Scenarios doing GIS QA
Last updated
Last updated
If you encounter a work order with NO Spec and No materials used, the GIS QA person will simply input the Segment ID to track the Work Order location. No GIS assets need to be created/modified.
If you encounter a work order where only LONG LINE work was performed, the GIS QA person will simply input the Segment ID of any work where long line was installed/maintained. This will be used to calculate the linear miles of work. No GIS assets need to be created/modified.
If no plans are attached, you may use:
The extents from the Location field, or
The number of footage materials that technicians input to estimate how much LONG LINE was installed
In the Data Tracker extents are stated from the location field
In the above example, the GIS QA person would select all segment IDs in Millwright Pkwy between Lake Creek Pkwy and Anderson Mill Rd.
In ArcGIS Pro you can use the Measure tool to determine what segment IDs the work order uses based on how much material the work order required. A double yellow centerline consists of 2 parallel stripes which means the footage used in materials means that the linear footage is ½ the amount. Bike lanes on both Eastbound/Westbound or Northbound/Southbound
Installed/Maintained
If you encounter a work order where SHORT LINE work was done, the GIS QA person will have to:
Add a date record if the short line record already exists GIS, or
Create the Short Line/Specialty Marking/Specialty Line feature in GIS and add the date record
In this example I created the short line GIS features selected the crosswalks/short line that need a Work Order ID. I also had to update the crosswalk NUMBER_OF_ASSETS field to the number of continental bars listed in the Specifications table.
Removed
If you encounter a work order where a markings short line/specialty line/specialty marking asset was removed, the person will follow a similar process to creating new date records for installed/removed assets. The following would be changed:
LOCATION_STATUS: Would change from “Active” to “Removed”
A new date record would be created: Set WORK_TYPE to “Removed” and fill out rest of date record such as Work Order ID, and whether work was done In-House or Contractor
If you encounter a work order where SMD performed planned maintenance, all markings with the associated work order need work dates. You may look at the attached plan to see which assets need maintenance and look at the Specifications/Materials tables to see which assets need date records.
In this example, it shows that bike arrows, man on bike, and arrow specialty markings have been refreshed.
The segment IDs are already listed, and the attached plans only show aerial imagery for markings technicians to refresh markings based on visual inspection.
From the segment IDs and the materials, we can select markings assets that are bike arrows, turn arrows, man on bike assets, straight arrows, and only word (second page of material table) markings.
There might be a work order that has complex engineering plans for the installation of pavement markings. Most of them would be found from ATSD (Active Transportation) or Transportation Engineering requester. Complex engineering plans are typically CAD drawings around 4-20 pages in the attached PDF with roadway markings and raised pavement markings that require fresh new installation of markings.
In encountering complex engineering plans for the work order, the best course of action is to:
Breakdown the plans into three categories based on GIS
Specialty_points: What specialty markings were installed?
Specialty_lines: What delineators/curbs/concrete domes/wheel stops were installed?
Short_line: What short line markings were installed (crosswalks/stop bars/yield lines)?
Have a second browser window or PDF viewer window open to look at the CAD engineering plans
Starting from the first page, use ArcGIS Pro to create features based on the three categories above
Start creating features for one category from the beginning to the end of the engineering plans
Work Order Example
You encounter a work order engineering plan that spans 13 pages of a long stretch of road. On those plans it shows delineators, concrete domes, bike arrows, bicyclists symbols, chevrons, green pads, crosswalks, stop bars, word symbols, turn arrows, and new long line.
Create GIS features for specialty points (bike arrows/bicyclists symbols/turn arrows/word symbols) starting from page 1 to page 13. After the GIS features are created, save edits. Add date records of the work order ID and that the work type was installed
Create GIS features for short line (crosswalks/stop bars) starting from page 1 to page 13. After the GIS features are created, save edits. Add date records of the work order ID and that the work type was installed
Create GIS features for specialty line (delineators/concrete domes) starting from page 1 to page 13. After the GIS features are created, save edits. Add date records of the work order ID and that the work type was installed
Usually the Instructions would specify to install roadway markings according to the attached plans from the requesters. Work orders that have attached complex engineering plans will be what is used to reference markings installed because using materials/specifications tables in this scenario would be hard to verify and check. In general, technicians will follow the engineering plans for installation markings unless stated otherwise.
ArcGIS Pro and Engineering Plan Example
Below is an example screenshot of creating specialty point assets in ArcGIS Pro:
These points were created by looking at the attached plans in the work order:
We would break up the creation of GIS assets into the three categories to save edits through the GIS QA process (versus saving edits between three different layers all at once). It is also easier to keep track of how many pages have been done for GIS QA.
