def import_blocks(blocks_layer): sides = ('R', 'L') for i, feature in enumerate(blocks_layer): for side in sides: from_num = feature['%s_ADD_FROM' % side] to_num = feature['%s_ADD_TO' % side] zip = feature['%s_ZIP' % side] street_name = feature['ST_NAME'] if from_num and to_num and zip and street_name: if from_num > to_num: from_num, to_num = to_num, from_num street_pretty_name, block_pretty_name = make_pretty_name( from_num, to_num, feature['PRE_DIR'], street_name, feature['ST_TYPE'], feature['SUF_DIR']) block, created = Block.objects.get_or_create( pretty_name=block_pretty_name, predir=(feature['PRE_DIR'] or ''), street=street_name, street_slug=slugify( '%s %s' % (street_name, (feature['ST_TYPE'] or ''))), street_pretty_name=street_pretty_name, suffix=(feature['ST_TYPE'] or ''), postdir=(feature['SUF_DIR'] or ''), from_num=from_num, to_num=to_num, zip=zip, city='FAKE', # we don't know it yetc state='FL', location='SRID=4326;%s' % str(feature.geometry)) logger.debug('%s block %r' % (created and 'Created' or 'Already had', block)) if i % 100 == 0: logger.info('Created %s blocks' % i)
def update_block_pretty_names(): for b in Block.objects.all().iterator(): name = make_pretty_name(b.from_num, b.to_num, b.predir, b.street, b.suffix)[1] if name != b.pretty_name: print '%s -- %s' % (b.pretty_name, name) b.pretty_name = name b.save()
def import_blocks(blocks_layer): sides = ('R', 'L') for i, feature in enumerate(blocks_layer): for side in sides: from_num = feature['%s_ADD_FROM' % side] to_num = feature['%s_ADD_TO' % side] zip = feature['%s_ZIP' % side] street_name = feature['ST_NAME'] if from_num and to_num and zip and street_name: if from_num > to_num: from_num, to_num = to_num, from_num street_pretty_name, block_pretty_name = make_pretty_name( from_num, to_num, feature['PRE_DIR'], street_name, feature['ST_TYPE'], feature['SUF_DIR']) block, created = Block.objects.get_or_create( pretty_name=block_pretty_name, predir=(feature['PRE_DIR'] or ''), street=street_name, street_slug=slugify('%s %s' % (street_name, (feature['ST_TYPE'] or ''))), street_pretty_name=street_pretty_name, suffix=(feature['ST_TYPE'] or ''), postdir=(feature['SUF_DIR'] or ''), from_num=from_num, to_num=to_num, zip=zip, city='FAKE', # we don't know it yetc state='FL', location='SRID=4326;%s' % str(feature.geometry) ) logger.debug('%s block %r' % (created and 'Created' or 'Already had', block)) if i % 100 == 0: logger.info('Created %s blocks' % i)