City of San Jose Spatial Adjustment Project

 


In April 2003, The City of San Jose selected MRF to adjust its street centerline, parcel, and water, sewer, and other GIS layers’ geometry to agree with orthophoto and planimetric data. The City required MRF to integrate and verify data sets from different data sources, including the City’s MGE data, CAD geofile, data from the County of Santa Clara, as-built plans, and data from outside sources. MRF evaluated the City’s enterprise GIS data model in Oracle 9.2 and proposed changes to the data model so that it can support GeoMedia, ArcGIS, and MapInfo.

 

Major tasks included:

§         Evaluated the City’s enterprise data model and ensured data model interoperability among GeoMedia, ArcGIS, and MapInfo.

§         Migrated City’s base maps from MGE to an Oracle Spatial data model

§         Developed a set of GIS data processing and QA/QC tools for arc generation, rubber-sheeting, conflation, data integration, and data model data loading.

§         Spatially adjusted centerline/parcel/utility features to fit with Orthophotos and planimetric data.

o        Street centerlines,

o        Parcels,

o        Sanitary and Water,

o        Planning layers, and

o        Dozens of other secondary GIS layers.

§         Captured missing streets and parcels using Tract Maps and Assessor Maps

§         Captured and verified centerline, parcel and utility attributes from multiple data sources, including orthophotos, subdivision plans, utility engineering plans, and profile drawings from the City and street centerline data from GDT.

§         Created FGDC standard compliant metadata for each GIS layer

§         Cleaned up data and corrected topological errors

§         Verified street name, address ranges and other attributes

§         Performed complete QA/QC that ensured the data quality. Complex spatial queries were required to check the address overlapping error, polygon overlapping errors, etc.

 

MRF developed a set of software tools to achieve higher levels of spatial accuracy and cross-referencing attributes. The final deliverable was a data set stored in Oracle Spatial 9.2 Object Model. Software used in this project: MicroStation, GeoMedia, ArcGIS, ArcSDE, MapInfo, MRF GIS Components.