Please register for a free, but registration required AASHTO Geospatial Online Transportation User Group (GOTUG) Webinar:
Handling Data for GIS, December 2, 2020 at 1:00 PM ET at:
Join us for three GIS Online presentations on handling Data:
Mapping DOT Projects and Highway Inventory Data – An ETL Epic Journey
The Louisiana Department of Transportation and Development has a lot of data. As part of the Department’s System of Engagement project, DOTD and ESRI have embarked on a quest to eliminate silos and turn data into information. To do this, a centralized database repository was created. ETL tools have been deployed to extract data from Systems of Record, translate to a common schema, enrich the data to meet different needs, and load into the SoE database repositories to serve out as web services for desktop/web maps and apps as well as Open Data sites (two sites) for consumption.
Modeling MIRE Data Using NoSQL
NoSQL graph‐based databases are widely used in social media applications, such as Facebook and LinkedIn. But they are underutilized in the GIS industry. We will discuss how a NoSQL graph‐based database can simplify complex data modeling of real world features by storing all of the information about intersections at the node level. We will provide an overview of how DDOT (District Department of Transportation, Washington DC) and the AppGeo team leveraged the existing DDOT Linear Referencing System (LRS) based on Esri’s Roads & Highways, to develop the workflow and processing scripts to migrate this data into a NoSQL graph database (ArangoDB), and discuss how the team developed web services, safety data visualizations, interactive queries, and a web application for viewing cross‐sections.
Tracking Oklahoma’s County Certified Mileage
For ODOT to remain compliant with both State Tax Law and ARNOLD requirements, the Inventory Management Branch uses a combination of Mobile Data Collection, Interagency Cooperation, and a strong web presence to stay accurate and up to date. Utilizing ESRI’s Collector App and ArcGIS Online allows us to collaborate with Field Personnel and County Staff in real time to update new roads and get them their funds quicker than before.
After registering, you will receive a confirmation email containing information about joining the webinar.