search

mapbox / csv2geojson

magically convert csv files to geojson files
http://mapbox.github.io/csv2geojson/
MIT License
364 stars 82 forks source link

Longitude Values Getting Messed Up #32

Closed DevelopIntelligenceBoulder closed 8 years ago

DevelopIntelligenceBoulder commented 9 years ago

Tried using the npm module and geojson.io to convert csv to geojson.

This is how the geojson ends up:

{ "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": { "rank": "1", "name": "Mount Elbert", "range": "Sawatch Range", "id": "1", "elevation": "14,440 ft\n4401 m", "prominence": "9,093 ft\n2772 m", "latitude": "39.1178", "image": "/img/Elbert2006.jpg" }, "geometry": { "type": "Point", "coordinates": [ -106.4454, 671 ] } },

The coordinates get messed up.

The same csv ends up fine using http://togeojson.com/

DevelopIntelligenceBoulder commented 9 years ago

Here's the csv

rank,name,range,id,elevation,prominence,isolation,longitude,latitude,image
1,Mount Elbert,Sawatch Range,1,"14,440 ft
4401 m","9,093 ft
2772 m","671 mi
1,079 km",-106.4454,39.1178,/img/Elbert2006.jpg
2,Mount Massive,Sawatch Range,2,"14,428 ft
4398 m","1,961 ft
598 m","5.1 mi
8.1 km",-106.4757,39.1875,/img/Elbert2006.jpg
3,Mount Harvard,Sawatch Range,3,"14,421 ft
4396 m","2,360 ft
719 m","15 mi
24 km",-106.3207,38.9244,/img/Massive.jpg
4,La Plata Peak,Sawatch Range,4,"14,368 ft
4379 m","1,861 ft
567 m","6 mi
10 km",-106.4729,39.0294,/img/Elbert2006.jpg
5,Blanca Peak,Sangre de Cristo Mountains,5,"14,351 ft
4374 m","5,326 ft
1623 m","103 mi
166 km",-105.4856,37.5775,/img/Massive.jpg
6,Uncompahgre Peak,San Juan Mountains,6,"14,321 ft
4365 m","4,277 ft
1304 m","85 mi
137 km",-107.4621,38.0717,/img/Elbert2006.jpg
7,Crestone Peak,Sangre de Cristo Mountains,7,"14,300 ft
4359 m","4,554 ft
1388 m","27 mi
44 km",-105.5855,37.9668,/img/Elbert2006.jpg
8,Mount Lincoln,Mosquito Range,8,"14,293 ft
4357 m","3,862 ft
1177 m","23 mi
36 km",-106.1116,39.3515,/img/Elbert2006.jpg
9,Castle Peak,Elk Mountains,9,"14,279 ft
4352 m","2,365 ft
721 m","21 mi
34 km",-106.8614,39.0097,/img/Elbert2006.jpg
10,Grays Peak,Front Range,10,"14,278 ft
4352 m","2,770 ft
844 m","25 mi
40 km",-105.8176,39.6339,/img/Elbert2006.jpg
11,Mount Antero,Sawatch Range,11,"14,276 ft
4351 m","2,503 ft
763 m","18 mi
28 km",-106.2462,38.6741,/img/Massive.jpg
12,Torreys Peak,Front Range,12,"14,274 ft
4351 m","560 ft
171 m","0.7 mi
1.1 km",-105.8212,39.6428,/img/Massive.jpg
13,Quandary Peak,Tenmile Range,13,"14,271 ft
4350 m","1,125 ft
343 m","3.2 mi
5.1 km",-106.1064,39.3972,/img/Elbert2006.jpg
14,Mount Evans,Front Range,14,"14,271 ft
4350 m","2,769 ft
844 m","10 mi
16 km",-105.6438,39.5883,/img/Massive.jpg
15,Longs Peak,Front Range,15,"14,259 ft
4346 m","2,940 ft
896 m","44 mi
70 km",-105.6151,40.255,/img/Elbert2006.jpg
16,Mount Wilson,San Miguel Mountains,16,"14,252 ft
4344 m","4,024 ft
1227 m","33 mi
53 km",-107.9916,37.8391,/img/Elbert2006.jpg
17,Mount Shavano,Sawatch Range,17,"14,235 ft
4339 m","1,619 ft
493 m","3.8 mi
6.1 km",-106.2394,38.6193,/img/Elbert2006.jpg
18,Mount Princeton,Sawatch Range,18,"14,204 ft
4329 m","2,177 ft
664 m","5.2 mi
8.4 km",-106.2424,38.7492,/img/Elbert2006.jpg
19,Mount Belford,Sawatch Range,19,"14,203 ft
4329 m","1,337 ft
408 m","3.3 mi
5.3 km",-106.3608,38.9606,/img/Elbert2006.jpg
20,Crestone Needle,Sangre de Cristo Mountains,20,"14,203 ft
4329 m","457 ft
139 m","0.4 mi
0.7 km",-105.5766,37.9647,/img/Massive.jpg
21,Mount Yale,Sawatch Range,21,"14,202 ft
4329 m","1,896 ft
578 m","5.5 mi
8.9 km",-106.3138,38.8442,/img/Elbert2006.jpg
22,Mount Bross,Mosquito Range,22,"14,178 ft
4322 m","312 ft
95 m","1.0 mi
1.6 km",-106.1076,39.3355,/img/Massive.jpg
23,Kit Carson Mountain,Sangre de Cristo Mountains,23,"14,171 ft
4319 m","1,025 ft
312 m","1.3 mi
2.1 km",-105.6026,37.9797,/img/Massive.jpg
24,Maroon Peak,Elk Mountains,24,"14,163 ft
4317 m","2,336 ft
712 m","8 mi
13 km",-106.989,39.0708,/img/Elbert2006.jpg
25,Tabeguache Peak,Sawatch Range,25,"14,162 ft
4317 m","455 ft
139 m","0.8 mi
1.2 km",-106.2509,38.6254,/img/Massive.jpg
26,Mount Oxford,Sawatch Range,26,"14,160 ft
4316 m","653 ft
199 m","1.2 mi
2.0 km",-106.3388,38.9648,/img/Massive.jpg
27,Mount Sneffels,San Juan Mountains,27,"14,158 ft
4315 m","3,050 ft
930 m","16 mi
25 km",-107.7923,38.0038,/img/Massive.jpg
28,Mount Democrat,Mosquito Range,28,"14,155 ft
4315 m","768 ft
234 m","1.3 mi
2.0 km",-106.14,39.3396,/img/Massive.jpg
29,Capitol Peak,Elk Mountains,29,"14,137 ft
4309 m","1,750 ft
533 m","7 mi
12 km",-107.0829,39.1503,/img/Elbert2006.jpg
30,Pikes Peak,Front Range,30,"14,115 ft
4302 m","5,530 ft
1686 m","61 mi
98 km",-105.0442,38.8405,/img/Elbert2006.jpg
31,Snowmass Mountain,Elk Mountains,31,"14,099 ft
4297 m","1,152 ft
351 m","2.3 mi
3.8 km",-107.0665,39.1187,/img/Elbert2006.jpg
32,Windom Peak,Needle Mountains,32,"14,093 ft
4296 m","2,187 ft
667 m","26 mi
42 km",-107.5919,37.6212,/img/Elbert2006.jpg
33,Mount Eolus,Needle Mountains,33,"14,090 ft
4295 m","1,024 ft
312 m","1.7 mi
2.7 km",-107.6227,37.6218,/img/Massive.jpg
34,Challenger Point,Sangre de Cristo Mountains,34,"14,087 ft
4294 m","301 ft
92 m","0.2 mi
0.4 km",-105.6066,37.9804,/img/Massive.jpg
35,Mount Columbia,Sawatch Range,35,"14,077 ft
4291 m","893 ft
272 m","1.9 mi
3.1 km",-106.2975,38.9038,/img/Massive.jpg
36,Missouri Mountain,Sawatch Range,36,"14,074 ft
4290 m","847 ft
258 m","1.3 mi
2.1 km",-106.3786,38.9477,/img/Massive.jpg
37,Humboldt Peak,Sangre de Cristo Mountains,37,"14,070 ft
4289 m","1,204 ft
367 m","1.4 mi
2.3 km",-105.5552,37.9762,/img/Massive.jpg
38,Mount Bierstadt,Front Range,38,"14,065 ft
4287 m","720 ft
219 m","1.1 mi
1.8 km",-105.6688,39.5826,/img/Massive.jpg
39,Sunlight Peak,Needle Mountains,39,"14,065 ft
4287 m","399 ft
122 m","0.5 mi
0.8 km",-107.5959,37.6274,/img/Massive.jpg
40,Handies Peak,San Juan Mountains,40,"14,058 ft
4285 m","1,908 ft
582 m","11 mi
18 km",-107.5044,37.913,/img/Massive.jpg
41,Culebra Peak,Culebra Range,41,"14,053 ft
4283 m","4,827 ft
1471 m","35 mi
57 km",-105.1858,37.1224,/img/Elbert2006.jpg
42,Ellingwood Point,Sangre de Cristo Mountains,42,"14,048 ft
4282 m","342 ft
104 m","0.5 mi
0.8 km",-105.4927,37.5826,/img/Massive.jpg
43,Mount Lindsey,Sangre de Cristo Mountains,43,"14,048 ft
4282 m","1,542 ft
470 m","2.3 mi
3.6 km",-105.4449,37.5837,/img/Massive.jpg
44,Little Bear Peak,Sangre de Cristo Mountains,44,"14,043 ft
4280 m","377 ft
115 m","1.0 mi
1.6 km",-105.4972,37.5666,/img/Massive.jpg
45,Mount Sherman,Mosquito Range,45,"14,043 ft
4280 m","850 ft
259 m","8 mi
13 km",-106.1699,39.225,/img/Elbert2006.jpg
46,Redcloud Peak,San Juan Mountains,46,"14,041 ft
4280 m","1,436 ft
438 m","4.9 mi
7.9 km",-107.4219,37.941,/img/Elbert2006.jpg
47,Pyramid Peak,Elk Mountains,47,"14,025 ft
4275 m","1,638 ft
499 m","2.1 mi
3.4 km",-106.9501,39.0716,/img/Massive.jpg
48,Wilson Peak,San Miguel Mountains,48,"14,023 ft
4274 m","857 ft
261 m","1.5 mi
2.4 km",-107.9847,37.8603,/img/Massive.jpg
49,San Luis Peak,La Garita Mountains,49,"14,022 ft
4274 m","3,113 ft
949 m","27 mi
43 km",-106.9313,37.9868,/img/Elbert2006.jpg
50,Wetterhorn Peak,San Juan Mountains,50,"14,021 ft
4274 m","1,635 ft
498 m","2.8 mi
4.5 km",-107.5109,38.0607,/img/Elbert2006.jpg
51,Huron Peak,Sawatch Range,51,"14,012 ft
4271 m","1,423 ft
434 m","3.2 mi
5.2 km",-106.438,38.9455,/img/Elbert2006.jpg
52,Mount of the Holy Cross,Sawatch Range,52,"14,011 ft
4271 m","2,111 ft
643 m","18 mi
30 km",-106.4817,39.4668,/img/Massive.jpg
53,Sunshine Peak,San Juan Mountains,53,"14,007 ft
4269 m","501 ft
153 m","1.3 mi
2.1 km",-107.4256,37.9228,/img/Massive.jpg
tmcw commented 8 years ago

