Steven,<br><br><br>Dank je wel, ik had inderdaad in de "style" sectie een paar colommen waarop ik selecteerde om de kleur te bepalen van een vlak, en dezen waren in hoofdletters geschreven. Die directe link had ik nog niet gelegd. Het werkt nu.<br>
<br><br>Gert Jan.<br><br><div class="gmail_quote">Op 7 augustus 2009 14:48 schreef Steven Schreuder <span dir="ltr"><<a href="mailto:stevenschreuder@hotmail.com">stevenschreuder@hotmail.com</a>></span> het volgende:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
hoi,<br>ik weet het niet zeker, maar volgens mij heb ik iets vergelijkbaars gehad.<br>in postgis worden alle veldnamen met kleine letters geschreven. dus ik denk dat je ergens in je mapfile veldnamen met hoofdletters hebt geschreven<br>
<br>succes!<br><br>Steven<br><br><br><br><a href="http://www.rugbyopdekaart.nl" target="_blank">http://www.rugbyopdekaart.nl</a><br><br><br><hr>Date: Fri, 7 Aug 2009 14:43:01 +0200<br>From: <a href="mailto:gjk4all@gmail.com" target="_blank">gjk4all@gmail.com</a><br>
To: <a href="mailto:talk-nl@openstreetmap.org" target="_blank">talk-nl@openstreetmap.org</a><br>Subject: [OSM-talk-nl] Problemen met postgis en mapserver<div><div></div><div class="h5"><br><br>Mensen,<br><br><br><br>Ik probeer shapes uit mijn postgis database te toveren met behulp van mapserver, al mijn pogingen stranden echter in een error. De betreffende shapefile werkte als zodanig prima maar nadat ik hem ingelezen had in postgres/postgis met shp2pgsql krijg ik alleen maar de volgende melding:<br>
<br><div style="margin-left: 40px;"><b>Warning</b>: [MapServer Error]: msPostGISLayerWhichShapes(): Error
(ERROR: column "NAAM" does not exist
LINE 1: select "NAAM","WATER",encode(AsBinary(force_collection(force...
^
) executing query: select
"NAAM","WATER",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64')
as geom,"gid" from netherlands_outline where the_geom &&
GeomFromText('POLYGON((-59366.4215654938
306839.000025,-59366.4215654938 614419.099962,350954.421565494
614419.099962,350954.421565494 306839.000025,-59366.4215654938
306839.000025))',find_srid('','netherlands_outline','the_geom')) in <b>/data/public-docroot/test/example3.php</b> on line <b>53</b></div><br>De colommen naam en water bestaan echter wel in de database<br>
<br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;">gis=# \d netherlands_outline</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> Table "public.netherlands_outline"</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Column | Type | Modifiers</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">----------+-----------------------+-------------------------------------------------------------------</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> gid | integer | not null default nextval('netherlands_outline_gid_seq'::regclass)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> naam | character varying(40) |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> water | character varying(1) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> the_geom | geometry |</span><span style="font-family: courier new,monospace;"></span><br></div><br>In mapserver is de boel als volgt gedefinieerd:<br><br><div style="margin-left: 40px;">
<span style="font-family: courier new,monospace;"> LAYER</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> NAME "europa"</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> GROUP "background"</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> STATUS DEFAULT</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> CONNECTIONTYPE POSTGIS</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> CONNECTION "host=localhost dbname=gis user=gis_user password=******** port=5432"</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> DATA "the_geom from netherlands_outline"</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> TYPE POLYGON</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> PROJECTION</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> "init=epsg:28992"</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> END</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> CLASS</span><br> ... boel kleur definities ...<br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> END</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> END</span><br></div><br>Wie kan mij uitleggen wat hier fout gaat en wat ik er aan kan doen? Ik begin net met mapserver/postgis maar heb wel al wat ervaring met ESRI/Oracle. Ik draai de volgende versies:<br>
<br><div style="margin-left: 40px;">cgi-mapserver/unstable uptodate 5.4.2-1<br>mapserver-bin/unstable uptodate 5.4.2-1<br>mapserver-doc/unstable uptodate 5.4.2-1<br>postgresql-8.3/unstable uptodate 8.3.7-3<br>postgresql-8.3-postgis/unstable uptodate 1.3.5-1<br>
postgresql-client-8.3/unstable uptodate 8.3.7-3<br>libpostgis-java/unstable uptodate 1.3.5-1<br>postgis/unstable uptodate 1.3.5-1<br></div><br>Bij voorbaat dank,<br><br><br>Gert Jan Kruizinga.<br><br><br></div></div><div class="hm">
<hr>Express yourself instantly with MSN Messenger! <a href="http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/" target="_blank">MSN Messenger</a></div></div>
<br>_______________________________________________<br>
Talk-nl mailing list<br>
<a href="mailto:Talk-nl@openstreetmap.org">Talk-nl@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/talk-nl" target="_blank">http://lists.openstreetmap.org/listinfo/talk-nl</a><br>
<br></blockquote></div><br>