Transcription
Use of Oracle Spatial 10gfor Land ManagementXavier LopezDirector, Spatial TechnologiesOracle USA, Inc.
OverviewŸŸŸŸGeospatial is ubiquitous and mission criticalOracle Spatial TechnologiesCase ExamplesOracle10g New Features2
Mission Critical Uses in CadastresMapping Agencies, and Land RegistrationŸ IACS:Ireland Ministry of Agric.Netherlands Min of Agric.Poland Min of Agric.Italian Min of Agric.Ÿ Cadastre:The NetherlandsPolandDenmarkCzech RepublicŸ Environment:UK Environment AgencyU.S. EPAŸ Mapping Agencies:UK Ordnance SurveyIreland Ordnance SurveyN. Ireland Ordnance SurveySOGEI (Italy)NGA (USA)USGS (USA)AustraliaŸ Hydrographic Agencies–––CanadaAustraliaUS Navy 3
Location is becoming mainstreamŸ Location Aware Utilities Infrastructure–––Networks: Outage, Network Analysis, Distribution,Logistics: Real time supply chain managementAsset Management: Fixed, mobile, planningŸ eBusiness Applications–CRM, Sales, Marketing, HR, Supply Chain–Web Portals: Google, Yahoo, AOL, MicrosoftŸ Location-enhanced Wireless Communications–Ubiquitous positioning capability
Amazon.com Example5
Challenge of Integrating Spatialand Enterprise ApplicationsŸ Specialty GIS servers–––––Data isolationHigh systems adminand management costsScalability problemsHigh training costsComplex support problemsŸ Spatial data tightly coupled tospecific applicationŸ Information not aligned withBusiness ProcessesSpatialDataGeo EngineeringServerGIS/DesignTabularDataEnterprise DataServerBusinessApps6
Role of Spatial DBMS:Provides Security, Performance, ScalabilityEngineeringApplicationsGISSQLSQLAsset MgmtApplications s Logic Data ilitySQLOracle10gSpatial7
DBMS Supports all Information TypesŸ Relate associated information to spatial locations²²²²²²²²RecordsImagesSatellite imagery2D & 3D Vector dataNetworksDocumentsVideoXML
Partners Supporting Oracle Spatial/Locator
Enterprise Customer RequirementsŸ Cost reduction, consolidationŸ Eliminate stovepipesŸ Decision making based on allavailable dataŸ Eliminate duplicate dataŸ Support multiple data typesŸ Simplified programmingŸ Use common IT platformsŸ Support best of breed toolsŸŸŸŸŸ1000’s of users10’s Terabytes24x7 systemsMinimize of Isolated systemsSupport near real-time dataand sensor inputsŸ Database securityŸ Support SOA architecture10
Oracle Spatial CapabilitiesSpatial Data TypesAll Spatial DataStored in the DatabaseSpatial IndexingOracleSpatialFast Access toSpatial DataSpatial Access Through SQLQuery/AnalysisSelect, join, buffer, within distance,nearest neighbor, intersection, union,convex hull, centroid, .
Every Oracle10g Databaseis a Spatial DBMSOracle10g Locator Feature:ŸŸŸŸŸŸŸŸŸŸSQL Spatial TypeR-tree indexSpatial OperatorsSpatial Reference SystemGeodetic (lat/long) SupportVersioning/Long TransactionsParallel Index, Query, LoadPartitioningGML SupportAnnotation Support12
Spatial Query Via SQLFind all building within 500 meters of building 902SQL SELECT a.building id2 FROM base buildings a,3 base buildings b4 WHERE b.building id 9025 AND MDSYS.SDO WITHIN DISTANCE(6 a.Location, b.Location,7 ‘distance 500’) ‘TRUE’;500meters13
Oracle Spatial OptionŸ Includes Locator features plus :––––––––––Geometry operationsSpatial aggregatesLinear referencingCoordinate system transformationUser-defined coordinate systemsNetwork ManagementTopologyRaster integrationGeocoderSpatial Data MiningAn option of OracleEnterprise EditionLarge data volumes,high user populationComplex queries,Advancedmanipulations.14
DBMS Enables Geospatial PlatformsLand ManagementTransportationHomeland SecurityModeling/AnalysisLogisticsMultiple AppsMultiple Users
Ireland Dept. of Agriculture16
UK Ordnance SurveyData CollectionSurveysGPSNew FeaturesPhotogrammetryOnline UpdatesSecure extractionRecordsRecordsSpatialSpatial RecordsSpatialProductionParcel UpdatesIntegrationLong TransactionsVersioningTopology Mgmt.Quality ControlSecurityDisseminationCompilationMedia ProductionWeb DeliveryOnline QueryOnline updatesPersonalizationBillingSecurity
UK Ordnance SurveyŸŸŸŸŸŸŸŸStore and maintain once, use many timesReduce deployment costsReduce maintenance costsImprove data integrationImprove systems integrationFacilitate new product opportunitiesIncrease business agilityStandards and COTS based18
Previous EnvironmentŸŸŸŸExisting systems lack agilityDifficult tointegrate/interoperateVery costly to maintainComplex bespokedevelopmentsEditorsDCQTCS GRACEAPSFEPSls & MktngStatsDMSProd SchedSystemsLMSMOSAICROADSDDMSDCSCFSRAMSHSMCMSDef RegGMSGDW/SCSAMGMS2Mercury(GOS)FTP19eDCS
SizingType of DataRaw DataSize (GB)350Spatial Indexes70Transient Tables required duringSpatial Index Creation / Re-Build40Non-Spatial Indexes20450 million featuresHistory (10% change per year for 5 years)175History Spatial Indexes20Transient Tables required duringSpatial Index Creation / Re-Build10History Non-Spatial Indexes10Database Structures (system, undo, etc.)100Contingency at 25%200Total995 GB20
US Census Bureau 2010 TIGERŸ World’s largest Topology Maintenance ProjectŸ Census standardized on Oracle10g Spatial for 2010Topology Modernization ProjectŸ Using Oracle10g Topology––––Data MaintenanceReferential IntegrityPersistent TopologyOpen Solution21
New York CityŸŸCentralized GIS Utility based onOracle SpatialDeveloped standardized digitalbasemap for all agenciesŸ 6,000 miles of undergroundpipesŸ 1 million water/sewerconnectionsŸ 32,000 sq. miles ofInfrastructure DataŸ 7,500 digital photographsŸŸMultiple GIS applications: ESRI,Bentley, MapInfo, GE SmallworldCore component of city’s 311application
Integrated NYC Spatial ArchitectureGIS Specialist SystemsSpatially Enabled Business ApplicationsEnvironmentalManagementLogistics ManagementTransportationCrime MonitoringDPW ServicesHealth & SocialServicesEducationFinancial ManagementTopographic/RasterCadastreGeo-coded AddressStreet Center LinesAssetsEnvironmentalTransportHealth/Social servicesEducationSpatial Data HubCitizen PortalAsset MaintenanceCriminal JusticeHealth Planning
Oracle10g Value PropositionIntegrated and Assured Information SharingExternal WebServicesŸŸŸŸSingle source of truthStrong SecurityReal-time information updatesInteroperable data and locationProvincialaware processesŸ Integrated spatial information from Agenciesmultiple sourcesŸ Enhanced Business andPlanningOperational IntelligenceDept.Ÿ Creation of a Network Centric,Spatially Enabled, Real 24
To find out mples, white papers, downloads, discussion forum, sample data .25
Oracle Spatial Option Includes Locator features plus : . Management Transportation Crime Monitoring DPW Services Health & Social Services Education Spatially Enabled Business Applications Logistics Management Financial Management Citizen Portal Asset Maintenance Health Planning Spatial Data Hub Topographic/Raster Cadastre Geo-coded Address Street Center Lines Assets
