{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Enrich Polygons from a Dataset\n", "\n", "This example illustrates how to enrich polygons that are in a dataset with variables from CARTO's Data Observatory.\n", "\n", "_Note: You'll need [CARTO Account](https://carto.com/signup) credentials to reproduce this example._" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "from cartoframes.auth import set_default_credentials\n", "\n", "set_default_credentials('creds.json')" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | OBJECTID | \n", "FULLTRACTID | \n", "TRACTID | \n", "geometry | \n", "
---|---|---|---|---|
0 | \n", "1 | \n", "51013102901 | \n", "102901 | \n", "POLYGON ((-77.09099 38.84516, -77.08957 38.844... | \n", "
1 | \n", "2 | \n", "51013103000 | \n", "103000 | \n", "POLYGON ((-77.08558 38.82992, -77.08625 38.828... | \n", "
2 | \n", "3 | \n", "51013102902 | \n", "102902 | \n", "POLYGON ((-77.09520 38.84499, -77.09442 38.844... | \n", "
\n", " | slug | \n", "name | \n", "description | \n", "category_id | \n", "country_id | \n", "data_source_id | \n", "provider_id | \n", "geography_name | \n", "geography_description | \n", "temporal_aggregation | \n", "time_coverage | \n", "update_frequency | \n", "is_public_data | \n", "lang | \n", "version | \n", "category_name | \n", "provider_name | \n", "geography_id | \n", "id | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "acs_sociodemogr_858c104e | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2008-01-01, 2013-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20082012 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
1 | \n", "acs_sociodemogr_6bf5c7f4 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20142018 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
2 | \n", "acs_sociodemogr_dda43439 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2011-01-01, 2016-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20112015 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
3 | \n", "acs_sociodemogr_97c32d1f | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2010-01-01, 2015-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20102014 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
4 | \n", "acs_sociodemogr_d4b2cf03 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2006-01-01, 2011-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20062010 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
5 | \n", "acs_sociodemogr_496a0675 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2013-01-01, 2018-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20132017 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
6 | \n", "acs_sociodemogr_9ed5d625 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2007-01-01, 2012-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20072011 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
7 | \n", "acs_sociodemogr_cfeb0968 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2009-01-01, 2014-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20092013 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
8 | \n", "acs_sociodemogr_30d1f53 | \n", "Sociodemographics - United States of America (... | \n", "The American Community Survey (ACS) is an ongo... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "usa_acs | \n", "Census Tract - United States of America (2015) | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "5yrs | \n", "[2012-01-01, 2017-01-01) | \n", "None | \n", "True | \n", "eng | \n", "20122016 | \n", "Demographics | \n", "American Community Survey | \n", "carto-do-public-data.carto.geography_usa_censu... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
\n", " | slug | \n", "name | \n", "description | \n", "db_type | \n", "agg_method | \n", "column_name | \n", "variable_group_id | \n", "dataset_id | \n", "id | \n", "
---|---|---|---|---|---|---|---|---|---|
79 | \n", "median_income_57be5af4 | \n", "Median Income | \n", "Median Household Income in the past 12 Months.... | \n", "FLOAT | \n", "AVG | \n", "median_income | \n", "None | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
165 | \n", "no_car_2207f034 | \n", "no_car | \n", "Workers age 16 and over with no vehicle. All p... | \n", "FLOAT | \n", "SUM | \n", "no_car | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
166 | \n", "no_cars_3a983c4e | \n", "no_cars | \n", "Car-free households. The number of households ... | \n", "FLOAT | \n", "SUM | \n", "no_cars | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
167 | \n", "one_car_13b3a60b | \n", "one_car | \n", "One car households. The number of households w... | \n", "FLOAT | \n", "SUM | \n", "one_car | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
168 | \n", "two_cars_fec37223 | \n", "two_cars | \n", "Two car households. The number of households w... | \n", "FLOAT | \n", "SUM | \n", "two_cars | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
169 | \n", "three_cars_32e541e7 | \n", "three_cars | \n", "Three car households. The number of households... | \n", "FLOAT | \n", "SUM | \n", "three_cars | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
170 | \n", "four_more_cars_297e8a8a | \n", "four_more_cars | \n", "Four car households. The number of households ... | \n", "FLOAT | \n", "SUM | \n", "four_more_cars | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
174 | \n", "commuters_by_ca_120481e3 | \n", "commuters_by_car_truck_van | \n", "Commuters by Car, Truck, or Van. The number of... | \n", "FLOAT | \n", "SUM | \n", "commuters_by_car_truck_van | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
175 | \n", "commuters_by_ca_59febe6f | \n", "commuters_by_carpool | \n", "Commuters by Carpool. The number of workers ag... | \n", "FLOAT | \n", "SUM | \n", "commuters_by_carpool | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
177 | \n", "commuters_drove_acf77a1 | \n", "commuters_drove_alone | \n", "Commuters who drove alone. The number of worke... | \n", "FLOAT | \n", "SUM | \n", "commuters_drove_alone | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
197 | \n", "employed_educat_958fdcfe | \n", "employed_education_health_social | \n", "Workers employed in firms in educational servi... | \n", "FLOAT | \n", "SUM | \n", "employed_education_health_social | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
201 | \n", "employed_other__a5acf594 | \n", "employed_other_services_not_public_admin | \n", "Workers employed in firms in other services ex... | \n", "FLOAT | \n", "SUM | \n", "employed_other_services_not_public_admin | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
205 | \n", "employed_transp_66aedbfd | \n", "employed_transportation_warehousing_utilities | \n", "Workers employed in firms in transportation, w... | \n", "FLOAT | \n", "SUM | \n", "employed_transportation_warehousing_utilities | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "carto-do-public-data.usa_acs.demographics_soci... | \n", "
\n", " | OBJECTID | \n", "FULLTRACTID | \n", "TRACTID | \n", "geometry | \n", "no_car | \n", "
---|---|---|---|---|---|
0 | \n", "1 | \n", "51013102901 | \n", "102901 | \n", "POLYGON ((-77.09099 38.84516, -77.08957 38.844... | \n", "0.657821 | \n", "
1 | \n", "2 | \n", "51013103000 | \n", "103000 | \n", "POLYGON ((-77.08558 38.82992, -77.08625 38.828... | \n", "87.516848 | \n", "
2 | \n", "3 | \n", "51013102902 | \n", "102902 | \n", "POLYGON ((-77.09520 38.84499, -77.09442 38.844... | \n", "123.512837 | \n", "