On Mon, Nov 21, 2011 at 2:40 AM, Борис Нариманович Карпов <[email protected]> wrote: > Hello! I have trouble with geoserver and arcgis soft. > My situation : i have ms sql database with features made in arcdesktop > (9.3). I import data to spatial postgis database. After that transform i > have a lot of tables, i can watch images in arccatalog (and it's correct!), > but my postgis base has no tables named geometry_columns and > spatial_sys_ref. I want to show my tables on web page using geoserver. When > i tried to publish layer, native srs was not detected, so i can't choose > force declared or reproject from native or keep native srs (geoserver > doesn't compute bounds). My collection of tables schematicly look like this > http://help.arcgis.com/en/arcgisdesktop/10.0/help/002q/pdf/sdesystables_diagram.pdf . > Is it really "to explain" to Geoserver, that information about srs is > storing in another tables without adding geometry_columns and > spatial_sys_ref tables and and direct declaration of srid field? I'm using > Geoserver 2.1-RC2.
There is no such a thing, metadata must be declared in the postgis way. A support to look in other tables, if ESRI has any standard metadata structure, could be developed and added to the PostGisDialect class though: http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis/PostGISDialect.java See the getGeometrySRID method Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
