[Geomoose-users] Feature Report error with Identify Tool

[Jim Klassen]

What is "and (16C2BO010)"?


On 06/01/2015 07:11 AM, Fernando wrote:
> 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: bfraser at geoanalytic.com
> To: nando_gcia at hotmail.com; geomoose-users at lists.osgeo.org
> 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="javascript:GeoMOOSE.startService('feature_report',
>
> {'dxf_text':'[dxf_text]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">
>
>
>           Report </ a>
>           </ td>
>
>         
>
>         but you may want to try:
>
>         
>
>       <Td>
>
>
>           [dxf_text] <a href="javascript:GeoMOOSE.startService('feature_report',
>
> {'gid':'[gid]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">
>
>
>           Report </ a>
>           </ td>
>
>     
>
>     
>
>     Best Regards,
> Brent Fraser
>
>             
>
>             
>
>             _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>           
>           
>
>         
>       
>     
>     
>  		 	   		  
>
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20150601/185cc99b/attachment.html>