0

I am using a GPS App on Android that export my location as a latitude and longitude values.

For each location it exporting a separate data set:

Latitude (LAT): 32.05796  
N 32°3'28.6578" 
Longitude (LONG): 34.83233  
E 34°49'56.39448"

It is quite easy to copy this data into a CSV file and then to upload it into QGIS.

However, it is time consuming especially when I have 15 or more locations to add.

I have tried some GPS apps and they all doing pretty much the same thing.

Is there some App or a method that enables to collect several locations in one table?

Once the table is saved as CSV it should not be a problem to import it as CSV into QGIS.

  • 1
    Why not use the Qfield app to digitize directly into layer? – Gabriel C. Nov 28 '18 at 14:02
  • 1
    here maps you can export your collections to csv or gpx waypoints. play.google.com/store/apps/… – Mapperz Nov 28 '18 at 14:03
  • My OS is windows Pro 10 – Nitzan Matan Nov 28 '18 at 14:24
  • 1
    I would come up with a nice bash 1-liner if that would help. – pLumo Nov 28 '18 at 14:24
  • Is this Google apps enable to import the data as a CSV file? – Nitzan Matan Nov 28 '18 at 14:26
1

Bash solution:

Put all your data files in a subfolder named "data" and run this little script:

{
# print some header
printf "%s,%s\n" LAT LON;
# print the data
grep -Pho '(LAT|LONG)\): \K.*' data/* | paste -d, - -
} > output.csv # redirect output between brackets to csv file

In one line for copy-paste:

{ printf "%s,%s\n" LAT LON; grep -Pho '(LAT|LONG)\): \K.*' data/* | paste -d, - -; } > output.csv

You can run bash on Windows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.