[postgis-users] Does PostGIS 1.0RC1/2 work with MS4W/Mapserver 4.4.1?

[Mike Leahy]

Yes, that was it exactly.

I verified that any MULTIPOINT, MULTILINESTRING or MULTIPOLYGON will draw fine
for me, but POINT, LINESTRING or POLYGON all do not.  I was able to get my
points to draw by using the following as the layer's data string in the MapFile
as a temporary solution:

"the_geom from (select oid, collect(the_geom) as the_geom from gis_pointstable
group by oid) as foo using srid=4326 using uniqe oid"

If I need to include any additional attributes, I'll just have to add them to
the subquery 'select' and 'group by' lists.

Thank you very much for your help.

Mike



Quoting strk at refractions.net:

> On Mon, Feb 14, 2005 at 06:04:51PM +0100, Dirk Jesko wrote:
> > I am pretty sure that is the same issue. Until now I tested several 
> > installation with always the same result: No mapserver will display 
> > points coming from a PostGIS 1.0.0RC1 or newer.
> > I would really be interested whether this is caused by Mapserver or 
> > PostGIS. Since the 0.9.x work and there are also no problems with other 
> > geometry types like polygon or line, I doubt that the problem is caused 
> > by the mapserver.
> 
> You might want to try postgis from current CVS, or wait for RC3, as
> memory alignment problems might have a role in this situation.
> 
> Please let me know if you try. Also, do you confirm POINT are the
> only geometry you have problems with ? I've had reports of problems
> with POLYGONS as well (but not with MULTIPOLYGONS).
> 
> --strk;
> 
> > 
> > Regards,
> > Dirk
> > 
> > 
> > >Check http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1216.  This might
> 
> > >be the same issue you've run into.  If so, roll back to PostGIS 0.9.1.
> > >
> > >-Perry
> > >
> > >On Monday 14 February 2005 08:28 am, Mike Leahy wrote:
> > > 
> > >
> > >>Hello list,
> > >>
> > >>I'm just wondering if anyone has been able to get Mapserver to draw maps
> > >>with PostGIS layers using the latest MS4W package with 1.0 RC1 or RC2 of
> > >>PostGIS. I'm having a bit of trouble...after updating PostGIS to the
> > >>lastest version available (via the windows installer), it seems that my
> > >>Mapserver/Chameleon application in my MS4W installation no longer likes
> > >>PostGIS layers.  I have a fairly simple table in PostGIS with POINT
> > >>geometry that I imported using shp2pgsql (the version supplied with the
> > >>installer).  As far as I can tell, all the data are valid...and
> Mapserver
> > >>doesn't actually complain, it just draws a blank layer instead of the
> > >>points in the actual table.  The same identical table imported into 
> > >>PostGIS
> > >>0.9.1 had no troubles with my MS4W application...I can only guess where
> > >>I've gone wrong.    Just to be sure, I set the extent in my mapfile to
> the
> > >>extents returned for the table from PostGIS, and the map still appeared
> > >>blank.
> > >>
> > >>Can anyone recommend where I should look first to figure this out?
> > >>
> > >>Thanks,
> > >>Mike
> > >>
> > >>   
> > >>
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 




----------------------------------------
This mail sent through www.mywaterloo.ca