Description: 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.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:cg_AreaSqFt = cg_LengthFt* LgSs_AVG_WIDTH_FTThe cg_AreaSqFt was then divided by 9 to calculate cg_AreaSqYd.
Description: The Neighborhood feature class is a polygon layer. Originating in the prod geodatabase, this feature class was updated in 2018 with new neighborhoods to include all parts of the city boundary. Previously, there were areas within the city boundary with no neighborhood designation. Therefore, seven new neighborhoods were added (PRK, OPS, KIP, GMT, FED, BCG, and ACD) and previous neighborhoods were spatially updated. The neighborhood feature class is intended to be used for pavement maintance by the City of Lakewood PW STM Division. Collectors and arterials are therefore not associated with any neighborhood polygon as they generally extend past multiple neighborhoods. The STM approach of using neighborhoods with local pavement records is to restore, repair, and rehabilitate all pavement segments within one neighborhood at the same time.