Re: [Geoserver-users] WFS layer with "location"

2019-04-10 Thread geseus
Hi, thanks for reply .. so once again without formatting .. Hi, Im using Geoserver and PostGis .. On database i have table "Coordinate" ("Id", "X", "Y", "AddressId", "RootId", ...) I also have materialized view, wich is updated periodically: create materialized view "geoCoordinate" select "

[Geoserver-users] WFS layer with "location"

2019-04-09 Thread geseus
Hi, Im using Geoserver and PostGis .. On database i have table I also have materialized view, wich is updated periodically: If I create a layer /"geoCoordinate-1"/ via /"Configure new SQL view..."/ and use this select: Then, when i check /DescribeFeatureType: http://localhost:8080/geoser

[Geoserver-users] Parametrize DB connection (PostGIS)

2018-11-28 Thread geseus
Hi, is it possible to parametrize values for PostGIS datastore in datastore.xml file (like for eg. app-schemas)? I'm using PostGIS as a database, and would like to have datastore.xml like: test_datastore dbStore ${test.datasource.description} PostGIS true test_workspace

[Geoserver-users] Mapping PostGis geometry to app schema

2017-11-21 Thread geseus
Hi, is it possible to use geometry type from PostGis in app schema? I have view in postgre db: Then i have schema: App schema mapping is defined as: But when a call WFS service, there is empty Geom element in the result: So, how can i map postGis geometry type to element in app schema

[Geoserver-users] WFS nesting

2017-10-29 Thread geseus
files.zip Hi, I'm trying to do wfs with nested elements, but without success. I have 3 postgres tables: person, email, web. I'm able to join them, so output is like: .. person elements email 1 elements