AccidentsAPI is a RESTful API that provides information about accidents that occurred in Madrid in 2022. It allows users to retrieve accident data, including details of the accidents and associated passenger information.
- Java
- JPA
- Spring Boot
- Hibernate
- MySQL
- Maven
- Swagger
- Java Development Kit (JDK) 8 or higher
- MySQL database
Accident Fields:
| Field | English Description | Spanish Description |
|---|---|---|
| recordNumber | The record number of the accident | Número de registro del accidente |
| date | The date of the accident (format: dd/mm/yyyy) | Fecha del accidente (formato: dd/mm/aaaa) |
| time | The time of the accident | Hora del accidente |
| location | The location of the accident | Ubicación del accidente |
| number | The number associated with the accident | Número asociado al accidente |
| districtCode | The district code of the accident | Código del distrito del accidente |
| district | The district where the accident occurred | Distrito donde ocurrió el accidente |
| accidentType | The type of accident | Tipo de accidente |
| weatherCondition | The weather condition at the time of the accident | Condición climática en el momento del accidente |
| coordinateXUtm | The X-coordinate in the UTM coordinate system | Coordenada X UTM en el sistema de coordenadas UTM |
| coordinateYUtm | The Y-coordinate in the UTM coordinate system | Coordenada Y UTM en el sistema de coordenadas UTM |
| passengers | A list of passengers involved in the accident | Lista de pasajeros involucrados en el accidente |
| accidentType | English Description | Spanish Description |
|---|---|---|
| Rear-end | Alcance | |
| Animal collision | Atropello a animal | |
| Pedestrian collision | Atropello a persona | |
| Fall | Caída | |
| Collision with a fixed obstacle | Choque contra obstáculo fijo | |
| Frontal collision | Colisión frontal | |
| Frontal-lateral collision | Colisión fronto-lateral | |
| Lateral collision | Colisión lateral | |
| Multiple collision | Colisión múltiple | |
| Fall from a height | Despeñamiento | |
| Other | Otro | |
| Single vehicle road departure | Solo salida de la vía | |
| Rollover | Vuelco |
| weatherCondition | English Description | Spanish Description |
|---|---|---|
| Clear | Despejado | |
| Hail | Granizando | |
| Light rain | Lluvia débil | |
| Heavy rain | Lluvia intensa | |
| Snowing | Nevando | |
| Cloudy | Nublado | |
| Unknown | Se desconoce |
| district |
|---|
| ARGANZUELA |
| BARAJAS |
| CARABANCHEL |
| CENTRO |
| CHAMARTÍN |
| CHAMBERÍ |
| CIUDAD LINEAL |
| FUENCARRAL-EL PARDO |
| HORTALEZA |
| LATINA |
| MONCLOA-ARAVACA |
| MORATALAZ |
| PUENTE DE VALLECAS |
| RETIRO |
| SALAMANCA |
| SAN BLAS-CANILLEJAS |
| TETUÁN |
| USERA |
| VICÁLVARO |
| VILLA DE VALLECAS |
| VILLAVERDE |
Passengers:
| Field | English Description | Spanish Description |
|---|---|---|
| id | The identifier of the passenger | Identificador del pasajero |
| personType | The type of person involved | Tipo de persona involucrada |
| ageRange | The age range of the person | Rango de edad de la persona |
| gender | The gender of the person | Género de la persona |
| severityType | The severity of the person's injuries | Gravedad de las lesiones de la persona |
| positiveAlcohol | Indicates whether the person tested positive for alcohol (Y/N) | Indica si la persona dio positivo en la prueba de alcohol (S/N) |
| vehicleType | The type of vehicle the person was in | Tipo de vehículo en el que se encontraba la persona |
Severity Codes:
| Severity Code | English Description | Spanish Description |
|---|---|---|
| 1 | MILD - Emergency care without subsequent hospitalization | LEVE - Atención de emergencia sin hospitalización posterior |
| 2 | MILD - Hospitalization up to 24 hours | LEVE - Hospitalización hasta 24 horas |
| 3 | SEVERE - Hospitalization exceeding 24 hours | GRAVE - Hospitalización superior a 24 horas |
| 4 | FATAL - Deceased within 24 hours | FATAL - Fallecido dentro de las 24 horas |
| 5 | MILD - Outpatient care after the accident | LEVE - Atención ambulatoria después del accidente |
| 6 | MILD - Immediate medical care at a health center | LEVE - Atención médica inmediata en un centro de salud |
| 7 | MILD - Medical care only at the scene of the accident |
All requests must be made with Spanish values
For the documentation we use Swagger: http://localhost:8080/swagger-ui/index.html#/
-
Clone the repository: git clone https://github.com/your-username/accidents-api.git
-
Configure the database connection in the
application.propertiesfile -
Build the project using Maven: mvn clean install
-
Start the server: The API will be accessible at
http://localhost:8080.
Contributions are welcome! If you find any issues or have suggestions for improvements, please create a new issue or submit a pull request.