SDSFIE Online Tools BrowseGenerate Data Dictionary Webinar 1300

SDSFIE Online Tools: Browse/Generate & Data Dictionary Webinar 1300 -1500 Eastern 28 NOV 18 (Session 1) 12 DEC 18 (Session 2) Call-in toll-free number: 1 -888 -557 -8511 (US) / Access Code: 903 935 1 / Security Code: 4444 Webex: https: //usace. webex. com/usace/j. php? MTID=md 63 dc 7 e 3599 d 923 c 73 dc 9805 d 9 a 874 c 8 Meeting number: 966 475 753 Meeting password: 4444 DCS: https: //conference. apps. mil/webconf/SDSFIEVector. WG FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE

SDSFIE Webinar Schedule FY 2019 ☑ 1. ☑ 2. SDSFIE Program & Standards Overview: 11 & 24 OCT Browse/Generate, Data Dictionary: 28 NOV & 12 DEC ---------------- 2019 ---------------- 3. Data Model Pre Migration: 16 JAN & 6 FEB 4. Assessing Compliance with Validate; Adaptations with Model Builder: MAR / APR 5. Data Model Migration: APR / MAY 6. Metadata standards, tools and templates: MAY / JUN FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 2

SDSFIE Overview Webinar • Agenda – SDSFIE-V Concepts and Terminology – SDSFIEOnline Website • Online Resources • Online Tools – Common Workflows using SDSFIE-V: Which Tool for which Task? – Data Collection Workflows, with Browse/Generate and Data Dictionary (and Model Builder) • Notes: – Please mute phones unless asking questions! – You can also use “Chat” in Web. Ex or DCS to ask questions FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 3

SDSFIE-V “Models” • In SDSFIE-Vector, or “SDSFIE-V”, a “Model” consists of an organized set of “elements”: – A set of Entities (Feature Types and/or nonspatial Object Tables) SDSFIE-V 4. 0 Gold Army 4. 0 • with Attributes, or characteristics, for each feature • Attributes may be constrained by Enumerations – Enumerations (“picklists”) have a set of Enumerants Air Force 4. 0 … • and, potentially, participate in Associations • In each Version of SDSFIE-V (e. g. , 3. 1 or 4. 0), there is a Gold model that is the root of all other models • Each Service adapts the Gold model to create their own Headquarters Adaptation model • Services can allow lower echelons to develop their own Sub-Adaptation • All adaptations must adhere to SDSFIE-V Implementation Guidance (SVIG) FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION Navy Data Model 4. 0 GEOFidelis 4. 0 USACE HQ 4. 0 … ENABLE HORIZONTAL / VERTICAL EXCHANGE 4

SDSFIE-V Adaptation Approach • “SDSFIE Adaptation” defined: A formalized alteration of a model which results in another model tailored to the particular business requirements of an implementing organization. An Adaptation consists of a specific Profile and/or all the Extensions that are required to meet specific business requirements. • SDSFIE Adaptation consists of three primary steps: – “profiling” – removing non-mandatory elements that the implementing organization does not require • Any entity other than those used in Installation CIP • Any non-foundational attribute – “extending” – adding required elements not found in the parent model (e. g. , needed by USACE but not in Gold) – “changing” – altering model, without affecting interoperability FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 5

SDSFIE Model “Elements” ▪ Model “elements” include any of the following model components: ► Folder – a set of entities ► Entity (two types) q q Feature Type – A set of thematically equivalent geographic features with a corresponding data table of attributes Object Table – A non-spatial data table of attributes that can be linked to one or more feature types ► Attribute – a characteristic of an entity ► Enumeration – constraint on an attribute ► Enumerant – permissible value in an enumeration ► Association – establishes a relationship between two entities based on a primary key and a foreign key FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 6

SDSFIE Terminology SDSFIE Elements, and Element Properties All SDSFIE LDM, elements have standard properties, which include: • Model Name o Pascal. Case or o camel. Case • Alias o English name • Definition o Succinct characterization • Description o Elaborate on Def. o Def. References • Note o Deconfliction • Justification FOUNDATION DATA SDSFIE Element-Specific Properties SDSFIE LDM Element Terms • N/A Folder • Default Geometry Entity • Feature. Type (spatial) • Object. Table (non-spatial) • ⁻ one: point, line, or area Permissible Geometry • ⁻ one or more of above Parent Entity [if subclass] • • Entity Model Name Data Type Physical Elements Terms, in Arc. GIS Geodatabase Feature Dataset Feature class Object class ⁻ E. g. , String, Real, Date. Time Length (in most cases) attribute Field • Length Enumeration Domain • Enumeration Model Name enumerant (Domain) Value • • Parent Entity and Attribute Child Entity and Attribute Association Relationship • • Constraining Enumeration REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 7

SDSFIE Online Overview of Tools and Resources DEMO FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 8

