def forwards(self, orm):
"Import lots from HPD file"
owner = orm.Owner.objects.get(name='Housing Preservation and Development')
for lot in csv.DictReader(open(self.file, 'r')):
if lot['Vacant'] != 'yes':
continue
bbl = load.make_bbl(3, int(lot['Block']), int(lot['Lot']))
if orm.Lot.objects.filter(bbl=bbl).count() > 0:
print "Lot %s already exists. Skipping." % bbl
continue
saved_lot = orm.Lot(
address=lot['Address'],
borough='Brooklyn',
bbl=bbl,
block=lot['Block'],
lot=lot['Lot'],
zipcode=lot['ZipCode'],
owner=owner,
area=lot['Lot Area'],
area_acres=str(load.convert_sq_ft_to_acres(int(lot['Lot Area']))),
centroid_source=lot['point source'],
centroid=self._get_centroid(lot),
school_district=lot['School District'],
council=lot['City Council District'],
council_district=lot['Community District'],
police_precinct=lot['Police Precinct'],
)
saved_lot.save()
def backwards(self, orm):
"Remove lots from HPD file"
for lot in csv.DictReader(open(self.file, 'r')):
bbl = load.make_bbl(3, int(lot['Block']), int(lot['Lot']))
orm.Lot.objects.filter(bbl=bbl).delete()