![Page 1: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/1.jpg)
Data Collectionand Quality Assurance
Ron Howard Jr., EI
Environmental Coordinator
Russell Koenig, PS, EISurveyor
DLZ Ohio, Inc.2008 Ohio GIS
Conference
September 10-12, 2008
Crowne Plaza North Hotel
Columbus, Ohio
![Page 2: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/2.jpg)
QUALITY ASSURANCE
Refers to planned and systematic processes that
provide confidence of a product’s or service’s
effectiveness.
![Page 3: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/3.jpg)
Original
Hand Written
Document.
Drawbacks
• Difficult to read
• Not structured
• Must be retyped
• Open to interpretation
![Page 4: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/4.jpg)
Palm Database Document
Benefits• Standardized
responses.
• Easy sorting and manipulation of data.
• Provide client with a document designed around their changing needs.
![Page 5: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/5.jpg)
Palm Database Document
Benefits cont.• Check
boxes and drop down menus save time.
• Once entered document is complete.
• Greater quality final product.
![Page 6: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/6.jpg)
Palm Database Document
Drawbacks• Special
Training.
• Greater learning curve for users.
• Field crew’s level of detail is visibly displayed whether good or bad.
![Page 7: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/7.jpg)
![Page 8: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/8.jpg)
![Page 9: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/9.jpg)
Hours / Job Palm Hand Written Position Hourly RateField Work 267 481 Field Tech 21.00$ Retyping hand written forms 240 Administrative assistant 16.00$ Inserting forms into books 40 Intern 12.00$ Database development 40 Programmer 35.00$
Palm Hand Written SavingsTotal Hours 307 761 60%Total Cost 7,007$ 14,419$ 51%
Comparison and Savings between Electronic and Hand Written Data
Collection.Parcels / Day Palm Hand WrittenField Work 45 25Retyping hand written forms 0 50Inserting forms into books 0 300
Total Parcels
1502
![Page 10: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/10.jpg)
Related Benefits1. Less people handling information relates to a higher quality product.2. Realistic deliverable 1 cd -vs- 13 3-inch binders3. Ability to sort specific information due to standardized inputs.4. Ability to generate reports relative to each client's particular need.5. Ability to attach a photo with pertinent data.6. Improved ability to check work for accuracy.7. Database development was more extensive in this case because it was our 1st project.8. Newer databases need approx 50% less work.
Note: Now that the client has increased ability to work with the data they will ask for extra database items. Therefore, don't reduce programmer time.
![Page 11: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/11.jpg)
Brain power has to rise in proportion to the reduction in time, operational effort, and
muscle power.Joseph V.R. Paiva, PH.D., P.S.
![Page 12: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/12.jpg)
Case Study: I-70/71
Existing Utility Location– Subsurface Utility Engineering (SUE)– Sewerage/Drainage
![Page 13: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/13.jpg)
Project Approach
Combine Survey
Data with GIS Data
Collection methods
to produce a final
product with
maximum quality in
minimal time.
![Page 14: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/14.jpg)
![Page 15: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/15.jpg)
707802.19, 1873544.62
987.12
70-71 MANHOLE INVENTORY
NAVD88
1000 STORM MH
![Page 16: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/16.jpg)
1
2
24” RCP
1000 STORM MH
8.10 1001
09-11-08
707802.19, 1873544.62 RH/RK
CONC
987.12
STEEL
GOOD
70-71 MANHOLE INVENTORY
NO
TRASH & SILT
24” RCP 8.42
NAVD88N
![Page 17: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/17.jpg)
24” NE RCP
1000 STORM MH
8.10 1001
DIR
09-11-08
707802.19, 1873544.62 RH/RK
CONC
987.12
STEEL
GOOD
70-71 MANHOLE INVENTORY
NO
TRASH & SILT
24” S RCP 8.42
NAVD881
2
N
![Page 18: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/18.jpg)
GIS Data Collection Advantages
• Upload coordinates for navigation• Customized drop-down menus• No lost, damaged, or illegible forms• Downloadable information
![Page 19: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/19.jpg)
GIS-Grade GPS
• Fast and effective– Navigation– Inventory
• Low accuracy– 30 feet un-processed– 1-3 feet post-processed
(using CORS)
![Page 20: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/20.jpg)
Survey-Grade GPS
• Static (~0.03’)– Must Post-Process
![Page 21: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/21.jpg)
Survey-Grade GPS
• Static (~0.03’)– Must Post-Process
• RTK (~0.10’)– Base Station
& Radio Waves– No Post-Processing
![Page 22: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/22.jpg)
Survey-Grade GPS
• Static (~0.03’)– Must Post-Process
• RTK (~0.10’)– Base Station
& Radio Waves– No Post-Processing
• VRS (~0.10’)– CORS Network– “On the fly” results
![Page 23: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/23.jpg)
Step 1: Survey
• Search for approximately 1900 structures– 770 located previously during SUE work
• Obtain accurate coordinates
![Page 24: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/24.jpg)
Step 2: Report• Structure details & condition• Pipe information
– Direction, size, material, depth, connection• GIS-Grade GPS coordinate
![Page 25: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/25.jpg)
• Sewer Database spreadsheet (Excel)– Survey coordinates and GIS report data
• Compare GIS and survey coordinates• Calculate pipe invert elevations
Step 3: Assemble
![Page 26: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/26.jpg)
Step 4: QC
• Database analysis– Identify missing or conflicting information
• Existing records– City of Columbus Sewer Atlas– Original construction and as-built drawings
• Additional field work– Stakeout, locate, and report missing
structures
![Page 27: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/27.jpg)
Step 5: Deliver• The final report included
– 1458 located structures– 3177 reported inverts
• Bound book– Database was easy to format
• Organized into 3 sections– Structure Location– Structure Information– Pipe Information
![Page 28: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/28.jpg)
Structure Location
![Page 29: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/29.jpg)
Structure Information
![Page 30: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/30.jpg)
Pipe Information
![Page 31: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/31.jpg)
Additional Request – Pipe Drawing
• Create invert coordinates• Place all start & stop points in order• Add point number & survey linework codes
– BL*P = Begin Line “Pipe”– EL*P = End Line “Pipe”
• Run through drafting software– Lines were automatic and at true elevation
![Page 32: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/32.jpg)
Pipe Point FilePOINT NORTHING EASTING ELEV
CODE
30000 711769.45 1827261.58 696.27BL*P1
30001 711778.66 1827277.52 696.27EL*P1
30002 711769.45 1827261.58 696.24BL*P2
30003 711778.29 1827093.73 695.56EL*P2
30004 711798.41 1827232.98 710.24BL*P3
30005 711792.29 1827244.84 709.55EL*P3
30006 711792.94 1827113.96 0.00BL*P4
30007 711792.29 1827244.84 708.36EL*P4
30008 711792.94 1827113.96 704.57BL*P5
30009 711787.09 1827114.39 704.45EL*P5
30010 711787.09 1827114.39 702.07BL*P6
30011 711786.62 1827092.33 701.14EL*P6
30012 711787.09 1827114.39 704.29BL*P7
30013 711424.05 1827187.41 703.43EL*P7
![Page 33: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/33.jpg)
![Page 34: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/34.jpg)
Highlights
• Minimal field time• Structure & report verification• Automated calculations• No transposing errors• Easily formatted report
![Page 35: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/35.jpg)
The Future• Innovative process and
experience– More jobs of this type at very
low cost• Enhanced Sewer Database
spreadsheet– Automated calculations and
error messages– Faster and better
![Page 36: Data Collection and Quality Assurance Ron Howard Jr., EI Environmental Coordinator Russell Koenig, PS, EI Surveyor DLZ Ohio, Inc. 2008 Ohio GIS Conference](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649e9f5503460f94ba163e/html5/thumbnails/36.jpg)
THANKS!
Ron Howard Jr., EI
Environmental Coordinator
Russell Koenig, PS, EISurveyor
DLZ Ohio, Inc.
6121 huntley Road
Columbus, Ohio 43229
614-888-0040