1 / 24

Oracle Location based services Spatial and Oracle Locator

Oracle Location based services Spatial and Oracle Locator. Srinivas Gudelli CIS 764 Fall 2008. Overview. What is Oracle Spatial and Oracle Locator? Spatial information systems (Ex: GIS) GIS vs. Oracle Spatial? History and architecture Data loading-examples Advantages Summary Questions.

fuller
Download Presentation

Oracle Location based services Spatial and Oracle Locator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Location based servicesSpatial and Oracle Locator Srinivas Gudelli CIS 764 Fall 2008

  2. Overview • What is Oracle Spatial and Oracle Locator? • Spatial information systems (Ex: GIS) • GIS vs. Oracle Spatial? • History and architecture • Data loading-examples • Advantages • Summary • Questions

  3. What is Oracle Spatial and Oracle Locator? • Oracle Spatial and Oracle Locator, is a feature in Oracle database that stores location applications. • Oracle locator-Standard and Enterprise Editions that provides core location functionality. • Oracle Spatial is an option for Oracle Enterprise Edition that provides advanced spatial features to support high-end GIS and Location Based System solutions.

  4. Oracle Locator do Oracle Spatial do =Locator + ... • Geometric Transformations • Spatial Aggregations • Network Modeling • Topology • Raster • Geocoder • Spatial Data Mining • 3D Types (LIDAR, TINS) • Web Services (WFS, CSW, OpenLS) • All geometric objects • – Points, lines, polygons • – 2D, 3D, 4D • Indexing (quadtrees and r-trees) • Spatial queries • Proximity queries • Distances • Projections

  5. Spatial information systems (Ex. GIS) • Geographic Information Systems (GIS) integrates hardware, software, and data for capturing, managing, analyzing, and displaying all forms of geographically referenced information. • Evolution mainly from government, then started development from commercial software vendors. • Enterprise GIS offers tools to share and view the spatial data through internet.

  6. Geographic Information Systems • Stores attributes, raster images, vector data • Have capability to provide business logics such as relationships, domain values, networks, subtypes

  7. GIS vs. Oracle Spatial • GIS is stand-alone system. • Incompatible for e-business applications • Dual Architecture Continued….

  8. GIS vs. Oracle Spatial • Fully integrated, Single Architecture. • Location analysis without GIS • Useful for corporate and business applications

  9. GIS vs. Oracle Spatial Oracle spatial emphasizing the Information Systems by combining the Location information with attribute information Continued….

  10. Oracle Spatial

  11. Architecture Data type

  12. Spatial database

  13. Storing Spatial data in a Database • Three types of geometry: Points, Lines, and Polygons

  14. Spatial data storage in Oracle • Use SDO_GEOMETRY for vector • Use SDO_GEORASTER for raster images Structure of SDO_GEOMETRY SDO_GTYPE NUMBER SDO_SRID NUMBER SDO_POINT SDO_POINT_TYPE SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY SDO_ORDINATES SDO_ORDINATE_ARRAY Details…. next slides • Example SQL> CREATE TABLE states ( state VARCHAR2(30), totpop NUMBER(9), geom SDO_GEOMETRY);

  15. SDO_GTYPE • Defines the geometry type • Follow DOOT rule

  16. SDO_SRID • SRID = Spatial Reference system ID • More than 1000 different systems • A common value: 8307 • – "Longitude/Latitude WGS84" • – Used by GPS • – Navteq and TeleAtlas data are WGS84-encoded • All geometries must have the same SRID • Different layers can have different SRID • Automatic conversion when querying

  17. SDO_POINT and SDO_ODRINATES

  18. Example-Point SQL> CREATE TABLE geometry_examples ( name VARCHAR2(100), description VARCHAR2(100), geom SDO_GEOMETRY ); Creating a Table • SQL> INSERT INTO geometry_examples values • ( • ‘POINT’ • ‘'2-dimensional Point at coordinates’ • SDO_GEOMETRY • ( • 2001, • 8307, • SDO_POINT_TYPE • ( • -79, • 37, • NULL • ), • NULL, • NULL • ) • ); Loading Point Data values -79, 37 (2D) 2001-DOOT

  19. Example 2- Polygon SQL> INSERT INTO geometry_examples VALUES ( 'POLYGON', '2-D polygon connecting A(Xa, Ya), B(Xb, Yb), C(Xc, Yc), D(Xd, Yd)', SDO_GEOMETRY ( 2003, -- SDO_GTYPE: D00T. Set to 2003 as it is a 2-dimensional polygon 32774, -- SDO_SRID NULL, -- SDO_POINT_TYPE is null SDO_ELEM_INFO_ARRAY -- SDO_ELEM_INFO attribute ( 1, -- Offset is 1 1003, -- Element-type is 1003 for an outer POLYGON element 1 -- Interpretation is 1 if boundary is connected by straight lines. ), SDO_ORDINATE_ARRAY -- SDO_ORDINATES attribute ( 1,1, -- Xa, Ya values 2,-1, -- Xb, Yb values 3,1, -- Xc, Yc values 2,2, -- Xd, Yd values 1,1 -- Xa, Ya values : Repeat first vertex to close the ring ) ) );

  20. Other spatial functions-Oracle Spatial • Spatial query from SQL • Inbuilt geo-coding services available for know address • All types of spatial operations can be performed using SQL such as joining, counting and relate. • Metadata loading option. • Network analysis such routing, directions • Visualization in Map viewer • Spatial analysis such as buffering, nearest neighbor, within distance, and contains.

  21. Benefits

  22. Summary • Useful tool to add spatial features into existing database • No extra programming skills necessary • No need to purchase GIS software's • Single database • No cost feature for Oracle Application Server to view the maps • Supports all types of geometry such as raster, lines, polygons

  23. References • Pro Oracle Spatial Book • Fred Louiis, Sollutiion Archiitect and Ohiio Valllley. Oracle Platform GIS & Location-Based Services.Oracle • http://www.oracle.com/technology/products/spatial/index.html

More Related