All,
answering my own question . . .
Geez, was that involved . . . .
I get a (real polygon) geometry from this:
select
st_transform(
st_setSRID(
st_extent(
the_geom
)::geometry, 200068
), 3857i
) as boundingp
from
loc_last
where
vname in ('2293','2297')
bobb
On 8/11/14 1:04 PM, Basques, Bob (CI-StPaul) wrote:
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