SDSFIE Online – Homepage https: //www. sdsfieonline. org Consent Banner – An initial pop-up to give consent After consenting, you have access to the SDSFIE Online Homepage – Provides a brief overview of SDSFIE, with links to the all parts of SDSFIE Online, with 4 main sections Menu Strip section – Access to all tools and pages Welcome section – What’s New? section – Highlights new developments or updated tools / documents A brief explanation of SDSFIE along with a “Learn More” link that will direct you to a page that explains the SDSFIE Family of Standards. FOUNDATION DATA Stakeholders section – provides links to each Component page REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 9

SDSFIE Online – The Menu Strip: Home – will always take you to the Welcome (Home) page • Top of almost all SDSFIE Online pages (not Tools) • Versatile • Hover/click accesses different SDSFIE Online topics and functions SDSFIE Online – provides links to general information and how to get started FOUNDATION DATA Standards – provides details on each of the SDSFIE Standards Models & Workflows – provides links to each of the SDSFIE Tools, and the means to interact with the models Components - provides links to each component page (identical to the links on the Home page) Support – provides links to a FAQ page, SDSFIE User Guides and additional training REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 10

SDSFIE Online – “SDSFIE Online” What is SDSFIE Online? – Provides an overview of SDSFIE Online and the SDSFIE family of standards. Register User – first, create User Account Getting Started – Three step process: Log In As User – must log in to obtain access to models and tools Step 1) Register Step 2) Learn More Step 3) Get to Work • Takes 24 -48 hrs, normally less • Standard password reset and username recovery functions Learn More – See “Support” menu item. Website Changelog FOUNDATION DATA • Specify a Sponsor or Manager REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 11

SDSFIE Online – “Standards” FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 12

SDSFIE Online – “Components” US Army Page To be Updated Soon! • US Army HQ 4. 0. 2 – model details • Implementation Plan • Migration Guidance and Support FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 13

SDSFIE Online – “Support” SDSFIE FAQ – commonly asked questions and general information about SDSFIE and the website; accessible from the “Get Help” link at the bottom of any page User Guides and Training Videos – 4 Tool/Workflow downloadable user guides and 26 training videos (watch through You. Tube, or download) Direct Contact “Help Desk” – response within 24 hrs (8: 00 AM-4: 30 PM EST Mon-Fri) • Webform email submission • Email: support@sdsfieonline. org • Phone: (571) 403 -0238 FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 14

Support – Details, and More Resources • SDSFIE Online – User Guides (5 “how-to” format) – FAQ – Training (26 videos) • Background (4) • Data Dictionary (2) • Browse/Generate (5) • Model Builder (8) • Validation (2) • Migration (5) • AGC – Online; Guidance; Standards; Requirements; Modeling • Leidos/Image Matters Support Team – Tech Support (via SDSFIE “Help Desk”) – Training (webinars) – Migration support (multiple 3 -4 day events) FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 15

SDSFIE Online – “Models & Workflows” Browse Generate – allows examination of a single model at a time and/or publishes a physical or logical data representation of that model Data Dictionary – provides multi-faceted search interface and reports across all logical data models, with saved search function Migration – supports moving data repositories to new (target) models, with capabilities for managing and registering custom data and sub-adaptations Model Builder - provides for creation and editing of logical data models, with options for interactive GUI or workbook upload for large/complex models Validate – facilitates comparison between any two models, including source to parent mode, with workbook output; shows adherence to SDSFIE rules FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 16

SDSFIE Online Tools: Browse/Generate Select a single model (adaptation) from the Registry, and “browse”, in full detail, all elements in that model ► Find entities in the model by keyword searches that probe the property text (e. g. , Definition, etc) of all element types ► Select entities within the chosen model, and “Generate” these different products: q LDM – a logical representation of data model in two different formats, both as Excel workbooks, with options q PDM – a physical representation of data model in ESRI Workspace XML format, which can be imported into a Geodatabase, with many options possible, including application of “Alternate Names” q Metadata model, full or for entity/attribute section, as XML ► FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 17

SDSFIE Online Tools: Data Dictionary ► ► ► ► Perform keyword searches against all models in the Registry, or specify selected type(s) of models to be probed Find selected type(s) or all elements in all or specified model(s) that match element property text (i. e. , Model Name, Alias, Definition, Description, Note) to the search criteria Examine lists of matched elements from different models, by element type (as tabs) View all attributes constrained by an enumeration in a model Use OR and AND operators with keyword(s), as well as conduct exact phrase matching Save Search, and Execute or Edit a Saved Search, Export Search Results FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 18

