[Geomoose-users] shape file to database

[Shashwat_Nigam]

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.
Thanks & Regards,
Shashwat Nigam<mailto:shashwat_nigam at satyam.com>
| Software Engineer | Geographical Information System
Satyam Computer Services Limited<http://www.satyam.com/>, Hyderabad | MOBILE: +919951467324 |

From: Dan Little [mailto:danlittle at yahoo.com]
Sent: Wednesday, August 27, 2008 6:59 PM
To: Shashwat_Nigam; geomoose-users at lists.sourceforge.net
Subject: Re: [Geomoose-users] shape file to database

GeoMOOSE will work with any dataset mapserver can process.

Here's the mapserver documentation on the use of PostGIS/PostgreSQL

Can you verify that the geometry column is named "the_geom"? Typically tools will name the column "wkb_geometry".

----- Original Message ----
From: Shashwat_Nigam <Shashwat_Nigam at satyam.com>
To: "geomoose-users at lists.sourceforge.net" <geomoose-users at lists.sourceforge.net>
Sent: Wednesday, August 27, 2008 7:30:48 AM
Subject: [Geomoose-users] shape file to database
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

      CONNECTIONTYPE postgis
      CONNECTION "host=localhost dbname=Database_name user=postgres password=Password port=5432"
                DATA "the_geom from county"

But after this a few layers are able to load and rest not. Even at certain zoom levels other layers breaks.
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.


Thanks & Regards,
Shashwat Nigam<mailto:shashwat_nigam at satyam.com>
| Software Engineer | Geographical Information System
Satyam Computer Services Limited<http://www.satyam.com/>, Hyderabad | MOBILE: +919951467324 |



________________________________
DISCLAIMER:
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.


________________________________
DISCLAIMER:
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20080828/241e49b2/attachment.html