austin_pard_polygon_transform.py

import json

import psycopg2


conn = psycopg2.connect("dbname='bostongreenmap' user='django' host='localhost' password='django'")
cursor = conn.cursor()

with open('./data/city_of_austin_parks.json', 'r') as fh:
    data = fh.read()
data = json.loads(data)

crs = data['crs']

for feature in data['features']:
    geometry = feature['geometry']
    geometry['crs'] = crs

    cursor.execute('SELECT ST_AsText(ST_Transform(ST_GeomFromGeoJson(%s), 4326));', (json.dumps(geometry), ))
    print(cursor.fetchall())

cursor.close()
conn.close()