@DevelopIntelligenceBoulder is the file above what's going in? It looks like there's an unescaped newline in a field.

tmcw commented 8 years ago

This is the unescaped newline.

DevelopIntelligenceBoulder commented 8 years ago

ok, thanks

On Thu, Feb 11, 2016 at 8:37 AM, Tom MacWright notifications@github.com wrote:

@DevelopIntelligenceBoulder https://github.com/DevelopIntelligenceBoulder is the file above what's going in? It looks like there's an unescaped newline in a field.

— Reply to this email directly or view it on GitHub https://github.com/mapbox/csv2geojson/issues/32#issuecomment-182947066.

Kyle Pennell, Technical Marketing Manager DevelopIntelligence http://www.developintelligence.com/ Personally, Relevant Technical Learning Solutions

[o] 720-864-1830

About DevelopIntelligence: DevelopIntelligence https://tracking.cirrusinsight.com/21dc293f-629f-4859-8e05-ecc53de0af62/developintelligence-com , a two-time winner of "Fastest growing education companies in America" on the Inc 5000 list https://tracking.cirrusinsight.com/21dc293f-629f-4859-8e05-ecc53de0af62/inc-com-profile-developintelligence , is the leading provider of technical talent development solutions for software and high-tech companies.

Since 2003, over 48,000 engineers in 30 different countries have participated in DI's expert-led, project-focused, highly-customized learning solutions.

With over 220 different course offerings, we provide world-class learning solutions including Java development, Front-End, Big Data, DevOps and more. Find out more here: http://www.DevelopIntelligence.com http://www.developintelligence.com/