; City of Prince George
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

City of Prince George

VIEWS: 27 PAGES: 26

  • pg 1
									   City of Prince George

Internet Mapping System – PGMap

   Wendy Nordin – GIS Coordinator
   Craig Telford – GIS Technologist
                City of Prince George IMS - PGMap

• Intranet version deployed in the fall of 2000
• Internet version deployed in the fall of 2001
• Uses Autodesk MapGuide software
• Application is developed using basic html, JavaScript,
  and Macromedia Coldfusion
• Tabular data is stored mainly in an Oracle database,
  some data is stored in MS Access
• Supported spatial data format is Autodesk sdf and
  ESRI shape
             City of Prince George IMS - PGMap
• Internet version has 203 layers
• Provides basic search features
   – Search by civic address, legal description
• Produces a basic property report
   – 14 queries on 3 tables
   – Links to zoning bylaw text, lot servicing sketches, and
     integrated survey monument sketches
            City of Prince George IMS - PGMap
• Intranet version has 255 layers
• Provides more complex search capabilities
   – Query Builder
   – Search by civic address, legal description, zoning, owner,
     valve, manhole, hydrant etc
• Property report is comprehensive
   – 32 queries on 15 tables
   – Links to internet version documents plus legal plans,
     engineer drawings
• Intranet version has redlining, buffering and mailing
  lists
           City of Prince George IMS - PGMap


Query
Builder
Allows
users to
perform
complex
sql
queries
and
build
reports
or maps
            City of Prince George IMS - PGMap

Redlining
Tool
Allows
users to
create
quick
sketches
and notes
for file
City of Prince George IMS - PGMap
Buffer and Mailing List
        City of Prince George IMS – PGMap
Property Report
         City of Prince George IMS – PGMap
Property Report   •Civic Address
                  •Legal description and right of ways registered on title
                  with link to scanned legal plan
                  •Zoning with a link to zoning bylaw text
                  •Rezoning history
                  •Indicator if property is in the ARL, floodplain, or has
                  other land use restrictions
                  •List of development permits, variance permits , and
                  land use contracts
                  •Specific primary, secondary and tertiary land uses
                  •Business licenses
                  •Building permits
                  •Utility accounts
                  •Liquor Licenses
                  •Owner, Mailing Address
                  •Assessed Value
                  •Lot size
                  •Location and details of service connections with link to
                  service connection sketch
                 City of Prince George IMS - PGMap
    Basic application structure
•   Client map viewer (through the embedded map or mwf file) posts requests to
    the web server.
•   The web server processes the request from web server and passes to the
    MapGuide server.
•   MapGuide server retrieves the required data and returns to the map viewer.
          City of Prince George IMS - PGMap
Layer Authoring
          City of Prince George IMS - PGMap
Layer Authoring
          City of Prince George IMS - PGMap
Layer Authoring
             City of Prince George IMS - PGMap
Staff resources:
 – Application Development
     •   Oracle database administrator
     •   Network administrator
     •   GIS Coordinator
     •   Occasional outsourcing through consultants
 – Data Maintenance
     • Tabular data is maintained by appropriate divisional clerical staff (16),
       GIS staff (2), plus 1 external agency (BC Assessment Authority)
     • Spatial data maintained by GIS staff (2 technologists)
             City of Prince George – Spatial Data
• Spatial Data Management
   – Software & Applications
       • Data structure
   – Data sources
       • Internal & External
   – Parcel update process
   – Data issues
                City of Prince George – Spatial Data
•   Applications and Structure

     –
         • AutoCad, Autocad Map – DWG
         • Mapguide – SDF (shapefile, dwg, dxf, etc)
              – Historically stored in dwg format




     –
         • Arc/INFO – coverage, shapefile
         • ArcGIS – GeoDatabase (Personal & SDE)
              – Feature Classes
              – Moving to Data Model structure within SDE




     – Maintain and update a minimum of two data formats.
            City of Prince George – Spatial Data
• Data Sources
  – Internal
      • Planning department – Zoning, ALR, SHO
          – ArcPad Landuse data collected
      • Utilities department – Infrastructure, Water, Storm & Sewer
          – GPS location of some features is being done.
  – External
      • BC Land Titles – Legal plan boundaries
      • Consultants – Engineering drawings
          City of Prince George – Spatial Data
• Parcel update process
            City of Prince George – Spatial Data
• Spatial update process




   – Export spatial data!
           City of Prince George – Spatial Data
• Spatial update process




   – Legal plan
City of Prince George – Spatial Data
            City of Prince George – Spatial Data
• Daily export process
   – Convert dwg to dxf
   – Import to ArcINFO workstation
      • Clean & Build for region feature class (PID)
      • Relate to Oracle – region feature class (FOLIO)
      • Relate to Oracle – Civic Address, Ownership, land use,
        zoning


   – Export to Shapefile
      • City owned properties
      • City owned properties, For Sale
                 City of Prince George – Spatial Data
• Daily export process (2)
   –   DWG annotation exported to a CSV file
         • UTM NAD83, Zone 10
         • Geographic (Lat Long)
   –   Extent of each Parcel & Folio exported to a text file
   –   Data Converted to ESRI Shapefile
   –   Shapefile converted to sdf format
   –   Python scripts and GeoProcessing models
            City of Prince George – Spatial Data
• Data Issues
   – Why do we maintain 2 data formats?
      • Other departments use of dwg format
      • Conversion back to dwg is not always perfect
          – Annotation (justification)
          – Arcs / curves segmented line (cul-de-sacs)
      • Not all of the data is maintained by us
          – Quality of data not always insure
               City of Prince George – Spatial Data
• Data Issues
   – Coincident geometry
      •   Park boundaries
      •   ALR
      •   Zoning
      •   Service areas
         City of Prince George – Spatial Data
• Questions?

								
To top