Transcription
Soil Data WarehouseWestern Regional NCSS ConferenceTelluride, ColoradoJuly 9, 2002Ken Harward, Project ManagerNRCS Information Technology CenterFort Collins, Colorado
Outline of Presentation Soil Data Warehouse Objectives Soil Data Warehouse Components SDW Phased Implementation &Timeline Geospatial Data Warehouse& the Soil Data Warehouse
SDW Objectives A single source of current official soilsurvey data of high quality that meetsUSDA national program responsibilities. Access to current and previous versions ofofficial soil survey data. Products that meet customer needs. Customer access for selecting,interpreting, reporting and downloadingsoil survey data and information.
Soil Data Warehouse ConceptsSoiSoil DataWarehouseQualityVersionedMetadataroFatalDSoil Data ForS oi lDataF orOnline AccessApplicationsPublications
SDW Objectives Informational materials explaining theNational Cooperative Soil Surveyprocedures, standards and technicalreferences. Supporting soil survey data such as pedondescriptions, laboratory characterization,and photographic and graphic images. Metadata and other information aboutthe soil survey products.
Soil Data Warehouse Components Business Analysis & Requirements for SoilData Delivery and Distribution Basic design includes a:– staging server,– warehouse database,– and various data marts Other components include:––––Web Soil Data ViewerOnline reports & interpretationsCustom ExportsSoils API (application programming interface)
SDW Business Analysis &Requirements
SDW Basic Design
SDW Phased Implementation First priority: primary warehouse functions and asoil data mart for SSURGO and the NRCS FieldOffice Technical Guide (eFOTG). 2nd priority: Web Soil Data Viewer Data Mart. Soil Reports and Interpretations Data Mart. Custom Export Data Mart. Soils Application Programming Interface (API)Data Mart. Soil Survey Publication Data Mart.
SDW Timeline Initial FOTG/SSURGO data mart up byAugust 2002. Initial Soil Data Warehouse up byNovember 2002. Fully functioning SDW and FOTG/SSURGOdata mart by Winter 2003. Web Soil Data Viewer data mart bySpring 2003.
Geospatial Data Warehouse & the SDW Infrastructure funding available throughthe Service Center Agencies (NRCS,FSA, RD) Data Management Initiative. Ongoing six month Pilot project todevelop and validate the technicalarchitecture. Soils data is included in the Pilot phase. Driving forces for the GDW are businesscontinuance and disaster recovery.
Data Directory Services (Metadata)OperationalDataSourcesSpatial Data IntegrationWarehousesPrimary SourceSecondary SourceNCGC SpatialData WarehouseAPFO SpatialData WarehouseNASISData MartsApplicationsFarmLoansService izingPlantsWetlandEasementsState/LocalPublic ydrographyHydrographyHydrologic UnitsHydrologic UnitsImageryMap IndexesReplicationMap IndexesOrtho ImageryOrtho ImageryOwnershipOwnershipPlantsTopographic tory& AssessmentRural Water& Waste WaterDataAccessState Govt,,PartnersRuralHousingCommon Land WCCClimateSTL-WFCensusPlantsProgram DataSoilsExternalDataMartsFed. Govt.,Partners
Geospatial Data WarehousePilot Project Pilot project runs from June to December 2002. Leverage existing production lines at the datacenters in Salt Lake City (FSA’s APFO) andFort Worth (NRCS’s NCGC). Move DOQ, DRG, and Soils data intowarehouses at each data center. Populate data marts at the Web Farm in FortCollins. Explore data replication, load balancing, andfailover technologies.
Other Data SourcesWeb FarmsAerial PhotographyField OfficeOGCMap ServicesDataMartsOGCMap ServicesOGCMap Servicesessr CDRemolownDoOGCMap Serviceste Ac ceOGCMap ServicesssDataWarehousePoFTadDrCDesktop GIS(ArcView)National Cartography& Geospatial CenterRemotead FTP occcesState al dataService Centeror Remote Officer CDFTP oWeb ApplicationsoteRemA ccess
Other Data SourcesWeb FarmsAerial PhotographyField OfficeOGCMap ServicesDataMartsOGCMap ServicesOGCMap ServicesDataWarehouser CDRemolownDoOGCMap Serviceste Ac ceNational Cartography& Geospatial CenterOGCMap ServicesssDataWarehousePoFTadDrCDesktop GIS(ArcView)cesad FTP oesOnestop ShoppingsPortal/GatewaysccAcState RepositoryRemoteDownloRemoteAloadDownLocal dataService Centeror Remote Officer CDFTP oWeb ApplicationsoteRemA ccess
Long-term Outlook Geospatial Data Warehouse taskconsists of a 5 year plan to implementthe GDW technical architecture andprovide ongoing O&M. Service Center Initiative funds theinfrastructure. NRCS funds Soil Data Warehouseanalysis and development.
Geospatial Data Warehouse Geospatial Data Warehouse Pilot Project Pilot project runs from June to December 2002. Leverage existing production lines at the data centers in Salt Lake City (FSA’s APFO) and Fort Worth (NRCS’s NCGC). Move DOQ, DRG, and Soils data
