publish.GIS.Base

Butte County Development Services - GIS Division Unpublished Material publish.GIS.Base_Roads vector digital data publish.GIS.Base_Roads Butte County Roads Layer The roads layer was developed to provide centerline road information for Butte County. It contains road segments, road names, and geocoded (addressed) road segements for unincorporated areas of Butte County. The file should be used for cartographic purposes and geographic analysis which does not require a high degree of positional accuracy. Note - This is not an adopted layer. BACKGROUND: In late 2004, the existing Butte County road file was adjusted from the old Butte County parcel base, maintained by Butte County Development Services, to align with the Butte County Association of Governments (BCAG) parcel base. The reason being that the BCAG parcel base contains more accurate geometry than the previous base. Also, the BCAG base is being used by the majority of other municipalities in the area. In early 2005, the newly adjusted road file was geocoded to include addressed road segments within unincorporated Butte County. These geocoded (addressed) road segments can be used to place addressed databases using the geocode functions in ArcView and ArcMap. The segments were addressed using the existing Butte County address point file and the existing BCAG address point file. The Butte County address point was determined to be approx 80-85% accurate for the rural areas of the county, at that time. The BCAG address point file was determined to be approx 95-97% accurate for the incorporated areas of the county, at that time. These approx accuracies refer to attributes and parcel level position, not positional in terms of being on the actual structures. As of August 2005, an effort is currently in process to realign the road segments from the parcel base to the aerial photo's. It is fairly well known that certain areas of the county, mostly rural, have parcel boundaries and easements which do not align precisely with the aerial photo base. The reason being that some assessor parcel pages are fairly outdated and were not originally drawn, by the Assessor's Office, using survey data. In order to increase the positional accuracy for future projects and analysis, road segments which do not match the aerial photo base will be realigned. A seperate layer will be available, upon request, which contains segments that follow the parcel file. This process is expected to take several months to complete. The following fields were added in October 2005: jurisdict, ramp, and direct. 'Jurisdict' is populated with road jurisdiction attributes obtained from Butte County Public Works road name list file. Not all roads contained attributes, so a file of those roads were returned to public works. 'Ramp' and 'Direct' fields were added to signify off and on ramps for state highways. The direction marks which way the traffic is exiting or entering the highway. Note: The jurisdiction is for general reference purposes only and may not actually determine jurisdiction. The following fields were added in December 2005: road_no, fr_mile, to_mile, and length. These fields will be used for routing and general reference purposes for by the Butte County Public Works department. See process step 2 for more info. The following field was added in March 2006: major. Field was requested by LAFCO analyst for cartographic purposes. See process step 3 for more info. DISCLAIMER Butte County does not guarantee that the information provided in the layer is accurate or complete. The County provides this information on an "as is" basis and disclaims all warranties, expressed or implied, including but not limitied to warranties of merchantability, fitness for a particular purpose and non-infringement. The County is not responsible for any damages arising from the use of this information. Access to this data is at user's risk. Users should verify the information before making project commitments. en Ongoing as roads are created Complete As needed -122.050775 -121.101367 40.170715 39.248388 6547475.547235 6812834.288826 2217691.868083 2552435.028647 Roads, Streets, --public and private REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords. REQUIRED: Restrictions and legal prerequisites for accessing the data set. Butte County does not guarantee that the information provided in the layer is accurate or complete. The County provides this information on an "as is" basis and disclaims all warranties, expressed or implied, including but not limitied to warranties of merchantability, fitness for a particular purpose and non-infringement. The County is not responsible for any damages arising from the use of this information. Access to this data is at user's risk. Users should verify the information before making project commitments. Butte County Development Services - GIS Division Jim Aranguren GIS Manager mailing and physical address

7 County Center Drive

