I am investigating to use Arena Mobil for field survey.

I would like to get the survey record to copy it in my PostGIS database for further data analysis and publication in my own web mapping platform connected to the PostGIS database.

Furthermore, I know that I should export the survey record in file format, but the best should be to use python or R script for example to automatically copy records from Arena database to my own PostGIS database.

Is there any API or trick to do it ?

Best regards

asked 11 Apr, 12:18

clardeux's gravatar image

clardeux
111
accept rate: 0%


Dear users,
In Arena there is already a RESTful API to query the data stored in the records (data is fetched in JSON format).
It's not documented but it's used in the Explorer module in Arena; you could try to investigate how it works by yourself by checking what is being sent to the server while you define the query to extract the data in that section, or if you want we can contact you to your private email address to better understand your needs.
Many thanks,
Open Foris Team

permanent link

answered 12 Apr, 10:56

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k19
accept rate: 20%

In Arena there is already a RESTful API

Oh, that is great!

Now, I have slightly different issues to solve, but I will come to this probably soon.

I will try to get oriented in Explorer module in Arena!

Please, if you will communicate something via email regarding this, add me to CC (my email is accessible in my profile here, right?)!

(12 Apr, 11:06) jurafejfar jurafejfar's gravatar image

Hi Clardeaux,

There is API used for export to R. See this in docs:

api

J.

permanent link

answered 12 Apr, 09:58

jurafejfar's gravatar image

jurafejfar
132310
accept rate: 0%

But it will just download data in .zip ...

I have somewhat similar plans to touch data from my custom postgres DB... So far, I did not find any API for that. I just spent some limited time browsing source code on GitHub.

But on the other hand, I have found the Arena internal DB structure and data format (JSON) quite accessible. So If you could host Arena (server) yourself, it would be quite easy to access data inside quite easily.

(12 Apr, 10:01) jurafejfar jurafejfar's gravatar image

Maybe, it would be also possible to develop REST API (for example PostGREST) which will serve data through https protocol. And maybe in the future this could be integrated to Arena?

(12 Apr, 10:01) jurafejfar jurafejfar's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×36

question asked: 11 Apr, 12:18

question was seen: 549 times

last updated: 12 Apr, 11:06