gavinr / csv-to-geojson Goto Github PK

View Code? Open in Web Editor NEW

57.0 5.0 30.0 684 KB

Convert a CSV to GeoJSON

Home Page: http://csv.togeojson.com/

JavaScript 81.80% HTML 18.20%

geojson csv javascript hacktoberfest

csv-to-geojson's Introduction

CSV To GeoJSON

A simple webpage to convert a CSV to GeoJSON: http://csv.togeojson.com/

Credit

Using CSV to JSON function from http://stackoverflow.com/a/1293163/2039 (License http://creativecommons.org/licenses/by-sa/3.0/)
Using JSON to GeoJSON package from caseypt https://github.com/caseypt/geojson.js (license (c) 2012 Casey Thomas, MIT License)

License

http://creativecommons.org/licenses/by-sa/3.0/

csv-to-geojson's People

Contributors

Stargazers

Watchers

csv-to-geojson's Issues

Prevent quotes around certain properties

I have a unix time stamp as a date property in my geojson. With the quote around the timestamp, it can't read it right (fairly obvious). Same with currency. Is there a way to keep certain properties from having quotes around them?

Thanks, btw, for this.

Switch CSV Parser to Papa Parse

Multithreaded, worker-enabled, etc
http://papaparse.com/

readme should warn data is automatically uploaded to a public github gist

Users should ideally read the source, but you should indicate in your readme that public anonymous gists are created with the input data.

It's possible someone may be working with sensitive data and could, without realizing, have it uploaded publicly to github gists.

Update http://csv.togeojson.com/

I was going to create an issue or PR that blank lines in the CSV (I had a blank line at the end) result in invalid geoJSON because it ends with {"type":"Feature","geometry":{},"properties":{}}]}.

But I see the latest master has already fixed this in #7 :)

Please could you update the code on the released site?

Thanks for this handy tool!

(One suggestion is to rename your master branch to gh-pages and use GitHub Pages to host directly on http://csv.togeojson.com/, so no need to deploy in the future -- it's always up to date.)

Show button to allow sending to Gist (instead of automatically doing it)

This should also remove the warning that was set up in #9

Show resultant GeoJSON on a map

csv2geojson

You might want to steal some tricks from csv2geojson - there's an implementation of delimiter-autodetection, regexes for lat/lon, and tests for some odd things like sexagesimal notation.

Spaces in first line of CSV cause bad or no geometry

I tried to use a simple CSV file, and it forgot to create geometry type & coordinates. However it did leave the coordinates in the properties but it saved them as strings.

Example file used:

Street, City, State, Zip, Misc, Lat, Lon 
800 North Pearl St, Menards, NY, 12204, Work, 42.67948646, -73.73575897

What I got back:

{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      **"geometry": {},**
      "properties": {
        "Street": " 800 North Pearl St",
        " City": " Menards",
        " State": " NY",
        " Zip": " 12204",
        " Misc": " Work",
        "  latitude": " 42.67948646",
        " longitude ": " -73.73575897"   
      }

It should be this:

{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [ -73.73575897,42.67948646 ]
},
"properties": {
"Street":" 800 North Pearl St",
"City":" Menards",
"State":" NY",

Handle (and show error) if some rows have no latitude/longitude

If some rows have missing latitude/longitude, that will create invalid GeoJSON so we cannot include those rows.

UI should alert user to which rows were removed from the output GeoJSON

Example CSV:

Id,Name,Latitude,Longitude,a
153,aa,40.172000,-88.834000,b
154,bb,39.216000,-1.051000,b
155,cc,46.471000,-119.333000,b
434,dd,,,b

Outputs:

{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -88.834,
          40.172
        ]
      },
      "properties": {
        "Id": "153",
        "Name": "aa",
        "a": "b"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -1.051,
          39.216
        ]
      },
      "properties": {
        "Id": "154",
        "Name": "bb",
        "a": "b"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -119.333,
          46.471
        ]
      },
      "properties": {
        "Id": "155",
        "Name": "cc",
        "a": "b"
      }
    },
    {
      "type": "Feature",
      "geometry": {},
      "properties": {
        "Id": "434",
        "Name": "dd",
        "a": "b"
      }
    }
  ]
}

Expected:

{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -88.834,
          40.172
        ]
      },
      "properties": {
        "Id": "153",
        "Name": "aa",
        "a": "b"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -1.051,
          39.216
        ]
      },
      "properties": {
        "Id": "154",
        "Name": "bb",
        "a": "b"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -119.333,
          46.471
        ]
      },
      "properties": {
        "Id": "155",
        "Name": "cc",
        "a": "b"
      }
    }
  ]
}

{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Point","coordinates":["-92.2069692","46.8354471"]},"properties":{}},{"type":"Feature","geometry":{"type":"Point","coordinates":["-92.2068811","46.8355317"]},"properties":{}},{"type":"Feature","geometry":{"type":"Point","coordinates":["-92.2069551","46.8354527"]},"properties":{}},{"type":"Feature","geometry":{"type":"Point","coordinates":["-92.2069158","46.8354658"]},"properties":{}}