[mapserver-users] postgis error "geom" deos not exit

Annu Anurag i.skidoosh at gmail.com
Sun Apr 22 12:13:47 PDT 2012


Dear everybody,

                          I've been trying to get a shapefile displayed
from my postgis database on my site. I've somehow been unable to do so. The
site on opening says, "msDrawMap(): Image handling error. Failed to draw
layer named 'Road'. msPostGISLayerWhichShapes(): Query error. Error
executing query: ERROR: column "geom" does not exist LINE 1: select
"name",encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),... ^ ". I set the
debug variables on in my mapfile and it came up with this.

[Sun Apr 22 00:23:48 2012].720775 msPostGISLayerOpen called: geom from
asia_southern_asia_india_delhi_highway
[Sun Apr 22 00:23:48 2012].721115 msPostGISLayerOpen: No connection in
pool, creating a fresh one.
[Sun Apr 22 00:23:48 2012].919149 msConnPoolRegister(Road,user=postgres
password=***************** dbname=delhiroads host=localhost,0x91c6630)
[Sun Apr 22 00:23:48 2012].961144 msPostGISLayerOpen: Got PostGIS version
10500.
[Sun Apr 22 00:23:48 2012].961217 msPostGISLayerFreeItemInfo called.
[Sun Apr 22 00:23:48 2012].961257 msPostGISLayerInitItemInfo called.
[Sun Apr 22 00:23:48 2012].961293 msPostGISLayerWhichShapes called.
[Sun Apr 22 00:23:48 2012].961335 msPostGISParseData called.
[Sun Apr 22 00:23:48 2012].961397 msPostGISRetrievePK called.
[Sun Apr 22 00:23:48 2012].961440 msPostGISRetrievePK: select attname from
pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid =
pg_class.oid and pg_class.oid = pg_attribute.attrelid and
pg_constraint.contype = 'p' and pg_constraint.conkey[1] =
pg_attribute.attnum and pg_class.relname =
'asia_southern_asia_india_delhi_highway' and
pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null
[Sun Apr 22 00:23:48 2012].970777 msPostGISParseData: unique_column=gid,
srid=, geom_column_name=geom,
table_name=asia_southern_asia_india_delhi_highway
[Sun Apr 22 00:23:48 2012].970865 msPostGISBuildSQL called.
[Sun Apr 22 00:23:48 2012].970899 msPostGISBuildSQLItems called.
[Sun Apr 22 00:23:48 2012].970935 msPostGISBuildSQLItems: 1 items requested.
[Sun Apr 22 00:23:48 2012].970966 msPostGISBuildSQLFrom called.
[Sun Apr 22 00:23:48 2012].971015 msPostGISBuildSQLWhere called.
[Sun Apr 22 00:23:48 2012].971045 msPostGISBuildSQLSRID called.
[Sun Apr 22 00:23:48 2012].971076 msPostGISBuildSQLSRID: Building find_srid
line.
[Sun Apr 22 00:23:48 2012].971106 msPostGISBuildSQLSRID: Found table
(asia_southern_asia_india_delhi_highway)
[Sun Apr 22 00:23:48 2012].971140 msPostGISBuildSQLBox called.
[Sun Apr 22 00:23:48 2012].971246 msPostGISLayerWhichShapes query: select
"name",encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),'hex') as geom,"gid"
from asia_southern_asia_india_delhi_highway where geom &&
GeomFromText('POLYGON((76.8164150612777 28.410443,76.8164150612777
28.862691,77.4196089387223 28.862691,77.4196089387223
28.410443,76.8164150612777
28.410443))',find_srid('','asia_southern_asia_india_delhi_highway','geom'))
[Sun Apr 22 00:23:48 2012].974241 msPostGISLayerWhichShapes query status:
PGRES_FATAL_ERROR (7)
[Sun Apr 22 00:23:48 2012].974320 Error (msPostGISLayerWhichShapes()
) executing query: ERROR:  column "geom" does not exist
LINE 1: select "name",encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),...
                                                     ^
[Sun Apr 22 00:23:48 2012].974372 msPostGISLayerWhichShapes(): Query error.
Error executing query: ERROR:  column "geom" does not exist
LINE 1: select "name",encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),...
                                                     ^

