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))