class WohnbaulandAnteile(ProjectTable): id_teilflaeche = Field(int, 0) nettoflaeche = Field(float, 0) class Meta: workspace = 'definitions'
class ErschliessungsnetzLinienZeichnung(ProjectTable): IDNetz = Field(int, 0) IDNetzelement = Field(int, 0) length = Field(float, 0) class Meta: workspace = 'infrastukturfolgekosten'
class Einrichtungen(ProjectTable): projektcheck_category = Field(str, '') name = Field(str, '') class Meta: workspace = 'erreichbarkeiten'
class TransferNodes(ProjectTable): node_id = Field(int, 0) weight = Field(float, 0) name = Field(str, '') class Meta: workspace = 'traffic'
class Ways(ProjectTable): nutzungsart = Field(int, 0) miv_anteil = Field(float, 0) wege_gesamt = Field(int, 0) class Meta: workspace = 'traffic'
class ZentraleOrte(ProjectTable): id_haltestelle = Field(int, 0) id_zentraler_ort = Field(int, 0) name = Field(str, '') class Meta: workspace = 'erreichbarkeiten'
class RouteLinks(ProjectTable): from_node_id = Field(int, 0) to_node_id = Field(int, 0) transfer_node_id = Field(int, 0) area_id = Field(int, 0) class Meta: workspace = 'traffic'
class ApProJahr(ProjectTable): id_teilflaeche = Field(int, 0) name_teilflaeche = Field(str, '') jahr = Field(int, 0) arbeitsplaetze = Field(int, 0) class Meta: workspace = 'bewohner_arbeitsplaetze'
class Isochronen(ProjectTable): sekunden = Field(int, 0) minuten = Field(float, 0) modus = Field(str, '') id_connector = Field(int, 0) class Meta: workspace = 'erreichbarkeiten'
class Gesamtkosten(ProjectTable): IDNetz = Field(int, 0) Netz = Field(str, '') IDKostenphase = Field(int, 0) Kostenphase = Field(str, '') Euro = Field(float, 0) class Meta: workspace = 'infrastukturfolgekosten'
class WohnflaecheGebaeudetyp(ProjectTable): id_teilflaeche = Field(int, 0) mean_wohnflaeche = Field(int, 0) id_gebaeudetyp = Field(int, 0) name_gebaeudetyp = Field(str, 0) class Meta: workspace = 'definitions'
class Kostenaufteilung(ProjectTable): IDNetz = Field(int, 0) IDKostenphase = Field(int, 0) Anteil_GSB = Field(int, 0) Anteil_GEM = Field(int, 0) Anteil_ALL = Field(int, 0) class Meta: workspace = 'infrastukturfolgekosten'
class Verkaufsflaechen(ProjectTable): id_teilflaeche = Field(int, 0) id_sortiment = Field(int, 0) name_sortiment = Field(str, '') verkaufsflaeche_qm = Field(int, 0) class Meta: workspace = 'definitions'
class GesamtkostenTraeger(ProjectTable): IDNetz = Field(int, 0) Netz = Field(str, '') Betrag_GSB = Field(float, 0) Betrag_GEM = Field(float, 0) Betrag_ALL = Field(float, 0) class Meta: workspace = 'infrastukturfolgekosten'
class Haltestellen(ProjectTable): abfahrten = Field(int, 0) id_bahn = Field(int, 0) flaechenzugehoerig = Field(bool, False) name = Field(str, '') berechnet = Field(str, '') class Meta: workspace = 'erreichbarkeiten'
class WohnenStruktur(ProjectTable): id_teilflaeche = Field(int, 0) jahr = Field(int, 0) alter_we = Field(int, 0) id_gebaeudetyp = Field(int, 0) wohnungen = Field(float, 0) class Meta: workspace = 'bewohner_arbeitsplaetze'
def test_fields(self): self.table.add_field(Field(int, default=0, name='1')) self.table.add_field(Field(str, default='hallo', name='2')) self.table.add(geom=None) df = self.table.to_pandas(columns=self.table.field_names) uq1 = df['1'].unique() uq2 = df['2'].unique() assert len(uq1) == 1 assert uq1[0] == 0 assert len(uq2) == 1 assert uq2[0] == '"hallo"'
class TestProjectTable(ProjectTable): name = Field(str) value = Field(float, default=1.0) is_true = Field(bool, default=False) class Meta: workspace = 'test' name = 'huhu' database = Geopackage geom = 'Polygon' @classmethod def extra(cls): setattr(cls, 'extra_field', Field(int, default=-1))
class GrundsteuerSettings(ProjectTable): Hebesatz_GrStB = Field(int, 0) EFH_Rohmiete = Field(int, 0) DHH_Rohmiete = Field(int, 0) RHW_Rohmiete = Field(int, 0) MFH_Rohmiete = Field(int, 0) Bodenwert_SWV = Field(int, 0) Bueroflaeche = Field(int, 0) Verkaufsraeume = Field(int, 0) qm_Grundstueck_pro_WE_EFH = Field(int, 0) is_new_bundesland = Field(bool, True) class Meta: workspace = 'einnahmen'
def test_02_auto_add_missing_fields(self): features = TestProjectTable.features(create=True) for i in range(5): features.add(name=i) TestProjectTable.missing = Field(int, default=50) features = TestProjectTable.features() df = features.to_pandas() assert df['missing'].unique()[0] == 50
class MarketCellRelations(ProjectTable): id_markt = Field(int, 0) id_siedlungszelle = Field(int, 0) distanz = Field(int, 0) kk_strom_nullfall = Field(float, 0) kk_strom_planfall = Field(float, 0) kk_bindung_nullfall = Field(float, 0) kk_bindung_planfall = Field(float, 0) in_auswahl = Field(bool, False) luftlinie = Field(int, 0) class Meta: workspace = 'marketcompetition'
class Projektrahmendaten(ProjectTable): ags = Field(str, '') gemeinde_name = Field(str, '') gemeinde_typ = Field(int, 0) projekt_name = Field(str, '') haltestellen_berechnet = Field(str, '') datum = Field(str, '') basisdaten_version = Field(float, 0) basisdaten_datum = Field(str, '') class Meta: workspace = 'definitions'
class Gewerbeanteile(ProjectTable): id_teilflaeche = Field(int, 0) name_teilflaeche = Field(str, '') id_branche = Field(int, 0) name_branche = Field(str, '') anteil_definition = Field(int, 0) anteil_branche = Field(int, 0) anzahl_jobs_schaetzung = Field(int, 0) dichtekennwert = Field(int, 0) class Meta: workspace = 'definitions'
class ErschliessungsnetzPunkte(ProjectTable): IDNetz = Field(int, 0) IDNetzelement = Field(int, 0) bezeichnung = Field(str, '') Euro_EH = Field(float, 0) Euro_EN = Field(float, 0) Cent_BU = Field(int, 0) Lebensdauer = Field(int, 0) class Meta: workspace = 'infrastukturfolgekosten'
class BeschaeftigtenWanderung(ProjectTable): AGS = Field(str, '') GEN = Field(str, '') zuzug = Field(float, 0) fortzug = Field(float, 0) saldo = Field(float, 0) fixed = Field(bool, False) wanderungs_anteil = Field(float, 0) class Meta: workspace = 'einnahmen'
class ErreichbarkeitenOEPNV(ProjectTable): id_origin = Field(int, 0) id_destination = Field(int, 0) verkehrsmittel = Field(str, '') abfahrt = Field(str, '') umstiege = Field(int, 0) ziel = Field(str, '') dauer = Field(str, '') class Meta: workspace = 'erreichbarkeiten'
class Wohneinheiten(ProjectTable): id_teilflaeche = Field(int, 0) id_gebaeudetyp = Field(int, 0) name_gebaeudetyp = Field(str, 0) we = Field(int, 0) ew_je_we = Field(float, 0) korrekturfaktor = Field(float, 0) anteil_u18 = Field(int, 0) class Meta: workspace = 'definitions'
class KostenkennwerteLinienelemente(ProjectTable): IDNetz = Field(int, 0) IDNetzelement = Field(int, 0) Euro_EH = Field(float, 0) Euro_EN = Field(float, 0) Cent_BU = Field(int, 0) Lebensdauer = Field(int, 0) class Meta: workspace = 'infrastukturfolgekosten'
class SettlementCells(ProjectTable): ew = Field(int, 0) kk_index = Field(float, 1) kk = Field(float, 0) id_teilflaeche = Field(int, 0) in_auswahl = Field(bool, False) ags = Field(str, '') class Meta: workspace = 'marketcompetition'
class WohnenProJahr(ProjectTable): id_teilflaeche = Field(int, 0) name_teilflaeche = Field(str, '') jahr = Field(int, 0) id_altersklasse = Field(int, 0) altersklasse = Field(str, '') bewohner = Field(float, 0) class Meta: workspace = 'bewohner_arbeitsplaetze'