Oroville California 95965 USA (530) 538-6870 (530) 538-7785 JAranguren@buttecounty.net 8:00 am - 4:00 pm , Monday - Friday GIF Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.1.1850 SDE Feature Class 2004 The following fields were added in October 2005: jurisdict, ramp, and direct. 'Jurisdict" is populated with road jusrisdiction attributes obtained from Butte County Public Works road name list file. Not all roads contained attributes, so a file of those roads were returned to public works. This information was updated in December 2005 to reflect changes once the 'ROAD_NO' filed was added. 'Ramp' and 'Direct' fields were added to signify off and on ramps for state highways. The direction marks which way the traffic is exiting or entering the highway. The following fields and attributes were added in December 2005: road_no, fr_mile, to_mile, and length_mi. The 'ROAD_NO' field contains Butte County Public Works designated road numbers for all county maintained roads. Some road numbers which were determined to be within incorporated areas were not added. All road numbers were entered manually and reviewed by the GIS technician for proper length, location, and starting and ending points. Roads were split to accommodate proper lengths for transitions from county maintained to private. The 'FR_MILE and TO_MILE' fields contain Butte County Public Works segment length information for designated roads. This information is used to calibrate roads for routing purposes. Interesection data was received from the Public Works department to use for adding lengths. When a length was not specified then tha actual calculated lenght was used. Note: This is information generated by the roads division and may not reflect what the actual geagraphic distance of the road my be. The 'LENGTH_MI' field contains the actual calculated length of the road segment in miles. I:\shared\data_updates\ROADS_BCDS\SERVER_UPDATES\103105\roads_bcds.shp.xml 20051103 12523700 Butte County GIS Division Larry Painter GIS Technician March 2006. 'MAJOR' field added to be used for cartographic purposes only. Information was provided by LAFCO analyst on a seperate shapefile. GIS technician (L.Painter) then transfered the information to the roads layer. "YES" represents a road which can be symbolized seperatly than other segments. March 2006 Metadata imported. W:\GIS\BASE_DATA\R-T\roads.shp.xml 20060523 08250700 Dataset copied. \\bc-gis-02\GISInternal\shared\data_updates\ROADS_BCDS\ROADS_BCDS.mdb 20091221 10053900 Dataset copied. Server=bc-gis-sde-01; Service=sde:sqlserver:bc-gis-sde-01\gis_data; Database=publish; User=dshuey; Version=DSHUEY.diana_edit 20110913 16124700 Road file was adjusted to fit Digital Ortho Photos created by Butte County Association of Governments in February 2002. Spatial accuracy of these photos varies from 1 to 5 meters. For more information go to http://www.bcag.org/__gis/Aerial_Photo_Pricing.html. Exceptions to the road file following the photos include: when the parcel base did not align to the photos, the roads were adjusted to fit to the right of way designations on the parcel so some discrepencies may occur between the photos and the roads. Vector Simple FALSE 0 TRUE FALSE coordinate pair 0.000328 0.000328 survey feet North American Datum of 1983 Geodetic Reference System 80 6378137.000000 298.257222 GCS_North_American_1983 NAD_1983_StatePlane_California_II_FIPS_0402_Feet Explicit elevation coordinate included with horizontal coordinates 1.000000 LENGTH_MI LENGTH_MI Double 8 Length of roads calculated in GIS. Units in miles. 38 8 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. PWwork.PWOWNER.Base_Roads Feature Class 0 Shape Feature geometry. ESRI Coordinates defining the features. Shape Geometry 4 0 0 STREET STREET String 30 Street Name 0 0 STREETTYPE STREETTYPE String 8 Road, Court, Lane, Way, etc. 0 0 STREETNAME STREETNAME String 45 Complete Street Name 0 0 HIERARCHY HIERARCHY String 20 Functional classification of roadways (highway, arterial, collector, etc.) based on the Butte County Highway Planning System Road Maps in use prior to 2000, created by the State of California Department of Transportation, in co-operation with the United States Department of Transportation Federal Highway Administration and the Counties. 0 0 HWY_NUM HWY_NUM String 3 State Highway number, eg. Hwy 99 0 0 Z_100000 Z_100000 String 16 Selection of major roads for mapping simplification at a scale of approximately 1:100,000. 0 0 Z_24000 Z_24000 String 16 Selection of major roads for mapping simplification at a scale of approximately 1:24,000. 0 0 FRADDL FRADDL Integer 4 From address left (geocoding) 10 0 TOADDL TOADDL Integer 4 To address left (geocoding) 10 0 ADDED ADDED String 5 0 0 FRADDR FRADDR Integer 4 From address right (geocoding) 10 0 TOADDR TOADDR Integer 4 To address right (geocoding) 10 0 JURISDICT JURISDICT String 25 Jurisdiction of road. 0 0 RAMP RAMP String 10 Type of state highway ramp on/off. 0 0 DIRECT DIRECT String 15 Direction of travel for on/off ramp or highway. 0 0 STATUS STATUS String 15 Current status of the road. 'Innactive' is used to flag roads which are not currently constructed. 0 0 ROAD_NO ROAD_NO String 10 Butte County Public Works designated road number used for maintenance and reference purposes. 0 0 MAJOR MAJOR String 20 0 0 UPDATED UPDATED String 10 0 0 LABEL Label String 35 0 0 FR_MILE FR_MILE Double 8 From-mile used for calibrating roads. This does not reflect the actual mileage of the road. Units in miles. 38 8 TO_MILE TO_MILE Double 8 To-mile used for calibrating roads. This does not reflect the actual mileage of the road. Units in miles. 38 8 CLASS CLASS String 6 0 0 SURFACE SURFACE String 6 0 0 Shape.STLength() Shape.STLength() Double 0 0 0 Butte County Development Services - GIS Division Jim Aranguren GIS Manager mailing and physical address

7 County Center Drive

Oroville California 95965 USA (530) 538-6870 (530) 538-7785 JAranguren@buttecounty.net 8:00 am - 4:00 pm, Monday - Friday Downloadable Data 0.077 2.737 20110824 Butte County Development Services - GIS Division Brian Lasagna GIS Analyst mailing and physical address

7 County Center Drive

