Name: Philly Streets Paving Plan 2015

Display Field: PROJECTNUM

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: 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

Copyright Text: Andrew Newell, Lead GIS Analyst | City of Philadelphia, Streets Department | 1401 JFK Blvd. MSB Suite 880 | andrew.newell@phila.gov | 215-686-5036

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -75.27253745430836
YMin: 39.88388210251764
XMax: -74.96878442917594
YMax: 40.13911435549332
Spatial Reference: 4269  (4269)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PROJECTNUM ( type: esriFieldTypeString, alias: PROJECTNUM, length: 30 )
• PROJECTNAM ( type: esriFieldTypeString, alias: PROJECTNAM, length: 100 )
• PWDEXPORT ( type: esriFieldTypeString, alias: PWDEXPORT, length: 1 )
• BIDNUMBER ( type: esriFieldTypeString, alias: BIDNUMBER, length: 20 )
• FUNDING ( type: esriFieldTypeString, alias: FUNDING, length: 10 )
• SEG_ID ( type: esriFieldTypeString, alias: SEG_ID, length: 10 )
• YEAR ( type: esriFieldTypeDouble, alias: YEAR )
• ESRI_OID ( type: esriFieldTypeSmallInteger, alias: ESRI_OID )
• SHAPE_Leng ( type: esriFieldTypeDouble, alias: SHAPE_Leng )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata