Make geoJSON
More specifically, make geoJSON from a Google spreadsheet because you can view that in a beautiful Mapbox map on GitHub. YEAH!
This is a super simple node.js command line tool (NPM) that fetches your data from Google Spreadsheets and transforms it to geoJSON with the option to write it to a file. When you push the file to GitHub after running the script, you can view it in your repo as a lovely map!
Quick How
npm install -g gs2geojson- Have a Google Spreadsheet with lat, long columns and if you want, a hexcolor column. Publish spreadsheet, copy key.
gs2geojson YOURSPREADSHEETKEY- Use
gs2geojson YOURSPREADSHEETKEY --saveto write it to a file to push to GitHub
See directly below if you want to know more about getting lat and long
Long How
Make a Spreadsheet
- Your spreadsheet should have a lat column and long column. You can do it manually or use this Mapbox Plugin or use a Geocoder.
- If you want to pick your own markers colors, and a column titled hexcolor with the hexcolor values you want. The default is blue.
- Click
File>Publish to the Web>Start Publishing. Copy the key generated between the = and &:
Node and NPM
- On Mac installing the
.pkggives you both Node and NPM. - On Windows installing the
.msigives you both Node and NPM.
- In your computer's Terminal, type
npm install -g gs2geojsonto install it as a global module. - Here's an example you can try:
gs2geojson 0Ao5u1U6KYND7dGN5QngweVJUWE16bTRob0d2a3dCbnc --save
Additionally, if you want to clone this repo, you can cd gs2geojson and run npm install then npm test to try it out.
Add Your Key and Run
- In your Terminal type
gs2geojson YOURSPREADSHEETKEY
- If you want to save the spreadsheet as a geojson file in the directory you're in type
gs2geojson YOURSPREADSHEETKEY --save - To pipe the data to you clipboard to paste somewhere else type
gs2geojson YOURSPREADSHEETKEY | pbcopy
Push to GitHub and View
- Include it in a repo and push it to GitHub!
- Go look at it on the internet!