Hallo,
Ik probeer een mapserver met postgis aan de praat te krijgen. Alleen de
configuratie hiervan is mij nog onduidelijk.
LAYER
NAME "Wegen"
TYPE line
STATUS on
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=gis user={gebruikersnaam} password={ww}"
DATA "way from planet_osm_roads"
TRANSPARENCY 30
FILTER "highway = 'secondary'"
CLASS
STYLE
COLOR 128 255 255
OUTLINECOLOR 0 255 0
WIDTH 2
END
END
METADATA
"wms_title" "Wegen"
"wms_srs" "EPSG:28992"
END
PROJECTION
"init=epsg:28992"
END
END
Ik probeer hier alle wegen te vinden welke in de tabel planet_osm_roads,
kolom highway als secondary genoteerd staan.
Vervolgens komt er een foutmelding:
<ServiceExceptionReport version="1.1.1">
<ServiceException>msDrawMap(): Image handling error. Failed to draw
layer named 'Wegen'. prepare_database(): Query error. Error executing
POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY
CURSOR FOR SELECT
asbinary(force_collection(force_2d(way)),'NDR'),OID::text from
planet_osm_roads WHERE (highway = 'secondary') and (way && setSRID(
'BOX3D(119500.416666667 485500.416666667,119999.583333333
485999.583333333)'::BOX3D,find_srid('','planet_osm_roads','way') ))'
Postgresql reports the error as 'ERROR: column "oid" does not exist LINE
1: ...T asbinary(force_collection(force_2d(way)),'NDR'),OID::text ... ^
' More Help: Error with POSTGIS data variable. You specified 'check your
.map file'. Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using
unique column name using SRID=srid#' Make sure you put in the 'using
unique column name' and 'using SRID=#' clauses in. For more help, please
see http://postgis.refractions.net/documentation/ Mappostgis.c - version
of Jan 23/2004.</ServiceException>
</ServiceExceptionReport>
Is er iemand die een idee heeft wat ik fout doe en hoe ik het kan oplossen?
Alvast bedankt.
Peter
_______________________________________________
Talk-nl mailing list
[email protected]
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk-nl
