<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Bob,<br>
<br>
Personally, I'd select PostGIS for data management reasons, not
performance. If you've got a few shapefiles a few thousand records
and a spatial index (.qix), shapefiles will likely [slightly]
out-perform PostGIS.<br>
<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<br>
On 2/16/2012 8:00 AM, Bistrais, Bob wrote:
<blockquote
cite="mid:4EFF8BB964547748A07CA32961810C041D05039E@SOM-TEAQASMAIL1.som.w2k.state.me.us"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 11 (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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</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="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Not yet, still
fumbling with the Simplfy
statement. But, as was said, it’s not really appropriate
to have the
parcels display at that scale. This is more of an
experiment to see how well I
can improve performance with PostGIS over shapefiles. Any
advice is welcomed
on that.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" style="text-align:center"
align="center"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt;color:windowtext">
<hr tabindex="-1" align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma"
size="2"><span
style="font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma;
color:windowtext"> Brent Fraser
[<a class="moz-txt-link-freetext" href="mailto:bfraser@geoanalytic.com">mailto:bfraser@geoanalytic.com</a>] <br>
<b><span style="font-weight:bold">Sent:</span></b>
Thursday, February 16, 2012
9:55 AM<br>
<b><span style="font-weight:bold">To:</span></b>
Bistrais, Bob<br>
<b><span style="font-weight:bold">Cc:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
<b><span style="font-weight:bold">Subject:</span></b>
Re: [Geomoose-users]
Trouble with PostGis layer on GM 2.2</span></font><font
color="black"><span style="color:windowtext"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt">Cool. Did you sort
out your performance problems
with the state-wide parcel layer?<br>
<br>
<br>
<o:p></o:p></span></font></p>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt">Best Regards,<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt">Brent Fraser<o:p></o:p></span></font></pre>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt"><br>
On 2/16/2012 7:52 AM, Bistrais, Bob wrote: <o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Yes, as it turns out, that’s what I had to do and
it’s working now.<u5:p></u5:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"><u5:p> </u5:p></span></font><o:p></o:p></p>
<div>
<div class="MsoNormal" style="text-align:center"
align="center"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt;color:windowtext">
<hr tabindex="-1" align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma"
size="2"><span
style="font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma;
color:windowtext"> Brent Fraser [<a
moz-do-not-send="true"
href="mailto:bfraser@geoanalytic.com">mailto:bfraser@geoanalytic.com</a>]
<br>
<b><span style="font-weight:bold">Sent:</span></b>
Thursday, February 16, 2012
9:37 AM<br>
<b><span style="font-weight:bold">To:</span></b>
Bistrais, Bob<br>
<b><span style="font-weight:bold">Cc:</span></b> <a
moz-do-not-send="true"
href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
<b><span style="font-weight:bold">Subject:</span></b>
Re: [Geomoose-users]
Trouble with PostGis layer on GM 2.2</span></font><o:p></o:p></p>
</div>
<u5:p></u5:p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt"><u5:p> </u5:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt">If your PostGIS
server and mapserver are on different
computers, make sure you've enabled Postgres to accept
remote connects (edit
pg_hba.conf).<br>
<br>
<br>
<o:p></o:p></span></font></p>
<u5:p></u5:p>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt">Best Regards,<u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt">Brent Fraser<u5:p></u5:p><o:p></o:p></span></font></pre>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:12.0pt"><br>
On 2/15/2012 12:50 PM, Bistrais, Bob wrote: <u5:p></u5:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Trying to implement some layers through PostGIS, and
I’m a PG newbie (some of you have seen my struggles on the
other
lists). But now I am having trouble displaying a layer in
GeoMoose
2.2. I think this may be related to the MapServer
version, as this same
layer works fine with MapServer 6.0.1<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial">The error message is as follows:<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial">msPOSTGISLayerOpen(): Query
error. Couldn't make
connection to DB with connect string<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial">The connection strings:<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"> DATA "the_geom from
bb_connectme_rds
USING SRID=26919 USING Unique gid"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"> CONNECTION "user=myusername
password=mypassword dbname=postgistest host=mymachinename
port=5432"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"> CONNECTIONTYPE postgis<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"> PROCESSING
"CLOSE_CONNECTION=DEFER"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial"><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial">As I mentioned, this all works
fine on another
service using MapServer 6.0.1. Does PostGis work with GM
2.2? If
so, does it look like my connection strings are incorrect?<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt"><br>
<br>
<o:p></o:p></span></font></p>
<pre><font color="black" face="Courier New" size="2"><u5:p></u5:p><span style="font-size:10.0pt"><fieldset class="mimeAttachmentHeader"></fieldset>_______________________________________________<u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt">Geomoose-users mailing list<u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt"><a href="mailto:Geomoose-users@lists.osgeo.org" moz-do-not-send="true">Geomoose-users@lists.osgeo.org</a><u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt"><a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" moz-do-not-send="true">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><u5:p></u5:p><o:p></o:p></span></font></pre>
</div>
</blockquote>
</body>
</html>