class ImportedPlacetype(CsvModel): name = CharField(prepare=lambda x: x or '') clean_name = CharField(prepare=lambda x: x or '') color = CharField(prepare=lambda x: x or '') intersection_density = FloatField(prepare=lambda x: x or 0) class Meta: delimiter = "," has_header = True
class ImportPlacetypeComponent(CsvModel): # BTID,Building_Type, # Urban Mixed Use,Urban Residential,Urban Commercial,City Mixed Use,City Residential,City Commercial, # Town Mixed Use,Town Residential,Town Commercial,Village Mixed Use,Village Residential,Village Commercial, # Neighborhood Residential,Neighborhood Low,Office Focus,Mixed Office and R&D,Office/Industrial,Industrial Focus, # Low-Density Employment Park,High Intensity Activity Center,Mid Intensity Activity Center, # Low Intensity Retail-Centered N'Hood,Retail: Strip Mall/ Big Box,Industrial/Office/Res Mixed High, # Industrial/Office/Res Mixed Low,Suburban Multifamily,Suburban Mixed Residential,Residential Subdivision, # Large Lot Residential Area,Rural Residential,Rural Ranchettes,Rural Employment,Campus/ University, # Institutional,Parks & Open Space,BuildingType Name,Gross_Net_Flag category = CharField(prepare=lambda x: x or '') btid = IntegerField(prepare=lambda x: x or 0) color = CharField(prepare=lambda x: x or '') name = CharField(prepare=lambda x: x or '') urban_mixed_use = FloatField(prepare=lambda x: x or 0) urban_residential = FloatField(prepare=lambda x: x or 0) urban_commercial = FloatField(prepare=lambda x: x or 0) city_mixed_use = FloatField(prepare=lambda x: x or 0) city_residential = FloatField(prepare=lambda x: x or 0) city_commercial = FloatField(prepare=lambda x: x or 0) town_mixed_use = FloatField(prepare=lambda x: x or 0) town_residential = FloatField(prepare=lambda x: x or 0) town_commercial = FloatField(prepare=lambda x: x or 0) village_mixed_use = FloatField(prepare=lambda x: x or 0) village_residential = FloatField(prepare=lambda x: x or 0) village_commercial = FloatField(prepare=lambda x: x or 0) neighborhood_residential = FloatField(prepare=lambda x: x or 0) neighborhood_low = FloatField(prepare=lambda x: x or 0) office_focus = FloatField(prepare=lambda x: x or 0) mixed_office_and_r_and_d = FloatField(prepare=lambda x: x or 0) office_industrial = FloatField(prepare=lambda x: x or 0) industrial_focus = FloatField(prepare=lambda x: x or 0) low_density_employment_park = FloatField(prepare=lambda x: x or 0) high_intensity_activity_center = FloatField(prepare=lambda x: x or 0) mid_intensity_activity_center = FloatField(prepare=lambda x: x or 0) low_intensity_retail_centered_neighborhood = FloatField( prepare=lambda x: x or 0) retail_strip_mall_big_box = FloatField(prepare=lambda x: x or 0) industrial_office_residential_mixed_high = FloatField( prepare=lambda x: x or 0) industrial_office_residential_mixed_low = FloatField( prepare=lambda x: x or 0) suburban_multifamily = FloatField(prepare=lambda x: x or 0) suburban_mixed_residential = FloatField(prepare=lambda x: x or 0) residential_subdivision = FloatField(prepare=lambda x: x or 0) large_lot_residential = FloatField(prepare=lambda x: x or 0) rural_residential = FloatField(prepare=lambda x: x or 0) rural_ranchettes = FloatField(prepare=lambda x: x or 0) rural_employment = FloatField(prepare=lambda x: x or 0) campus_or_university = FloatField(prepare=lambda x: x or 0) institutional = FloatField(prepare=lambda x: x or 0) parks_and_open_space = FloatField(prepare=lambda x: x or 0) class Meta: delimiter = "," has_header = True
class ImportPrimaryComponent(CsvModel): # id id = IntegerField(prepare=lambda x: x or 0) #source,hyperlink,building_type, source = CharField(prepare=lambda x: x or '') website = CharField(prepare=lambda x: x or '') placetype_component = CharField(prepare=lambda x: x or '') #building,household_size, name = CharField(prepare=lambda x: x or '') address = CharField(prepare=lambda x: x or '') vacancy_rate = FloatField(prepare=lambda x: x or 0) household_size = FloatField(prepare=lambda x: x or 0) #Pct_SF_Large_Lot,Pct_SF_Small_Lot,Pct_Attached_SF,Pct_MF_2_to_4,Pct_MF_5_Plus, percent_detached_single_family = FloatField(prepare=lambda x: x or 0) percent_attached_single_family = FloatField(prepare=lambda x: x or 0) percent_multifamily_2_to_4 = FloatField(prepare=lambda x: x or 0) percent_multifamily_5_plus = FloatField(prepare=lambda x: x or 0) # Pct_Emp_Office_Svc,Pct_Educ_Svc,Pct_Medical_Svc,Pct_Public_Admin, percent_office_services = FloatField(prepare=lambda x: x or 0) percent_education_services = FloatField(prepare=lambda x: x or 0) percent_medical_services = FloatField(prepare=lambda x: x or 0) percent_public_admin = FloatField(prepare=lambda x: x or 0) #Pct_Retail_Svc,Pct_Restuarant,Pct_Accommodation,Pct_Arts_Entertainment,Pct_Other_Svc, percent_retail_services = FloatField(prepare=lambda x: x or 0) percent_restaurant = FloatField(prepare=lambda x: x or 0) percent_accommodation = FloatField(prepare=lambda x: x or 0) percent_arts_entertainment = FloatField(prepare=lambda x: x or 0) percent_other_services = FloatField(prepare=lambda x: x or 0) # Pct_Manufacturing,Pct_Transport_warehouse,Pct_Wholesale,Pct_Construction_Util,Pct_Agriculture,Pct_Extraction, percent_manufacturing = FloatField(prepare=lambda x: x or 0) percent_transport_warehouse = FloatField(prepare=lambda x: x or 0) percent_wholesale = FloatField(prepare=lambda x: x or 0) percent_construction_utilities = FloatField(prepare=lambda x: x or 0) percent_agriculture = FloatField(prepare=lambda x: x or 0) percent_extraction = FloatField(prepare=lambda x: x or 0) # Pct_ArmedForces,Pct_Military percent_military = FloatField(prepare=lambda x: x or 0) # percent_of_building_type,floors,percent_residential,percent_retail,percent_office,percent_industrial, percent_of_placetype_component = FloatField(prepare=lambda x: x or 0) lot_size_square_feet = FloatField(prepare=lambda x: x or 0) floors = FloatField(prepare=lambda x: x or 0) #total_far,parking_spaces,parking_structure_square_feet,residential_efficiency,residential_lot_square_feet,square_feet_per_du, total_far = FloatField(prepare=lambda x: x or 0) #residential efficiency residential_efficiency = FloatField(prepare=lambda x: x or 0) residential_square_feet_per_unit = FloatField(prepare=lambda x: x or 0) # retail_efficiency,retail_square_feet_per_employee,office_efficiency,office_square_feet_per_employee, retail_efficiency = FloatField(prepare=lambda x: x or 0) retail_square_feet_per_unit = FloatField(prepare=lambda x: x or 0) #office efficiency, etc. office_efficiency = FloatField(prepare=lambda x: x or 0) office_square_feet_per_unit = FloatField(prepare=lambda x: x or 0) #industrial_efficiency,industrial_square_feet_per_employee, industrial_efficiency = FloatField(prepare=lambda x: x or 0) industrial_square_feet_per_unit = FloatField(prepare=lambda x: x or 0) average_parking_space_square_feet = FloatField(prepare=lambda x: x or 0) surface_parking_spaces = FloatField(prepare=lambda x: x or 0) above_ground_parking_spaces = FloatField(prepare=lambda x: x or 0) below_ground_parking_spaces = FloatField(prepare=lambda x: x or 0) building_footprint_square_feet = FloatField(prepare=lambda x: x or 0) surface_parking_square_feet = FloatField(prepare=lambda x: x or 0) hardscape_other_square_feet = FloatField(prepare=lambda x: x or 0) irrigated_softscape_square_feet = FloatField(prepare=lambda x: x or 0) nonirrigated_softscape_square_feet = FloatField(prepare=lambda x: x or 0) irrigated_percent = FloatField(prepare=lambda x: x or 0) id2 = IntegerField(prepare=lambda x: x or 0) class Meta: delimiter = "," has_header = True
class ImportCropType(CsvModel): id = IntegerField(prepare=lambda x: x or 0) name = CharField(prepare=lambda x: x or '') alfalfa = FloatField(prepare=lambda x: x or 0) almonds = FloatField(prepare=lambda x: x or 0) apples = FloatField(prepare=lambda x: x or 0) apricots = FloatField(prepare=lambda x: x or 0) asparagus = FloatField(prepare=lambda x: x or 0) beans = FloatField(prepare=lambda x: x or 0) blueberries = FloatField(prepare=lambda x: x or 0) corn = FloatField(prepare=lambda x: x or 0) grapes = FloatField(prepare=lambda x: x or 0) mandarins = FloatField(prepare=lambda x: x or 0) nursery = FloatField(prepare=lambda x: x or 0) olives = FloatField(prepare=lambda x: x or 0) other_citrus = FloatField(prepare=lambda x: x or 0) other_fruits_and_nuts = FloatField(prepare=lambda x: x or 0) other_stone_fruits = FloatField(prepare=lambda x: x or 0) pasture = FloatField(prepare=lambda x: x or 0) peaches = FloatField(prepare=lambda x: x or 0) pears = FloatField(prepare=lambda x: x or 0) prunes = FloatField(prepare=lambda x: x or 0) rice = FloatField(prepare=lambda x: x or 0) safflower = FloatField(prepare=lambda x: x or 0) strawberry = FloatField(prepare=lambda x: x or 0) sunflower = FloatField(prepare=lambda x: x or 0) timber = FloatField(prepare=lambda x: x or 0) tomatoes = FloatField(prepare=lambda x: x or 0) vegetables = FloatField(prepare=lambda x: x or 0) walnuts = FloatField(prepare=lambda x: x or 0) wheat = FloatField(prepare=lambda x: x or 0)
class ImportCrop(CsvModel): id = IntegerField(prepare=lambda x: x or 0) name = CharField(prepare=lambda x: x or '') crop_yield = FloatField(prepare=lambda x: x or 0) unit_price = FloatField(prepare=lambda x: x or 0) cost = FloatField(prepare=lambda x: x or 0) water_consumption = FloatField(prepare=lambda x: x or 0) labor_input = FloatField(prepare=lambda x: x or 0) truck_trips = FloatField(prepare=lambda x: x or 0) seed_cost = FloatField(prepare=lambda x: x or 0) chemical_cost = FloatField(prepare=lambda x: x or 0) fertilizer_cost = FloatField(prepare=lambda x: x or 0) custom_cost = FloatField(prepare=lambda x: x or 0) contract_cost = FloatField(prepare=lambda x: x or 0) irrigation_cost = FloatField(prepare=lambda x: x or 0) labor_cost = FloatField(prepare=lambda x: x or 0) equipment_cost = FloatField(prepare=lambda x: x or 0) fuel_cost = FloatField(prepare=lambda x: x or 0) other_cost = FloatField(prepare=lambda x: x or 0) feed_cost = FloatField(prepare=lambda x: x or 0) pasture_cost = FloatField(prepare=lambda x: x or 0) land_rent_cost = FloatField(prepare=lambda x: x or 0) other_cash_costs = FloatField(prepare=lambda x: x or 0) # We don't store this. We calculate it from everything above on the front-end total_cash_costs = FloatField(prepare=lambda x: x or 0) establishment_cost = FloatField(prepare=lambda x: x or 0) land_cost = FloatField(prepare=lambda x: x or 0) other_noncash_costs = FloatField(prepare=lambda x: x or 0) # We don't store this. We calculate it from everything above on the front-end total_noncash_costs = FloatField(prepare=lambda x: x or 0) class Meta: delimiter = "," has_header = True