Group Abstract

Message Boards

WOLFRAM COMMUNITY

10.7K Views

4 Replies

3 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Data Science Geographic Information System

How do I make a map of several zipcodes or countries?

Jorge Mahecha

Jorge Mahecha, Boston College

Posted 8 years ago

Hey, Community. I have a list of zipcodes, and for each zipcode I have certain data, say for example the number of people from that zipcode who took a test (this is known data). Picture a spreadsheet with column 1, zipcodes, column 2 , number of people who took the test. How do I make a map showing those zipcodes? Could I label each zipcode with the number of people who took the test? How? Thank you.

POSTED BY: Jorge Mahecha

4 Replies

Sort By:

Valery Syssik

Posted 5 years ago

How to: (https://download.geonames.org/export/zip/allCountries.zip) allCountries = Import["/Users/admin/Documents/allCountries.csv", {"TSV", "RawData"}]; zipToCoordinatesMexico = Association[ Map [#[[2]] -> Map[ToExpression, #[[10 ;; 11]]] &, Select[allCountries, #[[1]] == "MX" &] ]];

How to:

(*https://download.geonames.org/export/zip/allCountries.zip*)

allCountries = 
  Import["/Users/admin/Documents/allCountries.csv", {"TSV", 
    "RawData"}];

zipToCoordinatesMexico = 
  Association[
   Map [#[[2]] ->  Map[ToExpression, #[[10 ;; 11]]] &,  
    Select[allCountries, #[[1]] == "MX" &] ]];

POSTED BY: Valery Syssik

Jorge Mahecha

Jorge Mahecha, Boston College

Posted 8 years ago

I have a dataset of over a 1000 zipcodes so it takes a lot of time. I'm getting this weird message: It's really strange, for three reasons at least: The first, I've never sene a "Try again" message. What does that mean? The second reason is that 06883 is a valid zipcode that for example, Wolfram Alpha recognizes. The line I'm running is something like zips = Interpreter["ZIPCode"] /@ {"95014", "01545", "94087", "95129", "01810", "10471", "02067", "01720"...} It does not always interpret the same ZIP codes the right way. For example, the first time I ran it, there was no issue with code 94568, but the second time it showed the aforementioned error. What could be the issue? I'd appreciate any suggestions.