Hello everyone.
I’m trying to access a geographical SpatiaLite view layer from GeoServer 2.5.2 with SpatiaLite extension installed. The problem is that GeoServer does not recognize this view as a layer, although there is a record in the table views_geometry_columns that indicates it. I can add the layer, but the field that contains the geometry appears as String (instead of Polygon), and GeoServer does not draw anything.
However, if I add a record in the table geometry_columns, GeoServer correctly identifies as polygon type column that stores the geometry and draws the features of the view, though it is not a table but a view. In my case, I can only add a record to the view views_geometry_columns and not to table geometry_columns, so I’m not worth this solution.
I am using a version of SpatiaLite (2.4) that recognices this data model in which the spatial information is included in the view views_geometry_columns view and not in the geometry_columns table. I have read tha SpatiaLite version included in this GeoServer extension is 2.4.0. Tthis version alreday implements this data model for storing geographic views. It seems as if the extension for reading SpatiaLite does not understand the model of tables and views to store SpatiaLite geographical views.
Any ideas?
Thanks in advance
Un saludo
/FIRMA%20OUTLOOK/Tragsatec.png){kind=small}
/FIRMA%20OUTLOOK/cenefa.png){kind=small}
Pedro Briones Garcia
Jefe de Grupo de Actuaciones y Proyectos
Gerencia de Sistemas de Información Geográfica
Grupo Tragsa - SEPI
/FIRMA%20OUTLOOK/Tragsatec_SEPI.png){kind=small}
Calle Julián Camarillo 6 B - 28037 Madrid
Tel.: 913226489 - 88216 - Fax: 913226005
pbg@anonymised.com www.tragsa.es
En beneficio del medio ambiente, imprime este e-mail sólo si realmente es necesario
For the benefit of the environment, print this e-mail only if you really need
********************************************************************************************** El consumo de papel es perjudicial para el medio ambiente. Por favor, téngalo en cuenta antes de imprimir este mensaje. AVISO LEGAL: Este mensaje y sus anexos pueden contener información confidencial o legalmente protegida. Está dirigido únicamente a la persona o entidad indicada como destinatarios del mensaje. Si este mensaje le hubiera llegado por error, por favor elimínelo sin revisarlo ni reenviarlo y notifíquelo inmediatamente al remitente. **********************************************************************************************