<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (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: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:Verdana;
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:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks Dan … but I already mentioned that GeoMOOSE is facing problem even I had done the same as given in the link. Ya the geometry column in this case is the_geom only and it is producing data as it is. But
a few layers not. Also after a certain zoom extent it seems to be failed. Again in case of search it responding with an error. Please have a look to sort it out.<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:gray">Thanks & Regards,</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";
color:navy"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:#1F497D"><a href="mailto:shashwat_nigam@satyam.com" title="Shashwat Nigam"><span style="color:#1F497D;text-decoration:none">Shashwat Nigam</span></a><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray">|
</span></b><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray">Software Engineer | Geographical Information System</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";color:gray"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray"><a href="http://www.satyam.com/"><span style="color:gray;
text-decoration:none">Satyam Computer Services Limited</span></a>, Hyderabad | MOBILE</span></b><b><span lang="FR" style="font-size:8.0pt;
font-family:"Arial","sans-serif";color:gray">:
+919951467324</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:gray"> | </span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<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"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Dan Little [mailto:danlittle@yahoo.com]
<br>
<b>Sent:</b> Wednesday, August 27, 2008 6:59 PM<br>
<b>To:</b> Shashwat_Nigam; geomoose-users@lists.sourceforge.net<br>
<b>Subject:</b> Re: [Geomoose-users] shape file to database<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;
font-family:"Arial","sans-serif"">GeoMOOSE will work with any dataset mapserver can process.<br>
<br>
Here's the mapserver documentation on the use of PostGIS/PostgreSQL <br>
<br>
Can you verify that the geometry column is named "the_geom"? Typically tools will name the column "wkb_geometry".<br>
<br>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">----- 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<span style="font-size:12.0pt;
font-family:"Times New Roman","serif""><o:p></o:p></span></p>
<div>
<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<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> CONNECTIONTYPE postgis</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> CONNECTION "host=localhost dbname=Database_name user=postgres password=Password port=5432"</span><o:p></o:p></p>
<p class="MsoNormal"> <span style="font-size:10.0pt">DATA "the_geom from county"</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> </span><o:p></o:p></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.
<o:p></o:p></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.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">Thanks & Regards,</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt"><a href="mailto:shashwat_nigam@satyam.com" target="_blank" title="Shashwat Nigam"><span style="color:windowtext;text-decoration:none">Shashwat Nigam</span></a></span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">| </span></b><b><span style="font-size:7.5pt;color:gray">Software Engineer | Geographical Information System</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;color:gray"><a href="http://www.satyam.com/" target="_blank"><span style="color:gray;
text-decoration:none">Satyam Computer Services Limited</span></a>, Hyderabad | MOBILE</span></b><b><span lang="FR" style="font-size:8.0pt;
color:gray">:
+919951467324</span></b><span style="font-size:10.0pt;color:gray"> | </span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p> </o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy">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.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p> </o:p></span></p>
</div>
<br>
<hr>
<font face="Arial" color="Navy" size="2">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>
</body>
</html>