Labels Milestones

New Issue

ArcGIS Online Monitoring on ArcGIS Enterprise #100

Open

opened 3 years ago by rbsetiawan · 0 comments

rbsetiawan commented 3 years ago

Owner

diagram

Description

• database platform : SQL Server 2017

  • url : database.gisportal.id
  • owner : arcgis
  • Database name: db_argol

• tabel :

  • accounts

    • create table

    CREATE TABLE accounts (
        id int IDENTITY(1,1) PRIMARY KEY,
        uername varchar(255),
        role varchar(255),
        license_level varchar(255),
        last_login DATETIME
    );
    
    

    • insert into:

    
    INSERT INTO [dbo].[accounts]
    ([uername]
    ,[role]
    ,[license_level]
    ,[last_login])
    VALUES
    ('ataufik','org_admin',2,'2023-08-02'),
    ('geonetinfo02','Contribution Edit',2,'2023-08-02'),
    ('jfirdaus','Organizer and Publisher',2,'2023-08-02'),
    ('vidya_aa','Organizer and Publisher',2,'2023-07-31'),
    ('geonetinfo01','Data Editor',2,'2023-07-31'),
    ('geonetinfo03','Organizer and Publisher',2,'2023-07-25'),
    ('dpradana','org_admin',2,'2023-06-21'),
    ('trachman_geonetinfo7','Organizer and Publisher',2,'2023-05-29'),
    ('rbsetiawan','Viewer',2,'2023-03-01'),
    ('geonetusr01','Viewer',11,'2023-02-08'),
    ('iaditya_geonetinfo','org_admin',2,'2023-02-08'),
    ('geonetusr02','Viewer',11,'2023-02-03'),
    ('rizqamaulana08','Contribution Edit',2,'2023-01-26'),
    ('mfajri24','org_publisher',2,'2023-01-24'),
    ('geonetusr03','org_admin',2,'2023-01-24'),
    ('Bappedalitbang','org_admin',2,'2023-01-10'),
    ('umargeonet','org_publisher',2,'2022-09-01'),
    ('khairuddin_ctf','org_admin',2,'2022-04-14'),
    ('demostm8','STM Viewer',2,'2022-03-31'),
    ('lhakim24','org_admin',2,'2021-08-12')
    

    • alter or change column data type

    ALTER TABLE accounts
    ALTER COLUMN license_level int;
    

    • alter or change column name

    sp_rename 'accounts.uername', 'username', 'COLUMN';
    

  • item_details

    • create table

    CREATE TABLE item_details (
        id int IDENTITY(1,1) PRIMARY KEY,
        owner varchar(255) ,
        items_id varchar(255) ,
        title varchar(255) ,
        type varchar(255) ,
        size_kb_default int,
        unix_timestamp varchar(255) ,
        source varchar(255) ,
        portal_url varchar(255) ,
        size_kb int,
        date_update DATETIME,
        command varchar(255) 
    );
    

    • insert into

        INSERT INTO [dbo].[item_details] ([owner] ,[items_id] ,[title] ,[type] ,[size_kb_default] ,[unix_timestamp] ,[source] ,[portal_url] ,[size_kb] ,[date_update] ,[command]) VALUES
    
    
        ('ataufik','dd548454b1a8430f8b64d2d888312346','Survey Musrenbang Tahun Anggaran 2018 Bappeda Kabupaten Bogor','Web Mapping Application',460504,'1521687107','https://giskabbogor.maps.arcgis.com/apps/Cascade/index.html?appid=dd548454b1a8430f8b64d2d888312346','https://geonetinfo.maps.arcgis.com/home/item.html?id=dd548454b1a8430f8b64d2d888312346',449711,'2018-03-22',''),
        ('ataufik','ffbf04228c6e47bfa6f98dd262741db7','Anchor Pattern Navigation','Web Map',12350,'1578988633','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=ffbf04228c6e47bfa6f98dd262741db7',12061,'2020-01-14',''),
        ('ataufik','75ac694405e742bfa09007dadf367f9d','aaa','Web Mapping Application',2974,'1657096352','https://geonetinfo.maps.arcgis.com/apps/webappviewer/index.html?id=75ac694405e742bfa09007dadf367f9d','https://geonetinfo.maps.arcgis.com/home/item.html?id=75ac694405e742bfa09007dadf367f9d',2904,'2022-07-06',''),
        ('ataufik','9193f8cbf0d042ad812406f1669bc08b','Map Image For FieldMap by fajri','Web Map',1453,'1654576582','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=9193f8cbf0d042ad812406f1669bc08b',1419,'2023-09-25','delete'),
        ('ataufik','e1b12dc6b0b4475bbaf7ecc9f0312187','WebMapWGS84','Web Map',17671,'1658194485','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=e1b12dc6b0b4475bbaf7ecc9f0312187',17257,'2022-07-19',''),
    
    
    </details>
    
    
    

  • log item

    • create table

    CREATE TABLE log_item (
        id int IDENTITY(1,1) PRIMARY KEY,
        items_id varchar(255) ,
        date_update DATETIME
    );   
    

    • insert into log item

    insert into log_item (items_id) values
    ('1241c78657d04c0f83a98a7671d42ee3'),
    ('f872ae5880274c30b040ec8a88021462'),
    ('c54aabeedf9f4401a6afdd5cd79aa97b'),
    ('f877b4932775483dbf9572ee36eb85e7'),
    ('b4fd7bb853fa40408ee183fd5744088f'),
    ('86082fcca42a4f86a159f38adc4739a7'),
    ('01aa8320920c4c7c906e193c09d5a1ab'),
    ('b509c98a407c42ee8213db49d53c6855'),
    ('8a16272c9b6e45a4968c7196a80ae4f6'),
    ('065779b778b048ec9ecf14325a366eec')
    

  • view item resume

    • create view

    create view item_resume as
    select username, role, license_level,
    case
        when dty.items is null then 0
        else dty.items
    end items,
    
    case
        when dty.size_kb is null then 0
        else dty.size_kb
    end size_kb
    from accounts dtx
    left join 
    ( select 
        owner,
        count(size) as items,
        sum(cast(size as bigint)) as size_kb
    
        from 
        (select owner, items_id, 
        case
        when compare_items is null then null
        else size_kb
        end as size
        --compare_items, 
        --size_kb 
    
        from 
            (select a.owner
            ,a.items_id
            ,b.items_id as compare_items
            --,count(cast(a.size_kb as bigint)) as items
            --,sum(cast(a.size_kb as bigint)) as size_kb
            ,a.size_kb
            from item_details a
            left join log_item b on a.items_id = b.items_id
            --left join accounts c on a.owner = c.username
            ) dta ) dtb
    
            group by owner ) dty on dtx.username = dty.owner
    
    
    

  • view item_details_current_v

    • create view

    
    create view item_details_current_v as
    select 
    id.id,
    id.owner,
    id.items_id,
    id.title,
    id.type,
    id.size_kb_default,
    id.unix_timestamp,
    id.source,
    id.portal_url,
    id.size_kb,
    id.date_update,
    id.command
    from item_details id inner join
    (select * from log_item li2 where format(date_update,'yyyy-MM-dd') = (select max(date_update) from (select format(date_update,'yyyy-MM-dd') as date_update from log_item li group by format(date_update,'yyyy-MM-dd') ) li0)) li1
    on id.items_id = li1.items_id
    
    
    

    
     </details>
    
    
    

  • view item

    • create view

    
     </details>
    
    
    
    

