环境:windows 2003 Server
ArcSDE 9.3
----------------------------ArcSDE注册语法-----------------------
sdelayer -o register -l gis230000000000.st_asj_pt,shape -e p -C objectid,sde -u gis230000000000 -p gis230000000000 -t ST_GEOMETRY -r 0
-l 注册表名与空间列名
-e 注册要素类型
p point
l line
a poylone
p+ 多点
l+ 多线
a+ 多面
-C 主键列名及管理主键的用户
-u 注册用户名
-p 注册密码
-t 注册类型
删除指定图层,但非删除表
sdelayer -o delete -l aa_1,shape -u test -p test;
查询某个图层的Owner,Layer id,用户可以操作的权限
远端注册
sdelayer -o register -l giswell,shape -e l+ -C ID,USER -t st_geometry -u user -p pwd -i sde:oracle10g:/;local=local_tnsname -r rsid
---------------------------向图层表添加数据-----------------------
select registration_id from sde.table_registry where table_name='ST_KK_PT' and owner='GIS230000000000';--343
insert into st_kk_pt(objectid,
mc, jd, wd, bh, sszzjgdm, fldm, gxsj, shape
)
select
sde.version_user_ddl.next_row_id('GIS230000000000',343),
mc,
ltrim(rtrim(jd)) jd,
ltrim(rtrim(wd)) wd,
bh,
sszzjgdm,
'' fldm,
sysdate gxsj,
sde.st_pointfromtext('point('||ltrim(rtrim(jd))||' '||ltrim(rtrim(wd))||')', 4) shape
--sde.st_pointfromtext('point(125 45)', 4)
--SDE.St_Linefromtext('linestring(126.47426 35,127.47426 36)', 5)
--SDE.St_Polygon('polygon((126.47426 35,127.47426 36,128.47426 38,126.47426 35))', 4)
from JX_KK_PT@JX_PGIS
where mc NOT LIKE '长青卡口%'
---------------------------清除图层表垃圾数据--------------------
CREATE OR REPLACE PROCEDURE del_sde_tab(tableName IN VARCHAR2) AS
BEGIN
DELETE FROM sde.gdb_objectclasses t WHERE t.name=UPPER(tableName);
DELETE FROM sde.geometry_columns t WHERE t.f_table_name=UPPER(tablename);
DELETE FROM sde.geometry_columns t WHERE t.g_table_name=UPPER(tablename);
DELETE FROM sde.gdb_usermetadata t WHERE t.name=UPPER(tablename);
DELETE FROM sde.layers t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.st_geometry_index t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.table_registry t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.column_registry t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.gdb_featuredataset t WHERE t.name=UPPER(tablename);
DELETE FROM sde.all_st_geometry_columns_v t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.st_geometry_columns t WHERE t.table_name=UPPER(tablename);
END;
ArcSDE 9.3
----------------------------ArcSDE注册语法-----------------------
sdelayer -o register -l gis230000000000.st_asj_pt,shape -e p -C objectid,sde -u gis230000000000 -p gis230000000000 -t ST_GEOMETRY -r 0
-l 注册表名与空间列名
-e 注册要素类型
p point
l line
a poylone
p+ 多点
l+ 多线
a+ 多面
-C 主键列名及管理主键的用户
-u 注册用户名
-p 注册密码
-t 注册类型
删除指定图层,但非删除表
sdelayer -o delete -l aa_1,shape -u test -p test;
查询某个图层的Owner,Layer id,用户可以操作的权限
远端注册
sdelayer -o register -l giswell,shape -e l+ -C ID,USER -t st_geometry -u user -p pwd -i sde:oracle10g:/;local=local_tnsname -r rsid
---------------------------向图层表添加数据-----------------------
select registration_id from sde.table_registry where table_name='ST_KK_PT' and owner='GIS230000000000';--343
insert into st_kk_pt(objectid,
mc, jd, wd, bh, sszzjgdm, fldm, gxsj, shape
)
select
sde.version_user_ddl.next_row_id('GIS230000000000',343),
mc,
ltrim(rtrim(jd)) jd,
ltrim(rtrim(wd)) wd,
bh,
sszzjgdm,
'' fldm,
sysdate gxsj,
sde.st_pointfromtext('point('||ltrim(rtrim(jd))||' '||ltrim(rtrim(wd))||')', 4) shape
--sde.st_pointfromtext('point(125 45)', 4)
--SDE.St_Linefromtext('linestring(126.47426 35,127.47426 36)', 5)
--SDE.St_Polygon('polygon((126.47426 35,127.47426 36,128.47426 38,126.47426 35))', 4)
from JX_KK_PT@JX_PGIS
where mc NOT LIKE '长青卡口%'
---------------------------清除图层表垃圾数据--------------------
CREATE OR REPLACE PROCEDURE del_sde_tab(tableName IN VARCHAR2) AS
BEGIN
DELETE FROM sde.gdb_objectclasses t WHERE t.name=UPPER(tableName);
DELETE FROM sde.geometry_columns t WHERE t.f_table_name=UPPER(tablename);
DELETE FROM sde.geometry_columns t WHERE t.g_table_name=UPPER(tablename);
DELETE FROM sde.gdb_usermetadata t WHERE t.name=UPPER(tablename);
DELETE FROM sde.layers t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.st_geometry_index t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.table_registry t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.column_registry t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.gdb_featuredataset t WHERE t.name=UPPER(tablename);
DELETE FROM sde.all_st_geometry_columns_v t WHERE t.table_name=UPPER(tablename);
DELETE FROM sde.st_geometry_columns t WHERE t.table_name=UPPER(tablename);
END;