Aggregate with PostgreSQL

Tyler_Erickson · March 14, 2011, 4:42pm

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

Mitch_Sundt · March 14, 2011, 7:31pm

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about installing
web apps? Or neither?

Mitch

···

On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson wrote:

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

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

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com

Tyler_Erickson · March 14, 2011, 7:52pm

I'm not a java developer. I use eclipse, but for Python development
(PyDev). My java web app installation experience usually involves dropping
war files into Tomcat, and submitting log traces when something goes wrong.

Tyler

···

On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt wrote:

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about installing
web apps? Or neither?

Mitch

On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson tylerickson@gmail.comwrote:

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

Mitch_Sundt · March 14, 2011, 11:09pm

Great.

Set up a system with the latest JDK, Tomcat and Postgresql installed. Are
you a Windows or Linux or Mac user?

I'll write up the other steps in a bit. I'm working on a check-in, and will
provide you with a war file after I get that done.

Since we don't have a Postgres installer yet, you'll need to manually
configure the database, and also manually alter some configuration files,
then update a jar in the war file I give you. Once that is done, you can
drop the modified war into tomcat, and you should be good to go. Tedious
and less complex than it sounds.

Mitch

···

On Mon, Mar 14, 2011 at 12:52 PM, Tyler Erickson wrote:

I'm not a java developer. I use eclipse, but for Python development
(PyDev). My java web app installation experience usually involves dropping
war files into Tomcat, and submitting log traces when something goes wrong.

Tyler

On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt msundt@cs.washington.eduwrote:

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about installing
web apps? Or neither?

Mitch

On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson tylerickson@gmail.comwrote:

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

Tyler_Erickson · March 14, 2011, 11:37pm

I develop on ubuntu linux, and I am comfortable installing and configuring
postgresql.

Do you use postgis to store the spatial data types?

Great.

Set up a system with the latest JDK, Tomcat and Postgresql installed. Are
you a Windows or Linux or Mac user?

I'll write up the other steps in a bit. I'm working on a check-in, and
will
provide you with a war file after I get that done.

Since we don't have a Postgres installer yet, you'll need to manually
configure the database, and also manually alter some configuration files,
then update a jar in the war file I give you. Once that is done, you can
drop the modified war into tomcat, and you should be good to go. Tedious
and less complex than it sounds.

Mitch

I'm not a java developer. I use eclipse, but for Python development
(PyDev). My java web app installation experience usually involves
dropping
war files into Tomcat, and submitting log traces when something goes
wrong.

Tyler

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about
installing

···

On Mar 14, 2011 5:09 PM, "Mitch Sundt" wrote: > On Mon, Mar 14, 2011 at 12:52 PM, Tyler Erickson > On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt >> web apps? Or neither? >>> >>> Mitch >>> >>> >>> On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson >> >>>> Are there any instructions available for setting up Aggregate 1.0 to >>>> work with PostgreSQL? We wouldn't mind helping to test it out... >>>> >>>> -- >>>> Post: opendatakit@googlegroups.com >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>> >>> >>> >>> -- >>> Mitch Sundt >>> Software Engineer >>> http://www.OpenDataKit.org >>> University of Washington >>> mitchellsundt@gmail.com >>> >>> -- >>> Post: opendatakit@googlegroups.com >>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> > > > > -- > Mitch Sundt > Software Engineer > http://www.OpenDataKit.org > University of Washington > mitchellsundt@gmail.com > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

Jeffrey_Johnson · March 15, 2011, 1:33am

I got this all working with Postgres once, struggled with the use of
Google Accounts for login though, but finally did get it working.
Would love to have instructions. AFAIK, postgis is not used by
default, I added a trigger to create a postgis point from the lat and
lon columns on insert. I had started looking at how to make ODK a
GeoServer community module so we could get WMS/WFS pretty easily, but
never got beyond the drawing board.

Jeff

···

On Mon, Mar 14, 2011 at 4:37 PM, Tyler Erickson wrote: > I develop on ubuntu linux, and I am comfortable installing and configuring > postgresql. > > Do you use postgis to store the spatial data types? > > On Mar 14, 2011 5:09 PM, "Mitch Sundt" wrote: >> Great. >> >> Set up a system with the latest JDK, Tomcat and Postgresql installed. Are >> you a Windows or Linux or Mac user? >> >> I'll write up the other steps in a bit. I'm working on a check-in, and >> will >> provide you with a war file after I get that done. >> >> Since we don't have a Postgres installer yet, you'll need to manually >> configure the database, and also manually alter some configuration files, >> then update a jar in the war file I give you. Once that is done, you can >> drop the modified war into tomcat, and you should be good to go. Tedious >> and less complex than it sounds. >> >> Mitch >> >> On Mon, Mar 14, 2011 at 12:52 PM, Tyler Erickson wrote: >> >>> I'm not a java developer. I use eclipse, but for Python development >>> (PyDev). My java web app installation experience usually involves >>> dropping >>> war files into Tomcat, and submitting log traces when something goes >>> wrong. >>> >>> - Tyler >>> >>> >>> On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt wrote: >>> >>>> Hi Tyler, >>>> >>>> Are you a Eclipse/Java software developer? Or just savvy about >>>> installing >>>> web apps? Or neither? >>>> >>>> Mitch >>>> >>>> >>>> On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson wrote: >>>> >>>>> Are there any instructions available for setting up Aggregate 1.0 to >>>>> work with PostgreSQL? We wouldn't mind helping to test it out... >>>>> >>>>> -- >>>>> Post: opendatakit@googlegroups.com >>>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>>> >>>> >>>> >>>> >>>> -- >>>> Mitch Sundt >>>> Software Engineer >>>> http://www.OpenDataKit.org >>>> University of Washington >>>> mitchellsundt@gmail.com >>>> >>>> -- >>>> Post: opendatakit@googlegroups.com >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>> >>> -- >>> Post: opendatakit@googlegroups.com >>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >> >> >> >> -- >> Mitch Sundt >> Software Engineer >> http://www.OpenDataKit.org >> University of Washington >> mitchellsundt@gmail.com >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >

