Python Script 2

For this script, the objective was to write a number of SQL statements to select mines that meet the following criterion:

• Mine must be active
• Mine must not also be a rail loading station
• Mine must not be within 1.5km of any railroad

The script narrowed down the number of mines to 41 that met the criteria. It is shown below.