Item 1: Supply of Commercial and Industrial Land in Lane County

Home Browse Search

For the land outside the metro area, commercial and industrial zoning designations that were to be included in the land base were identified by T AC members representing Lane County. Spatial queries were applied to the Lane land use polygon coverage to arrive at the land base for the lands outside the metro area. A detailed flow diagram is included at the end of this appendix that documents all of the individual processes used to generate this file. This process produced a single GIS polygon file with new unique identification attributes that will be used to populate the Access database. This step is important for the next step of populating the database but will also be instrumental for linking the results of later database queries back to the GIS for map display. ECO designed a database structure that is simple and straightforward. The goal was to create a structure that can contain all of the attributes identified by the partner agencies as valuable to this study and that can be effectively tied to the outside GIS files, databases, and spreadsheets that will supply these attributes. ECO will compile this database as "snapshot" exports from outside source datasets, but also document where and how static tables can later be replaced with live, dynamic queries to their source datasets. In addition, this structure creates a repository for new data, identified by the partner agencies as valuable to the study, but currently not available from existing datasets or through cost effective spatial analysis. Tables and fields have been created to store data values generated from site visits, air photo interpretation or other future analyses.