GeoSolve Inc. February 2006 vector digital data STREETS withheld Street Centerline Dataset (for E911-PSAP), Columbia County, Oregon To provide Columbia County 911 Communications District with a street centerline/addressing data layer. en February 2006 publication date In work As needed -123.376058 -122.764181 46.183335 45.614720 7473528.888854 7622941.289889 723057.593952 925760.237853 Streets Street Centerlines Addresses Columbia County Oregon USA To be determined by Columbia County 911 Communications District To be determined by Columbia County 911 Communications District Columbia County 911 Communications District Sue Reedy Data Specialist mailing and physical address

PO Box 998

St. Helens Oregon 97051 USA

58611 McNulty Way

503-397-7255 x224 503-366-7196 sreedy@columbia911.com 8-5 ESRI ArcCatalog 9.2.6.1500 GeoSolve Inc. February 2006 vector digital data Personal GeoDatabase Feature Class The attribute accuracy was tested by manual comparison of Columbia Counties delivered data sources (RdNames, MSAG, taxlot and corresponding situs table, roads1, and roads2). In this comparison, street name and addressing was verified. Discrepancies have been noted. The attributes are being verified by Columbia County. This layer was created as part of a personal geodatabase with ArcGIS 9.x. The topological integrity of the streets layer was verified with ArcGIS topology rules. The six rules used for the streets were, Must Not Overlap, Must Not Intersect, Must Not Have Dangles, Must Not Self-Overlap, Must Not Self-Intersect, and Must Be Single Part Public streets that fell within the right-of-way and were visible on the orthophotography were adjusted, digitized and addressed. As of the publication date, GeoSolve is working with Columbia Co. to verify and correct any issues flagged in the notes and comments fields. Please use this data set with caution until this process is complete. The streets were adjusted to the center of the TRAVELED WAY as visible on the orthophotography (As noted in Source Information). Columbia County Unknown vector digital data Original road segments from Columbia County with mile post information. disc RDNames Columbia County 2005 tabular digital data disc MSAG Columbia County Unknown vector digital data disc Taxlot Columbia County Unknown tabular digital data disc TAXDATA Columbia County Unknown vector digital data disc roads1 Columbia County Unknown vector digital data disc roads2 Columbia County 2002 raster digital data disc 2002 Color Orthophotography Columbia County 2000 raster digital data disc 2000 Color Orthophotography This layer was created as a personal geodatabase with ArcGIS 9.x. The RdNames.shp was adjusted / digitized to the center of the traveled way as visible on the orthophotography at a scale between 1:500 and 1:1500. The hierarchy in which the orthos were utilized is as follows: 2002 Color, 2000 Color, 2000 ODOT and the 2005 NAIP. In order to retain the vital information from the RdNames.shp, segments were split, but not merged. When a street extension was necessary, a new line segment was drawn rather than lengthening the existing one. Street name attributes were assigned from a variety of source data in the following order: RdNames, MSAG, taxlot situs addresses, roads1, and roads 2. When necessary, ORMAP, Google Maps, and ODOT City Maps were used as a reference. The IRIS fields were populated by calculating data from the roads1 and roads2 layers. Address ranges were assigned by joining the taxlot layer with the TAXDATA Access table and using situs addresses. The MSAG was also used to assign address ranges. Street name and address range discrepancies among source data was noted. LocalID attributes were assigned based on the PPDS Streets layer. City attributes were assigned based on the CITY feature class. County attributes were assigned based on the County boundaries shapefile from the Oregon Geospatial Enterprise Office. The zipcode attributes were assigned from the US Census Bureau's ZIP Code Tabulation Areas, EPA Oregon Zipcodes, and the similarity of the mailing address and situs address as found in the TAXDATA table. Addressed street segments that spanned multiple zipcode boundaries where not attributed with zipcode data. These segments are duplicated and attributed in the STREETS_ZIP layer. During the visit to Columbia County in January 2006 made by GeoSolve Inc. the attributes for Streets were updated and corrected. Missing roads were identified, digitized, and attributed. When possible, incorrect or missing addressing was attributed. Street naming conventions were determined with corrections to be made at the office of GeoSolve Inc. In all aforementioned cases, attributes were made using the map books and institutional knowledge of Columbia County PSAP staff. February 2006 withheld GeoSolve Inc. mailing address

PO Box 627

