[postgis-devel] PostGIS-1.x / Mapserver bug (hopefully) fixed

[strk at refractions.net]

Thank you, hopefully we've fixed this long-standing bug.
The force_collection() function was broken.
RC3 should not have this problem anymore.
Please anyone having this problem try current CVS.

--strk;

On Mon, Feb 14, 2005 at 01:47:36PM -0500, Mike Leahy wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users