tilemill-project / tilemill

TileMill is a modern map design studio
https://tilemill-project.github.io/tilemill/
BSD 3-Clause "New" or "Revised" License
3.12k stars 527 forks source link

Exported GeoJSON file error #1480

Closed kaleeta closed 12 years ago

kaleeta commented 12 years ago

Went through the process of installing geo script for google docs, verifying the geocode addresses with mapquest, identifying the primary key-long-lat, then exported as GeoJson txt file....wheew I'm tired :). When I added the layer to my project I received the following error:

CSV Plugin: could not detect column headers with the name of wkt ,x/y, or latitude/longitude - this is required for reading geometry data

Here's my GeoJSON code....I couldn't find anything wrong, so I'm consulting "the man." Please advise.

{"features":[{"id":33.76164955,"properties":{"address":"659 Peachtree Street Northeast Atlanta, GA 30308","website":"www.thegeorgianterrace.com/","geo_accuracy":"secondary","purpose":"Hotel","geo_longitude":-84.38756735,"geo_latitude":33.76164955,"business":"Georgian Terrace Hotel"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.38756735,33.76164955]}},{"id":33.74802165,"properties":{"address":"65 Martin Luther King Jr Drive Southeast, Atlanta, GA 30334","website":"http://gba.georgia.gov/00/channel_title/0,2094,59377335_73933508,00.html","geo_accuracy":"secondary","purpose":"Venue","geo_longitude":-84.3844437,"geo_latitude":33.74802165,"business":"The Freight Room"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3844437,33.74802165]}},{"id":33.7794167079704,"properties":{"address":"997 Virginia Avenue Northeast Atlanta, GA 30306","website":"http://www.murphys-atlanta-restaurant.com/","geo_accuracy":"residential","purpose":"Rehearsal Dinner","geo_longitude":-84.3469483330671,"geo_latitude":33.7794167079704,"business":"Murphy's Restaurant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3469483330671,33.7794167079704]}},{"id":33.7407673266744,"properties":{"address":"180B Northside Drive Southwest Atlanta, GA 30313","website":"http://www.paschalsatlanta.com/","geo_accuracy":"primary","purpose":"Thanksgiving Dinner","geo_longitude":-84.4081690720122,"geo_latitude":33.7407673266744,"business":"Paschal's Restuarant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.4081690720122,33.7407673266744]}}],"type":"FeatureCollection"}

springmeyer commented 12 years ago

Ensure your geojson file has a .geojson or .json file extension. It appears that tilemill is interpreting it as csv, which must mean you gave a .txt or .csv extension?

On May 12, 2012, at 9:43 PM, kaleetareply@reply.github.com wrote:

Went through the process of installing geo script for google docs, verifying the geocode addresses with mapquest, identifying the primary key-long-lat, then exported as GeoJson txt file....wheew I'm tired :). When I added the layer to my project I received the following error:

CSV Plugin: could not detect column headers with the name of wkt ,x/y, or latitude/longitude - this is required for reading geometry data

Here's my GeoJSON code....I couldn't find anything wrong, so I'm consulting "the man." Please advise.

{"features":[{"id":33.76164955,"properties":{"address":"659 Peachtree Street Northeast Atlanta, GA 30308","website":"www.thegeorgianterrace.com/","geo_accuracy":"secondary","purpose":"Hotel","geo_longitude":-84.38756735,"geo_latitude":33.76164955,"business":"Georgian Terrace Hotel"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.38756735,33.76164955]}},{"id":33.74802165,"properties":{"address":"65 Martin Luther King Jr Drive Southeast, Atlanta, GA 30334","website":"http://gba.georgia.gov/00/channel_title/0,2094,59377335_73933508,00.html","geo_accuracy":"secondary","purpose":"Venue","geo_longitude":-84.3844437,"geo_latitude":33.74802165,"business":"The Freight Room"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3844437,33.74802165]}},{"id":33.7794167079704,"properties":{"address":"997 Virginia Avenue Northeast Atlanta, GA 30306","website":"http://www.murphys-atlanta-restaurant.com/","geo_accuracy":"residential","purpose":"Rehearsal Dinner"," geo_longitude":-84.3469483330671,"geo_latitude":33.7794167079704,"business":"Murphy's Restaurant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3469483330671,33.7794167079704]}},{"id":33.7407673266744,"properties":{"address":"180B Northside Drive Southwest Atlanta, GA 30313","website":"http://www.paschalsatlanta.com/","geo_accuracy":"primary","purpose":"Thanksgiving Dinner","geo_longitude":-84.4081690720122,"geo_latitude":33.7407673266744,"business":"Paschal's Restuarant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.4081690720122,33.7407673266744]}}],"type":"FeatureCollection"}


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480

kaleeta commented 12 years ago

Yeah, it exported as a txt. That's awesome, I'll make the change.

Thank you!!!

On May 13, 2012, at 1:20 AM, Dane Springmeyer reply@reply.github.com wrote:

Ensure your geojson file has a .geojson or .json file extension. It appears that tilemill is interpreting it as csv, which must mean you gave a .txt or .csv extension?

On May 12, 2012, at 9:43 PM, kaleetareply@reply.github.com wrote:

Went through the process of installing geo script for google docs, verifying the geocode addresses with mapquest, identifying the primary key-long-lat, then exported as GeoJson txt file....wheew I'm tired :). When I added the layer to my project I received the following error:

CSV Plugin: could not detect column headers with the name of wkt ,x/y, or latitude/longitude - this is required for reading geometry data

Here's my GeoJSON code....I couldn't find anything wrong, so I'm consulting "the man." Please advise.

{"features":[{"id":33.76164955,"properties":{"address":"659 Peachtree Street Northeast Atlanta, GA 30308","website":"www.thegeorgianterrace.com/","geo_accuracy":"secondary","purpose":"Hotel","geo_longitude":-84.38756735,"geo_latitude":33.76164955,"business":"Georgian Terrace Hotel"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.38756735,33.76164955]}},{"id":33.74802165,"properties":{"address":"65 Martin Luther King Jr Drive Southeast, Atlanta, GA 30334","website":"http://gba.georgia.gov/00/channel_title/0,2094,59377335_73933508,00.html","geo_accuracy":"secondary","purpose":"Venue","geo_longitude":-84.3844437,"geo_latitude":33.74802165,"business":"The Freight Room"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3844437,33.74802165]}},{"id":33.7794167079704,"properties":{"address":"997 Virginia Avenue Northeast Atlanta, GA 30306","website":"http://www.murphys-atlanta-restaurant.com/","geo_accuracy":"residential","purpose":"Rehearsal Dinner" ," geo_longitude":-84.3469483330671,"geo_latitude":33.7794167079704,"business":"Murphy's Restaurant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3469483330671,33.7794167079704]}},{"id":33.7407673266744,"properties":{"address":"180B Northside Drive Southwest Atlanta, GA 30313","website":"http://www.paschalsatlanta.com/","geo_accuracy":"primary","purpose":"Thanksgiving Dinner","geo_longitude":-84.4081690720122,"geo_latitude":33.7407673266744,"business":"Paschal's Restuarant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.4081690720122,33.7407673266744]}}],"type":"FeatureCollection"}


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5674085

springmeyer commented 12 years ago

Great. So, perhaps a note about this needs to be made to the tutorial you followed?

On May 13, 2012, at 7:25 AM, kaleetareply@reply.github.com wrote:

Yeah, it exported as a txt. That's awesome, I'll make the change.

Thank you!!!

On May 13, 2012, at 1:20 AM, Dane Springmeyer reply@reply.github.com wrote:

Ensure your geojson file has a .geojson or .json file extension. It appears that tilemill is interpreting it as csv, which must mean you gave a .txt or .csv extension?

On May 12, 2012, at 9:43 PM, kaleetareply@reply.github.com wrote:

Went through the process of installing geo script for google docs, verifying the geocode addresses with mapquest, identifying the primary key-long-lat, then exported as GeoJson txt file....wheew I'm tired :). When I added the layer to my project I received the following error:

CSV Plugin: could not detect column headers with the name of wkt ,x/y, or latitude/longitude - this is required for reading geometry data

Here's my GeoJSON code....I couldn't find anything wrong, so I'm consulting "the man." Please advise.

{"features":[{"id":33.76164955,"properties":{"address":"659 Peachtree Street Northeast Atlanta, GA 30308","website":"www.thegeorgianterrace.com/","geo_accuracy":"secondary","purpose":"Hotel","geo_longitude":-84.38756735,"geo_latitude":33.76164955,"business":"Georgian Terrace Hotel"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.38756735,33.76164955]}},{"id":33.74802165,"properties":{"address":"65 Martin Luther King Jr Drive Southeast, Atlanta, GA 30334","website":"http://gba.georgia.gov/00/channel_title/0,2094,59377335_73933508,00.html","geo_accuracy":"secondary","purpose":"Venue","geo_longitude":-84.3844437,"geo_latitude":33.74802165,"business":"The Freight Room"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3844437,33.74802165]}},{"id":33.7794167079704,"properties":{"address":"997 Virginia Avenue Northeast Atlanta, GA 30306","website":"http://www.murphys-atlanta-restaurant.com/","geo_accuracy":"residential","purpose":"Rehearsal Dinner " ," geo_longitude":-84.3469483330671,"geo_latitude":33.7794167079704,"business":"Murphy's Restaurant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3469483330671,33.7794167079704]}},{"id":33.7407673266744,"properties":{"address":"180B Northside Drive Southwest Atlanta, GA 30313","website":"http://www.paschalsatlanta.com/","geo_accuracy":"primary","purpose":"Thanksgiving Dinner","geo_longitude":-84.4081690720122,"geo_latitude":33.7407673266744,"business":"Paschal's Restuarant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.4081690720122,33.7407673266744]}}],"type":"FeatureCollection"}


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5674085


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5676609

kaleeta commented 12 years ago

I think that would help. And you may want to add that google docs always downloads the file as a txt and just changing the txt to geojson doesn't work. You have to copy the code in dreamweaver using a js file then save the file as geojson. I know it sounds weird but that's the only way I could get it to work. :) Thanks for your speedy response. :)

--- On Sun, 5/13/12, Dane Springmeyer reply@reply.github.com wrote:

From: Dane Springmeyer reply@reply.github.com Subject: Re: [tilemill] Exported GeoJSON file error (#1480) To: "kaleeta" kaleeta_wright@yahoo.com Date: Sunday, May 13, 2012, 1:28 PM

Great. So, perhaps a note about this needs to be made to the tutorial you followed?

On May 13, 2012, at 7:25 AM, kaleetareply@reply.github.com wrote:

Yeah, it exported as a txt. That's awesome, I'll make the change.

Thank you!!!

On May 13, 2012, at 1:20 AM, Dane Springmeyer reply@reply.github.com wrote:

Ensure your geojson file has a .geojson or .json file extension. It appears that tilemill is interpreting it as csv, which must mean you gave a .txt or .csv extension?

On May 12, 2012, at 9:43 PM, kaleetareply@reply.github.com wrote:

Went through the process of installing geo script for google docs, verifying the geocode addresses with mapquest, identifying the primary key-long-lat, then exported as GeoJson txt file....wheew I'm tired :). When I added the layer to my project I received the following error:

  CSV Plugin: could not detect column headers with the name of wkt ,x/y, or latitude/longitude - this is required for reading geometry data

Here's my GeoJSON code....I couldn't find anything wrong, so I'm consulting "the man." Please advise.

{"features":[{"id":33.76164955,"properties":{"address":"659 Peachtree Street Northeast  Atlanta, GA 30308","website":"www.thegeorgianterrace.com/","geo_accuracy":"secondary","purpose":"Hotel","geo_longitude":-84.38756735,"geo_latitude":33.76164955,"business":"Georgian Terrace Hotel"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.38756735,33.76164955]}},{"id":33.74802165,"properties":{"address":"65 Martin Luther King Jr Drive Southeast, Atlanta, GA 30334","website":"http://gba.georgia.gov/00/channel_title/0,2094,59377335_73933508,00.html","geo_accuracy":"secondary","purpose":"Venue","geo_longitude":-84.3844437,"geo_latitude":33.74802165,"business":"The Freight Room"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3844437,33.74802165]}},{"id":33.7794167079704,"properties":{"address":"997 Virginia Avenue Northeast  Atlanta, GA 30306","website":"http://www.murphys-atlanta-restaurant.com/","geo_accuracy":"residential","purpose":"Rehearsal Dinne r " ," geo_longitude":-84.3469483330671,"geo_latitude":33.7794167079704,"business":"Murphy's Restaurant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.3469483330671,33.7794167079704]}},{"id":33.7407673266744,"properties":{"address":"180B Northside Drive Southwest  Atlanta, GA 30313","website":"http://www.paschalsatlanta.com/","geo_accuracy":"primary","purpose":"Thanksgiving Dinner","geo_longitude":-84.4081690720122,"geo_latitude":33.7407673266744,"business":"Paschal's Restuarant"},"type":"Feature","geometry":{"type":"Point","coordinates":[-84.4081690720122,33.7407673266744]}}],"type":"FeatureCollection"}


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5674085


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5676609


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5678260

tmcw commented 12 years ago

Hey, updated the blog post on MapBox to that effect. Thanks for pointing this out!

kaleeta commented 12 years ago

Thanks Tom!!  I love your development team! Great documentation. :)

--- On Mon, 5/21/12, Tom MacWright reply@reply.github.com wrote:

From: Tom MacWright reply@reply.github.com Subject: Re: [tilemill] Exported GeoJSON file error (#1480) To: "kaleeta" kaleeta_wright@yahoo.com Date: Monday, May 21, 2012, 4:32 PM

Hey, updated the blog post on MapBox to that effect. Thanks for pointing this out!


Reply to this email directly or view it on GitHub: https://github.com/mapbox/tilemill/issues/1480#issuecomment-5834330