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.
My create table statement :
CREATE TABLE sde.forestry
(
objectid integer NOT NULL,
forestryid smallint NOT NULL,
"name" character varying(30),
area integer,
district character varying(30),
shape st_geometry
)
P.S. : I'm sorry for my awful english :)
P.S.S. : i understand, that its not normal and more easy way to create view
in DB with all requirments, but may be it is possible to show by methods of
geoserver?
------------------------------------------------------------------------------
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
