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'
