Oracle Location based services Spatial and Oracle LocatorOverviewWhat is Oracle Spatial and Oracle Locator?Oracle Locator doSpatial information systems (Ex. GIS)Geographic Information SystemsGIS vs. Oracle SpatialGIS vs. Oracle SpatialSlide 9Oracle SpatialArchitectureSpatial databaseStoring Spatial data in a DatabaseSpatial data storage in OracleSDO_GTYPESDO_SRIDSDO_POINT and SDO_ODRINATESExample-PointExample 2- PolygonOther spatial functions-Oracle SpatialBenefitsSummaryReferencesSlide 24Oracle Location based servicesSpatial and Oracle LocatorSrinivas GudelliCIS 764Fall 2008OverviewWhat is Oracle Spatial and Oracle Locator?Spatial information systems (Ex: GIS)GIS vs. Oracle Spatial?History and architectureData loading-examplesAdvantages SummaryQuestionsWhat 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.Oracle Locator doAll geometric objects– Points, lines, polygons– 2D, 3D, 4DIndexing (quadtrees and r-trees)Spatial queriesProximity queriesDistancesProjectionsOracle Spatial do=Locator + ...Geometric TransformationsSpatial AggregationsNetwork ModelingTopologyRasterGeocoderSpatial Data Mining3D Types (LIDAR, TINS)Web Services (WFS, CSW, OpenLS)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.Geographic Information SystemsStores attributes, raster images, vector dataHave capability to provide business logics such as relationships, domain values, networks, subtypesGIS vs. Oracle Spatial GIS is stand-alone system.Incompatible for e-business applicationsDual ArchitectureContinued….GIS vs. Oracle SpatialFully integrated, Single Architecture.Location analysis without GISUseful for corporate and business applicationsGIS vs. Oracle SpatialContinued….Oracle spatial emphasizing the Information Systems by combining the Location information with attribute informationOracle SpatialArchitectureData typeSpatial databaseStoring Spatial data in a Database Three types of geometry: Points, Lines, and PolygonsSpatial data storage in Oracle Use SDO_GEOMETRY for vectorUse SDO_GEORASTER for raster imagesStructure of SDO_GEOMETRYSDO_GTYPE NUMBERSDO_SRID NUMBERSDO_POINT SDO_POINT_TYPESDO_ELEM_INFO SDO_ELEM_INFO_ARRAYSDO_ORDINATES SDO_ORDINATE_ARRAY• ExampleSQL> CREATE TABLE states (state VARCHAR2(30),totpop NUMBER(9),geom SDO_GEOMETRY);Details…. next slidesSDO_GTYPEDefines the geometry type Follow DOOT ruleSDO_SRIDSRID = Spatial Reference system ID More than 1000 different systemsA common value: 8307– "Longitude/Latitude WGS84"– Used by GPS– Navteq and TeleAtlas data are WGS84-encodedAll geometries must have the same SRIDDifferent layers can have different SRIDAutomatic conversion when queryingSDO_POINT and SDO_ODRINATESExample-Point1. SQL> INSERT INTO geometry_examples values2. (3. ‘POINT’4. ‘'2-dimensional Point at coordinates’ 5. SDO_GEOMETRY6. (7. 2001, 8. 8307, 9. SDO_POINT_TYPE10. (11. -79, 12. 37, 13. NULL 14. ),15. NULL,16. NULL17. )18. );SQL> CREATE TABLE geometry_examples(name VARCHAR2(100),description VARCHAR2(100),geom SDO_GEOMETRY);Creating a TableLoading Point Data values-79, 37 (2D)2001-DOOTExample 2- PolygonSQL> 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 polygon32774, -- SDO_SRIDNULL, -- SDO_POINT_TYPE is nullSDO_ELEM_INFO_ARRAY -- SDO_ELEM_INFO attribute (1, -- Offset is 11003, -- Element-type is 1003 for an outer POLYGON element1 -- Interpretation is 1 if boundary is connected by straight lines.),SDO_ORDINATE_ARRAY -- SDO_ORDINATES attribute(1,1, -- Xa, Ya values2,-1, -- Xb, Yb values3,1, -- Xc, Yc values2,2, -- Xd, Yd values1,1 -- Xa, Ya values : Repeat first vertex to close the ring)));Other spatial functions-Oracle SpatialSpatial query from SQLInbuilt geo-coding services available for know addressAll types of spatial operations can be performed using SQL such as joining, counting and relate.Metadata loading option.Network analysis such routing, directionsVisualization in Map viewerSpatial analysis such as buffering, nearest neighbor, within distance, and contains.BenefitsSummaryUseful tool to add spatial features into existing databaseNo extra programming skills necessaryNo need to purchase GIS software'sSingle database No cost feature for Oracle Application Server to view the mapsSupports all types of geometry such as raster, lines, polygonsReferencesPro Oracle Spatial BookFred Louiis, Sollutiion Archiitect and Ohiio Valllley. Oracle Platform GIS & Location-Based
View Full Document