MAC URISA 2016

How often are you in a crunch with a map request and you realize the data given to you is in multiple datasets? What about the requests which require you to update an existing GIS layer with datasets that has never been reviewed for errors or data consistency? Managing these data "Gotcha's" can be quite a headache, especially when a short turnaround is needed and there is no room for error. Using Excel and Python I will demo some approaches to help manage and organize datasets for obstacles you may face on a day to day basis. Techniques will include some tips using excel for checking your data, ETL (Extract->Transform->Load) process's for routine data uploads, and tricks for quick and easy map updates using ArcMap.