[Geomoose-users] Postgis layer - point out

[Brent Fraser]

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:
> || SIS.TER || Carlo Pelliconi ||
>
> 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] *On Behalf Of *Brent 
> Fraser
> *Sent:* Monday, February 25, 2013 11:51 AM
> *To:* Carlo Pelliconi
> *Cc:* 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
>
>
>
>     -- 
>
>     	
>
>     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/20130225/54dc95d9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2319 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130225/54dc95d9/attachment-0002.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1239 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130225/54dc95d9/attachment-0003.jpe>