View In:   ArcGIS Online Map Viewer

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: 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: -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: 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 )
• UNIQUE_ID ( type: esriFieldTypeInteger, alias: UNIQUE_ID, editable: true, nullable: false, defaultValue: null, modelName: UNIQUE_ID )
• CNN_INTRSCTN_FKEY ( type: esriFieldTypeDouble, alias: CNN_INTRSCTN_FKEY, editable: true, nullable: true, defaultValue: null, modelName: CNN_INTRSCTN_FKEY )
• CNN_SGMT_FKEY ( type: esriFieldTypeInteger, alias: CNN_SGMT_FKEY, editable: true, nullable: true, defaultValue: null, modelName: CNN_SGMT_FKEY )
• TB_LATITUDE ( type: esriFieldTypeDouble, alias: TB_LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: TB_LATITUDE )
• TB_LONGITUDE ( type: esriFieldTypeDouble, alias: TB_LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: TB_LONGITUDE )
• GEOCODE_SOURCE ( type: esriFieldTypeString, alias: GEOCODE_SOURCE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: GEOCODE_SOURCE )
• GEOCODE_LOCATION ( type: esriFieldTypeString, alias: GEOCODE_LOCATION, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: GEOCODE_LOCATION )
• CASE_ID_PKEY ( type: esriFieldTypeString, alias: CASE_ID_PKEY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CASE_ID_PKEY )
• ACCIDENT_YEAR ( type: esriFieldTypeInteger, alias: ACCIDENT_YEAR, editable: true, nullable: true, defaultValue: null, modelName: ACCIDENT_YEAR )
• JURIS ( type: esriFieldTypeString, alias: JURIS, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: JURIS )
• COLLISION_DATE ( type: esriFieldTypeDouble, alias: COLLISION_DATE, editable: true, nullable: true, defaultValue: null, modelName: COLLISION_DATE )
• COLLISION_TIME ( type: esriFieldTypeDouble, alias: COLLISION_TIME, editable: true, nullable: true, defaultValue: null, modelName: COLLISION_TIME )
• OFFICER_ID ( type: esriFieldTypeString, alias: OFFICER_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OFFICER_ID )
• REPORTING_DISTRICT ( type: esriFieldTypeString, alias: REPORTING_DISTRICT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: REPORTING_DISTRICT )
• DAY_OF_WEEK ( type: esriFieldTypeString, alias: DAY_OF_WEEK, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DAY_OF_WEEK )
• BEAT_NUMBER ( type: esriFieldTypeString, alias: BEAT_NUMBER, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BEAT_NUMBER )
• PRIMARY_RD ( type: esriFieldTypeString, alias: PRIMARY_RD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRIMARY_RD )
• SECONDARY_RD ( type: esriFieldTypeString, alias: SECONDARY_RD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SECONDARY_RD )
• DISTANCE ( type: esriFieldTypeDouble, alias: DISTANCE, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DIRECTION )
• WEATHER_2 ( type: esriFieldTypeString, alias: WEATHER_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WEATHER_2 )
• COLLISION_SEVERITY ( type: esriFieldTypeString, alias: COLLISION_SEVERITY, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: COLLISION_SEVERITY )
• TYPE_OF_COLLISION ( type: esriFieldTypeString, alias: TYPE_OF_COLLISION, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TYPE_OF_COLLISION )
• MVIW ( type: esriFieldTypeString, alias: MVIW, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MVIW )
• PED_ACTION ( type: esriFieldTypeString, alias: PED_ACTION, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PED_ACTION )
• ROAD_SURFACE ( type: esriFieldTypeString, alias: ROAD_SURFACE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ROAD_SURFACE )
• ROAD_COND_1 ( type: esriFieldTypeString, alias: ROAD_COND_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ROAD_COND_1 )
• ROAD_COND_2 ( type: esriFieldTypeString, alias: ROAD_COND_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ROAD_COND_2 )
• LIGHTING ( type: esriFieldTypeString, alias: LIGHTING, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LIGHTING )
• CONTROL_DEVICE ( type: esriFieldTypeString, alias: CONTROL_DEVICE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CONTROL_DEVICE )
• DPH_COL_GRP ( type: esriFieldTypeString, alias: DPH_COL_GRP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DPH_COL_GRP )
• TIME_CAT ( type: esriFieldTypeString, alias: TIME_CAT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TIME_CAT )
• WEATHER_1 ( type: esriFieldTypeString, alias: WEATHER_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WEATHER_1 )
• INTERSECTION ( type: esriFieldTypeString, alias: INTERSECTION, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: INTERSECTION )
• MONTH ( type: esriFieldTypeString, alias: MONTH, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MONTH )
• VZ_PCF_CODE ( type: esriFieldTypeString, alias: VZ_PCF_CODE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VZ_PCF_CODE )
• VZ_PCF_GROUP ( type: esriFieldTypeString, alias: VZ_PCF_GROUP, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: VZ_PCF_GROUP )
• VZ_PCF_DESCRIPTION ( type: esriFieldTypeString, alias: VZ_PCF_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VZ_PCF_DESCRIPTION )
• VZ_PCF_LINK ( type: esriFieldTypeString, alias: VZ_PCF_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VZ_PCF_LINK )
• NUMBER_KILLED ( type: esriFieldTypeInteger, alias: NUMBER_KILLED, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_KILLED )
• NUMBER_INJURED ( type: esriFieldTypeInteger, alias: NUMBER_INJURED, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_INJURED )
• STREET_VIEW ( type: esriFieldTypeString, alias: STREET_VIEW, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STREET_VIEW )
• REPORT_LINK ( type: esriFieldTypeString, alias: REPORT_LINK, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: REPORT_LINK )
• NUMBER_REPORTS ( type: esriFieldTypeInteger, alias: NUMBER_REPORTS, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_REPORTS )
• PARTY_AT_FAULT ( type: esriFieldTypeString, alias: PARTY_AT_FAULT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY_AT_FAULT )
• PARTY1_TYPE ( type: esriFieldTypeString, alias: PARTY1_TYPE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY1_TYPE )
• PARTY1_DIR_OF_TRAVEL ( type: esriFieldTypeString, alias: PARTY1_DIR_OF_TRAVEL, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY1_DIR_OF_TRAVEL )
• PARTY1_MOVE_PRE_ACC ( type: esriFieldTypeString, alias: PARTY1_MOVE_PRE_ACC, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY1_MOVE_PRE_ACC )
• PARTY2_TYPE ( type: esriFieldTypeString, alias: PARTY2_TYPE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY2_TYPE )
• PARTY2_DIR_OF_TRAVEL ( type: esriFieldTypeString, alias: PARTY2_DIR_OF_TRAVEL, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY2_DIR_OF_TRAVEL )
• PARTY2_MOVE_PRE_ACC ( type: esriFieldTypeString, alias: PARTY2_MOVE_PRE_ACC, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PARTY2_MOVE_PRE_ACC )
• 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 )

