Thursday, March 17, 2016

Post 2: Python Script

Introduction

The purpose of this post is to show the skills I have learned using python script. 
Figure 1: First Python Script

Figure 1 shows the python script I used to list out the raster datasets I had, put them all into one geodatabase (TMP.gdb) project them all into the same coordinate system and extract each of the datasets from the Trempealeau county boundary.

 Figure 2: Second Python Script

Figure 2 shows the python script I used to set up SQL statements that would select mines that were:

  • Active
  • Had "Mine" in the facility type field
  • All mines that did not have the word "rail" in the facility type
  • All mines that are 1.5 Kilometers or more from a rail road
This selected 44 mines out of the original 129 mines, that met this criteria.