Name: MTA.DPH_collisions

Display Field: GEOCODE_SOURCE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: | A. PURPOSE | Statewide Integrated Traffic Records System (SWITRS) is a database that serves as a means to collect and process data gathered from a collision scene. http://iswitrs.chp.ca.gov/Reports/jsp/userLogin.jsp. SFPD (SF Police Department) also reports collision data, although the geocoding accuracy rate is lower for SFPD data.| B. METHODOLOGY | -- imported from SWITRS| C. UPDATE FREQUENCY | Quarterly, approximately. However, there is a one year lag with SWITRS data availability.| D. OTHER CRITICAL INFO | Geocoding accuracy rate for 2013-14 SFPD data was at 75%.| E. ATTRIBUTES | http://ds.civicknowledge.org.s3.amazonaws.com/iswitrs.chp.ca.gov/SWITRS%20Data%20Dictionary.pdf

Copyright Text: | A. CUSTODIAN | James Shahamiri, james.shahamiri@sfmta.com, Transportation Engineering, SFMTA. | B. CREATED | 20150201 | C. VERSIONS | 201605, James Shahamiri, regular updates as data become available 20150201, James Shahamiri, regular updates as data become available

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -122.513616209
YMin: 37.707458603000006
XMax: -122.35832789400001
YMax: 37.829861891
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• UNIQUE_ID ( type: esriFieldTypeInteger, alias: UNIQUE_ID )
• CNN_INTRSCTN_FKEY ( type: esriFieldTypeDouble, alias: CNN_INTRSCTN_FKEY )
• CNN_SGMT_FKEY ( type: esriFieldTypeInteger, alias: CNN_SGMT_FKEY )
• TB_LATITUDE ( type: esriFieldTypeDouble, alias: TB_LATITUDE )
• TB_LONGITUDE ( type: esriFieldTypeDouble, alias: TB_LONGITUDE )
• GEOCODE_SOURCE ( type: esriFieldTypeString, alias: GEOCODE_SOURCE, length: 1073741822 )
• GEOCODE_LOCATION ( type: esriFieldTypeString, alias: GEOCODE_LOCATION, length: 1073741822 )
• CASE_ID_PKEY ( type: esriFieldTypeString, alias: CASE_ID_PKEY, length: 255 )
• ACCIDENT_YEAR ( type: esriFieldTypeInteger, alias: ACCIDENT_YEAR )
• JURIS ( type: esriFieldTypeString, alias: JURIS, length: 1073741822 )
• COLLISION_DATE ( type: esriFieldTypeDouble, alias: COLLISION_DATE )
• COLLISION_TIME ( type: esriFieldTypeDouble, alias: COLLISION_TIME )
• OFFICER_ID ( type: esriFieldTypeString, alias: OFFICER_ID, length: 1073741822 )
• REPORTING_DISTRICT ( type: esriFieldTypeString, alias: REPORTING_DISTRICT, length: 1073741822 )
• DAY_OF_WEEK ( type: esriFieldTypeString, alias: DAY_OF_WEEK, length: 1073741822 )
• BEAT_NUMBER ( type: esriFieldTypeString, alias: BEAT_NUMBER, length: 1073741822 )
• PRIMARY_RD ( type: esriFieldTypeString, alias: PRIMARY_RD, length: 1073741822 )
• SECONDARY_RD ( type: esriFieldTypeString, alias: SECONDARY_RD, length: 1073741822 )
• DISTANCE ( type: esriFieldTypeDouble, alias: DISTANCE )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, length: 1073741822 )
• WEATHER_2 ( type: esriFieldTypeString, alias: WEATHER_2, length: 1073741822 )
• COLLISION_SEVERITY ( type: esriFieldTypeString, alias: COLLISION_SEVERITY, length: 1073741822 )
• TYPE_OF_COLLISION ( type: esriFieldTypeString, alias: TYPE_OF_COLLISION, length: 1073741822 )
• MVIW ( type: esriFieldTypeString, alias: MVIW, length: 1073741822 )
• PED_ACTION ( type: esriFieldTypeString, alias: PED_ACTION, length: 1073741822 )
• ROAD_SURFACE ( type: esriFieldTypeString, alias: ROAD_SURFACE, length: 1073741822 )
• ROAD_COND_1 ( type: esriFieldTypeString, alias: ROAD_COND_1, length: 1073741822 )
• ROAD_COND_2 ( type: esriFieldTypeString, alias: ROAD_COND_2, length: 1073741822 )
• LIGHTING ( type: esriFieldTypeString, alias: LIGHTING, length: 1073741822 )
• CONTROL_DEVICE ( type: esriFieldTypeString, alias: CONTROL_DEVICE, length: 1073741822 )
• DPH_COL_GRP ( type: esriFieldTypeString, alias: DPH_COL_GRP, length: 255 )
• TIME_CAT ( type: esriFieldTypeString, alias: TIME_CAT, length: 1073741822 )
• WEATHER_1 ( type: esriFieldTypeString, alias: WEATHER_1, length: 1073741822 )
• INTERSECTION ( type: esriFieldTypeString, alias: INTERSECTION, length: 1073741822 )
• MONTH ( type: esriFieldTypeString, alias: MONTH, length: 1073741822 )
• VZ_PCF_CODE ( type: esriFieldTypeString, alias: VZ_PCF_CODE, length: 255 )
• VZ_PCF_GROUP ( type: esriFieldTypeString, alias: VZ_PCF_GROUP, length: 1073741822 )
• VZ_PCF_DESCRIPTION ( type: esriFieldTypeString, alias: VZ_PCF_DESCRIPTION, length: 255 )
• VZ_PCF_LINK ( type: esriFieldTypeString, alias: VZ_PCF_LINK, length: 255 )
• NUMBER_KILLED ( type: esriFieldTypeInteger, alias: NUMBER_KILLED )
• NUMBER_INJURED ( type: esriFieldTypeInteger, alias: NUMBER_INJURED )
• STREET_VIEW ( type: esriFieldTypeString, alias: STREET_VIEW, length: 1073741822 )
• REPORT_LINK ( type: esriFieldTypeString, alias: REPORT_LINK, length: 1073741822 )
• NUMBER_REPORTS ( type: esriFieldTypeInteger, alias: NUMBER_REPORTS )
• PARTY_AT_FAULT ( type: esriFieldTypeString, alias: PARTY_AT_FAULT, length: 1073741822 )
• PARTY1_TYPE ( type: esriFieldTypeString, alias: PARTY1_TYPE, length: 1073741822 )
• PARTY1_DIR_OF_TRAVEL ( type: esriFieldTypeString, alias: PARTY1_DIR_OF_TRAVEL, length: 1073741822 )
• PARTY1_MOVE_PRE_ACC ( type: esriFieldTypeString, alias: PARTY1_MOVE_PRE_ACC, length: 1073741822 )
• PARTY2_TYPE ( type: esriFieldTypeString, alias: PARTY2_TYPE, length: 1073741822 )
• PARTY2_DIR_OF_TRAVEL ( type: esriFieldTypeString, alias: PARTY2_DIR_OF_TRAVEL, length: 1073741822 )
• PARTY2_MOVE_PRE_ACC ( type: esriFieldTypeString, alias: PARTY2_MOVE_PRE_ACC, length: 1073741822 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

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

  Iteminfo   Thumbnail   Metadata