Keep your Data Flowing

0 of 5 lessons complete (0%)
Exit Course

Lesson 3: Building the Web Map

You don’t have access to this lesson

Please register or sign in to access the course content.

Publishing the Query Layers

Once the views are created we are going to add them as Query Layers to an ArcGIS Pro map and create the web map in ArcGIS Enterprise.

Note: Query Layers have some limitations on the SQL complexity they support, that is why we are saving them as views in the database and adding the view to the Pro map.

Add a select * query to the Query Layer window to view all rows and columns.

ArcGIS requires a unique identifier for query layers. For the all_jobs_last_48_hours view shown above we are using the job_id field. In the fme_nodes view we are generating an ID field utilizing the built in row_number() function. This ID has nothing to do with FME Cores or Engines and is only there to make ArcGIS happy.

Once both the query layers have been added, publish each table to ArcGIS Enterprise making sure to enable the “Feature” option in your sharing dialog.

Add Feature Layer to a Web Map

From your Portal content find the layers that you just created.

You will notice that you have two of them, a Map image layer and a Feature layer. You will be working with the Feature layer so that we can work with them in ArcGIS Dashboards.

  1. Add the Feature layer to a web map.
  2. Inside the map you will want to select each table and open the properties pane that appears on the right side.
  3. Expand the Refresh Interval settings and enable the setting by clicking the slider.
  4. Set the refresh layer to the desired interval. The lowest setting allowed for tables is 0.1, which is 6 seconds.
    1. A faster refresh interval means the dashboard feels closer to real-time, but hit your ArcGIS Server more often, consuming server resources. The interval may need adjusting for your platform.
  5. Repeat steps 2 – 4 for each table that you will be using in the dashboard.
  6. Save the web map.

Now that we have added the tables to a web map and configured the refresh settings, save your web map. We will be using it in the next lesson, Building the Dashboard.