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)
register('ch.babs.kulturgueter', Kulturgueter)
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)
register('ch.vbs.territorialregionen', TERRITORIALREGIONEN)
kanton = Column('kanton', Unicode)
vergleichsrastereinheit = Column('vergleichsrastereinheit', Unicode)
lagequalitaeten = Column('lagequalitaeten', Unicode)
raeumliche_qualitaeten = Column('raeumliche_qualitaeten', Unicode)
arch__hist__qualitaeten = Column('arch__hist__qualitaeten', Unicode)
fassungsjahr = Column('fassungsjahr', Unicode)
band_1 = Column('band_1', Unicode)
band_2 = Column('band_2', Unicode)
publikationsjahr_1 = Column('publikationsjahr_1', Unicode)
publikationsjahr_2 = Column('publikationsjahr_2', Unicode)
pdf_dokument_1 = Column('pdf_dokument_1', Unicode)
pdf_dokument_2 = Column('pdf_dokument_2', Unicode)
pdfspecial = Column('pdfspecial', Unicode)
the_geom = Column(Geometry2D)
register('ch.bak.bundesinventar-schuetzenswerte-ortsbilder', Isos)
class Unesco(Base, Vector):
__tablename__ = 'unesco'
__table_args__ = ({'autoload': False})
__template__ = 'templates/htmlpopup/unesco_bak.mako'
__bodId__ = 'ch.bak.schutzgebiete-unesco_weltkulturerbe'
__label__ = 'name_de'
__returnedGeometry__ = 'the_geom_simplified_tolerance_3'
id = Column('bgdi_id', Integer, primary_key=True)
name_fr = Column('name_fr', Unicode)
name_de = Column('bgdi_name', Unicode)
name_it = Column('name_it', Unicode)
name_en = Column('name_en', Unicode)
name_rm = Column('name_rm', Unicode)
vergleichsrastereinheit = Column('vergleichsrastereinheit', Unicode)
lagequalitaeten = Column('lagequalitaeten', Unicode)
raeumliche_qualitaeten = Column('raeumliche_qualitaeten', Unicode)
arch__hist__qualitaeten = Column('arch__hist__qualitaeten', Unicode)
fassungsjahr = Column('fassungsjahr', Unicode)
band_1 = Column('band_1', Unicode)
band_2 = Column('band_2', Unicode)
publikationsjahr_1 = Column('publikationsjahr_1', Unicode)
publikationsjahr_2 = Column('publikationsjahr_2', Unicode)
pdf_dokument_1 = Column('pdf_dokument_1', Unicode)
pdf_dokument_2 = Column('pdf_dokument_2', Unicode)
pdfspecial = Column('pdfspecial', Unicode)
the_geom = Column(Geometry2D)
register('ch.bak.bundesinventar-schuetzenswerte-ortsbilder', Isos)
class Unesco(Base, Vector):
__tablename__ = 'unesco'
__table_args__ = ({'autoload': False})
__template__ = 'templates/htmlpopup/unesco_bak.mako'
__bodId__ = 'ch.bak.schutzgebiete-unesco_weltkulturerbe'
__label__ = 'name_de'
__returnedGeometry__ = 'the_geom_simplified_tolerance_3'
id = Column('bgdi_id', Integer, primary_key=True)
name_fr = Column('name_fr', Unicode)
name_de = Column('bgdi_name', Unicode)
name_it = Column('name_it', Unicode)
name_en = Column('name_en', Unicode)
name_rm = Column('name_rm', Unicode)
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/landschaftstypen.mako'
__bodId__ = 'ch.are.landschaftstypen'
__label__ = 'typ_nr'
id = Column('object', Unicode, primary_key=True)
typ_nr = Column('typ_nr', Integer)
typname_de = Column('typname_de', Unicode)
typname_fr = Column('typname_fr', Unicode)
regname_de = Column('regname_de', Unicode)
regname_fr = Column('regname_fr', Unicode)
object_are = Column('object_are', Float)
typ_area = Column('typ_area', Float)
stand = Column('stand', Unicode)
the_geom = Column(Geometry2D)
register('ch.are.landschaftstypen', Landschaftstypen)
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)
flaeche_ha = Column('flaeche_ha', Float)
stand = Column('stand', Float)
the_geom = Column(Geometry3D)
register('ch.are.alpenkonvention', Alpenkonvention)
__template__ = 'templates/htmlpopup/landschaftstypen.mako'
__bodId__ = 'ch.are.landschaftstypen'
__label__ = 'typ_nr'
id = Column('object', Text, primary_key=True)
typ_nr = Column('typ_nr', Integer)
typname_de = Column('typname_de', Text)
typname_fr = Column('typname_fr', Text)
regname_de = Column('regname_de', Text)
regname_fr = Column('regname_fr', Text)
object_are = Column('object_are', Numeric)
typ_area = Column('typ_area', Numeric)
stand = Column('stand', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
register('ch.are.landschaftstypen', Landschaftstypen)
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)
register('ch.are.alpenkonvention', Alpenkonvention)
__template__ = 'templates/htmlpopup/landschaftstypen.mako'
__bodId__ = 'ch.are.landschaftstypen'
__label__ = 'typ_nr'
id = Column('object', Unicode, primary_key=True)
typ_nr = Column('typ_nr', Integer)
typname_de = Column('typname_de', Unicode)
typname_fr = Column('typname_fr', Unicode)
regname_de = Column('regname_de', Unicode)
regname_fr = Column('regname_fr', Unicode)
object_are = Column('object_are', Float)
typ_area = Column('typ_area', Float)
stand = Column('stand', Unicode)
the_geom = Column(Geometry2D)
register('ch.are.landschaftstypen', Landschaftstypen)
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)
flaeche_ha = Column('flaeche_ha', Float)
stand = Column('stand', Float)
the_geom = Column(Geometry3D)
register('ch.are.alpenkonvention', Alpenkonvention)
fr = Column('fr', Unicode)
it = Column('it', Unicode)
en = Column('en', Unicode)
the_geom = Column(Geometry2D)
class EignungDaecher(Base, SolarClass, Vector):
__tablename__ = 'view_solarenergie_daecher_gs'
__template__ = 'templates/htmlpopup/solareignungdaecher.mako'
__bodId__ = 'ch.bfe.solarenergie-eignung-daecher'
__queryable_attributes__ = ['df_uid', 'building_id']
id = Column('df_uid', BigInteger, primary_key=True)
df_nummer = Column('df_nummer', Integer)
neigung = Column('neigung', Integer)
register(EignungDaecher.__bodId__, EignungDaecher)
class EignungDaecherOverview(Base, SolarOverview, Vector):
__tablename__ = 'solarenergie_availability'
__template__ = 'templates/htmlpopup/solareignungdaecher_av.mako'
__parentLayerId__ = EignungDaecher.__bodId__
__bodId__ = 'ch.bfe.solarenergie-eignung-daecher'
register(EignungDaecherOverview.__bodId__, EignungDaecherOverview)
class EignungFassaden(Base, SolarClass, Vector):
__tablename__ = 'view_solarenergie_fassaden_gs'
__template__ = 'templates/htmlpopup/solareignungfassaden.mako'
__bodId__ = 'ch.bfe.solarenergie-eignung-fassaden'
ort = Column('ort', Unicode)
massstab = Column('massstab', Integer)
filesize_mb = Column('filesize_mb', Unicode)
bgdi_imagemode = Column('bgdi_imagemode', Unicode)
the_geom_footprint = Column('the_geom_footprint', Geometry2D)
the_geom = Column(Geometry2D)
class LuftbilderSwisstopoFarbe(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_color'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_farbe'
__queryable_attributes__ = ['id', 'ort']
image_height = Column('image_height', Integer)
image_width = Column('image_width', Integer)
register('ch.swisstopo.lubis-luftbilder_farbe', LuftbilderSwisstopoFarbe)
class LuftbilderSwisstopoIr(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_ir'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_infrarot'
__queryable_attributes__ = ['id', 'ort']
image_height = Column('image_height', Integer)
image_width = Column('image_width', Integer)
register('ch.swisstopo.lubis-luftbilder_infrarot', LuftbilderSwisstopoIr)
class LuftbilderSwisstopoSw(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_bw'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_schwarzweiss'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/dufour_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-dufour'
__label__ = 'datenstand'
id = Column('tilenumber', Unicode, primary_key=True)
kbbez = Column('kbbez', Unicode)
datenstand = Column('datenstand', Integer)
bv_nummer = Column('bv_nummer', Unicode)
the_geom = Column(Geometry2D)
class SiegfriedErst(Base, Vector):
__tablename__ = 'view_siegfried_erstausgabe'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/siegfried_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-siegfried'
__label__ = 'datenstand'
id = Column('tilenumber', Unicode, primary_key=True)
kbbez = Column('kbbez', Unicode)
datenstand = Column('datenstand', Numeric)
bv_nummer = Column('bv_nummer', Unicode)
the_geom = Column(Geometry2D)
register('ch.swisstopo.hiks-siegfried', SiegfriedErst)
register('ch.swisstopo.hiks-dufour', DufourErst)
register('ch.swisstopo.zeitreihen', Zeitreihen15)
register('ch.swisstopo.zeitreihen', Zeitreihen20)
register('ch.swisstopo.zeitreihen', Zeitreihen21)
register('ch.swisstopo.zeitreihen', Zeitreihen22)
__bodId__ = 'ch.bfs.arealstatistik'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
id_arealstatistik_85 = Column('id_arealstatistik_85', Integer)
id_arealstatistik_97 = Column('id_arealstatistik_97', Integer)
id_arealstatistik_09 = Column('id_arealstatistik_09', Integer)
the_geom = Column(Geometry2D)
register('ch.bfs.arealstatistik', Arealstatistik2009)
class Arealstatistik1985(Base, Vector):
__tablename__ = 'arealstatistik_std_1985'
__table_args__ = ({'schema': 'bfs', 'autoload': False})
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik-1985'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/dufour_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-dufour'
__label__ = 'datenstand'
id = Column('tilenumber', Unicode, primary_key=True)
kbbez = Column('kbbez', Unicode)
datenstand = Column('datenstand', Integer)
bv_nummer = Column('bv_nummer', Unicode)
the_geom = Column(Geometry2D)
class SiegfriedErst(Base, Vector):
__tablename__ = 'view_siegfried_erstausgabe'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/siegfried_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-siegfried'
__label__ = 'datenstand'
id = Column('tilenumber', Unicode, primary_key=True)
kbbez = Column('kbbez', Unicode)
datenstand = Column('datenstand', Numeric)
bv_nummer = Column('bv_nummer', Unicode)
the_geom = Column(Geometry2D)
register('ch.swisstopo.hiks-siegfried', SiegfriedErst)
register('ch.swisstopo.hiks-dufour', DufourErst)
register('ch.swisstopo.zeitreihen', Zeitreihen15)
register('ch.swisstopo.zeitreihen', Zeitreihen20)
register('ch.swisstopo.zeitreihen', Zeitreihen21)
register('ch.swisstopo.zeitreihen', Zeitreihen22)
it = Column('it', Unicode)
en = Column('en', Unicode)
the_geom = Column(Geometry2D)
class EignungDaecher(Base, SolarClass, Vector):
__tablename__ = 'view_solarenergie_daecher_gs'
__template__ = 'templates/htmlpopup/solareignungdaecher.mako'
__bodId__ = 'ch.bfe.solarenergie-eignung-daecher'
__queryable_attributes__ = ['df_uid', 'building_id']
id = Column('df_uid', BigInteger, primary_key=True)
df_nummer = Column('df_nummer', Integer)
neigung = Column('neigung', Integer)
register(EignungDaecher.__bodId__, EignungDaecher)
class EignungDaecherOverview(Base, SolarOverview, Vector):
__tablename__ = 'solarenergie_availability'
__template__ = 'templates/htmlpopup/solareignungdaecher_av.mako'
__parentLayerId__ = EignungDaecher.__bodId__
__bodId__ = 'ch.bfe.solarenergie-eignung-daecher'
register(EignungDaecherOverview.__bodId__, EignungDaecherOverview)
class EignungFassaden(Base, SolarClass, Vector):
__tablename__ = 'view_solarenergie_fassaden_gs'
__template__ = 'templates/htmlpopup/solareignungfassaden.mako'
class SiegfriedErst(Base, Vector):
__tablename__ = 'view_siegfried_erstausgabe'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/siegfried_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-siegfried'
__label__ = 'datenstand'
id = Column('tilenumber', Text, primary_key=True)
kbbez = Column('kbbez', Text)
datenstand = Column('datenstand', Numeric)
bv_nummer = Column('bv_nummer', Text)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
register('ch.swisstopo.hiks-siegfried', SiegfriedErst)
register('ch.swisstopo.hiks-dufour', DufourErst)
register('ch.swisstopo.zeitreihen', Zeitreihen_15)
register('ch.swisstopo.zeitreihen', Zeitreihen_20)
register('ch.swisstopo.zeitreihen', Zeitreihen_21)
register('ch.swisstopo.zeitreihen', Zeitreihen_22)
class Zeitreihen_Metadata_15(Base, Vector):
# view in a schema
__tablename__ = 'meta_15'
__table_args__ = ({'schema': 'public', 'autoload': False})
__minresolution__ = 10.05
__maxresolution__ = 500005
__bodId__ = 'ch.swisstopo.zeitreihen_meta'
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
id_arealstatistik_85 = Column('id_arealstatistik_85', Integer)
id_arealstatistik_97 = Column('id_arealstatistik_97', Integer)
id_arealstatistik_09 = Column('id_arealstatistik_09', Integer)
the_geom = Column(Geometry2D)
register('ch.bfs.arealstatistik', Arealstatistik2009)
class Arealstatistik1985(Base, Vector):
__tablename__ = 'arealstatistik_std_1985'
__table_args__ = ({'schema': 'bfs', 'autoload': False})
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik-1985'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
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))
register('ch.bfs.gebaeude_wohnungs_register', Gebaeuderegister)
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 SiegfriedErst(Base, Vector):
__tablename__ = "view_siegfried_erstausgabe"
__table_args__ = {"schema": "public", "autoload": False}
__template__ = "templates/htmlpopup/siegfried_erst.mako"
__bodId__ = "ch.swisstopo.hiks-siegfried"
__label__ = "datenstand"
id = Column("tilenumber", Text, primary_key=True)
kbbez = Column("kbbez", Text)
datenstand = Column("datenstand", Numeric)
bv_nummer = Column("bv_nummer", Text)
the_geom = Column(Geometry(geometry_type="GEOMETRY", dimension=2, srid=21781))
register("ch.swisstopo.hiks-siegfried", SiegfriedErst)
register("ch.swisstopo.hiks-dufour", DufourErst)
register("ch.swisstopo.zeitreihen", Zeitreihen_15)
register("ch.swisstopo.zeitreihen", Zeitreihen_20)
register("ch.swisstopo.zeitreihen", Zeitreihen_21)
register("ch.swisstopo.zeitreihen", Zeitreihen_22)
class Zeitreihen_Metadata_15(Base, Vector):
# view in a schema
__tablename__ = "meta_15"
__table_args__ = {"schema": "public", "autoload": False}
__minresolution__ = 10.05
__maxresolution__ = 500005
__bodId__ = "ch.swisstopo.zeitreihen_meta"
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
id_arealstatistik_85 = Column('id_arealstatistik_85', Integer)
id_arealstatistik_97 = Column('id_arealstatistik_97', Integer)
id_arealstatistik_09 = Column('id_arealstatistik_09', Integer)
register('ch.bfs.arealstatistik', Arealstatistik2009)
class Arealstatistik1985(Base, Vector):
__tablename__ = 'arealstatistik_std_1985'
__table_args__ = ({'schema': 'bfs', 'autoload': False})
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik-1985'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
fj85 = Column('fj85', 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)
register('ch.swisstopo.lubis-luftbilder_farbe', luftbilder_swisstopo_farbe)
class luftbilder_swisstopo_ir(Base, Vector):
__tablename__ = 'luftbilder_swisstopo_ir'
__table_args__ = ({
'schema': 'public',
'autoload': False,
'extend_existing': True
})
__template__ = 'templates/htmlpopup/lubis.mako'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_infrarot'
__queryable_attributes__ = ['id', 'ort']
__returnedGeometry__ = 'the_geom_footprint'
__timeInstant__ = 'bgdi_flugjahr'
__extended_info__ = True
__template__ = 'templates/htmlpopup/bodeneignung.mako'
__label__ = 'farbe'
id = Column('bgdi_id', Integer, primary_key=True)
farbe = Column('farbe', Integer)
eignungsei = Column('eignungsei', Unicode)
the_geom = Column(Geometry2D)
class Kulturtyp(Base, Bodeneignung, Vector):
__template__ = 'templates/htmlpopup/bodeneignung-kulurtyp.mako'
__bodId__ = 'ch.blw.bodeneignung-kulturtyp'
# __queryable_attributes__ = ['farbe']
__label__ = 'symb_color'
symb_color = Column('symb_color', Unicode)
register('ch.blw.bodeneignung-kulturtyp', Kulturtyp)
class Gruendigkeit(Base, Bodeneignung, Vector):
__bodId__ = 'ch.blw.bodeneignung-gruendigkeit'
register('ch.blw.bodeneignung-gruendigkeit', Gruendigkeit)
class Skelettgehalt(Base, Bodeneignung, Vector):
__bodId__ = 'ch.blw.bodeneignung-skelettgehalt'
register('ch.blw.bodeneignung-skelettgehalt', Skelettgehalt)
class Wasserspeichervermoegen(Base, Bodeneignung, Vector):
Base = bases['mogis']
class CadastralWebMap(Base, Vector):
__tablename__ = 'view_os_realestate_cwm'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/cadastralwebmap.mako'
__bodId__ = 'ch.kantone.cadastralwebmap-farbe'
__label__ = 'ak'
id = Column('id', Integer, primary_key=True)
ak = Column('ak', Unicode)
the_geom = Column(Geometry2D)
register('ch.kantone.cadastralwebmap-farbe', CadastralWebMap)
class CadastralWebMapOpenData(Base, Vector):
__tablename__ = 'view_os_realestate_vd_opendata'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/cadastralwebmap_opendata.mako'
__bodId__ = 'ch.swisstopo-vd.amtliche-vermessung'
__label__ = 'name'
__extended_info__ = True
id = Column('id', Integer, primary_key=True)
bfsnr = Column('bfsnr', Integer)
ak = Column('ak', Unicode)
name = Column('name', Unicode)
the_geom = Column(Geometry2D)
massstab = Column('massstab', Integer)
filesize_mb = Column('filesize_mb', Unicode)
bgdi_imagemode = Column('bgdi_imagemode', Unicode)
the_geom_footprint = Column('the_geom_footprint', Geometry2D)
the_geom = Column(Geometry2D)
class LuftbilderSwisstopoFarbe(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_color'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_farbe'
__queryable_attributes__ = ['id', 'ort']
image_height = Column('image_height', Integer)
image_width = Column('image_width', Integer)
register('ch.swisstopo.lubis-luftbilder_farbe', LuftbilderSwisstopoFarbe)
class LuftbilderSwisstopoIr(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_ir'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_infrarot'
__queryable_attributes__ = ['id', 'ort']
image_height = Column('image_height', Integer)
image_width = Column('image_width', Integer)
register('ch.swisstopo.lubis-luftbilder_infrarot', LuftbilderSwisstopoIr)
class LuftbilderSwisstopoSw(Base, LuftbilderBase, Vector):
__tablename__ = 'luftbilder_swisstopo_bw'
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)
register('ch.blw.bodeneignung-kulturtyp', BODENEIGNUNG)
class emapis_beizugsgebiet(Base, Vector):
__tablename__ = 'emapis_beizugsgebiet'
__table_args__ = ({'schema': 'blw', 'autoload': False})
__template__ = 'templates/htmlpopup/emapis.mako'
__bodId__ = 'ch.blw.emapis-beizugsgebiet'
__label__ = 'typ'
id = Column('xtf_id', Integer, primary_key=True)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
typ = Column('typ', Text)
typ_de = Column('typ_de', Text)
typ_fr = Column('typ_fr', Text)
typ_it = Column('typ_it', Text)
objektart = Column('objektart', Unicode)
hausnr = Column('hausnr', Unicode)
adresse = Column('adresse', Unicode)
kurztexte = Column('kurztexte', Unicode)
kt_kz = Column('kt_kz', Unicode)
pdf_list = Column('pdf_list', Unicode)
link_uri = Column('link_uri', Unicode)
link_title = Column('link_title', Unicode)
link_2_uri = Column('link_2_uri', Unicode)
link_2_title = Column('link_2_title', Unicode)
link_3_uri = Column('link_3_uri', Unicode)
link_3_title = Column('link_3_title', Unicode)
the_geom = Column(Geometry2D)
register('ch.babs.kulturgueter', Kulturgueter)
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)
name = Column('name', Unicode)
the_geom = Column(Geometry2D)
register('ch.vbs.territorialregionen', Territorialregionen)
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))
register('ch.bfs.gebaeude_wohnungs_register', Gebaeuderegister)
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))
register('ch.swisstopo.fixpunkte-agnes', AGNES)
HouseNum = Column('address_house_num', Unicode)
Floor = Column('address_floor', Unicode)
Region = Column('address_region', Unicode)
PostalCode = Column('address_postal_code', Unicode)
City = Column('address_city', Unicode)
Timezone = Column('address_timezone', Unicode)
Country = Column('address_country', Unicode)
AuthenticationModes = Column('authentication_mode',
postgresql.ARRAY(Unicode))
QueryAuthenticationModes = Column('queriable_authentication_mode', Unicode)
Latitude = Column('latitude', Numeric)
Longitude = Column('longitude', Numeric)
GeoCoordinates = Column('queriable_geocoordinates', Unicode)
EntranceLatitude = Column('entrance_latitude', Numeric)
EntranceLongitude = Column('entrance_longitude', Numeric)
GeoChargingPointEntrance = Column('queriable_entrance_geocoordinates',
Unicode)
lastUpdate = Column('last_modified', Date)
IsOpen24Hours = Column('is_open_24_hours', Boolean)
OpeningTimes = Column('opening_times', Boolean)
OperatorID = Column('operator_id', Unicode)
HubOperatorID = Column('hub_operator_id', Unicode)
ClearinghouseID = Column('clearing_house_id', Unicode)
OperatorName = Column('operator_name', Unicode)
HotlinePhoneNumber = Column('hotline_phone_num', Unicode)
ProviderURL = Column('provider_url', Unicode)
the_geom = Column(Geometry2D)
register(DiemoLocations.__bodId__, DiemoLocations)
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)
register('ch.babs.kulturgueter', Kulturgueter)
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)
register('ch.vbs.territorialregionen', TERRITORIALREGIONEN)
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)
register('ch.swisstopo.lubis-luftbilder_farbe', luftbilder_swisstopo_farbe)
class luftbilder_swisstopo_ir(Base, Vector):
__tablename__ = 'luftbilder_swisstopo_ir'
__table_args__ = ({'schema': 'public', 'autoload': False, 'extend_existing': True})
__template__ = 'templates/htmlpopup/lubis.mako'
__bodId__ = 'ch.swisstopo.lubis-luftbilder_infrarot'
__queryable_attributes__ = ['id', 'ort']
__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',
number = Column('number', Integer)
location = Column('location', Unicode)
lat = Column('lat', Float)
lon = Column('lon', Float)
street = Column('street', Unicode)
city = Column('city', Unicode)
categories = Column('categories', Unicode)
the_geom_point = Column('the_geom', Geometry2D)
class MobilityStandorteZoom1(Base, MobilityStandorte, Vector):
__minscale__ = 1
__maxscale__ = 4000
the_geom = Column('the_geom_click', Geometry2D)
register(MobilityStandorte.__bodId__, MobilityStandorteZoom1)
class MobilityStandorteZoom2(Base, MobilityStandorte, Vector):
__minscale__ = 4000
the_geom = Column('the_geom_click_overview', Geometry2D)
register(MobilityStandorte.__bodId__, MobilityStandorteZoom2)
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'
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)
register('ch.blw.bodeneignung-kulturtyp', BODENEIGNUNG)
class emapis_beizugsgebiet(Base, Vector):
__tablename__ = 'emapis_beizugsgebiet'
__table_args__ = ({'schema': 'blw', 'autoload': False})
__template__ = 'templates/htmlpopup/emapis.mako'
__bodId__ = 'ch.blw.emapis-beizugsgebiet'
__label__ = 'typ'
id = Column('xtf_id', Integer, primary_key=True)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
typ = Column('typ', Text)
typ_de = Column('typ_de', Text)
typ_fr = Column('typ_fr', Text)
typ_it = Column('typ_it', Text)
__table_args__ = ({'schema': 'siedlung_landschaft', 'autoload': False})
__template__ = 'templates/htmlpopup/landschaftstypen.mako'
__bodId__ = 'ch.are.landschaftstypen'
__label__ = 'typ_nr'
id = Column('object', Unicode, primary_key=True)
typ_nr = Column('typ_nr', Integer)
typname_de = Column('typname_de', Unicode)
typname_fr = Column('typname_fr', Unicode)
regname_de = Column('regname_de', Unicode)
regname_fr = Column('regname_fr', Unicode)
object_are = Column('object_are', Float)
typ_area = Column('typ_area', Float)
stand = Column('stand', Unicode)
the_geom = Column(Geometry2D)
register('ch.are.landschaftstypen', Landschaftstypen)
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)
flaeche_ha = Column('flaeche_ha', Float)
stand = Column('stand', Float)
the_geom = Column(Geometry3D)
register('ch.are.alpenkonvention', Alpenkonvention)
objektart = Column('objektart', Unicode)
hausnr = Column('hausnr', Unicode)
adresse = Column('adresse', Unicode)
kurztexte = Column('kurztexte', Unicode)
kt_kz = Column('kt_kz', Unicode)
pdf_list = Column('pdf_list', Unicode)
link_uri = Column('link_uri', Unicode)
link_title = Column('link_title', Unicode)
link_2_uri = Column('link_2_uri', Unicode)
link_2_title = Column('link_2_title', Unicode)
link_3_uri = Column('link_3_uri', Unicode)
link_3_title = Column('link_3_title', Unicode)
the_geom = Column(Geometry2D)
register('ch.babs.kulturgueter', Kulturgueter)
class NationalesSportanlagenkonzept(Base, Vector):
__tablename__ = 'nationales_sportanlagenkonzept'
__table_args__ = ({'schema': 'baspo', 'autoload': False})
__template__ = 'templates/htmlpopup/nationales_sportanlagenkonzept.mako'
__bodId__ = 'ch.baspo.nationales-sportanlagenkonzept'
__label__ = 'name_der_anlage'
id = Column('bgdi_id', Integer, primary_key=True)
nasak_nr = Column('nasak_nr', Unicode, nullable=False)
kategorie_de = Column('kategorie_de', Unicode, nullable=False)
art_der_anlage = Column('art_der_anlage', Unicode, nullable=False)
name_der_anlage = Column('name_der_anlage', Unicode, nullable=False)
ort = Column('ort', Unicode, nullable=False)
website = Column('website', Unicode, nullable=False, default=u'')
class SiegfriedErst(Base, Vector):
__tablename__ = 'view_siegfried_erstausgabe'
__table_args__ = ({'schema': 'public', 'autoload': False})
__template__ = 'templates/htmlpopup/siegfried_erst.mako'
__bodId__ = 'ch.swisstopo.hiks-siegfried'
__label__ = 'datenstand'
id = Column('tilenumber', Text, primary_key=True)
kbbez = Column('kbbez', Text)
datenstand = Column('datenstand', Numeric)
bv_nummer = Column('bv_nummer', Text)
the_geom = Column(Geometry(geometry_type='GEOMETRY',
dimension=2, srid=21781))
register('ch.swisstopo.hiks-siegfried', SiegfriedErst)
register('ch.swisstopo.hiks-dufour', DufourErst)
register('ch.swisstopo.zeitreihen', Zeitreihen_15)
register('ch.swisstopo.zeitreihen', Zeitreihen_20)
register('ch.swisstopo.zeitreihen', Zeitreihen_21)
register('ch.swisstopo.zeitreihen', Zeitreihen_22)
class Zeitreihen_Metadata_15(Base, Vector):
# view in a schema
__tablename__ = 'meta_15'
__table_args__ = ({'schema': 'public', 'autoload': False})
__minresolution__ = 10.05
__maxresolution__ = 500005
__bodId__ = 'ch.swisstopo.zeitreihen_meta'
strname_it = Column('strname_it', Unicode, nullable=True)
strname_rm = Column('strname_rm', Unicode, nullable=True)
deinr = Column('deinr', Unicode)
plz4 = Column('plz4', Integer, nullable=False)
plz6 = Column('plz6', Integer, nullable=False)
plzname = Column('plzname', Unicode)
gdename = Column('gdename', Unicode, nullable=False)
gdekt = Column('gdekt', Unicode)
dstrid = Column('dstrid', Integer)
gstat = Column('gstat', Integer)
gdenr = Column('gdenr', Integer)
bgdi_created = Column('bgdi_created', Unicode)
the_geom = Column(Geometry2D)
register('ch.bfs.gebaeude_wohnungs_register', Gebaeuderegister)
register('ch.bfs.gebaeude_wohnungs_register_preview', Gebaeuderegister)
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', Unicode, primary_key=True)
url = Column('url', Unicode)
bgdi_id = Column('bgdi_id', Integer)
the_geom = Column(Geometry2D)
Base = bases['dritte']
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))
register('ch.sgpk.maechtigkeit-lockergesteine', Maechtigkeit_lockergesteine)
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)
__bodId__ = 'ch.are.landschaftstypen'
__label__ = 'typ_nr'
id = Column('object', Text, primary_key=True)
typ_nr = Column('typ_nr', Integer)
typname_de = Column('typname_de', Text)
typname_fr = Column('typname_fr', Text)
regname_de = Column('regname_de', Text)
regname_fr = Column('regname_fr', Text)
object_are = Column('object_are', Numeric)
typ_area = Column('typ_area', Numeric)
stand = Column('stand', Text)
the_geom = Column(
Geometry(geometry_type='GEOMETRY', dimension=2, srid=21781))
register('ch.are.landschaftstypen', Landschaftstypen)
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)
location = Column('location', Unicode)
lat = Column('lat', Float)
lon = Column('lon', Float)
street = Column('street', Unicode)
city = Column('city', Unicode)
categories = Column('categories', Unicode)
the_geom_point = Column('the_geom', Geometry2D)
class MobilityStandorteZoom1(Base, MobilityStandorte, Vector):
__minscale__ = 1
__maxscale__ = 4000
the_geom = Column('the_geom_click', Geometry2D)
register(MobilityStandorte.__bodId__, MobilityStandorteZoom1)
class MobilityStandorteZoom2(Base, MobilityStandorte, Vector):
__minscale__ = 4000
the_geom = Column('the_geom_click_overview', Geometry2D)
register(MobilityStandorte.__bodId__, MobilityStandorteZoom2)
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'
__template__ = 'templates/htmlpopup/bodeneignung.mako'
__label__ = 'farbe'
id = Column('bgdi_id', Integer, primary_key=True)
farbe = Column('farbe', Integer)
eignungsei = Column('eignungsei', Unicode)
the_geom = Column(Geometry2D)
class Kulturtyp(Base, Bodeneignung, Vector):
__template__ = 'templates/htmlpopup/bodeneignung-kulurtyp.mako'
__bodId__ = 'ch.blw.bodeneignung-kulturtyp'
# __queryable_attributes__ = ['farbe']
__label__ = 'symb_color'
symb_color = Column('symb_color', Unicode)
register('ch.blw.bodeneignung-kulturtyp', Kulturtyp)
class Gruendigkeit(Base, Bodeneignung, Vector):
__bodId__ = 'ch.blw.bodeneignung-gruendigkeit'
register('ch.blw.bodeneignung-gruendigkeit', Gruendigkeit)
class Skelettgehalt(Base, Bodeneignung, Vector):
__bodId__ = 'ch.blw.bodeneignung-skelettgehalt'
register('ch.blw.bodeneignung-skelettgehalt', Skelettgehalt)
class Wasserspeichervermoegen(Base, Bodeneignung, Vector):
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
id_arealstatistik_85 = Column('id_arealstatistik_85', Integer)
id_arealstatistik_97 = Column('id_arealstatistik_97', Integer)
id_arealstatistik_09 = Column('id_arealstatistik_09', Integer)
the_geom = Column(Geometry2D)
register('ch.bfs.arealstatistik', Arealstatistik2009)
class Arealstatistik1985(Base, Vector):
__tablename__ = 'arealstatistik_std_1985'
__table_args__ = ({'schema': 'bfs', 'autoload': False})
__template__ = 'templates/htmlpopup/arealstatistik_std.mako'
__bodId__ = 'ch.bfs.arealstatistik-1985'
# __minscale__ = 5001
__maxscale__ = 50000
# specially big layer
__label__ = 'id'
id = Column('bgdi_id', Integer, primary_key=True)
fj85 = Column('fj85', Integer)
fj97 = Column('fj97', Integer)
fj09 = Column('fj09', Integer)
Base = bases['dritte']
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))
register('ch.sgpk.maechtigkeit-lockergesteine', Maechtigkeit_lockergesteine)
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)
strname_fr = Column('strname_fr', Unicode, nullable=True)
strname_it = Column('strname_it', Unicode, nullable=True)
strname_rm = Column('strname_rm', Unicode, nullable=True)
deinr = Column('deinr', Unicode)
plz4 = Column('plz4', Integer, nullable=False)
plz6 = Column('plz6', Integer, nullable=False)
plzname = Column('plzname', Unicode)
gdename = Column('gdename', Unicode, nullable=False)
gdekt = Column('gdekt', Unicode)
dstrid = Column('dstrid', Integer)
gstat = Column('gstat', Integer)
gdenr = Column('gdenr', Integer)
bgdi_created = Column('bgdi_created', Unicode)
the_geom = Column(Geometry2D)
register('ch.bfs.gebaeude_wohnungs_register', Gebaeuderegister)
register('ch.bfs.gebaeude_wohnungs_register_preview', Gebaeuderegister)
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', Unicode, primary_key=True)
url = Column('url', Unicode)
bgdi_id = Column('bgdi_id', Integer)
the_geom = Column(Geometry2D)
register('ch.swisstopo.fixpunkte-agnes', Agnes)