Oroville California 95965 USA (530) 538-6704 (530) 538-7785 BLasagna@buttecounty.net 8:00 am - 4:00 pm , Monday - Friday FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time http://www.esri.com/metadata/esriprof80.html ESRI Metadata Profile http://www.esri.com/metadata/esriprof80.html ESRI Metadata Profile en 20190417 20134600 FALSE 20190417 19535800 20190417 19535800 AddSpatialIndex M:\GIS\BASE_DATA\R-T\roads.shp 0 0 0 M:\GIS\BASE_DATA\R-T\roads.shp SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN communities_poly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN community_poly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN communitypoly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN community_poly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN communitypoly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN communitypoly_Layer # NEW_SELECTION roads_Layer1 SelectLayerByLocation roads_Layer1 HAVE_THEIR_CENTER_IN community_Layer # NEW_SELECTION roads_Layer1 FeatureClassToFeatureClass M:\GIS\BASE_DATA\R-T\roads.shp "Database Connections\bc-gis-sde-01.publish.dc.gis.sde" NEWBase_Roads # "OBJECTID 'OBJECTID' true true false 9 Long 0 9 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,OBJECTID,-1,-1;STREET 'STREET' true true false 30 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,STREET,-1,-1;STREETTYPE 'STREETTYPE' true true false 8 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,STREETTYPE,-1,-1;STREETNAME 'STREETNAME' true true false 45 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,STREETNAME,-1,-1;HIERARCHY 'HIERARCHY' true true false 20 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,HIERARCHY,-1,-1;HWY_NUM 'HWY_NUM' true true false 3 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,HWY_NUM,-1,-1;Z_100000 'Z_100000' true true false 16 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,Z_100000,-1,-1;Z_24000 'Z_24000' true true false 16 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,Z_24000,-1,-1;FRADDL 'FRADDL' true true false 9 Long 0 9 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,FRADDL,-1,-1;TOADDL 'TOADDL' true true false 9 Long 0 9 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,TOADDL,-1,-1;FRADDR 'FRADDR' true true false 9 Long 0 9 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,FRADDR,-1,-1;TOADDR 'TOADDR' true true false 9 Long 0 9 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,TOADDR,-1,-1;ADDED 'ADDED' true true false 5 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,ADDED,-1,-1;Shape_Leng 'Shape_Leng' true true false 19 Double 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,Shape_Leng,-1,-1;UPDATED 'UPDATED' true true false 10 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,UPDATED,-1,-1;JURISDICT 'JURISDICT' true true false 25 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,JURISDICT,-1,-1;RAMP 'RAMP' true true false 10 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,RAMP,-1,-1;DIRECT 'DIRECT' true true false 15 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,DIRECT,-1,-1;STATUS 'STATUS' true true false 15 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,STATUS,-1,-1;ROAD_NO 'ROAD_NO' true true false 10 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,ROAD_NO,-1,-1;FR_MILE 'FR_MILE' true true false 19 Double 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,FR_MILE,-1,-1;TO_MILE 'TO_MILE' true true false 19 Double 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,TO_MILE,-1,-1;LENGTH_MI 'LENGTH_MI' true true false 19 Double 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,LENGTH_MI,-1,-1;TEMP_ 'TEMP_' true true false 50 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,TEMP,-1,-1;LABELING 'LABELING' true true false 35 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,LABELING,-1,-1;MAJOR 'MAJOR' true true false 20 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,MAJOR,-1,-1;CLASS 'CLASS' true true false 6 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,CLASS,-1,-1;SURFACE 'SURFACE' true true false 6 Text 0 0 ,First,#,M:\GIS\BASE_DATA\R-T\roads.shp,SURFACE,-1,-1" # "Database Connections\bc-gis-sde-01.publish.dc.gis.sde\publish.GIS.NEWBase_Roads" Select roads "N:\Temp\Roads\Dianna Roads.shp" # CalculateField "Dianna Roads" snapped "not" VB # CalculateField "Dianna Roads" snapped "not" VB # CalculateField "Dianna Roads" snapped "not" VB # CalculateField "Dianna Roads" snapped "not" VB # CalculateField "Dianna Roads" snapped " " VB # CalculateField "Dianna RoadsCopy" LENGTH_MI round( [LENGTH_MI]/5280 ,3) VB # CalculateField "Dianna RoadsCopy" JURISDICT "CITY" VB # CalculateField "Dianna RoadsCopy" JURISDICT "CITY" VB # CalculateField "Dianna RoadsCopy" JURISDICT "ORO" VB # CalculateField "Dianna RoadsCopy" JURISDICT "CHICO" VB # CalculateField "Dianna RoadsCopy" JURISDICT "GRID" VB # CalculateField "Dianna RoadsCopy" STATUS "" VB # CalculateField "Dianna RoadsCopy" ROAD_NO "" VB # CalculateField "Dianna RoadsCopy" JURISDICT "PVT" VB # CalculateField "Dianna RoadsCopy" CLASS "" VB # CalculateField "Dianna RoadsCopy" SURFACE "" VB # CalculateField "Road Merge" ROAD_NO "28465-V" VB # CalculateField roads Z_24000 "minor" VB # CalculateField roads Z_24000 "minor" VB # CalculateField roads Z_24000 "minor" VB # CalculateField roads Z_24000 "minor" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField roads Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "major" VB # CalculateField "roads (M drive)" Z_24000 "minor" VB # CalculateField "roads (M drive)" LABELING "Lower Wyandotte Rd" VB # CalculateField roads LABELING "" VB # Merge roads;RoadsCity C:\Users\lsanders\Documents\ArcGIS\Default.gdb\roads_Merge "OBJECTID_1 "OBJECTID_1" true true false 10 Long 0 10 ,First,#,roads,OBJECTID_1,-1,-1,RoadsCity,OBJECTID_1,-1,-1;OBJECTID "OBJECTID" true true false 10 Long 0 10 ,First,#,roads,OBJECTID,-1,-1,RoadsCity,OBJECTID,-1,-1;STREET "STREET" true true false 30 Text 0 0 ,First,#,roads,STREET,-1,-1;STREETTYPE "STREETTYPE" true true false 8 Text 0 0 ,First,#,roads,STREETTYPE,-1,-1;STREETNAME "STREETNAME" true true false 45 Text 0 0 ,First,#,roads,STREETNAME,-1,-1;HIERARCHY "HIERARCHY" true true false 20 Text 0 0 ,First,#,roads,HIERARCHY,-1,-1,RoadsCity,HIERARCHY,-1,-1;HWY_NUM "HWY_NUM" true true false 3 Text 0 0 ,First,#,roads,HWY_NUM,-1,-1,RoadsCity,HWY_NUM,-1,-1;Z_100000 "Z_100000" true true false 16 Text 0 0 ,First,#,roads,Z_100000,-1,-1,RoadsCity,Z_100000,-1,-1;Z_24000 "Z_24000" true true false 16 Text 0 0 ,First,#,roads,Z_24000,-1,-1,RoadsCity,Z_24000,-1,-1;FRADDL "FRADDL" true true false 10 Long 0 10 ,First,#,roads,FRADDL,-1,-1;TOADDL "TOADDL" true true false 10 Long 0 10 ,First,#,roads,TOADDL,-1,-1;FRADDR "FRADDR" true true false 10 Long 0 10 ,First,#,roads,FRADDR,-1,-1;TOADDR "TOADDR" true true false 10 Long 0 10 ,First,#,roads,TOADDR,-1,-1;ADDED "ADDED" true true false 5 Text 0 0 ,First,#,roads,ADDED,-1,-1;Shape_Leng "Shape_Leng" true true false 19 Double 8 18 ,First,#,roads,Shape_Leng,-1,-1,RoadsCity,Shape_Leng,-1,-1;UPDATED "UPDATED" true true false 10 Text 0 0 ,First,#,roads,UPDATED,-1,-1,RoadsCity,UPDATED,-1,-1;JURISDICT "JURISDICT" true true false 25 Text 0 0 ,First,#,roads,JURISDICT,-1,-1;RAMP "RAMP" true true false 10 Text 0 0 ,First,#,roads,RAMP,-1,-1;DIRECT "DIRECT" true true false 15 Text 0 0 ,First,#,roads,DIRECT,-1,-1;STATUS "STATUS" true true false 15 Text 0 0 ,First,#,roads,STATUS,-1,-1;ROAD_NO "ROAD_NO" true true false 10 Text 0 0 ,First,#,roads,ROAD_NO,-1,-1;FR_MILE "FR_MILE" true true false 19 Double 8 18 ,First,#,roads,FR_MILE,-1,-1;TO_MILE "TO_MILE" true true false 19 Double 8 18 ,First,#,roads,TO_MILE,-1,-1;LENGTH_MI "LENGTH_MI" true true false 19 Double 8 18 ,First,#,roads,LENGTH_MI,-1,-1;TEMP_ "TEMP_" true true false 50 Text 0 0 ,First,#,roads,TEMP_,-1,-1;LABELING "LABELING" true true false 35 Text 0 0 ,First,#,roads,LABELING,-1,-1;MAJOR "MAJOR" true true false 20 Text 0 0 ,First,#,roads,MAJOR,-1,-1;CLASS "CLASS" true true false 6 Text 0 0 ,First,#,roads,CLASS,-1,-1;SURFACE "SURFACE" true true false 6 Text 0 0 ,First,#,roads,SURFACE,-1,-1;Shape_len "Shape_len" true true false 19 Double 0 0 ,First,#,roads,Shape_len,-1,-1;DYNAMAP_ID "DYNAMAP_ID" true true false 15 Text 0 0 ,First,#,RoadsCity,DYNAMAP_ID,-1,-1;L_F_ADD "L_F_ADD" true true false 11 Text 0 0 ,First,#,RoadsCity,L_F_ADD,-1,-1;L_T_ADD "L_T_ADD" true true false 11 Text 0 0 ,First,#,RoadsCity,L_T_ADD,-1,-1;R_F_ADD "R_F_ADD" true true false 11 Text 0 0 ,First,#,RoadsCity,R_F_ADD,-1,-1;R_T_ADD "R_T_ADD" true true false 11 Text 0 0 ,First,#,RoadsCity,R_T_ADD,-1,-1;PREFIX "PREFIX" true true false 4 Text 0 0 ,First,#,RoadsCity,PREFIX,-1,-1;NAME "NAME" true true false 40 Text 0 0 ,First,#,RoadsCity,NAME,-1,-1;TYPE "TYPE" true true false 6 Text 0 0 ,First,#,RoadsCity,TYPE,-1,-1;SUFFIX "SUFFIX" true true false 4 Text 0 0 ,First,#,RoadsCity,SUFFIX,-1,-1;FCC "FCC" true true false 3 Text 0 0 ,First,#,RoadsCity,FCC,-1,-1;POSTAL_L "POSTAL_L" true true false 5 Text 0 0 ,First,#,RoadsCity,POSTAL_L,-1,-1;POSTAL_R "POSTAL_R" true true false 5 Text 0 0 ,First,#,RoadsCity,POSTAL_R,-1,-1;ACC "ACC" true true false 1 Text 0 0 ,First,#,RoadsCity,ACC,-1,-1;NAME_TYPE "NAME_TYPE" true true false 1 Text 0 0 ,First,#,RoadsCity,NAME_TYPE,-1,-1;SHIELD "SHIELD" true true false 1 Text 0 0 ,First,#,RoadsCity,SHIELD,-1,-1;SEG_LEN "SEG_LEN" true true false 19 Double 0 0 ,First,#,RoadsCity,SEG_LEN,-1,-1;SPEED "SPEED" true true false 10 Long 0 10 ,First,#,RoadsCity,SPEED,-1,-1;ONE_WAY "ONE_WAY" true true false 2 Text 0 0 ,First,#,RoadsCity,ONE_WAY,-1,-1;F_ZLEV "F_ZLEV" true true false 10 Long 0 10 ,First,#,RoadsCity,F_ZLEV,-1,-1;T_ZLEV "T_ZLEV" true true false 10 Long 0 10 ,First,#,RoadsCity,T_ZLEV,-1,-1;FT_COST "FT_COST" true true false 19 Double 0 0 ,First,#,RoadsCity,FT_COST,-1,-1;TF_COST "TF_COST" true true false 19 Double 0 0 ,First,#,RoadsCity,TF_COST,-1,-1;FT_DIR "FT_DIR" true true false 2 Text 0 0 ,First,#,RoadsCity,FT_DIR,-1,-1;TF_DIR "TF_DIR" true true false 2 Text 0 0 ,First,#,RoadsCity,TF_DIR,-1,-1;NAME_FLAG "NAME_FLAG" true true false 10 Long 0 10 ,First,#,RoadsCity,NAME_FLAG,-1,-1;FULLSTREET "FULLSTREET" true true false 60 Text 0 0 ,First,#,RoadsCity,FULLSTREET,-1,-1;VESTING "VESTING" true true false 7 Text 0 0 ,First,#,RoadsCity,VESTING,-1,-1;PLAN_LABEL "PLAN_LABEL" true true false 42 Text 0 0 ,First,#,RoadsCity,PLAN_LABEL,-1,-1;FUNC_CLASS "FUNC_CLASS" true true false 25 Text 0 0 ,First,#,RoadsCity,FUNC_CLASS,-1,-1;GP_CLASS "GP_CLASS" true true false 5 Text 0 0 ,First,#,RoadsCity,GP_CLASS,-1,-1;MINUTES "MINUTES" true true false 19 Double 0 0 ,First,#,RoadsCity,MINUTES,-1,-1;MILES "MILES" true true false 19 Double 0 0 ,First,#,RoadsCity,MILES,-1,-1;COMMENT "COMMENT" true true false 100 Text 0 0 ,First,#,RoadsCity,COMMENT,-1,-1;COMMUNITY "COMMUNITY" true true false 30 Text 0 0 ,First,#,RoadsCity,COMMUNITY,-1,-1;EditorName "EditorName" true true false 50 Text 0 0 ,First,#,RoadsCity,EditorName,-1,-1;LastUpdate "LastUpdate" true true false 8 Date 0 0 ,First,#,RoadsCity,LastUpdate,-1,-1;OVERPASS "OVERPASS" true true false 50 Text 0 0 ,First,#,RoadsCity,OVERPASS,-1,-1;ROAD_DEF_Q "ROAD_DEF_Q" true true false 10 Long 0 10 ,First,#,RoadsCity,ROAD_DEF_Q,-1,-1;COC_Speed "COC_Speed" true true false 19 Double 0 0 ,First,#,RoadsCity,COC_Speed,-1,-1" CalculateField roads_Merge STREET [NAME] VB # CalculateField roads_Merge STREETTYPE [TYPE] VB # CalculateField roads_Merge STREETNAME "[NAME] & " " &[TYPE]" VB # CalculateField roads_Merge JURISDICT [COMMUNITY] VB # CalculateField roads_Merge CLASS [FUNC_CLASS] VB # CalculateField roads_Merge LABELING [FULLSTREET] VB # CalculateField roads_Merge DIRECT [PREFIX] VB # CalculateField roads_Merge FRADDL [L_F_ADD] VB # CalculateField roads_Merge TOADDL [L_T_ADD] VB # CalculateField roads_Merge FRADDR [R_F_ADD] VB # CalculateField roads_Merge TOADDR [R_T_ADD] VB # CalculateField roads_Merge CLASS [VESTING] VB # CalculateField roads_Merge STREET LCase( [STREET] ) VB # CalculateField roads_Merge STREET UCase(Left( [STREET],1 )) VB # CalculateField roads_Merge STREET "UCase(Left( [STREET],1 )) & LCase( mid( [NAME],2 ))" VB # CalculateField roads_Merge STREETTYPE "UCase(Left( [STREETTYPE] ,1 )) & LCase( mid( [STREETTYPE] ,2 ))" VB # CalculateField roads_Merge STREETNAME "[STREET]& " " & [STREETTYPE]" VB # CalculateField roads_Merge ADDED 12/2/2015 VB # CalculateField roads_Merge ADDED "" VB # CalculateField roads_Merge UPDATED 12/02/2015 VB # CalculateField roads_Merge UPDATED "December 2015" VB # CalculateField roads_Merge UPDATED "12/2015" VB # CalculateField roads_Merge ADDED "LS" VB # CalculateField roads_Merge ADDED "" VB # CalculateField roads Z_100000 "minor" VB # CalculateField roads Z_24000 "minor" VB # CalculateField roads HWY_NUM "" VB # CalculateField roads HWY_NUM "" VB # CalculateField roads HWY_NUM "" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_24000 "major" VB # CalculateField Roads Z_24000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_24000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads Z_24000 "major" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "minor" VB # CalculateField Roads Z_100000 "major" VB # CalculateField Roads HWY_NUM "" VB # CalculateField roads JURISDICT "ORO" VB # CalculateField roads JURISDICT "ORO" VB # FeatureClassToFeatureClass E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp "Database Connections\gisvm-sql-01.LIVE.gis.sde" Base_RoadsNEW # "OBJECTID_1 "OBJECTID_1" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,OBJECTID_1,-1,-1;OBJECTID "OBJECTID" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,OBJECTID,-1,-1;STREET "STREET" true true false 30 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,STREET,-1,-1;STREETTYPE "STREETTYPE" true true false 8 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,STREETTYPE,-1,-1;STREETNAME "STREETNAME" true true false 45 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,STREETNAME,-1,-1;HIERARCHY "HIERARCHY" true true false 20 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,HIERARCHY,-1,-1;HWY_NUM "HWY_NUM" true true false 3 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,HWY_NUM,-1,-1;Z_100000 "Z_100000" true true false 16 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,Z_100000,-1,-1;Z_24000 "Z_24000" true true false 16 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,Z_24000,-1,-1;FRADDL "FRADDL" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,FRADDL,-1,-1;TOADDL "TOADDL" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,TOADDL,-1,-1;FRADDR "FRADDR" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,FRADDR,-1,-1;TOADDR "TOADDR" true true false 10 Long 0 10 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,TOADDR,-1,-1;ADDED "ADDED" true true false 5 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,ADDED,-1,-1;Shape_Leng "Shape_Leng" true true false 19 Double 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,Shape_Leng,-1,-1;UPDATED "UPDATED" true true false 10 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,UPDATED,-1,-1;JURISDICT "JURISDICT" true true false 25 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,JURISDICT,-1,-1;RAMP "RAMP" true true false 10 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,RAMP,-1,-1;DIRECT "DIRECT" true true false 15 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,DIRECT,-1,-1;STATUS "STATUS" true true false 15 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,STATUS,-1,-1;ROAD_NO "ROAD_NO" true true false 10 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,ROAD_NO,-1,-1;FR_MILE "FR_MILE" true true false 19 Double 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,FR_MILE,-1,-1;TO_MILE "TO_MILE" true true false 19 Double 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,TO_MILE,-1,-1;LENGTH_MI "LENGTH_MI" true true false 19 Double 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,LENGTH_MI,-1,-1;TEMP_ "TEMP_" true true false 50 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,TEMP_,-1,-1;LABELING "LABELING" true true false 35 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,LABELING,-1,-1;MAJOR "MAJOR" true true false 20 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,MAJOR,-1,-1;CLASS "CLASS" true true false 6 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,CLASS,-1,-1;SURFACE "SURFACE" true true false 6 Text 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,SURFACE,-1,-1;Shape_Le_1 "Shape_Le_1" true true false 19 Double 0 0 ,First,#,E:\Temp\PW_BackupMay2017\Maintained_Roads\roads.shp,Shape_Le_1,-1,-1" # CalculateField Roads JURISDICT "ORO" VB # ChangePrivileges 'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_Bridges';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_ExistingBikeRoute';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_MaintainedRoads';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_RoadDistricts';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_RoadSigns';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_Speed_Zones';'Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.DeptPW_StreetLights' PW_Edit GRANT GRANT UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685471344f5844714f346a6871592b38726c74533632673d3d2a00;SERVER=gisvm-sql-01;INSTANCE=sde:sqlserver:gisvm-sql-01\gis_data;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisvm-sql-01\gis_data;DATABASE=PWwork;USER=pwowner;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PWwork.PWOWNER.Base_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>OBJECTID_1</field_name><field_name>OBJECTID</field_name></DeleteField></workflow></operationSequence> CalculateField Main\Roads LENGTH_MI "[Shape.STLength()] /5280" VB # FeatureClassToFeatureClass "Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads" \\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb base_roads # "STREET "STREET" true true false 30 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,STREET,-1,-1;STREETTYPE "STREETTYPE" true true false 8 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,STREETTYPE,-1,-1;STREETNAME "STREETNAME" true true false 45 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,STREETNAME,-1,-1;HIERARCHY "HIERARCHY" true true false 20 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,HIERARCHY,-1,-1;HWY_NUM "HWY_NUM" true true false 3 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,HWY_NUM,-1,-1;Z_100000 "Z_100000" true true false 16 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,Z_100000,-1,-1;Z_24000 "Z_24000" true true false 16 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,Z_24000,-1,-1;FRADDL "FRADDL" true true false 4 Long 0 10 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,FRADDL,-1,-1;TOADDL "TOADDL" true true false 4 Long 0 10 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,TOADDL,-1,-1;FRADDR "FRADDR" true true false 4 Long 0 10 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,FRADDR,-1,-1;TOADDR "TOADDR" true true false 4 Long 0 10 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,TOADDR,-1,-1;ADDED "ADDED" true true false 5 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,ADDED,-1,-1;UPDATED "UPDATED" true true false 10 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,UPDATED,-1,-1;JURISDICT "JURISDICT" true true false 25 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,JURISDICT,-1,-1;RAMP "RAMP" true true false 10 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,RAMP,-1,-1;DIRECT "DIRECT" true true false 15 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,DIRECT,-1,-1;STATUS "STATUS" true true false 15 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,STATUS,-1,-1;ROAD_NO "ROAD_NO" true true false 10 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,ROAD_NO,-1,-1;FR_MILE "FR_MILE" true true false 8 Double 8 38 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,FR_MILE,-1,-1;TO_MILE "TO_MILE" true true false 8 Double 8 38 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,TO_MILE,-1,-1;LENGTH_MI "LENGTH_MI" true true false 8 Double 8 38 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,LENGTH_MI,-1,-1;LABELING "LABELING" true true false 35 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,LABELING,-1,-1;MAJOR "MAJOR" true true false 20 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,MAJOR,-1,-1;CLASS "CLASS" true true false 6 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,CLASS,-1,-1;SURFACE "SURFACE" true true false 6 Text 0 0 ,First,#,Database Connections\gisvm-sql-01.PWWork.Pwowner.sde\PWwork.PWOWNER.Base_Roads,SURFACE,-1,-1" # AlterField \\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads LABELING LABEL Label TEXT 35 NULLABLE false FeatureClassToFeatureClass \\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads "Database Connections\gisvm-sql-01.PWWork.Pwowner.sde" Base_Roads # "STREET "STREET" true true false 30 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,STREET,-1,-1;STREETTYPE "STREETTYPE" true true false 8 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,STREETTYPE,-1,-1;STREETNAME "STREETNAME" true true false 45 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,STREETNAME,-1,-1;HIERARCHY "HIERARCHY" true true false 20 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,HIERARCHY,-1,-1;HWY_NUM "HWY_NUM" true true false 3 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,HWY_NUM,-1,-1;Z_100000 "Z_100000" true true false 16 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,Z_100000,-1,-1;Z_24000 "Z_24000" true true false 16 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,Z_24000,-1,-1;FRADDL "FRADDL" true true false 4 Long 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,FRADDL,-1,-1;TOADDL "TOADDL" true true false 4 Long 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,TOADDL,-1,-1;FRADDR "FRADDR" true true false 4 Long 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,FRADDR,-1,-1;TOADDR "TOADDR" true true false 4 Long 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,TOADDR,-1,-1;ADDED "ADDED" true true false 5 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,ADDED,-1,-1;UPDATED "UPDATED" true true false 10 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,UPDATED,-1,-1;JURISDICT "JURISDICT" true true false 25 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,JURISDICT,-1,-1;RAMP "RAMP" true true false 10 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,RAMP,-1,-1;DIRECT "DIRECT" true true false 15 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,DIRECT,-1,-1;STATUS "STATUS" true true false 15 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,STATUS,-1,-1;ROAD_NO "ROAD_NO" true true false 10 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,ROAD_NO,-1,-1;FR_MILE "FR_MILE" true true false 8 Double 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,FR_MILE,-1,-1;TO_MILE "TO_MILE" true true false 8 Double 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,TO_MILE,-1,-1;LENGTH_MI "LENGTH_MI" true true false 8 Double 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,LENGTH_MI,-1,-1;LABEL "Label" true true false 35 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,LABEL,-1,-1;MAJOR "MAJOR" true true false 20 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,MAJOR,-1,-1;CLASS "CLASS" true true false 6 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,CLASS,-1,-1;SURFACE "SURFACE" true true false 6 Text 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,SURFACE,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,\\bci\countyshare\GIS\Temp\PW\KGoff\Temp.gdb\base_roads,Shape_Length,-1,-1" # Server=gisvm-sql-01; Service=sde:sqlserver:gisvm-sql-01\GIS_data; Database=Live; User=GIS; Version=dbo.DEFAULT ArcSDE Connection PWwork.PWOWNER.Base_Roads 002 0.000 6547475.547235 6812834.288826 2217691.868083 2552435.028647 1 Projected GCS_North_American_1983 NAD_1983_StatePlane_California_II_FIPS_0402_Feet <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/10.6'><WKT>PROJCS["NAD_1983_StatePlane_California_II_FIPS_0402_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-122.0],PARAMETER["Standard_Parallel_1",38.33333333333334],PARAMETER["Standard_Parallel_2",39.83333333333334],PARAMETER["Latitude_Of_Origin",37.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2226]]</WKT><XOrigin>-115211800</XOrigin><YOrigin>-93821500</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102642</WKID><LatestWKID>2226</LatestWKID></ProjectedCoordinateSystem> Linear Unit: Foot_US (0.304801) 1.0 INSPIRE Metadata Directive 150000000 5000 Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270 Map 6547475.547235 6812834.288826 2552435.028647 2217691.868083 1 -122.050775 -121.101367 40.170715 39.248388 1 002 1 -122.050775 -121.101367 40.170715 39.248388 All County Roads Highways Roads Streets ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset 002 file:// Local Area Network 2.737 SDE Feature Class SDE Feature Class 0.000 NAD_1983_StatePlane_California_II_FIPS_0402_Feet EPSG 5.3(9.0.0) 0 20190417 /9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3X60n6Uv0oA9eaQBjIIzVYo6S5XB4/wAatCmMR53Xqv8AWkBWE/7zawwc81O4JGVOPXFQ3S5Abv0qS3YsoP4GpT1sJb2FRi+csM+g7UpLAcY6d6R433fK21fQCmyZRNzkBenWqGVJ1ZpHbywcDPB9qgjspZ1GfkRjn61bdTMNqgxxfxMwxn2AodgQdnCKMFmOAPapcUKxXZWjGCUwPWmiRU2lmAwe3eiZ4sqCxZs9BxVWQhtreo4xzWMtNhPQliSOZnkbOSThRwceufWp3tkCBtxZx03GmRIAMAlW9R0rI1PxZp+lXjWjrNJIvMhQZwfTmqhCVR2irmc6kILmm7Gi2A3CLnuTxWbq+tQaVbpNLC8itJtAUjrisO/8bxGMiwtnDnPzSnp+Arkrm9ubwqbieSXb03tnFdNDASbvU2OGvjoJWp6s9RtpvttpDcoiKJEDDd1GatKoU5JyT/FiuT8I61LcP/Z85j2xxgRdicdvfj+VdZ5saHBUsQecZrlr0nSm4s66FVVYKSLQwI1kViADyKrxn97JgnLcgmmSylrclVwPQVAZ47dCSSW9zWalZmr1HsXXJ3ZCtnJNWBN/FuyR71VVpZwX2BFPALdT+FOkCxIO7HAFS9NgRLJI2V+fk84BqwYy+dgRsjg7sY/DFVHZd44yfQ0+FjLd7Yy2xfvc8duKqDGmB090jLMy9fug5+lFaTxo8Jjz1oqpU77DsXBS8CmLuJ5p9dRQtRt/rkP+yf6VJmmP95D/ALX9DQBHOoMZ9uaZbkiFgpAOepqWXmI1WhiilciSNWOO4qeoupZxKwGWjI78dagZHWTcxZj2IGcfT0qeO1ggbdFCiH/ZGKSePzgFLMMc/KcZqhkJi/iZWb8QPzOapzTKZCrtkKMhV+6KseRDnc29T67s8Uu5dp2IqjHHHJ96mS0EZ6RB/mfn2JqQQbSGxzjAJNI78jK5LH5eamnkVI4icc9DnuK59ySjdXcdnbyS3D+XCpyWJ/T9K8v1e9j1DVZ7qJGRJCMBuvTFdd44vEGnQWyyNvlk8zaOhQZ6/jXB162BoqMOfqzx8wrOUvZrZBRRT4gGlRW+6WANdx551vhTS0iVdSmkXDqQg2nKHOCc/h+tdUbm2VQiMfwzzU0UUYgijQ/u1VVXnqMf4VFcMqIeC2T0PFfOV6jqTcmfRUaSpQUURvcbUdhg4XIFKkUSxrNdMGfqB2H0FPjtVKEvyWXBUdvbNPaON5AWjzt6DPFZLQ1IzcyHOxQ6542elKsgZtzld2MgZ6fU1YIBQIAAP7p6UzESLyiYHOMZpAQxwPISd21T1b1/OrC4X93GhRV45/z1pH3Snrx3ocOW3g5GckdMU1toMU3D5KgHOev/ANeimkkkE9D0GMUUXYjoKXn8KTFLXcaC0yQ/Kv8AvClyM0yXBQem4fzpAL5sSnDSID6FhVbIW5445qwYImHzRI31GagkAjnDNn1oYpFoEvz0HpTgMVFGQRuU5PcVIjq6hlPHvTTuMr3EYGWJIB646/hUUkjMNhACkcrnJ+n0q27LtJOePas8SQM20yEDrtClc/U0gI5mhiSW6mx5MSk9Ovqa8p17W5tZvmcswtkJEMR4CCu48V65aW+kS2qzB5rhCFWMg4Hv6V5lXbhKSV5tHj5jWu1Ti9OoUUUV3HlhT4k8yZI843MBn60yrFl9m+2Rfa2kW3z85i+8PpSew1uj1gQGzhijyWSJQg45OAOaqFGubnYPlVPmY46VaadZbK0it5GwyqQW+8wwME0jwooIkkLM5G7A/Svmpr3j6dWsrD0MRAPmEqvy5DdcfTrTjjqox6Z//XUJjh242kADoaQHy2JdjkcKqqcU0nLRA5JbjpWZOuOf1pyRZTexwehJ60xk3SrIycDhc9zVgEgYJ4FR6gM2yMQFMYXqSxI/pVnakYCujuv95RxVclmUbefWkYlZACflPOM96qMkugyzJCyknquc+pFFRi4MibQBtHr1zRQ2mBtUdaqXbzrA5hwMA5J69O1VtNmuJpG3SbkHXPXP+Fdi1VynJJ2NMZJNMdSNuT/EP50F3Vvubl9QaQypIAFPIYZHcUrDuTVT1RrdLCV7nHlKpL56bcc1bzUNzH5sDKACSO4yKBPVHiOpalNqGozXTORvbgLwAOg/SqvnSj/lo/8A30a0tZ0K90ly9yqeW8hVGQ8N34HpzWVXsx5Wvd2Pl5qak+bceZpT1kf/AL6NJvf+83502iqI1CiiigAooooAKKKKAOq0TxQ0ckVvdjqBEs2QNg6ZPbAFdpFGXYSNIzD+ElePrXkNdt4Y8RGWM2V5KPMHKPI/3v8AZrzMZhFbngvU9TB4t39nUfodYu0kk5x2wP1qTKg/L1PvUAfLYUE4HNNkk8qMuwyScAV5SbWx6g6UgDf8529s0odVXJdR65qqblm2okZchc4HSlWF3j+cbBkd+TSAlN5hykSFz0H1pjQ3DFd7J1yfWnRr5ROyMYPdWqUGVmB24GKAGrGcN5rKEPRQeWop0+VQOAM9OT0oquZx0QGy7qUZRycYwPekt4Ft13Ywx6gVIqhBtQYH0qRa7S7a3Yv86ilONrY53dvoamqOTgp/vf0NIZHHPvYL5Ug92XA/OpgR34p3tSdzQByvi7wy2tiOWCby5YwcBs7T/h9a8vuLK5tP9fBJGNxQFlwCR1Fe8EYx9cYrmvF9hFNol1MG/eJESobkAZBPHqcda6aFdxai9jzsXg4zTqR0Z5LRRRXpHiBRRRQAUUUUAFFFFABRRRQB22g+II7qP7NduscqjhiQqso4xnPWt6NPtMgJXbEpJPvXlisVYMpwQcg16H4V1JdUs1tZpyblAS4K4yM8c15OMwij+8gevg8U5/u57m7uALBF5HoKdyeuBUjQiIbVOSRxgVXlAEmwNkY+Z815tmejawuWbAUbsdB6mlAG478sScYBp0L7VARML2AFISJSwySAeSP4vaqtG10CvfUOHyCo2LwFHb/69FQzvuR4olJ4wdtFTcDowKcKbuFKpzXcaDqY+Mr/AL39KcelRufmT6/0pAS+/am55oJwBzTMlvYUAEmdhwcEDOTXlHiy9uWeK0m1NLwqWL7Iwmxs4wcV6rM/lwOxHQZrw/U54LnU7ie2R0hkcsquckZ6/rmurCK8m+x5uZTtBLuVKKKK9E8UKKKKACiiigAooooAKKKKACpLeeS1uI54jh42DKfcVHRQM9N0vW/7btvMSMxMCEfvzjJxWjGgb5VG1BycnOa8tsNUvNNk320xUckqeVP1FejaLqi6ppqTbWR921x05AGce3NeJi8M6b5l8J7eFxSqrll8RoBssQgYnoWPSonbnyUPu5A6CpWOECZwMZJPao1hGws+RuP3RXEzsGhxHCWVcYHCjpRSs24sqcYUnp3opAdD3xSr9KYDl/1qQEZ54NdxoBGRURGZV9ApP8qkyfWoZgcryQMFT2xmgCViMYHX+VHSoI4PKbIklYZJwWzU3UdaTEV78yCymMX+sCErxnnHHHevDHxvbGSMnGRg17xNnyW5rMsfDmlWwaVLCEyMSSzjd/PpXRQrKkndbnFi8NKu1Z2seMUV7XqENtYaZdXUNjbs8UbOF8ockD6V4xPM9zcSTyY3yMWOBgZNdtGt7W7seXicP7Cybvcjooorc5QooooAKKKKACiir2j2Q1HVYLVg21yd204OAMmlJqKbZUU5NJdSjRXokXgOzivo5/tDPApBMMiA7vUZyP5VbuvDWkTwmJbRYtxyHj4YY965JY6kmdiy+q072Oe8OeG4p7a31S4nYYfekaY5we/4iuwMjSTgjn5f1/yKigsIbZVtYlPkQKFAJ79fzqVYlU8Fs9MDpXlYitKrO726HqUKKpQsvmPRVLAudxA69hUckg6r8zZwBUhtlX75Ldh83SgLGmANox0PesGrG5XWOZmkBXYrHGSeg+lFShlG8HLbmJxRRcRuQcu3J4/Wpc9/eq0RIkbnAJ7DrVk5zz0rtWxoLjpUMx4J9CD+tSgfKfaq1ySkDHDNnHC0hMmDqTgHNB+U/WqFrdJJOAis3Y9OK0GHSkkK9yKU/uSD606D/Ve1MlHygVLBxHijqC3K2p7BpV55oynkvuGccYNeGV674xvhZ6BcjcAZU8sA9yxx/LJ/CvIq9HBr3Wzx8yknNIKKKK7DzQooooAKKKKACvRfBmhpbaeuotuNxcrtXnhEz1/SvPYozLKka/edgo+pr2PRtOTSNMis1maULkl2PfPOPQZrjxk7Q5e56GXU+ao5NbFtwwcIp69z2FVJ45A5IBfHfrVsMzTseAoHWmzr5aALk4x04ryJK+p7RnvIVdTscBui8cmnRbsgyKygdyOv4U4KnllypyT/AHjTgMIGALdgeuKdRR3W5nG/UZISz8Eqvb1NNbYvJLHH6U8q8jYzjjsOah+zRqG3M7A9nfismiiITZYAFYwfU/Mf60VPHACSYVCr/eAx+tFFkOxrQsfOK9gKtldy5JNFFdkdixvVGqK4TdBIhJwRiiihiKtnpYtLkyid3OMYYCrrHO3jrRRQiURTn7oqRPuD6UUVC3KOT+IcgXw7FlAxecYJ/h4PSvMKKK9XCfwzwsw/j/JBRRRXScIUUUUAFFFFAHQeDdPj1DxHbrIcLEWkAxnJA4/XmvV2QRoUXgKMCiivOxnxpHuZckqN/MWJAq4FMkiEyEEke4oorgZ39CrHbxyySO4yFwAvb1q2UCgAcUUUWEhrLyduASOuM+tVbqzhyAVyQ2c9zRRTklYbIJ5MAhAF9O+KKKK5pbkM/9k=