Racked my brain on this last Friday, couldn't get anything to work from a
Mapserver Mapfile.
I can get the numbers from POSTGIS just fine via PGADMIN, but they come back as
a BOX entity which MapServer doesn't seem to know what to do with. I tried
casting but got no matching records.
MAPFILE fragment . . .
DATA "the_geom from (
select
st_extent(sub1.the_geom)::geometry as the_geom
from
loc_last as sub1
where
vname in (%asset_id%) -- vname in
('2293','2297')
) as subquery using unique the_geom using srid=200068"
In pgadmin, the above select returns polygon (per st_astext applied) The
subselect is grabbing a couple of points based on asset_id(s).
Thanks
bobb
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
