<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div>GeoMOOSE will work with any dataset mapserver can process.<br><br>Here's the mapserver documentation on the use of PostGIS/PostgreSQL:<br> http://mapserver.gis.umn.edu/docs/reference/vector_data/postgis/?searchterm=postgis<br><br>Can you verify that the geometry column is named "the_geom"? Typically tools will name the column "wkb_geometry".<br><br><br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Shashwat_Nigam <Shashwat_Nigam@satyam.com><br>To: "geomoose-users@lists.sourceforge.net" <geomoose-users@lists.sourceforge.net><br>Sent: Wednesday, August 27, 2008 7:30:48 AM<br>Subject: [Geomoose-users] shape file to
database<br><br>
<style>
<!--
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
.MsoChpDefault
{}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal">I am trying to exclude .shp files and to have database connectivity instead. For that I converted the shape files to .sql using shp2pgsql.exe as it is a tool given by PostgreSQL. After this in the map files I provided the connection as</p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"> </span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"> CONNECTIONTYPE postgis</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"> CONNECTION "host=localhost dbname=Database_name user=postgres password=Password port=5432"</span></p>
<p class="MsoNormal" style=""> <span style="font-size: 10pt;">
DATA "the_geom from county"</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"> </span></p>
<p class="MsoNormal">But after this a few layers are able to load and rest not. Even at certain zoom levels other layers breaks.
</p>
<p class="MsoNormal">I want to know that is there anything else to done for the same or GeoMOOSE application is only valid for file based system not for database.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style=""><b><span style="font-size: 10pt; color: gray;">Thanks & Regards,</span></b><span style="font-size: 12pt; color: navy;"></span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt;"><a rel="nofollow" ymailto="mailto:shashwat_nigam@satyam.com" target="_blank" href="mailto:shashwat_nigam@satyam.com" title="Shashwat Nigam"><span style="color: windowtext; text-decoration: none;">Shashwat Nigam</span></a></span></b></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; color: gray;">|
</span></b><b><span style="font-size: 7.5pt; color: gray;">Software Engineer | Geographical Information System</span></b><span style="font-size: 12pt; color: gray;"></span></p>
<p class="MsoNormal"><b><span style="font-size: 7.5pt; color: gray;"><a rel="nofollow" target="_blank" href="http://www.satyam.com/"><span style="color: gray; text-decoration: none;">Satyam Computer Services Limited</span></a>, Hyderabad | MOBILE</span></b><b><span style="font-size: 8pt; color: gray;" lang="FR">:
+919951467324</span></b><span style="font-size: 10pt; color: gray;"> | </span><span style="font-size: 12pt;"></span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>
<br>
<hr>
<font color="Navy" size="2" face="Arial">DISCLAIMER:<br>
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or
all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.<br>
</font>
</div></div></div><br>
</body></html>