SDSFIE Online – Common User Workflows and Required Tools TOOL USE CASE • Need to collect data in the field. • Stipulated HQ model contains all required element concepts • Need to collect data in the field. • Need new elements concepts that don’t have a match in the stipulated HQ model • Need to plan for migration • Need to know compliancy of source data • Need to migrate data to be compliant • Need to view and/or update entity and attribute metadata FOUNDATION DATA Data Dictionary (DD) Browse / Generate (B/G) X Model Builder (MB) Migration X X Validation X X Examine relevant models Check (e. g. , “source parent” and “target compliancy of parent” adaptations) existing database against parent model(s) Use for inspection of inputs, intermediate results, and outputs Use B/G tools REACH BACK SUPPORT SYSTEMS INTEGRATION Use Migration Workflow and Tool ENABLE HORIZONTAL / VERTICAL EXCHANGE 19

SDSFIE Online – User Workflows Data Collection– all requirements are met by parent model (HQ Adaptation) Use Case #1 FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 20

SDSFIE Online – User Workflows Data Collection (Standard Elements) Scenario – Setting up project involving use of drones around Corps facilities to collect data. Know you need to track authorization area and use. – Inquiry to SMEs results in knowledge that new USACE HQ 4. 0 Adaptation has all entities (named SUAS*) needed to capture required information about authorized drone activities. – Need set of entities in geodatabase to serve as backend for web feature service accessed via handheld. Recommended Approach Browse / Generate Tool Select entities, and Generate schema FOUNDATION DATA REACH BACK SUPPORT Save schema Esri XML Workspace Document SYSTEMS INTEGRATION Arc. GIS Geodatabase Create new (empty) GDB in Arc. Catalog, and Import schema ENABLE HORIZONTAL / VERTICAL EXCHANGE 21

SDSFIE Online – User Workflows Data Collection – all requirements are met by parent model (HQ Adaptation) Use Case #1 DEMO FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 22

SDSFIE Online Data Collection Workflow START • Identify required element concepts • Identify stipulated parent adaptation Use B/G to: • Select stipulated parent adaptation • Select matched entity concepts Use B/G to: find matching concepts in the stipulated parent adaptation Report unmet requirements to your SDSFIE Component Lead YES Find all? NO Does your Component permit subadaptation? YES FOUNDATION DATA Use B/G to: • Generate LDM for future reference • Generate PDM for ESRI GDB structure (Workspace XML document) B/G = Browse/Generate Tool DD = Data Dictionary Tool MB = Model Builder Tool NO Create New Adaptation in MB: • Select stipulated parent adaptation • Select all matched entity concepts • Create new model REACH BACK SUPPORT Use DD to: • Try to find unmatched elements in other Components’ models SYSTEMS INTEGRATION In ESRI Arc. GIS: • Create empty GDB • Import ESRI Workspace XML doc GDB, ready for data! Use MB to: • Add unmatched elements that were found in other Components’ adaptation END YES Find all? NO Use MB to: • Create new elements not found in stipulated parent adaptation or that of other Components’ ENABLE HORIZONTAL / VERTICAL EXCHANGE 23

SDSFIE Online – User Workflows Data Collection – not all requirements are met by parent model (HQ Adaptation) [Use Case #2] Scenario – Setting up project involving use of drones around Corps facilities to collect data. – Same requirements as previous scenario, geodatabase with feature classes that support drone operations – *Additional need for a feature type that delineates areas with FAA airspace restrictions of non-federal UAS operations – Will need the 4 USACE HQ 4. 0 feature types, plus one additional feature type. – Your Component allows sub-adaptations FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 24

Adaptation Actions – Use Case #2 Parent Adaptation Need to check for existing entity in SDSFIE! Start with USACE HQ 4. 0. 2: 465 entities (Profiled Parent) Add entity to represent FAA UAS Temporary Flight Restrictions for National Security PROFILE 4 entities Child Adaptation EXTEND Remove all entities except: 5 entities Suas. Airport. Buffer Suas. Airworthiness. Area Suas. Certificate. Of. Authorz. Area Suas. Launch. Or. Landing. Location FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 25

SDSFIE Online – User Workflows Data Collection – not all requirements are met by parent model (HQ Adaptation) Use Case #2 DEMO FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 26

QUESTIONS? ? Paul Dubois: 703 -428 -6742 paul. c. dubois@usace. army. mil Dr. Jeff Ehman: 812 -325 -7937 jeffe@imagemattersllc. com FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 27

SDSFIE Webinar Schedule FY 2019 ☑ 1. ☑ 2. SDSFIE Program & Standards Overview: 11 & 24 OCT Browse/Generate, Data Dictionary: 28 NOV & 12 DEC ---------------- 2019 ---------------- 3. Data Model Pre Migration: 16 JAN & 6 FEB 4. Assessing Compliance with Validate; Adaptations with Model Builder: MAR / APR 5. Data Model Migration: APR / MAY 6. Metadata standards, tools and templates: MAY / JUN FOUNDATION DATA REACH BACK SUPPORT SYSTEMS INTEGRATION ENABLE HORIZONTAL / VERTICAL EXCHANGE 28