I need help with the overall architecture/stack of my project.

I have many spreadsheets of data with zip codes, categories, and numerical values (and a ton of other columns that will eventually be made available). I want the user to be able to select different areas or categories from a dropdown and have those zip codes web-mapped in a choropleth to compare zip codes.

A simplified version of this data looks like this:
| Zip     |Year       | Type of vehicle   | Number of vehicles 
| 12345   |2017       | pickup truck      | 3
| 12345   |2018       | pickup truck      | 9
| 12345   |2017       | sedan             | 4
| 12345   |2018       | sedan             | 9

In short, the user gets to choose: which year, which type of vehicle, and which zip(s) to display. Then I want it on a choropleth map.

In the past I have just created GeoJSON objects for each combination of data to present, but in this case I have lots of combinations and I am expecting to ingest more data every few months. I need a way to do this programatically.

I had initially planned to develop on WAMP stack since that's what my IT department is using and I'd like to eventually have them host it. But I'm running into a problem where I can pull the values I want from the MySQL DB, but I'm not sure how to then have a web map display polygons of zip codes choroplethed by numerical values from the DB.

Is there a way to host a web map (say Mapbox) with a geojson of zip polygons, and then color them according to the values I pull from the DB?

I am open to changing the stack to something that can support geodata, but I've never done it before and don't know where to start.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.