<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">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: <span style="font-size:13.5pt;color:black;background:white">find_srid('','(select','poly_geom')</span> . Am I running up against some complexity limitation of mapserver, or making some mistake in my
DATA query?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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"<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Robert Burgholzer<o:p></o:p></p>
<p class="MsoNormal">Surface Water Modeler <br>
Virginia DEQ Office of Surface and Ground Water Supply<o:p></o:p></p>
<p class="MsoNormal">804-869-3066<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>