StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16319806
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-01T14:16:18.190
FavoriteCount
0
LastActivityDate
2013-05-01T14:36:31.417
LastEditDate
2013-05-01T14:36:31.417
LastEditorUserId
244461
OwnerUserId
244461
ParentId
15556081
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I intend to do something similar for all the counties in US and so I have collected some information that might be of use to you. Here's the overall approach. <ol> <li>Collect the data like list of counties each with it's FIPS id, display name and svg map. This information is in <a href="http://commons.wikimedia.org/wiki/File:Blank_Map_of_Arizona.svg" rel="nofollow noreferrer">public domain</a>. Like the blank SVG map of Arizona shown below.</li> </ol> <img src="https://i.stack.imgur.com/IVmPt.png" alt="svg map of arizona"> <ol start="2"> <li>Store all this data by county id in a database like MySQL or whatever you fancy. Add the data pertaining to schools. Now you can export the subset of data to a csv file for Analysis. I prefer using R. Once you have your map and data ready, proceed to the next step.</li> <li>You can overlay this data on the map using Raphael as shown in <a href="http://jebruner.com/2011/11/how-to-build-an-interactive-map-with-open-source-tools/" rel="nofollow noreferrer">this article</a> </li> </ol> or Use this open source JQuery <a href="http://newsignature.github.io/us-map/" rel="nofollow noreferrer">plugin</a> and customize it to create your own clickable heatmap. Let me know how you progress and we can bounce some ideas. EDIT: Here's another <a href="http://flowingdata.com/2009/11/12/how-to-make-a-us-county-thematic-map-using-free-tools/#more-3581" rel="nofollow noreferrer">nice article</a> how to make a Choropleth using free tools. This look slike the best approach to make what you are going after. It uses Python so it should be neat and clean.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POcreating choropleth map of Arizona with counties and an excel file of data about the counties
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USRHT
UserOwnerUserId
1. USRHT
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.