课
程
程
资
讯
讯
综
合
合
--2.插入METADATA属性数据
INSERT INTO USER_SDO_GEOM_METADATA
VALUES(
'DEV_TOWER_ACTL',
'location',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X',-180,180,0.0011119487),
MDSYS.SDO_DIM_ELEMENT('Y',-90,90,0.0011119487)
),
8307
);
--3.创建空间索引
CREATE INDEX IDX_SPATIAL_Dev_Acrossbox
ON Dev_Acrossbox (location)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
--4.执行PL/SQL
----线
declare
v_type MAPINFO_MAPCATALOG%rowtype;
begin
select * into v_type from mapinfo_mapcatalog m where m.tablename='LINE_INFO' and m.ownername='POSTGIS' ;
v_type.tablename:=&new_tableName;
insert into MAPINFO_MAPCATALOG values v_type ;
commit;
dbms_output.put_line(v_type.tablename);
end;
--点
declare
v_type MAPINFO_MAPCATALOG%rowtype;
begin
select * into v_type from mapinfo_mapcatalog m where m.tablename='DEV_TRANSTATION' and m.ownername='POSTGIS' ;
v_type.tablename:=&new_tableName;
insert into MAPINFO_MAPCATALOG values v_type ;
commit;
dbms_output.put_line(v_type.tablename);
end;
注：第四步中，具体的样例数据可以通过easyloader上传点和直线来取得。上传后，会自动的插入的到mapinfo.mapinfo_mapcatalog表中。
| 广告合作：400-664-0084 全国热线：400-664-0084 Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号 珠峰网 版权所有 All Rights Reserved 
|
