<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Hi again, after reading your answers, I tried to change dxf_text to gid, as Brent says but the error is exactly the same. The dxf_text column are unique identifiers of our project.</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">And to test the idea of Tanya, I have corrected the projection of drawing, referencing it with ArcMap to EPSG 23030:</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Projected Coordinate System: ED_1950_UTM_Zone_30N</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Projection: Transverse_Mercator</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Linear Unit: Meter</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">And placing on the extend of southern Spain following: 358836 4186265 359163 4186624</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">MAP</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> NAME EDIFICIO_C2_MAP</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> STATUS ON</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> EXTENT 358836 4186265 359163 4186624</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> UNITS METERS </span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">.....</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> PROJECTION</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> "init=epsg:23030"</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> END</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">......</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">LAYER</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> CONNECTIONTYPE postgis</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> CONNECTION "user=postgres password=************** dbname=edificio_c2 host=localhost port=5432"</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> DATA "the_geom FROM c2_shape USING UNIQUE gid USING SRID=23030"</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">.....</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">And the error is as follows:</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Warning: layerObj::queryByRect(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> ^</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 72</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Warning: mapObj::setExtent(): [MapServer Error]: setExtent(): Given map extent is invalid. Check that it is in the form: minx, miny, maxx, maxy</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Warning: mapObj::setExtent(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> ^</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Fatal error: Uncaught exception 'MapScriptException' in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php:100</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">Stack trace:</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">#0 C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php(100): mapObj->setExtent(0, 0, 0, 0)</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">#1 {main}</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);"> thrown in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100</span><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><br style="line-height: 21.2999992370605px; color: rgb(68, 68, 68); font-size: 15px; background-color: rgb(255, 255, 255);"><span style="color: rgb(68, 68, 68); font-size: 15px; line-height: 21.2999992370605px; background-color: rgb(255, 255, 255);">It might be a bug GeoMOOSE programming? What else I can do?</span><br><br><div><hr id="stopSpelling">Date: Thu, 28 May 2015 10:22:53 -0600<br>From: bfraser@geoanalytic.com<br>To: nando_gcia@hotmail.com; geomoose-users@lists.osgeo.org<br>Subject: Re: [Geomoose-users] Feature Report error with Identify Tool<br><br>
Fernanado,<br>
<br>
When Mapserver does the attribute query as requested by the
GeoMOOSE feature_report.php, it applies a spatial filter based on
the EXTENT stated in the map file and a filter on a unique key:<br>
<br>
<tt><span id="ecxresult_box" lang="en"><span title="Warning: layerObj::queryByRect(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BN001» ">Warning: layerObj
:: queryByRect (): [MapServer Error]:
msPostGISLayerWhichShapes (): Error executing query: ERROR:
syntax error at or near "C2BN001"<br>
</span><span title="LINE 1: ... -1,-136 362,227 362,227 -1,-136 -1))',3857) and (16C2BN001) ">LINE 1: ... -1 362.227 362.227
-136 -1 -136 -1)) ', 3857) and (16C2BN001)<br>
</span><span title="^ ">^</span></span></tt><br>
<br>
It looks like it's having a problem with the unique key. You
specified<br>
<br>
<span id="ecxresult_box" lang="en"><tt><span title="<td>[dxf_text] <a href="javascript:GeoMOOSE.startService('feature_report', {'dxf_text' : '[dxf_text]', 'src' : 'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">Report</"><Td>
[dxf_text] <a href=<a class="ecxmoz-txt-link-rfc2396E" target="_blank">"javascript:GeoMOOSE.startService('feature_report',
{'dxf_text':'[dxf_text]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ </span></tt><span title="a></td> "><tt>a>
</ td></tt><tt><br>
</tt><br>
but you may want to try:<br>
<br>
</span></span><tt><span id="ecxresult_box" lang="en"><span title="<td>[dxf_text] <a href="javascript:GeoMOOSE.startService('feature_report', {'dxf_text' : '[dxf_text]', 'src' : 'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">Report</"><Td>
[dxf_text] <a href=<a class="ecxmoz-txt-link-rfc2396E" target="_blank">"javascript:GeoMOOSE.startService('feature_report',
{'gid':'[gid]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ </span><span title="a></td> ">a>
</ td></span></span></tt><tt><br>
</tt><br>
<br>
<pre class="ecxmoz-signature">Best Regards,
Brent Fraser</pre>
<div class="ecxmoz-cite-prefix">On 5/28/2015 4:10 AM, Fernando wrote:<br>
</div>
<blockquote cite="mid:DUB120-W3442CFEC1F584CAEFF04E4F6CA0@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr"><span id="ecxresult_box" lang="en"><span class="ecxhps">Brent</span><span>,
thank </span></span><span id="ecxresult_box" lang="en"><span><span id="ecxresult_box" class="ecxshort_text" lang="en"><span class="ecxhps">you for your replies but</span></span> how
can I</span> <span class="ecxhps">georeference</span> <span class="ecxhps">the building plan</span> <span class="ecxhps">correctly</span>
<span class="ecxhps">?</span> <span class="ecxhps">Actually</span>
<span class="ecxhps">we don't need</span> <span class="ecxhps">to</span>
<span class="ecxhps">have an</span> real <span class="ecxhps">coordinate
system</span><span>,</span> <span class="ecxhps">that does not
matter</span> <span class="ecxhps">in the project.</span> W<span class="ecxhps">e start from</span> <span class="ecxhps">a DXF</span>
<span class="ecxhps">AutoCAD drawing</span> <span class="ecxhps">and</span>
<span class="ecxhps">converted into</span> <span class="ecxhps">shapefile</span>
<span class="ecxhps">with</span> <span class="ecxhps">ArcTools</span>
<span class="ecxhps">and then</span> <span class="ecxhps">import it</span>
<span class="ecxhps">to</span> <span class="ecxhps">POSTGIS</span><span>.</span>
<span class="ecxhps">To display</span> <span class="ecxhps">online</span>
<span class="ecxhps">we decided to</span> <span class="ecxhps">try</span>
<span class="ecxhps">GeoMOOSE</span><span>.</span></span><br>
<br>
<span id="ecxresult_box" class="ecxshort_text" lang="en"><span class="ecxhps">How do you think</span> <span class="ecxhps">that</span>
<span class="ecxhps">would solve</span> <span class="ecxhps">the
error</span><span>?<br>
<br>
<br></span></span><div><blockquote cite="mid:DUB120-W24A0B6BDC6AE17EBF05A94F6CB0@phx.gbl"><pre>Geomoose-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a></pre>
</blockquote>
<br>
</div>
</div>
</blockquote>
<br></div><style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style> </div></body>
</html>