AnsweredAssumed Answered

Manual data registration with ArcSDE probelms

Question asked by geonetadmin on Apr 29, 2010
Latest reply on May 10, 2010 by geonetadmin
Original User: gstaats

I am experiencing problems registering data with ArcSDE. I have a table with SDO_Geometry that is being registered with ArcSDE, but no geometry is being displayed in ArcCatalog or ArcMap. I can view the attribute table, but not geometry. There are no errors while trying to view the geometry - nothing is rendered. Any Ideas? Here is my table schema:

CREATE TABLE LRS (
LRS_SPATIAL_ID NUMBER(10,0),
NLF_ID VARCHAR2(14),
DISTRICT_NBR NUMBER(10,0),
JURISDICTION_CD VARCHAR2(1),
TRANS_ROUTE_CD VARCHAR2(2),
COUNTY_ABREV3_CD VARCHAR2(3),
CTL_BEGIN_NBR FLOAT,
CTL_END_NBR FLOAT,
LEAVE_CD VARCHAR2(1),
REENTER_CD VARCHAR2(1),
ROAD_STATUS VARCHAR2(1),
TRANSACTION_CD VARCHAR2(1),
GEOMETRY MDSYS.SDO_GEOMETRY, primary key (LRS_SPATIAL_ID) )

LRS_SPATIAL_ID is the PK and being used as the ObjectID. The data is in Ohio State Plane South '83, units of meters. The data only contains lines and the table has a single geometry column. Is there somethings that  Iam doing wrong? Thanks.

Below if the command I used to register the data.

sdelayer -o register -l LRS,GEOMETRY -u user -p password -P High   -e sl -t SDO_GEOMETRY -C  LR
S_SPATIAL_ID,SDE  -G 32123 -x 0,0,10000

Attachments

Outcomes