dbio module

Module for interfacing with the PostGIS database

dbio.columnExists(dbname, schemaname, tablename, colname)

Tests whether a column exists in a table.

dbio.connect(dbname)

Connect to database dbname.

dbio.createResampledCatalog(dbname)

Create catalog that holds information on resampled rasters.

dbio.createResampledTables(dbname, sname, tname, dt, tilesize, overwrite, squery='')

Cache resampled tables by using materialized views.

dbio.deleteRasters(dbname, tablename, dt, squery='')

If date already exists delete associated rasters before ingesting, and optionally constrain with subquery.

dbio.getResampledTables(dbname, options, res)

Find names of resampled raster tables.

dbio.ingest(dbname, filename, dt, stname, resample=True, overwrite=True)

Imports Geotif filename into database db.

dbio.resampleRaster(dbname, sname, tname, dt, res, method, tilesize, overwrite, squery='')

Resample raster to target resolution.

dbio.schemaExists(dbname, schemaname)

Check if schema exists in database.

dbio.tableExists(dbname, schemaname, tablename)

Check if table exists in the database.

dbio.writeGeotif(lat, lon, res, data, filename=None)

Writes Geotif in temporary directory so it can be imported into the PostGIS database.