Transcription
7/13/2011INSPIRE InitiativeDelivering Access to HarmonisedSpatial DataJune 2011Make Data AvailableDon MurrayPresident & Co-founder,Safe SoftwareINSPIRE InitiativeMark DöringProject Managercon terrain a standard format through standard servicesFME 2011:Makes you the Superhero!Achieve Total Spatial Data Mastery1
7/13/2011INSPIRE InitiativeStandard FormatData (Historic Today Tomorrow) Analysis Better DecisionsWorld of Applications isRelationalXML/GML is Object Oriented2
7/13/2011How do they map to each other?What we need!What we do Data Model is King Working with GML requires solving the formatproblem AND the data model problem? Semantic data translation is key!We build data bridges3
7/13/2011XML Expert Not Required!XML/GML: 2 Strategy OptionsOption #1 Leverage industry XML tools such as XSLTand XQuery Users must know these complex technologies.XML/GML 2-Fold StrategyData Creator challengeOption #2 Make it EasyGML Minimal understanding of XML requiredProduce INSPIRE GML4
7/13/2011XML Writing Made EasierXML Writing TransformersXMLTemplator Convert FME attributes to XMLXMLFormatter Formats and beautifies XML documents.XMLValidator Ensures XML is validWriting XML - XMLTemplater feederObject objectID "{fme:get-attribute("objectID")}" feederName {fme:get-attribute("feederName")} /feederName feederNo {fme:get-attribute("feederNo")} /feederNo eaLoc {fme:get-attribute("eaLoc")} /eaLoc /feederObject XML Writing Example Sample XML: Source of XMLtemplates Add Xquery: replace attributevalues with Xquery statements feederObject objectID "{fme:get-attribute("objectID")}" feederName {fme:get-attribute("feederName")} /feederName feederNo {fme:get-attribute("feederNo")} /feederNo eaLoc {fme:get-attribute("eaLoc")} /eaLoc /feederObject Sample XML substation objectID "Vancouver Substation" mapLocation coord X 669170.169 /X Y 1000199.534 /Y /coord /mapLocation facilityID 5E67B377 /facilityID sectionID RPG123 /sectionID phaseCode ABC /phaseCode feederList feederObject objectID "8-64" feederName 10-24 /feederName feederNo 8763 /feederNo eaLoc 9D2D /eaLoc /feederObject feederObject objectID "8-65" feederName 10-25 /feederName feederNo 8766 /feederNo eaLoc 9D3F /eaLoc /feederObject /feederList name Vancouver Central /name /substation 5
7/13/2011XML Writing continued Data Consumer challenge XMLTemplater requires a sample XMLDocument!GMLUse XMLSampleGenerator togenerate XML from XSD!Use INSPIRE GMLWhat if you don’t have a sample?XML Reading Made EasierXML ReadingUse the GML ReaderXMLFragmenter Split XML documentsinto manageable“features” Includes “flattenoption” in FME 2011 Functionality also inXML ReaderNo XQuery or xfMapneeded!!!6
7/13/2011XML Reading ExampleINSPIRE Solution Pack for FMESimplifying INSPIRE Schema Mapping ChallengesINSPIRE Solution Pack for FME The aim is to design the schemamapping as simple as possibleInitial situation of INSPIREschema mapping INSPIRE expert knowledge and domain expertise are required High complexity of the source data and the INSPIRE destination model It has to be accounted for local characteristics (quality, history, contents) Uses FME Standard functionality(ETL) Extends FME with INSPIRE specificinformation and functionalities-Internal data modelsMeta dataData historyData qualityExpertise (Domain)INSPIRE Solution Pack for-INSPIRE data modelsINSPIRE specificationsINSPIRE legislationINSPIRE requirementsExpertise (Annex 1)7
7/13/2011ETL with INSPIRE Solution Pack for FMEData model as a common basePredefined INSPIREtemplateWorkspacesper Annex themeConnectionto individualsourcedata situationINSPIRE Solution Pack forFMEArcGIS for INSPIREINSPIREData Models & ServicesINSPIRE ETL Workflow DescriptionImportsourceschemaUse ESRIINSPIRE GDBschemapredefined mappingEuropeanSDIETLInternal Information-/Data Management Systemindividual mappingConsumerConclusion:Schematransformationand mappingLoad datainto ESRIINSPIRE GDBWhy is the INSPIRE Solution Pack simplifying the mapping process?You only deal with the tip of the icebergINSPIRESolution Pack8
7/13/2011The tip of the iceberg ModelINSPIRE Solution Pack for FMEFME feature based mappingexistingFeatureINSPIREFeatureINSPIRE Solution Pack for FME mappingcomplex things are hiddenXMLValidationOSIRIS (FFH) protected Sites(simple / full schema)FeatureRelationsUML / GMLXSDSchemaINSPIREData ValidationDatabaseDesignmdo1Source: OSIRIS dataINSPIRE Protected Sites –Full Schema (ISP Template)ESRI Shapes files representing the geometryNon spatial data separated in 2 databases and about200 tables9
Slide 35mdo1Mark Döring, 5/16/2011
7/13/2011Main Mapping ChallengesComplex Source Data Modell Domain knowledge from the customer (LANUV) needed INSPIRE GDB knowledge from con terraComplex Destination Modell INSPIRE Protected Sites full schemaMapping in Two StepsCustom OSIRIS Reader restructure and fusion of source data Result: feature structure close to INSPIREMapping with INSPIRE Solution Pack for FME template attribute and value Mapping Result: INSPIRE compliant dataInformation Exchange simple excel sheet with attributes Process with iterationsINSPIRE Mapping with template WorkspaceCustom Readerfor OSIRIS FFHISP Mapping forINSPIRE GDBModellResult:Filled ArcGIS for INSPIRE GDBMuch less complexity of FME WorkbenchReusable OSIRIS reader10
7/13/2011INSPIRE-GMLINSPIRE Solution providerscon terra – www.conterra.deDotted Eyes – www.dottedeyes.comMetria – www.metria.seSpatialworld- www.spatialworld.fiINSPIRE FME SolutionsThank You!LithuaniaSwedish National Land SurveyFinland National Land SurveyTurkish Ministry of EnvironmentState Agency for Nature, Environmentand Consumer Protection NRW UK Environment Agency LK Oberhavel Questions? Contact Information Email: don.murray@safe.com Email: m.doering@conterra.de @DonAtSafe@McMarkinger www.safe.com/inspire www.conterra.de/isp11
Predefined INSPIRE template Workspaces per Annex theme ETL with INSPIRE Solution Pack for FME Connection to individual source data situation individual mapping predefined mapping Import source schema Use ESRI INSPIRE GDB schema Load data into ESRI INSPIRE GDB INSPIRE ETL Workflow Description INSPIRE Solution Pack Schema transformation and .
