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())