Leaving the GIS industry: bye for now

Alex Tereshenkov

After working for more than 10 years in geospatial industry, I have decided to change the field and focus on pure software engineering. I have quite enjoyed using GIS tools to solve various computational problems and software development tools to build useful GIS products and services for my customers. However, as my interests starting shifting towards clean code and programming per se – I have noticed I was reading in the bed Refactoring by Martin Fowler way more often than The ESRI guide to GIS analysis by Andy Mitchell – so I thought it would be useful to try changing the career path.

As I won’t be using any of the GIS software any longer, I won’t be able to post any new practical material that would be useful to GIS analysts and developers. However, in this post I would like to share some of the last thoughts I have…

View original post 2,176 more words

Editing Shapefile DBF

Excel 2007 is the last version that supported in place editing of .dbf files. Access 2010 is the last version that can import .dbf files (though Excel 2010 and 2013 can still read them, via drag and drop). What to do?

If it’s Excel’s usability you’re after (extended search and replace, repeat previous values, fill, …) and you can change the default storage format: use personal-geodatabase instead of shapefiles. Then you can just open the .mdb in Access and edit there or push/pull from .xls as needed.

Remember it’s important to keep the ObjectID or FID intact, so no adding or deleting rows from the Access and Excel side, and be careful to only touch the feature class tables. As long as you keep backups and tread with care and attention you’ll be fine.

An added benefit is being able to use Longer_Field_Names and increased row limits.

…

For just get up and go without any changes to formats or workflow the best current method I’ve found for direct editing of DBF files outside of ArcGIS is via DBF Viewer Plus. It free and comes in a single file portable executable (voluntary payment asked for, no nagging though).

In the event DBF Viewer Plus disappears my next fall back would be DBF Manager, $45 – $60 USD.

If it’s important to stay inside Excel, then the route is with SaveDBF addon, but note development and support stopped as of January 2015 so this is only an interim solution.

A heavy weight solution which should work pretty much in perpetuity is LibreOffice or OpenOffice.

Further reading

• DBF creation and manipulation without excel 2003