nononoexe / rtadb

Database for analysis of road traffic accidents

Road Traffic Accident Database

Road Traffic Accident Database (RTADB) is the database for analysis of road traffic accidents. The database is scalable using your data set related to traffic accidents. This repository contains scripts that build the database for analyzing traffic accident data.

🚀Usage

Starting Up the Database

Make sure you have docker installed.

In order to run the container capable of serving a PostGIS-enabled database, the following command at the root of your project:

docker-compose up -d --build

After executing the command, you can open RStudio as the analysis environment by accessing http://localhost:8787.

About postgis/postgis image used this container, see the page.

Sample Database

Once you have started a database container, you can build the sample database using the R script(depends R ≥ 4.1) contained in this repository.

The sample database contains followings:

• Road traffic accidents data
• Administrative area data
• Land use data
• Traffic volume data
• Japanese regional grid squares data

To use these data, download each and place it in dir, data-raw/[data-name]/

Each data using the sample database be obtained from followings:

Directory	Description	Download
traffic-accidents	Traffic accident data provided by Aichi prefectural police.	-
administrative-areas	Information on administrative areas such as cities and wards. Information on the names of the administrative districts of Aichi Prefecture is included in aichi.csv. Spatial information on administrative areas is provided by R Package 'jpndistrict'.	-
population-census	Population of each municipality in Aichi Prefecture.	here
land-use	Data classified by land in Aichi Prefecture.	here
traffic-volumes-points	Location data of the spot traffic volume measurement points. The detailed version A of location information of spot traffic volume is included.	-
traffic-volumes	Spot traffic volume mesurement data.	here

📝License

This project is MIT licensed.