Mitch_Sundt · March 15, 2011, 6:59pm

Correct, we don't use postgis. We store geopoints as 4 columns of lat,
long, altitude, accuracy.

Hopefully a view could be defined on top of our table that would present the
postgis datatypes?

I'll start work on the configuration steps this afternoon...

Mitch

···

On Mon, Mar 14, 2011 at 6:33 PM, Jeffrey Johnson wrote:

I got this all working with Postgres once, struggled with the use of
Google Accounts for login though, but finally did get it working.
Would love to have instructions. AFAIK, postgis is not used by
default, I added a trigger to create a postgis point from the lat and
lon columns on insert. I had started looking at how to make ODK a
GeoServer community module so we could get WMS/WFS pretty easily, but
never got beyond the drawing board.

Jeff

On Mon, Mar 14, 2011 at 4:37 PM, Tyler Erickson tylerickson@gmail.com wrote:

I develop on ubuntu linux, and I am comfortable installing and
configuring
postgresql.

Do you use postgis to store the spatial data types?

On Mar 14, 2011 5:09 PM, "Mitch Sundt" msundt@cs.washington.edu wrote:

Great.

Set up a system with the latest JDK, Tomcat and Postgresql installed.
Are
you a Windows or Linux or Mac user?

I'll write up the other steps in a bit. I'm working on a check-in, and
will
provide you with a war file after I get that done.

Since we don't have a Postgres installer yet, you'll need to manually
configure the database, and also manually alter some configuration
files,
then update a jar in the war file I give you. Once that is done, you can
drop the modified war into tomcat, and you should be good to go. Tedious
and less complex than it sounds.

Mitch

On Mon, Mar 14, 2011 at 12:52 PM, Tyler Erickson tylerickson@gmail.comwrote:

I'm not a java developer. I use eclipse, but for Python development
(PyDev). My java web app installation experience usually involves
dropping
war files into Tomcat, and submitting log traces when something goes
wrong.

Tyler

On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt msundt@cs.washington.eduwrote:

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about
installing
web apps? Or neither?

Mitch

On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson tylerickson@gmail.comwrote:

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

Mitch_Sundt · March 16, 2011, 11:51pm

Here is information on what to do:
http://code.google.com/p/opendatakit/wiki/AggregatePostgresqlInstall

Mitch

···

On Tue, Mar 15, 2011 at 11:59 AM, Mitch Sundt wrote:

Correct, we don't use postgis. We store geopoints as 4 columns of lat,
long, altitude, accuracy.

Hopefully a view could be defined on top of our table that would present
the postgis datatypes?

I'll start work on the configuration steps this afternoon...

Mitch

On Mon, Mar 14, 2011 at 6:33 PM, Jeffrey Johnson ortelius@gmail.comwrote:

I got this all working with Postgres once, struggled with the use of
Google Accounts for login though, but finally did get it working.
Would love to have instructions. AFAIK, postgis is not used by
default, I added a trigger to create a postgis point from the lat and
lon columns on insert. I had started looking at how to make ODK a
GeoServer community module so we could get WMS/WFS pretty easily, but
never got beyond the drawing board.

Jeff

On Mon, Mar 14, 2011 at 4:37 PM, Tyler Erickson tylerickson@gmail.com wrote:

I develop on ubuntu linux, and I am comfortable installing and
configuring
postgresql.

Do you use postgis to store the spatial data types?

On Mar 14, 2011 5:09 PM, "Mitch Sundt" msundt@cs.washington.edu wrote:

Great.

Set up a system with the latest JDK, Tomcat and Postgresql installed.
Are
you a Windows or Linux or Mac user?

I'll write up the other steps in a bit. I'm working on a check-in, and
will
provide you with a war file after I get that done.

Since we don't have a Postgres installer yet, you'll need to manually
configure the database, and also manually alter some configuration
files,
then update a jar in the war file I give you. Once that is done, you
can
drop the modified war into tomcat, and you should be good to go.
Tedious
and less complex than it sounds.

Mitch

On Mon, Mar 14, 2011 at 12:52 PM, Tyler Erickson tylerickson@gmail.comwrote:

I'm not a java developer. I use eclipse, but for Python development
(PyDev). My java web app installation experience usually involves
dropping
war files into Tomcat, and submitting log traces when something goes
wrong.

Tyler

On Mon, Mar 14, 2011 at 1:31 PM, Mitch Sundt msundt@cs.washington.eduwrote:

Hi Tyler,

Are you a Eclipse/Java software developer? Or just savvy about
installing
web apps? Or neither?

Mitch

On Mon, Mar 14, 2011 at 9:42 AM, Tyler Erickson tylerickson@gmail.comwrote:

Are there any instructions available for setting up Aggregate 1.0 to
work with PostgreSQL? We wouldn't mind helping to test it out...

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

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

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

Abel_Melquiades_Call · October 30, 2017, 1:56am

@Mitch_Sundt yeap creating views for it will work.