search

antievictionmappingproject / covid-19-map-react

COVID-19 Emergency Tenant Protections Map (refactored to use React!)
13 stars 9 forks source link

Carto <-> Airtable web service #49

Closed c5inco closed 3 years ago

c5inco commented 3 years ago

Tracking bug for work to build better data pipeline so Carto can query Airtable more directly.

lisjak commented 3 years ago

@azadag @jimboweb @unixjazz what's the status on this? :)

azadag commented 3 years ago

I think i want to set up some sort of github action to automatically do the data sync, will have to learn to set this up though!

azadag commented 3 years ago

Ok this is finished... new data can be found at https://ampitup.carto.com/dataset/global_housing_actions exported here. See old link for reference, and airtable base

variables starting with housingexp and housing_part__ are width-wise expansions + english only translations of airtable variable housing_experience_type; and housing_justice_participation_3 these are dummy variables using 1 and 0...

housing_experience_type - means have you experienced, eviction, taken part in a justice action, or experienced landlord retaliation

carto variables + old version if existed in quotes id local_neighb_city_state_country = 'location' Latitude Longitude participation_reason = 'why' num_occupants_involved debt - text entry - what has your experience with debt been like housing_exp_eviction - 0/1 dummy have you experienced eviction housing_exp_housing_justice_action - 0/1 dummy - have you participated in a housing justice action housing_exp_landlord_retaliation - 0/1 dummy - have you experienced landlord retaliation experienced_landlord_retaliation - 'text entry' - how has your landlord threathened you for not paying the rent date_recieved_communication - date/string- when did you recieve communication threathening retaliation from your landlord housing_part_campaigning_list_of_demands - 0/1 dummy - hja participation - you are on a rent strike housing_part_mutual_aid_direct_aid - 0/1 dummy - hja participation - you are participating in direct aid housing_part_occupation_squat - 0/1 dummy - hja participation - you are occupying or squating housing_part_rent_strike_rent_decrease - 0/1 dummy - hja participation - you are on rent strike or requesting rent decrease housing_part_other - 0/1 dummy - hja participation - selected 'other' housing_justice_other - text entry - what other type of action are yo utaking property_ll_owner - text entry - what is the name of your landlord local_resources - text entry - what resources are available in your local area

unixjazz commented 3 years ago

hi @azadag: what do you need help with?

azadag commented 3 years ago

Oh! I think reviewing the data types, variable names, etc to prepare for swapping out the old version? Am I outputting data correctly (NULL vs empty cells).