Albany Oregon 97321 USA (541) 926-2870 (541) 926-2384 shirley@geosolveinc.com 8-5 Columbia County 2000 raster digital data disc 2000 ODOT False Color NIR Orthophotography U.S. Department of Agriculture 2005 raster digital data disc 2005 NAIP Orthophotography Unknown vector digital data disc Columbia County Boundary US Census Bureau 2000 Clipped and Reprojected to Columbia County online Census Bureau ZIP Code Tabulation Areas EPA 2000 Clipped and Reprojected to Columbia County online EPA Oregon Zipcode Boundaries Metro Data Resource Center August 17, 2005 vector digital data disc PPDS Streets Portland Police Bureau 6\26\2006 disc colu_streets Columbia County Unknown vector digital data 2006 taxlot data disc taxlots The attributes for LOCALID and LEFTZIP and RIGHT zip were updated from the colu_streets shape file provided by the Portland Police Bureau. In colu_streets shape file all of the unnecessary fields were deleted. Temporary fields for LOCALID, LEFTZIP and RIGHTZIP were created and the values were calculated over. A spatial join was created between STREETS feature class and colu_streets shape file creating a Join_Output feature class. A tabular join was created between the STREETS feature class and the Join_Output feature class using the OBJECTID field. The values for LOCALID were calculated from the LocalID_Tp field. The values for LEFTZIP were calculated from the Left_Temp field and the values for RIGHTZIP were calculated from the Right_Temp field. February 2006 withheld GeoSolve Inc. mailing address

PO Box 627

Albany Oregon 97321 USA (541) 926-2870 (541) 926-2384 shirley@geosolveinc.com 8-5 Regular monthly maintenance updates may include: - Updating street attributes - Adding new streets - Adjusting street locations - Resolving discrepancies Updates performed on the following dates: - February, 2011 - January, 2011 - December, 2010 - November, 2010 - October, 2010 - September, 2010 - August, 2010 - July, 2010 - June, 2010 - May, 2010 - April, 2010 - March, 2010 - February, 2010 - January, 2010 - December, 2009 - November, 2009 - September, 2009 - August, 2009 - July, 2009 - June, 2009 - May, 2009 - April, 2009 - March, 2009 - February, 2009 - January, 2009 - December, 2008 - November, 2008 - October, 2008 - September, 2008 - August, 2008 - July, 2008 - June, 2008 - May, 2008 - April, 2008 - March, 2008 - February, 2008 - January, 2008 - December, 2007 - November, 2007 - October, 2007 - September, 2007 - August, 2007 - June, 2007 - May, 2007 - April, 2007 - March, 2007 - February, 2007 - January, 2007 - December, 2006 - November, 2006 - October, 2006 - September, 2006 December 2006 withheld withheld withheld withheld withheld withheld withheld withheld withheld withheld withheld GeoSolve Inc. mailing address

PO Box 627

Albany Oregon 97321 USA (541) 926-2870 (541) 926-2384 shirley@geosolveinc.com 8-5 Dataset copied. withheld 20110623 16323000 Vector Simple FALSE 0 TRUE FALSE coordinate pair 0.000256 0.000256 international feet D_North_American_1983_HARN Geodetic Reference System 80 6378137.000000 298.257222 GCS_North_American_1983_HARN NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl 0.000010 Explicit elevation coordinate included with horizontal coordinates Columbia County 911 Communications District Sue Reedy Data Specialist mailing and physical address St. Helens Oregon 97051 USA

PO Box 998

58611 McNulty Way

503-397-7255 x224 503-366-7196 sreedy@columbia911.com 8-5 Streets Centerline 20110322 GeoSolve Inc. Mailing Address

PO Box 627

