Name: FLAG

Display Field: CRN

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CRN (type: esriFieldTypeInteger, alias: CRN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERSTATE (type: esriFieldTypeInteger, alias: INTERSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE_ROAD (type: esriFieldTypeInteger, alias: STATE_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCAL_ROAD (type: esriFieldTypeInteger, alias: LOCAL_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCAL_ROAD_ONLY (type: esriFieldTypeInteger, alias: LOCAL_ROAD_ONLY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURNPIKE (type: esriFieldTypeInteger, alias: TURNPIKE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WET_ROAD (type: esriFieldTypeInteger, alias: WET_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SNOW_SLUSH_ROAD (type: esriFieldTypeInteger, alias: SNOW_SLUSH_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICY_ROAD (type: esriFieldTypeInteger, alias: ICY_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUDDEN_DEER (type: esriFieldTypeInteger, alias: SUDDEN_DEER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHLDR_RELATED (type: esriFieldTypeInteger, alias: SHLDR_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REAR_END (type: esriFieldTypeInteger, alias: REAR_END, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HO_OPPDIR_SDSWP (type: esriFieldTypeInteger, alias: HO_OPPDIR_SDSWP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_FIXED_OBJECT (type: esriFieldTypeInteger, alias: HIT_FIXED_OBJECT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SV_RUN_OFF_RD (type: esriFieldTypeInteger, alias: SV_RUN_OFF_RD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORK_ZONE (type: esriFieldTypeInteger, alias: WORK_ZONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPERTY_DAMAGE_ONLY (type: esriFieldTypeInteger, alias: PROPERTY_DAMAGE_ONLY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURY_OR_FATAL (type: esriFieldTypeInteger, alias: INJURY_OR_FATAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATAL_OR_MAJ_INJ (type: esriFieldTypeInteger, alias: FATAL_OR_MAJ_INJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURY (type: esriFieldTypeInteger, alias: INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATAL (type: esriFieldTypeInteger, alias: FATAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NON_INTERSECTION (type: esriFieldTypeInteger, alias: NON_INTERSECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERSECTION (type: esriFieldTypeInteger, alias: INTERSECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNALIZED_INT (type: esriFieldTypeInteger, alias: SIGNALIZED_INT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOP_CONTROLLED_INT (type: esriFieldTypeInteger, alias: STOP_CONTROLLED_INT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNSIGNALIZED_INT (type: esriFieldTypeInteger, alias: UNSIGNALIZED_INT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCHOOL_BUS (type: esriFieldTypeInteger, alias: SCHOOL_BUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCHOOL_ZONE (type: esriFieldTypeInteger, alias: SCHOOL_ZONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_DEER (type: esriFieldTypeInteger, alias: HIT_DEER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_TREE_SHRUB (type: esriFieldTypeInteger, alias: HIT_TREE_SHRUB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_EMBANKMENT (type: esriFieldTypeInteger, alias: HIT_EMBANKMENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_POLE (type: esriFieldTypeInteger, alias: HIT_POLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_GDRAIL (type: esriFieldTypeInteger, alias: HIT_GDRAIL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_GDRAIL_END (type: esriFieldTypeInteger, alias: HIT_GDRAIL_END, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_BARRIER (type: esriFieldTypeInteger, alias: HIT_BARRIER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_BRIDGE (type: esriFieldTypeInteger, alias: HIT_BRIDGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OVERTURNED (type: esriFieldTypeInteger, alias: OVERTURNED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MOTORCYCLE (type: esriFieldTypeInteger, alias: MOTORCYCLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BICYCLE (type: esriFieldTypeInteger, alias: BICYCLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HVY_TRUCK_RELATED (type: esriFieldTypeInteger, alias: HVY_TRUCK_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_FAILURE (type: esriFieldTypeInteger, alias: VEHICLE_FAILURE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAIN_TROLLEY (type: esriFieldTypeInteger, alias: TRAIN_TROLLEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHANTOM_VEHICLE (type: esriFieldTypeInteger, alias: PHANTOM_VEHICLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ALCOHOL_RELATED (type: esriFieldTypeInteger, alias: ALCOHOL_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRINKING_DRIVER (type: esriFieldTypeInteger, alias: DRINKING_DRIVER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNDERAGE_DRNK_DRV (type: esriFieldTypeInteger, alias: UNDERAGE_DRNK_DRV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNLICENSED (type: esriFieldTypeInteger, alias: UNLICENSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRACTED (type: esriFieldTypeInteger, alias: DISTRACTED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CELL_PHONE (type: esriFieldTypeInteger, alias: CELL_PHONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_CLEARANCE (type: esriFieldTypeInteger, alias: NO_CLEARANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RUNNING_RED_LT (type: esriFieldTypeInteger, alias: RUNNING_RED_LT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TAILGATING (type: esriFieldTypeInteger, alias: TAILGATING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CROSS_MEDIAN (type: esriFieldTypeInteger, alias: CROSS_MEDIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURVED_ROAD (type: esriFieldTypeInteger, alias: CURVED_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURVE_DVR_ERROR (type: esriFieldTypeInteger, alias: CURVE_DVR_ERROR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIMIT_65MPH (type: esriFieldTypeInteger, alias: LIMIT_65MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEEDING (type: esriFieldTypeInteger, alias: SPEEDING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEEDING_RELATED (type: esriFieldTypeInteger, alias: SPEEDING_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGGRESSIVE_DRIVING (type: esriFieldTypeInteger, alias: AGGRESSIVE_DRIVING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATIGUE_ASLEEP (type: esriFieldTypeInteger, alias: FATIGUE_ASLEEP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_16YR (type: esriFieldTypeInteger, alias: DRIVER_16YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_17YR (type: esriFieldTypeInteger, alias: DRIVER_17YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_18YR (type: esriFieldTypeInteger, alias: DRIVER_18YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_19YR (type: esriFieldTypeInteger, alias: DRIVER_19YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_20YR (type: esriFieldTypeInteger, alias: DRIVER_20YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_50_64YR (type: esriFieldTypeInteger, alias: DRIVER_50_64YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_65_74YR (type: esriFieldTypeInteger, alias: DRIVER_65_74YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_75PLUS (type: esriFieldTypeInteger, alias: DRIVER_75PLUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNBELTED (type: esriFieldTypeInteger, alias: UNBELTED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEDESTRIAN (type: esriFieldTypeInteger, alias: PEDESTRIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMM_VEHICLE (type: esriFieldTypeInteger, alias: COMM_VEHICLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSP_REPORTED (type: esriFieldTypeInteger, alias: PSP_REPORTED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NHTSA_AGG_DRIVING (type: esriFieldTypeInteger, alias: NHTSA_AGG_DRIVING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEER_RELATED (type: esriFieldTypeInteger, alias: DEER_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ILLUMINATION_DARK (type: esriFieldTypeInteger, alias: ILLUMINATION_DARK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RUNNING_STOP_SIGN (type: esriFieldTypeInteger, alias: RUNNING_STOP_SIGN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAIN (type: esriFieldTypeInteger, alias: TRAIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TROLLEY (type: esriFieldTypeInteger, alias: TROLLEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIT_PARKED_VEHICLE (type: esriFieldTypeInteger, alias: HIT_PARKED_VEHICLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRE_IN_VEHICLE (type: esriFieldTypeInteger, alias: FIRE_IN_VEHICLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_TOWED (type: esriFieldTypeInteger, alias: VEHICLE_TOWED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAZARDOUS_TRUCK (type: esriFieldTypeInteger, alias: HAZARDOUS_TRUCK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAJOR_INJURY (type: esriFieldTypeInteger, alias: MAJOR_INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODERATE_INJURY (type: esriFieldTypeInteger, alias: MODERATE_INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MINOR_INJURY (type: esriFieldTypeInteger, alias: MINOR_INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MC_DRINKING_DRIVER (type: esriFieldTypeInteger, alias: MC_DRINKING_DRIVER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRUG_RELATED (type: esriFieldTypeInteger, alias: DRUG_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ILLEGAL_DRUG_RELATED (type: esriFieldTypeInteger, alias: ILLEGAL_DRUG_RELATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCHOOL_BUS_UNIT (type: esriFieldTypeInteger, alias: SCHOOL_BUS_UNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRUGGED_DRIVER (type: esriFieldTypeInteger, alias: DRUGGED_DRIVER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPAIRED_DRIVER (type: esriFieldTypeInteger, alias: IMPAIRED_DRIVER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeInteger, alias: COUNTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_YEAR (type: esriFieldTypeString, alias: COUNTY_YEAR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MUNICIPALITY (type: esriFieldTypeInteger, alias: MUNICIPALITY, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: FLAG
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• HarrisburgCrashes2013to2017 (4) -- Related To: Reported Crash (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/21/2019 7:45:20 PM

Schema Last Edit Date: 11/21/2019 7:45:20 PM

Data Last Edit Date: 11/21/2019 7:45:20 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat