def hifld_national():
#['VAL_DATE', 'NAICS_DESC', 'COUNTRY', 'NAICS_CODE', 'UNITS', 'RevGeoFlag', 'SOURCEDATE', 'MHPID', 'WEBSITE', 'VAL_METHOD', 'SOURCE', 'ZIP4', 'STATUS', 'COUNTYFIPS', 'ZIP', '\xef\xbb\xbfX', 'LONGITUDE', 'COUNTY', 'STATE', 'FID', 'Y', 'SIZE', 'CITY', 'YEARBLT', 'NAME', 'ADDRESS2', 'TELEPHONE', 'ADDRESS', 'LATITUDE', 'TYPE']
payload = tpcsv.open_source_csv('source_files/HIFLD_Mobile_Home_Parks.csv')
data = payload[0]
headers = payload[1]
parks = []
for park in data:
if park['NAICS_CODE'] == '721211':
continue
else:
address = park['ADDRESS']
county = park['COUNTY']
state = park['STATE']
zipcode = park['ZIP']
name = park['NAME']
city = park['CITY']
total_lots = park['UNITS']
phone_number = park['TELEPHONE']
website = park['WEBSITE']
info_list = [
str("total_lots:" + total_lots),
str("phone_number:" + phone_number),
str("zipcode:" + zipcode),
str("website:" + website)
]
info = "\n".join(info_list)
geo_location = str(park['LATITUDE']) + ", " + str(park['LONGITUDE'])
information = db.apply_schema(
park_name = name,
park_county = county,
park_address = address,
city = city,
park_info = info,
other_contact_info = phone_number,
geo_location = geo_location,
state = state,
total_lots = total_lots
)
park_a = [information]
parks.append(information)
print " :: {} :: {}".format(information['park_name'], information['geo_location'])
tpcsv.write_source_csv(park_a, "pa_complete.csv")
return parks
def mh_village_PA():
#ID,Name,Address,City,State,Zip,County,"Site Count","Average Monthly Rent","Phone Number","Vacant Sites"
payload = tpcsv.open_source_csv('source_files/PACommunityReport.csv')
data = payload[0]
headers = payload[1]
parks = []
for park in data:
address = park['Address']
county = park['County']
state = park['State']
zipcode = park['Zip']
name = park['Name']
city = park['City']
total_lots = park['Site Count']
avg_rent = park['Average Monthly Rent']
phone_number = park['Phone Number']
vacant_lots = park['Vacant Sites']
info_list = [
str("total_lots:" + total_lots),
str("avg_rent:" + avg_rent),
str("phone_number:" + phone_number),
str("vacant_lots:" + vacant_lots),
str("zipcode:" + zipcode),
]
info = "\n".join(info_list)
geo_location = get_park_geolocation(address, county, state, zipcode)
information = db.apply_schema(
park_name = name,
park_county = county,
park_address = address,
city = city,
park_info = info,
other_contact_info = phone_number,
geo_location = geo_location,
state = state,
total_lots = total_lots
)
park_a = [information]
parks.append(information)
print " :: {} :: {}".format(information['park_name'], information['geo_location'])
tpcsv.write_source_csv(park_a, "pa_complete.csv")
return parks