<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<div class="moz-cite-prefix">On 5/28/2015 4:10 AM, Fernando wrote:<br>
</div>
<blockquote cite="mid:DUB120-W3442CFEC1F584CAEFF04E4F6CA0@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr"><span id="result_box" lang="en"><span class="hps">Brent</span><span>,
thank </span></span><span id="result_box" lang="en"><span><span
id="result_box" class="short_text" lang="en"><span
class="hps">you for your replies but</span></span> how
can I</span> <span class="hps">georeference</span> <span
class="hps">the building plan</span> <span class="hps">correctly</span>
<span class="hps">?</span> <span class="hps">Actually</span>
<span class="hps">we don't need</span> <span class="hps">to</span>
<span class="hps">have an</span> real <span class="hps">coordinate
system</span><span>,</span> <span class="hps">that does not
matter</span> <span class="hps">in the project.</span> W<span
class="hps">e start from</span> <span class="hps">a DXF</span>
<span class="hps">AutoCAD drawing</span> <span class="hps">and</span>
<span class="hps">converted into</span> <span class="hps">shapefile</span>
<span class="hps">with</span> <span class="hps">ArcTools</span>
<span class="hps">and then</span> <span class="hps">import it</span>
<span class="hps">to</span> <span class="hps">POSTGIS</span><span>.</span>
<span class="hps">To display</span> <span class="hps">online</span>
<span class="hps">we decided to</span> <span class="hps">try</span>
<span class="hps">GeoMOOSE</span><span>.</span></span><br>
<br>
<span id="result_box" class="short_text" lang="en"><span
class="hps">How do you think</span> <span class="hps">that</span>
<span class="hps">would solve</span> <span class="hps">the
error</span><span>?<br>
<br>
<br>
</span></span><br>
<div>
<hr id="stopSpelling">Date: Wed, 27 May 2015 07:36:02 -0600<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:bfraser@geoanalytic.com">bfraser@geoanalytic.com</a><br>
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><br>
Subject: Re: [Geomoose-users] Feature Report error with
Identify Tool<br>
<br>
Fernando,<br>
<br>
Your EXTENT is set to <br>
<br>
<span id="ecxresult_box" lang="en"><span
title="</tr> "> EXTENT -136 -1 227 362</span></span><br>
<span id="ecxresult_box" lang="en"><span title="</tr> "><span
id="ecxresult_box" lang="en"><span title="</tr> ">
UNITS METERS</span></span><br>
<br>
while not technically invalid, it means you are mapping an
area about 400 meters by 400 meters off the coast of
Africa. Try setting the EXTENT to values for your mapping
area.<br>
</span></span>
<pre class="ecxmoz-signature">Best Regards,
Brent Fraser</pre>
<div class="ecxmoz-cite-prefix">On 5/27/2015 3:44 AM, Fernando
wrote:<br>
</div>
<blockquote
cite="mid:DUB120-W24A0B6BDC6AE17EBF05A94F6CB0@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
title="Hola de nuevo, tras hacer que funcione
correctamente la herramienta "Identify", he
añadido la opción de "feature_report" pero
se produce un error. ">Hello again, after making the
"Identify" tool to work properly, I added the option
"feature_report" but fails.<br>
<br>
</span><span title="Mi fichero identify.html es: ">My
identify.html file is:<br>
<br>
</span><span title="<!-- MapServer Template --> "><!
- MapServer Template -><br>
</span><span title="<tr
bgcolor="#DEE5EB"><td
colspan="2"><b><u>ESPACIOS</u></b></tr>"><Tr
bgcolor = "# DEE5EB"> <td colspan = "2">
<b> <u> SPACE </ u> </ b>
</ tr><br>
</span><span title="<tr> "><Tr><br>
</span><span title="<td
align="right"><b>IDENTIFICADOR:</b></td>
"><Td align = "right"> <b> IDENTIFIER:
</ b> </ td><br>
</span><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 moz-do-not-send="true"
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><span title="a></td> ">a>
</ td><br>
</span><span title="</tr> "></ Tr><br>
</span><span title="<tr> "><Tr><br>
</span><span title="<td
align="right"><b>CONTENIDO:</b></td>
"><Td align = "right"> <b> Content: </
b> </ td><br>
</span><span title="<td>[contenido]</td> "><Td>
[content] </ td><br>
</span><span title="</tr> "></ Tr><br>
-----------------------------------------------<br>
My map file is:<br>
<br>
MAP
<br>
NAME EDIFICIO_C2_MAP <br>
STATUS ON
<br>
SIZE 800 800 <br>
EXTENT -136 -1 227 362 <br>
UNITS METERS
<br>
<br>
INCLUDE "./geomoose_globals.map"<br>
<br>
IMAGECOLOR 255 255 255 <br>
IMAGETYPE PNG
<br>
SYMBOLSET "./symbols/symbol.sym" <br>
FONTSET "./fonts/fontset.list" <br>
TRANSPARENT FALSE<br>
RESOLUTION 100<br>
DEFRESOLUTION 100<br>
CONFIG "MS_ERRORFILE" "/ms4w/ms_error_c2.txt"<br>
DEBUG 5<br>
<br>
OUTPUTFORMAT<br>
NAME png<br>
DRIVER "AGG/PNG"<br>
MIMETYPE "image/png"<br>
IMAGEMODE PC256<br>
EXTENSION "png"<br>
FORMATOPTION "GAMMA=0.75"<br>
END<br>
-----------------------------------<br>
</span></span><br>
<span id="ecxresult_box" lang="en"><span
title="</tr> "><span id="ecxresult_box"
lang="en"><span title="Mi fichero identify.html es:
">My parcel.xml file is:<br>
<br>
</span></span><feature-report><br>
<!-- query informtion --><br>
<query item="dxf_text" string="%qstring%"/><br>
<br>
<!-- This is the template --><br>
<template>parcel_template.pdf</template><br>
<br>
<!-- this is the location of the map in the
template --><br>
<map x="0.92" y="2.18" w="6.69" h="3.68"/><br>
<br>
<!-- This is a list of where the fields are to
be printed on the template --><br>
<fields><br>
<field x=".5" y="7.25" src="%dxf_text%"
title="IDENTIFICADOR:"/><br>
<field x=".5" y="7.45" src="%contenido%"
title="CONTENIDO:"/><br>
<br>
<field x=".5" y="8.25" src="%area%"
title="AREA:" format='%0.2f'/><br>
<field x=".5" y="8.45" src="%perimeter%"
title="PERIMETRO:"/><br>
</fields><br>
</feature-report><br>
<br>
------------<br>
<br>
<br>
</span><span title="Búsqueda de prueba: ">Test search
results:<br>
<br>
</span><span title="Detailed information for the area
you clicked on the map... ">Detailed information for
the area you clicked on the map ...<br>
</span><span title="Ground Coordinates ">Ground
Coordinates<br>
</span><span title="X: 116.27685546875 ">X:
116.27685546875<br>
</span><span title="Y: 299.78662109375 ">Y:
299.78662109375<br>
<br>
</span><span title="ESPACIOS ">SPACES<br>
</span><span title="IDENTIFICADOR: 16C2BN001 Report ">IDENTIFIER:
16C2BN001 Report<br>
</span><span title="CONTENIDO: VESTIBULO DPTO.">CONTENTS:
DEPARTMENT HALL. </span><span title="FISICA ">PHYSICAL<br>
</span><span title="TIPO UBICACIÓN: VESTIBULO ">LOCATION
TYPE: HALL<br>
</span><span title="TIPO USO: ZONA COMUN ">USE TYPE:
COMMON AREA<br>
<br>
-----------------------------------------<br>
<br>
</span><span title="Error: "></span></span><span
id="ecxresult_box" lang="en"><span title="Error: "><span
id="ecxresult_box" lang="en"><span title="Error
cuando hago click en el hipervínculo
"Report": ">Error when I click on the
hyperlink "Report":<br>
<br>
</span></span></span><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="^ ">^<br>
</span><span title="in
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php
on line 72 ">in C: \ MS4W \ apps \ geomoose2 \ htdocs
\ php \ feature_report.php on line 72<br>
<br>
</span><span title="Warning: mapObj::setExtent():
[MapServer Error]: setExtent(): Given map extent is
invalid.">Warning: MapObj :: SetExtent (): [MapServer
Error]: SetExtent (): Given extent map is invalid. </span><span
title="Check that it is in the form: minx, miny, maxx,
maxy ">Check That it is in the form: minx, miny, maxx,
maxy<br>
</span><span title="in
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php
on line 100 ">in C: \ MS4W \ apps \ geomoose2 \ htdocs
\ php \ feature_report.php on line 100<br>
<br>
</span><span title="Warning: mapObj::setExtent():
[MapServer Error]: msPostGISLayerWhichShapes(): Error
executing query: ERROR: error de sintaxis en o cerca
de «C2BN001» ">Warning: MapObj :: SetExtent ():
[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="^ ">^<br>
</span><span title="in
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php
on line 100 ">in C: \ MS4W \ apps \ geomoose2 \ htdocs
\ php \ feature_report.php on line 100<br>
<br>
</span><span title="Fatal error: Uncaught exception
'MapScriptException' in
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php:100
">Fatal error: Uncaught exception 'MapScriptException'
in C: \ MS4W \ apps \ geomoose2 \ htdocs \ php \
feature_report.php: 100<br>
</span><span title="Stack trace: ">Stack trace:<br>
</span><span title="#0
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php(100):
mapObj->setExtent(0, 0, 0, 0) "># 0 C: \ MS4W \
apps \ geomoose2 \ htdocs \ php \ feature_report.php
(100) mapObj-> SetExtent (0, 0, 0, 0)<br>
</span><span title="#1 {main} "># 1 {main}<br>
</span><span title="thrown in
C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php
on line 100 ">thrown in C: \ MS4W \ apps \ geomoose2 \
htdocs \ php \ feature_report.php on line 100<br>
<br>
</span><span title="¿Alguien puede ayudarme a corregir
el error?"><br>
Can anyone help me fix the error?</span></span> </div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Geomoose-users mailing list
<a moz-do-not-send="true" class="ecxmoz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a moz-do-not-send="true" 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>
</body>
</html>