[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_30NProjection: Transverse_MercatorLinear Unit: MeterAnd placing on the extend of southern Spain following: 358836 4186265 359163 4186624MAP    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 72Warning: 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 100Warning: 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 100Fatal error: Uncaught exception 'MapScriptException' in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php:100Stack 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 100It 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
    On 5/28/2015 4:10 AM, Fernando wrote:

    
    
      
      Brent,
            thank you for your replies but how
            can I georeference the building plan correctly
          ? Actually
          we don't need to
          have an real coordinate
            system, that does not
            matter in the project. We start from a DXF
          AutoCAD drawing and
          converted into shapefile
          with ArcTools
          and then import it
          to POSTGIS.
          To display online
          we decided to try
          GeoMOOSE.

        

        How do you think that
          would solve the
            error?

            

            
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/dba87397/attachment-0001.html>