search

datachile / datachile-mondrian

Schema de Mondrian para DataChile. Server API.
https://chilecube.datachile.io/cubes
1 stars 2 forks source link

casen_household missing zona #23

Closed pachadotdev closed 6 years ago

pachadotdev commented 6 years ago

Check here: https://chilecube.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJEYXRlIiwiRGF0ZSIsIlllYXIiXV0sImN1dHMiOltbWzIwMTVdLFsiRGF0ZSIsIkRhdGUiLCJZZWFyIl1dXSwiY3ViZSI6ImNhc2VuX2hvdXNlaG9sZCIsIm1lYXN1cmVzIjpbIkV4cGFuc2lvbiBGYWN0b3IgUmVnaW9uIl19

"Zona" is not available :(

However, http://pacha.datawheel.us/datachile/economy/casen/analysis/3_household/household_for_db.csv has that dimension as is described in http://pacha.datawheel.us/datachile/economy/casen/analysis/3_household/zona_id.csv

screenshot from 2017-11-02 16-59-14

jazzido commented 6 years ago

It needs to be ingested, right?

pachadotdev commented 6 years ago

@jazzido unless there's way to paste the column

palamago commented 6 years ago

It's true, is missing in the database. My bad probably.

table fact_household_casen
(
    comuna_id integer,
    household_type integer,
    walls_material integer,
    floor_material integer,
    ceiling_material integer,
    households_in_land integer,
    land_using integer,
    household_sq_meters integer,
    household_using integer,
    family_member_owner integer,
    family_member_owner_2 integer,
    subsidy_or_program integer,
    credit integer,
    paying_credit integer,
    water_source integer,
    water_distribution integer,
    waste_disposal integer,
    electricity integer,
    rooms integer,
    bathrooms integer,
    families_in_household integer,
    reason_to_share integer,
    cooking_energy_source integer,
    heating_energy_source integer,
    hot_water_energy_source integer,
    less_than_8_blocks_public_transport integer,
    less_than_20_blocks_educational_center integer,
    less_than_20_blocks_health_center integer,
    less_than_20_blocks_market integer,
    less_than_20_blocks_atm integer,
    less_than_20_blocks_sports_center integer,
    less_than_20_blocks_green_areas integer,
    less_than_20_blocks_community_equipment integer,
    less_than_20_blocks_pharmacy integer,
    affected_by_acoustic_contamination integer,
    affected_by_air_contamination integer,
    affected_by_river_or_lake_contamination integer,
    affected_by_public_water_source_contamination integer,
    affected_by_graffitis_or_advertising integer,
    affected_by_accumulation_of_trash_public_areas integer,
    affected_by_animal_or_insect_plague integer,
    expr integer,
    expc integer,
    comuna_datachile_id integer,
    year integer,
    date_id integer
);
palamago commented 6 years ago

re-ingested and column added to schema. https://chilecube.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJab25lIElkIiwiWm9uZSBJZCIsIlpvbmUgSWQiXV0sImN1dHMiOltdLCJjdWJlIjoiY2FzZW5faG91c2Vob2xkIiwibWVhc3VyZXMiOlsiTnVtYmVyIG9mIHJlY29yZHMiXX0=