def import_energie_labels(datadir):
# energie labels (van maps.amsterdam.nl open geodata)
pg_str = get_ogr2ogr_pgstr()
esri_json2psql(os.path.join(datadir, 'energie_labels',
'ENERGIE_LABELS.json'),
pg_str,
'energie_labels_raw',
t_srs=SRS_TO_STORE)
run_sql(_CUSTOM_SQL)
def import_warmtekoude(datadir):
# Stads warmte / koude net:
pg_str = get_ogr2ogr_pgstr()
esri_json2psql(os.path.join(datadir, 'warmtekoude',
'STADSWARMTEKOUDE.json'),
pg_str,
'warmtekoude_raw',
t_srs=SRS_TO_STORE)
run_sql(_CUSTOM_SQL)
def import_corporatie_bezit(datadir):
"""
Import maps.amsterdam.nl derived map of housing corporation property.
"""
pg_str = get_ogr2ogr_pgstr()
esri_json2psql(os.path.join(datadir, 'corporatie_bezit', 'AFWC_2017.json'),
pg_str,
'afwc2017_raw',
t_srs=SRS_TO_STORE)
run_sql(_CUSTOM_SQL)
def import_mip(datadir):
"""
Import multi year investment plan 2016.
"""
pg_str = get_ogr2ogr_pgstr()
esri_json2psql(
os.path.join(datadir, 'mip', 'MIP2016.json'),
pg_str,
'mip2016_raw',
t_srs=SRS_TO_STORE
)
run_sql(_CUSTOM_SQL)
def import_renovaties(datadir):
"""
Import maps.amsterdam.nl derived map of housing corporation property.
"""
run_sql("DROP TABLE IF EXISTS public.renovaties_raw;")
pg_str = get_ogr2ogr_pgstr()
shp2psql(os.path.join(datadir, 'renovaties',
'renovatiesperbuurtvanaf2017_region.shp'),
pg_str,
'renovaties_raw',
t_srs=SRS_TO_STORE,
s_srs='EPSG:28992')
run_sql(_CUSTOM_SQL)
def reindex_bag_buurt():
"""
Run additional SQL after restoring BAG buurt table.
(reproject and add a spatial index)
"""
sql = """
ALTER TABLE "bag_buurt"
ALTER COLUMN "geometrie"
type Geometry(MultiPolygon, 4326)
USING ST_Transform("geometrie", 4326);
DROP INDEX IF EXISTS bag_buurt_idx;
CREATE INDEX bag_buurt_idx ON public.bag_buurt USING GIST(geometrie);
"""
run_sql(sql)
run_sql("""VACUUM ANALYZE public.bag_buurt;""")