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