In [16]:

    

import MySQLdb
import numpy as np
%matplotlib inline
import matplotlib.pyplot as plt
plt.rcParams['figure.figsize'] = (10.0, 10.0)
plt.rcParams['image.aspect'] = 'equal'
plt.rcParams['figure.dpi'] = 300


    

In [17]:

    

def get_database_conn():
  connection = MySQLdb.connect('localhost', 'root', '', 'insight')
  cursor = connection.cursor()
  return connection, cursor
connection, cursor = get_database_conn()


    

In [42]:

    

def get_contour(i):
    #cursor.execute("SELECT * FROM contours WHERE id = %s", (str(i)))
    query = "SELECT * FROM contours WHERE id = %s WHERE reg = 'CA'" % i
    cursor.execute(query)
    result = cursor.fetchall()
    lats = np.fromstring(result[0][-2], sep=',')
    lons = np.fromstring(result[0][-1], sep=',')
    return np.array([lats, lons])
def show_contour(i):
    contour = get_contour(i)
    plt.scatter(contour[1], contour[0])
    
def get_all_antennas():
    query = "SELECT antlat, antlon FROM contours WHERE antlon < -50 AND antlon > -125 AND antlat < 50 AND antlat > 20"
    cursor.execute(query)
    result = cursor.fetchall()
    return np.array(result)
def show_all_antennas():
    locs = get_all_antennas()
    plt.scatter(locs[:,1], locs[:,0])


    

In [43]:

    

ax =plt.gca()
ax.set_aspect('equal')
print show_all_antennas()
plt.draw()


    

    




None






    

In [20]: