View In:
ArcGIS Online Map Viewer
Name: MTA.DPH_ped_hin_archive
Display Field: STREET_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: | A. PURPOSE | This data was created by the San Francisco Department of Public Health to identify street segments and intersections in San Francisco that have a high number of pedestrian fatalities and severe injuries. As of 2014, this network is being used to inform Vision Zero.| B. METHODOLOGY | Pedestrian high injury corridors were originally derived from 2005-2009 Statewide Integrated Traffic Records System (SWITRS) injury records. All pedestrian injuries resulting from a collision between a vehicle and a pedestrian were used in the analysis, for a total of 3,883 pedestrian injuries (383 of which were severe) and 97 fatalities (16 pedestrian injuries were not able to be geocoded).For this analysis, severe and fatal injuries were weighted by multiplying those counts times 3 while complaints of pain and visible injury were assigned a count of 1. Weighted injuries were then aggregated at an intersection level (based on primary and secondary streets in SWITRS) and then assigned their adjoining street segments. Potential high injury density corridors were defined by first identifying street segments with weighted counts =>9 and then assessing whether there was a linear pattern of higher injury counts proximate to those segments and following the street network. A kernel density geoprocessing tool that takes into account the area density of the mapped, weighted injuries served as a qualitative check that area-level concentrations of injury were captured.These high injury corridors were revised in 2013 using SWITRS injury records from 2010 and 2011. With the additional two years of data there were a total of 5,452 pedestrian injuries, out of which 127 were fatalities (48 pedestrian injuries were not able to be geocoded and were thus excluded from the analysis). New HICs and HIC extensions were identified by assessing both absolute changes in injury density from 2005-2009 compared to 2007-2011 as well as segment-level weight injury counts for 2007-2011 compared to 2005-2009. The data was split into two overlapping groups of 5-year periods to account for the small sample of size of injuries occurring per year and associated issues with respect to random variation and regression to the mean. In addition, intersections a relatively high rate of (pedestrian injuries/pedestrian volumes), were identified using pedestrian volumes estimated from a pedestrian volume model developed for San Francisco. The HIPIs identified have a weighted total pedestrian injury count >=4 and a pedestrian crossing risk (weighted total pedestrian injuries / pedestrian volume) >= 3 injuries annually per 1 million walk trips (intersections in the 97thpercentile and higher of all intersections with an estimated pedestrian crossing risk, utilizing injury data from 2005-2011). Also identified were intersections with a relatively higher number of pedestrian injuries that were not located on HICs. These intersections had a total of 9 or more weighted total pedestrian injuries from 2005-2011. http://www.sfhealthequity.org/component/jdownloads/finish/8-transportation/280-identifying-high-pedestrian-injury-corridors-for-targeted-safety-improvements/0?Itemid=0| C. UPDATE FREQUENCY | This dataset will be updated in 2015/16 using 2009-2013 injury when available from SWITRS. This update schedule is tentative and pending approval from the MTA/DPH. Please contact Devan Morris (devan.morris@sfdph.org) to inquire about the latest pedestrian high injury network.| D. OTHER CRITICAL INFO | This is one of three networks that make up the Vision Zero High Injury Network. All injury data was geocoded to the nearest intersection for this analysis and available on www.transbasesf.org. A complete methodology is available here: http://bit.ly/1QQxU79.| E. ATTRIBUTES |OBJECTID: Unique record identifier;geom: PostGIS/ArcGIS geometry identifier;cnn_sgmt_pkey: This attribute is the same as Centerline Network Number Unique ID (CNN) found in other road network feature classes throughout the city;street_name: Street name excluding prefix and suffix;street_type: Street suffix;street_layer: SFDPW street classification;full_street_name: Full street name including suffix;class_code: Class code used for symbolizing;gis_length_miles: Street length representing duel carriage ways as one street segment instead of two;duel_car_way_yn: Street is represented as a duel carriage way;duel_car_way_id: Unique ID assigned for each side of a duel carriage way;corrected_length_miles: Street length representing duel carriage ways as one street segment instead of two;f_node_cnn_intrsctn_fkey: Unique intersection ID at start of street segment;t_node_cnn_intrsctn_fkey: Unique intersection ID at end of street segment;shape_length: Object length created by ArcGIS;sgmt_ped_hgh_injry_crrdr_pkey: Unique identifier used by TransBASE;hic_code: Unique code created for each pedestrian high injury corridor;hic_name: Name of each pedestrian high injury corridor;cross_street_1: Starting cross street for pedestrian high injury corridor;cross_street_2: Ending cross street for pedestrian high injury corridor;geom_Length: Object length created by ArcGIS
Copyright Text: | A. CUSTODIAN | Devan Morris, devan.morris@sfdph.org, Population Health, San Francisco Department of Public Health;
Megan Wier, megan.wier@sfdph.org, Population Health, San Francisco Department of Public Health
| B. CREATED | 20131213
| C.VERSIONS |
20110601, Devan Morris/Megan Wier (Department of Public Health);
20131213, Devan Morris/Megan Wier (Department of Public Health) – see complete methodology for additions
Default Visibility: false
MaxRecordCount: 10000
MaxSelectionCount: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Supports Datum Transformation: true
Extent:
XMin: 5980443.055562523
YMin: 2085856.2264928012
XMax: 6017051.291890054
YMax: 2122419.8668279764
Spatial Reference: 102643
(2227)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSLSSolid
Color: [227, 121, 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
CNN_SGMT_PKEY
(
type: esriFieldTypeInteger, alias: cnn_sgmt_pkey, editable: true, nullable: true, defaultValue: null, modelName: cnn_sgmt_pkey
)
-
STREET_NAME
(
type: esriFieldTypeString, alias: street_name, editable: true, nullable: true, length: 29, defaultValue: null, modelName: street_name
)
-
STREET_TYPE
(
type: esriFieldTypeString, alias: street_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: street_type
)
-
STREET_LAYER
(
type: esriFieldTypeString, alias: street_layer, editable: true, nullable: true, length: 16, defaultValue: null, modelName: street_layer
)
-
FULL_STREET_NAME
(
type: esriFieldTypeString, alias: full_street_name, editable: true, nullable: true, length: 36, defaultValue: null, modelName: full_street_name
)
-
CLASS_CODE
(
type: esriFieldTypeString, alias: class_code, editable: true, nullable: true, length: 1, defaultValue: null, modelName: class_code
)
-
GIS_LENGTH_MILES
(
type: esriFieldTypeDouble, alias: gis_length_miles, editable: true, nullable: true, defaultValue: null, modelName: gis_length_miles
)
-
DUEL_CAR_WAY_YN
(
type: esriFieldTypeString, alias: duel_car_way_yn, editable: true, nullable: true, length: 254, defaultValue: null, modelName: duel_car_way_yn
)
-
DUEL_CAR_WAY_ID
(
type: esriFieldTypeInteger, alias: duel_car_way_id, editable: true, nullable: true, defaultValue: null, modelName: duel_car_way_id
)
-
CORRECTED_LENGTH_MILES
(
type: esriFieldTypeDouble, alias: corrected_length_miles, editable: true, nullable: true, defaultValue: null, modelName: corrected_length_miles
)
-
F_NODE_CNN_INTRSCTN_FKEY
(
type: esriFieldTypeInteger, alias: f_node_cnn_intrsctn_fkey, editable: true, nullable: true, defaultValue: null, modelName: f_node_cnn_intrsctn_fkey
)
-
T_NODE_CNN_INTRSCTN_FKEY
(
type: esriFieldTypeInteger, alias: t_node_cnn_intrsctn_fkey, editable: true, nullable: true, defaultValue: null, modelName: t_node_cnn_intrsctn_fkey
)
-
SHAPE_LENGTH
(
type: esriFieldTypeDouble, alias: shape_length, editable: true, nullable: true, defaultValue: null, modelName: shape_length
)
-
SGMT_PED_HGH_INJRY_CRRDR_PKEY
(
type: esriFieldTypeInteger, alias: sgmt_ped_hgh_injry_crrdr_pkey, editable: true, nullable: true, defaultValue: null, modelName: sgmt_ped_hgh_injry_crrdr_pkey
)
-
HIC_YN
(
type: esriFieldTypeString, alias: hic_yn, editable: true, nullable: true, length: 50, defaultValue: null, modelName: hic_yn
)
-
HIC_CODE
(
type: esriFieldTypeInteger, alias: hic_code, editable: true, nullable: true, defaultValue: null, modelName: hic_code
)
-
HIC_NAME
(
type: esriFieldTypeString, alias: hic_name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hic_name
)
-
CROSS_STREET_1
(
type: esriFieldTypeString, alias: cross_street_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cross_street_1
)
-
CROSS_STREET_2
(
type: esriFieldTypeString, alias: cross_street_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cross_street_2
)
-
CREATED_USER
(
type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE
)
-
LAST_EDITED_USER
(
type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER
)
-
LAST_EDITED_DATE
(
type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE
)
-
Shape__Length
(
type: esriFieldTypeDouble, alias: GEOM.LEN, editable: false, nullable: true, defaultValue: null, modelName: GEOM.LEN, required: true
)
Templates:
-
Name: MTA.DPH_ped_hin_archive
Description:
Prototype:
CROSS_STREET_1: null
CROSS_STREET_2: null
CNN_SGMT_PKEY: null
STREET_NAME: null
STREET_TYPE: null
STREET_LAYER: null
FULL_STREET_NAME: null
CLASS_CODE: null
GIS_LENGTH_MILES: null
DUEL_CAR_WAY_YN: null
DUEL_CAR_WAY_ID: null
CORRECTED_LENGTH_MILES: null
F_NODE_CNN_INTRSCTN_FKEY: null
T_NODE_CNN_INTRSCTN_FKEY: null
SHAPE_LENGTH: null
SGMT_PED_HGH_INJRY_CRRDR_PKEY: null
HIC_YN: null
HIC_CODE: null
HIC_NAME: null
Drawing Tool: esriFeatureEditToolLine
Capabilities: Query
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata