Thanks for the hint, Jeff! Andreas
On Mon, July 12, 2010 3:45 pm, Jeff McKenna wrote: > For the record, when I hit this wall, I always view what features are > returned by using the ogrinfo commandline utility (and therefore cutting > out the possibilities of problems specific to MapServer). In this case > you can pass expressions through the '-sql' switch in ogrinfo: > > > ogrinfo PG:"host=127.0.0.1 user=postgres password=postgres > dbname=canada port=5432" -sql "select blah from blah where blah=blah" > > Happy mapserving. > > -jeff > > > -- > Jeff McKenna > MapServer Consulting and Training Services > http://www.gatewaygeomatics.com/ > > > > > Andreas Neumann wrote: >> ok - the problem is solved. >> >> The source table was a view and it turned out that some fields had an >> invisible line break at the end of the string and therefore did not >> match >> with the expression. In the table they visually looked the same, but one >> did not immediately see the line break at the end ... >> >> All fine now and sorry for the fuss ... >> >> Thanks for trying to help! >> Andreas >> >> On Mon, July 12, 2010 3:31 pm, Michael Schulz wrote: >>> Hi Andreas, >>> >>> could you try the map-file with the layer EXTENT removed and see if >>> that improves the situation? I seem to remember having a similar >>> problem, with the layer extent parameter, that is generated by the >>> QGIS mapfile exporter. >>> >>> Cheers, Michael >>> >>> >>> 2010/7/12 Andreas Neumann <[email protected]>: >>>> Hi all, >>>> >>>> I have troubles with the UMN/Postgis combo. When I just draw the layer >>>> with a single class, it draws fine, but as soon as I use >>>> classification >>>> with an EXPRESSION (simple string comparison), a lot of features are >>>> skipped. >>>> >>>> Attached I am sending a mapfile with just one class (buildings from a >>>> landcover table). Most buildings are skipped, only a few are drawn. >>>> >>>> I have no idea why. >>>> >>>> The same table draws fine without problems in QGIS. >>>> >>>> Any idea why the classification is skipping many features? >>>> >>>> Thanks a lot, >>>> Andreas >>>> >>>> -- >>>> Andreas Neumann >>>> http://www.carto.net/neumann/ >>>> http://www.svgopen.org/ > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
