I have a join query that is used to fuel a DATA statement, and it works on the
command line, and inside of mapserver as it is grabbing the data, but when it
goes to rendering the final geometry it fails because it cannot seem to
determine what table name to look for in the find_srid statement:
find_srid('','(select','poly_geom') . Am I running up against some complexity
limitation of mapserver, or making some mistake in my DATA query?
DATA "poly_geom FROM (select foo.poly_geom, foo.elemname,foo.elementid,
foo.dataval as dataval_%runid1%, bar.dataval as dataval_%runid2%,
round(((bar.dataval - foo.dataval) / foo.dataval)::numeric,4) as delta_pct from
(select a.poly_geom, b.elementid, a.scenarioid, a.elemname, a.custom1,
a.custom2, b.runid, b.dataname, b.dataval, b.datatext from scen_model_element
as a left outer join scen_model_run_data as b on ( a.elementid = b.elementid)
left outer join scen_model_element as c on (c.scenarioid = %pscen% and
c.custom1 in ('cova_ws_subnodal', 'cova_ws_container') and
contains(c.poly_geom,a.point_geom) ) where a.scenarioid = %nscen% and b.runid =
%runid1% and b.dataname = '%dataname1%' ) AS foo, (select d.poly_geom,
e.elementid, d.scenarioid, d.elemname, d.custom1, d.custom2, e.runid,
e.dataname, e.dataval, e.datatext from scen_model_element as d left outer join
scen_model_run_data as e on ( d.elementid = e.elementid) left outer join
scen_model_element as f on (f.scenarioid = %pscen% and f.custom1 in
('cova_ws_subnodal', 'cova_ws_container') and
contains(f.poly_geom,d.point_geom) ) where d.scenarioid = %nscen% and e.runid =
%runid2% and e.dataname = '%dataname2%' ) AS bar where foo.elementid =
bar.elementid ) AS foobar USING UNIQUE elementid"
Robert Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
