-2

I have been for a while looking for an app or website where I could display a map on screen and create a list of points over it by just clicking and adding them.

I'd like to export this list in CSV format, like:

ID, LONG, LAT
1, xx.xxx, yy.yyy
2, xx.xxx, yy.yyy

I decided to ask here because I still can't find an easy way to do this that wouldn't involve coding it by myself.

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Eduardo G.R.
  • 181
  • 8
  • 1
    What software do you have available? Do you want to do this in a program or via a browser? Windows, Mac, Linux, Android, other? You could add placemarks in Google Earth and then export to CSV.. though you might need to code that part; if you google KML to CSV there are many sites that say they can convert your data. – Michael Stimson Feb 13 '18 at 22:37
  • Im using Linux and I don't care if it's web or an application. If it's web it may be easier but I just need to create points by clicking and exporting. The thing is that I will have to add many (more than 1000) points and most of the web-apps out there require many steps to add just ONE point... maybe I will really end up coding it by myself if there is a way to get the coords of they mouse X,Y position over a google map.. – Eduardo G.R. Feb 13 '18 at 23:18
  • You can use QGIS, create a point shapefile, add Google imagery, insert all your points (1000 is fine, you'd probably get nearer 1 million before you hit any sort of limit) then calculate the X and Y coordinates into the table and export to CSV... all interactive with no scripting. Does that sound like something you'd be interested in doing? BTW QGIS is open source, thereby free, just download and install for Windows, Linux or Mac. – Michael Stimson Feb 13 '18 at 23:32
  • http://geojson.io makes a GeoJSON file, http://www.convertcsv.com/geojson-to-csv.htm then use this to make a csv.. No coding involved. – Bill Chappell Feb 14 '18 at 02:41
  • @geojson.io thanks that's a terrific web app. I just wish I could have a key binding to add new points without having to click on the marker icon each time. Congrats for that app it's a goal. – Eduardo G.R. Feb 14 '18 at 17:03

1 Answers1

1

I would suggest QGIS for this task, it's open source and fairly easy to use; there are tutorials to help you to get started. After installing QGIS and before you start locate the OpenLayers plugin (or according to Adding Basemaps from Google or Bing in QGIS? use QuickMapServices) and add it to QGIS.

Firstly create a new point shapefile, use the coordinate reference system (CRS) of WGS84 (EPSG:4326), this is compatible with Google.

Secondly add your new shapefile to QGIS (click Add Data button)

Add Google Imagery using the plugin and set your canvas CRS to Web Mercator (EPSG:3857) and make sure you set 'project on the fly'.

Add your points.

Add new fields of LAT and LON for your points' location.

Calculate the XY values.

Export your table to CSV.

Remove unnecessary fields with Excel (or similar).

It sounds like an involved process but isn't really, read the tutorials linked and it should be quite clear and straightforward and afterwards you'll have a basic understanding of QGIS which may help in the future to create maps etc.

Community
  • 1
Michael Stimson
  • 25,566
  • 2
  • 35
  • 74