{"repo":"agude/SWITRS-to-SQLite","free":true,"listed":false,"github":"https://github.com/agude/SWITRS-to-SQLite","clone":"git clone https://github.com/agude/SWITRS-to-SQLite.git","description":"Python script for converting California's Statewide Integrated Traffic Records System (SWITRS) reports to SQLite.","language":"Python","stars":12,"topics":["python","database","sqlite","switrs","conversion"],"license":null,"category":"databases-storage","readme_excerpt":"SWITRS-to-SQLite Looking to get right to work with the data? Check out the cleaned dataset on Kaggle: [California Traffic Collision Data from SWITRS][kaggle] [kaggle]: https://www.kaggle.com/alexgude/california-traffic-collision-data-from-switrs SWITRS-to-SQLite is a Python 3 script that converts the CSV files from the California Highway Patrol's Statewide Integrated Traffic Records System (SWITRS) into an SQLite database. Note: CHP shut down iSWITRS on January 8, 2025 and replaced it with the [California Crash Reporting System (CCRS)][ccrs]. This tool works with the legacy SWITRS CSV format ( CollisionRecords.txt , PartyRecords.txt , VictimRecords.txt ). CCRS uses a different file layout; support for it is planned for a future release. [ccrs]: https://data.ca.gov/dataset/ccrs Versioning This repository follows [SemVer][semver]. I will increment the MAJOR version if a change is backwards incompatible for either the Python command line or the structure of the output database. [semver]: https://semver.org/ Installation The best way to install SWITRS-to-SQLite is with pip : Or with UV: This will give you access to the script simply by calling: Development Installation For development, clone the repository and use UV to sync the environment (this handles the local package installation automatically): SWITRS-to-SQLite requires Python 3.10+. Usage Using SWITRS-to-SQLite is simple; just point it to the unzipped files from SWITRS and it will run the conversion: The script also suppor","default_branch":null,"files":null,"tree":[],"storefront":"/r/agude","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/agude/SWITRS-to-SQLite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}