{ "layers" : [ { "currentVersion" : 12, "id" : 1, "name" : "Complaint of Pain", "type" : "Feature Layer", "serviceItemId" : "3203da4215d943b2ad9eaf35448249c4", "displayField" : "City", "description" : "This file was created at the request of San Joaquin County's Deputy Director of Engineering (Najee Zarif). The file is updated upon request from Transportation Engineering with the aid of the SJC PW GIS Team.\n\nThis file represents the State Wide Integrated Traffic Reporting System(SWITRS) collisions provided by the California Highway Patrol(CHP). These collisions having occurred/reported in “San Joaquin-Unincorxporated” for the calendar year associated e.g. “SWITRS2019” for the year of 2019. Verified by Traffic Engineering staff to only pertain to collisions having occurred within areas of San Joaquin County Public Works jurisdiction or Right-of-Way during the year of the layer. Marked by severity of the collision. Note: “ReportNo” corresponds to the SWITRS designation and not the CHP “Local Report Number”.”", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1708622534621, "schemaLastEditDate" : 1708622534621, "dataLastEditDate" : 1708622534621 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13532433.470446182, "ymin" : 4501249.6604391346, "xmax" : -13461136.253387367, "ymax" : 4589176.2570618978, "spatialReference" : { "wkid" : 54004, "latestWkid" : 54004 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Highest_Degree_of_Injury","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"ae1feff3f1ac8bed7d321df486d1dde9","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAZ1JREFUKJGdkr1LHEEchp9V95aFy56sUVg/TsVCLERBCwshBCLaRBv/BNHaQwIxhaQNoqKFaC8pLLQQjUIwKIeFCjlRLGJhoneDyC2XM0ccczoWftzt5bBwqplhnuH5vbxFPHMVeU4jyiRBP+lUL5cXVfjMc3yBJRRTTGpufjCkavl1ss5Vohr9BfgsuLqoJnnSim6EjEHVJce1LS/Ypwzih98wSoJYjVn/2uCvhH9/LHkWWSOkGhjTTh9BQx5+kEYgiFmWfyDdD8V1fmK708DbR1DKZDd2w9Np6H4oKGz3qupmsefReQTCH6G5H2q6MvfmywB0VsBq9A5U10kPePwVfi7c7bPBQvO34+zZQnAPpuIRSsmkUt8L12mo7fDqpmK7QohoRnVzdp2aN6+BCgCsILS9y53ykqPFFcDNgO78FzsyY7lNA++BfNH+tcXOMD8mwg8teChAjL3hMImjIePVpxaptB40yoE4BWqN/bnl1EZfUkq5TQ6I67rbuKNR+X00DWwAN4AG+BzHORBSHmQreLsKMeBzrqcQ4j/3Wx4DjI61AFj9AAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Complaint of Pain","label":"Complaint of Pain","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Highest_Degree_of_Injury", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Accident_Number", "type" : "esriFieldTypeDouble", "alias" : "Accident Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Report_Number", "type" : "esriFieldTypeString", "alias" : "Report Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_date", "type" : "esriFieldTypeDate", "alias" : "Collision date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Time", "type" : "esriFieldTypeDate", "alias" : "Collision Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Day_of_Week", "type" : "esriFieldTypeString", "alias" : "Collision Day of Week", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Road", "type" : "esriFieldTypeString", "alias" : "Primary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Secondary_Road", "type" : "esriFieldTypeString", "alias" : "Secondary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance_in_Feet", "type" : "esriFieldTypeDouble", "alias" : "Distance in Feet", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction", "type" : "esriFieldTypeString", "alias" : "Direction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Highest_Degree_of_Injury", "type" : "esriFieldTypeString", "alias" : "Highest Degree of Injury", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Injured", "type" : "esriFieldTypeDouble", "alias" : "Number Injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Killed", "type" : "esriFieldTypeDouble", "alias" : "Number Killed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_at_Fault", "type" : "esriFieldTypeDouble", "alias" : "Party at Fault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Collision_Factor", "type" : "esriFieldTypeString", "alias" : "Primary Collision Factor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hit_and_Run", "type" : "esriFieldTypeString", "alias" : "Hit and Run", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_Type", "type" : "esriFieldTypeString", "alias" : "Collision Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Involved_With", "type" : "esriFieldTypeString", "alias" : "Involved With", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pedestrian_Action", "type" : "esriFieldTypeString", "alias" : "Pedestrian Action", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Private_Property", "type" : "esriFieldTypeSmallInteger", "alias" : "Private Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Officer_ID", "type" : "esriFieldTypeString", "alias" : "Officer ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation", "type" : "esriFieldTypeString", "alias" : "Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation_Subsection", "type" : "esriFieldTypeString", "alias" : "Violation Subsection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Weather", "type" : "esriFieldTypeString", "alias" : "Weather", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Surface_Condition", "type" : "esriFieldTypeString", "alias" : "Road Surface Condition", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Condition1", "type" : "esriFieldTypeString", "alias" : "Road Condition1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lighting", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Right_of_Way_Controls", "type" : "esriFieldTypeString", "alias" : "Right of Way Controls", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__________", "type" : "esriFieldTypeSmallInteger", "alias" : "----------", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_1", "type" : "esriFieldTypeDouble", "alias" : "Party Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_1", "type" : "esriFieldTypeString", "alias" : "Party Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_1", "type" : "esriFieldTypeDouble", "alias" : "Party Age 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_1", "type" : "esriFieldTypeString", "alias" : "Party Sex 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_1", "type" : "esriFieldTypeString", "alias" : "Race 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_1", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_1", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_1", "type" : "esriFieldTypeString", "alias" : "special information 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_1", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_1", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_1", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_1", "type" : "esriFieldTypeString", "alias" : "Speed Limit 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_1", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_1", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_2", "type" : "esriFieldTypeDouble", "alias" : "Party Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_2", "type" : "esriFieldTypeString", "alias" : "Party Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_2", "type" : "esriFieldTypeDouble", "alias" : "Party Age 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_2", "type" : "esriFieldTypeString", "alias" : "Party Sex 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_2", "type" : "esriFieldTypeString", "alias" : "Race 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_2", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_2", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_2", "type" : "esriFieldTypeString", "alias" : "special information 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_2", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_2", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_2", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_2", "type" : "esriFieldTypeString", "alias" : "Speed Limit 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_2", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_2", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SWITRS20__F4B70D859C045D6B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27629.SWITRS2021_COMPLAINT_OF_PAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Complaint of Pain", "name" : "Complaint of Pain", "domains" : { }, "templates" : [ { "name" : "Complaint of Pain", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Longitude" : null, "Safety_Equipment_2" : null, "Accident_Number" : null, "City" : null, "Report_Number" : null, "Collision_date" : null, "Collision_Time" : null, "Collision_Day_of_Week" : null, "Primary_Road" : null, "Secondary_Road" : null, "Distance_in_Feet" : null, "Direction" : null, "X" : null, "Y" : null, "Latitude" : null, "Highest_Degree_of_Injury" : "Complaint of Pain", "Number_Injured" : null, "Number_Killed" : null, "Party_at_Fault" : null, "Primary_Collision_Factor" : null, "Hit_and_Run" : null, "Collision_Type" : null, "Involved_With" : null, "Pedestrian_Action" : null, "Private_Property" : null, "Officer_ID" : null, "Violation" : null, "Violation_Subsection" : null, "Weather" : null, "Road_Surface_Condition" : null, "Road_Condition1" : null, "Lighting" : null, "Right_of_Way_Controls" : null, "F__________" : null, "Party_Number_1" : null, "Party_Type_1" : null, "Party_Age_1" : null, "Party_Sex_1" : null, "Race_1" : null, "Direction_of_Travel_1" : null, "Movement_Preceding_Collision_1" : null, "special_information_1" : null, "Associated_Cause___Factor_1_1" : null, "Party_Sobriety_1_1" : null, "Vehicle_Type_1" : null, "Vehicle_Type_Code_1" : null, "Vehicle_Year_1" : null, "Vehicle_Make_1" : null, "Vehicle_Model_1" : null, "Speed_Limit_1" : null, "Extent_of_Damage_1" : null, "Safety_Equipment_1" : null, "Party_Number_2" : null, "Party_Type_2" : null, "Party_Age_2" : null, "Party_Sex_2" : null, "Race_2" : null, "Direction_of_Travel_2" : null, "Movement_Preceding_Collision_2" : null, "special_information_2" : null, "Associated_Cause___Factor_1_2" : null, "Party_Sobriety_1_2" : null, "Vehicle_Type_2" : null, "Vehicle_Type_Code_2" : null, "Vehicle_Year_2" : null, "Vehicle_Make_2" : null, "Vehicle_Model_2" : null, "Speed_Limit_2" : null, "Extent_of_Damage_2" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 2, "name" : "Fatal", "type" : "Feature Layer", "serviceItemId" : "3203da4215d943b2ad9eaf35448249c4", "displayField" : "City", "description" : "This file was created at the request of San Joaquin County's Deputy Director of Engineering (Najee Zarif). The file is updated upon request from Transportation Engineering with the aid of the SJC PW GIS Team.\n\nThis file represents the State Wide Integrated Traffic Reporting System(SWITRS) collisions provided by the California Highway Patrol(CHP). These collisions having occurred/reported in “San Joaquin-Unincorxporated” for the calendar year associated e.g. “SWITRS2019” for the year of 2019. Verified by Traffic Engineering staff to only pertain to collisions having occurred within areas of San Joaquin County Public Works jurisdiction or Right-of-Way during the year of the layer. Marked by severity of the collision. Note: “ReportNo” corresponds to the SWITRS designation and not the CHP “Local Report Number”.”", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1708622531289, "schemaLastEditDate" : 1708622531289, "dataLastEditDate" : 1708622531289 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13532433.470446182, "ymin" : 4501249.6604391346, "xmax" : -13461136.253387367, "ymax" : 4589176.2570618978, "spatialReference" : { "wkid" : 54004, "latestWkid" : 54004 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Highest_Degree_of_Injury","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"6c55de689f08f97e1611d675b354be7c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAWlJREFUKJGd0rFrFEEYxuFn8XA5OO9kFeGMXhCrFFZa2giKadQmf4LEXkQwVraSQrAQ7cXCQgsxGpCIECxiigghjV28TCFZ9OKhA9G1uLjuJRHBqWaG+X3f+77z1fznqlUPBXVM9pnY4GidTy2e4W5CvitYcGyVuc+M7kMTG4yucirlapGm40mMb4fAgnSF1wfonKhUzXAEX2kuxThbMJbwsQRX0vRmK8bOob/4aeA4jUXu4UIJ9mK8OPaPMBrYw+khqXX2Vx8t4RYmMV65P0jrPCMv6dbgB70q+ApPtvZVsM6X9+12JoQBuD5oUuYygU2c2yZ3jcUQQreU+oC5s5zBCHRwfafN70+ZsfWfNXjMi/tZ1ryS5zewW7jf3mXZ1B3m5fmfcLA2xfwHrt1O05NJjJdwGOsFsw95frnf78UYF35XKicnz/OFabrTMW7iDX4iwd52u70cQ1iuShia1YF/j7brDCHs0P4LB9VvZQ1cvtcAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Fatal","label":"Fatal","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Highest_Degree_of_Injury", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Accident_Number", "type" : "esriFieldTypeDouble", "alias" : "Accident Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Report_Number", "type" : "esriFieldTypeString", "alias" : "Report Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_date", "type" : "esriFieldTypeDate", "alias" : "Collision date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Time", "type" : "esriFieldTypeDate", "alias" : "Collision Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Day_of_Week", "type" : "esriFieldTypeString", "alias" : "Collision Day of Week", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Road", "type" : "esriFieldTypeString", "alias" : "Primary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Secondary_Road", "type" : "esriFieldTypeString", "alias" : "Secondary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance_in_Feet", "type" : "esriFieldTypeDouble", "alias" : "Distance in Feet", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction", "type" : "esriFieldTypeString", "alias" : "Direction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Highest_Degree_of_Injury", "type" : "esriFieldTypeString", "alias" : "Highest Degree of Injury", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Injured", "type" : "esriFieldTypeDouble", "alias" : "Number Injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Killed", "type" : "esriFieldTypeDouble", "alias" : "Number Killed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_at_Fault", "type" : "esriFieldTypeDouble", "alias" : "Party at Fault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Collision_Factor", "type" : "esriFieldTypeString", "alias" : "Primary Collision Factor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hit_and_Run", "type" : "esriFieldTypeString", "alias" : "Hit and Run", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_Type", "type" : "esriFieldTypeString", "alias" : "Collision Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Involved_With", "type" : "esriFieldTypeString", "alias" : "Involved With", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pedestrian_Action", "type" : "esriFieldTypeString", "alias" : "Pedestrian Action", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Private_Property", "type" : "esriFieldTypeSmallInteger", "alias" : "Private Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Officer_ID", "type" : "esriFieldTypeString", "alias" : "Officer ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation", "type" : "esriFieldTypeString", "alias" : "Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation_Subsection", "type" : "esriFieldTypeString", "alias" : "Violation Subsection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Weather", "type" : "esriFieldTypeString", "alias" : "Weather", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Surface_Condition", "type" : "esriFieldTypeString", "alias" : "Road Surface Condition", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Condition1", "type" : "esriFieldTypeString", "alias" : "Road Condition1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lighting", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Right_of_Way_Controls", "type" : "esriFieldTypeString", "alias" : "Right of Way Controls", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__________", "type" : "esriFieldTypeSmallInteger", "alias" : "----------", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_1", "type" : "esriFieldTypeDouble", "alias" : "Party Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_1", "type" : "esriFieldTypeString", "alias" : "Party Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_1", "type" : "esriFieldTypeDouble", "alias" : "Party Age 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_1", "type" : "esriFieldTypeString", "alias" : "Party Sex 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_1", "type" : "esriFieldTypeString", "alias" : "Race 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_1", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_1", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_1", "type" : "esriFieldTypeString", "alias" : "special information 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_1", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_1", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_1", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_1", "type" : "esriFieldTypeString", "alias" : "Speed Limit 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_1", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_1", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_2", "type" : "esriFieldTypeDouble", "alias" : "Party Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_2", "type" : "esriFieldTypeString", "alias" : "Party Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_2", "type" : "esriFieldTypeDouble", "alias" : "Party Age 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_2", "type" : "esriFieldTypeString", "alias" : "Party Sex 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_2", "type" : "esriFieldTypeString", "alias" : "Race 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_2", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_2", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_2", "type" : "esriFieldTypeString", "alias" : "special information 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_2", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_2", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_2", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_2", "type" : "esriFieldTypeString", "alias" : "Speed Limit 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_2", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_2", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SWITRS20__F4B70D859C045D6B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27629.SWITRS2021_COMPLAINT_OF_PAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Fatal", "name" : "Fatal", "domains" : { }, "templates" : [ { "name" : "Fatal", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Longitude" : null, "Safety_Equipment_2" : null, "Accident_Number" : null, "City" : null, "Report_Number" : null, "Collision_date" : null, "Collision_Time" : null, "Collision_Day_of_Week" : null, "Primary_Road" : null, "Secondary_Road" : null, "Distance_in_Feet" : null, "Direction" : null, "X" : null, "Y" : null, "Latitude" : null, "Highest_Degree_of_Injury" : "Fatal", "Number_Injured" : null, "Number_Killed" : null, "Party_at_Fault" : null, "Primary_Collision_Factor" : null, "Hit_and_Run" : null, "Collision_Type" : null, "Involved_With" : null, "Pedestrian_Action" : null, "Private_Property" : null, "Officer_ID" : null, "Violation" : null, "Violation_Subsection" : null, "Weather" : null, "Road_Surface_Condition" : null, "Road_Condition1" : null, "Lighting" : null, "Right_of_Way_Controls" : null, "F__________" : null, "Party_Number_1" : null, "Party_Type_1" : null, "Party_Age_1" : null, "Party_Sex_1" : null, "Race_1" : null, "Direction_of_Travel_1" : null, "Movement_Preceding_Collision_1" : null, "special_information_1" : null, "Associated_Cause___Factor_1_1" : null, "Party_Sobriety_1_1" : null, "Vehicle_Type_1" : null, "Vehicle_Type_Code_1" : null, "Vehicle_Year_1" : null, "Vehicle_Make_1" : null, "Vehicle_Model_1" : null, "Speed_Limit_1" : null, "Extent_of_Damage_1" : null, "Safety_Equipment_1" : null, "Party_Number_2" : null, "Party_Type_2" : null, "Party_Age_2" : null, "Party_Sex_2" : null, "Race_2" : null, "Direction_of_Travel_2" : null, "Movement_Preceding_Collision_2" : null, "special_information_2" : null, "Associated_Cause___Factor_1_2" : null, "Party_Sobriety_1_2" : null, "Vehicle_Type_2" : null, "Vehicle_Type_Code_2" : null, "Vehicle_Year_2" : null, "Vehicle_Make_2" : null, "Vehicle_Model_2" : null, "Speed_Limit_2" : null, "Extent_of_Damage_2" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 3, "name" : "Other Visible Injury", "type" : "Feature Layer", "serviceItemId" : "3203da4215d943b2ad9eaf35448249c4", "displayField" : "City", "description" : "This file was created at the request of San Joaquin County's Deputy Director of Engineering (Najee Zarif). The file is updated upon request from Transportation Engineering with the aid of the SJC PW GIS Team.\n\nThis file represents the State Wide Integrated Traffic Reporting System(SWITRS) collisions provided by the California Highway Patrol(CHP). These collisions having occurred/reported in “San Joaquin-Unincorxporated” for the calendar year associated e.g. “SWITRS2019” for the year of 2019. Verified by Traffic Engineering staff to only pertain to collisions having occurred within areas of San Joaquin County Public Works jurisdiction or Right-of-Way during the year of the layer. Marked by severity of the collision. Note: “ReportNo” corresponds to the SWITRS designation and not the CHP “Local Report Number”.”", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1708622531289, "schemaLastEditDate" : 1708622531289, "dataLastEditDate" : 1708622531289 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13532433.470446182, "ymin" : 4501249.6604391346, "xmax" : -13461136.253387367, "ymax" : 4589176.2570618978, "spatialReference" : { "wkid" : 54004, "latestWkid" : 54004 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Highest_Degree_of_Injury","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"9dc2f8fb90855425a220e838bd3a7380","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAaZJREFUKJGdkj1IW1EYhp+riZerMSlXEa7aiDiIgyLopovgT5bWRSh2FLG7FKE6uYqD4CC1swSVUgVRI4r9wRaxGSKIFIoEbXIG61UTgzmgXodovLeGDp7pnMP3HJ7vPZ+LJy6X/WAtoCEZSEl6kmmea26OfYUscc2k8hozJ2gFqT4SbJ5dUFWsgbcQkmmqjv7SrLoZtGbVgPJK/nCA1kfU/SifS3z46/0Pr+pFUKnDhcQbico1K0id0sufLLh/qI74PNJfVpy7H48KNQaecJQp4EUWTKTky7ry/4fhUSE/j1aHqlbAM3tRJAqjczDQCYHGh/tSL76uWipCv4i5AK5vSNjBjV34FM7s7aDm5nw3YeggMuBJkghQf1/Q0wJXFnQ0OHXjp4SFELGs6vQ6m+0NtAEVAP4SGOp+1GZ64TsrkPlPF8D8NqvvV3Xvm4D5DijLkc3lzwN9eOILW3dcdgDiw4ts/Y7zdqxPbVKQ3UA5cGLB2sw3lvs/pBJSyh1HqgCmae6Mh4iNh+QV8BW4ARSgwDCMPSnFnl3BMatAHAj+6ymEeOR+Cy6/jD1GtP5JAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Other Visible Injury","label":"Other Visible Injury","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Highest_Degree_of_Injury", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Accident_Number", "type" : "esriFieldTypeDouble", "alias" : "Accident Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Report_Number", "type" : "esriFieldTypeString", "alias" : "Report Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_date", "type" : "esriFieldTypeDate", "alias" : "Collision date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Time", "type" : "esriFieldTypeDate", "alias" : "Collision Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Day_of_Week", "type" : "esriFieldTypeString", "alias" : "Collision Day of Week", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Road", "type" : "esriFieldTypeString", "alias" : "Primary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Secondary_Road", "type" : "esriFieldTypeString", "alias" : "Secondary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance_in_Feet", "type" : "esriFieldTypeDouble", "alias" : "Distance in Feet", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction", "type" : "esriFieldTypeString", "alias" : "Direction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Highest_Degree_of_Injury", "type" : "esriFieldTypeString", "alias" : "Highest Degree of Injury", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Injured", "type" : "esriFieldTypeDouble", "alias" : "Number Injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Killed", "type" : "esriFieldTypeDouble", "alias" : "Number Killed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_at_Fault", "type" : "esriFieldTypeDouble", "alias" : "Party at Fault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Collision_Factor", "type" : "esriFieldTypeString", "alias" : "Primary Collision Factor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hit_and_Run", "type" : "esriFieldTypeString", "alias" : "Hit and Run", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_Type", "type" : "esriFieldTypeString", "alias" : "Collision Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Involved_With", "type" : "esriFieldTypeString", "alias" : "Involved With", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pedestrian_Action", "type" : "esriFieldTypeString", "alias" : "Pedestrian Action", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Private_Property", "type" : "esriFieldTypeSmallInteger", "alias" : "Private Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Officer_ID", "type" : "esriFieldTypeString", "alias" : "Officer ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation", "type" : "esriFieldTypeString", "alias" : "Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation_Subsection", "type" : "esriFieldTypeString", "alias" : "Violation Subsection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Weather", "type" : "esriFieldTypeString", "alias" : "Weather", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Surface_Condition", "type" : "esriFieldTypeString", "alias" : "Road Surface Condition", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Condition1", "type" : "esriFieldTypeString", "alias" : "Road Condition1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lighting", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Right_of_Way_Controls", "type" : "esriFieldTypeString", "alias" : "Right of Way Controls", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__________", "type" : "esriFieldTypeSmallInteger", "alias" : "----------", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_1", "type" : "esriFieldTypeDouble", "alias" : "Party Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_1", "type" : "esriFieldTypeString", "alias" : "Party Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_1", "type" : "esriFieldTypeDouble", "alias" : "Party Age 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_1", "type" : "esriFieldTypeString", "alias" : "Party Sex 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_1", "type" : "esriFieldTypeString", "alias" : "Race 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_1", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_1", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_1", "type" : "esriFieldTypeString", "alias" : "special information 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_1", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_1", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_1", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_1", "type" : "esriFieldTypeString", "alias" : "Speed Limit 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_1", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_1", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_2", "type" : "esriFieldTypeDouble", "alias" : "Party Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_2", "type" : "esriFieldTypeString", "alias" : "Party Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_2", "type" : "esriFieldTypeDouble", "alias" : "Party Age 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_2", "type" : "esriFieldTypeString", "alias" : "Party Sex 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_2", "type" : "esriFieldTypeString", "alias" : "Race 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_2", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_2", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_2", "type" : "esriFieldTypeString", "alias" : "special information 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_2", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_2", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_2", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_2", "type" : "esriFieldTypeString", "alias" : "Speed Limit 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_2", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_2", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SWITRS20__F4B70D859C045D6B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27629.SWITRS2021_COMPLAINT_OF_PAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Other Visible Injury", "name" : "Other Visible Injury", "domains" : { }, "templates" : [ { "name" : "Other Visible Injury", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Longitude" : null, "Safety_Equipment_2" : null, "Accident_Number" : null, "City" : null, "Report_Number" : null, "Collision_date" : null, "Collision_Time" : null, "Collision_Day_of_Week" : null, "Primary_Road" : null, "Secondary_Road" : null, "Distance_in_Feet" : null, "Direction" : null, "X" : null, "Y" : null, "Latitude" : null, "Highest_Degree_of_Injury" : "Other Visible Injury", "Number_Injured" : null, "Number_Killed" : null, "Party_at_Fault" : null, "Primary_Collision_Factor" : null, "Hit_and_Run" : null, "Collision_Type" : null, "Involved_With" : null, "Pedestrian_Action" : null, "Private_Property" : null, "Officer_ID" : null, "Violation" : null, "Violation_Subsection" : null, "Weather" : null, "Road_Surface_Condition" : null, "Road_Condition1" : null, "Lighting" : null, "Right_of_Way_Controls" : null, "F__________" : null, "Party_Number_1" : null, "Party_Type_1" : null, "Party_Age_1" : null, "Party_Sex_1" : null, "Race_1" : null, "Direction_of_Travel_1" : null, "Movement_Preceding_Collision_1" : null, "special_information_1" : null, "Associated_Cause___Factor_1_1" : null, "Party_Sobriety_1_1" : null, "Vehicle_Type_1" : null, "Vehicle_Type_Code_1" : null, "Vehicle_Year_1" : null, "Vehicle_Make_1" : null, "Vehicle_Model_1" : null, "Speed_Limit_1" : null, "Extent_of_Damage_1" : null, "Safety_Equipment_1" : null, "Party_Number_2" : null, "Party_Type_2" : null, "Party_Age_2" : null, "Party_Sex_2" : null, "Race_2" : null, "Direction_of_Travel_2" : null, "Movement_Preceding_Collision_2" : null, "special_information_2" : null, "Associated_Cause___Factor_1_2" : null, "Party_Sobriety_1_2" : null, "Vehicle_Type_2" : null, "Vehicle_Type_Code_2" : null, "Vehicle_Year_2" : null, "Vehicle_Make_2" : null, "Vehicle_Model_2" : null, "Speed_Limit_2" : null, "Extent_of_Damage_2" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 4, "name" : "Property Damage Only", "type" : "Feature Layer", "serviceItemId" : "3203da4215d943b2ad9eaf35448249c4", "displayField" : "City", "description" : "This file was created at the request of San Joaquin County's Deputy Director of Engineering (Najee Zarif). The file is updated upon request from Transportation Engineering with the aid of the SJC PW GIS Team.\n\nThis file represents the State Wide Integrated Traffic Reporting System(SWITRS) collisions provided by the California Highway Patrol(CHP). These collisions having occurred/reported in “San Joaquin-Unincorxporated” for the calendar year associated e.g. “SWITRS2019” for the year of 2019. Verified by Traffic Engineering staff to only pertain to collisions having occurred within areas of San Joaquin County Public Works jurisdiction or Right-of-Way during the year of the layer. Marked by severity of the collision. Note: “ReportNo” corresponds to the SWITRS designation and not the CHP “Local Report Number”.”", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1708622531289, "schemaLastEditDate" : 1708622531289, "dataLastEditDate" : 1708622531289 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13532433.470446182, "ymin" : 4501249.6604391346, "xmax" : -13461136.253387367, "ymax" : 4589176.2570618978, "spatialReference" : { "wkid" : 54004, "latestWkid" : 54004 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Highest_Degree_of_Injury","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"58f74adfa06b0e29867d786d4ce2b30c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAZpJREFUKJGdkrFLG1Ecxz9njjtPYiKxCNdrI0UHHeqio4ug1MW6iPQPCOlepFA7uRYHwUF0l0oc2kHUCsFSkA6aIVLRoYg0Td6Qeo2xtr565hwi550JDr7tPd7n8fl+30/lnkv1b164GBeQrJwx5pzyuMGgqEVZCcHskoJdFxx1eXKSY9Mp0a42gxoB55T2vzn6GnRejbv6cEqRXwNgwkXP7fNZayUefup7NgZNj+D/HyK/s3Jj3KU7pfDTA/P7+ls1KuONbfXzaGGgg/CvDHPAiAfKsnze2n13GVoYCNEfzGjQ4r9UykJmCrqSYA3fnBsPiPIMi0/kq+AlZT/4Iw32BzggCGJwYu6aMYGogufHZAGvls4xwAFrKKjrFMgIIfKe6sECm9YgA4AF0BSHntc1Mc+PPrIG1f9UAexl1nfnY5Gel/YboF63/0o7scniDFvXnDcAheIkW+nvTAy+03tdRY4CD4FjXDYOF1n9ljgrSym3g60Ctm1vM00+NS0d4AtQARRAM01zT0qx51cIzCpQAN7f9hRC1LhfAQ3jiSqenJZCAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Property Damage Only","label":"Property Damage Only","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Highest_Degree_of_Injury", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Accident_Number", "type" : "esriFieldTypeDouble", "alias" : "Accident Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Report_Number", "type" : "esriFieldTypeString", "alias" : "Report Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_date", "type" : "esriFieldTypeDate", "alias" : "Collision date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Time", "type" : "esriFieldTypeDate", "alias" : "Collision Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Day_of_Week", "type" : "esriFieldTypeString", "alias" : "Collision Day of Week", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Road", "type" : "esriFieldTypeString", "alias" : "Primary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Secondary_Road", "type" : "esriFieldTypeString", "alias" : "Secondary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance_in_Feet", "type" : "esriFieldTypeDouble", "alias" : "Distance in Feet", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction", "type" : "esriFieldTypeString", "alias" : "Direction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Highest_Degree_of_Injury", "type" : "esriFieldTypeString", "alias" : "Highest Degree of Injury", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Injured", "type" : "esriFieldTypeDouble", "alias" : "Number Injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Killed", "type" : "esriFieldTypeDouble", "alias" : "Number Killed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_at_Fault", "type" : "esriFieldTypeDouble", "alias" : "Party at Fault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Collision_Factor", "type" : "esriFieldTypeString", "alias" : "Primary Collision Factor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hit_and_Run", "type" : "esriFieldTypeString", "alias" : "Hit and Run", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_Type", "type" : "esriFieldTypeString", "alias" : "Collision Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Involved_With", "type" : "esriFieldTypeString", "alias" : "Involved With", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pedestrian_Action", "type" : "esriFieldTypeString", "alias" : "Pedestrian Action", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Private_Property", "type" : "esriFieldTypeSmallInteger", "alias" : "Private Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Officer_ID", "type" : "esriFieldTypeString", "alias" : "Officer ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation", "type" : "esriFieldTypeString", "alias" : "Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation_Subsection", "type" : "esriFieldTypeString", "alias" : "Violation Subsection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Weather", "type" : "esriFieldTypeString", "alias" : "Weather", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Surface_Condition", "type" : "esriFieldTypeString", "alias" : "Road Surface Condition", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Condition1", "type" : "esriFieldTypeString", "alias" : "Road Condition1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lighting", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Right_of_Way_Controls", "type" : "esriFieldTypeString", "alias" : "Right of Way Controls", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__________", "type" : "esriFieldTypeSmallInteger", "alias" : "----------", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_1", "type" : "esriFieldTypeDouble", "alias" : "Party Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_1", "type" : "esriFieldTypeString", "alias" : "Party Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_1", "type" : "esriFieldTypeDouble", "alias" : "Party Age 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_1", "type" : "esriFieldTypeString", "alias" : "Party Sex 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_1", "type" : "esriFieldTypeString", "alias" : "Race 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_1", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_1", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_1", "type" : "esriFieldTypeString", "alias" : "special information 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_1", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_1", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_1", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_1", "type" : "esriFieldTypeString", "alias" : "Speed Limit 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_1", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_1", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_2", "type" : "esriFieldTypeDouble", "alias" : "Party Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_2", "type" : "esriFieldTypeString", "alias" : "Party Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_2", "type" : "esriFieldTypeDouble", "alias" : "Party Age 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_2", "type" : "esriFieldTypeString", "alias" : "Party Sex 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_2", "type" : "esriFieldTypeString", "alias" : "Race 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_2", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_2", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_2", "type" : "esriFieldTypeString", "alias" : "special information 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_2", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_2", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_2", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_2", "type" : "esriFieldTypeString", "alias" : "Speed Limit 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_2", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_2", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SWITRS20__F4B70D859C045D6B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27629.SWITRS2021_COMPLAINT_OF_PAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Property Damage Only", "name" : "Property Damage Only", "domains" : { }, "templates" : [ { "name" : "Property Damage Only", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Longitude" : null, "Safety_Equipment_2" : null, "Accident_Number" : null, "City" : null, "Report_Number" : null, "Collision_date" : null, "Collision_Time" : null, "Collision_Day_of_Week" : null, "Primary_Road" : null, "Secondary_Road" : null, "Distance_in_Feet" : null, "Direction" : null, "X" : null, "Y" : null, "Latitude" : null, "Highest_Degree_of_Injury" : "Property Damage Only", "Number_Injured" : null, "Number_Killed" : null, "Party_at_Fault" : null, "Primary_Collision_Factor" : null, "Hit_and_Run" : null, "Collision_Type" : null, "Involved_With" : null, "Pedestrian_Action" : null, "Private_Property" : null, "Officer_ID" : null, "Violation" : null, "Violation_Subsection" : null, "Weather" : null, "Road_Surface_Condition" : null, "Road_Condition1" : null, "Lighting" : null, "Right_of_Way_Controls" : null, "F__________" : null, "Party_Number_1" : null, "Party_Type_1" : null, "Party_Age_1" : null, "Party_Sex_1" : null, "Race_1" : null, "Direction_of_Travel_1" : null, "Movement_Preceding_Collision_1" : null, "special_information_1" : null, "Associated_Cause___Factor_1_1" : null, "Party_Sobriety_1_1" : null, "Vehicle_Type_1" : null, "Vehicle_Type_Code_1" : null, "Vehicle_Year_1" : null, "Vehicle_Make_1" : null, "Vehicle_Model_1" : null, "Speed_Limit_1" : null, "Extent_of_Damage_1" : null, "Safety_Equipment_1" : null, "Party_Number_2" : null, "Party_Type_2" : null, "Party_Age_2" : null, "Party_Sex_2" : null, "Race_2" : null, "Direction_of_Travel_2" : null, "Movement_Preceding_Collision_2" : null, "special_information_2" : null, "Associated_Cause___Factor_1_2" : null, "Party_Sobriety_1_2" : null, "Vehicle_Type_2" : null, "Vehicle_Type_Code_2" : null, "Vehicle_Year_2" : null, "Vehicle_Make_2" : null, "Vehicle_Model_2" : null, "Speed_Limit_2" : null, "Extent_of_Damage_2" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 5, "name" : "Severe Injury", "type" : "Feature Layer", "serviceItemId" : "3203da4215d943b2ad9eaf35448249c4", "displayField" : "City", "description" : "This file was created at the request of San Joaquin County's Deputy Director of Engineering (Najee Zarif). The file is updated upon request from Transportation Engineering with the aid of the SJC PW GIS Team.\n\nThis file represents the State Wide Integrated Traffic Reporting System(SWITRS) collisions provided by the California Highway Patrol(CHP). These collisions having occurred/reported in “San Joaquin-Unincorxporated” for the calendar year associated e.g. “SWITRS2019” for the year of 2019. Verified by Traffic Engineering staff to only pertain to collisions having occurred within areas of San Joaquin County Public Works jurisdiction or Right-of-Way during the year of the layer. Marked by severity of the collision. Note: “ReportNo” corresponds to the SWITRS designation and not the CHP “Local Report Number”.”", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1708622531289, "schemaLastEditDate" : 1708622531289, "dataLastEditDate" : 1708622531289 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13532433.470446182, "ymin" : 4501249.6604391346, "xmax" : -13461136.253387367, "ymax" : 4589176.2570618978, "spatialReference" : { "wkid" : 54004, "latestWkid" : 54004 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Highest_Degree_of_Injury","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"2d03e908acea49cb4daae45ea32a3843","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAZ9JREFUKJGdkj9IG1EcgL+rwePgzEn8RzSNWgdxcFIR/yyiRRerg6Oj6CiUUlAn15JBcBAFRxF0MIP4D8SgjQ4xQwQJxYKIJodIDk2a6gPNORTOOw0Ofdt7vO/x/T6ei/9cLvvmJ6byAUazZIceyHyUUW5UtPUczHYiGXnBI8zaay73MtxWKxSh4uYvmeprLpsLkb+GZbOvQ0hHDvAQUz4nHtIo8X+i0Xq1CA9l+Ljnj/tMxHYOMRvaka4s8FyOT6lC8xdTnnceBRUfdWqc6BzQb4FZkf5SQ8O7MRRUCijodKjKKMX2S2fEWGSaAUZpo8861yjV6umt+sV2wgWQ4yltByPscsAagAOUUe7S3hMPOv/AO1IxeKnSzRA5Hmnls0M3RTKq63rCUg2ysNdCTxdQBVCBn2G+vx7zIURwEzAsMMTqVtAz7x40xiYgb9r7uOd4co2ZMIYtDpBcZDJ8we9v4/KPJoQ0AFQCKTB3NljaCGRH0kKIiKMqgGEYkRUCiRUReAT2gRwgAYVer/dU6OLUruD4q0ASWH7tqev6G/dnsZ2LIYn6wgYAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Severe Injury","label":"Severe Injury","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Highest_Degree_of_Injury", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Accident_Number", "type" : "esriFieldTypeDouble", "alias" : "Accident Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Report_Number", "type" : "esriFieldTypeString", "alias" : "Report Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_date", "type" : "esriFieldTypeDate", "alias" : "Collision date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Time", "type" : "esriFieldTypeDate", "alias" : "Collision Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Collision_Day_of_Week", "type" : "esriFieldTypeString", "alias" : "Collision Day of Week", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Road", "type" : "esriFieldTypeString", "alias" : "Primary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Secondary_Road", "type" : "esriFieldTypeString", "alias" : "Secondary Road", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance_in_Feet", "type" : "esriFieldTypeDouble", "alias" : "Distance in Feet", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction", "type" : "esriFieldTypeString", "alias" : "Direction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Highest_Degree_of_Injury", "type" : "esriFieldTypeString", "alias" : "Highest Degree of Injury", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Injured", "type" : "esriFieldTypeDouble", "alias" : "Number Injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_Killed", "type" : "esriFieldTypeDouble", "alias" : "Number Killed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_at_Fault", "type" : "esriFieldTypeDouble", "alias" : "Party at Fault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Collision_Factor", "type" : "esriFieldTypeString", "alias" : "Primary Collision Factor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hit_and_Run", "type" : "esriFieldTypeString", "alias" : "Hit and Run", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_Type", "type" : "esriFieldTypeString", "alias" : "Collision Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Involved_With", "type" : "esriFieldTypeString", "alias" : "Involved With", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pedestrian_Action", "type" : "esriFieldTypeString", "alias" : "Pedestrian Action", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Private_Property", "type" : "esriFieldTypeSmallInteger", "alias" : "Private Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Officer_ID", "type" : "esriFieldTypeString", "alias" : "Officer ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation", "type" : "esriFieldTypeString", "alias" : "Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violation_Subsection", "type" : "esriFieldTypeString", "alias" : "Violation Subsection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Weather", "type" : "esriFieldTypeString", "alias" : "Weather", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Surface_Condition", "type" : "esriFieldTypeString", "alias" : "Road Surface Condition", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Road_Condition1", "type" : "esriFieldTypeString", "alias" : "Road Condition1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lighting", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Right_of_Way_Controls", "type" : "esriFieldTypeString", "alias" : "Right of Way Controls", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__________", "type" : "esriFieldTypeSmallInteger", "alias" : "----------", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_1", "type" : "esriFieldTypeDouble", "alias" : "Party Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_1", "type" : "esriFieldTypeString", "alias" : "Party Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_1", "type" : "esriFieldTypeDouble", "alias" : "Party Age 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_1", "type" : "esriFieldTypeString", "alias" : "Party Sex 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_1", "type" : "esriFieldTypeString", "alias" : "Race 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_1", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_1", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_1", "type" : "esriFieldTypeString", "alias" : "special information 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_1", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_1", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_1", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_1", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_1", "type" : "esriFieldTypeString", "alias" : "Speed Limit 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_1", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_1", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Number_2", "type" : "esriFieldTypeDouble", "alias" : "Party Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Type_2", "type" : "esriFieldTypeString", "alias" : "Party Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Age_2", "type" : "esriFieldTypeDouble", "alias" : "Party Age 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sex_2", "type" : "esriFieldTypeString", "alias" : "Party Sex 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_2", "type" : "esriFieldTypeString", "alias" : "Race 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_Travel_2", "type" : "esriFieldTypeString", "alias" : "Direction of Travel 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Movement_Preceding_Collision_2", "type" : "esriFieldTypeString", "alias" : "Movement Preceding Collision 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "special_information_2", "type" : "esriFieldTypeString", "alias" : "special information 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Associated_Cause___Factor_1_2", "type" : "esriFieldTypeString", "alias" : "Associated Cause - Factor 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Party_Sobriety_1_2", "type" : "esriFieldTypeString", "alias" : "Party Sobriety 1 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Type_Code_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Type Code 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Year_2", "type" : "esriFieldTypeDouble", "alias" : "Vehicle Year 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Make_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Make 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vehicle_Model_2", "type" : "esriFieldTypeString", "alias" : "Vehicle Model 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_Limit_2", "type" : "esriFieldTypeString", "alias" : "Speed Limit 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Extent_of_Damage_2", "type" : "esriFieldTypeString", "alias" : "Extent of Damage 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Safety_Equipment_2", "type" : "esriFieldTypeString", "alias" : "Safety Equipment 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SWITRS20__F4B70D859C045D6B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27629.SWITRS2021_COMPLAINT_OF_PAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Severe Injury", "name" : "Severe Injury", "domains" : { }, "templates" : [ { "name" : "Severe Injury", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Longitude" : null, "Safety_Equipment_2" : null, "Accident_Number" : null, "City" : null, "Report_Number" : null, "Collision_date" : null, "Collision_Time" : null, "Collision_Day_of_Week" : null, "Primary_Road" : null, "Secondary_Road" : null, "Distance_in_Feet" : null, "Direction" : null, "X" : null, "Y" : null, "Latitude" : null, "Highest_Degree_of_Injury" : "Severe Injury", "Number_Injured" : null, "Number_Killed" : null, "Party_at_Fault" : null, "Primary_Collision_Factor" : null, "Hit_and_Run" : null, "Collision_Type" : null, "Involved_With" : null, "Pedestrian_Action" : null, "Private_Property" : null, "Officer_ID" : null, "Violation" : null, "Violation_Subsection" : null, "Weather" : null, "Road_Surface_Condition" : null, "Road_Condition1" : null, "Lighting" : null, "Right_of_Way_Controls" : null, "F__________" : null, "Party_Number_1" : null, "Party_Type_1" : null, "Party_Age_1" : null, "Party_Sex_1" : null, "Race_1" : null, "Direction_of_Travel_1" : null, "Movement_Preceding_Collision_1" : null, "special_information_1" : null, "Associated_Cause___Factor_1_1" : null, "Party_Sobriety_1_1" : null, "Vehicle_Type_1" : null, "Vehicle_Type_Code_1" : null, "Vehicle_Year_1" : null, "Vehicle_Make_1" : null, "Vehicle_Model_1" : null, "Speed_Limit_1" : null, "Extent_of_Damage_1" : null, "Safety_Equipment_1" : null, "Party_Number_2" : null, "Party_Type_2" : null, "Party_Age_2" : null, "Party_Sex_2" : null, "Race_2" : null, "Direction_of_Travel_2" : null, "Movement_Preceding_Collision_2" : null, "special_information_2" : null, "Associated_Cause___Factor_1_2" : null, "Party_Sobriety_1_2" : null, "Vehicle_Type_2" : null, "Vehicle_Type_Code_2" : null, "Vehicle_Year_2" : null, "Vehicle_Make_2" : null, "Vehicle_Model_2" : null, "Speed_Limit_2" : null, "Extent_of_Damage_2" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" } ], "tables" : [] }