Yes, you can have different layers using different geometry
types in a single SDE instance.
cheers,
Chris
----- Original Message ----- From: "Freeman, Aleda (EEA)" <Aleda.Freeman@anonymised.com>
To: "'Chris Morgan'" <chris@anonymised.com>
Cc: <geoserver-users@lists.sourceforge.net>
Sent: Tuesday, July 06, 2010 2:14 PM
Subject: RE: [Geoserver-users] Does GeoServer support SDE's ST_GEOMETRY?
OK, that's good I think. We're not looking to get rid of SDE, only use a
different underlying geometry type next time.
I guess I should probably try to set up a test layer and make sure GeoServer
can access it.
I wonder if we can mix geometry types in one SDE instance. I'll check with
our SDE administrator.
I'll let you know how it works out.
Aleda Freeman, GISP, Web Mapping Services Manager
MassGIS
Information Technology Division
251 Causeway St. 5th floor
Boston, MA 02114
phone: 617-626-1193
fax: 617-626-1249
http://www.mass.gov/mgis - MassGIS
http://lyceum.massgis.state.ma.us - Webservices Wiki
MassGIS is the Commonwealth's Office of Geographic Information
A Technology and Data Resource for GIS Users in the Commonwealth
-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Chris
Morgan
Sent: Monday, July 05, 2010 12:22 PM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Does GeoServer support SDE's ST_GEOMETRY?
That's not quite right as I understand it.
If you use SDE as your Geoserver source, then ST_GEOMETRY will be implicitly
supported, along with the other formats that SDE supports.
But (at present), you cannot dispense with the intermediary SDE layer for
access by Geoserver.
Whereas if you use Oracle's SDO_GEOMETRY type, you don't need SDE at all.
Presumably someone could create an ESRI ST_GEOMETRY data store for
Geoserver, but at present, there isn't one.
cheers,
Chris
----- Original Message -----
From: "Gabriel Roldan" <groldan@anonymised.com>
To: "Freeman, Aleda (EEA)" <Aleda.Freeman@anonymised.com>
Cc: "'Chris Morgan'" <chris@anonymised.com>;
<geoserver-users@lists.sourceforge.net>
Sent: Monday, July 05, 2010 5:10 PM
Subject: Re: [Geoserver-users] Does GeoServer support SDE's ST_GEOMETRY?
Hi Aleda,
my understanding is the ST_GEOMETRY should be supported out of the
box. It is just one of the underlying geometry storage formats ESRI
supports, but it's transparent for the client API.
Cheers,
Gabriel.
On 7/2/10 6:30 PM, Freeman, Aleda (EEA) wrote:
Well... I've been reading...
This page:
http://argyron.limnology.wisc.edu:8099/arcgismanager/help/index.htm#g
eodatabases/an_over1698501291.htm
says that the
ArcSDE Spatial Type ST_Geometry
* Utilizes the ArcSDE extended spatial type for managing vector data
* Supports the ISO and OGC SQL API for spatial
* Based on the ISO SQL MM specification for spatial
Aleda Freeman, GISP, Web Mapping Services Manager MassGIS Information
Technology Division
251 Causeway St. 5th floor
Boston, MA 02114
phone: 617-626-1193
fax: 617-626-1249
http://www.mass.gov/mgis - MassGIS
http://lyceum.massgis.state.ma.us/>
- Webservices Wiki MassGIS is the Commonwealth's Office of Geographic
Information A Technology and Data Resource for GIS Users in the
Commonwealth
________________________________
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of
Chris Morgan
Sent: Friday, July 02, 2010 5:04 PM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Does GeoServer support SDE's ST_GEOMETRY?
ST_GEOMETRY is an ESRI format - not sure if it is standards-compliant.
We use Oracle's SDO_GEOMETRY type - seems to work OK with both SDE
and Geoserver, and you have the advantage of using SQL for data
loading and querying if you want.
cheers,
Chris
---- Original Message ----
From: "Freeman, Aleda (EEA)"<Aleda.Freeman@anonymised.com>
To:
"geoserver-users@lists.sourceforge.net"<geoserver-users@anonymised.com
orge.net>
Sent: Fri, Jul 2, 2010, 21:37 PM
Subject: [Geoserver-users] Does GeoServer support SDE's ST_GEOMETRY?
We are currently using ESRI SDE with the BLOB geometry. (SDE 9.2 on
Oracle 10.2).
(Actually my data librarian clarifies: BLOB is what is used mostly
for geometry storage. A few keywords (like USERS) use SDELOB (a
newer term than BLOB).)
We are planning to put SDE 10 (and Oracle 11) on a brand new server
and load it up with data.
My boss is now interested in ST_GEOMETRY (I guess it has advantages
such as SQL access).
http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/
the_st_g432914457.htm
http://webhelp.esri.com/arcgisserver/9.3/java/geodatabases/st_geom-27
0510096.htm
I looked around in GeoServer and GeoTools documentation but I
couldn't find an answer to the question:
Does GeoServer support ST_GEOMETRY for SDE? Or will it in the near
future?
Aleda Freeman, GISP, Web Mapping Services Manager MassGIS Information
Technology Division
251 Causeway St. 5th floor
Boston, MA 02114
phone: 617-626-1193
fax: 617-626-1249
http://www.mass.gov/mgis - MassGIS
http://lyceum.massgis.state.ma.us - Webservices Wiki MassGIS is the
Commonwealth's Office of Geographic Information A Technology and Data
Resource for GIS Users in the Commonwealth
------------------------------------------------------------
Incoming and outgoing emails are checked for viruses by Sophos
AntiVirus.
This email may contain confidential information which is intended for
the named recipient(s) only. If you are not the named recipient you
should not take any action in relation to this email, other than to
notify us that you have received it in error.
Lynx Information Systems Ltd
93-99 Upper Richmond Rd
London SW15 2TG
United Kingdom
Web: http://www.lynxinfo.co.uk
Email: lynx@anonymised.com
Tel: +44 (0)20 8780 2634
Fax: +44 (0)20 8780 0931
Registered in England Number 2454130
VAT Number GB 561 8979 88
------------------------------------------------------------
--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------
Incoming and outgoing emails are checked for viruses by Sophos AntiVirus.
This email may contain confidential information which is intended for the
named recipient(s) only. If you are not the named recipient you should not
take any action in relation to this email, other than to notify us that you
have received it in error.
Lynx Information Systems Ltd
93-99 Upper Richmond Rd
London SW15 2TG
United Kingdom
Web: http://www.lynxinfo.co.uk
Email: lynx@anonymised.com
Tel: +44 (0)20 8780 2634
Fax: +44 (0)20 8780 0931
Registered in England Number 2454130
VAT Number GB 561 8979 88
------------------------------------------------------------
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint What will you do first with EVO,
the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------
Incoming and outgoing emails are checked for viruses
by Sophos AntiVirus.
This email may contain confidential information which is
intended for the named recipient(s) only. If you are
not the named recipient you should not take any action in
relation to this email, other than to notify us that you
have received it in error.
Lynx Information Systems Ltd
93-99 Upper Richmond Rd
London SW15 2TG
United Kingdom
Web: http://www.lynxinfo.co.uk
Email: lynx@anonymised.com
Tel: +44 (0)20 8780 2634
Fax: +44 (0)20 8780 0931
Registered in England Number 2454130
VAT Number GB 561 8979 88
------------------------------------------------------------