class bildstreifen(Base, Vector):
__tablename__ = 'view_bildstreifen'
__table_args__ = ({'schema': 'ads40', 'autoload': False})
__template__ = 'templates/htmlpopup/lubis_bildstreifen.mako'
__bodId__ = 'ch.swisstopo.lubis-bildstreifen'
__queryable_attributes__ = ['id']
__returnedGeometry__ = 'the_geom_footprint'
__timeInstant__ = 'bgdi_flugjahr'
__extended_info__ = True
# Composite labels
__label__ = 'flugdatum'
id = Column('bildstreifen_nr', Text, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=3, srid=21781))
the_geom_footprint = Column(
'the_geom_footprint',
Geometry(geometry_type='GEOMETRY', dimension=3, srid=21781))
flugdatum = Column('flugdatum', Text)
firma = Column('firma', Text)
filmart = Column('filmart', Text)
bgdi_flugjahr = Column('bgdi_flugjahr', Integer)
resolution = Column('resolution', Text)
objectid = Column('objectid', Text)
area = Column('area', Text)
gsd = Column('gsd', Numeric)
toposhop_length = Column('toposhop_length', Numeric)
toposhop_start_x = Column('toposhop_start_x', Integer)
toposhop_start_y = Column('toposhop_start_y', Integer)
toposhop_end_x = Column('toposhop_end_x', Integer)
toposhop_end_y = Column('toposhop_end_y', Integer)
toposhop_date = Column('toposhop_date', Text)
goal = Column('goal', Text)
class Kulturgueter(Base, Vector):
__tablename__ = 'kgs'
__table_args__ = ({'schema': 'babs', 'autoload': False})
__template__ = 'templates/htmlpopup/kgs.mako'
__bodId__ = 'ch.babs.kulturgueter'
__queryable_attributes__ = ['zkob']
__extended_info__ = True
__label__ = 'zkob'
id = Column('kgs_nr', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
zkob = Column('zkob', Text)
x = Column('x', Numeric)
y = Column('y', Numeric)
kategorie = Column('kategorie', Text)
gemeinde = Column('gemeinde', Text)
gemeinde_ehemalig = Column('gemeinde_ehemalig', Text)
objektart = Column('objektart', Text)
hausnr = Column('hausnr', Text)
adresse = Column('adresse', Text)
kurztexte = Column('kurztexte', Text)
kt_kz = Column('kt_kz', Text)
pdf_list = Column('pdf_list', Text)
link_uri = Column('link_uri', Text)
link_title = Column('link_title', Text)
link_2_uri = Column('link_2_uri', Text)
link_2_title = Column('link_2_title', Text)
link_3_uri = Column('link_3_uri', Text)
link_3_title = Column('link_3_title', Text)
class Gebaeuderegister(Base, Vector):
__tablename__ = 'adr'
__table_args__ = ({'schema': 'bfs', 'autoload': False})
__template__ = 'templates/htmlpopup/gebaeuderegister.mako'
__bodId__ = 'ch.bfs.gebaeude_wohnungs_register'
__queryable_attributes__ = [
'strname1', 'deinr', 'plz4', 'plzname', 'gdename', 'egid'
]
# __minscale__ = 5001
# due to https://redmine.bgdi.admin.ch/issues/3146 ltmoc __maxscale__ = 25000
# Composite labels
__label__ = 'strname1'
id = Column('egid_edid', Text, primary_key=True)
egid = Column('egid', Integer)
strname1 = Column('strname1', Text)
deinr = Column('deinr', Text)
plz4 = Column('plz4', Integer)
plzname = Column('plzname', Text)
gdename = Column('gdename', Text)
gdekt = Column('gdekt', Text)
dstrid = Column('dstrid', Integer)
gkplaus = Column('gkplaus', Integer)
gstat = Column('gstat', Integer)
gdenr = Column('gdenr', Integer)
ggbkr = Column('ggbkr', Text)
bgdi_created = Column('bgdi_created', Text)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
class Aeromagnetische_karte_1100(Base, Vector):
__tablename__ = 'am_1100'
__table_args__ = ({'schema': 'nagra', 'autoload': False})
__template__ = 'templates/htmlpopup/aeromagnetische_karte.mako'
__bodId__ = 'ch.nagra.aeromagnetische-karte_1100'
__label__ = 'id'
id = Column('et_id', Integer, primary_key=True)
et_fromatt_1100 = Column('et_fromatt_1100', Numeric)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class TERRITORIALREGIONEN(Base, Vector):
__tablename__ = 'territorialregionen'
__table_args__ = ({'autoload': False})
__template__ = 'templates/htmlpopup/territorialregionen.mako'
__bodId__ = 'ch.vbs.territorialregionen'
__label__ = 'name'
id = Column('terreg_nr', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
name = Column('name', Text)
class Patrouilledesglaciers_a(Base, Vector):
__tablename__ = 'patrouille_a'
__table_args__ = ({'schema': 'militaer', 'autoload': False})
__template__ = 'templates/htmlpopup/patrouilledesglaciers_a.mako'
__bodId__ = 'ch.vbs.patrouilledesglaciers-a_rennen'
__label__ = 'name'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
name = Column('name', Text)
class Maechtigkeit_lockergesteine(Base, Vector):
__tablename__ = 'maechtigkeit_lockergesteine'
__table_args__ = ({'schema': 'sgpk', 'autoload': False})
__template__ = 'templates/htmlpopup/maechtigkeit_lockergesteine.mako'
__bodId__ = 'ch.sgpk.maechtigkeit-lockergesteine'
__label__ = 'id'
id = Column('id', Integer, primary_key=True)
maechtigkeit = Column('maechtigkeit', Numeric)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Kataster_belasteten_standorte_zivflpl_Oereb(Base, Vector):
__tablename__ = 'kataster_belasteter_standorte_zivflpl_oereb'
__table_args__ = ({'schema': 'bazl', 'autoload': False})
__bodId__ = 'ch.bazl.kataster-belasteter-standorte-zivilflugplaetze.oereb'
id = Column('stabil_id', Text, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
geomType = Column('geom_type', Text)
xmlData = Column('xml_data', Text)
bgdi_created = Column('bgdi_created', Text)
data_created = Column('data_created', Text)
class Sichereitszonen_Oereb(Base, Vector):
__tablename__ = 'sichereitszonen_oereb'
__table_args__ = ({'schema': 'bazl', 'autoload': False})
__bodId__ = 'ch.bazl.sicherheitszonenplan.oereb'
id = Column('stabil_id', Text, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
geomType = Column('geom_type', Text)
xmlData = Column('xml_data', Text)
bgdi_created = Column('bgdi_created', Text)
data_created = Column('data_created', Text)
class Bundestankstellen_bebeco(Base, Vector):
__tablename__ = 'bundestankstellen_bebeco'
__table_args__ = ({'schema': 'militaer', 'autoload': False})
__template__ = 'templates/htmlpopup/bundestankstellen.mako'
__bodId__ = 'ch.vbs.bundestankstellen-bebeco'
__queryable_attributes__ = ['ort']
__label__ = 'ort'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
ort = Column('ort', Text)
class AGNES(Base, Vector):
__tablename__ = 'agnes'
__table_args__ = ({'schema': 'fpds', 'autoload': False})
__template__ = 'templates/htmlpopup/agnes.mako'
__bodId__ = 'ch.swisstopo.fixpunkte-agnes'
__label__ = 'id'
id = Column('no', Text, primary_key=True)
url = Column('url', Text)
bgdi_id = Column('bgdi_id', Integer)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
class Alpenkonvention(Base, Vector):
__tablename__ = 'alpenkonvention'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/alpenkonvention.mako'
__bodId__ = 'ch.are.alpenkonvention'
__label__ = 'stand'
id = Column('row_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
flaeche_ha = Column('flaeche_ha', Numeric)
stand = Column('stand', Numeric)
class GueteklasseOev(Base, Vector):
__tablename__ = 'gueteklassen'
__table_args__ = ({'schema': 'oeffentlicher_verkehr', 'autoload': False})
__template__ = 'templates/htmlpopup/gueteklasseoev.mako'
__bodId__ = 'ch.are.gueteklassen_oev'
__label__ = 'klasse_fr'
id = Column('id', Integer, primary_key=True)
klasse_de = Column('klasse_de', Text)
klasse_fr = Column('klasse_fr', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Gemeindetyp(Base, Vector):
__tablename__ = 'gemeindetyp_1990_9klassen'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/gemeindetyp.mako'
__bodId__ = 'ch.are.gemeindetyp-1990-9klassen'
__label__ = 'name'
id = Column('gde_no', Integer, primary_key=True)
name = Column('name', Text)
nom = Column('nom', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Beschaeftigtendichte(Base, Vector):
__tablename__ = 'beschaeftigtendichte'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/beschaeftigtendichte.mako'
__bodId__ = 'ch.are.beschaeftigtendichte'
__label__ = 'empt_ha'
id = Column('row_id', Integer, primary_key=True)
empt_ha = Column('empt_ha', Numeric)
stand = Column('stand', Numeric)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class UNESCO(Base, Vector):
__tablename__ = 'unesco'
__table_args__ = ({'autoload': False})
__template__ = 'templates/htmlpopup/unesco_bak.mako'
__bodId__ = 'ch.bak.schutzgebiete-unesco_weltkulturerbe'
__label__ = 'bgdi_name'
id = Column('bgdi_id', Integer, primary_key=True)
bgdi_name = Column('bgdi_name', Text)
bgdi_surface = Column('bgdi_surface', Text)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
class luftbilder_swisstopo_sw(Base, Vector):
__tablename__ = 'luftbilder_swisstopo_bw'
__table_args__ = ({
'schema': 'public',
'autoload': False,
'extend_existing': True
})
__template__ = 'templates/htmlpopup/lubis.mako'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_schwarzweiss'
__queryable_attributes__ = ['id', 'ort', 'filmart', 'bgdi_flugjahr']
__returnedGeometry__ = 'the_geom_footprint'
__timeInstant__ = 'bgdi_flugjahr'
__extended_info__ = True
# Composite labels
__label__ = 'flugdatum'
id = Column('ebkey', Text, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=3, srid=21781))
the_geom_footprint = Column(
'the_geom_footprint',
Geometry(geometry_type='GEOMETRY', dimension=3, srid=21781))
filename = Column('filename', Text)
inventarnummer = Column('inventarnummer', Integer)
bildnummer = Column('bildnummer', Integer)
flugdatum = Column('flugdatum', Text)
firma = Column('firma', Text)
filmart = Column('filmart', Text)
bgdi_flugjahr = Column('bgdi_flugjahr', Integer)
orientierung = Column('orientierung', Boolean)
rotation = Column('rotation', Integer)
orthophoto = Column('orthophoto', Text)
originalsize = Column('originalsize', Text)
x = Column('x', Integer)
y = Column('y', Integer)
flughoehe = Column('flughoehe', Integer)
ort = Column('ort', Text)
massstab = Column('massstab', Integer)
filesize_mb = Column('filesize_mb', Text)
bgdi_imagemode = Column('bgdi_imagemode', Text)
image_height = Column('image_height', Integer)
image_width = Column('image_width', Integer)
class DufourErst(Base, Vector):
__tablename__ = 'view_dufour_erstausgabe'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/dufour_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-dufour'
__label__ = 'datenstand'
id = Column('tilenumber', Text, primary_key=True)
kbbez = Column('kbbez', Text)
datenstand = Column('datenstand', Integer)
bv_nummer = Column('bv_nummer', Text)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
class Logistikraeume_armeelogistikcenter(Base, Vector):
__tablename__ = 'abschnittsregionen_armeelogistikzentren'
__table_args__ = ({'schema': 'militaer', 'autoload': False})
__template__ = 'templates/htmlpopup/logistikraeume.mako'
__bodId__ = 'ch.vbs.logistikraeume-armeelogistikcenter'
__queryable_attributes__ = ['kanton', 'region']
__label__ = 'kanton'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
kanton = Column('kantone', Text)
region = Column('region', Text)
class BODENEIGNUNG(Base, Vector):
__tablename__ = 'bodeneignung'
__table_args__ = ({'schema': 'blw', 'autoload': False})
__template__ = 'templates/htmlpopup/bodeneignung-kulurtyp.mako'
__bodId__ = 'ch.blw.bodeneignung-kulturtyp'
#__queryable_attributes__ = ['farbe']
__label__ = 'symb_color'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
farbe = Column('farbe', Integer)
symb_color = Column('symb_color', Text)
class Retablierungsstellen(Base, Vector):
__tablename__ = 'retablierungsstellen'
__table_args__ = ({'schema': 'militaer', 'autoload': False})
__template__ = 'templates/htmlpopup/retablierungsstellen.mako'
__bodId__ = 'ch.vbs.retablierungsstellen'
__queryable_attributes__ = ['name']
__label__ = 'name'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
name = Column('name', Text)
url = Column('url', Text)
class NOTFALLSCHUTZ(Base, Vector):
__tablename__ = 'zonenplan_kernanlagen'
__table_args__ = ({'schema': 'ensi', 'autoload': False})
__template__ = 'templates/htmlpopup/zonenplan_kernanlagen.mako'
__bodId__ = 'ch.ensi.zonenplan-notfallschutz-kernanlagen'
__label__ = 'name'
id = Column('nr', Integer, primary_key=True)
name = Column('name', Text)
zone = Column('zone', Text)
sektor = Column('sektor', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Zeitreihen_Metadata_22(Base, Vector):
# view in a schema
__tablename__ = 'meta_22'
__table_args__ = ({'schema': 'public', 'autoload': False})
__minresolution__ = 0
__maxresolution__ = 2.55
__bodId__ = 'ch.swisstopo.zeitreihen_meta'
id = Column('gid', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
release_year = Column('release_year', Integer)
bgdi_order = Column('bgdi_order', Integer)
class fsme_impfung(Base, Vector):
__tablename__ = 'fsme_impfung'
__table_args__ = ({'schema': 'bag', 'autoload': False})
__template__ = 'templates/htmlpopup/fsme.mako'
__bodId__ = 'ch.bag.zecken-fsme-impfung'
__label__ = 'gemname'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
gemname = Column('gemname', Integer)
bfsnr = Column('bfsnr', Integer)
bezirksnr = Column('bezirksnr', Integer)
kantonsnr = Column('kantonsnr', Integer)
class AggloIsoStaedte(Base, Vector):
__tablename__ = 'agglomerationen_isolierte_staedte'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/aggloisostaedte.mako'
__bodId__ = 'ch.are.agglomerationen_isolierte_staedte'
__label__ = 'name'
id = Column('row_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
name = Column('name', Text)
klasse_de = Column('klasse_de', Text)
klasse_fr = Column('klasse_fr', Text)
flaeche_ha = Column('flaeche_ha', Numeric)
class Bauzonen(Base, Vector):
__tablename__ = 'bauzonen_2007'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/bauzonen.mako'
__bodId__ = 'ch.are.bauzonen-2007'
id = Column('row_id', Integer, primary_key=True)
name = Column('name', Text)
nutz_de = Column('nutz_de', Text)
nutz_fr = Column('nutz_fr', Text)
kt_kz = Column('kt_kz', Text)
flaeche_qm = Column('flaeche_qm', Numeric)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Armeelogistikcenter(Base, Vector):
__tablename__ = 'armeelogistikcenter'
__table_args__ = ({'schema': 'militaer', 'autoload': False})
__template__ = 'templates/htmlpopup/armeelogistikcenter.mako'
__bodId__ = 'ch.vbs.armeelogistikcenter'
__queryable_attributes__ = ['name', 'abkuerzung']
__label__ = 'name'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=3, srid=21781))
name = Column('name', Text)
abkuerzung = Column('abkuerzung', Text)
mail = Column('email', Text)
url = Column('url', Text)
class PRONATURA(Base, Vector):
__tablename__ = 'waldreservate'
__table_args__ = ({'schema': 'pronatura', 'autoload': False})
__template__ = 'templates/htmlpopup/pronatura.mako'
__bodId__ = 'ch.pronatura.waldreservate'
__queryable_attributes__ = ['name', 'sg_nr', 'gisflaeche', 'gisteilobjekt', 'mcpfe']
__label__ = 'name'
id = Column('bgdi_id', Integer, primary_key=True)
sg_nr = Column('sg_nr', Numeric)
name = Column('name', Text)
gisflaeche = Column('obj_gisflaeche', Numeric)
gisteilobjekt = Column('obj_gisteilobjekt', Numeric)
mcpfe = Column('mcpfe', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class FEUERSTELLEN(Base, Vector):
__tablename__ = 'feuerstellen'
__table_args__ = ({'schema': 'tamedia', 'autoload': False})
__template__ = 'templates/htmlpopup/swissmap_online_feuerstellen.mako'
__bodId__ = 'ch.tamedia.schweizerfamilie-feuerstellen'
__label__ = 'gemeinde'
id = Column('nr', Integer, primary_key=True)
gemeinde = Column('gemeinde', Text)
ort = Column('ort', Text)
kanton = Column('kanton', Text)
karte = Column('karte', Text)
url = Column('url', Text)
koordinate_lv03 = Column('koordinate_lv03', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
class Gemeindetypen_2012(Base, Vector):
__tablename__ = 'gemeindetypologie_2012'
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/gemeindetypen_2012.mako'
__bodId__ = 'ch.are.gemeindetypen'
__label__ = 'name_'
id = Column('bgdi_id', Integer, primary_key=True)
name_ = Column('name_', Text)
typ_code = Column('typ_code', Text)
typ_bez_d = Column('typ_bez_d', Text)
typ_bez_f = Column('typ_bez_f', Text)
bfs_no = Column('bfs_no', Text)
kt_no = Column('kt_no', Text)
kt_kz = Column('kt_kz', Text)
flaeche_ha = Column('flaeche_ha', Numeric)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
