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;""")