• Feature Service

  • Portal for ArcGIS Items :
    https://development.gisportal.id/portal/home/item.html?id=d86791bfd19142cb885d0ee1bf121527#overview

  • ArcGIS Server Service :
    https://development.gisportal.id/server/rest/services/Umar/Test_Mas_Rian/FeatureServer

• create Feature Service

  • ArcGIS Pro

    • Open ArcGIS Pro
    • Connecto to Portal for ArcGIS
    • add new map
      
    • add database connection
      
      
    • Expand database connection
      

  • add balnk feature include coordinate

    • add new feature class
      
      
      
      
      
      
      

    • finish feature class
      

  • drak or add items (feature class and tabular table to project)

    • feature class
    • add tabular table
    • accounts
    • item_details
      
• Publish Feature Service

  • ArcGIS Pro

    • Share > Web Layer > Publish Web Layer
      
    • descripsion feature and allow or enable Feature
      
      
      
    • Analyze
      
      
    • re Analyze and publish
      
    • finish publish
      

  • Porta for ArcGIS
    

    • Feature Service https://development.gisportal.id/portal/home/item.html?id=5bb68b0ce38c4bc6a380edbdd1af2835
    • Map Image https://development.gisportal.id/portal/home/item.html?id=23deee3b0f0145de9ff5cbf39a613239

  • ArcGIS Server
    

    • Rest Service https://development.gisportal.id/server/rest/services/main/ArcGIS_Monitoring/MapServer

