{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "MTA.DPH_collisions", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "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", "copyrightText": "| A. CUSTODIAN | James Shahamiri, james.shahamiri@sfmta.com, Transportation Engineering, SFMTA.\n| B. CREATED | 20150201\n| C. VERSIONS |\n\n201605, James Shahamiri, regular updates as data become available\n20150201, James Shahamiri, regular updates as data become available", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": -122.513616209, "ymin": 37.707458603000006, "xmax": -122.35832789400001, "ymax": 37.829861891, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 2, "mTolerance": 2, "falseX": -400, "falseY": -422.689223, "xyUnits": 1.0948483343315887E13, "falseZ": 0, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e30e24ae33f796aaba0b0186340d8f2f", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAXCAYAAAA7kX6CAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmUlEQVQ4jc3RTUhUURQA4G9MB6ZAMYQiapFRZDGLiNZuAoO2Jv1A0SKCyMWYq4KaaBMxTJAuokW1KRAJFAuCaFZF0SIhRigikQJLMpAi0dfPi1czxMzoq1x1V+fcez/OuffUW+Kq/39ghtQyjkRxSJggnGegj/exsIXrrXSFv6C3DPTSH1vxJJkOutaU8kk+NHMottVedraTK6MZgim272Z+UdjDpm0Mp6mL8jnCpxwY5fMJWgKCPj5WwAwrN1BoZ3l5LySRZjCNUb4W6UChAjYxt57OcVYEpNZyq5FkCkW+F+nMlVAFzDKLx1H8gLEIRfEL3OdwjuHYz7nHjVa2RPE7PONsN4WDJLcSLAhv072Z/eV8NfZw5hV7R7iGC6Wx/oY9rCty6iVfonwXDU14iEdMJ7lSRhUwz5tSERMca6D/LokxhhrZl/05nZg3TrFqlvNDJMa5/Jrjg3yrvlcDZ7g4QmqS03nOVZ8vCCdou8nGaY7muboYqoGX2FFHNs+dOFQBsyQ/8STH8z+hahgN969QTav/spYMfwAVqm6MZXaY3QAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 10, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "GEOCODE_SOURCE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeInteger", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "CNN_INTRSCTN_FKEY", "type": "esriFieldTypeDouble", "alias": "CNN_INTRSCTN_FKEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CNN_INTRSCTN_FKEY" }, { "name": "CNN_SGMT_FKEY", "type": "esriFieldTypeInteger", "alias": "CNN_SGMT_FKEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CNN_SGMT_FKEY" }, { "name": "TB_LATITUDE", "type": "esriFieldTypeDouble", "alias": "TB_LATITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TB_LATITUDE" }, { "name": "TB_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "TB_LONGITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TB_LONGITUDE" }, { "name": "GEOCODE_SOURCE", "type": "esriFieldTypeString", "alias": "GEOCODE_SOURCE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "GEOCODE_SOURCE" }, { "name": "GEOCODE_LOCATION", "type": "esriFieldTypeString", "alias": "GEOCODE_LOCATION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "GEOCODE_LOCATION" }, { "name": "CASE_ID_PKEY", "type": "esriFieldTypeString", "alias": "CASE_ID_PKEY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CASE_ID_PKEY" }, { "name": "ACCIDENT_YEAR", "type": "esriFieldTypeInteger", "alias": "ACCIDENT_YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCIDENT_YEAR" }, { "name": "JURIS", "type": "esriFieldTypeString", "alias": "JURIS", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "JURIS" }, { "name": "COLLISION_DATE", "type": "esriFieldTypeDouble", "alias": "COLLISION_DATE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COLLISION_DATE" }, { "name": "COLLISION_TIME", "type": "esriFieldTypeDouble", "alias": "COLLISION_TIME", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COLLISION_TIME" }, { "name": "OFFICER_ID", "type": "esriFieldTypeString", "alias": "OFFICER_ID", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "OFFICER_ID" }, { "name": "REPORTING_DISTRICT", "type": "esriFieldTypeString", "alias": "REPORTING_DISTRICT", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "REPORTING_DISTRICT" }, { "name": "DAY_OF_WEEK", "type": "esriFieldTypeString", "alias": "DAY_OF_WEEK", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "DAY_OF_WEEK" }, { "name": "BEAT_NUMBER", "type": "esriFieldTypeString", "alias": "BEAT_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "BEAT_NUMBER" }, { "name": "PRIMARY_RD", "type": "esriFieldTypeString", "alias": "PRIMARY_RD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PRIMARY_RD" }, { "name": "SECONDARY_RD", "type": "esriFieldTypeString", "alias": "SECONDARY_RD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "SECONDARY_RD" }, { "name": "DISTANCE", "type": "esriFieldTypeDouble", "alias": "DISTANCE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISTANCE" }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "DIRECTION" }, { "name": "WEATHER_2", "type": "esriFieldTypeString", "alias": "WEATHER_2", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "WEATHER_2" }, { "name": "COLLISION_SEVERITY", "type": "esriFieldTypeString", "alias": "COLLISION_SEVERITY", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "COLLISION_SEVERITY" }, { "name": "TYPE_OF_COLLISION", "type": "esriFieldTypeString", "alias": "TYPE_OF_COLLISION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TYPE_OF_COLLISION" }, { "name": "MVIW", "type": "esriFieldTypeString", "alias": "MVIW", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MVIW" }, { "name": "PED_ACTION", "type": "esriFieldTypeString", "alias": "PED_ACTION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PED_ACTION" }, { "name": "ROAD_SURFACE", "type": "esriFieldTypeString", "alias": "ROAD_SURFACE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ROAD_SURFACE" }, { "name": "ROAD_COND_1", "type": "esriFieldTypeString", "alias": "ROAD_COND_1", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ROAD_COND_1" }, { "name": "ROAD_COND_2", "type": "esriFieldTypeString", "alias": "ROAD_COND_2", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ROAD_COND_2" }, { "name": "LIGHTING", "type": "esriFieldTypeString", "alias": "LIGHTING", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LIGHTING" }, { "name": "CONTROL_DEVICE", "type": "esriFieldTypeString", "alias": "CONTROL_DEVICE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CONTROL_DEVICE" }, { "name": "DPH_COL_GRP", "type": "esriFieldTypeString", "alias": "DPH_COL_GRP", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DPH_COL_GRP" }, { "name": "TIME_CAT", "type": "esriFieldTypeString", "alias": "TIME_CAT", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TIME_CAT" }, { "name": "WEATHER_1", "type": "esriFieldTypeString", "alias": "WEATHER_1", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "WEATHER_1" }, { "name": "INTERSECTION", "type": "esriFieldTypeString", "alias": "INTERSECTION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "INTERSECTION" }, { "name": "MONTH", "type": "esriFieldTypeString", "alias": "MONTH", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MONTH" }, { "name": "VZ_PCF_CODE", "type": "esriFieldTypeString", "alias": "VZ_PCF_CODE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VZ_PCF_CODE" }, { "name": "VZ_PCF_GROUP", "type": "esriFieldTypeString", "alias": "VZ_PCF_GROUP", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "VZ_PCF_GROUP" }, { "name": "VZ_PCF_DESCRIPTION", "type": "esriFieldTypeString", "alias": "VZ_PCF_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VZ_PCF_DESCRIPTION" }, { "name": "VZ_PCF_LINK", "type": "esriFieldTypeString", "alias": "VZ_PCF_LINK", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VZ_PCF_LINK" }, { "name": "NUMBER_KILLED", "type": "esriFieldTypeInteger", "alias": "NUMBER_KILLED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMBER_KILLED" }, { "name": "NUMBER_INJURED", "type": "esriFieldTypeInteger", "alias": "NUMBER_INJURED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMBER_INJURED" }, { "name": "STREET_VIEW", "type": "esriFieldTypeString", "alias": "STREET_VIEW", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "STREET_VIEW" }, { "name": "REPORT_LINK", "type": "esriFieldTypeString", "alias": "REPORT_LINK", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "REPORT_LINK" }, { "name": "NUMBER_REPORTS", "type": "esriFieldTypeInteger", "alias": "NUMBER_REPORTS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMBER_REPORTS" }, { "name": "PARTY_AT_FAULT", "type": "esriFieldTypeString", "alias": "PARTY_AT_FAULT", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY_AT_FAULT" }, { "name": "PARTY1_TYPE", "type": "esriFieldTypeString", "alias": "PARTY1_TYPE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY1_TYPE" }, { "name": "PARTY1_DIR_OF_TRAVEL", "type": "esriFieldTypeString", "alias": "PARTY1_DIR_OF_TRAVEL", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY1_DIR_OF_TRAVEL" }, { "name": "PARTY1_MOVE_PRE_ACC", "type": "esriFieldTypeString", "alias": "PARTY1_MOVE_PRE_ACC", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY1_MOVE_PRE_ACC" }, { "name": "PARTY2_TYPE", "type": "esriFieldTypeString", "alias": "PARTY2_TYPE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY2_TYPE" }, { "name": "PARTY2_DIR_OF_TRAVEL", "type": "esriFieldTypeString", "alias": "PARTY2_DIR_OF_TRAVEL", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY2_DIR_OF_TRAVEL" }, { "name": "PARTY2_MOVE_PRE_ACC", "type": "esriFieldTypeString", "alias": "PARTY2_MOVE_PRE_ACC", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PARTY2_MOVE_PRE_ACC" }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_USER" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITED_USER" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R319_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A308_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MTA.DPH_collisions", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 10000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }