Step 1: Switch from "Maps" to "Datasets" and find the NEW DATASET button.
Step 2: The raw data that you want to import lives at https://gist.githubusercontent.com/amandabee/39a6db5da70f6c454a06d81d1759d0c2/raw/1a5475c0689e794a0c3c9620ebfc708c03ea2c1c/Subtotals_by_District.csv -- I found that by clicking the RAW button on the CSV (below)
Step 3: Rename your dataset to something civilized like "YTD Complaints" (actually, rename it exactly that. "YTD Complaints")
Step 4: You'll notice that there's a new, empty column called "The Geom" -- we need to fill that column. So find your way to https://amandabee.carto.com/viz/e2357457-bc5b-425a-9fec-a618743ce856/map and use the Create Map button to copy my shapefiles onto your account.
Step 5: When you're looking at the data view, on the lower right-hand side of the screen you should see a button that is labeled "merge datasets" -- select it. We're going to do a "Column Join". If you look at the original , it is a lot easier to see the district column. When you import it into Carto it will re-order all your columns, but you're looking for the district column. If you look at the data in the Oakland City Council Districts map, you'll notice that there is also a district column but it is empty. So which column should you actually use? (You want name)
Step 6: Choose the columns to merge. I'd leave all the complaints columns but kill most of the Council District columns. Just keep councilmem and dist.
Step 7: Use the Wizard to make a Choropleth map of "All Dumping" or "Dumping Subtotal" -- the most important switch to flip is the Quantification -- that should be set to Equal Interval.
- Try a different basemap.
- Add some hover content.
Questions:
- Do we need to normalize this by the population?
- What do we know about dumping, based on this map? What do we not know?
- What would your next steps be if you wanted to write about this?
Last Step: You'll never regret a little housekeeping. Select Edit Metadata and fill in some of the metadata. What is this map? Where did you get the data? It's a good habit.
note: You won't be able to do much more than this with your stock free Carto account. But if you head over to https://education.github.com/pack you can get an expanded free account.