# diagram  # Description - database platform : SQL Server 2017 - url : database.gisportal.id - owner : arcgis - Database name: db_argol - tabel : - <details> <summary>accounts</summary> - create table ``` CREATE TABLE accounts ( id int IDENTITY(1,1) PRIMARY KEY, uername varchar(255), role varchar(255), license_level varchar(255), last_login DATETIME ); ``` - insert into: ``` INSERT INTO [dbo].[accounts] ([uername] ,[role] ,[license_level] ,[last_login]) VALUES ('ataufik','org_admin',2,'2023-08-02'), ('geonetinfo02','Contribution Edit',2,'2023-08-02'), ('jfirdaus','Organizer and Publisher',2,'2023-08-02'), ('vidya_aa','Organizer and Publisher',2,'2023-07-31'), ('geonetinfo01','Data Editor',2,'2023-07-31'), ('geonetinfo03','Organizer and Publisher',2,'2023-07-25'), ('dpradana','org_admin',2,'2023-06-21'), ('trachman_geonetinfo7','Organizer and Publisher',2,'2023-05-29'), ('rbsetiawan','Viewer',2,'2023-03-01'), ('geonetusr01','Viewer',11,'2023-02-08'), ('iaditya_geonetinfo','org_admin',2,'2023-02-08'), ('geonetusr02','Viewer',11,'2023-02-03'), ('rizqamaulana08','Contribution Edit',2,'2023-01-26'), ('mfajri24','org_publisher',2,'2023-01-24'), ('geonetusr03','org_admin',2,'2023-01-24'), ('Bappedalitbang','org_admin',2,'2023-01-10'), ('umargeonet','org_publisher',2,'2022-09-01'), ('khairuddin_ctf','org_admin',2,'2022-04-14'), ('demostm8','STM Viewer',2,'2022-03-31'), ('lhakim24','org_admin',2,'2021-08-12') ``` - alter or change column data type ``` ALTER TABLE accounts ALTER COLUMN license_level int; ``` - alter or change column name ``` sp_rename 'accounts.uername', 'username', 'COLUMN'; ``` </details> - <details> <summary>item_details</summary> - create table ``` CREATE TABLE item_details ( id int IDENTITY(1,1) PRIMARY KEY, owner varchar(255) , items_id varchar(255) , title varchar(255) , type varchar(255) , size_kb_default int, unix_timestamp varchar(255) , source varchar(255) , portal_url varchar(255) , size_kb int, date_update DATETIME, command varchar(255) ); ``` - insert into ``` INSERT INTO [dbo].[item_details] ([owner] ,[items_id] ,[title] ,[type] ,[size_kb_default] ,[unix_timestamp] ,[source] ,[portal_url] ,[size_kb] ,[date_update] ,[command]) VALUES ('ataufik','dd548454b1a8430f8b64d2d888312346','Survey Musrenbang Tahun Anggaran 2018 Bappeda Kabupaten Bogor','Web Mapping Application',460504,'1521687107','https://giskabbogor.maps.arcgis.com/apps/Cascade/index.html?appid=dd548454b1a8430f8b64d2d888312346','https://geonetinfo.maps.arcgis.com/home/item.html?id=dd548454b1a8430f8b64d2d888312346',449711,'2018-03-22',''), ('ataufik','ffbf04228c6e47bfa6f98dd262741db7','Anchor Pattern Navigation','Web Map',12350,'1578988633','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=ffbf04228c6e47bfa6f98dd262741db7',12061,'2020-01-14',''), ('ataufik','75ac694405e742bfa09007dadf367f9d','aaa','Web Mapping Application',2974,'1657096352','https://geonetinfo.maps.arcgis.com/apps/webappviewer/index.html?id=75ac694405e742bfa09007dadf367f9d','https://geonetinfo.maps.arcgis.com/home/item.html?id=75ac694405e742bfa09007dadf367f9d',2904,'2022-07-06',''), ('ataufik','9193f8cbf0d042ad812406f1669bc08b','Map Image For FieldMap by fajri','Web Map',1453,'1654576582','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=9193f8cbf0d042ad812406f1669bc08b',1419,'2023-09-25','delete'), ('ataufik','e1b12dc6b0b4475bbaf7ecc9f0312187','WebMapWGS84','Web Map',17671,'1658194485','None','https://geonetinfo.maps.arcgis.com/home/item.html?id=e1b12dc6b0b4475bbaf7ecc9f0312187',17257,'2022-07-19',''), </details> - <details> <summary>log item</summary> - create table ``` CREATE TABLE log_item ( id int IDENTITY(1,1) PRIMARY KEY, items_id varchar(255) , date_update DATETIME ); ``` - insert into log item ``` insert into log_item (items_id) values ('1241c78657d04c0f83a98a7671d42ee3'), ('f872ae5880274c30b040ec8a88021462'), ('c54aabeedf9f4401a6afdd5cd79aa97b'), ('f877b4932775483dbf9572ee36eb85e7'), ('b4fd7bb853fa40408ee183fd5744088f'), ('86082fcca42a4f86a159f38adc4739a7'), ('01aa8320920c4c7c906e193c09d5a1ab'), ('b509c98a407c42ee8213db49d53c6855'), ('8a16272c9b6e45a4968c7196a80ae4f6'), ('065779b778b048ec9ecf14325a366eec') ``` </details> - <details> <summary>view item resume</summary> - create view ``` create view item_resume as select username, role, license_level, case when dty.items is null then 0 else dty.items end items, case when dty.size_kb is null then 0 else dty.size_kb end size_kb from accounts dtx left join ( select owner, count(size) as items, sum(cast(size as bigint)) as size_kb from (select owner, items_id, case when compare_items is null then null else size_kb end as size --compare_items, --size_kb from (select a.owner ,a.items_id ,b.items_id as compare_items --,count(cast(a.size_kb as bigint)) as items --,sum(cast(a.size_kb as bigint)) as size_kb ,a.size_kb from item_details a left join log_item b on a.items_id = b.items_id --left join accounts c on a.owner = c.username ) dta ) dtb group by owner ) dty on dtx.username = dty.owner ``` </details> - <details> <summary>view item_details_current_v</summary> - create view ``` create view item_details_current_v as select id.id, id.owner, id.items_id, id.title, id.type, id.size_kb_default, id.unix_timestamp, id.source, id.portal_url, id.size_kb, id.date_update, id.command from item_details id inner join (select * from log_item li2 where format(date_update,'yyyy-MM-dd') = (select max(date_update) from (select format(date_update,'yyyy-MM-dd') as date_update from log_item li group by format(date_update,'yyyy-MM-dd') ) li0)) li1 on id.items_id = li1.items_id ``` </details> - <details> <summary>view item</summary> - create view ``` ``` </details> - <details> <summary>Feature Service</summary> - Portal for ArcGIS Items : https://development.gisportal.id/portal/home/item.html?id=d86791bfd19142cb885d0ee1bf121527#overview - ArcGIS Server Service : https://development.gisportal.id/server/rest/services/Umar/Test_Mas_Rian/FeatureServer </details> - <details> <summary>create Feature Service</summary> - ArcGIS Pro - Open ArcGIS Pro - Connecto to Portal for ArcGIS - add new map  - add database connection   - Expand database connection  - add balnk feature include coordinate - add new feature class        - finish feature class  - drak or add items (feature class and tabular table to project) - feature class - add tabular table - accounts - item_details  </details> - <details> <summary>Publish Feature Service</summary> - ArcGIS Pro - Share > Web Layer > Publish Web Layer  - descripsion feature and allow or enable Feature    - Analyze   - re Analyze and publish  - finish publish  - Porta for ArcGIS  - Feature Service https://development.gisportal.id/portal/home/item.html?id=5bb68b0ce38c4bc6a380edbdd1af2835 - Map Image https://development.gisportal.id/portal/home/item.html?id=23deee3b0f0145de9ff5cbf39a613239 - ArcGIS Server  - Rest Service https://development.gisportal.id/server/rest/services/main/ArcGIS_Monitoring/MapServer </details>

