def run(): print "Loading State data" xmldoc = minidom.parse('HealthMap/scripts/states.xml') cNodes = xmldoc.childNodes sList = cNodes[0].getElementsByTagName( "state") # top level in DOM is States for state in sList: # iterate through each State # create the State record in Region table print("%s (%s)" % (state.getAttribute('name'), state.getAttribute('abbrev'))) reg = Region(state=state.getAttribute('abbrev'), stateName=state.getAttribute('name')) reg.save() pList = state.getElementsByTagName("point") for point in pList: # iterate through polyline points # create the Polyline record # print ("lat:%s, lng:%s" % (point.getAttribute('lat'),point.getAttribute('lng'))) line = Polyline(region=reg, lat=point.getAttribute('lat'), lng=point.getAttribute('lng')) line.save() print("... %s lat/lng points" % len(pList))
def run(): # clean up if necessary print "Loading County data" book = open_workbook('HealthMap/scripts/data.xls') sheet = book.sheet_by_index(1) for row_index in range(sheet.nrows): fips = sheet.cell(row_index,0).value state = sheet.cell(row_index,1).value county = sheet.cell(row_index,2).value if len(state)>1 and len(county)<1: # state data row print state if len(fips)==5: state_reg = Region.objects.filter(stateName=state.strip()) state_abbrev = state_reg[0].state # get State abbrev reg = Region.objects.filter(state=state_abbrev, county=county) if reg: reg.delete() # cleanup existing print("[%s] %s, County: %s (%s)" % (state_abbrev, state, county, fips)) reg = Region(state=state_abbrev, stateName=state, county=county, fips=fips) reg.save()