[Geoserver-users] Problems creating a Geoserver Layer on a PostGIS View

Hi,

I can't see any content in my mail after your titles:

I created the view with:

and psql shows a correct geometry column in that view:

dkuenzel wrote:

Hello,

I am trying to create a WFS Layer on a Database view which contains a Geometry field but something doesn't seem to work out correctly:
- Loading the Table or View via direct DB-Connection into Qgis works, all Points are displayed on the map.
- Creating a Geoserver Layer on the original Table works, the layer can be displayed in Qgis.
- Creating a Geoserver Layer on the View works, but there seems to be an issue with the Geometry. Loading the Layer into Qgis works and the attribute table contains data but the points can't be displayed.

I created the view with:

and psql shows a correct geometry column in that view:

Now when I create a layer in the Geoserver WebUI I get the following

results:
<http://osgeo-org.1560.x6.nabble.com/file/n5194895/point_fails.png&gt;
In comparison to the original Table:
<http://osgeo-org.1560.x6.nabble.com/file/n5194895/point_works.png&gt;

I really tried to figure out what the problem is, but I even fail to limit the source of it. On the one hand the View seems to be fully functional as I can open and display it via direct DB-Connection, I don't see any differences between the Geometry fields in the original table and the view.

On the other hand Geoserver seems to notice a difference which is the source of the problem.

I would be really pleased if anyone got an idea on this, because I am totally lost here...

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problems-creating-a-Geoserver-Layer-on-a-PostGIS-View-tp5194895.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users