class Survey_Ygl(BasePoverty, PovertyValues):
__tablename__ = "survey_ygl"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
poverty_geo = db.Column(db.String(), primary_key=True)
poverty_level = db.Column(db.String(), primary_key=True)
geo = column_property(PovertyXWalk.geo)
@classmethod
def get_supported_levels(cls):
base_levels = super(Survey_Ygl, cls).get_supported_levels()
return dict(base_levels, **{POVERTY_LEVEL: [ALL, PPP1, PPP2]})
class Survey_Yg(BasePoverty):
__tablename__ = "survey_yg"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
poverty_geo = db.Column(db.String(), primary_key=True)
geo = column_property(PovertyXWalk.geo)
gini = db.Column(db.Float)
totpop = db.Column(db.Float)
url_name = column_property(
select([Geo.url_name])
.where(and_(poverty_geo == PovertyXWalk.poverty_geo, Geo.id == PovertyXWalk.geo)).limit(1)
)
class Survey_Ygr(BasePoverty):
__tablename__ = "survey_ygr"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
residence = db.Column(db.String(), primary_key=True)
poverty_geo = db.Column(db.String(), primary_key=True)
geo = column_property(PovertyXWalk.geo)
gini = db.Column(db.Float)
totpop = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
base_levels = super(Survey_Ygr, cls).get_supported_levels()
return dict(base_levels, **{RESIDENCE: [ALL, URBAN, RURAL]})
class Survey_Ygg(BasePoverty):
__tablename__ = "survey_ygg"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
gender = db.Column(db.String(), primary_key=True)
poverty_geo = db.Column(db.String(), primary_key=True)
geo = column_property(PovertyXWalk.geo)
gini = db.Column(db.Float)
totpop = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
base_levels = super(Survey_Ygg, cls).get_supported_levels()
return dict(base_levels, **{GENDER: [ALL, MALE, FEMALE]})
class ValueOfProduction(BaseCell5M):
__tablename__ = "value"
median_moe = 1
value_of_production = db.Column(db.Integer())
class HarvestedAreaBySupply(WaterSupply):
__tablename__ = "area_by_supply"
median_moe = 2
harvested_area = db.Column(db.Integer())
class HarvestedArea(BaseCell5M):
__tablename__ = "area"
median_moe = 1
harvested_area = db.Column(db.Integer())
def year(cls):
return db.Column(db.Integer(), primary_key=True)
class ValueOfProductionBySupply(WaterSupply):
__tablename__ = "value_by_supply"
median_moe = 2
value_of_production = db.Column(db.Integer())
