search

jueyang / call-me-maybe

Use the issue queue. Dark secrets welcome. (CUNY-J teaching 2015)
3 stars 0 forks source link

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

Closed ericalucia closed 9 years ago

ericalucia commented 9 years ago

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

jueyang commented 9 years ago

Cool. I'll get back to you tonight!

On Mon, Feb 23, 2015 at 5:48 PM, ericalucia notifications@github.com 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 https://github.com/jueyang/call-me-maybe/issues/11.

jueyang commented 9 years ago

@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:

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

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

jueyang commented 9 years ago

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

ericalucia commented 9 years ago

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 notifications@github.com 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 https://github.com/jueyang/call-me-maybe/issues/11#issuecomment-75670256 .

jueyang commented 9 years ago

@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 commented 9 years ago

Thank you Jue!

On Mon, Feb 23, 2015 at 7:32 PM, Jue Yang notifications@github.com 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 https://github.com/jueyang/call-me-maybe/issues/11#issuecomment-75673278 .