Templates:

• Name: MTA.DPH_collisions
  Description:
  Prototype:
  PARTY2_MOVE_PRE_ACC: null
  PARTY2_DIR_OF_TRAVEL: null
  UNIQUE_ID: 0
  CNN_INTRSCTN_FKEY: null
  CNN_SGMT_FKEY: null
  TB_LATITUDE: null
  TB_LONGITUDE: null
  GEOCODE_SOURCE: null
  GEOCODE_LOCATION: null
  CASE_ID_PKEY: null
  ACCIDENT_YEAR: null
  JURIS: null
  COLLISION_DATE: null
  COLLISION_TIME: null
  OFFICER_ID: null
  REPORTING_DISTRICT: null
  DAY_OF_WEEK: null
  BEAT_NUMBER: null
  PRIMARY_RD: null
  SECONDARY_RD: null
  DISTANCE: null
  DIRECTION: null
  WEATHER_2: null
  COLLISION_SEVERITY: null
  TYPE_OF_COLLISION: null
  MVIW: null
  PED_ACTION: null
  ROAD_SURFACE: null
  ROAD_COND_1: null
  ROAD_COND_2: null
  LIGHTING: null
  CONTROL_DEVICE: null
  DPH_COL_GRP: null
  TIME_CAT: null
  WEATHER_1: null
  INTERSECTION: null
  MONTH: null
  VZ_PCF_CODE: null
  VZ_PCF_GROUP: null
  VZ_PCF_DESCRIPTION: null
  VZ_PCF_LINK: null
  NUMBER_KILLED: null
  NUMBER_INJURED: null
  STREET_VIEW: null
  REPORT_LINK: null
  NUMBER_REPORTS: null
  PARTY_AT_FAULT: null
  PARTY1_TYPE: null
  PARTY1_DIR_OF_TRAVEL: null
  PARTY1_MOVE_PRE_ACC: null
  PARTY2_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

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