topic Re: ArcCatalog and sdo_geometry in Data Management Questions

ArcCatalog and sdo_geometry

Ganael_Jatteau — Mon, 25 Jun 2012 07:58:07 GMT

Hello,

I need to load some geometries in an Oracle Locator database 11g using the native format sdo_geometry.

1. Am I able to load some shapefiles using ArcCatalog into sdo_geometry (without an SDE schema)?

2. If 1. is not possible, I might have to use an Oracle tool to load some .shp. What would be the Oracle projection to match the Esri SRID 100200 (WGS84 Web Mercator Auxiliary Sphere) so that I can display the data on a Web client using a query layer?

Thanks in advance,
Ganael

Re: ArcCatalog and sdo_geometry

VinceAngelo — Mon, 25 Jun 2012 12:17:40 GMT

A google on "WGS84 Web Mercator Auxiliary Sphere oracle srid" turned up this.
Note that 100200 isn't an SRID, it's a projection code (Esri's definition of "spatial
reference" is a lot more than just coordinate system).

- V

Re: ArcCatalog and sdo_geometry

JakeSkinner — Mon, 25 Jun 2012 15:45:38 GMT

Hello,

I need to load some geometries in an Oracle Locator database 11g using the native format sdo_geometry.

1. Am I able to load some shapefiles using ArcCatalog into sdo_geometry (without an SDE schema)?

Thanks in advance,
Ganael

Yes, at 10.1 you can load shapefiles into a database just as you could for a geodatabase.

http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=3949

Re: ArcCatalog and sdo_geometry

Ganael_Jatteau — Tue, 26 Jun 2012 09:16:52 GMT

Thanks for the links. I understand using ArcMap 10.1 would solve all the problem so that I don't have to care about the Oracle SRID.

Cheers.