Author Topic: Exporting of data CSV+  (Read 1666 times)

Offline KewGIS

  • Newbie
  • *
  • Posts: 2
  • Mapping plant life to help save species at risk for our future
    • View Profile
Exporting of data CSV+
« on: January 17, 2014, 18:00:06 »
Hi,

We use Locus for much of our fieldwork (for collection data and viewing maps) and it is great. But it is difficult to export all of the data recorded into csv (or even other formats). It would get great if you could export:

1) link to photos
2) the accuracy of the point
3) Lat Longs to a higher precision

I can see all of this in the SQLite database, but much of the data seems to be stored into a blob (description and photos), does anyone know an easy way of getting to this data. At present we have to export CSV.

Thanks

GIS Kew
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 11438
  • Thanked: 317 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: Exporting of data CSV+
« Reply #1 on: January 17, 2014, 18:54:04 »
Hi Kew,
 
it depend how much time you want to invest and if you are skilled with Android, or simple Java developing. If so, you should be able to create a program that will read even a BLOB objects from database (because it's content is defined in public API for Locus). Best should be to write add-on for Locus, that will export selected points to some file

I can of course improve CSV export a little bit (precission of lat, lon, accuracy, ...), but for example with photos or generally attached files (in next version of Locus you will be able to attach everything ...) it will be worst. or exists and "world wide used schema for geo data in CSV?
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!
 

Offline KewGIS

  • Newbie
  • *
  • Posts: 2
  • Mapping plant life to help save species at risk for our future
    • View Profile
Re: Exporting of data CSV+
« Reply #2 on: January 20, 2014, 12:37:18 »
Improvements to CSV would be great, and we would just need the reference to the file (file name/s). I am afraid we have no skills with Android, so pretty difficult for us to program. Our standard for data would follow those used for natural history collections (Darwin core see http://rs.tdwg.org/dwc/terms/#occurrenceindex if you are really interested).

We mainly use locus to get out mapping data into the field (see our blog http://www.kew.org/news/kew-blogs/gis-team/mapping-tools-two.htm), and at present connect to ODK for detailed data recording, with the simpler and observational data recorded into locus. It would be great be able to connect ODK and Locus (sending and retrieving points).

Thanks

GIS Kew
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 11438
  • Thanked: 317 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: Exporting of data CSV+
« Reply #3 on: January 21, 2014, 09:36:50 »
Understand.

Direct connect to ODK is not planned now. Maybe later in our "new" project http://www.locusmap.eu/locus-gis-android-gis-application/

I was searching if exists any specification for geodata in CSV files, but seems that everyone do it on it's own. Nevermind. I had improved current CSV export a little in Locus, so if you want, you may try it here https://dl.dropboxusercontent.com/u/8015949/Locus%20%28dev%29/test_versions/2.18.0.9.apk

Main change is that headers of columns are now simple texts that do not change (in current version they change by user language), for waypoints is added "accuracy" and "attachments". So all attachments are now exported together with data.

I was thinking about your "Lat Longs to a higher precision", but now it's precission on six decimal places, so I think it's already more then it's needed. 0.000 001 means metres accuracy
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!