GeoNodeUserGroup-DE / geonode-dev-datapackage

Datapackage development setup based on Docker Blueprint for GeoNode
0 stars 0 forks source link

Downloading table data via the GeoNode download interface #4

Closed ridoo closed 3 weeks ago

ridoo commented 3 months ago

Downloading table data via the GeoNode download interface: It should be possible to download table data for a dataset in various formats via the normal GeoNode download interface. If a format is not supported for any reason, it should be removed from the list of possible downloads.

ridoo commented 2 months ago
ridoo commented 2 months ago

@mwallschlaeger @specka Downloading tabular data via UI has been reviewed. Now, CSV and excel formats are supported:

Image

If this fits your requirements, feel free to close or comment.

mwallschlaeger commented 2 months ago

@specka from my side CSV and excel are just fine for tabular data.

specka commented 2 months ago

sometimes, people also have "txt" files with tabular data; so similar to csv files, but with a different file ending. So far in the con terra repo we also provide txt files, so this should be also possible with GeoNode. The names of the formats should be improved (excel small, CSV Capital letters), its confusing and not homogeneous.

ridoo commented 2 months ago
ridoo commented 2 months ago

WFS supports the following formats:

<ows:Parameter name="outputFormat">
    <ows:AllowedValues>
        <ows:Value>application/gml+xml; version=3.2</ows:Value>
        <ows:Value>GML2</ows:Value>
        <ows:Value>KML</ows:Value>
        <ows:Value>SHAPE-ZIP</ows:Value>
        <ows:Value>application/json</ows:Value>
        <ows:Value>application/vnd.google-earth.kml xml</ows:Value>
        <ows:Value>application/vnd.google-earth.kml+xml</ows:Value>
        <ows:Value>csv</ows:Value>
        <ows:Value>excel</ows:Value>
        <ows:Value>excel2007</ows:Value>
        <ows:Value>gml3</ows:Value>
        <ows:Value>gml32</ows:Value>
        <ows:Value>json</ows:Value>
        <ows:Value>text/csv</ows:Value>
        <ows:Value>text/xml; subtype=gml/2.1.2</ows:Value>
        <ows:Value>text/xml; subtype=gml/3.1.1</ows:Value>
        <ows:Value>text/xml; subtype=gml/3.2</ows:Value>
    </ows:AllowedValues>
</ows:Parameter>

The most similar format to text is text/csv which is provided via CSV option. I would leave it as is and close the issue then. @specka @mwallschlaeger feel free to re-open anytime.

mwallschlaeger commented 1 month ago

hi I tried to download tabular data in excel and csv format and run into the following issue:

Image

ridoo commented 3 weeks ago

This is really weird as it worked without a problem before .. have to investigate this regression issue. Seems that url of the map layer config is not set (anymore?) fo tabular datasets.

ridoo commented 3 weeks ago

Handled regression after removing WMS specifics for tabular datasets.