GIS_STREETS.PavingPlan2015
Summary:City of Philadelphia paving plan for 2015 that displays paving project funding, City - Local Funding, City - Federal Funding, and State FundingFeatures updated: 05/01/2015Attributes updated: 05/01/2015Metadata updated 05/01/2015Update Frequency: As NeededPublic = YesLayer NameThe layers shown are query layers based off of a spatial view derived from the Streets Department paving data. The layers are:City - Local FundingCity - Federal FundingStateData Development:These layers were created through the use of a query layer within ArcGIS ArcMap. We accessed our Paving Database and created a spatial layer of the data by connecting our paving data which is in a SQL database to the City's Street Centerline layer to give the Paving data spatial context.Key Attribute Fields:ProjectNumber: Indicates the Project Number that this street segments paving project is under.ProjectName: Identifies what group will be performing the work.PWDExport: Was used to identify projects within the city's Cityworks database.BidNumber: Indicates the Bid Number that the segments paving project fell under.Funding: Identifies who is funding the project.Seg_ID: Indicates the Segment ID for that portion of the road.Year: Identifies the year the project is to take place.Shape: Is used for spatial context and is not something typically used in analysis by usersESRI_OID: A unique ID created in order to query the data within the layer in ArcMapCoordinate systemProjected Coordinate System: NAD_1983_StatePlane_Pennsylvania_South_FIPS_3702_FeetProjection: Lambert_Conformal_ConicFalse_Easting: 1968500.00000000False_Northing: 0.00000000Central_Meridian: -77.75000000Standard_Parallel_1: 39.93333333Standard_Parallel_2: 40.96666667Latitude_Of_Origin: 39.33333333Linear Unit: Foot_USGeographic Coordinate System: GCS_North_American_1983Datum: D_North_American_1983Prime Meridian: GreenwichAngular Unit: DegreeThematic mappingAs this map currently sits, it is based off the Funding field using a definition query ( ex. Funding = 'FEDERAL', Funding = 'STATE', and Funding = 'Local'). Other options for displaying this data would be to base it off the ProjectNumber, ProjectName, or BidNumber fields. Other InformationKeep in mind the three layers you are seeing here are copies of one another and the only difference is the definition query, so each layer is based off of 1 of the 3 different funding options. In order to get a view of all the data, make sure you remove the definition query and/or append the 3 layers together in your own arcmap environment
nan
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'PROJECTNUM', 'type': 'esriFieldTypeString', 'alias': 'PROJECTNUM', 'sqlType': 'sqlTypeOther', 'length': 30, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PROJECTNAM', 'type': 'esriFieldTypeString', 'alias': 'PROJECTNAM', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PWDEXPORT', 'type': 'esriFieldTypeString', 'alias': 'PWDEXPORT', 'sqlType': 'sqlTypeOther', 'length': 1, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'BIDNUMBER', 'type': 'esriFieldTypeString', 'alias': 'BIDNUMBER', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FUNDING', 'type': 'esriFieldTypeString', 'alias': 'FUNDING', 'sqlType': 'sqlTypeOther', 'length': 10, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SEG_ID', 'type': 'esriFieldTypeString', 'alias': 'SEG_ID', 'sqlType': 'sqlTypeOther', 'length': 10, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'YEAR', 'type': 'esriFieldTypeDouble', 'alias': 'YEAR', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ESRI_OID', 'type': 'esriFieldTypeSmallInteger', 'alias': 'ESRI_OID', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__PAVINGPL__F4B70D8595703673', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'user_9886.PAVINGPLAN2015_GIS_STREETS_PAVINGPLAN2015_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}]
nan
{'renderer': {'type': 'uniqueValue', 'field1': 'FUNDING', 'field2': None, 'field3': None, 'fieldDelimiter': ', ', 'defaultSymbol': None, 'defaultLabel': None, 'uniqueValueInfos': [{'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [250, 52, 17, 255], 'width': 2}, 'value': 'FEDERAL', 'label': 'FEDERAL', 'description': ''}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [10, 147, 252, 255], 'width': 2}, 'value': 'Local', 'label': 'Local', 'description': ''}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [255, 170, 0, 255], 'width': 2}, 'value': 'STATE', 'label': 'STATE', 'description': ''}]}, 'transparency': 0, 'labelingInfo': None}
[{'id': 'FEDERAL', 'name': 'FEDERAL', 'domains': {}, 'templates': [{'name': 'FEDERAL', 'description': '', 'drawingTool': 'esriFeatureEditToolLine', 'prototype': {'attributes': {'BIDNUMBER': None, 'ESRI_OID': None, 'PROJECTNUM': None, 'PROJECTNAM': None, 'PWDEXPORT': None, 'FUNDING': 'FEDERAL', 'SEG_ID': None, 'YEAR': None}}}]}, {'id': 'Local', 'name': 'Local', 'domains': {}, 'templates': [{'name': 'Local', 'description': '', 'drawingTool': 'esriFeatureEditToolLine', 'prototype': {'attributes': {'BIDNUMBER': None, 'ESRI_OID': None, 'PROJECTNUM': None, 'PROJECTNAM': None, 'PWDEXPORT': None, 'FUNDING': 'Local', 'SEG_ID': None, 'YEAR': None}}}]}, {'id': 'STATE', 'name': 'STATE', 'domains': {}, 'templates': [{'name': 'STATE', 'description': '', 'drawingTool': 'esriFeatureEditToolLine', 'prototype': {'attributes': {'BIDNUMBER': None, 'ESRI_OID': None, 'PROJECTNUM': None, 'PROJECTNAM': None, 'PWDEXPORT': None, 'FUNDING': 'STATE', 'SEG_ID': None, 'YEAR': None}}}]}]
[]