image.png

555 KiB

image.png

320 KiB

image.png

293 KiB

image.png

625 KiB

image.png

443 KiB

image.png

222 KiB

image.png

161 KiB

image.png

92 KiB

image.png

151 KiB

image.png

126 KiB

image.png

160 KiB

image.png

139 KiB

image.png

123 KiB

image.png

950 KiB

image.png

356 KiB

image.png

127 KiB

image.png

144 KiB

image.png

341 KiB

image.png

525 KiB

image.png

176 KiB

image.png

166 KiB

image.png

373 KiB

image.png

398 KiB

image.png

146 KiB

rbsetiawan added the

RND

ArcGIS Online

labels 3 years ago

rbsetiawan self-assigned this 3 years ago

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

master

Labels

Apply labels

Clear labels

ArcGIS Desktop ArcGIS Enterprise ArcGIS Monitor ArcGIS Notebook Server ArcGIS Online ArcGIS Pro Bugs CarryMap Builder data store Error geoanalytics geoevent imageserver Issue Portal rasteranalytics RND server Solvent SQL Server
database Workflow manager server

No Label ArcGIS Desktop ArcGIS Enterprise ArcGIS Monitor ArcGIS Notebook Server ArcGIS Online ArcGIS Pro Bugs CarryMap Builder data store Error geoanalytics geoevent imageserver Issue Portal rasteranalytics RND server Solvent SQL Server Workflow manager server

Milestone

Set milestone

Clear milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Assign users

Clear assignees

No Assignees

rbsetiawan

1 Participants

Notifications

Subscribe

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview

Loading…

Cancel

Save

There is no content yet.