topic Re: connection of aracle database to arcmap in Data Management Questions

connection of aracle database to arcmap

IndiraKhanal1 — Mon, 01 Jul 2013 22:55:09 GMT

hello...I have been trying to connect oracle databse in to arcmap 10.1. It got connected but while trying to add feature type ( route network file) to the map it says "Coodinate system identifier is invalid". The tables which are not associated with any geometry are displayed but the geometry related files are not showing up. I would really appreciate on any comment and thoughts.

Re: connection of aracle database to arcmap

WilliamCraft — Wed, 03 Jul 2013 02:11:04 GMT

In what spatial data type does your data (route network file) exist inside Oracle (i.e., SDO_GEOMETRY, SDE_LOB, ST_GEOMETRY)?

Are these tables registered with ArcSDE as spatial data (i.e., do they have a geometry column such as a SHAPE field)?

How are you making your connection to Oracle in ArcMap... is it through database connections or are you using a Query Layer?

Re: connection of aracle database to arcmap

IndiraKhanal1 — Wed, 03 Jul 2013 15:31:08 GMT

It is SDO_GEOMETRY type. Yes they have geometry columns and I am using database connections to connect oracle to arcmap.

Re: connection of aracle database to arcmap

WilliamCraft — Wed, 03 Jul 2013 19:30:02 GMT

I can't say for certain, but to me this sounds like an issue with how these tables were registered as layers. More specifically, I am thinking that the SRID used during the layer registration is not one that ArcSDE recongnizes or interprets correctly. How did these tables get registered with SDE... was it via SDE command line or some other method? Try performing a describe_long on one of the tables to see what the SRID value is. You can also see if the spatial column is set correctly and what the coordinate system attribute comes back with. Here's an example output:

ArcSDE 9.3.1 for Oracle11g Build 3056 Fri Sep 10 09:41:17 2010

Layer   Administration Utility

-----------------------------------------------------

Layer Description ....: <None>

Table Owner ..........: LA

Table Name ...........: BUILDING_PY

Spatial Column .......: SHAPE

Layer Id .............: 476

SRID .................: 34

Minimum Shape Id .....: 1

Offset ...............:

falsex: -124791099.998718

falsey: -91255499.999136

System Units .........:       3906.249996

Z Offset..............:          0.000000

Z Units ..............:          1.000000

Measure Offset .......: <None>

Measure Units ........: <None>

XY Cluster Tolerance .:          0.008192000008

Spatial Index ........:

parameter:    SPIDX_GRID,GRID0=2000,GRID1=6000,FULL

exist:        Yes

array form:   2000,6000,0

Layer Envelope .......:

minx:   2643628.63990, miny:    483129.61769

maxx:   3710047.75462, maxy:   1457660.51806

Entities .............: nac+

Layer Type ...........: SDE-LOB

Creation Date ........: 07/07/11 14:02:02

I/O Mode .............: NORMAL

Autolocking ..........: Enabled

Precision.............: High

User Privileges ......: SELECT, UPDATE, INSERT, DELETE

Coordinate System ....: PROJCS["NAD_1983_StatePlane_Louisiana_South_FIPS_1702_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",3280833.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-91.33333333333333],PARAMETER["Standard_Parallel_1",29.3],PARAMETER["Standard_Parallel_2",30.7],PARAMETER["Latitude_Of_Origin",28.5],UNIT["Foot_US",0.3048006096012192]]

Layer Configuration ..: DEFAULTS

Re: connection of aracle database to arcmap

VinceAngelo — Wed, 03 Jul 2013 22:17:39 GMT

I'm wondering if they were registered at all. Query Layers don't require
pre-registration, but Enterprise Geodatabase (ArcSDE) feature classes do.

- V