The issue here has to do with what you called your geometry column in
the database. If you loaded the data using shp2pgsql and did not specify
a geometry column name then the default is "the_geom" and not "geom"
If you are not sure then check with psql like
psql -U postgres -h localhost delhiroads
\d asia_southern_asia_india_delhi_highway
\q
And look for the column name for the geometry type column. If you used
mixed case names then you need to double quote the column names of the
connection will fold the names to lowercase and you will not find the
column.
-Steve W
On 4/22/2012 3:13 PM, Annu Anurag wrote:
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.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
