De la sociedad por acciones simplificada
XII. La forma de administración de la sociedad
The PR DTPW crash database is operated and managed by the Accident Analysis Office (AAO). The database consists of all the data entered in crash reports, representing more than 230,000 data entered per year from 1997 to 2011, except year 2001, with incomplete data for years 2010 and 2011. The limitations in the data gathering process of the AAO resulted in a serious evaluation of data fields needed to perform on a yearly based crash analysis in Puerto Rico. After this evaluation, performed with the help of the Traffic Engineering and Operational Area (PRHTA) and the PRTSC, the AAO reduced the fields entered in the database and began to use only Fatal and Injury crashes (F+I) for their crash analysis. In order to gather a tool for faster and deeper crash evaluations, the PRTSC has an agreement with the University of Puerto Rico (Río Piedras campus). Through the execution of this agreement, the University contracted the staff of the Center for Advanced Public Safety (CAPS) at the University of Alabama.
The Center for Advanced Public Safety, at The University of Alabama, is a research and development center dedicated to the use of information technology to help improve society by performing crime, accidents, and other analyses that impact people positively. CAPS has more than thirty years of experience in the traffic safety industry in the United States. The following products from CAPS have received the support from local and national government agencies in the USA:
eCite: Comprehensive electronic citation issuance and processing system
o Mobile Officer’s Virtual Environment (MOVE): enables officers to operate their computer systems from anywhere on the highway
2 2
22
eCrash: Electronic crash reporting and transmission procedure used with MOVE (gather and stores information)
CARE: Data analysis software package used for problem identification and countermeasure development in traffic safety and others applications (criminal justice, emergency management, questionnaires, etc.)
The Critical Analysis Reporting Environment (CARE) is being used to provide to the decision-makers a practical report on crash analysis. This is because it is a crash data analysis software system that has an easy-to-use interface which turns data into information. This software has the following capabilities (CARE, 2014):
Statistical Generation
Data Analysis
Information Mining Capability
Analysis of Non-categorical Variables
Narrative Data Searching (subject to data availability)
Hotspot Determination
Report Generation
Collision Diagram Generation (subject to data availability)
GIS Integration (subject to data availability)
Traditionally, agencies often maintain crash databases in the following three different tables: crash, vehicle, and person. The crash table includes all the attributes of the crash such as crash type, severity, roadway condition, weather condition, etc. The vehicle table includes specific details about the vehicles involved in the crash such as the vehicle type, make and model of the vehicle, etc. Finally, the person table includes details on all the road users involved in the crash and includes person-level information such as age, gender, seating position, etc. For example, a crash involving two vehicles with three occupants in the two vehicles will have one record in the crash table, two records in the vehicle table, and three records in the person table. Note that all these tables could be linked through a unique ID, the crash number or the PAR number.
For PR data, the DTPW and the CAPS personnel worked together to develop a crash database that integrates data from a group of the 108 tables of the database. In other words, the CARE database does not include separate tables for the crashes, vehicles, and occupants; all the important information is compiled into one table. Note that each record in this table corresponds to one crash. The future crash data entry improvements could include providing the complete relational database with the crash, vehicle, and person tables.
CARE version 10.0.0.22 has Puerto Rico crash data for years 2002 through 2009, and for year 2012. The database includes all crashes (i.e., fatal, injury, and property damage only (PDO) crashes) for the years 2002 to 2006 and only fatal and injury (F+I) crashes for the years 2007 to 2009 and 2012. More specifically, the following data variables and their attributes are included in CARE database:
Year (2002-2009, 2012)
Month
Day of month
Day of the week
Week of the year
2 3
23
Time of day
Date
Related event (most harmful)
Overturn Two vehicles Mailbox
Fire/explosion Three or more vehicles Traffic sign
Submerged Pedestrian hit and run Back-slope
Gas inhalation Hit and run Bridge
Spilled load Stationary vehicle Building
Leakage/spilling Cyclist Fence
Irregular road surface Cyclist hit and run Other fixed object
Fell off cliff Motorcyclist Pothole
Collapsed road/bridge Motorcyclist with fixed
object Agricultural equipment
Jackknifed Animal barrier Construction equipment
Motorcycle overturned Safety drums Storm drain
Fallen person Utility poles Other with collision
Other event without
collision Trees
Pedestrian Fire hydrant
Collision type
Entering intersection at an angle A parked vehicle
In the same direction – posterior A vehicle stopped on pavement
In the same direction – turning A vehicle parking or reversing
In the same direction – side A vehicle exiting a parking space
In the opposite direction – front A vehicle entering a private entrance
In the opposite direction – turning A vehicle exiting a private entrance
In the opposite direction – side Not available
Contributing circumstances
Left crash scene Vision obstructed Vehicle to the left
Under the influence of
alcohol Driver lost control Failure to obey signal
Failure to yield Mechanical defect Over-extended load
Disregarded traffic control Roadway defect Street racing
Exceeded speed limit Driver too slow Pedestrian violation
Avoid object/person Overloaded Weight/height/width of vehicle
Improper turn Climate/weather Failure to dim
Following too closely Inappropriate trailer hitch Load fell off
Improper lane change Driver condition Didn’t see person/object
Improper reverse Wrong way Defective traffic light
2 4
24
Improper passing Vehicle pushing another
vehicle Other
Failure to signal Person pushing vehicle None
Number of vehicles involved
Number of pedestrians involved
Number of injured
Number of fatalities
Crash type
Fatal
Injury
PDO
Road surface condition
Dry
Wet
Muddy
Other
Roadway characteristics
Straight-level Curve-downhill
Straight-downhill Curve-uphill
Straight-uphill Curve-hill top
Straight-hill top Other
Curve-level Unknown
Traffic control
Police/work zone flagger Yield sign
Pedestrian control No passing zone
Traffic light Other
Flashing traffic light Unknown
Stop sign
Lighting condition
Daytime Dark with lighting
Sunrise Dark without lighting
Sunset Unknown
Weather condition
Foggy Cloudy
Windy Rainy
Clear Other
Location type
Intersection of two state roads
Intersection of one state road and one municipal road
Intersection of two municipal roads
2 5
25
State road with kilometer marker (non-intersection)
Road or street with section number (urban area)
Road or street without intersection, kilometer marker or section number
Unknown
Police precinct/district
Arecibo Highway Dorado District Patillas District West Bayamón Precinct Bayamon Highway Fajardo District Peñuelas District South Bayamón Precinct Caguas Highway Florida District Ponce District Bo. Obrero Precinct Fajardo Highway Guánica District Quebradillas District Loiza St. Precinct Guayama Highway Guayama District Rincón District North Carolina Precinct Ponce Highway Guayanilla District Rio Grande District West Carolina Precinct San Juan Highway Guaynabo District Rio Piedras District South Carolina Precinct Adjuntas District Gurabo District Sabana Grande District Castañer Precinct Aguada District Hatillo District Salinas District Cedro Arriba Precinct Aguadilla District Hormigueros District San Germán District Cupey Precinct Aguas Buenas District Humacao District San Juan District El Tuque Precinct Aibonito District Isabela District San Lorenzo District East Hato Rey Precinct Añasco District Jayuya District San Sebastián District West Hato Rey Precinct Arecibo District Juana Díaz District Santa Isabel District Juan Domingo Precinct Arroyo District Juncos District Toa Alta District La Playa Precinct Barceloneta District Lajas District Toa Baja District La Rambla Precinct Barranquitas District Lares District Utuado District Mameyes Precinct Cabo Rojo District Las Marías District Vega Alta District North Mayaguez Precinct Caguas District Las Piedras District Vega Baja District South Mayaguez Precint Camuy District Levittown District Vieques District Monte Hatillo Precint Canóvanas District Loíza District Villalba District Morell Campos Precint Cataño District Luquillo District Yabucoa District Parada 19 Precint Cayey District Manatí District Yauco District Puerto Nuevo Precint Ceiba District Maricao District Traffic Division Sabana Hoyos Precint Ciales District Maunabo District Carolina Traffic Division
Station A
North Trujillo Alto Precint
Cidra District Mayagüez District Caimito Precint South Trujillo Alto Precint Coamo District Moca District Airport Precint Touristic Zone Precint Comerío District Morovis District Angeles Precint Traffic Sub-Div. Bayamon Corozal District Naguabo District Highway Precint Aibonito Traffic Div.
Culebra District Naranjito District Ramey Base Precint Dajaos District Orocovis District North Bayamón Precint
Municipality
2 6
26
Adjuntas Cataño Hatillo Maunabo San Germán
Aguada Cayey Hato Rey Mayagüez San Juan
Aguadilla Ceiba Hormigueros Moca San Lorenzo
Aguas Buenas Ciales Humacao Morovis San Sebastián
Aibonito Cidra Isabela Naguabo Santa Isabel
Añasco Coamo Isla Verde Naranjito Santurce
Arecibo Comerío Jayuya Orocovis Toa Alta
Arroyo Corozal Juana Díaz Patillas Toa Baja
Barceloneta Culebra Juncos Peñuelas Trujillo Alto
Barranquitas Dorado Lajas Ponce Utuado
Bayamón Fajardo Lares Puerto Nuevo Vega Alta
Bo. Obrero Florida Las Marías Quebradillas Vega Baja
Cabo Rojo Guánica Las Piedras Rincón Vieques
Caguas Guayama Loiza Rio Grande Villalba
Camuy Guayanilla Luquillo Rio Piedras Yabucoa
Canóvanas Guaynabo Manatí Sabana Grande Yauco
Carolina Gurabo Maricao Salinas Unknown
Road class and jurisdiction
Primary state road (regional)
Secondary state road (inter municipal)
Tertiary state road (intra municipal)
Street (municipal road)
Unknown
Causing Unit (CU) driver gender
Male
Female
Unknown
CU driver age
CU driver authorized
Yes
No
Unknown
2 7
27
CU driver condition
Normal Inebriated
Fatigued Under the influence of drugs
Drunk Other
Learner driver Unknown
CU vehicle type
Car Motorcycle
Small truck Bicycle
Pick-up Agricultural machine
Van Road equipment
Semi-tractor (cab) Trailer
Truck Mobile home
Bus Jeep
School bus Other
Crane
CU contributing circumstance
Left scene of the crash Vision obstructed Vehicle to the left
Under the influence of
alcohol Driver lost control Failure to obey signal
Failure to yield Mechanical defect Over-extended load
Disregard traffic
control Roadway defect Street racing
Exceeded speed limit Driver too slow Pedestrian violation
Avoid object/person Overloaded Weight/height/width of
vehicle
Improper turn Climate/weather Failure to dim
Following too closely Inappropriate trailer
hitch Load fell off
Improper lane change Driver condition Didn’t see person/object
Improper reverse Wrong way Defective traffic light
Improper passing Vehicle pushing another
vehicle Other
Failure to signal Person pushing vehicle None
CU seatbelt use
2 8
28
CU vehicle direction
o North o Southwest
o Northeast o West
o East o Northwest
o Southeast o Unknown
o South
Motorcycle involved
Bicycle involved
Passenger vehicle involved
Truck or van involved
Heavy vehicle involved
Young victims involved
Youth victims involved
Adult victims involved
Older victims involved
Elderly victims involved
Male victims involved
Female victims involved
Young drivers involved
Youth drivers involved
Adult drivers involved
Older drivers involved
Elderly drivers involved
Male drivers involved
Female drivers involved
Has Global Positioning System (GPS) o Provided by officer
o Derived from route and kilometer (KM) o Removed as invalid
o N/A
2 9
29