<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Bobb,<br>
<br>
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...<br>
<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
On 2/25/2013 11:41 AM, Basques, Bob (CI-StPaul) wrote:<br>
</div>
<blockquote
cite="mid:C9CEA89772DA74488B5A5B6EB17DC481065BA216@055-CH1MPN1-003.055d.mgd.msft.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<title>|| SIS.TER || Carlo Pelliconi ||</title>
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
p.testo9nero, li.testo9nero, div.testo9nero
{mso-style-name:testo9nero;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:8.5pt;
font-family:"Arial","sans-serif";
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Comic Sans MS";
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext">Brent (and others),<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext">Bobb<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Comic Sans
MS";color:windowtext"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in
0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">
<a class="moz-txt-link-abbreviated" href="mailto:geomoose-users-bounces@lists.osgeo.org">geomoose-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:geomoose-users-bounces@lists.osgeo.org">mailto:geomoose-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Brent Fraser<br>
<b>Sent:</b> Monday, February 25, 2013 11:51 AM<br>
<b>To:</b> Carlo Pelliconi<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [Geomoose-users] Postgis layer -
point out<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">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 (<a
moz-do-not-send="true"
href="http://www.maptools.org/ms4w/index.phtml?page=downloads.html">http://www.maptools.org/ms4w/index.phtml?page=downloads.html</a>)
and possibly other packages such as OSGeo4w.<br>
<br>
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.<br>
<br>
<o:p></o:p></p>
<pre>Best Regards,<o:p></o:p></pre>
<pre>Brent Fraser<o:p></o:p></pre>
<p class="MsoNormal">On 2/25/2013 10:30 AM, Carlo Pelliconi
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Thank you Brent.<br>
But I need editing capabilities on the postgis layer: is
it possible in this way (with WMS protocol)?<br>
<br>
Best Regards, <br>
Carlo Pelliconi<br>
<br>
Il 25/02/2013 18:23, Brent Fraser ha scritto:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Configure Mapserver to connect to the
PostGIS database and use Mapserver's WMS protocol to
communicate with GeoMoose.
<br>
<br>
Best Regards, <br>
Brent Fraser <br>
<br>
On 2/25/2013 10:21 AM, Carlo Pelliconi wrote: <br>
<br>
<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">I want
to describe in a better way my previous question:
<br>
how can I build up a posgis layer in GeoMOOSE WITHOUT
using GEOSERVER? <br>
<br>
Thank you. <br>
Regards, Carlo <br>
_______________________________________________ <br>
Geomoose-users mailing list <br>
<a moz-do-not-send="true"
href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/geomoose-users">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a>
<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif""><img
id="_x0000_i1025"
src="cid:part4.03020208.03090108@geoanalytic.com"
width="132" height="51" border="0"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif""><img
id="_x0000_i1026"
src="cid:part5.02060003.05050204@geoanalytic.com"
width="40" height="40" border="0"><o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:7.0pt;font-family:"Arial","sans-serif"">Certificata
(DIN EN) ISO 9001:2000<br>
Reg. n° 44 100 077218<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif""> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">ing.
Carlo Pelliconi<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">Responsabile
Sistemi Informativi<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif""> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">*
Phone:<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">+39
0542 364034<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">*
Fax:<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">+39
0542 612130<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">*
E-mail:<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">c.pelliconi[AT]sis-ter.it<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">---------------------------------------------------<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">Sis.ter
Srl<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">Via
Mentana, 10<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">40026
Imola (BO)<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt
.75pt">
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif"">C.F/P.IVA
01777271204<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><br>
<span
style="font-size:7.5pt;font-family:"Arial","sans-serif"">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).
<br>
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).
</span><o:p></o:p></p>
</div>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</blockquote>
<br>
</body>
</html>