[空间数据库操作.ppt

空间数据库操作 武汉大学 测绘学院 中国南极测绘研究中心 连接数据库的基本参数 Oracle Net Service Name/SID TCP/IP Host Name(IP) and Port User and Password Oracle9i\network\admin\tnsnames.ora POLARDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 36)(PORT = 1521)) ) (CONNECT_DATA = (SID = polardb) (SERVER = DEDICATED) ) ) Table Roads 河流表 River create table rivers(rname varchar2(64),geometry mdsys.sdo_geometry); insert into user_sdo_geom_metadata values( rivers,geometry,mdsys.sdo_dim_array(mdsys.sdo_dim_element(X,0,100,0.05),mdsys.sdo_dim_element(Y,0,100,0.05)),8307); create index rivers_spatial_idx on rivers(geometry) indextype is mdsys.spatial_index; insert into rivers(rname,geometry) values(Yangtze River,mdsys.sdo_geometry(2002,8307,null,mdsys.sdo_elem_info_array(1,2,1),mdsys.sdo_ordinate_array(8,8,9,10,15,15))); Table River 空间示意图 空间位置的拓扑关系 TOUCH, OVERLAPBDYDISJOINT, OVERLAPBDYINTERSECT, EQUAL, INSIDE, COVEREDBY, CONTAINS, COVERS, ANYINTERACT, ON. VC读写Oracle数据库 OO4O介绍 准备： 首先要安装Oralce数据库客户端， 并安装了本地Oracle数据库 或者有远程数据库服务 已知用户名称和用户密码 7/polardb gis/gis2006 利用VC向导创建 OO4O实战 VC代码实例 PHP操作Oracle数据库 前提：安装PHP以及Oracle连接模块 oci_connect() Oci_parse() Oci_excute() Oci_fetch() Oci_close() 实习（任选一题）: OO4O编写一段代码，实现空间数据字段的创建、录入、更新、查询功能 PHP编写一段代码，实现空间数据字段的创建、录入、更新、查询功能 The End 谢 谢 Oracle数据库支持 空间拓扑关系 DISJOINT DISJOINT 没有任何关系 TOUCH TOUCH 边界相交但区域无关 OVERLAPBDYDISJOINT OVERLAPBDYDISJOINT 区域相交但边界不相关，比如： OVERLAPBDYINTERSECT OVERLAPBDYINTERSECT 边界和区域都相交 ANYINTERACT ANYINTERACT 任意相关 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Sl