def process_row(self, r):
row = cleanup_row(r, replace=True)
pk = row[0]
status = row[14]
if status not in self.status_choices:
log.warn(
"Meetbout {} references non-existing status {}; skipping".format(
pk, status))
return
bouwblok = row[15]
return models.Meetbout(
pk=pk,
buurt=row[1],
x_coordinaat=parse_decimal(row[2]),
y_coordinaat=parse_decimal(row[3]),
hoogte_nap=parse_decimal(row[4]),
zakking_cumulatief=parse_decimal(row[5]),
datum=uva_datum(row[6]),
bouwblokzijde=row[7],
eigenaar=row[8],
beveiligd=uva_indicatie(row[9]),
stadsdeel=row[10],
adres=row[11],
locatie=row[12],
zakkingssnelheid=parse_decimal(row[13]),
status=status,
bouwbloknummer=bouwblok,
rollaag_id=self.rollagen.get(bouwblok),
blokeenheid=row[16] or 0,
geometrie=GEOSGeometry(row[17]),
)
def process_row(self, r):
row = cleanup_row(r, replace=True)
pk = row[0]
meting_type = row[2]
if meting_type not in self.type_choices:
log.warn(
"Meting {} references non-existing type {}; skipping".format(pk,
meting_type))
return
meetbout_id = row[5]
if meetbout_id not in self.meetbouten:
log.warn(
"Meting {} references non-existing meetbout {}; skipping".format(
pk, meetbout_id))
return
meting = models.Meting.objects.create(
pk=pk,
datum=uva_datum(row[1]),
type=meting_type,
hoogte_nap=parse_decimal(row[3]),
zakking=parse_decimal(row[4]),
meetbout_id=meetbout_id,
zakkingssnelheid=parse_decimal(row[9]),
zakking_cumulatief=parse_decimal(row[10]),
ploeg=row[11],
type_int=int(row[12]) if row[12] else None,
dagen_vorige_meting=int(row[13]) if row[13] else None,
pandmsl=row[14],
stadsdeel=row[15],
wvi=row[16],
)
for i in range(6, 9):
self.create_relation(meting, row[i])
return meting
def process_row(self, r):
row = cleanup_row(r, replace=True)
pk = row[0]
merk = int(row[3])
if merk not in self.merk_choices:
log.warn(
"Peilmerk {} references non-existing merk {}; skipping".format(
pk, merk))
return
# PEILMERKNR,HOOGTE,JAAR,MERK,OMSCHRIJVING,WINDRICHTING,X_MUURVLAK,Y_MUURVLAK,RWSNR,GEOMETRIE
return Peilmerk(
pk=pk,
hoogte=parse_decimal(row[1]),
jaar=int(row[2]),
merk=int(row[3]),
omschrijving=row[4],
windrichting=row[5],
muurvlak_x=int(row[6] or 0),
muurvlak_y=int(row[7] or 0),
rws_nummer=row[8],
geometrie=GEOSGeometry(row[9]),
)
def process_row(self, r):
row = cleanup_row(r, replace=True)
pk = row[1]
bouwblok = row[0]
return models.Rollaag(
pk=pk,
bouwblok=bouwblok,
x_coordinaat=parse_decimal(row[2]),
y_coordinaat=parse_decimal(row[3]),
geometrie=GEOSGeometry(row[4]),
)
def process_row(self, r):
row = cleanup_row(r, replace=True)
pk = row[0]
return models.Referentiepunt(
pk=pk,
x_coordinaat=parse_decimal(row[1]),
y_coordinaat=parse_decimal(row[2]),
hoogte_nap=parse_decimal(row[3]),
datum=uva_datum(row[4]),
locatie=row[5],
geometrie=GEOSGeometry(row[6]),
)