In [1]:

    

import numpy as np, pandas as pd, os


    

In [2]:

    

import psycopg2
import pandas.io.sql as sql
conn_string = "host='localhost' port=5432 dbname='drcog_backup' user='postgres' password='postgres'"
conn = psycopg2.connect(conn_string)
cur = conn.cursor()
parcel_coords = sql.read_frame('select * from parcel_coords',conn)


    

In [3]:

    

parcel_coords.tail()


    

    
Out[3]:






  

    

      

      
parcel_id
      
x
      
y
    
  
  

    

      
3162507
      
 528782
      
 3196638
      
 1710424
    
    

      
3162508
      
 528782
      
 3197942
      
 1710724
    
    

      
3162509
      
 528782
      
 3197549
      
 1710087
    
    

      
3162510
      
 528782
      
 3196717
      
 1710411
    
    

      
3162511
      
 528782
      
 3197585
      
 1710767
    
  

In [4]:

    

store = pd.HDFStore('c:\\urbansim\\data\\drcog.h5')


    

In [5]:

    

store['parcel_coords'] = parcel_coords


    

In [6]:

    

store.close()