Albany Oregon 97321 USA (541) 926-2870 (541) 926-2384 shirley@geosolveinc.com 8-5 FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time en February 2006 20180313 15464600 FALSE 20191127 07542900 20191127 07542900 FALSE Arterial_Roads 002 0.000 Projected GCS_North_American_1983_HARN Linear Unit: Foot (0.304800) NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WKT>PROJCS[&quot;NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl&quot;,GEOGCS[&quot;GCS_North_American_1983_HARN&quot;,DATUM[&quot;D_North_American_1983_HARN&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,8202099.737532808],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-120.5],PARAMETER[&quot;Standard_Parallel_1&quot;,44.33333333333334],PARAMETER[&quot;Standard_Parallel_2&quot;,46.0],PARAMETER[&quot;Latitude_Of_Origin&quot;,43.66666666666666],UNIT[&quot;Foot&quot;,0.3048],AUTHORITY[&quot;EPSG&quot;,2913]]</WKT><XOrigin>-111333600</XOrigin><YOrigin>-98152500</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2913</WKID><LatestWKID>2913</LatestWKID></ProjectedCoordinateSystem> 1.0 Esri ArcGIS 12.4.2.19948 Arterial_Roads 7473528.888854 7622941.289889 925760.237853 723057.593952 1 -123.376058 -122.764181 46.183335 45.61472 1 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset 002 withheld Local Area Network Personal GeoDatabase Feature Class Enterprise Geodatabase Feature Class 0.000 NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl EPSG 6.13(9.0.0) 0 20191127 Arterial_Roads Feature Class 0 OBJECTID_1 OBJECTID_1 OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. OBJECTID OBJECTID Integer 4 10 0 Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. SHAPE Shape Geometry 8 0 0 Feature geometry. ESRI Coordinates defining the features. STREETNAME STREETNAME String 30 0 0 Street name. Columbia E911/HI-TECH PREFIX PREFIX String 2 0 0 Columbia E911/HI-TECH Prefix directional of street name, ex. NE, N, etc. FTYPE FTYPE String 4 0 0 Columbia E911/HI-TECH Street type ex. AV, BLVD, etc. SUFFIX SUFFIX String 2 0 0 Columbia E911/HI-TECH Suffix directional of street name, ex. NE, N, etc. LEFTADD1 LEFTADD1 Integer 4 10 0 Columbia E911/HI-TECH The left low address. LEFTADD2 LEFTADD2 Integer 4 10 0 Columbia E911/HI-TECH The left high address. RGTADD1 RGTADD1 Integer 4 10 0 Columbia E911/HI-TECH The right low address. RGTADD2 RGTADD2 Integer 4 10 0 Columbia E911/HI-TECH The right high address. ZERO ZERO Integer 4 10 0 Columbia E911/HI-TECH Columbia Co attribute field. DIRECTION DIRECTION Integer 4 10 0 Columbia E911/HI-TECH Columbia Co attribute field. TYPE TYPE Integer 4 10 0 Columbia E911/HI-TECH Columbia Co attribute field. UP_DATE UP_DATE Date 8 0 0 Columbia E911/HI-TECH Columbia Co attribute field. CR_DATE CR_DATE Date 8 0 0 Columbia E911/HI-TECH Columbia Co attribute field. LOCALID LOCALID Integer 4 10 0 Portland Police Data Systems Unique identifying number. LEFTZIP LEFTZIP Integer 4 10 0 Portland Police Data Systems The zip code on the left side of the segment. RIGHTZIP RIGHTZIP Integer 4 10 0 Portland Police Data Systems The zip code on the right side of the segment. LCOUNTY LCOUNTY String 4 0 0 Portland Police Data Systems The county on the left side of the segment. RCOUNTY RCOUNTY String 4 0 0 Portland Police Data Systems The county on the right side of the segment. LCITY LCITY String 32 0 0 Portland Police Data Systems The city on the left side of the segment. RCITY RCITY String 32 0 0 Portland Police Data Systems The city on the right side of the segment. Road_Numbr Road_Numbr String 10 0 0 Columbia Co Road Dept County road number. Beg_Milpst Beg_Milpst String 19 0 0 Columbia Co Road Dept The beginning milepost of the segment. End_Milpst End_Milpst String 19 0 0 Columbia Co Road Dept The ending milepost of the segment. IRIS_FPRE IRIS_FPRE String 2 0 0 Columbia County Prefix directional of street name, ex. NE, N, etc. IRIS_FNAME IRIS_FNAME String 30 0 0 Columbia County Street name. IRIS_FTYPE IRIS_FTYPE String 4 0 0 Columbia County Street type ex. AV, BLVD, etc. RDNAME RDNAME String 30 0 0 Columbia Co Road Dept Street name. ALIAS ALIAS String 75 0 0 Full legal road name if different from MSAG. GeoSolve Inc. DESIG DESIG String 25 0 0 Classification for non addressed populated streets. GeoSolve Inc. concat concat String 72 0 0 SHAPE_Leng SHAPE_Leng Double 8 38 8 f_zlev f_zlev Integer 4 10 0 t_zlev t_zlev Integer 4 10 0 pcmap_Name pcmap_Name String 50 0 0 Shape_Le_1 Shape_Le_1 Double 8 38 8 Shape.STLength() Shape.STLength() Double 0 0 0