View In:
ArcGIS Online Map Viewer
Name: MTA.DPH_vz_hgh_injry_ntwrk
Display Field: STREET_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: | A. METHODOLOGY |The 2017 Vision Zero High Injury Network is derived from 2013-2015 severe and fatal injury data from Zuckerberg San Francisco General (ZSFG), San Francisco Police Department/Crossroads Software Traffic Collision Database (SFPD), and the Office of the Medical Examiner (OME). ZSFG patient records and SFPD victim records were probabilistically linked through the Transportation Injury Surveillance System (TISS – contact Leilani.Schwarcz@sfdph.orgfor more information) using LinkSolv Software. Injury severity for linked SFPD/ZSFG records was reclassified based on injury outcome as determined by ZSFG medical personnel (net 883 police reported severe injuries) consistent with the Vision Zero Severe Injury Protocol (2017) while unlinked SFPD victim records were not changed (104 police reported severe injuries). Severe injuries captured by ZSFG but not reported to SFPD were also included in this analysis (411 unreported/unlinked severe injury patient records). Fatality data came from OME records that meet San Francisco’s Vision Zero Fatality Protocol (96 fatalities).Only transportation-related injuries resulting in a severe injury or fatality were used in this analysis. Each street centerline segment block was converted into ~0.25 mile overlapping corridorized sections using ArcPy. These sections were intersected with the severe/fatal injury data. Only severe/fatal injuries with the same primary street as the corridorized section were counted for that section. The count of severe/fatal injuries was then normalized by the sections mileage to derive the number of severe/fatal injuries per mile. A threshold of ≥7 severe/fatal injuries per mile was used as the threshold to determine if a corridorized segment qualified for inclusion into the network. Sections of the 2015 Vision Zero High Injury Network that had ≥6 severe/fatal injuries or a fatality in the last 4 year (2013-2016) were included in the updated network as well.2017 VZ High Injury Network Injury Capture by Mode (2013-2015):PedestrianSevere/Fatal Injuries: 77.1% - 404/524 PedestrianAll Injuries: 63.0% - 1675/2659CyclistSevere/Fatal Injuries: 71.1% - 248/349CyclistAll Injuries: 62.8% - 1319/2101VehicleSevere/Fatal Injuries: 74.5% - 450/604:VehicleAll Injuries: 59.5% - 4536/7628All Modes Severe/Fatal Injuries: 74.6% - 1102/1477All Modes All Injuries: 60.8% - 7530/12388| B. UPDATE FREQUENCY |This dataset will be updated in 2019/20 using 2016-2018 injury when available from SFPD, ZSFG, and OME. This update schedule is tentative and pending approval from the SFDPH/SFMTA. Please contact Devan Morris (devan.morris@sfdph.org) for more information.| C. OTHER CRITICAL INFO |The network represents a snapshot in time (2013-2015) where severe and fatal injuries are most concentrated. It may not reflect current conditions or changes to the city’s transportation system. Although prior incidents are often indicative of future incidents the Vision Zero High Injury Network is not a prediction (probability) of future risk. The High Injury Network approach is in contrast to risk-based approaches, which focus on locations determined to be more dangerous with increased risk or danger often calculated by dividing the number of injuries or collisions by vehicle volumes to estimate risk of injury per vehicle. The High Injury Network instead informs agencies of the streets where injuries, particularly severe and fatal, are concentrated in San Francisco based on injury counts; it is not an assessment of whether a street or particular location is dangerous. The 2017 Vision Zero Network is derived from only the worst injury outcomes (severe/fatal injuries) and may not cover locations with high numbers of less severe injury collisions. Hospital and emergency medical service records from which unreported injury and reclassified injury collisions are derived are protected by the Health Insurance Portability and Accountability Act and have strict confidentiality and privacy requirements. As of June 2017 SFPDH is working in conjunction with SFPDH’s Office of Compliance and Privacy Affairs, ZSFG and the SFMTA to determine at what level of aggregation SFDPH can share the data to be compliant with HIPAA. Location specific counts of severe/fatal injuries have been intentionally excluded from this dataset and a full dataset is pending review.A complete methodology is available here: link forthcoming.| D. 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;geom_Length: Object length created by ArcGIS;prior_network: identifies if street segment was on the 2015 Vision Zero High Injury Network or is new;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;geom_Length: Object length created by ArcGIS;prior_network: identifies if street segment was on the 2015 Vision Zero High Injury Network or is new
Copyright Text: | A. CUSTODIAN | Devan Morris, devan.morris@sfdph.org, Population Health, San Francisco Department of Public Health;
Leilani Schwarcz, leilani.schwarcz@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 DATE |
20170629
| C. VERSIONS |
Original release - 20110601, Devan Morris/Megan Wier (Department of Public Health) – previous methodology (http://bit.ly/1QQxU79);
Latest release - 20170629, Devan Morris/Megan Wier (Department of Public Health).
Default Visibility: false
MaxRecordCount: 2000
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: 141700.1156481242
YMin: 63521.494835414196
XMax: 180582.2399352718
YMax: 99948.49130194995
Spatial Reference: 0
(0)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSLSSolid
Color: [0, 110, 138, 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
)
-
CLASS_CODE
(
type: esriFieldTypeString, alias: CLASS_CODE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: class_code
)
-
DIRECTION
(
type: esriFieldTypeString, alias: DIRECTION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: direction
)
-
Shape__Length
(
type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN, required: true
)
-
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: 1073741822, defaultValue: null, modelName: street_name
)
-
STREET_TYPE
(
type: esriFieldTypeString, alias: street_type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: street_type
)
-
STREET_LAYER
(
type: esriFieldTypeString, alias: street_layer, editable: true, nullable: true, length: 254, defaultValue: null, modelName: street_layer
)
-
FULL_STREET_NAME
(
type: esriFieldTypeString, alias: full_street_name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: full_street_name
)
-
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
)
-
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
)
-
CORRECTED_LENGTH_MILES
(
type: esriFieldTypeDouble, alias: corrected_length_miles, editable: true, nullable: true, defaultValue: null, modelName: corrected_length_miles
)
-
FROM_INTRSCTN
(
type: esriFieldTypeString, alias: from_intrsctn, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: from_intrsctn
)
-
TO_INTRSCTN
(
type: esriFieldTypeString, alias: to_intrsctn, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: to_intrsctn
)
-
GEOM_LEN
(
type: esriFieldTypeDouble, alias: GEOM_LEN, editable: true, nullable: false, defaultValue: null, modelName: GEOM_LEN
)
Templates:
-
Name: MTA.DPH_vz_hgh_injry_ntwrk
Description:
Prototype:
TO_INTRSCTN: null
GEOM_LEN: 0
CLASS_CODE: null
DIRECTION: null
FROM_INTRSCTN: null
CNN_SGMT_PKEY: null
STREET_NAME: null
STREET_TYPE: null
STREET_LAYER: null
FULL_STREET_NAME: null
GIS_LENGTH_MILES: null
DUEL_CAR_WAY_YN: null
DUEL_CAR_WAY_ID: null
F_NODE_CNN_INTRSCTN_FKEY: null
T_NODE_CNN_INTRSCTN_FKEY: null
CORRECTED_LENGTH_MILES: 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
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