<html>
<head>
<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;}
@font-face
{font-family:"Comic Sans MS \;color\:windowtext";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
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;
font-family:"Comic Sans MS";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Comic Sans MS";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
.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]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS";color:windowtext">Brent,<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">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.<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 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.<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"> Brent Fraser [mailto:bfraser@geoanalytic.com]
<br>
<b>Sent:</b> Monday, February 25, 2013 5:00 PM<br>
<b>To:</b> Basques, Bob (CI-StPaul)<br>
<b>Cc:</b> geomoose-users@lists.osgeo.org<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">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>
<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 11:41 AM, Basques, Bob (CI-StPaul) wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif"">Brent (and others),</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif""> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif"">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif""> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif"">Bobb</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif""> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif""> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS ;color:windowtext","serif""> </span><o:p></o:p></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 href="mailto:geomoose-users-bounces@lists.osgeo.org">geomoose-users-bounces@lists.osgeo.org</a> [<a 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 href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [Geomoose-users] Postgis layer - point out</span><o:p></o:p></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 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>
<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>
<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 href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<br>
<a 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>
<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 border="0" width="132" height="51" id="_x0000_i1025" src="cid:image001.jpg@01CE13F4.A0E89C70"></span><o:p></o:p></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 border="0" width="40" height="40" id="_x0000_i1026" src="cid:image002.jpg@01CE13F4.A0E89C70"></span><o:p></o:p></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</span><o:p></o:p></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""> </span><o:p></o:p></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</span><o:p></o:p></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</span><o:p></o:p></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""> </span><o:p></o:p></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:</span><o:p></o:p></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</span><o:p></o:p></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:</span><o:p></o:p></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</span><o:p></o:p></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:</span><o:p></o:p></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</span><o:p></o:p></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"">---------------------------------------------------</span><o:p></o:p></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</span><o:p></o:p></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</span><o:p></o:p></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)</span><o:p></o:p></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</span><o:p></o:p></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>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>