{"id":159802,"date":"2019-02-07T08:47:26","date_gmt":"2019-02-07T16:47:26","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&#038;p=159802"},"modified":"2024-09-27T14:22:35","modified_gmt":"2024-09-27T21:22:35","slug":"swift-and-lossless","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless","title":{"rendered":"Swift and Lossless"},"author":1432,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[10402],"tags":[323212,157432,325042,325052,201052],"arcuser_issues":[194992],"class_list":["post-159802","arcuser","type-arcuser","status-publish","format-standard","hentry","category-arcgis-desktop","tag-air-force","tag-arcgis","tag-arctoolbox","tag-geobase","tag-python","arcuser_issues-spring-2013"],"acf":{"short_description":"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026","pdf":{"host_remotely":false,"file":159872,"file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2>Automating the migration to a new data model<\/h2>\r\nUsing ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very specific data model to a more generalized one. The AF solution transitioned the Spatial Data Standard for Facilities, Infrastructure, and Environment (SDSFIE) 2.6 geospatial data to the Air Force Adaptation of SDSFIE 3.0."},{"acf_fc_layout":"image","image":159812,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The AF GeoBase program supports the AF Civil Engineer (CE) and broader AF missions by providing accurate geospatial data of real-world features for all AF installations, ranges, and property. The GeoBase mission involves tightly integrated cross-functional collaboration across the AF to provide geospatial visualization and analysis of CE business data. Its mission includes managing geospatial data and serving as the authoritative repository of all installation geospatial data."},{"acf_fc_layout":"image","image":159822,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Per the direction of Executive Order 12906,\u00a0<em>Coordinating Geographic Data Acquisition and Access: The National Spatial Data Infrastructure<\/em>, published April 13, 1994, many government organizations implemented the SDSFIE logical data model. This model is based on standards from the Federal Geographic Data Committee (FGDC). Within the United States Department of Defense (DoD), SDSFIE is now the geospatial data standard for all the armed services and the Washington Headquarters Services. It is governed by the Defense Installations Spatial Data Infrastructure (DISDI) Group. The Department of Defense Real Property and Installations Lifecycle Management (RPILM) Investment Review Board (IRB) approved SDSFIE 3.0 on November 15, 2010.\r\n\r\nFollowing this approval, the Office of the Under Secretary of Defense (Acquisition, Technology &amp; Logistics) (USD[AT&amp;L]) submitted the SDSFIE 3.0 to the DoD Information Technology Standards Registry (DISR) for listing as a mandated standard. To comply with the standard, the AF developed the AF Adaptation of SDSFIE 3.0, approved in January 2012."},{"acf_fc_layout":"image","image":159832,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>The New Standard<\/h2>\r\nThe new standard is significantly different from the prior version, SDSFIE 2.6. The data model for SDSFIE v2.6 represents facilities, infrastructure, and environmental features in a broad, thematically based, hierarchical manner. Items are organized first by a broad theme, then to a more detailed description or type for a given theme, then to a specific class of a thematic type. Simply put, items are organized into entity set, entity type, and entity class.\r\n\r\nThe data model for SDSFIE v3.0 represents features similarly to v2.6 except that it is more general. For example, in v2.6 transportation features are broken out into several modes, whereas in v3.0, all forms of transportation are in one entity type or dataset.\r\n\r\nIn some cases, there is a simple one-to-one relationship between features in v2.6 and v3.0. However, this generalization can require multiple v2.6 feature classes to be merged into one v3.0 feature class. Also, one v2.6 feature class can relate to many v3.0 feature classes. Additionally, some v2.6 feature classes are not in v3.0, and some v3.0 feature classes do not have a corresponding 2.6 version. The variety of relationships between features in v2.6 and v3.0 complicated the task of automating the migration process."},{"acf_fc_layout":"image","image":159842,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>The Migration Process<\/h2>\r\nSuccessful data migration required meeting two key goals: rapid conversion and no data loss. During the transition process, each AF user had to stop editing the current SDSFIE 2.6 geodatabase while it was migrated to the AF Adaptation. Consequently, rapid data migration was essential. Significant differences in the two versions necessitated considerable data manipulation and required a carefully developed methodology that ensured no data would be lost.\r\n\r\nBecause migrating from SDSFIE v2.6 to v3.0 was a significant effort, automating as much of the process as possible was essential. Once the migration methodology was envisioned, Python tools for use in ArcToolbox were developed to assist GeoBase personnel with the task. Using these tools, the transition process was accomplished more efficiently and resulted in minimal downtime for GeoBase. While creating the tools was not without difficulties, in the end the tools were used to migrate well over 1,000 sites in only a few months."},{"acf_fc_layout":"image","image":159852,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>The Process Step by Step<\/h2>\r\nArcToolbox Python tools developed by the AF saved critical man-hours while ensuring rapid and lossless data migration. The method the AF developed requires an interim (transition) geodatabase. The interim geodatabase contains v3.0 feature classes, but each feature class includes both v2.6 and v3.0 attributes. Consequently, it was named the v2.6-3.0 merged geodatabase.\r\n\r\nTo automate the process, the AF developed a series of tools that were separately applied. This multistep approach was adopted because initial tests using a single script required long run times (as much as 18 hours in one case). A lengthy run time might cause users to conclude the tool had stopped in midprocess. In this multistep process, each tool prepares the geodatabase for the next step. This approach has the additional benefit of giving users an opportunity to check the results of one operation before moving to the next\u2014a safeguard against data corruption or loss. Each tool and the processes associated are listed in \"<a href=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\/\">An Overview of the SDSFIE v2.6 to v3.0 Migration Process<\/a>.\""},{"acf_fc_layout":"image","image":159862,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Automating the Process<\/h2>\r\nFor more information, contact\u00a0<a href=\"mailto:kyle.turner.1@us.af.mil\">Kyle D. Turner<\/a>."}],"references":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Swift and Lossless | Spring 2013 | ArcUser<\/title>\n<meta name=\"description\" content=\"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Swift and Lossless\" \/>\n<meta property=\"og:description\" content=\"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-27T21:22:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless\",\n\t            \"name\": \"Swift and Lossless | Spring 2013 | ArcUser\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2019-02-07T16:47:26+00:00\",\n\t            \"dateModified\": \"2024-09-27T21:22:35+00:00\",\n\t            \"description\": \"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"Home\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"Swift and Lossless\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t            \"name\": \"Esri\",\n\t            \"description\": \"Esri Newsroom\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb\",\n\t            \"name\": \"April Mann\",\n\t            \"image\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t                \"url\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"caption\": \"April Mann\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Swift and Lossless | Spring 2013 | ArcUser","description":"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless","og_locale":"en_US","og_type":"article","og_title":"Swift and Lossless","og_description":"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-09-27T21:22:35+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless","name":"Swift and Lossless | Spring 2013 | ArcUser","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-02-07T16:47:26+00:00","dateModified":"2024-09-27T21:22:35+00:00","description":"Using ArcToolbox with Python tools, the Air Force (AF) created a repeatable process in\u00a0ArcGIS for Desktop\u00a0that enabled the translation of a very\u2026","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/swift-and-lossless#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"Swift and Lossless"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb","name":"April Mann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","caption":"April Mann"},"url":""}]}},"sort_order":"0","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/159802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcuser"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1432"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/159802\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=159802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=159802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=159802"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=159802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}