Data Points - NYC zip codes (PLEASE IGNORE - PROBLEM SOLVED)

[ericalucia]

Data Points - NYC zip codes (PLEASE IGNORE - PROBLEM SOLVED)

[jueyang]

Cool. I'll get back to you tonight!

On Mon, Feb 23, 2015 at 5:48 PM, ericalucia [email protected]
wrote:

Hello Jue,
I am still unsure of how to get the data points for the H.S. student zip
codes. I put both the lat/long and addresses in this updates csv file. Can
you help me find out how to actually map the data points? I think I either
need a walk through on CartoDB or the query.

https://gist.github.com/ericalucia/3c88d576eb9daab93cff

—
Reply to this email directly or view it on GitHub
#11.

[jueyang]

@ericalucia

File looks good, except it looks like a tsv (tab-seperate value) rather than a csv (comma-separated file.) All you need to do is to change the file name to dalton-hs-zipcode.tsv (Not using space in filenames is a good practice.) You could either upload your local file up to CartoDB, or just use the gist url.

If you use the gist url, click the raw button on your gist after you change the file name, and paste that url to create a CartoDB table.

Now just one step away from making points! You will probably notice a column called the_geom in your table once you created it. That is your dot on the map. You have this column because you already include latitude and longitude in the data.

See, CartoDB is smart! I looked at the file and for some reason a few rows didn't get a value. So the better thing to do here is to geocode the table again with CartoDB's geocoder. To do that:

• click the_geom column
• choose geocode by address in the prompt window
• the geocoder will run, and populate the_geom column with the new coordinates

Now go to "Map View". See the points?

In the next comment I will add things about selecting the zipcode.

[jueyang]

@ericalucia LOL just noticed your capped title. Gotcha. I'll close this issue :)

[ericalucia]

Jue,
To be honest I'm still not sure how I got to the point I did, but I have a
map now.

On Mon, Feb 23, 2015 at 7:19 PM, Jue Yang [email protected] wrote:

@ericalucia https://github.com/ericalucia LOL just noticed your capped
title. Gotcha. I'll close this issue :)

—
Reply to this email directly or view it on GitHub
#11 (comment)
.

[jueyang]

@ericalucia I'll post some fill-in-the-gap links to the class issue queue. CartoDB has pretty good docs. Hopefully that would answer some questions :)

[ericalucia]

Thank you Jue!

On Mon, Feb 23, 2015 at 7:32 PM, Jue Yang [email protected] wrote:

@ericalucia https://github.com/ericalucia I'll post some
fill-in-the-gap links to the class issue queue. CartoDB has pretty good
docs. Hopefully that would answer some questions :)

—
Reply to this email directly or view it on GitHub
#11 (comment)
.