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
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
You don't say what version of ArcSDE you are using, but ArcSDE has
had sufficient problems with primary keys over the years that it is
probably your issue. This is especially true if you make the registered
rowid column SDE-set *and* a primary key.
Try creating the table *without* the PK, registering it, then if you choose
to use a USER-set rowid, adding a primary key post-registration.
- V