AnsweredAssumed Answered

Schema Lock in File Geodatabase when using Python to update shapefiles.

Question asked by kundalay1 on Apr 28, 2017
Latest reply on May 1, 2017 by kundalay1

We get data from external agencies which currently is a manual process. We are working on automating this using Python. The first script looks in the download folder for shapefiles and tables and updates our SQL Server Database which is the main data source which serves data to the public. This part is working well.

 

The second part is taking the same data and updating existing File Geodatabase which is used extensively by internal users and sometimes is even faster to work from than through SQL server connection. I have a portion of code that deletes the data from the existing shapefiles which basically leads to an empty table and the second portion appends data to that table.

 

My question is, do I have to worry about schema locks since all I am doing is erasing the table rows and appending data to the table and leaving the schema unchanged.  

Outcomes