[Sun Apr 22 00:23:48 2012].974411 msPostGISLayerFreeItemInfo called.
[Sun Apr 22 00:23:48 2012].974444 msPostGISLayerClose called: geom from
asia_southern_asia_india_delhi_highway
[Sun Apr 22 00:23:48 2012].974478 msConnPoolRelease(Road,user=postgres
password=Christbearers dbname=delhiroads host=localhost,0x91c6630)
[Sun Apr 22 00:23:48 2012].974510 msConnPoolClose(user=postgres
password=Christbearers dbname=delhiroads host=localhost,0x91c6630)
[Sun Apr 22 00:23:48 2012].975210 msDrawMap(): Image handling error. Failed
to draw layer named 'Road'.
[Sun Apr 22 00:23:48 2012].976675 msPostGISLayerClose called: geom from
asia_southern_asia_india_delhi_highway
[Sun Apr 22 00:23:48 2012].977001 freeLayer(): freeing layer at 0x91c8538.
[Sun Apr 22 00:23:48 2012].977060 msPostGISLayerIsOpen called.


An additional detail is that I've recently installed pgrouting onto my
system. I got the deb files for the latest pgrouting package available from
the ubuntu repositories. Its installed with support for driving distance.
When I ran my mapfile which had been running fine using bare shapefiles, I
got an error. Here is the mapfile.


MAP # /////////////////////////////////////////////////////////////MAPFILE
BEGINS.////////////////////////////////////////////////////////////////////////////
    NAME "First"
    CONFIG "MS_ERRORFILE" "/var/www/tmp/ms_error.txt"
    CONFIG "ON_MISSING_DATA" "LOG"
    CONFIG "PROJ_LIB" "/usr/share/proj/"
    CONFIG "PROJ_DEBUG" "ON"
    CONFIG "CPL_DEBUG" "ON"
    SIZE 1024 768
    IMAGECOLOR 239 245 186
    IMAGETYPE PNG
    SHAPEPATH "/var/www/Delhi/"
    FONTSET /var/www/fonts/fontset.txt
    EXTENT 76.898503 28.410443 77.337521 28.862691

         #
        # ///////////////////////////////////////////////////////WEB
CONSTRUCT BEGINS.
///////////////////////////////////////////////////////////////
         #

        WEB
            TEMPLATE "/var/www/roadrefined.html"
            IMAGEPATH "/var/www/tmp/"
            IMAGEURL "/tmp/"
        END #__________________END OF THE WEB
CONSTRUCT._____________________########################################################################

         #
        # //////////////////////////////////////////////////////THE FIRST
LAYER. LAYER THAT DRAWS EVERYTHING. ///////////////////////////////////////
         #

        LAYER
            NAME "Road"
            CONNECTIONTYPE postgis
            CONNECTION "user=postgres password=**************
dbname=delhiroads host=localhost"
            DEBUG 5
            STATUS DEFAULT
            TYPE LINE
            DATA "geom from asia_southern_asia_india_delhi_highway"
            LABELCACHE ON
            LABELITEM "name"

             #
            # //////////////////////////////////////////////////////THE
CLASS THAT CLASSIFIES EVERYTHING IN IT. ////////////////////////////////
             #

            CLASS

                 #
                # /////////////////////////////////////////////////////THE
STYLE OF DRAWING THIS CLASS. ////////////////////////////////////
                 #

                STYLE
                    OUTLINECOLOR 0 123 0
                    COLOR 153 205 205
                END #___END OF THE SYLE DECLARATION FOR THIS
CLASS.___#####################################################################

                 #
                # ////////////////////////////////////////////////////THE
LABEL DISCIPLINE FOR THIS CLASS. ////////////////////////////////
                 #

                LABEL
                    MINFEATURESIZE auto
                    COLOR 0 0 0
                    FONT "arial"
                    TYPE truetype
                    ANGLE follow
                    SIZE 12
                    MINDISTANCE 50
                    REPEATDISTANCE 150
                END #________END OF THE LABEL DISCIPLINE FOR THIS
CLASS.________###########################################################


            END #_________END OF THE CLASS THAT CLASSIFIES
EVERYTHING.___________##############################################################
        END #________END OF THE LAYER THAT DRAWS
EVERYTHING._________##############################################################################
END #_________________________________END OF THE MAPFILE,
ATLAST.___________________________________#######################################################




I'm stuck here for long and my project is stuck too. If anybody has any
clue how to work this one out, please help.

Anurag.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120423/81540f6c/attachment.htm>


More information about the MapServer-users mailing list