![[vision-zero.png|500]] [Vision Zero](https://www.boston.gov/transportation/vision-zero) is an initiative to eliminate fatal traffic crashes in Boston. It was originally a manual process to collect and publish the data and reconcile GIS issues. One of my projects was to automate this process which I was successful in and thus created the city's first automated GIS data pipeline. I used [PostGIS](https://postgis.net/) which is a PostgreSQL extension that adds support for storing and querying geospatial data. More specifically, I used PostGIS functions to run geospatial transformations such as snapping crash data points to the correct street segment in our streets dataset. I learned a lot about spatial reference systems, projections, and how to properly visualize geospatial data in different parts of the world.