PostgresOSM.subregion_table_exists

PostgresOSM.subregion_table_exists(subregion_name, layer_name, table_named_as_subregion=False, schema_named_as_layer=False)[source]

Check if a table (for a geographic (sub)region) exists.

Parameters:

  • subregion_name (str) – name of a geographic (sub)region, which acts as a table name

  • layer_name (str) – name of an OSM layer (e.g. ‘points’, ‘railways’, …), which acts as a schema name

  • table_named_as_subregion (bool) – whether to use subregion name as table name, defaults to False

  • schema_named_as_layer (bool) – whether a schema is named as a layer name, defaults to False

Returns:

True if the table exists, False otherwise

Return type:

bool

Examples:

>>> from pydriosm.ios import PostgresOSM

>>> osmdb = PostgresOSM(database_name='osmdb_test')
Password (postgres@localhost:5432): ***
Creating a database: "osmdb_test" ... Done.
Connecting postgres:***@localhost:5432/osmdb_test ... Successfully.

>>> subrgn_name = 'London'
>>> lyr_name = 'pt'

>>> # Check whether the table "pt"."london" is available
>>> osmdb.subregion_table_exists(subregion_name=subrgn_name, layer_name=lyr_name)
False

>>> # Check whether the table "points"."greater_london" is available
>>> osmdb.subregion_table_exists(
...     subregion_name=subrgn_name, layer_name=lyr_name, table_named_as_subregion=True,
...     schema_named_as_layer=True)
False

>>> # Delete the database 'osmdb_test'
>>> osmdb.drop_database(verbose=True)
To drop the database "osmdb_test" from postgres:***@localhost:5432
? [No]|Yes: yes
Dropping "osmdb_test" ... Done.