Data Sharing with No Delays

At the Texas Department of Transportation, ArcGIS Pro and ArcGIS Open Data Pave the Way for Smooth Workflows

It's not a cure-all for Texas traffic, but the state's department of transportation, TxDOT, eases two major pains with ArcGIS Pro and ArcGIS Open Data: data publishing and data requests.

With ArcGIS Open Data, the public can see planned department of transportation projects, traffic volumes, and congested roadways in Dallas and throughout the state.

With ArcGIS Open Data, the public can see planned department of transportation projects, traffic volumes, and congested roadways in Dallas and throughout the state.

Chris Bardash, a TxDOT GIS analyst, used ArcGIS Pro to implement a single project that can publish services for the entire organization. This allows TxDOT to easily share its data both internally and externally via ArcGIS Online and its ArcGIS Open Data site. On the whole, the solution cuts the time it takes to publish data and reduces the number of data requests that TxDOT's data management team has to process manually.

Automating Service Updates

Prior to implementing ArcGIS Pro, TxDOT was juggling too many distinct datasets and services. The two-person GIS team had built a custom web mapping app for statewide planning using ArcGIS API for JavaScript. But Bardash and his colleague, Adam Breznicky, knew that because of the mutable nature of planning projects—with changes in project locations, marker positions, speed limits, and the like—the services for the map would need to be updated on a regular basis.

Initially, they had created a single map document for each service—that is, one map for every service—so there were approximately 40 map documents sitting in a folder.

"Then we realized we could use the map tabs within ArcGIS Pro to contain all the [map documents] in a single product," recalled Bardash.

So they started by building an ArcGIS Pro project to import all the map documents. Now, there is a single ArcGIS Pro project on a network drive that anyone in the data management section of TxDOT can access. Additionally, all the data is sourced on an enterprise database, so users can just open the ArcGIS Pro project and it's already connected to the data.

"Any time you need to update services, you open the project and go to the map tab for that service," explained Bardash. "Everything is already symbolized and connected to the data source. You just click overwrite to [edit] the service in ArcGIS Online."

By automating some manual steps, such as removing extraneous fields, ArcGIS Pro performs the quality control that has to be conducted before publishing a service.

"We want to clean up some fields before we publish them," said Bardash. "In some cases, we might delete certain fields."

The Texas Department of Transportation (TxDOT) implemented an ArcGIS Open Data site, which anyone can use to download information on the work the department is doing.

The Texas Department of Transportation (TxDOT) implemented an ArcGIS Open Data site, which anyone can use to download information on the work the department is doing.

So the team wrote a Python script that can check to see if the service has any of the fields that need to be deleted.

"We couldn't write a script specific to each layer, so we wrote a script that searched for any fields in a list of about ten of them," explained Bardash.

When a user activates that ArcGIS Pro task (a set of preconfigured steps that guide someone through a workflow), the delete fields script gets triggered automatically. From there, the user overwrites the service and reviews the item details page in ArcGIS Online to make any final adjustments, such as removing underscores from the item names and changing settings, like optimizing layer drawing, that aren't available to set when publishing.

"In the past, this would have been a part of our standard operating procedure that someone would have to remember to do," said Bardash. "Now, the task just walks you through it."

Sharing Data Externally

To help with transparency, TxDOT has also implemented an ArcGIS Open Data site.

"People can visualize the work we are doing—planned projects, traffic volumes, congested roadways, classifications for each road, [and] asset locations," said Bardash. "Our entire inventory of things like that is out there for people to consume. They can download it or use it in their own web apps."

To reduce the time it took to handle the number of labor-intensive data requests the department received, TxDOT was looking for a solution to share data externally.

"We were preparing to build our own site when our Esri contacts informed us about the out-of-the-box ArcGIS Open Data solution available to us for free as part of our Esri account," recalled Bardash.

With very little preparation, Bardash and Breznicky were able to quickly stand up an open data site. From there, it could share the services it had already prepared and made available in ArcGIS Online.

"It did not require any purchases and needed very little configuration," said Bardash. "Basically, we added our branding to the site, set our services to be available on the open data portal, and published it."

Now, if consultants working on a TxDOT project need to get ahold of official highway data to put on a map, the data management section no longer has to find the data and send the specialists a zipped geodatabase file. Instead, the team can give them a link to TxDOT's open data portal, and the consultants can find the data themselves.

"ArcGIS Pro makes it easier for us to get that data out there faster and ensure a certain level of quality," Bardash conveyed. "With any given data request, [we] can save the minutes or hours it takes to assemble all that data, depending on the request."

Learn more about ArcGIS Pro, and find out how to implement an out-of-the-box ArcGIS Open Data site.