20200122 04342300 1.0 FALSE PavementLine 002 3085500.109641 3156074.645657 1650334.409757 1702652.718506 1 Relationship Relationship rPavementLine_has_ROWSidewalks Relationship rPavementLine_has_ROWCrosspans Relationship rPavementLine_has_ROWMedians Relationship rPavementLine_has_ROWRamps Relationship rPavementLine_has_ROWCurbGutters rNeighborhood_has_PavementLines Relationship rROWCookieCutter_has_PavementLine Relationship Projected GCS_North_American_1983_HARN Linear Unit: Foot_US (0.304801) NAD_1983_HARN_StatePlane_Colorado_Central_FIPS_0502_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.3'><WKT>PROJCS[&quot;NAD_1983_HARN_StatePlane_Colorado_Central_FIPS_0502_Feet&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;,3000000.000316083],PARAMETER[&quot;False_Northing&quot;,999999.999996],PARAMETER[&quot;Central_Meridian&quot;,-105.5],PARAMETER[&quot;Standard_Parallel_1&quot;,38.45],PARAMETER[&quot;Standard_Parallel_2&quot;,39.75],PARAMETER[&quot;Latitude_Of_Origin&quot;,37.83333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2877]]</WKT><XOrigin>-118767900</XOrigin><YOrigin>-94525500</YOrigin><XYScale>3048.0060960121928</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>2877</WKID><LatestWKID>2877</LatestWKID></ProjectedCoordinateSystem> 20191216 16320400 20191216 16320400 150000000 5000 ItemDescription Version 6.2 (Build 9200) ; Esri ArcGIS 10.3.1.4959 PavementLine 1 -105.196494 -104.944841 39.762195 39.617653 Public pavement segments maintained by the City of Lakewood PW STM division. Represents built throughfares within the Lakewood city boundary which have been paved for motor vechile conveyance. In total, there are 4876 records. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>PavementLine is a polyline feature class. Pavement records orginiated from the prod geodatabase and underwent editing to represent pavement records according to a PWs legacy spreadsheet. The geometry came from prod.GIS.Roads for all records before any manipulation. The spreadsheet determined the functional classification (collector, arterial, local) of each street segment. Collectors and arterials were merged into one single feature depending on the start and stop location of the spreadsheet, while local streets represent pavement segments between each intersection. After determining the spatial extent of each feature, the PWs legacy spreadsheet with maintanance history (overlay, reclamite, crackseal, and concrete dates) was joined based on the GIS LINK in the spreadsheet and LgRd_ASSET_ID in GIS. The ouput feature class was a layer with the correct spatial extent and maintanace history for each pavement segment. Following, a model built in GIS determined the cg_ToStreet and cg_FromStreet for each record.</SPAN></P><P><SPAN>PavementLine records which have a functional classification of "Local" are associated to a neighorhood for PW to be able to preform work on all pavement segments in one neighorhood at a given time. Additioanlly, "Collectors" and "Arterials" under functional classificaiton do not have a neighborhood association as the entire line segment will be completed as repairs become due. As area is an important attribute for the PW STM division to report, it was calculated using the following equation:</SPAN></P><P STYLE="text-align:Center;"><SPAN>cg_AreaSqFt = cg_LengthFt* LgSs_AVG_WIDTH_FT</SPAN></P><P><SPAN>The cg_AreaSqFt was then divided by 9 to calculate cg_AreaSqYd.</SPAN></P></DIV></DIV></DIV> City of Lakewood, Colorado PW STM Pavement Feature Class dataset EPSG 8.6.2 4876 Simple FALSE 4876 TRUE FALSE PavementLine Feature Class 4876 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. cg_CartegraphID cgCartegraphID Integer 4 10 0 cg_Description cgDescription String 254 0 0 cg_Street cgStreet String 255 0 0 cg_FromStreet cgFromStreet String 50 0 0 cg_ToStreet cg_ToStreet String 50 0 0 cg_FunctionalClassification cgFunctionalClassification String 50 0 0 cg_PavementClassification cgPavementClassification String 50 0 0 cg_Neighborhood_fk cg_Neighborhood_fk String 50 0 0 cg_Area cgArea Double 8 38 8 cg_Area_unit cgArea_unit String 10 0 0 cg_Area_source cgArea_source String 25 0 0 cg_Width cgWidth Double 8 38 8 cg_Width_unit cgWidth_unit String 10 0 0 cg_Width_source cgWidth_source String 25 0 0 cg_Length cgLength Double 8 38 8 cg_Length_unit cgLength_unit String 10 0 0 cg_Length_source cgLength_source String 25 0 0 cg_NumberofLanes cgNumberofLanes Integer 4 10 0 cg_Subdivision cgSubdivision String 50 0 0 cg_RightOfWayWidth cgRightOfWayWidth Double 8 38 8 cg_RightOfWayWidth_unit cgRightOfWayWidth_unit String 10 0 0 cg_RightOfWayWidth_source cgRightOfWayWidth_source String 25 0 0 cg_SpeedZone cgSpeedZone Double 8 38 8 cg_SpeedZone_unit cgSpeedZone_unit String 10 0 0 cg_Retired cgRetired Date 36 0 0 cg_Replaced cgReplaced Date 36 0 0 cg_Installed cgInstalled Date 36 0 0 cg_TotalCost cgTotalCost Double 8 38 8 cg_ConditionGroup cgConditionGroup String 150 0 0 cg_Jurisdiction cgJurisdiction String 35 0 0 cg_Notes cgNotes String 500 0 0 cg_EstimatedOCI cgEstimatedOCI Double 8 38 8 cg_PredictionGroup cgPredictionGroup String 50 0 0 cg_LocationDescription cgLocationDescription String 500 0 0 cg_EstimatedOCR cgEstimatedOCR String 50 0 0 cg_EstimatedCCR cgEstimatedCCR String 50 0 0 cg_CriticalityFactor cgCriticalityFactor Double 8 38 8 cg_CurrentInspectionID cgCurrentInspectionID String 50 0 0 cg_EstimatedCCI cgEstimatedCCI Double 8 38 8 cg_ActBefore cgActBefore Date 36 0 0 cg_CurrentInspectionDate cgCurrentInspectionDate Date 36 0 0 cg_CurrentInspectionOCI cgCurrentInspectionOCI Double 8 38 8 cg_CurrentInspectionOCR cgCurrentInspectionOCR String 50 0 0 cg_CurrentInspectionNotes cgCurrentInspectionNotes String 500 0 0 lgRd_UNIQUE_ID lgRd_UNIQUE_ID Integer 4 10 0 lgRd_PREFIX lgRd_PREFIX String 2 0 0 lgRd_STREETNAME lgRd_STREETNAME String 48 0 0 lgRd_STREETTYPE lgRd_STREETTYPE String 4 0 0 lgRd_SUFFIX lgRd_SUFFIX String 2 0 0 lgRd_FULLNAME lgRd_FULLNAME String 80 0 0 lgRd_CLASS lgRd_CLASS String 4 0 0 lgRd_SNOW_ROUTE lgRd_SNOW_ROUTE String 8 0 0 lgRd_COMMENT1 lgRd_COMMENT1 String 200 0 0 lgRd_COMMENT2 lgRd_COMMENT2 String 200 0 0 lgRd_ASSET_ID lgRd_ASSET_ID String 24 0 0 lgRd_ClassDescription lgRd_ClassDescription String 50 0 0 lgSs_LINE lgSs_LINE Integer 4 10 0 lgSs_CLASS lgSs_CLASS String 1073741822 0 0 lgSs_STREET lgSs_STREET String 1073741822 0 0 lgSs_FROM lgSs_FROM String 1073741822 0 0 lgSs_TO lgSs_TO String 255 0 0 lgSs_CENTER_LINE_MILES lgSs_CENTER_LINE_MILES Double 8 38 8 derv_CENTER_LINE_MILES_DivSegCo derv_CENTER_LINE_MILES_DivSegCo Double 8 38 8 lgSs_TOTAL_LANE_MILES lgSs_TOTAL_LANE_MILES Double 8 38 8 derv_TOTAL_LANE_MILES_DivSegCou derv_TOTAL_LANE_MILES_DivSegCou Double 8 38 8 lgSs_AVG_WIDTH_FT lgSs_AVG_WIDTH_FT Double 8 38 8 lgSs_LENGTH_FEET lgSs_LENGTH_FEET Double 8 38 8 derv_LENGTH_FEET_DivSegCount derv_LENGTH_FEET_DivSegCount Double 8 38 8 lgSs_SQUARE_YARD_PAVEMENT lgSs_SQUARE_YARD_PAVEMENT Double 8 38 8 derv_SQUARE_YARD_PAVEMENT_DivSe derv_SQUARE_YARD_PAVEMENT_DivSe Double 8 38 8 lgSs_LAST_CONCRETE_YEAR lgSs_LAST_CONCRETE_YEAR Date 36 0 0 lgSs_LAST_OVERLAY_YEAR lgSs_LAST_OVERLAY_YEAR Date 36 0 0 lgSs_LAST_RECLAMITE_YEAR lgSs_LAST_RECLAMITE_YEAR Date 36 0 0 lgSs_LAST_CRACKSEAL_YEAR lgSs_LAST_CRACKSEAL_YEAR Date 36 0 0 lgSs_NEXT_CONCRETE_YEAR lgSs_NEXT_CONCRETE_YEAR Date 36 0 0 lgSs_NEXT_OVERLAY_YEAR lgSs_NEXT_OVERLAY_YEAR Date 36 0 0 lgSs_NEXT_RECLAMITE_YEAR lgSs_NEXT_RECLAMITE_YEAR Date 36 0 0 lgSs_NEXT_CRACKSEAL_YEAR lgSs_NEXT_CRACKSEAL_YEAR Date 36 0 0 lgSs_GENERAL_CONDITION lgSs_GENERAL_CONDITION String 900 0 0 lgSs_YEAR_RATED lgSs_YEAR_RATED Integer 4 10 0 lgSs_GISLINK lgSs_GISLINK String 100 0 0 lgSs_Zone lgSs_Zone Integer 4 10 0 derv_SamsNotesForPWs derv_SamsNotesForPWs String 200 0 0 derv_RdSegsCount derv_RdSegsCount SmallInteger 2 5 0 derv_BlockNo derv_BlockNo Integer 4 10 0 derv_BlockName derv_BlockName String 100 0 0 derv_Seg2BlockCount derv_Seg2BlockCount SmallInteger 2 5 0 derv_FutureCartegraphID derv_FutureCartegraphID Integer 4 10 0 created_user created_user String 255 0 0 created_date created_date Date 36 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 36 0 0 GlobalID GlobalID GlobalID 38 0 0 cg_AreaSqFt cg_AreaSqFt Double 8 38 8 cg_AreaSqYd cg_AreaSqYd Double 8 38 8 cg_LengthFt cg_LengthFt Double 8 38 8 cg_WidthFt cg_WidthFt Double 8 38 8 cg_LaneMiles cg_LaneMiles Double 8 38 8 cgOid cgOid String 20 0 0 cgURL cgURL String 255 0 0 gisURL gisURL String 255 0 0 cg_CenterlineMiles cg_CenterlineMiles Double 8 38 8 Shape.STLength() Shape.STLength() Double 0 0 0 20191216