OD Home
Overview
Methodology
Limitations
Results
Downloads
Future Enhancements
References
Contacts



 

Methodology

The fundamental backbone of this project is the design and populating of the Geodatabase, which involves several stages typical to designing databases with organization and management in mind.

Stage 1: Data Collection and Justification


Most of the spatial data for the Geodatabase originated from the District of Pitt Meadows, with some of it being provided by the B.C. Provincial Government. The data was given to OD in the following formats from the District: Arc/Info, PC Arc/Info coverages, AutoCAD, ArcGIS coverages, ArcView shapefiles, DBF and Excel spreadsheets. The majority of the data was originally stored as shapefiles, PC Arc/Info coverages or e00. Data originating from the Ministry of Agriculture, Fisheries and Food (i.e. soil and capability data) was compiled. While most of the data was contained in the District of Pitt Meadows, some attribute table fields corresponded to areas outside the District.

Discrepancies among identical GIS themes were carefully observed and corrected where possible (i.e. OCP_RURAL, OCP_URBAN, Utilities). Cadastre and crops data needed to be revised due to distortions caused by previous rubber-sheeting processes, causing mismatches to the original cadastral references. AutoCad files were not used because they contained feature elements not present in ArcGIS format, (such as North Arrows, GRID lines and latitude/longitude values) that would have required manual deletion. Due to time constraints, OD used AutoCad files strictly for reference purposes.

To facilitate ease in linking or relationships, roll number values in some feature and attribute layers were formatted using ArcView 3.2 according to the format in the cadastral feature layer. Also, zoning codes were added to cadastral feature layer. New data generated included the zoning definition attribute table and the parcel lot and plan number annotations through AML scripts. The AML scripts contributed by Darrin Grund were modified such that the annotation text sizes increased with increasing parcel area. Furthermore, since plan numbers are not unique, the AML script created plan numbers in common areas.



Next > Stage 2: Conceptual Data Modelling
Simon Fraser University

District of Pitt Meadows This site was produced by Operational:Database for GEOG 452 at SFU. It requires a Java enabled script browser and was last updated on March 25, 2003 by W Lau.