ODK connection to PostGIS+Geoserver

Support
1

Hi,

I would like to ask on how are we able to connect odk collect to
PostGIS+Geoserver+leaflets? I am new to this and I know I can get a lot of
ideas from you guys.:slight_smile:

thanks,

2

I am unfamiliar with those systems. If you have someone knowledgeable in
setting up servers, you could set up ODK Aggregate on that same server,
using PostgreSQL as the database, then they could either set up database
triggers to copy data from the ODK Aggregate tables into your PostGIS
tables or perhaps configure PostGIS to directly access the ODK Aggregate
tables (I'd recommend setting up a trigger).

··· On Thu, Jun 20, 2013 at 6:53 PM, dionde wrote:

Hi,

I would like to ask on how are we able to connect odk collect to
PostGIS+Geoserver+leaflets? I am new to this and I know I can get a lot of
ideas from you guys.:slight_smile:

thanks,

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

Hi,
We are doing this very thing for several of our projects.

As Mitch has said above, you install ODK Aggregate on a postgres+PostGIS
database. Using Geoserver's SQL Viewshttp://docs.geoserver.org/stable/en/user/data/database/sqlview.html,
we serve out the required data as a WMS service.

We consume this WMS service in out OpenLayers based WebGIS

4

Bryan McBride has a demo of ODK + PostGIS + GeoServer + Leaflet at
http://geoserving.net/odk_geoserver. Contact him at
mcbride.bryan@gmail.com if you want to find out how he did it.

Yaw

··· -- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.

On Fri, Jun 21, 2013 at 9:22 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

I am unfamiliar with those systems. If you have someone knowledgeable in
setting up servers, you could set up ODK Aggregate on that same server,
using PostgreSQL as the database, then they could either set up database
triggers to copy data from the ODK Aggregate tables into your PostGIS tables
or perhaps configure PostGIS to directly access the ODK Aggregate tables
(I'd recommend setting up a trigger).

On Thu, Jun 20, 2013 at 6:53 PM, dionde android00dionde@gmail.com wrote:

Hi,

I would like to ask on how are we able to connect odk collect to
PostGIS+Geoserver+leaflets? I am new to this and I know I can get a lot of
ideas from you guys.:slight_smile:

thanks,

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

5

Hi there, have you taken a look at smap?

http://code.google.com/p/smap-suite/

Mark

··· Sent from my Galaxy Nexus On Jun 21, 2013 7:22 PM, "Mitch Sundt" wrote:

I am unfamiliar with those systems. If you have someone knowledgeable in
setting up servers, you could set up ODK Aggregate on that same server,
using PostgreSQL as the database, then they could either set up database
triggers to copy data from the ODK Aggregate tables into your PostGIS
tables or perhaps configure PostGIS to directly access the ODK Aggregate
tables (I'd recommend setting up a trigger).

On Thu, Jun 20, 2013 at 6:53 PM, dionde android00dionde@gmail.com wrote:

Hi,

I would like to ask on how are we able to connect odk collect to
PostGIS+Geoserver+leaflets? I am new to this and I know I can get a lot of
ideas from you guys.:slight_smile:

thanks,

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

6

hi sir..

I am very new to geoserver and postgis. I've got this sql script view using
Geoserver like this one:

Select *, ST_AsEWKB(ST_GeomFromText('POINT ('||latitude||'
'||longitude||')',4326)) as geom FROM mytable

where latitude and longitude are columns from mytable

I got this kind of error..

ERROR: relation "mytable" does not exist Position: 128

I would like to hear any idea from you. I've been searching in some other
solutions but I got stuck in this error..thanks in advance

··· On Wed, Jun 26, 2013 at 6:24 PM, Devdatta Tengshe wrote:

Hi,
We are doing this very thing for several of our projects.

As Mitch has said above, you install ODK Aggregate on a postgres+PostGIS
database. Using Geoserver's SQL Viewshttp://docs.geoserver.org/stable/en/user/data/database/sqlview.html,
we serve out the required data as a WMS service.

We consume this WMS service in out OpenLayers based WebGIS

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/ACL683YUCao/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

7

'mytable' would be the name of the table containing the submission data.

You should Read up on PostgreSQL and SQL language to understand what this
text means.

There are likely other more easily accessible tutorials on the web.
Different vendors have different flavors of SQL, so once you understand the
general syntax, you will want to use the reference manuals for the specific
software you are using.

··· On Sun, Nov 10, 2013 at 6:12 PM, Dionde Clarin wrote:

hi sir..

I am very new to geoserver and postgis. I've got this sql script view
using Geoserver like this one:

Select *, ST_AsEWKB(ST_GeomFromText('POINT ('||latitude||'
'||longitude||')',4326)) as geom FROM mytable

where latitude and longitude are columns from mytable

I got this kind of error..

ERROR: relation "mytable" does not exist Position: 128

I would like to hear any idea from you. I've been searching in some other
solutions but I got stuck in this error..thanks in advance

On Wed, Jun 26, 2013 at 6:24 PM, Devdatta Tengshe dev3is@gmail.comwrote:

Hi,
We are doing this very thing for several of our projects.

As Mitch has said above, you install ODK Aggregate on a postgres+PostGIS
database. Using Geoserver's SQL Viewshttp://docs.geoserver.org/stable/en/user/data/database/sqlview.html,
we serve out the required data as a WMS service.

We consume this WMS service in out OpenLayers based WebGIS

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/ACL683YUCao/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com