{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "ITSSQLSandbox.DBO.Signal4CrashEvent_CurrentYear", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "extent": { "xmin": -82.88714645999994, "ymin": 5.6843418860808015E-14, "xmax": 5.6843418860808015E-14, "ymax": 30.351194620000058, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 2, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 1.125899906842624E13, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 71, 138, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ReportingAgency", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "S4DecimalDegreesLongitude", "type": "esriFieldTypeDouble", "alias": "S4DecimalDegreesLongitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "S4DecimalDegreesLongitude" }, { "name": "S4DecimalDegreesLatitude", "type": "esriFieldTypeDouble", "alias": "S4DecimalDegreesLatitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "S4DecimalDegreesLatitude" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ReportNumber", "type": "esriFieldTypeInteger", "alias": "ReportNumber", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ReportNumber" }, { "name": "ReportingAgency", "type": "esriFieldTypeString", "alias": "ReportingAgency", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ReportingAgency" }, { "name": "CrashDate", "type": "esriFieldTypeString", "alias": "CrashDate", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CrashDate" }, { "name": "CrashTime", "type": "esriFieldTypeString", "alias": "CrashTime", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CrashTime" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "City" }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "County" }, { "name": "CrashStreet", "type": "esriFieldTypeString", "alias": "CrashStreet", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CrashStreet" }, { "name": "IntersectingStreet", "type": "esriFieldTypeString", "alias": "IntersectingStreet", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "IntersectingStreet" }, { "name": "OffsetDistance", "type": "esriFieldTypeInteger", "alias": "OffsetDistance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OffsetDistance" }, { "name": "OffsetDirection", "type": "esriFieldTypeString", "alias": "OffsetDirection", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "OffsetDirection" }, { "name": "CrashType", "type": "esriFieldTypeString", "alias": "CrashType", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CrashType" }, { "name": "Vehicles", "type": "esriFieldTypeInteger", "alias": "Vehicles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Vehicles" }, { "name": "NonMotorists", "type": "esriFieldTypeInteger", "alias": "NonMotorists", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonMotorists" }, { "name": "Fatalities", "type": "esriFieldTypeInteger", "alias": "Fatalities", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fatalities" }, { "name": "Injuries", "type": "esriFieldTypeInteger", "alias": "Injuries", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Injuries" }, { "name": "AlcoholRelated", "type": "esriFieldTypeSmallInteger", "alias": "AlcoholRelated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AlcoholRelated" }, { "name": "DistractionRelated", "type": "esriFieldTypeSmallInteger", "alias": "DistractionRelated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DistractionRelated" }, { "name": "DrugRelated", "type": "esriFieldTypeSmallInteger", "alias": "DrugRelated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DrugRelated" }, { "name": "EstimatedDamages", "type": "esriFieldTypeInteger", "alias": "EstimatedDamages", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedDamages" }, { "name": "WeatherCondition", "type": "esriFieldTypeString", "alias": "WeatherCondition", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "WeatherCondition" }, { "name": "LightCondition", "type": "esriFieldTypeString", "alias": "LightCondition", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LightCondition" }, { "name": "CrashSeverity", "type": "esriFieldTypeString", "alias": "CrashSeverity", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CrashSeverity" }, { "name": "WithinCityLimits", "type": "esriFieldTypeSmallInteger", "alias": "WithinCityLimits", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WithinCityLimits" }, { "name": "FirstHarmfulEvent", "type": "esriFieldTypeString", "alias": "FirstHarmfulEvent", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FirstHarmfulEvent" }, { "name": "FirstHELocation", "type": "esriFieldTypeString", "alias": "FirstHELocation", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FirstHELocation" }, { "name": "FirstHERelationToJct", "type": "esriFieldTypeString", "alias": "FirstHERelationToJct", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FirstHERelationToJct" }, { "name": "SchoolBusRelated", "type": "esriFieldTypeSmallInteger", "alias": "SchoolBusRelated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SchoolBusRelated" }, { "name": "Pedestrians", "type": "esriFieldTypeInteger", "alias": "Pedestrians", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pedestrians" }, { "name": "IncapacitatingInjuries", "type": "esriFieldTypeInteger", "alias": "IncapacitatingInjuries", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IncapacitatingInjuries" }, { "name": "RoadSurfaceCondition", "type": "esriFieldTypeString", "alias": "RoadSurfaceCondition", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "RoadSurfaceCondition" }, { "name": "ContributingCircumstanceRoad1", "type": "esriFieldTypeString", "alias": "ContributingCircumstanceRoad1", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ContributingCircumstanceRoad1" }, { "name": "ContributingCircumstanceRoad2", "type": "esriFieldTypeString", "alias": "ContributingCircumstanceRoad2", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ContributingCircumstanceRoad2" }, { "name": "ContributingCircumstanceRoad3", "type": "esriFieldTypeString", "alias": "ContributingCircumstanceRoad3", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ContributingCircumstanceRoad3" }, { "name": "LRSRoadway", "type": "esriFieldTypeString", "alias": "LRSRoadway", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LRSRoadway" }, { "name": "LRSMilePoint", "type": "esriFieldTypeDouble", "alias": "LRSMilePoint", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LRSMilePoint" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R4229235_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1835358_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ITSSQLSandbox.DBO.Signal4CrashEvent_CurrentYear", "description": "", "prototype": { "attributes": { "LRSRoadway": null, "S4DecimalDegreesLongitude": null, "S4DecimalDegreesLatitude": null, "LRSMilePoint": null, "ReportNumber": 0, "ReportingAgency": null, "CrashDate": null, "CrashTime": null, "City": null, "County": null, "CrashStreet": null, "IntersectingStreet": null, "OffsetDistance": null, "OffsetDirection": null, "CrashType": null, "Vehicles": null, "NonMotorists": null, "Fatalities": null, "Injuries": null, "AlcoholRelated": null, "DistractionRelated": null, "DrugRelated": null, "EstimatedDamages": null, "WeatherCondition": null, "LightCondition": null, "CrashSeverity": null, "WithinCityLimits": null, "FirstHarmfulEvent": null, "FirstHELocation": null, "FirstHERelationToJct": null, "SchoolBusRelated": null, "Pedestrians": null, "IncapacitatingInjuries": null, "RoadSurfaceCondition": null, "ContributingCircumstanceRoad1": null, "ContributingCircumstanceRoad2": null, "ContributingCircumstanceRoad3": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "25d15cf8d65849d587a1dd2e352e98c4" }