Hello, I am attempting to remove some standalone tables from a map and subsequently launch a Python script that does some work on them. Here is the code I am using: The appendOptionAsync() call removes the tables from the map in preparation to run the python script. Note that if I right click and remove the tables the locks disappear: Before: After: However, if I run the tool and remove the tables that way... The locks persist Leading to this error: The locks remain even after I click out of the Python window: However... as soon as I click the button to run the tool again, the locks disappear: Before: Immediately after clicking the Import button again (locks are cleared): I feel like this might have something to do with garbage collection so I attempted to go back and put "using" statements as well as Dispose statements on the tables. The launchBaconAsync() call launches the python script. Thank you -John using System ; using System . Collections . Generic ; using System . Data ; using System . Diagnostics ; using System . IO ; using System . Linq ; using System . Windows ; using ArcGIS . Core . Data ; using ArcGIS . Desktop . Catalog ; using ArcGIS . Desktop . Core ; using ArcGIS . Desktop . Core . Geoprocessing ; using ArcGIS . Desktop . Framework . Contracts ; using ArcGIS . Desktop . Framework . Dialogs ; using ArcGIS . Desktop . Framework . Threading . Tasks ; using ArcGIS . Desktop . Mapping ; using Oracle . ManagedDataAccess . Client ; namespace BulkLoadTool { internal class Bacon : Button { public static IEnumerable List T > > SplitList T > ( List T > locations , int nSize = 1000 ) { for ( int i = 0 ; i locations . Count ; i + = nSize ) { yield return locations . GetRange ( i , Math . Min ( nSize , locations . Count - i ) ) ; } } public async void appendOptionAsync ( ) { await QueuedTask . Run ( ( ) = > { string selGDBitem = Module1 . Current . GDBdropdown . SelectedItem . ToString ( ) ; if ( selGDBitem == "" || selGDBitem == null ) { using ( var appFile = System . IO . File . CreateText ( @"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log" ) ) { appFile . Write ( String . Format ( "{0},\"{1}\"" , "False" , "" ) ) ; } return ; } else { string appString = String . Format ( "Would you like to append to {0}?" , selGDBitem ) ; var appResult = ArcGIS . Desktop . Framework . Dialogs . MessageBox . Show ( appString , "Append Features" , MessageBoxButton . YesNo , MessageBoxImage . Information ) ; if ( appResult == MessageBoxResult . Yes ) { using ( var appFile = System . IO . File . CreateText ( @"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log" ) ) { try { appFile . Write ( String . Format ( "{0},\"{1}\"" , "True" , selGDBitem ) ) ; IReadOnlyList StandaloneTable > standAloneTables = MapView . Active . Map . StandaloneTables ; List StandaloneTable > removalStandAloneTables = new List StandaloneTable > ( ) ; foreach ( var sATbl in standAloneTables ) { string sAPath = sATbl . GetTable ( ) . GetDatastore ( ) . GetPath ( ) . ToString ( ) ; if ( sAPath . Contains ( selGDBitem ) ) Trace . WriteLine ( sAPath ) ; { removalStandAloneTables . Add ( sATbl ) ; sATbl . GetTable ( ) . Dispose ( ) ; } } Trace . WriteLine ( selGDBitem ) ; MapView . Active . Map . RemoveStandaloneTables ( removalStandAloneTables ) ; var dispData = removalStandAloneTables . First ( ) . GetTable ( ) . GetDatastore ( ) . GetPath ( ) . AbsolutePath ; } catch { } return ; } } else using ( var appFile = System . IO . File . CreateText ( @"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log" ) ) { appFile . Write ( String . Format ( "{0},\"{1}\"" , "False" , "" ) ) ; } return ; } } ) ; } public async void launchBaconAsync ( ) { try { await QueuedTask . Run ( ( ) = > { object myCommand = @"C:\TxDOT\BulkLoad\LayerReference\Scripts\FutureBacon.bat" ; System . Diagnostics . ProcessStartInfo procStartInfo = new System . Diagnostics . ProcessStartInfo ( "cmd" , "/c" + myCommand ) ; procStartInfo . RedirectStandardOutput = false ; procStartInfo . UseShellExecute = true ; procStartInfo . CreateNoWindow = false ; System . Diagnostics . Process proc = new System . Diagnostics . Process ( ) ; proc . StartInfo = procStartInfo ; proc . Start ( ) ; //string result = proc.StandardOutput.ReadToEnd(); string result = String . Format ( "Features selected. See Python Window" ) ; //ArcGIS.Desktop.Framework.Dialogs.MessageBox.Show(result); } ) ; } catch ( Exception e ) { ArcGIS . Desktop . Framework . Dialogs . MessageBox . Show ( e . Message ) ; } } protected override void OnClick ( ) { try { var prog = new ProgressDialog ( "Gathering Route Info..." , false ) ; prog . Show ( ) ; QueuedTask . Run ( ( ) = > { var lyr = MapView . Active . Map . GetLayersAsFlattenedList ( ) . OfType FeatureLayer > ( ) . First ( l = > l . Name . Contains ( "TxDOT_Roadways_Edits" ) ) ; var selectionfromMap = lyr . GetSelection ( ) ; var gidList = new List string > ( ) ; var oids = selectionfromMap . GetObjectIDs ( ) . ToList ( ) ; int count = oids . Count ( ) ; var insp = new ArcGIS . Desktop . Editing . Attributes . Inspector ( false ) ; Dictionary string , Dictionary string , string > > futureDict = new Dictionary string , Dictionary string , string > > ( ) ; foreach ( var oid in oids ) { insp . Clear ( ) ; insp . Load ( lyr , oid ) ; Dictionary string , string > futureNestedDict = new Dictionary string , string > ( ) ; var gid = insp [ "GID" ] . ToString ( ) ; var editOp = insp [ "EDIT_TYPE" ] . ToString ( ) ; //FUTURE BACON DICT PARAMETERS var OGEOMS = insp [ "OGEOMS" ] . ToString ( ) ; var BEGIN_DFO = insp [ "BEGIN_DFO" ] . ToString ( ) ; var END_DFO = insp [ "END_DFO" ] . ToString ( ) ; var ETL_JOB_ID = insp [ "ETL_JOB_ID" ] . ToString ( ) ; if ( editOp . Contains ( "Retire" ) ) { continue ; } ; futureNestedDict [ "OGEOMS" ] = OGEOMS ; futureNestedDict [ "BEGIN_DFO" ] = BEGIN_DFO ; futureNestedDict [ "END_DFO" ] = END_DFO ; futureNestedDict [ "ETL_JOB_ID" ] = ETL_JOB_ID ; futureNestedDict [ "IN_GRID" ] = "True" ; futureDict [ gid ] = futureNestedDict ; gidList . Add ( gid ) ; } List string > removeGidList = new List string > ( gidList ) ; using ( OracleConnection oc = new OracleConnection ( ) ) { oc . ConnectionString = "Data Source=*******;USER ID=*********;Password=*******" ; oc . Open ( ) ; var chunks = SplitList ( gidList ) ; foreach ( var chunk in chunks ) { var chunkListJoin = String . Join ( "," , chunk ) ; string sql = String . Format ( "SELECT RDBD_GMTRY_LN_ID FROM GRIDOP.RDBD_GMTRY_LN WHERE GRIDOP.RDBD_GMTRY_LN.RDBD_GMTRY_LN_ID IN ({0})" , chunkListJoin ) ; OracleDataAdapter oda = new OracleDataAdapter ( sql , oc ) ; DataTable dt = new DataTable ( ) ; oda . Fill ( dt ) ; foreach ( DataRow dr in dt . Rows ) { removeGidList . Remove ( dr [ 0 ] . ToString ( ) ) ; } } ; Trace . WriteLine ( "Not in GRID: " ) ; Trace . WriteLine ( String . Join ( "," , removeGidList ) ) ; Trace . WriteLine ( "In GRID: " ) ; Trace . WriteLine ( String . Join ( "," , gidList ) ) ; foreach ( var g in removeGidList ) { futureDict [ g ] [ "IN_GRID" ] = "False" ; } oc . Close ( ) ; } //Write string to file System . IO . FileInfo file = new System . IO . FileInfo ( @"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log" ) ; file . Directory . Create ( ) ; using ( var outFile = System . IO . File . CreateText ( @"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log" ) ) { long gCount = gidList . Count ( ) ; long curCount = 1 ; foreach ( var arr in gidList ) { if ( curCount == 1 ) { outFile . Write ( "{" ) ; } //System.Diagnostics.Trace.WriteLine(arr); //System.Diagnostics.Trace.WriteLine(futureDict[arr]); String dString = String . Format ( "{0}:{{\"OGEOMS\":\"{1}\",\"BEGIN_DFO\":{2},\"END_DFO\":{3}}}" , arr , futureDict [ arr ] [ "OGEOMS" ] , futureDict [ arr ] [ "BEGIN_DFO" ] , futureDict [ arr ] [ "END_DFO" ] ) ; outFile . Write ( dString ) ; if ( curCount gCount ) { outFile . Write ( "," ) ; } else { outFile . Write ( "}" ) ; } curCount = curCount + 1 ; } } } ) ; prog . Dispose ( ) ; //Check append option appendOptionAsync ( ) ; launchBaconAsync ( ) ; return ; } catch ( Exception e ) { Trace . WriteLine ( e . Message ) ; //Module1.CreateNotification("Adding Layer... Will take a minute or so", "Roadways Edits Not Found"); //, @"Images\Bacon16.png"); var Datapath = QueuedTask . Run ( ( ) = > { DatabaseConnectionProperties connectionProperties = new DatabaseConnectionProperties ( EnterpriseDatabaseType . SQLServer ) { AuthenticationMode = AuthenticationMode . OSA , Instance = * * * * * * * * * * * * * * * Database = * * * * * * * * * * * * * Version = * * * * * * * * * * } ; using ( Geodatabase enterpriseGeodatabaseViaConnectionProperties = new Geodatabase ( connectionProperties ) ) { var gdbPath = enterpriseGeodatabaseViaConnectionProperties . GetPath ( ) ; return gdbPath . LocalPath ; } } ) ; string rdwaysEnd = @"TPP_GIS.APP_TPP_GIS_ADMIN.Roadways_Edits\TPP_GIS.APP_TPP_GIS_ADMIN.TxDOT_Roadways_Edits" ; string fullRdwayPath = Path . Combine ( Datapath . Result , rdwaysEnd ) ; Uri rdUri = new Uri ( fullRdwayPath ) ; QueuedTask . Run ( ( ) = > LayerFactory . Instance . CreateLayer ( rdUri , MapView . Active . Map ) ) ; } } } }

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Schema Locks persisting after running MapView.Active.Map.RemoveStandaloneTables() (ArcGIS Pro SDK C#)

JohnPhillipsGeo

Hello,

I am attempting to remove some standalone tables from a map and subsequently launch a Python script that does some work on them.

Here is the code I am using:

The appendOptionAsync() call removes the tables from the map in preparation to run the python script.

Note that if I right click and remove the tables the locks disappear:

Before:

After:

However, if I run the tool and remove the tables that way... The locks persist

Leading to this error:

The locks remain even after I click out of the Python window:

However... as soon as I click the button to run the tool again, the locks disappear:

Before:

Immediately after clicking the Import button again (locks are cleared):

I feel like this might have something to do with garbage collection so I attempted to go back and put "using" statements as well as Dispose statements on the tables.

The launchBaconAsync() call launches the python script.

Thank you

-John

<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Collections<SPAN class="punctuation token">.</SPAN>Generic<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Linq<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Catalog<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Geoprocessing<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Contracts<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Threading<SPAN class="punctuation token">.</SPAN>Tasks<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Mapping<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> Oracle<SPAN class="punctuation token">.</SPAN>ManagedDataAccess<SPAN class="punctuation token">.</SPAN>Client<SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">namespace</SPAN> BulkLoadTool
<SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">internal</SPAN> <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Bacon</SPAN> <SPAN class="punctuation token">:</SPAN> Button
    <SPAN class="punctuation token">{</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">static</SPAN> IEnumerable<SPAN class="operator token"><</SPAN>List<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN> SplitList<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>List<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN> locations<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">int</SPAN> nSize <SPAN class="operator token">=</SPAN> <SPAN class="number token">1000</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">int</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> locations<SPAN class="punctuation token">.</SPAN>Count<SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> nSize<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">yield</SPAN> <SPAN class="keyword token">return</SPAN> locations<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetRange</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> Math<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Min</SPAN><SPAN class="punctuation token">(</SPAN>nSize<SPAN class="punctuation token">,</SPAN> locations<SPAN class="punctuation token">.</SPAN>Count <SPAN class="operator token">-</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">async</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">appendOptionAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">await</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">string</SPAN> selGDBitem <SPAN class="operator token">=</SPAN> Module1<SPAN class="punctuation token">.</SPAN>Current<SPAN class="punctuation token">.</SPAN>GDBdropdown<SPAN class="punctuation token">.</SPAN>SelectedItem<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>selGDBitem <SPAN class="operator token">==</SPAN> <SPAN class="string token">""</SPAN> <SPAN class="operator token">||</SPAN> selGDBitem <SPAN class="operator token">==</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="punctuation token">}</SPAN>

                <SPAN class="keyword token">else</SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="keyword token">string</SPAN> appString <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Would you like to append to {0}?"</SPAN><SPAN class="punctuation token">,</SPAN> selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">var</SPAN> appResult <SPAN class="operator token">=</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">.</SPAN>MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN>appString<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Append Features"</SPAN><SPAN class="punctuation token">,</SPAN> MessageBoxButton<SPAN class="punctuation token">.</SPAN>YesNo<SPAN class="punctuation token">,</SPAN> MessageBoxImage<SPAN class="punctuation token">.</SPAN>Information<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>appResult <SPAN class="operator token">==</SPAN> MessageBoxResult<SPAN class="punctuation token">.</SPAN>Yes<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>                      

                        <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>

                            <SPAN class="keyword token">try</SPAN>
                            <SPAN class="punctuation token">{</SPAN>

                                appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"True"</SPAN><SPAN class="punctuation token">,</SPAN> selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            IReadOnlyList<SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN> standAloneTables <SPAN class="operator token">=</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN>StandaloneTables<SPAN class="punctuation token">;</SPAN>
                            List<SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN> removalStandAloneTables <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> sATbl <SPAN class="keyword token">in</SPAN> standAloneTables<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                <SPAN class="keyword token">string</SPAN> sAPath <SPAN class="operator token">=</SPAN> sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>sAPath<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                                Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>sAPath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                <SPAN class="punctuation token">{</SPAN>
                                    removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                    sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                    
                                <SPAN class="punctuation token">}</SPAN>                                                                
                            <SPAN class="punctuation token">}</SPAN>

                            Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN><SPAN class="token function">RemoveStandaloneTables</SPAN><SPAN class="punctuation token">(</SPAN>removalStandAloneTables<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                                <SPAN class="keyword token">var</SPAN> dispData <SPAN class="operator token">=</SPAN> removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>AbsolutePath<SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>
                            <SPAN class="keyword token">catch</SPAN>
                            <SPAN class="punctuation token">{</SPAN>

                            <SPAN class="punctuation token">}</SPAN>

                            <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="punctuation token">}</SPAN>
                        
                    <SPAN class="punctuation token">}</SPAN>
                                                                          
                    <SPAN class="keyword token">else</SPAN>
                        <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="punctuation token">}</SPAN>
            <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">async</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">launchBaconAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">try</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">await</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    <SPAN class="keyword token">object</SPAN> myCommand <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\Scripts\FutureBacon.bat"</SPAN><SPAN class="punctuation token">;</SPAN>

                    System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>ProcessStartInfo procStartInfo <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>ProcessStartInfo</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"cmd"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"/c"</SPAN> <SPAN class="operator token">+</SPAN> myCommand<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    procStartInfo<SPAN class="punctuation token">.</SPAN>RedirectStandardOutput <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">;</SPAN>
                    procStartInfo<SPAN class="punctuation token">.</SPAN>UseShellExecute <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
                    procStartInfo<SPAN class="punctuation token">.</SPAN>CreateNoWindow <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">;</SPAN>

                    System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>Process proc <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>Process</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    proc<SPAN class="punctuation token">.</SPAN>StartInfo <SPAN class="operator token">=</SPAN> procStartInfo<SPAN class="punctuation token">;</SPAN>
                    proc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Start</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="comment token">//string result = proc.StandardOutput.ReadToEnd();</SPAN>
                    <SPAN class="keyword token">string</SPAN> result <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Features selected.  See Python Window"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">//ArcGIS.Desktop.Framework.Dialogs.MessageBox.Show(result);</SPAN>
                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
            <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">.</SPAN>MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>Message<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">protected</SPAN> <SPAN class="keyword token">override</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">OnClick</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">try</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">var</SPAN> prog <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ProgressDialog</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Gathering Route Info..."</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                prog<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="keyword token">var</SPAN> lyr <SPAN class="operator token">=</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetLayersAsFlattenedList</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>OfType<SPAN class="operator token"><</SPAN>FeatureLayer<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>l <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> l<SPAN class="punctuation token">.</SPAN>Name<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"TxDOT_Roadways_Edits"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">var</SPAN> selectionfromMap <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetSelection</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="keyword token">var</SPAN> gidList <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">var</SPAN> oids <SPAN class="operator token">=</SPAN> selectionfromMap<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetObjectIDs</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToList</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">int</SPAN> count <SPAN class="operator token">=</SPAN> oids<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="keyword token">var</SPAN> insp <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Editing<SPAN class="punctuation token">.</SPAN>Attributes<SPAN class="punctuation token">.</SPAN>Inspector</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN> futureDict <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Dictionary</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>



                    <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> oid <SPAN class="keyword token">in</SPAN> oids<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        insp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Clear</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        insp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Load</SPAN><SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> oid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN> futureNestedDict <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Dictionary</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                        <SPAN class="keyword token">var</SPAN> gid <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"GID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> editOp <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"EDIT_TYPE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="comment token">//FUTURE BACON DICT PARAMETERS</SPAN>
                        <SPAN class="keyword token">var</SPAN> OGEOMS <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> BEGIN_DFO <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> END_DFO <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> ETL_JOB_ID <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ETL_JOB_ID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>editOp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Retire"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="keyword token">continue</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> OGEOMS<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> BEGIN_DFO<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> END_DFO<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ETL_JOB_ID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> ETL_JOB_ID<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"IN_GRID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"True"</SPAN><SPAN class="punctuation token">;</SPAN>

                        futureDict<SPAN class="punctuation token">[</SPAN>gid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> futureNestedDict<SPAN class="punctuation token">;</SPAN>
                        gidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>gid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                    List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN> removeGidList <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>OracleConnection oc <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">OracleConnection</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        oc<SPAN class="punctuation token">.</SPAN>ConnectionString <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Data Source=*******;USER ID=*********;Password=*******"</SPAN><SPAN class="punctuation token">;</SPAN>
                        oc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Open</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">var</SPAN> chunks <SPAN class="operator token">=</SPAN> <SPAN class="token function">SplitList</SPAN><SPAN class="punctuation token">(</SPAN>gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> chunk <SPAN class="keyword token">in</SPAN> chunks<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>


                            <SPAN class="keyword token">var</SPAN> chunkListJoin <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> chunk<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">string</SPAN> sql <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SELECT RDBD_GMTRY_LN_ID FROM GRIDOP.RDBD_GMTRY_LN WHERE GRIDOP.RDBD_GMTRY_LN.RDBD_GMTRY_LN_ID IN ({0})"</SPAN><SPAN class="punctuation token">,</SPAN> chunkListJoin<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            OracleDataAdapter oda <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">OracleDataAdapter</SPAN><SPAN class="punctuation token">(</SPAN>sql<SPAN class="punctuation token">,</SPAN> oc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            DataTable dt <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">DataTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            oda<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Fill</SPAN><SPAN class="punctuation token">(</SPAN>dt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN>DataRow dr <SPAN class="keyword token">in</SPAN> dt<SPAN class="punctuation token">.</SPAN>Rows<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                removeGidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Remove</SPAN><SPAN class="punctuation token">(</SPAN>dr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>

                        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Not in GRID: "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> removeGidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"In GRID: "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> g <SPAN class="keyword token">in</SPAN> removeGidList<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            futureDict<SPAN class="punctuation token">[</SPAN>g<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"IN_GRID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>

                        oc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Close</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                    <SPAN class="comment token">//Write string to file</SPAN>
                    System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>FileInfo file <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>FileInfo</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    file<SPAN class="punctuation token">.</SPAN>Directory<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Create</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> outFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        <SPAN class="keyword token">long</SPAN> gCount <SPAN class="operator token">=</SPAN> gidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">long</SPAN> curCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> arr <SPAN class="keyword token">in</SPAN> gidList<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>curCount <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>

                            <SPAN class="comment token">//System.Diagnostics.Trace.WriteLine(arr);</SPAN>
                            <SPAN class="comment token">//System.Diagnostics.Trace.WriteLine(futureDict[arr]);</SPAN>
                            String dString <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0}:{{\"OGEOMS\":\"{1}\",\"BEGIN_DFO\":{2},\"END_DFO\":{3}}}"</SPAN><SPAN class="punctuation token">,</SPAN>
                                arr<SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>dString<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>curCount <SPAN class="operator token"><</SPAN> gCount<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>
                            <SPAN class="keyword token">else</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"}"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>
                            curCount <SPAN class="operator token">=</SPAN> curCount <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                prog<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                <SPAN class="comment token">//Check append option</SPAN>
                <SPAN class="token function">appendOptionAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>                

                <SPAN class="token function">launchBaconAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN> 

            <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>Message<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="comment token">//Module1.CreateNotification("Adding Layer... Will take a minute or so", "Roadways Edits Not Found");</SPAN>
                <SPAN class="comment token">//, @"Images\Bacon16.png");</SPAN>


                <SPAN class="keyword token">var</SPAN> Datapath <SPAN class="operator token">=</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    DatabaseConnectionProperties connectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">DatabaseConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN>EnterpriseDatabaseType<SPAN class="punctuation token">.</SPAN>SQLServer<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        AuthenticationMode <SPAN class="operator token">=</SPAN> AuthenticationMode<SPAN class="punctuation token">.</SPAN>OSA<SPAN class="punctuation token">,</SPAN>
                        Instance <SPAN class="operator token">=</SPAN> <SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN>
                        Database <SPAN class="operator token">=</SPAN> <SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN>
                        Version <SPAN class="operator token">=</SPAN> <SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN>
                    <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>


                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase enterpriseGeodatabaseViaConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN>connectionProperties<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>

                        <SPAN class="keyword token">var</SPAN> gdbPath <SPAN class="operator token">=</SPAN> enterpriseGeodatabaseViaConnectionProperties<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">return</SPAN> gdbPath<SPAN class="punctuation token">.</SPAN>LocalPath<SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">string</SPAN> rdwaysEnd <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"TPP_GIS.APP_TPP_GIS_ADMIN.Roadways_Edits\TPP_GIS.APP_TPP_GIS_ADMIN.TxDOT_Roadways_Edits"</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">string</SPAN> fullRdwayPath <SPAN class="operator token">=</SPAN> Path<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Combine</SPAN><SPAN class="punctuation token">(</SPAN>Datapath<SPAN class="punctuation token">.</SPAN>Result<SPAN class="punctuation token">,</SPAN> rdwaysEnd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                Uri rdUri <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>fullRdwayPath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> LayerFactory<SPAN class="punctuation token">.</SPAN>Instance<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateLayer</SPAN><SPAN class="punctuation token">(</SPAN>rdUri<SPAN class="punctuation token">,</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>

        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Find more posts tagged with

Accepted answers

RichRuh

John,

I haven't analyzed all of your code, but this loop in AppendOptionAsync is going to keep locks around:

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>
  removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
  sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>                                 
<SPAN class="punctuation token">}</SPAN>   <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here's a better way to do this:

<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Table myTable <SPAN class="operator token">=</SPAN> sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Datastore myDatastore <SPAN class="operator token">=</SPAN> myTable<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>  
  <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>myDatastore<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
 <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here I'm disposing both the table and the datasource.

Likewise, this code isn't doing what you want it to:

<SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> t <SPAN class="keyword token">in</SPAN> removalStandAloneTables<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>
  t<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The loop portion is getting a table pointer, and then removing it (no effect whatsoever).

The last line is getting a table point, then getting a datastore pointer, then disposing the datastore pointer (leaving the table pointer behind).

You can remove this entire code block.

There's more documentation on how to properly dispose of geodatabase objects here.

--Rich

All comments

RichRuh

I haven't analyzed the entire code snippet, but this line:

<SPAN class="keyword token">var</SPAN> dispData <SPAN class="operator token">=</SPAN> removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>AbsolutePath<SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Is going to create a Table and a Geodatabase object that are not disposed. They could keep a lock until .NET garbage collection runs.

JohnPhillipsGeo

Rich,

I was able to completely remove that line as it wasn't being used anymore (it was from some previous troubleshooting)

The weird thing is that as soon as I press the button again, the locks immediately disappear.

Is there a method to check for and clear locks specifically?

Thanks!

JP

JohnPhillipsGeo

Rich,

I cleaned up the appendOptionAsync() code (where the error is occurring) so that the QueuedTask only runs on the for loop.

I then attempted to RemoveStandaloneTables outside of that QueuedTask and got a different error:

Exception thrown: 'System.UnauthorizedAccessException' in ArcGIS.Desktop.Mapping.dll
An exception of type 'System.UnauthorizedAccessException' occurred in ArcGIS.Desktop.Mapping.dll but was not handled in user code
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

I think this may mean that the locks are somehow persisting inside of that loop.

Anyways, thanks for the help just wanted to throw that out there.

JP

<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Collections<SPAN class="punctuation token">.</SPAN>Generic<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Linq<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Catalog<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Geoprocessing<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Contracts<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Threading<SPAN class="punctuation token">.</SPAN>Tasks<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Mapping<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> Oracle<SPAN class="punctuation token">.</SPAN>ManagedDataAccess<SPAN class="punctuation token">.</SPAN>Client<SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">namespace</SPAN> BulkLoadTool
<SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">internal</SPAN> <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Bacon</SPAN> <SPAN class="punctuation token">:</SPAN> Button
    <SPAN class="punctuation token">{</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">static</SPAN> IEnumerable<SPAN class="operator token"><</SPAN>List<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN> SplitList<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>List<SPAN class="operator token"><</SPAN>T<SPAN class="operator token">></SPAN> locations<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">int</SPAN> nSize <SPAN class="operator token">=</SPAN> <SPAN class="number token">1000</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">int</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> locations<SPAN class="punctuation token">.</SPAN>Count<SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> nSize<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">yield</SPAN> <SPAN class="keyword token">return</SPAN> locations<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetRange</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> Math<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Min</SPAN><SPAN class="punctuation token">(</SPAN>nSize<SPAN class="punctuation token">,</SPAN> locations<SPAN class="punctuation token">.</SPAN>Count <SPAN class="operator token">-</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">async</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">appendOptionAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>

            <SPAN class="keyword token">string</SPAN> selGDBitem <SPAN class="operator token">=</SPAN> Module1<SPAN class="punctuation token">.</SPAN>Current<SPAN class="punctuation token">.</SPAN>GDBdropdown<SPAN class="punctuation token">.</SPAN>SelectedItem<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                
                <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>selGDBitem <SPAN class="operator token">==</SPAN> <SPAN class="string token">""</SPAN> <SPAN class="operator token">||</SPAN> selGDBitem <SPAN class="operator token">==</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="punctuation token">}</SPAN>

                <SPAN class="keyword token">else</SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="keyword token">string</SPAN> appString <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Would you like to append to {0}?"</SPAN><SPAN class="punctuation token">,</SPAN> selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">var</SPAN> appResult <SPAN class="operator token">=</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">.</SPAN>MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN>appString<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Append Features"</SPAN><SPAN class="punctuation token">,</SPAN> MessageBoxButton<SPAN class="punctuation token">.</SPAN>YesNo<SPAN class="punctuation token">,</SPAN> MessageBoxImage<SPAN class="punctuation token">.</SPAN>Information<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>appResult <SPAN class="operator token">==</SPAN> MessageBoxResult<SPAN class="punctuation token">.</SPAN>Yes<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>                      

                        <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            <SPAN class="comment token">//try</SPAN>
                            <SPAN class="comment token">//{</SPAN>

                            appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"True"</SPAN><SPAN class="punctuation token">,</SPAN> selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            IReadOnlyList<SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN> standAloneTables <SPAN class="operator token">=</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN>StandaloneTables<SPAN class="punctuation token">;</SPAN>
                            List<SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN> removalStandAloneTables <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN>StandaloneTable<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">var</SPAN> rStandAloneTables <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">await</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                        
                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> sATbl <SPAN class="keyword token">in</SPAN> standAloneTables<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                                <SPAN class="punctuation token">{</SPAN>
                                    removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                    sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>                                 
                                <SPAN class="punctuation token">}</SPAN>                                                                
                            <SPAN class="punctuation token">}</SPAN>

                            <SPAN class="keyword token">return</SPAN> removalStandAloneTables<SPAN class="punctuation token">;</SPAN>

                        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN><SPAN class="token function">RemoveStandaloneTables</SPAN><SPAN class="punctuation token">(</SPAN>rStandAloneTables<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                            <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> t <SPAN class="keyword token">in</SPAN> removalStandAloneTables<SPAN class="punctuation token">)</SPAN>
                                <SPAN class="punctuation token">{</SPAN>
                                    t<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                                <SPAN class="punctuation token">}</SPAN>

                            removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="comment token">//}</SPAN>
                            <SPAN class="comment token">//catch</SPAN>
                            <SPAN class="comment token">//{</SPAN>

                            <SPAN class="comment token">//}</SPAN>
                            <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>                        
                    <SPAN class="punctuation token">}</SPAN>
                                                                          
                    <SPAN class="keyword token">else</SPAN>
                        <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> appFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\appendOption.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            appFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},\"{1}\""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                            <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="punctuation token">}</SPAN>
            
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">async</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">launchBaconAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">try</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">await</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    <SPAN class="keyword token">object</SPAN> myCommand <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\Scripts\FutureBacon.bat"</SPAN><SPAN class="punctuation token">;</SPAN>

                    System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>ProcessStartInfo procStartInfo <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>ProcessStartInfo</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"cmd"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"/c"</SPAN> <SPAN class="operator token">+</SPAN> myCommand<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    procStartInfo<SPAN class="punctuation token">.</SPAN>RedirectStandardOutput <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">;</SPAN>
                    procStartInfo<SPAN class="punctuation token">.</SPAN>UseShellExecute <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
                    procStartInfo<SPAN class="punctuation token">.</SPAN>CreateNoWindow <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">;</SPAN>

                    System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>Process proc <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>Diagnostics<SPAN class="punctuation token">.</SPAN>Process</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    proc<SPAN class="punctuation token">.</SPAN>StartInfo <SPAN class="operator token">=</SPAN> procStartInfo<SPAN class="punctuation token">;</SPAN>
                    proc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Start</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="comment token">//string result = proc.StandardOutput.ReadToEnd();</SPAN>
                    <SPAN class="keyword token">string</SPAN> result <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Features selected.  See Python Window"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">//ArcGIS.Desktop.Framework.Dialogs.MessageBox.Show(result);</SPAN>
                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
            <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Framework<SPAN class="punctuation token">.</SPAN>Dialogs<SPAN class="punctuation token">.</SPAN>MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>Message<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">protected</SPAN> <SPAN class="keyword token">override</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">OnClick</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">try</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">var</SPAN> prog <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ProgressDialog</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Gathering Route Info..."</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                prog<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="keyword token">var</SPAN> lyr <SPAN class="operator token">=</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetLayersAsFlattenedList</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>OfType<SPAN class="operator token"><</SPAN>FeatureLayer<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>l <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> l<SPAN class="punctuation token">.</SPAN>Name<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"TxDOT_Roadways_Edits"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">//var lyr = MapView.Active.Map.GetLayersAsFlattenedList().OfType<FeatureLayer>().FirstOrDefault();</SPAN>
                    <SPAN class="keyword token">var</SPAN> selectionfromMap <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetSelection</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="keyword token">var</SPAN> gidList <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">//var removeGidList = new List<string>();</SPAN>

                    <SPAN class="keyword token">var</SPAN> oids <SPAN class="operator token">=</SPAN> selectionfromMap<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetObjectIDs</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToList</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="keyword token">int</SPAN> count <SPAN class="operator token">=</SPAN> oids<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="keyword token">var</SPAN> insp <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Editing<SPAN class="punctuation token">.</SPAN>Attributes<SPAN class="punctuation token">.</SPAN>Inspector</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN> futureDict <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Dictionary</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                    <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> oid <SPAN class="keyword token">in</SPAN> oids<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        insp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Clear</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        insp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Load</SPAN><SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> oid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        Dictionary<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN> futureNestedDict <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Dictionary</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                        <SPAN class="keyword token">var</SPAN> gid <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"GID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> editOp <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"EDIT_TYPE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="comment token">//FUTURE BACON DICT PARAMETERS</SPAN>
                        <SPAN class="keyword token">var</SPAN> OGEOMS <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> BEGIN_DFO <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> END_DFO <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">var</SPAN> ETL_JOB_ID <SPAN class="operator token">=</SPAN> insp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ETL_JOB_ID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>editOp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Retire"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="keyword token">continue</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> OGEOMS<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> BEGIN_DFO<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> END_DFO<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ETL_JOB_ID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> ETL_JOB_ID<SPAN class="punctuation token">;</SPAN>
                        futureNestedDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"IN_GRID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"True"</SPAN><SPAN class="punctuation token">;</SPAN>

                        futureDict<SPAN class="punctuation token">[</SPAN>gid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> futureNestedDict<SPAN class="punctuation token">;</SPAN>

                        <SPAN class="comment token">//System.Diagnostics.Trace.WriteLine(gid);</SPAN>

                        gidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>gid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                    List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN> removeGidList <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>OracleConnection oc <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">OracleConnection</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        oc<SPAN class="punctuation token">.</SPAN>ConnectionString <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Data Source=********;USER ID=*********;Password=*******"</SPAN><SPAN class="punctuation token">;</SPAN>
                        oc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Open</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">var</SPAN> chunks <SPAN class="operator token">=</SPAN> <SPAN class="token function">SplitList</SPAN><SPAN class="punctuation token">(</SPAN>gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> chunk <SPAN class="keyword token">in</SPAN> chunks<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>


                            <SPAN class="keyword token">var</SPAN> chunkListJoin <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> chunk<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">string</SPAN> sql <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SELECT RDBD_GMTRY_LN_ID FROM GRIDOP.RDBD_GMTRY_LN WHERE GRIDOP.RDBD_GMTRY_LN.RDBD_GMTRY_LN_ID IN ({0})"</SPAN><SPAN class="punctuation token">,</SPAN> chunkListJoin<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            OracleDataAdapter oda <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">OracleDataAdapter</SPAN><SPAN class="punctuation token">(</SPAN>sql<SPAN class="punctuation token">,</SPAN> oc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            DataTable dt <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">DataTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            oda<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Fill</SPAN><SPAN class="punctuation token">(</SPAN>dt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN>DataRow dr <SPAN class="keyword token">in</SPAN> dt<SPAN class="punctuation token">.</SPAN>Rows<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                removeGidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Remove</SPAN><SPAN class="punctuation token">(</SPAN>dr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>

                        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Not in GRID: "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> removeGidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"In GRID: "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN> gidList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> g <SPAN class="keyword token">in</SPAN> removeGidList<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            futureDict<SPAN class="punctuation token">[</SPAN>g<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"IN_GRID"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"False"</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>

                        oc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Close</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                    <SPAN class="comment token">//Write string to file</SPAN>
                    System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>FileInfo file <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>FileInfo</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    file<SPAN class="punctuation token">.</SPAN>Directory<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Create</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">//System.IO.File.WriteAllLines(@"C:\TxDOT\BulkLoad\LayerReference\configFiles\writeGIDs.log", gidList.Select(x => string.Join(",", x)));</SPAN>
                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> outFile <SPAN class="operator token">=</SPAN> System<SPAN class="punctuation token">.</SPAN>IO<SPAN class="punctuation token">.</SPAN>File<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">@"C:\TxDOT\BulkLoad\LayerReference\configFiles\futureBaconDict.log"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        <SPAN class="keyword token">long</SPAN> gCount <SPAN class="operator token">=</SPAN> gidList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">long</SPAN> curCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> arr <SPAN class="keyword token">in</SPAN> gidList<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>curCount <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>

                            <SPAN class="comment token">//System.Diagnostics.Trace.WriteLine(arr);</SPAN>
                            <SPAN class="comment token">//System.Diagnostics.Trace.WriteLine(futureDict[arr]);</SPAN>
                            String dString <SPAN class="operator token">=</SPAN> String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0}:{{\"OGEOMS\":\"{1}\",\"BEGIN_DFO\":{2},\"END_DFO\":{3}}}"</SPAN><SPAN class="punctuation token">,</SPAN>
                                arr<SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OGEOMS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BEGIN_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                futureDict<SPAN class="punctuation token">[</SPAN>arr<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"END_DFO"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="comment token">//String dString = String.Format("{0}:{{\"OGEOMS\":\"{1}\",\"IN_GRID\":{2}}}"</SPAN>
                            <SPAN class="comment token">//String dString = String.Format("{0}:{{\"OGEOMS\":\"{1}\"}}",</SPAN>
                            <SPAN class="comment token">//    arr,</SPAN>
                            <SPAN class="comment token">//    futureDict[arr]["OGEOMS"]</SPAN>
                            <SPAN class="comment token">//    );</SPAN>
                            <SPAN class="comment token">//,</SPAN>
                            <SPAN class="comment token">//futureDict[arr]["IN_GRID"]);</SPAN>

                            outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN>dString<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>curCount <SPAN class="operator token"><</SPAN> gCount<SPAN class="punctuation token">)</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>
                            <SPAN class="keyword token">else</SPAN>
                            <SPAN class="punctuation token">{</SPAN>
                                outFile<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Write</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"}"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="punctuation token">}</SPAN>
                            curCount <SPAN class="operator token">=</SPAN> curCount <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="punctuation token">}</SPAN>

                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                prog<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


                <SPAN class="comment token">//Wait for Task to finish</SPAN>
                result<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Wait</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="token function">appendOptionAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                GC<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Collect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                GC<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WaitForPendingFinalizers</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="token function">launchBaconAsync</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>

            <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                Trace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>Message<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">return</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="comment token">//Module1.CreateNotification("Adding Layer... Will take a minute or so", "Roadways Edits Not Found");</SPAN>
                <SPAN class="comment token">//, @"Images\Bacon16.png");</SPAN>


                <SPAN class="keyword token">var</SPAN> Datapath <SPAN class="operator token">=</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
                <SPAN class="punctuation token">{</SPAN>

                    DatabaseConnectionProperties connectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">DatabaseConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN>EnterpriseDatabaseType<SPAN class="punctuation token">.</SPAN>SQLServer<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        <SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN><SPAN class="operator token">*</SPAN>
                    <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>


                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase enterpriseGeodatabaseViaConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN>connectionProperties<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>

                        <SPAN class="keyword token">var</SPAN> gdbPath <SPAN class="operator token">=</SPAN> enterpriseGeodatabaseViaConnectionProperties<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">return</SPAN> gdbPath<SPAN class="punctuation token">.</SPAN>LocalPath<SPAN class="punctuation token">;</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">string</SPAN> rdwaysEnd <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"TPP_GIS.APP_TPP_GIS_ADMIN.Roadways_Edits\TPP_GIS.APP_TPP_GIS_ADMIN.TxDOT_Roadways_Edits"</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">string</SPAN> fullRdwayPath <SPAN class="operator token">=</SPAN> Path<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Combine</SPAN><SPAN class="punctuation token">(</SPAN>Datapath<SPAN class="punctuation token">.</SPAN>Result<SPAN class="punctuation token">,</SPAN> rdwaysEnd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                Uri rdUri <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>fullRdwayPath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> LayerFactory<SPAN class="punctuation token">.</SPAN>Instance<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateLayer</SPAN><SPAN class="punctuation token">(</SPAN>rdUri<SPAN class="punctuation token">,</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>

        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RichRuh

John,

I haven't analyzed all of your code, but this loop in AppendOptionAsync is going to keep locks around:

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>
  removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
  sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>                                 
<SPAN class="punctuation token">}</SPAN>   <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here's a better way to do this:

<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Table myTable <SPAN class="operator token">=</SPAN> sATbl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Datastore myDatastore <SPAN class="operator token">=</SPAN> myTable<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>  
  <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>myDatastore<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>selGDBitem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>sATbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
 <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here I'm disposing both the table and the datasource.

Likewise, this code isn't doing what you want it to:

<SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> t <SPAN class="keyword token">in</SPAN> removalStandAloneTables<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>
  t<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

removalStandAloneTables<SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetTable</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetDatastore</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The loop portion is getting a table pointer, and then removing it (no effect whatsoever).

The last line is getting a table point, then getting a datastore pointer, then disposing the datastore pointer (leaving the table pointer behind).

You can remove this entire code block.

There's more documentation on how to properly dispose of geodatabase objects here.

--Rich

JohnPhillipsGeo

Rich,

Thanks for solving yet another one of my issues! The using statement did the trick. I didn't realize that I wasn't disposing the underlying datasource correctly.

I will definitely be using the 'using' statement more.

You are the man! Have a great weekend and thanks

JP

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.