Arena mobile api connection to postgis external database

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

arena-mobile

asked 11 Apr, 12:18

clardeux
11●1
accept rate: 0%

2 Answers:

active answers oldest answers newest answers popular answers

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 (OF) ♦♦
4.7k●1●9
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

Hi Clardeaux,

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

api

permanent link

answered 12 Apr, 09:58

jurafejfar
132●3●10
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

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

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

learn more about Markdown

Question tags:

arena-mobile ×27

question asked: 11 Apr, 12:18

question was seen: 188 times

last updated: 12 Apr, 11:06

Arena mobile api connection to postgis external database

Follow this question

Related questions