def layout(self, columns):
fullcol = [(self.column_id, 'bigint'),
(self.column_kind, 'char(1)')]
fullcol.extend(columns)
PGTable.layout(self, fullcol)
self.add_geometry_column(self.column_geom, self.srid,
'POINT', with_index=True)
def layout(self, columns):
""" Layout the table as specified in PGTable.layout() but
it will add a column for the OSM id. The name of the column
is specified in 'column_id'.
"""
fullcol = [(self.column_id, 'bigint PRIMARY KEY')]
fullcol.extend(columns)
PGTable.layout(self, fullcol)
def __init__(self, db, name="relations_hier", subset=None):
PGTable.__init__(self, db, name)
if subset is None:
self._subset = """SELECT DISTINCT relation_id
FROM relation_members
WHERE relation_type = 'R'"""
else:
self._subset = subset
def layout(self, columns):
""" Layout the table as specified in PGTable.layout() but
it will add a column for the OSM id. The name of the column
is specified in 'column_id'.
"""
fullcol = [(self.column_id, 'bigint PRIMARY KEY')]
fullcol.extend(columns)
PGTable.layout(self, fullcol)
self.add_geometry_column(self.column_geom, self.srid, 'GEOMETRY', with_index=True)
def __init__(self, db, basetable, name, subset):
PGTable.__init__(self, db, name)
updateset = "%s IN (SELECT id FROM %s_changeset WHERE action <> 'D')" % \
(self.column_id, basetable)
if subset is None:
self.wherequery = ""
self.updatequery = "WHERE %s"% updateset
else:
self.wherequery = "WHERE %s" % subset
self.updatequery = "WHERE %s AND %s" % (subset, updateset)
self.basetable = basetable
def __init__(self, db, name, subset, transform="%s"):
PGTable.__init__(self, db, name)
if subset is None:
self.wherequery = "SELECT id, tags, geom FROM nodes"
self.updatequery = "SELECT id, tags, geom FROM node_changeset WHERE action <> 'D'"
else:
self.wherequery = "SELECT id, tags, geom FROM nodes WHERE %s" % subset
self.updatequery = "SELECT id, tags, geom FROM node_changeset WHERE action <> 'D' AND %s" % (subset)
if self.srid != "4326":
transform = "ST_Transform(%s, %s)" % (transform, self.srid)
self.transform = transform
def __init__(self, db, name, subset):
PGTable.__init__(self, db, name)
updateset = "WHERE id = ANY(ARRAY(SELECT id FROM %s_changeset WHERE action <> 'D'))"
if subset is None:
wherequery = "WHERE tags is not null"
else:
wherequery = "WHERE %s" % subset
updateset = "%s AND %s" % (updateset, subset)
self.node_construct = 'SELECT id, tags, geom FROM nodes %s' % wherequery
self.way_construct = 'SELECT id, tags, ST_Centroid(osgende_way_geom(nodes)) as geom FROM ways %s' % wherequery
self.node_update = 'SELECT id, tags, geom FROM nodes %s' % updateset
self.way_update = 'SELECT id, tags, ST_Centroid(osgende_way_geom(nodes)) as geom FROM ways %s' % updateset
if self.srid == '4326':
transform = '%s'
else:
transform = 'ST_Transform(%%s, %s)' % self.srid
self.transform = transform
def __init__(self, db, name):
PGTable.__init__(self, db, name)
def __init__(self,db):
PGTable.__init__(self, db,
name=conf.DB_DEFAULT_STYLE_TABLE)
def __init__(self, db):
PGTable.__init__(self, db, name=conf.DB_DEFAULT_STYLE_TABLE)
def __init__(self, db, mastertable, name="joined_ways"):
PGTable.__init__(self, db, name)
self.master_table = mastertable
def __init__(self, db, name, subset, country_table=None, country_column='code', uptable=None):
PGTable.__init__(self, db, name)
self.subset = subset
self.country_table = country_table
self.country_column = country_column
self.update_table = uptable