[mapserver-users] UMN + Postsgis, features skipped

[Andreas Neumann]

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 <a.neumann at carto.net>:
>>>> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>


-- 
Andreas Neumann
http://www.carto.net/neumann/
http://www.svgopen.org/