{"id":234092,"date":"2019-05-16T14:42:42","date_gmt":"2019-05-16T21:42:42","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&p=234092"},"modified":"2024-09-27T16:49:42","modified_gmt":"2024-09-27T23:49:42","slug":"an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","title":{"rendered":"An overview of the SDSFIE v2.6 to v3.0 migration process"},"author":4922,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","castos_file_data":"","podmotor_file_id":"","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":[],"tags":[],"arcuser_issues":[194992],"class_list":["post-234092","arcuser","type-arcuser","status-publish","format-standard","hentry","arcuser_issues-spring-2013"],"acf":{"short_description":"These Python tools were developed to automate the migration process and ensure no data was lost\u2026","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"

Migration Process<\/h2>\r\nThese Python tools were developed to automate the migration process and ensure no data was lost."},{"acf_fc_layout":"image","image":703182,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

T0_Preparve_db.py<\/h3>\r\nThis tool checks the integrity of the geometry and repairs it if necessary. It also converts any multipart features to single-part features and deletes any empty datasets, feature classes, or tables.\r\n

T1_Clip_to_Site.py<\/h3>\r\nUsing a polygon chosen by the user, this tool clips an installation geodatabase into a site-only geodatabase. At this point, the user needs to considerw how to define the geographic extent of the site geodatabase. This is important, because in some cases a site is within another site. Also, it may be necessary to include non-AF features to provide situational awareness.\r\n

T2_AddnCalc_FC.py<\/h3>\r\nThis tool adds new fields to each v2.6 feature class for use later in the migration process. The new fields provide information in the v2.6\u20133.0 merged geodatabase to determine where the features in a v3.0 feature class were previously stored in the v2.6 geodatabase. This is necessary because, in some cases, multiple v2.6 feature classes are merged into one v3.0 feature class.\r\n

T3_DB_Separation.py<\/h3>\r\nTo retain those v2.6 feature classes that are not migrated to v3.0, this tool saves any such feature classes to the Orphaned geodatabase. To ensure a lossless migration, any data not v2.6 compliant is stored in the non-SDSFIE geodatabase.\r\n

T4A_Migrate_to_30.py<\/h3>\r\nThis tool appends the geodatabase output from T2_AddnCalc_FC.py to the merged v2.6\u20133.0 geodatabase.\r\n

T4B_Populate_30.py<\/h3>\r\nFrom user-specified input, this tool populates required fields in the merged geodatabase with site-specific information.\r\n

T4C_Attribute_Crosswalk.py<\/h3>\r\nThis tool operates on the merged v2.6\u20133.0 geodatabase to ensure that relevant data is not lost. For each feature class to retain important v2.6 data, some information is copied\/pasted from the old v2.6 field into the corresponding new v3.0 field.\r\n

T5_Site_Merge.py<\/h3>\r\nThis tool merges all the site-specific geodatabases into an installation master v2.6\u20133.0 geodatabase.\r\n

T6_AF_Adaptation.py<\/h3>\r\nStill working with the merged v2.6\u20133.0 geodatabase, this tool copies the v3.0 attributes to a v3.0-only geodatabase and the remaining v2.6 attributes are then saved as ancillary tables.\r\n

T7_NetStorage_Data_Export.py<\/h3>\r\nWorking with the v3.0 geodatabase, this last tool exports only common installation picture (CIP) feature classes to a geodatabase destined for the AF's Novell NetStorage web server."}],"references":null},"yoast_head":"\nAn overview of the SDSFIE v2.6 to v3.0 migration process | Spring 2013 | ArcUser<\/title>\n<meta name=\"description\" content=\"These Python tools were developed to automate the migration process and ensure no data was lost\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\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An overview of the SDSFIE v2.6 to v3.0 migration process\" \/>\n<meta property=\"og:description\" content=\"These Python tools were developed to automate the migration process and ensure no data was lost\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\" \/>\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-27T23:49:42+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=\"3 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\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\",\n\t \"name\": \"An overview of the SDSFIE v2.6 to v3.0 migration process | Spring 2013 | ArcUser\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t },\n\t \"datePublished\": \"2019-05-16T21:42:42+00:00\",\n\t \"dateModified\": \"2024-09-27T23:49:42+00:00\",\n\t \"description\": \"These Python tools were developed to automate the migration process and ensure no data was lost\u2026\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process#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\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process#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\": \"An overview of the SDSFIE v2.6 to v3.0 migration process\"\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\/67b072b56520e2ffda4f60a9161035ae\",\n\t \"name\": \"Veronica Diaz\",\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\/bbb0ff305c176c43ac571f14f7401ea2ec049c63dfa610144bf34f48dc867762?s=96&d=blank&r=g\",\n\t \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/bbb0ff305c176c43ac571f14f7401ea2ec049c63dfa610144bf34f48dc867762?s=96&d=blank&r=g\",\n\t \"caption\": \"Veronica Diaz\"\n\t },\n\t \"url\": \"\"\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"An overview of the SDSFIE v2.6 to v3.0 migration process | Spring 2013 | ArcUser","description":"These Python tools were developed to automate the migration process and ensure no data was lost\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\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","og_locale":"en_US","og_type":"article","og_title":"An overview of the SDSFIE v2.6 to v3.0 migration process","og_description":"These Python tools were developed to automate the migration process and ensure no data was lost\u2026","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-09-27T23:49:42+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process","name":"An overview of the SDSFIE v2.6 to v3.0 migration process | Spring 2013 | ArcUser","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-05-16T21:42:42+00:00","dateModified":"2024-09-27T23:49:42+00:00","description":"These Python tools were developed to automate the migration process and ensure no data was lost\u2026","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/an-overview-of-the-sdsfie-v2-6-to-v3-0-migration-process#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"An overview of the SDSFIE v2.6 to v3.0 migration process"}]},{"@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\/67b072b56520e2ffda4f60a9161035ae","name":"Veronica Diaz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bbb0ff305c176c43ac571f14f7401ea2ec049c63dfa610144bf34f48dc867762?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bbb0ff305c176c43ac571f14f7401ea2ec049c63dfa610144bf34f48dc867762?s=96&d=blank&r=g","caption":"Veronica Diaz"},"url":""}]}},"sort_order":"0","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/234092","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\/4922"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/234092\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=234092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=234092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=234092"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=234092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}