I am trying to use the WFS interface to extract the data. In my organisation there are a lot of projects, so I want to limit the list. All good, I can use the cql_filter to put in an expression to exclude some projects:
> project_id IN (10359935,10372387,10380347,10381195,10381862,10382142,10649431,10649996,10650455,10652006,10652348,10652594,10655940,10656694,10656755,10656818,10656871,10656968)
This works well for all the layers except my-projects-traps because the project_id field is missing. True the project name is there, but that is subject to user change, illegal characters and spaces that do not go well into a WFS request. Without the field the query crashes with an error message.
Could we please have the project_id exposed in all tables?
Hi Dan,
We have the same problem here with our Geoserver.
For some reason users got the same error message ‘WFSZLibStreamReader::Init() failed.
Bad syntax in request. (status code 400).’ for some layer files, not all. What was your solution to fix this problem? Thanks!
Kind regards
Geert
Flemish Gouverment (Belgium)
In our case, the problem was that the layer was generated from a PostGIS table where the geometry was optional. It appears that Arc can’t deal with NULL geom values. Also, the field could contain multiple lines, so we needed to convert all the lines to multi and explicitly set the attribute type as “MultiLineString” in geoserver.
SELECT ... ST_Multi(line) as geom ... WHERE NOT ST_IsEmpty(line)