[ms4w-users] mapserver and postgis doesn´t work

[Bart van den Eijnden]

Hi,

that's quite an advanced setup you want to create. I hope you already have  
some experience with the tools you are gonna use ...

Okay, to help you getting started, I can send you my MAP file (attached)  
and the things I did to put my data into PostGIS using a shapefile as a  
datasource.

You can also checkout the PostGIS workshops from:

http://www.omsug.ca/osgis2004/proceedings.html

--

initdb
pgstart

env
createdb bart

C:\pgsql75win>psql -d bart -f share/contrib/postgis.sql
C:\pgsql75win>psql -d bart -f share/contrib/spatial_ref_sys.sql

load shapefile:
C:\pgsql75win>shp2pgsql -D F:\pgsql75win\data\t50_vlakken_region.shp top50  
bart > f:\top50.sql

load the written sql file:
C:\pgsql75win>psql -d bart -f f:/top50.sql

create spatial index
psql -d bart
CREATE INDEX top50_geom_idx ON top50 USING GIST (the_geom  
GIST_GEOMETRY_OPS);

vacuum analyze;

Best regards,
Bart

On Sat, 08 Jan 2005 14:55:16 +0100, Martin K <krekoma at centrum.cz> wrote:

> How can I make a comunication between mapserver and postgis. I´m trying  
> latest ms4w and ms4wworkshop. I tried to config mapserver to publish WFS  
> with connection to postgis, but no data from dbase was responsed on my  
> request. If anyone have same experienc with this problem please help me,  
> I need *.map file with the correct settings WFS and connection to  
> postgis and some correct script to fill dbase with some data. Thansk
> _______________________________________________
> ms4w-users mailing list
> ms4w-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ms4w-users
>



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: top50postgis.map
Type: application/octet-stream
Size: 2673 bytes
Desc: not available
Url : http://lists.maptools.org/pipermail/ms4w-users/attachments/20050108/71794ee0/top50postgis.obj