<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
What is "and (16C2BO010)"?<br>
<br>
<br>
<div class="moz-cite-prefix">On 06/01/2015 07:11 AM, Fernando wrote:<br>
</div>
<blockquote cite="mid:DUB120-W44A481AF11B18E81E70564F6B60@phx.gbl"
type="cite">
<pre wrap="">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.
And to test the idea of Tanya, I have corrected the projection of drawing, referencing it with ArcMap to EPSG 23030:
Projected Coordinate System: ED_1950_UTM_Zone_30N
Projection: Transverse_Mercator
Linear Unit: Meter
And placing on the extend of southern Spain following: 358836 4186265 359163 4186624
MAP
NAME EDIFICIO_C2_MAP
STATUS ON
EXTENT 358836 4186265 359163 4186624
UNITS METERS
.....
PROJECTION
"init=epsg:23030"
END
......
LAYER
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=************** dbname=edificio_c2 host=localhost port=5432"
DATA "the_geom FROM c2_shape USING UNIQUE gid USING SRID=23030"
.....
And the error is as follows:
Warning: layerObj::queryByRect(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»
LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)
^
in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 72
Warning: mapObj::setExtent(): [MapServer Error]: setExtent(): Given map extent is invalid. Check that it is in the form: minx, miny, maxx, maxy
in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100
Warning: mapObj::setExtent(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»
LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)
^
in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100
Fatal error: Uncaught exception 'MapScriptException' in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php:100
Stack trace:
#0 C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php(100): mapObj->setExtent(0, 0, 0, 0)
#1 {main}
thrown in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100
It might be a bug GeoMOOSE programming? What else I can do?
Date: Thu, 28 May 2015 10:22:53 -0600
From: <a class="moz-txt-link-abbreviated" href="mailto:bfraser@geoanalytic.com">bfraser@geoanalytic.com</a>
To: <a class="moz-txt-link-abbreviated" href="mailto:nando_gcia@hotmail.com">nando_gcia@hotmail.com</a>; <a class="moz-txt-link-abbreviated" href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a>
Subject: Re: [Geomoose-users] Feature Report error with Identify Tool
Fernanado,
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:
Warning: layerObj
:: queryByRect (): [MapServer Error]:
msPostGISLayerWhichShapes (): Error executing query: ERROR:
syntax error at or near "C2BN001"
LINE 1: ... -1 362.227 362.227
-136 -1 -136 -1)) ', 3857) and (16C2BN001)
^
It looks like it's having a problem with the unique key. You
specified
<Td>
[dxf_text] <a href=<a class="moz-txt-link-rfc2396E" href="javascript:GeoMOOSE.startService('feature_report',{'dxf_text':'[dxf_text]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">"javascript:GeoMOOSE.startService('feature_report',
{'dxf_text':'[dxf_text]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ a>
</ td>
but you may want to try:
<Td>
[dxf_text] <a href=<a class="moz-txt-link-rfc2396E" href="javascript:GeoMOOSE.startService('feature_report',{'gid':'[gid]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">"javascript:GeoMOOSE.startService('feature_report',
{'gid':'[gid]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ a>
</ td>
Best Regards,
Brent Fraser
_______________________________________________
Geomoose-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geomoose-users">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Geomoose-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geomoose-users">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a></pre>
</blockquote>
<br>
</body>
</html>