[Geoserver-users] Publish PostGIS data without Geometry

GeoServer GeoServer User
1

Hi there,

I'm using PostGIS as my data store and geoserver to access the data.

In my PostGIS structure are different tables, some with geoinformation, but some without as well (relationships, tags, etc).
I want to access all the data in a web-application via services. For geodata i'm using wfs-t, but the question is, how to access the normal data in a clean json representation.

Is there an option, to publish a postgis table via geoserver in a simple not feature-type way?

Thanks, Richard

2

Richard,

if you configure a layer with a fake bounding box and a fake CRS (e.g EPSG:4326), GeoServer WFS should happily serve all your non-spatial data. You can to obtain JSON with WFS using outputformat=json and all the usual GeoServer WFS property filtering. Features are just rows in your source table. JSONP is also supported but disabled by default.

Types without geometries will not work with WMS, but that is expected.

Kind regards,
Ben.

On 17/06/15 18:20, Bischof, Richard wrote:

Hi there,

I'm using PostGIS as my data store and geoserver to access the data.

In my PostGIS structure are different tables, some with geoinformation, but some without as well (relationships, tags, etc).
I want to access all the data in a web-application via services. For geodata i'm using wfs-t, but the question is, how to access the normal data in a clean json representation.

Is there an option, to publish a postgis table via geoserver in a simple not feature-type way?

Thanks, Richard

------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand

3

On 17/06/15 18:20, Bischof, Richard wrote:

Hi there,

I'm using PostGIS as my data store and geoserver to access the data.

In my PostGIS structure are different tables, some with geoinformation, but some without as well (relationships, tags, etc).
I want to access all the data in a web-application via services. For geodata i'm using wfs-t, but the question is, how to access the normal data in a clean json representation.

Is there an option, to publish a postgis table via geoserver in a simple not feature-type way?

Thanks, Richard

Hello Richard
I don't think GeoServer is the right tools to provide a REST API for
your tables.
You could expose your tables with a web framework such as Django or
Flask or others
regards
p

--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti