Mapping the New York School Crime Rates


Lab Reports, Maps

Introduction

Not only the Tableau Public, Is there any other tools can analyze data by mapping?

3 Inspirations


  1. https://carto.com/gallery/internet-standards/
    I think this map is really clear about details. It is a good way to present a small number of highlights from the large data.

  2. https://carto.com/gallery/stolen-cars/
    I really like the colors, but consider the topic was about cars were stolen, I think maybe red can be stronger to represent this case.

  3. https://carto.com/gallery/lifewatch-inbo/
    It is a good example of the animated mapping. This shows that Carto is a great tool for presenting timeline-based data and showing the movement.

Process

Carto is a complexed tool, which requested the designer has to have clear thoughts about putting data in order. The process of refining the data is more complicated than others.

I download the data from the NYC Opendata.

Before importing the data to Carto, it is important to trans all the column to Numbers. After this, Carto can automatically recognize the data that can merge to the map. The School Information and the crime information were separated data.

After separately importing the two data, Carto supplies different types of ways to analyze the data.

Final Results

 

https://ememily.carto.com/builder/5853f180-10af-4e06-87d0-d9acc5649844/embed

Future Direction

Carto is a great tool for mapping data. Especially for visualizing timeline-based data. A trend is an important element or marketing analytics.