ArcGIS GeoBIM

Generating GeoBIM Schedule Polygons Using ArcGIS Pro

The GeoBIM schedule feature layer is a polygon layer based on the bounding area of the related features by schedule id. This provides a visual representation of the work being done on a schedule activity. The following workflow may not match your environment exactly but should provide a framework for the steps that need to be done to integrate your schedule data and related features with ArcGIS GeoBIM. 

 

Start with the End in Mind

The goal is to create a series of polygons that wrap around all asset features for each schedule activity. One or more feature layers (that are assigned an ID that matches the schedule data) can represent the assets and activities for the schedule task. The shape and style of the final polygons can be adjusted to fit the needs of the project, but a convex hull is a good starting point to create the smallest polygon to include all features. Knowing how the schedule polygons will be used can inform the style of polygon aggregation used in the first step. 

An overview of the process is: 

  1. Export your schedule data to a CSV format with a primary ID that can be related to the asset layers used to create the polygons
  2. Create polygons around features with the same schedule primary ID 
  3. Merge the polygons with the same ID into a single polygon if using more than one feature layer 
  4. Merge the schedule data with the Polygons by ID Append/overwrite GeoBIM schedule layer 
  5. Update time extent for Schedules layer

In this example, I am using ModelBuilder in ArcGIS Pro to automate the process. If you’re not sure how to create your own model builder workflow see the ModelBuilder quick tour to get started. 

Getting Started

In this example we have 2 layers, Spans and Structures that represent power lines and towers, respectively. The Spans are lines and the Structures are points; you do not have to start with polygon features. All features in both layers are assigned a schedule ID value that matches the schedule data. 

The other element needed is the schedule data itself. One of the easiest ways to incorporate schedule data is to export it to a .csv file. The exported data must include the schedule ID value that matches the attributes assigned to the related features as well as any other fields to be displayed in GeoBIM. The process to export the data to csv format will depend on the application used for the schedule. Follow the application’s best practices for exporting the data to a csv formatted file. 

These elements are required to use this process. 

Structures: 

Schedule Structures

Spans:

Schedule Spans

Create (Convex Hull) Polygons for Feature Layers

This example is using a convex hull around the features, but it is up to you which style of polygon aggregation to create. I am using the Minimum Bounding Geometry (MBG) tool in ArcGIS pro. Within that tool there are other polygon styles that can be used such as envelope or circle.

This is the section of the model that will create the polygons.

Convex Hulls

Geometry Types for Minimum Bounding Geometry:

Convex Hulls Illustration

The MBG tool only accepts a single feature layer as the input so it will need to be run for each feature layer. In addition to the geometry type configuration, make sure the group operation is set to List and the schedule ID field is selected for the grouping. This will create a polygon, which is a convex hull in this example, around the features that have the same schedule ID assigned. Once the MBGs are created, a simple merge and dissolve, based on the schedule ID field operation, will join them into a master polygon containing all features based on the schedule ID.

Spans:

Schedule Spans 2

Structures:

Schedule Structures 2

Merged and Dissolved:

Merged and Dissolved

Join Schedule Data and Polygons

Now that we have our schedule data in .csv and a polygon layer wrapping around all features for each schedule activity, they can be joined. In this case I am using the Join Field tool in ArcGIS Pro to add the schedule fields to the polygon layer and populate the data. This requires using the Transfer Fields capability in the Join Field tool. Make sure to add all fields to the list that you want included in the final GeoBIM layer.

This section of the model performs the join between schedule data and polygons.

Join Schedule Data and Polygons
Schedule table

 

Append Polygons and Data to GeoBIM

GeoBIM creates a Schedule layer automatically when a project is created with common fields for schedules. The Schedule layer needs to be updated manually if changes are needed, including adding more fields. Any standard method of appending/updating ArcGIS Online hosted feature layers will work, in this example I am using the Append tool in ArcGIS Pro model builder to automate the process.

This section of the model uses the combined polygon and schedule data to update the GeoBIM schedule layer in the GeoBIM project.

Append Polygons and Data to GeoBIM

GeoBIM Schedule Layer:

GeoBIM Schedule Layer

Update Time Extent for Schedules layer 

After the append is complete in ArcGIS Pro, update the Schedules layer time extents by opening the time settings in ArcGIS Online and clicking ok 

Update time extent for Schedules layer

Wrapping it all up

Whether you have a single feature layer or multiple layers of different geometry types, the workflow is still the same: create polygons around features by schedule ID, merge them all together, add the schedule data, then update the GeoBIM schedules layer. This creates a visual representation of the temporal nature of your features/assets based on your schedule.

The same workflow can be accomplished by running the Geoprocessing tools manually, creating your own model builder, using Python, or using the data interoperability tools. If you want to make regular updates to the schedule layer, an automated tool based on your data will be the most efficient process.

To learn more about generating ArcGIS GeoBIM Schedule polygons using ArcGIS Pro features, ask the ArcGIS GeoBIM team here.

About the authors

Aaron Cheuvront

Aaron Cheuvront is a Product Engineer on the ArcGIS GeoBIM Team. He joined Esri in 2021 with a background in system administration, design, and development of an indoor GIS platform at a large US university for almost 20 years.

Kachy Nwobi

Kachy Nwobi is a Product Engineer on the ArcGIS GeoBIM team. She joined Esri in 2020 and her primary roles are product documentation and testing. She has a Master's degree in Geospatial Technology for Geodesign from Thomas Jefferson University and a Bachelor's degree in Environmental Engineering from Drexel University. She currently lives in Washington DC.

Connect:
0 Comments
Inline Feedbacks
View all comments

Next Article

App Builders at the 2022 Esri User Conference

Read this article