350 likes | 653 Views
E N D
1. Larry SzarekPenn State UniversityMGIS ProgramCapstone Project Proposal Using a Utility Geodatabase to Store & Edit Drainage Plat Maps
2. Presentation Outline Objective
Background
Identification & Description of the Problem
Proposed Solution to the Problem
Process for Solving the Problem
Potential Obstacles
Project Timeline
Questions/Comments/Suggestion
3. Objective
4. Background
5. Background
6. Background
7. GIS at the Philadelphia Water Department Began in 1996
Orthophotography & Planimetrics (1996)
GIS Strategic Action Plan (2000)
Raster Imaging (2001)
Engineering Records Viewer (2002)
Data Conversion (2003 -2005)
Data maintenance & Application Development (Current)
8. Applications of GIS at PWD Sewer Assessment & Inspections
Document Management
Hydraulic Modeling
Storm water & Combined Sewer Overflow Modeling
Planning & Engineering
Preventative Maintenance
Tracing & Valve Isolation
Emergency Response
Work Order/Asset Management
Legacy Application Linking
9. GIS at PWD Enterprise GIS
ArcSDE 9.2
ArcGIS Server 9.2
ArcGIS Desktop 9.2
AutoDesk Mapguide 6.5
Water & Sewer Infrastructure Geodatabase
Geometric Network
120 Feature Classes
Over 1 million features
10. Identification & Description
11. Identification & Description of the Problem What is a drainage plat map?
Why are they important?
Issues involved with keeping them current
How can they be improved through the use of a Geodatabase
12. Philadelphia Water Department Drainage Plat Maps (History) Date back to the 1940’s when they were maintained as hand drawn linen maps.
Converted to Mylar sheets with a corresponding index map in the 1970’s
Converted to .tif files in 2001 and are now maintained digitally.
Full Sets are printed once a year and distributed throughout the department
4 Years ago the full set was georeferenced & rubbersheeted
13. Philadelphia Water Department Drainage Plat Maps (Specifications) Page Size: 44.5” X 34”
Actual Map Size: 42” X 24.5”
Title Block Size: 42” X 5.25”
Scale: 1” = 200’
123 Sheets to cover entire city
14. What does a Drainage Plat show? A rough plan view of the entire sewer system (storm, sanitary & combined)
Size, material, & grade for all sewers
Invert elevations for all manholes
Base map information (hydrology, streets, facilities, right of ways, railroads, etc.)
Street elevations
Descriptive annotation for specific parts and aspects of the system
Areas that are currently under construction
15. Philadelphia Water Department Drainage Plat Maps (Examples)
16. Philadelphia Water Department Drainage Plat Maps (Examples)
18. Drainage Plat Index Grid overlaid on top of city boundary
19. Issues Concerning These Maps Each change to the system is manually edited within the .tif file.
The base mapping is out of date and difficult to maintain
New sets are printed out once a year
They changes made are not georeferenced
They do not fit into our vision of an Enterprise GIS
20. Proposed Solution
21. How Using a Geodatabase Can Improve these maps Accuracy
Presentation
Maintenance
Analysis
-
-
22. Process
23. Process Identification of the Necessary GIS Datasets and Layers
Existing Layers
Wastewater & Stormwater Geometric Networks
Hydrology
PWD Facilities
Layers that will need to be created
Annotation Layer
Drainage Right of Ways
Layers that will need to be modified
Curblines
24. Choosing a Pilot Tile Criteria
Area that has all 3 types of sewer systems
Full tile
Relatively congested area
Contains at least 1 of the following:
PWD Facility
Drainage right of way
Body of water
Intercepting Chamber
Intercepting Sewer
Force Main
Pump Station
25. Process Creation of a Test Geodatabase
On Home Computer
Microsoft SQL Express
Personal ArcSDE
Full ArcSDE geodatabase capabilities for a few users and one editor at a time
26. Process Creation of an ArcGIS ArcMap Template
Proper Size
Title Block Area
Overview Map
Legend
Scale Bar
27. Process Creation of a Custom Symbol Set
ArcMap Style Manager
ArcMap Symbol Property Editor
28. Process Creation of Annotation
Use of Annotation Feature Classes
Feature linked
Stand Alone
29. Process Finalize the Map (Put it all together)
QA/QC
Solicit Feedback From Users
Present Results
30. Potential Obstacles
31. Potential Obstacles
32. Potential Obstacles
33. Potential Obstacles
34. Proposed Project Timeline March
Set Up Personal ArcSDE on Home Comp.
Choose Pilot Tile
Create Map Template
Assemble all Necessary Data
April
Create Custom Symbology
Store Symbology in Geodatabse
35. Project Timeline May
Annotation
June
Put it all together
Get Feedback From Users
QA/QC
July
Create a Presentation & Paper
August
Present Results at ESRI’s User Conference in San Diego, CA
(Abstract Accepted)
36. Questions,Comments,Suggestions