Oracle的空间技术

OracleLogoOracleOracl[e-mail]•OracleSpatial•••SpatialLocator•OracleSpatial•OracleApplicationServerMapViewer•:Oracle10gOracleSpatialOracleSpatialOracle7.1.6MultiDimensionOracle7.3.3SpatialDataOptionOracle8iSpatial•••Quad-Tree•Spatial••••Oracle9iSpatial•••R-Tree•••Oracle(OEM)Oracle7199419951997199920012003OracleSpatialOracleSpatialSQLSelecta.building_idfromfacilitya,facilitybwhereb.building_id=902andsdo_within_distance(a.geom,b.geom‘distance=10unit=mile’)=‘TRUE’;••••••••OracleFisherCircle85thSt.CoopCourtRoadROAD_ID123SURFACEAsphaltAsphaltAsphaltNAMEFisherCir.CoopCt.85ThSt.LANES422LOCATIONR-Tree•(MBR)•••R-TreeInside••SQL•–InsideContains–TouchDisjoint–CoversCoveredBy–EqualOverlapBoundary•–WithinDistance–NearestNeighbor500metersWithinDistanceSQLSQLSELECTa.building_id2FROMbase_buildingsa,3base_buildingsb4WHEREb.building_id=9025ANDMDSYS.SDO_WITHIN_DISTANCE(6a.Location,b.Location,7‘distance=500unit=meter’)8=‘TRUE’;500metersUnionXORIntersectOriginalDifference••Union•Difference•Intersect•XOR•Buffer•Centertroid•ConvexHull••Length•Area•DistanceOracle9i:•••••••••Oracle•••••••••UTMStatePlane••OracleSpatial(LRS)(LRS)?•••GIS(5,10,0)(50,15,53.8)(55,20,60)(45,10,44)(30,10,27)(15,5,11.2)(40,5,38)LRS•DBMSSIDLRSGeometrySIDMAccident#SIDSpeedStartMEndMSIDSign#MSIDConditionStartMEndMLRS–OracleSpatial••OracleSpatial••(Lon/Lat,Alt,Time)OracleASMapViewerOracleSpatialLRS•MapViewer••LRSOracleSpatial••selectSDO_AGGR_UNION(sdo_aggr_type(a.geometry,0.5)fromstates;SDO_AGGR_CONVEXHULL•••OracleSpatialLocatorOracleLocatorOracleSpatialLocator•••GIS•GIS•GIS•Oracle•Spatial•GIS••••OracleOracle9i:Locator&Spatial••2D3D4D•••••••*•*Spatial•Locator•••••••OracleLocatorOracleSpatialLocator•••GIS•GIS•GIS•Oracle•Spatial•GIS••••OracleWorkingwithLeadingPartnersOracleOracle&AutodeskAutodeskMapGuideAutodeskMapAutodeskOnSiteAutodeskMapGuideServerHTTPOracle9iOracleSpatialOracle&ESRIArcMapArcIMSArcEditorArcIMSHTTPOracle9iArcSDEOracleSpatialArcPadOracle&MapInfoMapXtremeJavaMapInfoProfessionalMapXtendMapXtremeMapMarkerHTTPOracle9iOracleSpatialOracle&IntergraphGeoMediaWebMapOnDemandGeoMediaProfessionalHTTPOracle9iOracleSpatialOracle9iASMapViewerOracle9iASMapViewer:•SDO_GEOMETRYWeb•OracleSpatialOracleLocator•Oracle9iASRelease2Oracle9iAS•XMLAPIHTTP•Javaservlet(100%J2EE•OracleSpatialOracleLocator•Oracle8.1.7•MapViewer:•Oracle•••MapRequest•MapViewerMapResponseEarthquakesMapViewerSDOVIS()MapViewerXML/HTTP–Oracle9iASOracleSpatialJDBCMapViewerQuery••••••JDBC•••URLMBRMapViewerOracle9iSpatial/LocatorMapViewerXML:?xmlversion=1.0standalone=yes?map_requesttitle=OracleLBSMapdatasource=mvdemobasemap=demo_mapwidth=500height=375antialiasing=trueformat=GIF_URLcentersize=1.5geoFeaturerender_style=m.starradius=1600,4800label=ThePlacetext_style=t.StreetNamegeometricPropertyPointcoordinates-122.2615,37.5266/coordinates/Point/geometricProperty/geoFeature/center/map_request•XML/HTTP•XMLURL••JDBCMapViewerXML:•MapViewerMap-Response•URLmap_responsemap_imagemap_contenturl==66737789482409838/boxsrsName=defaultcoordinates-122.9615,37.0016-121.5615,38.0516/coordinates/boxWMTExceptionversion=1.0.0error_code=SUCCESS“//map_image/map_responseMapViewerXML:•––Spatialsoftware•Oracle9iASRelease4(9.0.4)•Java•Oracle–USER_SDO_MAPS–USER_SDO_THEMES–USER_SDO_STYLESOracle9iOracleSpatial10g:OracleSpatial10g-•GeoRaster••••••–––ƒPoint_At_BearingƒGeneralize..ƒ…GeoRaster-74.1651749,41.339141-74.1651749,41.339141,-73.4284481,40.678193,-72.9792214,41.686228-74.1651749,41.339141,-74.1651749,39.559004,-72.9792214,39.559004,-72.9792214,41.339141yyyyyyyyyyyyyyyyyyyyyy6111166113879197318331953339819703339019088990010029100025491679CELLVALUEGEOLOGICALPERIOD1234567890COLORMAPyCOLORMAP6111166113879197318331953339819703339019088990010029100025491679CELLVALUERedGreenBlue125525502821236731422309849612122851452312436255510720318822481951357592041022550000•yyyyy(µm)1mm1m10-610-510-410-310-210-1110102103104105106107108109XUV0.40.50.60.7(µm)2310.4µm0.5µm0.6µm0.7µmGeoRaster•GeoRaster•:–––––––––GeoRaster•–––•––––GeoRaster•––•––GeoRaster•GeoRaster–TIFF/GeoTIFF–ESRIWorldFile–JPEG–GIF–BMP–PNG–•Oracle9iASMapViewerGeoRasterOracleSpatialGeoRaster••••••••OracleSpatial10gG1G2G3G4G5f1f2f3f0n1n2n3n4n5n6n7n8n9e1e2e3e4e5e6e7e8e9e10•––--•–––OracleSpatial10g••••••OracleSpatial10g•••OracleDataMining••••OracleSpatial10g•GeoRaster••••••–––ƒPoint_At_BearingƒGeneralizeƒnswersuestionsQ&A