[Geomoose-users] Feature Report error with Identify Tool

[Fernando]

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
          
          

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