Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Good day sires.

My team is currently working to develop a web-based GIS for a government client and we're using Geoserver 2.1.1 as our server application.

We're trying to play around with Geoserver's GetFeature function to generate a .csv file of the attribute fields of features saved in a PostGIS database. The function below does exactly that:

function generateFeatureTable(feature){ var featureTableURL = "http://localhost:8080/geoserver/prism/wfs?REQUEST=GetFeature&SERVICE=WFS&VERSION=1.1.0&TYPENAME=prism:" + feature + "&OUTPUTFORMAT=csv&SRSNAME=epsg:4326"; window.open(featureTableURL); }

The problem is that the .csv file is also including "the_geom" as one of its fields. If we make use of the PROPERTYNAME argument to specify the fields we like to include in the table, we would have to specify each and every field name excluding that of "the_geom".

Any ideas on how to specify the ones you would NOT want to include in the output file?

We will highly appreciate the insights you can provide us.

share|improve this question
add comment

2 Answers

The WFS protocol does not have a notion of excluding attributes, so no, it's not possible.

share|improve this answer
add comment

It might not help in your situation, but just in case you can make it work...

You can generate a .csv with the PostgreSQL COPY command, retrieving every column by simply naming the table OR passing a SELECT statement instead, specifying the exact columns/records to retrieve.

Hope it helps if you can use it.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.