{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "intersection_join_2016_2020_2", "type" : "Feature Layer", "serviceItemId" : "3f38123508e44980b72df2c21de6710f", "cacheMaxAge" : 30, "displayField" : "Join_Count", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1633500938815, "schemaLastEditDate" : 1633500938815, "dataLastEditDate" : 1633500938815 }, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : 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" : true, "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" : "esriGeometryMultipoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -8561207.184184622, "ymin" : 4901346.9848626936, "xmax" : -8553622.2341109868, "ymax" : 4910183.2205248959, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"969cb4ba45179ad398cfa745a029fe31","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAh0lEQVQYlVXPsQnDQBBE0RdcD+KuDdVgEJhLFbkX4cC527BxpjZ8CFSEhLtwoBOWNxnYz+zOBL9JaLGg7MtQNfcMZ9oPHqyFjBKQeoZ7hQ0uxMxYSAHt7uzquQk3YkcO9aemwl3nTZaA8mI9EadD4vcWtAQYyQvjjThX+OR6bFEKqduS/9X8And7JJtjQojmAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "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" : "Join_Count", "type" : "esriFieldTypeInteger", "alias" : "Join_Count", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TARGET_FID", "type" : "esriFieldTypeInteger", "alias" : "TARGET_FID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Join_Count_1", "type" : "esriFieldTypeInteger", "alias" : "Join_Count", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TARGET_FID_1", "type" : "esriFieldTypeInteger", "alias" : "TARGET_FID", "sqlType" : "sqlTypeOther", "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" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crash_Record_Number", "type" : "esriFieldTypeInteger", "alias" : "Crash Record Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "District_Number_where_Crash_ccc", "type" : "esriFieldTypeInteger", "alias" : "District Number where Crash cccureed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code_Number_where_Crash_", "type" : "esriFieldTypeInteger", "alias" : "County Code Number where Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Municipality_Code", "type" : "esriFieldTypeInteger", "alias" : "Municipality Code", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_of_the_Reporting_Police_Ag", "type" : "esriFieldTypeInteger", "alias" : "Code of the Reporting Police Agency", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Year_when_the_Crash_occurred", "type" : "esriFieldTypeInteger", "alias" : "Year when the Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Month_when_the_Crash_occurred", "type" : "esriFieldTypeInteger", "alias" : "Month when the Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Day_of_the_Week_code_when_Crash", "type" : "esriFieldTypeInteger", "alias" : "Day of the Week code when Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "The_Time_of_Day_When_the_Crash_", "type" : "esriFieldTypeInteger", "alias" : "The Time of Day When the Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "The_Hour_of_Day_when_the_Crash_", "type" : "esriFieldTypeInteger", "alias" : "The Hour of Day when the Crash occurred", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_that_defines_lighting_at_C", "type" : "esriFieldTypeInteger", "alias" : "Code that defines lighting at Crash scene", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_for_the_weather_type_at_th", "type" : "esriFieldTypeInteger", "alias" : "Code for the weather type at the time of Crash", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Roadway_Surface_Condition_Code", "type" : "esriFieldTypeInteger", "alias" : "Roadway Surface Condition Code", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Collision_category_that_defines", "type" : "esriFieldTypeInteger", "alias" : "Collision category that defines the Crash", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_for_the_Crash_relativity_t", "type" : "esriFieldTypeInteger", "alias" : "Code for the Crash relativity to the road", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_to_define_the_type_of_Work", "type" : "esriFieldTypeString", "alias" : "Code to define the type of Work Zone", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "The_Work_Zone_Location_Code", "type" : "esriFieldTypeString", "alias" : "The Work Zone Location Code", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_the_Crash_occur_in_a_work_z", "type" : "esriFieldTypeString", "alias" : "Did the Crash occur in a work zone", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_that_defines_the_Intersect", "type" : "esriFieldTypeInteger", "alias" : "Code that defines the Intersection Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_that_defines_the_Traffic_C", "type" : "esriFieldTypeInteger", "alias" : "Code that defines the Traffic Control Device", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_that_defines_the_crash_loc", "type" : "esriFieldTypeInteger", "alias" : "Code that defines the crash location", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_to_classify_crash_as_Urban", "type" : "esriFieldTypeInteger", "alias" : "Code to classify crash as Urban or Rural based on municipality", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_fatalities_invo", "type" : "esriFieldTypeInteger", "alias" : "Total amount of fatalities involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INJURY_COUNT", "type" : "esriFieldTypeInteger", "alias" : "INJURY_COUNT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_people_involved", "type" : "esriFieldTypeInteger", "alias" : "Total people involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_count_of_all_Vehicles_and", "type" : "esriFieldTypeInteger", "alias" : "Total count of all Vehicles and Pedestrains", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_the_crash_involve_a_School_", "type" : "esriFieldTypeString", "alias" : "Did the crash involve a School Bus (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_the_crash_occur_in_a_School", "type" : "esriFieldTypeString", "alias" : "Did the crash occur in a School Zone (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Decimal_format_of_the_Latitude", "type" : "esriFieldTypeString", "alias" : "Decimal format of the Latitude", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Decimal_format_of_the_Longitude", "type" : "esriFieldTypeString", "alias" : "Decimal format of the Longitude", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Time_Police_arrived_at_the_scen", "type" : "esriFieldTypeInteger", "alias" : "Time Police arrived at the scene", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Speed_limit_for_the_Constructio", "type" : "esriFieldTypeString", "alias" : "Speed limit for the Construction Zone", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Time_Police_were_dispatched_to_", "type" : "esriFieldTypeInteger", "alias" : "Time Police were dispatched to the scene", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Estimated_hours_roadway_was_clo", "type" : "esriFieldTypeString", "alias" : "Estimated hours roadway was closed", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_there_a_lane_closure__Y_N_", "type" : "esriFieldTypeInteger", "alias" : "Was there a lane closure (Y/N)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Direction_of_traffic_in_closed_", "type" : "esriFieldTypeString", "alias" : "Direction of traffic in closed lane (s)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PeNNDOT_highway_maintenance_not", "type" : "esriFieldTypeString", "alias" : "PeNNDOT highway maintenance notified", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_that_defines_any_special_j", "type" : "esriFieldTypeString", "alias" : "Code that defines any special jurisdiction - only for fatal crashes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_for_Traffic_Control_Device", "type" : "esriFieldTypeInteger", "alias" : "Code for Traffic Control Device state", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_Traffic_Detoured__Y_N_", "type" : "esriFieldTypeString", "alias" : "Was Traffic Detoured (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Were_construction_personnel_pre", "type" : "esriFieldTypeString", "alias" : "Were construction personnel present (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_traffic_rerouted_due_to_wor", "type" : "esriFieldTypeString", "alias" : "Was traffic rerouted due to work zone (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_work_zone_have_a_flagman__Y", "type" : "esriFieldTypeString", "alias" : "Did work zone have a flagman (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_work_zone_have_a_patrolman_", "type" : "esriFieldTypeString", "alias" : "Did work zone have a patrolman (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Did_Work_zone_have_a_lane_closu", "type" : "esriFieldTypeString", "alias" : "Did Work zone have a lane closure (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_there_moving_work_in_the_zo", "type" : "esriFieldTypeString", "alias" : "Was there moving work in the zone (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_this_a_special_type_of_work", "type" : "esriFieldTypeString", "alias" : "Was this a special type of work zone (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Was_a_median_shoulder_in_the_zo", "type" : "esriFieldTypeString", "alias" : "Was a median/shoulder in the zone (Y/N)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_number_of_all_motor_vehic", "type" : "esriFieldTypeInteger", "alias" : "Total number of all motor vehicles involved in the crash", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Automobiles_Inv", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Automobiles Involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Motorcycles_Inv", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Motorcycles Involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Buses_involved", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Buses involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Small_Trucks_in", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Small Trucks involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Heavy_Trucks_in", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Heavy Trucks involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_count_of_sport_utility_ve", "type" : "esriFieldTypeInteger", "alias" : "Total count of sport utility vehicles involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_vans_involved", "type" : "esriFieldTypeInteger", "alias" : "Total amount of vans involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Bicycles_involv", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Bicycles involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Major_Injuries_", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Major Injuries involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Moderate_Injuri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Moderate Injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Minimal_Injurie", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Minimal Injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOT_INJ_COUNT", "type" : "esriFieldTypeInteger", "alias" : "TOT_INJ_COUNT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "No_of_injuries_with_unknown_sev", "type" : "esriFieldTypeInteger", "alias" : "No of injuries with unknown severity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "No_of_people_that_are_unknown_i", "type" : "esriFieldTypeInteger", "alias" : "No of people that are unknown if injured", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_16_year_old_dri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 16 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_17_year_old_dri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 17 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_18_year_old_dri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 18 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_19_year_old_dri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 19 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_20_year_old_dri", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 20 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_50_to_64_year_o", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 50 to 64 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_65_to_74_year_o", "type" : "esriFieldTypeInteger", "alias" : "Total amount of 65 to 74 year old drivers", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_drivers_ages_75", "type" : "esriFieldTypeInteger", "alias" : "Total amount of drivers ages 75 and up", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_count_of_all_unbelted_occ", "type" : "esriFieldTypeInteger", "alias" : "Total count of all unbelted occupants", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "No_of_people_killed_not_wearing", "type" : "esriFieldTypeInteger", "alias" : "No of people killed not wearing a seatbelt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total___of_unbelted_sustaining_", "type" : "esriFieldTypeInteger", "alias" : "Total # of unbelted sustaining Major Injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Deaths_of_belted_occupant", "type" : "esriFieldTypeInteger", "alias" : "Total Deaths of belted occupants", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Major_Injuries_of_belted_", "type" : "esriFieldTypeInteger", "alias" : "Total Major Injuries of belted occupants", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Motorcyclist_fa", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Motorcyclist fatalities", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Motorcyclist_Ma", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Motorcyclist Major Injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Bicyclist_Fatal", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Bicyclist Fatalities", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_amount_of_Bicyclist_Major", "type" : "esriFieldTypeInteger", "alias" : "Total amount of Bicyclist Major Injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Pedestrian_involved", "type" : "esriFieldTypeInteger", "alias" : "Total Pedestrian involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Pedestrian_Fatalities", "type" : "esriFieldTypeInteger", "alias" : "Total Pedestrian Fatalities", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Pedestrian_Major_injuries", "type" : "esriFieldTypeInteger", "alias" : "Total Pedestrian Major injuries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Injury_severity_level_of_the_cr", "type" : "esriFieldTypeInteger", "alias" : "Injury severity level of the crash", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Commercial_vehicles_invol", "type" : "esriFieldTypeInteger", "alias" : "Total Commercial vehicles involved", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Decimal_format_of_the_Latitude_", "type" : "esriFieldTypeDouble", "alias" : "Decimal_format_of_the_Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Decimal_format_of_the_Longitu_1", "type" : "esriFieldTypeDouble", "alias" : "Decimal_format_of_the_Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Code_for_the_Roadway_surface_ty", "type" : "esriFieldTypeString", "alias" : "Code for the Roadway surface type - only for fatal crashes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code_number_where_crash1", "type" : "esriFieldTypeString", "alias" : "County Code number where crash occured", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__HIGH_INT__F4B70D85AF576463", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_5155.HIGH_INTERSECTION_CRASH_2021_INTERSECTION_JOIN_2016_2020_2_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Join_Count_Index", "fields" : "Join_Count", "isAscending" : true, "isUnique" : false, "description" : "Join_Count_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "intersection_join_2016_2020_2", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Code_for_the_Roadway_surface_ty" : null, "County_Code_number_where_crash1" : null, "Join_Count" : null, "TARGET_FID" : null, "Join_Count_1" : null, "TARGET_FID_1" : null, "X" : null, "Y" : null, "OBJECTID_1" : null, "Crash_Record_Number" : null, "District_Number_where_Crash_ccc" : null, "County_Code_Number_where_Crash_" : null, "Municipality_Code" : null, "Code_of_the_Reporting_Police_Ag" : null, "Year_when_the_Crash_occurred" : null, "Month_when_the_Crash_occurred" : null, "Day_of_the_Week_code_when_Crash" : null, "The_Time_of_Day_When_the_Crash_" : null, "The_Hour_of_Day_when_the_Crash_" : null, "Code_that_defines_lighting_at_C" : null, "Code_for_the_weather_type_at_th" : null, "Roadway_Surface_Condition_Code" : null, "Collision_category_that_defines" : null, "Code_for_the_Crash_relativity_t" : null, "Code_to_define_the_type_of_Work" : null, "The_Work_Zone_Location_Code" : null, "Did_the_Crash_occur_in_a_work_z" : null, "Code_that_defines_the_Intersect" : null, "Code_that_defines_the_Traffic_C" : null, "Code_that_defines_the_crash_loc" : null, "Code_to_classify_crash_as_Urban" : null, "Total_amount_of_fatalities_invo" : null, "INJURY_COUNT" : null, "Total_people_involved" : null, "Total_count_of_all_Vehicles_and" : null, "Did_the_crash_involve_a_School_" : null, "Did_the_crash_occur_in_a_School" : null, "Decimal_format_of_the_Latitude" : null, "Decimal_format_of_the_Longitude" : null, "Time_Police_arrived_at_the_scen" : null, "Speed_limit_for_the_Constructio" : null, "Time_Police_were_dispatched_to_" : null, "Estimated_hours_roadway_was_clo" : null, "Was_there_a_lane_closure__Y_N_" : null, "Direction_of_traffic_in_closed_" : null, "PeNNDOT_highway_maintenance_not" : null, "Code_that_defines_any_special_j" : null, "Code_for_Traffic_Control_Device" : null, "Was_Traffic_Detoured__Y_N_" : null, "Were_construction_personnel_pre" : null, "Was_traffic_rerouted_due_to_wor" : null, "Did_work_zone_have_a_flagman__Y" : null, "Did_work_zone_have_a_patrolman_" : null, "Did_Work_zone_have_a_lane_closu" : null, "Was_there_moving_work_in_the_zo" : null, "Was_this_a_special_type_of_work" : null, "Was_a_median_shoulder_in_the_zo" : null, "Total_number_of_all_motor_vehic" : null, "Total_amount_of_Automobiles_Inv" : null, "Total_amount_of_Motorcycles_Inv" : null, "Total_amount_of_Buses_involved" : null, "Total_amount_of_Small_Trucks_in" : null, "Total_amount_of_Heavy_Trucks_in" : null, "Total_count_of_sport_utility_ve" : null, "Total_amount_of_vans_involved" : null, "Total_amount_of_Bicycles_involv" : null, "Total_amount_of_Major_Injuries_" : null, "Total_amount_of_Moderate_Injuri" : null, "Total_amount_of_Minimal_Injurie" : null, "TOT_INJ_COUNT" : null, "No_of_injuries_with_unknown_sev" : null, "No_of_people_that_are_unknown_i" : null, "Total_amount_of_16_year_old_dri" : null, "Total_amount_of_17_year_old_dri" : null, "Total_amount_of_18_year_old_dri" : null, "Total_amount_of_19_year_old_dri" : null, "Total_amount_of_20_year_old_dri" : null, "Total_amount_of_50_to_64_year_o" : null, "Total_amount_of_65_to_74_year_o" : null, "Total_amount_of_drivers_ages_75" : null, "Total_count_of_all_unbelted_occ" : null, "No_of_people_killed_not_wearing" : null, "Total___of_unbelted_sustaining_" : null, "Total_Deaths_of_belted_occupant" : null, "Total_Major_Injuries_of_belted_" : null, "Total_amount_of_Motorcyclist_fa" : null, "Total_amount_of_Motorcyclist_Ma" : null, "Total_amount_of_Bicyclist_Fatal" : null, "Total_amount_of_Bicyclist_Major" : null, "Total_Pedestrian_involved" : null, "Total_Pedestrian_Fatalities" : null, "Total_Pedestrian_Major_injuries" : null, "Injury_severity_level_of_the_cr" : null, "Total_Commercial_vehicles_invol" : null, "Decimal_format_of_the_Latitude_" : null, "Decimal_format_of_the_Longitu_1" : null } } } ], "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" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [] }