It is often the case that the freely available data online are in Excel format. If one has Excel, then one has the ability to do some sort of basic manipulation of the files. But if Excel is not available, or your analysis software does not read Excel files, there is another way: use Python to manipulate Excel files. Continue reading »
Jun 152009
Jun 112009
There are multiple problems analysts face when they have to deal with processing multiple data files. There is the issue of identifying similarities and commonalities in files, and then of course how to automate the processing so they don’t have to run a program multiple times with the same parameters of separate files. In the world of ESRI’s GIS analysis, this can be performed quite easily with the help of Geoprocessing, either in Python or the Model Builder. Below is sample code that allows the iteration over a number of datasets. Continue reading »
Jun 042009
In the many methods present at the Python interface to ArcGIS (Python geoprocessing through the arcgisscripting module), one that is quite useful when processing individual elements on a feature class is called MakeFeaturelayer(). The behavior, while predictable with a small number of runs, can prove problematic when dealing with large datasets. Continue reading »
May 202009
As may be evident from my other posts in the past, I have a tendency to use Python to solve a lot of the problems I face every day doing research in Geography. In that context, analyzing the 2002 Input Output Model for Washington State, I decided that Graph Theory needs to come into play (Economic Geograhy seems to need more Python(s) around). Continue reading »
Accessing Geometries using the Geoprocessor is an easy task when one uses Python. All you need is a cursor to a feature class and you are there. Some terminology may help, before we dive into the code. Continue reading »
