Skip to content

Instantly share code, notes, and snippets.

@scottwalters

scottwalters/gist:10002243

Created April 6, 2014 06:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save scottwalters/10002243 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save scottwalters/10002243 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> show tables;
+----------------------+
| Tables_in_asdmadmin |
+----------------------+
| 2009_incident |
| 2009_person |
| 2009_unit |
| 2010_incident |
| 2010_person |
| 2010_unit |
| 2011_incident |
| 2011_person |
| 2011_unit |
| 2012_incident |
| 2012_person |
| 2012_unit |
| LOVCity |
| LOVCounty |
| LOVNcic |
| LOVState |
| farsxref |
| flagstaff_posts |
| flagstaff_signs |
| orig_2012_incident |
| orig_2012_person |
| orig_2012_unit |
| physical |
| pretty_2009_incident |
| pretty_2009_person |
| pretty_2009_unit |
| pretty_2010_incident |
| pretty_2010_person |
| pretty_2010_unit |
| pretty_2011_incident |
| pretty_2011_person |
| pretty_2011_unit |
| pretty_2012_incident |
| pretty_2012_person |
| pretty_2012_unit |
| t |
| testcompany |
| testperson |
+----------------------+
38 rows in set (0.03 sec)
mysql> describe 2012_incident;
+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| IncidentID | int(11) | NO | PRI | NULL | |
| Microfilm | int(11) | YES | | NULL | |
| ADOTReceivedDate | datetime | YES | | NULL | |
| Status | int(11) | YES | | NULL | |
| DataConv2008Flag | int(11) | YES | | NULL | |
| IncidentDate | date | YES | | NULL | |
| IncidentDateTime | datetime | YES | | NULL | |
| IncidentYear | int(11) | YES | | NULL | |
| IncidentMonth | int(11) | YES | | NULL | |
| IncidentDayOfWeek | int(11) | YES | | NULL | |
| IncidentHour | int(11) | YES | | NULL | |
| OfficerNcic | int(11) | YES | MUL | NULL | |
| OfficerId | int(11) | YES | | NULL | |
| FileNumber | bigint(20) | YES | MUL | NULL | |
| ExtendedNcic | int(11) | YES | | NULL | |
| DamageOverLimitFlag | int(11) | YES | | NULL | |
| PhotosTakenFlag | int(11) | YES | | NULL | |
| PhotographerName | text | YES | | NULL | |
| PhotographerID | int(11) | YES | | NULL | |
| PhotographerAgency | text | YES | | NULL | |
| InvestigatedAtSceneFlag | int(11) | YES | | NULL | |
| DateTimeInvestigated | datetime | YES | | NULL | |
| CollisionManner | int(11) | YES | | NULL | |
| LightCondition | int(11) | YES | | NULL | |
| FirstHarmfulEvent | int(11) | YES | | NULL | |
| FirstHarmfulLocation | int(11) | YES | | NULL | |
| TotalUnits | int(11) | YES | | NULL | |
| TotalMotorists | int(11) | YES | | NULL | |
| TotalNonMotorists | int(11) | YES | | NULL | |
| TotalInjuries | int(11) | YES | | NULL | |
| TotalFatalities | int(11) | YES | | NULL | |
| TotalMotoristsInjuries | int(11) | YES | | NULL | |
| TotalNonMotoristsInjuries | int(11) | YES | | NULL | |
| TotalMotoristsFatalities | int(11) | YES | | NULL | |
| TotalNonMotoristsFatalities | int(11) | YES | | NULL | |
| InjurySeverity | int(11) | YES | | NULL | |
| MedicalTransportFlag | int(11) | YES | | NULL | |
| FatalAccidentFlag | int(11) | YES | | NULL | |
| TowAwayFlag | int(11) | YES | | NULL | |
| NscReportable | int(11) | YES | | NULL | |
| SchoolBusRelatedFlag | int(11) | YES | | NULL | |
| WorkZoneRelatedFlag | int(11) | YES | | NULL | |
| WorkersPresentFlag | int(11) | YES | | NULL | |
| AlcoholInvolvementFlag | text | YES | | NULL | |
| DrugInvolvementFlag | text | YES | | NULL | |
| HazardousFlag | int(11) | YES | | NULL | |
| HitAndRunFlag | int(11) | YES | | NULL | |
| OnRoad | text | YES | | NULL | |
| CrossingFeature | text | YES | | NULL | |
| Offset | float | YES | | NULL | |
| OffsetMeasuredFlag | int(11) | YES | | NULL | |
| OffsetUnit | int(11) | YES | | NULL | |
| MPNum | float | YES | | NULL | |
| MPOffset | float | YES | | NULL | |
| CityId | int(11) | YES | | NULL | |
| CountyId | int(11) | YES | MUL | NULL | |
| StateId | int(11) | YES | | NULL | |
| StateCode | char(2) | YES | | NULL | |
| CountryCode | char(3) | YES | | NULL | |
| Latitude | double | YES | | NULL | |
| Longitude | double | YES | | NULL | |
| ValidLocationFlag | int(11) | YES | | NULL | |
| LocationToolVersion | text | YES | | NULL | |
| HESIntersectionFlag | int(11) | YES | | NULL | |
| IntersectionFlag | int(11) | YES | | NULL | |
| IntersectionRouteID | int(11) | YES | | NULL | |
| IntersectionATISCode | text | YES | | NULL | |
| TrafficWayType | int(11) | YES | | NULL | |
| IntersectionType | int(11) | YES | | NULL | |
| JunctionRelation | int(11) | YES | | NULL | |
| Weather | int(11) | YES | | NULL | |
| PropertyDamageOwnerCode | int(11) | YES | | NULL | |
| PropertyDamageDescCode | int(11) | YES | | NULL | |
| eCollisionManner | enum('SINGLE_VEHICLE','ANGLE_FRONT_TO_SIDE','LEFT_TURN','REAR_END','HEAD_ON','SIDESWIPE_SAME_DIRECTION','SIDESWIPE_OPPOSITE_DIRECTION','REAR_TO_SIDE','REAR_TO_REAR','BAD_VALUE_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eFirstHarmfulEvent | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BAD_VALUE_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eFirstHarmfulLocation | enum('ON_ROADWAY','SHOULDER','ROADSIDE','OUTSIDE_RIGHT_OF_WAY_TRAFFICWAY','MEDIAN','GORE','SEPARATOR','IN_PARKING_LANE_OR_ZONE','TUNNEL','BRIDGE','OFF_ROADWAY_LOCATION_UNKNOWN','BAD_VALUE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eIntersectionType | enum('FOUR_WAY_INTERSECTION','T_INTERSECTION','Y_INTERSECTION','INTERSECTION_AS_PART_OF_INTERCHANGE','TRAFFIC_CIRCLE','ROUNDABOUT','FIVE_POINT_OR_MORE','NOT_AT_INTERSECTION_0','LEGACY_INTERSECTION_RELATED_PRIOR_2009_98','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eInjurySeverity | enum('NO_INJURY','POSSIBLE_INJURY','NON_INCAPACITATING_INJURY','INCAPACITATING_INJURY','FATAL','BAD_VALUE_0','UNKNOWN_99') | YES | | NULL | |
| eJunctionRelation | enum('INTERSECTION_NON_INTERCHANGE','INTERSECTION_RELATED_NON_INTERCHANGE','ENTRANCE_EXIT_RAMP_NON_INTERCHANGE','RAILWAY_GRADE_CROSSING','CROSSOVER_RELATED','FRONTAGE_ROAD_NON_INTERCHANGE','DRIVEWAY','ALLEY_ACCESS_RELATED','UNKNOWN_NON_INTERCHANGE','THRU_ROADWAY','INTERSECTION_INTERCHANGE','INTERSECTION_RELATED_INTERCHANGE','ENTRANCE_EXIT_RAMP_INTERCHANGE','FRONTAGE_ROAD_INTERCHANGE','OTHER_PART_OF_INTERCHANGE','NOT_DEFINED_16','UNKNOWN_INTERCHANGE','UNKNOWN_JUNCTION','NOT_JUNCTION_RELATED_0','UNKNOWN_99','OTHER_NON_INTERCHANGE_109','NOT_REPORTED_255') | YES | | NULL | |
| eLightCondition | enum('DAYLIGHT','DAWN','DUSK','DARK_LIGHTED','DARK_NOT_LIGHTED','DARK_UNKNOWN_LIGHTING','BAD_VALUE_0','UNKNOWN_99') | YES | | NULL | |
| eNscReportable | enum('FATALS_INJURIES_OR_PROPERTY_DAMAGE_OVER_1000','PROPERTY_DAMAGE_UNDER_1000_WITH_NO_INJURIES','NOT_REPORTABLE','BAD_VALUE_0') | YES | | NULL | |
| ePropertyDamageOwnerCode | enum('PRIVATE','PUBLIC_UTILITY','FEDERAL_GOVERNMENT','STATE_OF_ARIZONA','COUNTY_IN_ARIZONA','CITY_IN_ARIZONA','TRIBAL','BAD_VALUE_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eTrafficWayType | enum('ONE_WAY_TRAFFICWAY','TWO_WAY_NOT_DIVIDED','TWO_WAY_NOT_DIVIDED_WITH_CONTINUOUS_LEFT_TURN_LANE','TWO_WAY_DIVIDED_UNPROTECTED_PAINTED_4_FEET_MEDIAN','TWO_WAY_DIVIDED_POSITIVE_MEDIAN_BARRIER','BAD_VALUE_0','UNKNOWN_99') | YES | | NULL | |
| eWeather | enum('CLEAR','CLOUDY','SLEET_HAIL_FREEZING_RAIN_OR_DRIZZLE','RAIN','SNOW','SEVERE_CROSSWINDS','BLOWING_SAND_SOIL_DIRT','FOG_SMOG_SMOKE','BLOWING_SNOW','BAD_VALUE_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
84 rows in set (0.08 sec)
mysql> describe 2012_unit;
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| IncidentID | int(11) | YES | MUL | NULL | |
| UnitID | int(11) | NO | PRI | NULL | |
| UnitNumber | int(11) | YES | | NULL | |
| UnitType | int(11) | YES | | NULL | |
| UnitTypeDesc | text | YES | | NULL | |
| TravelDirection | int(11) | YES | | NULL | |
| TravelDirectionDesc | text | YES | | NULL | |
| RoadAlignment | int(11) | YES | | NULL | |
| RoadAlignmentDesc | text | YES | | NULL | |
| RoadGrade | int(11) | YES | | NULL | |
| RoadGradeDesc | text | YES | | NULL | |
| Lane | int(11) | YES | | NULL | |
| LaneDesc | text | YES | | NULL | |
| UnitAction | int(11) | YES | | NULL | |
| UnitActionDesc | text | YES | | NULL | |
| MostHarmfulEvent | int(11) | YES | | NULL | |
| MostHarmfulEventDesc | text | YES | | NULL | |
| HitAndRunFlag | int(11) | YES | | NULL | |
| RoadCondition1 | int(11) | YES | | NULL | |
| RoadConditionDesc1 | text | YES | | NULL | |
| RoadCondition2 | int(11) | YES | | NULL | |
| RoadConditionDesc2 | text | YES | | NULL | |
| EnvCondition1 | int(11) | YES | | NULL | |
| EnvConditionDesc1 | text | YES | | NULL | |
| EnvCondition2 | int(11) | YES | | NULL | |
| EnvConditionDesc2 | text | YES | | NULL | |
| VehicleStateID | int(11) | YES | | NULL | |
| VehicleStateCode | char(2) | YES | | NULL | |
| VehicleStateName | char(14) | YES | | NULL | |
| RegYear | int(11) | YES | | NULL | |
| BodyStyle | int(11) | YES | | NULL | |
| BodyStyleDesc | text | YES | | NULL | |
| Make | int(11) | YES | | NULL | |
| MakeDesc | text | YES | | NULL | |
| Color | int(11) | YES | | NULL | |
| ColorDesc | text | YES | | NULL | |
| BusFlag | int(11) | YES | | NULL | |
| GVWRFlag | int(11) | YES | | NULL | |
| HazmatFlag | int(11) | YES | | NULL | |
| PostedSpeed | int(11) | YES | | NULL | |
| EstimatedSpeed | int(11) | YES | | NULL | |
| SpeedOverLimit | int(11) | YES | | NULL | |
| DisabledFlag | int(11) | YES | | NULL | |
| DamageArea | int(11) | YES | | NULL | |
| DamageAreaDesc | text | YES | | NULL | |
| Defect1 | int(11) | YES | | NULL | |
| DefectDesc1 | text | YES | | NULL | |
| Defect2 | int(11) | YES | | NULL | |
| DefectDesc2 | text | YES | | NULL | |
| CitationCount | int(11) | YES | | NULL | |
| EventSequence1 | int(11) | YES | | NULL | |
| EventSequenceDesc1 | text | YES | | NULL | |
| EventSequence2 | int(11) | YES | | NULL | |
| EventSequenceDesc2 | text | YES | | NULL | |
| EventSequence3 | int(11) | YES | | NULL | |
| EventSequenceDesc3 | text | YES | | NULL | |
| EventSequence4 | int(11) | YES | | NULL | |
| EventSequenceDesc4 | text | YES | | NULL | |
| ControlType | int(11) | YES | | NULL | |
| ControlTypeDesc | text | YES | | NULL | |
| SurfaceCondition1 | int(11) | YES | | NULL | |
| SurfaceConditionDesc1 | text | YES | | NULL | |
| SurfaceCondition2 | int(11) | YES | | NULL | |
| SurfaceConditionDesc2 | text | YES | | NULL | |
| eControlType | enum('TRAFFIC_CONTROL_SIGNAL','STOP_SIGNS','YIELD_SIGNS','WARNING_SIGNS','RAILROAD_CROSSING_DEVICE','FLASHING_TRAFFIC_CONTROL_SIGNAL','PERSON_FLAGGER_LAW_ENFORCEMENT_XING_GUARD_ETC','NO_CONTROLS_0','UNDEFINED_MINUS_1','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eDamageArea | enum('FRONT_MIDDLE','FRONT_RIGHT','RIGHT_SIDE_MIDDLE','REAR_RIGHT','REAR_MIDDLE','REAR_LEFT','LEFT_SIDE_MIDDLE','FRONT_LEFT','TOP','UNDERCARRIAGE','TOTALLED','NONE_0','UNDEFINED_MINUS_1','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eEventSequence1 | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BLANK_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eEventSequence2 | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BLANK_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eEventSequence3 | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BLANK_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eEventSequence4 | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BLANK_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eLane | enum('LANE_1','LANE_2','LANE_3','LANE_4','LANE_5','LANE_6','LANE_7','LANE_8','LANE_9','TWO_WAY_LEFT_TURN_0','CROSSWALK_20','DEDICATED_BIKE_LANE_21','HIGH_OCCUPANCY_VEHICLE_22','LEFT_TURN_1_30','LEFT_TURN_2_31','LEFT_TURN_3_32','LEFT_TURN_4_33','RIGHT_TURN_1_40','RIGHT_TURN_2_41','RIGHT_TURN_3_42','RIGHT_TURN_4_43','NON_ROADWAY_97','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eMostHarmfulEvent | enum('OVERTURN_ROLLOVER','FIRE_EXPLOSION','IMMERSION','JACKKNIFE','CARGO_EQUIPMENT_LOSS_SHIFT','FELL_JUMPED_FROM_VEHICLE','THROWN_OR_FALLING_OBJECT','OTHER_NON_COLLISION','EQUIPMENT_FAILURE_TIRES_BRAKES','SEPARATION_OF_UNITS','RAN_OFF_ROAD_RIGHT','RAN_OFF_ROAD_LEFT','CROSS_MEDIAN','CROSS_CENTERLINE','DOWNHILL_RUNAWAY','MOTOR_VEHICLE_IN_TRANSPORT','PEDESTRIAN','PEDALCYCLE','RAILWAY_VEHICLE_TRAIN_ENGINE','LIGHT_RAILWAY_RAILCAR_VEHICLE','ANIMAL_WILD_NON_GAME','ANIMAL_WILD_GAME','ANIMAL_PET','ANIMAL_LIVESTOCK','PARKED_MOTOR_VEHICLE','WORK_ZONE_MAINTENANCE_EQUIPMENT','STRUCK_BY_FALLING_SHIFTING_CARGO_OR_OBJECT','OTHER_NON_FIXED_OBJECT','IMPACT_ATTENUATOR_CRASH_CUSHION','BRIDGE_OVERHEAD_STRUCTURE','BRIDGE_RAIL','CULVERT','CURB','DITCH','EMBANKMENT','GUARDRAIL_FACE','GUARDRAIL_END','CONCRETE_TRAFFIC_BARRIER','CABLE_TRAFFIC_BARRIER','OTHER_TRAFFIC_BARRIER','TREE_BUSH_STUMP_STANDING','TRAFFIC_SIGN_SUPPORT','TRAFFIC_SIGNAL_SUPPORT','UTILITY_POLE_LIGHT_SUPPORT','OTHER_POST_POLE_OR_SUPPORT','FENCE','MAILBOX','BUILDING','OTHER_FIXED_OBJECT','BAD_VALUE_0','NOT_APPLICABLE_MINUS_1','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eRoadAlignment | enum('STRAIGHT','CURVE_LEFT','CURVE_RIGHT','BAD_VALUE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eRoadCondition1 | enum('NOT_APPLICABLE_MINUS_1','NO_CONTRIBUTING_CIRCUMSTANCES','ROAD_SURFACE_CONDITION','DEBRIS','LANE_CLOSURE','LANE_SHIFT_CLOSURE','WORK_ON_SHOULDER_OR_MEDIAN','INTERMITTENT_OR_MOVING_WORK','WORK_ZONE_OTHER','WORKERS_PRESENT','OBSTRUCTION_IN_ROADWAY','CHANGING_ROAD_WIDTH','NON_HIGHWAY_WORK','OTHER_97','UNKNOWN_99','TCD_INOPERATIVE_MISSING_OR_OBSCURED','SHOULDERS_NONE_LOW_SOFT_HIGH','RUT_HOLES_BUMPS','WORN_TRAVEL_POLISHED_SURFACE') | YES | | NULL | |
| eRoadCondition2 | enum('NOT_APPLICABLE_MINUS_1','NO_CONTRIBUTING_CIRCUMSTANCES','ROAD_SURFACE_CONDITION','DEBRIS','LANE_CLOSURE','LANE_SHIFT_CLOSURE','WORK_ON_SHOULDER_OR_MEDIAN','INTERMITTENT_OR_MOVING_WORK','WORK_ZONE_OTHER','WORKERS_PRESENT','OBSTRUCTION_IN_ROADWAY','CHANGING_ROAD_WIDTH','NON_HIGHWAY_WORK','OTHER_97','UNKNOWN_99','TCD_INOPERATIVE_MISSING_OR_OBSCURED','SHOULDERS_NONE_LOW_SOFT_HIGH','RUT_HOLES_BUMPS','WORN_TRAVEL_POLISHED_SURFACE') | YES | | NULL | |
| eRoadGrade | enum('LEVEL','DOWNHILL','UPHILL','HILLCREST','SAG_BOTTOM','BAD_VALUE_0','UNKNOWN_99') | YES | | NULL | |
| eSurfaceCondition1 | enum('DRY','WET','SNOW','SLUSH','ICE_FROST','WATER_STANDING_MOVING','SAND','MUD_DIRT_GRAVEL','OIL','BAD_VALUE_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eSurfaceCondition2 | enum('DRY','WET','SNOW','SLUSH','ICE_FROST','WATER_STANDING_MOVING','SAND','MUD_DIRT_GRAVEL','OIL','BLANK_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eTravelDirection | enum('NORTH','SOUTH','EAST','WEST','NORTHWEST','NORTHEAST','SOUTHWEST','SOUTHEAST','BAD_VALUE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eUnitAction | enum('GOING_STRAIGHT_AHEAD','SLOWING_IN_TRAFFICWAY','STOPPED_IN_TRAFFICWAY','MAKING_LEFT_TURN','MAKING_RIGHT_TURN','MAKING_U_TURN','OVERTAKING_PASSING','CHANGING_LANES','NEGOTIATING_A_CURVE','BACKING','AVOIDING_VEHICLE_OBJECT_PEDESTRIAN','ENTERING_PARKING_POSITION','LEAVING_PARKING_POSITION','PROPERLY_PARKED','IMPROPERLY_PARKED','DRIVERLESS_MOVING_VEHICLE','CROSSING_ROAD','WALKING_WITH_TRAFFIC','WALKING_AGAINST_TRAFFIC','STANDING','LYING','GETTING_ON_OR_OFF_VEHICLE','WORKING_ON_OR_PUSHING_VEHICLE','WORKING_ON_ROAD','BAD_VALUE_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eUnitType | enum('DRIVER','PEDESTRIAN','PEDALCYCLIST','DRIVERLESS','BAD_VALUE_0') | YES | | NULL | |
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
81 rows in set (0.08 sec)
mysql> describe 2012_person;
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| IncidentID | int(11) | YES | MUL | NULL | |
| UnitID | int(11) | YES | MUL | NULL | |
| UnitNumber | int(11) | YES | | NULL | |
| PersonID | int(11) | NO | PRI | NULL | |
| PersonNumber | int(11) | YES | | NULL | |
| PersonType | int(11) | YES | | NULL | |
| ZipCode | int(11) | YES | | NULL | |
| Age | int(11) | YES | | NULL | |
| Sex | char(1) | YES | | NULL | |
| SeatPosition | int(11) | YES | | NULL | |
| SafetyDevice | int(11) | YES | | NULL | |
| Airbag | int(11) | YES | | NULL | |
| InjuryStatus | int(11) | YES | | NULL | |
| Ejection | int(11) | YES | | NULL | |
| Extraction | int(11) | YES | | NULL | |
| NonMotoristLocation | int(11) | YES | | NULL | |
| AlcoholUseFlag | int(11) | YES | | NULL | |
| BACResult | float | YES | | NULL | |
| TestTypeA | int(11) | YES | | NULL | |
| DrugUseFlag | int(11) | YES | | NULL | |
| DrugType | int(11) | YES | | NULL | |
| TestTypeD | int(11) | YES | | NULL | |
| TransportSource | int(11) | YES | | NULL | |
| TransportedTo | text | YES | | NULL | |
| InjuryArea | int(11) | YES | | NULL | |
| InjuryDesc | int(11) | YES | | NULL | |
| Violation1 | int(11) | YES | | NULL | |
| Violation2 | int(11) | YES | | NULL | |
| LicenseClass | text | YES | | NULL | |
| Endorsement | text | YES | | NULL | |
| Restriction1 | text | YES | | NULL | |
| Restriction2 | text | YES | | NULL | |
| Physical0 | int(11) | YES | | NULL | |
| Physical1 | int(11) | YES | | NULL | |
| Physical2 | int(11) | YES | | NULL | |
| Physical3 | int(11) | YES | | NULL | |
| Physical4 | int(11) | YES | | NULL | |
| Physical5 | int(11) | YES | | NULL | |
| Physical6 | int(11) | YES | | NULL | |
| Physical97 | int(11) | YES | | NULL | |
| Physical99 | int(11) | YES | | NULL | |
| PhysicalA | int(11) | YES | | NULL | |
| PhysicalB | int(11) | YES | | NULL | |
| PhysicalC | int(11) | YES | | NULL | |
| PhysicalD | int(11) | YES | | NULL | |
| eAirbag | enum('NOT_DEPLOYED','DEPLOYED_FRONT','DEPLOYED_SIDE','DEPLOYED_OTHER_KNEE_AIR_BELT_ETC','DEPLOYED_COMBINATION','AIRBAG_SWITCH_OFF','NOT_APPLICABLE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eDrugType | enum('NO_DRUGS_REPORTED_NEGATIVE','MARIJUANA','COCAINE','OPIATE','AMPHETAMINE','PCP','BAD_VALUE_0','MINUS_1','OTHER_CONTROLLED_SUBSTANCE_87','TEST_REFUSED_95','NOT_GIVEN_96','OTHER_DRUG_97','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eEjection | enum('NOT_EJECTED','EJECTED_PARTIALLY','EJECTED_TOTALLY','UNKNOWN_DEGREE','NOT_APPLICABLE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eExtraction | enum('EXTRACTED','NOT_APPLICABLE_0','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eInjuryStatus | enum('NO_INJURY','POSSIBLE_INJURY','NON_INCAPACITATING_INJURY','INCAPACITATING_INJURY','FATAL','BAD_VALUE_0','UNKNOWN_99') | YES | | NULL | |
| eNonMotoristLocation | enum('MARKED_CROSSWALK_AT_INTERSECTION','AT_INTERSECTION_BUT_NO_CROSSWALK','NON_INTERSECTION_CROSSWALK','DRIVEWAY_ACCESS_CROSSWALK','SCHOOL_CROSSWALK','IN_ROADWAY_NOT_IN_A_CROSSWALK_OR_INTERSECTION','MEDIAN_BUT_NOT_ON_SHOULDER','ISLAND','SHOULDER','SIDEWALK','ROADSIDE','OUTSIDE_TRAFFICWAY','DEDICATED_BIKE_LANE','SHARED_USE_PATH_OR_TRAILS','INSIDE_BUILDING','NON_APPLICABLE_0','OTHER_97','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| ePersonType | enum('DRIVER','PEDESTRIAN','PEDALCYCLIST','PASSENGER','DRIVERLESS','BAD_VALUE_0') | YES | | NULL | |
| eSafetyDevice | enum('NONE_USED','LAP_BELT','SHOULDER_AND_LAP_BELT','CHILD_RESTRAINT_SYSTEM','HELMET_USED','AIR_BAG_DEPLOYED','AIR_BAG_DEPLOYED_LAP_SHOULDER_BELT','NOT_APPLICABLE_0','OTHER_97','UNKNOWN_99','NOT_REPORTED_255') | YES | | NULL | |
| eSex | enum('Male','Female','Unspec','null','error') | YES | | NULL | |
| eTestTypeA | enum('BLOOD_TEST','BREATH_TEST','URINE_TEST','SALIVA_TEST','TISSUE_TEST','NOT_USED','UNABLE_TO_ADMINISTER','REFUSED_TEST','UNKNOWN','PRELIMINARY_BREATH_TEST','TESTED_UNKNOWN_TEST_TYPE','MINUS_1','NO_TEST_0') | YES | | NULL | |
| eTransportSource | enum('EMS','LAW_ENFORCEMENT','MINUS_1','NOT_TRANSPORTED_0','OTHER_97','UNKNOWN_99') | YES | | NULL | |
| eViolation1 | enum('NO_IMPROPER_ACTION','SPEED_TOO_FAST_FOR_CONDITIONS','EXCEEDED_LAWFUL_SPEED','FOLLOWED_TOO_CLOSELY','RAN_STOP_SIGN','DISREGARDED_TRAFFIC_SIGNAL','MADE_IMPROPER_TURN','DROVE_RODE_IN_OPPOSING_TRAFFIC_LANE','KNOWINGLY_OPERATED_WITH_FAULTY_MISSING_EQUIPMENT','REQUIRED_MOTORCYCLE_SAFETY_EQUIPMENT_NOT_USED','PASSED_IN_NO_PASSING_ZONE','UNSAFE_LANE_CHANGE','FAILED_TO_KEEP_IN_PROPER_LANE','DISREGARDED_PAVEMENT_MARKINGS','OTHER_UNSAFE_PASSING','INATTENTION_DISTRACTION','DID_NOT_USE_CROSSWALK','WALKED_ON_WRONG_SIDE_OF_ROAD','ELECTRONIC_COMMUNICATIONS_DEVICE','PLACEHOLDER_20','NOT_APPLICABLE_MINUS_1','NOT_APPLICABLE_0','OTHER_97','UNKNOWN_99','FAILED_TO_YIELD_RIGHT_OF_WAY_103') | YES | | NULL | |
| eViolation2 | enum('NO_IMPROPER_ACTION','SPEED_TOO_FAST_FOR_CONDITIONS','EXCEEDED_LAWFUL_SPEED','FOLLOWED_TOO_CLOSELY','RAN_STOP_SIGN','DISREGARDED_TRAFFIC_SIGNAL','MADE_IMPROPER_TURN','DROVE_RODE_IN_OPPOSING_TRAFFIC_LANE','KNOWINGLY_OPERATED_WITH_FAULTY_MISSING_EQUIPMENT','REQUIRED_MOTORCYCLE_SAFETY_EQUIPMENT_NOT_USED','PASSED_IN_NO_PASSING_ZONE','UNSAFE_LANE_CHANGE','FAILED_TO_KEEP_IN_PROPER_LANE','DISREGARDED_PAVEMENT_MARKINGS','OTHER_UNSAFE_PASSING','INATTENTION_DISTRACTION','DID_NOT_USE_CROSSWALK','WALKED_ON_WRONG_SIDE_OF_ROAD','ELECTRONIC_COMMUNICATIONS_DEVICE','PLACEHOLDER_20','NOT_APPLICABLE_MINUS_1','NOT_APPLICABLE_0','OTHER_97','UNKNOWN_99','FAILED_TO_YIELD_RIGHT_OF_WAY_103') | YES | | NULL | |
+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
58 rows in set (0.07 sec)
mysql> \q
Bye
scott@Microknoppix:~/projects/Devel-Leak-0.03$ exit
exit
Script done on Sun Apr 6 02:29:00 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment