[Geomoose-users] Postgis layer - point out

Tue Feb 26 05:40:57 PST 2013

Brent,

I stand corrected.  I was under the impression that the question was related to editing of ad-hoc layers, but maybe I was not reading the messages well enough.

The trigger route could be used as you suggested though to do the conversions.  But I was mostly looking at it from the query side, once the data was in POSTGIS, you can convert coordinate output on the fly when pulling from POSTGIS (under another layer name perhaps) , of course with WMS it would all need to be set up ahead of time as an option for output.

Bobb

From: Brent Fraser [mailto:bfraser at geoanalytic.com]
Sent: Monday, February 25, 2013 5:00 PM
To: Basques, Bob (CI-StPaul)
Cc: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Postgis layer - point out

Bobb,

As I recall, the connection with TinyOWS is thru tables (in the , not SQL statements as with Mapserver's map file.  TinyOWS forms the SQL statements to do SELECT, UPDATE, and INSERT so as far as I know, using views or functions is not possible.  Maybe some hacks with Postgres triggers may be possible if you want to convert coords in insert/update...

Best Regards,

Brent Fraser
On 2/25/2013 11:41 AM, Basques, Bob (CI-StPaul) wrote:
Brent (and others),

The reprojection aspects should be possible through POSTGIS as well, either as a DB Function and/or via the SQL calls., especially with the somewhat ad-hoc nature to setting up any editing functionality.  I'm in the need in the near future to look at this type of editing as well, so maybe I'll be able to comment further down the road some.

Bobb

From: geomoose-users-bounces at lists.osgeo.org<mailto:geomoose-users-bounces at lists.osgeo.org> [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Brent Fraser
Sent: Monday, February 25, 2013 11:51 AM
To: Carlo Pelliconi
Cc: geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>
Subject: Re: [Geomoose-users] Postgis layer - point out

Then you need to use the WFS-T protocol (using GeoServer or TinyOWS).  TinyOWS is a WFS-T server now available as an Application through MS4W (http://www.maptools.org/ms4w/index.phtml?page=downloads.html) and possibly other packages such as OSGeo4w.

While I did some experimenting with TinyOWS and pre-release GeoMoose 2.6 I wasn't able to finish (I may get back to it soon).  In theory, as long as you store your data in the same coordinate system as your map display, it should work.

Best Regards,

Brent Fraser
On 2/25/2013 10:30 AM, Carlo Pelliconi wrote:
Thank you Brent.
But I need editing capabilities on the postgis layer: is it possible in this way (with WMS protocol)?

Best Regards,
Carlo Pelliconi

Il 25/02/2013 18:23, Brent Fraser ha scritto:
Configure Mapserver to connect to the PostGIS database and use Mapserver's WMS protocol to communicate with GeoMoose.

Best Regards,
Brent Fraser

On 2/25/2013 10:21 AM, Carlo Pelliconi wrote:

I want to describe in a better way my previous question:
how can I build up a posgis layer in GeoMOOSE WITHOUT using GEOSERVER?

Thank you.
Regards, Carlo
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org<mailto:Geomoose-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/geomoose-users

--
[cid:image001.jpg at 01CE13F4.A0E89C70]

[cid:image002.jpg at 01CE13F4.A0E89C70]

Certificata (DIN EN) ISO 9001:2000
Reg. n° 44 100 077218

ing. Carlo Pelliconi

Responsabile Sistemi Informativi

* Phone:

+39 0542 364034

* Fax:

+39 0542 612130

* E-mail:

c.pelliconi[AT]sis-ter.it

---------------------------------------------------

Sis.ter Srl

Via Mentana, 10

40026 Imola (BO)

C.F/P.IVA 01777271204

ATTENZIONE! I dati contenuti nel testo e negli allegati di questo messaggio e delle successive risposte sono di natura professionale e confidenziale, sono riservati esclusivamente ai loro destinatari e potranno essere conosciuti all'intenro dell'organizzazione del mittente nel rispoetto della policy aziendale di riferimento. Nel caso queso messaggio vi fosse giunto per errore Vi invitiamo a cancellarlo e darne pronta comunicazione al mittente. Ogni ulteriore utilizzo/trattamento è assolutamente vietato ed inibito senza una formale autorizzazione da parte del mittente. La non osservanza di quanto sopra indicato deve considerarsi violazione di legge e può comportare il risarcimento del danno (art. 2043 c.c.) e la condanna penale di reclusione sino a tre anni (Art. 616 cp. e 167 d.lg 196/2003).
ATTENTION! The information contained in this message or any of its attachments may be privileged and confidential and intended for the exclusive use of the addressee. If you are not the addressee, please advise the sender immediately by reply e-mail and delete this message and any attachments without retaining a copy. Any unauthorized disclosure, reproduction, distribution, or other dissemination of this information is prohibited. Any abuse would expose the responsible party to the payment of a compensation (art. 2043 c.c.) and to civil and/or criminal penalties with jail up till three yaers (Artt. 616 e 167 cp e d.lg 196/2003).

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130226/ab56588f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2319 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130226/ab56588f/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1239 bytes
Desc: image002.jpg
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130226/ab56588f/attachment-0003.jpg>