{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Enrich Variable Name Lookup\n", "\n", "Enrich variable names can be represented using a variety of string representations depending on where you are looking. Frequently there is a need to cross reference between these. The `Country.enrich_variables` property provides the ability to easily retrieve a Pandas data frame. This data frame can be used to perform cross reference lookups, but there also is a hidden method you can use as well, `Country._ba_cntry.get_enrich_variables_from_name_list`. This method accepts any iterabe of strings, and will look up the values by checking for a sequence of case insensitive matches in the `name`, `alias`, `field_name` and `enrich_field_name` columns.\n", "\n", "NOTE: This requires at least version 1.9.1 of the Python API. This was included with the Pro 2.9 release, but if you have a previous release of Pro, you can get the most recent release of the Python API by [cloning your default Python environment, setting your new environment to be the default](https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/work-with-python-environments.htm) and [updating the ArcGIS Python API (arcgis) package](https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/work-with-python-packages.htm)." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "from pathlib import Path\n", "\n", "from arcgis.geoenrichment import Country\n", "from arcgis.gis import GIS\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Load Excel Table with Various Representations of Enrich Names\n", "\n", "This is a table of name variations for enrich variables I was passed to use as an example of different variations needing to be looked up." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "dir_prj = Path.cwd().parent\n", "dir_ref = dir_prj/'references'\n", "xlsx_pth = dir_ref/'arcmap_pro_variables.xlsx'\n", "\n", "assert xlsx_pth.exists()" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | guided_workflow_names | \n", "pro_enrich_names | \n", "fieldnames_arcmap | \n", "fieldnames_pro | \n", "
---|---|---|---|---|
0 | \n", "TOTPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.totpop_cy | \n", "TOTPOP_CY | \n", "populationtotals_totpop_cy | \n", "
1 | \n", "HHPOP_CY.2021 Key Demographic Indicators (Esri... | \n", "householdtotals.tothh_cy | \n", "HHPOP_CY | \n", "populationtotals_hhpop_cy | \n", "
2 | \n", "FAMPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.fampop_cy | \n", "FAMPOP_CY | \n", "populationtotals_fampop_cy | \n", "
3 | \n", "MP14129a_B.2021 Health (Market Potential) (Esr... | \n", "healthpersonalcare.mp14129a_b | \n", "MP14129a_B | \n", "healthpersonalcare_mp14129a_b | \n", "
4 | \n", "X11001_X.2021 Education (Consumer Spending) (E... | \n", "education.x11001_x | \n", "X11001_X | \n", "education_x11001_x | \n", "
5 | \n", "X11001_A.2021 Education (Consumer Spending) (E... | \n", "education.x11001_x_a | \n", "X11001_A | \n", "education_x11001_x_a | \n", "
6 | \n", "X11001_I.2021 Education (Consumer Spending) (E... | \n", "education.x11001_x_i | \n", "X11001_I | \n", "education_x11001_x_i | \n", "
7 | \n", "MP09147a_B.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09147a_b | \n", "MP09147a_B | \n", "electronicsinternet_mp09147a_b | \n", "
8 | \n", "MP09147a_I.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09147a_b_i | \n", "MP09147a_I | \n", "electronicsinternet_mp09147a_b_i | \n", "
9 | \n", "MP09148a_B.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09148a_b | \n", "MP09148a_B | \n", "electronicsinternet_mp09148a_b | \n", "
10 | \n", "MP09148a_I.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09148a_b_i | \n", "MP09148a_I | \n", "electronicsinternet_mp09148a_b_i | \n", "
11 | \n", "MP09134a_B.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09134a_b | \n", "MP09134a_B | \n", "electronicsinternet_mp09134a_b | \n", "
12 | \n", "MP09134a_I.2021 Electronics (Market Potential)... | \n", "electronicsinternet.mp09134a_b_i | \n", "MP09134a_I | \n", "electronicsinternet_mp09134a_b_i | \n", "
13 | \n", "ACSTOTPOP.2015-2019 Key Demographic Indicators... | \n", "veterans.acstotpop | \n", "ACSTOTPOP | \n", "veterans_acstotpop | \n", "
14 | \n", "MOETOTPOP.2015-2019 Key Demographic Indicators... | \n", "veterans.acstotpop_e | \n", "MOETOTPOP | \n", "veterans_acstotpop_e | \n", "
15 | \n", "RELTOTPOP.2015-2019 Key Demographic Indicators... | \n", "veterans.acstotpop_r | \n", "RELTOTPOP | \n", "veterans_acstotpop_r | \n", "
16 | \n", "INDAGRI_CY.2021 Labor Force (Esri) (US 2021 Re... | \n", "industry.indagri_cy | \n", "INDAGRI_CY | \n", "industry_indagri_cy | \n", "
17 | \n", "INDMIN_CY.2021 Labor Force (Esri) (US 2021 Ret... | \n", "industry.indmin_cy | \n", "INDMIN_CY | \n", "industry_indmin_cy | \n", "
18 | \n", "INDCONS_CY.2021 Labor Force (Esri) (US 2021 Re... | \n", "industry.indcons_cy | \n", "INDCONS_CY | \n", "industry_indcons_cy | \n", "
19 | \n", "HHWHTHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.hhwhthhr10 | \n", "HHWHTHHR10 | \n", "householdsbyraceofhouseholder_hhwhthhr10 | \n", "
20 | \n", "HHBLKHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.hhblkhhr10 | \n", "HHBLKHHR10 | \n", "householdsbyraceofhouseholder_hhblkhhr10 | \n", "
21 | \n", "HHAIHHR10.2010 Households by Race_Hispanic Ori... | \n", "householdsbyraceofhouseholder.hhaihhr10 | \n", "HHAIHHR10 | \n", "householdsbyraceofhouseholder_hhaihhr10 | \n", "
22 | \n", "HHASNHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.hhasnhhr10 | \n", "HHASNHHR10 | \n", "householdsbyraceofhouseholder_hhasnhhr10 | \n", "
23 | \n", "HHPIHHR10.2010 Households by Race_Hispanic Ori... | \n", "householdsbyraceofhouseholder.hhpihhr10 | \n", "HHPIHHR10 | \n", "householdsbyraceofhouseholder_hhpihhr10 | \n", "
24 | \n", "HHOTHHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.hhothhhr10 | \n", "HHOTHHHR10 | \n", "householdsbyraceofhouseholder_hhothhhr10 | \n", "
25 | \n", "TADULTBASE.2021 Tapestry Market Segmentation (... | \n", "tapestryadultsnew.tadultbase | \n", "TADULTBASE | \n", "tapestryadultsnew_tadultbase | \n", "
26 | \n", "TADULT01.2021 Tapestry Market Segmentation (Ad... | \n", "tapestryadultsnew.tadult01 | \n", "TADULT01 | \n", "tapestryadultsnew_tadult01 | \n", "
27 | \n", "TADULT02.2021 Tapestry Market Segmentation (Ad... | \n", "tapestryadultsnew.tadult02 | \n", "TADULT02 | \n", "tapestryadultsnew_tadult02 | \n", "
28 | \n", "POPGRW10CY.2021 Key Demographic Indicators (Es... | \n", "populationtotals.popgrw10cy | \n", "POPGRW10CY | \n", "populationtotals_popgrw10cy | \n", "
29 | \n", "DIVINDX_CY.2021 Race and Hispanic Origin (Esri... | \n", "raceandhispanicorigin.divindx_cy | \n", "DIVINDX_CY | \n", "raceandhispanicorigin_divindx_cy | \n", "
30 | \n", "MEDHINC_CY.2021 Income (Esri) (Esri USA 2021) | \n", "householdincome.medhinc_cy | \n", "MEDHINC_CY | \n", "householdincome_medhinc_cy | \n", "
31 | \n", "ACSMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.acsmedhinc | \n", "ACSMEDHINC | \n", "householdincome_acsmedhinc | \n", "
32 | \n", "MOEMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.acsmedhinc_e | \n", "MOEMEDHINC | \n", "householdincome_acsmedhinc_e | \n", "
33 | \n", "RELMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.acsmedhinc_r | \n", "RELMEDHINC | \n", "householdincome_acsmedhinc_r | \n", "
\n", " | name | \n", "alias | \n", "data_collection | \n", "enrich_name | \n", "enrich_field_name | \n", "
---|---|---|---|---|---|
0 | \n", "ACSMEDHINC | \n", "2019 Median HH Income (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.ACSMEDHINC | \n", "householdincome_ACSMEDHINC | \n", "
1 | \n", "MEDHINC_CY | \n", "2021 Median Household Income | \n", "householdincome | \n", "householdincome.MEDHINC_CY | \n", "householdincome_MEDHINC_CY | \n", "
2 | \n", "MP09147a_B | \n", "2021 Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_B | \n", "ElectronicsInternet_MP09147a_B | \n", "
3 | \n", "MP09148a_B | \n", "2021 Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_B | \n", "ElectronicsInternet_MP09148a_B | \n", "
4 | \n", "MP09134a_B | \n", "2021 Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_B | \n", "ElectronicsInternet_MP09134a_B | \n", "
5 | \n", "X11001_X | \n", "2021 Education | \n", "education | \n", "education.X11001_X | \n", "education_X11001_X | \n", "
6 | \n", "MP14129a_B | \n", "2021 Typically Spend 1-3 Hrs Exercising/Wk | \n", "HealthPersonalCare | \n", "HealthPersonalCare.MP14129a_B | \n", "HealthPersonalCare_MP14129a_B | \n", "
7 | \n", "INDAGRI_CY | \n", "2021 Industry: Agriculture | \n", "industry | \n", "industry.INDAGRI_CY | \n", "industry_INDAGRI_CY | \n", "
8 | \n", "INDMIN_CY | \n", "2021 Industry: Mining | \n", "industry | \n", "industry.INDMIN_CY | \n", "industry_INDMIN_CY | \n", "
9 | \n", "INDCONS_CY | \n", "2021 Industry: Construction | \n", "industry | \n", "industry.INDCONS_CY | \n", "industry_INDCONS_CY | \n", "
10 | \n", "HHWHTHHR10 | \n", "2010 HHs w/White HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHWHTHHR10 | \n", "householdsbyraceofhouseholder_HHWHTHHR10 | \n", "
11 | \n", "HHBLKHHR10 | \n", "2010 HHs w/Black HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHBLKHHR10 | \n", "householdsbyraceofhouseholder_HHBLKHHR10 | \n", "
12 | \n", "HHAIHHR10 | \n", "2010 HHs w/Amer Indian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHAIHHR10 | \n", "householdsbyraceofhouseholder_HHAIHHR10 | \n", "
13 | \n", "HHASNHHR10 | \n", "2010 HHs w/Asian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHASNHHR10 | \n", "householdsbyraceofhouseholder_HHASNHHR10 | \n", "
14 | \n", "HHPIHHR10 | \n", "2010 HHs w/Pacific Isl HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHPIHHR10 | \n", "householdsbyraceofhouseholder_HHPIHHR10 | \n", "
15 | \n", "HHOTHHHR10 | \n", "2010 HHs w/Other Race HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHOTHHHR10 | \n", "householdsbyraceofhouseholder_HHOTHHHR10 | \n", "
16 | \n", "TOTHH_CY | \n", "2021 Total Households | \n", "householdtotals | \n", "householdtotals.TOTHH_CY | \n", "householdtotals_TOTHH_CY | \n", "
17 | \n", "TADULTBASE | \n", "2021 Tapestry Adult Pop Base | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULTBASE | \n", "tapestryadultsNEW_TADULTBASE | \n", "
18 | \n", "TADULT01 | \n", "2021 Pop 18+ in Tapestry Seg 1A | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT01 | \n", "tapestryadultsNEW_TADULT01 | \n", "
19 | \n", "TADULT02 | \n", "2021 Pop 18+ in Tapestry Seg 1B | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT02 | \n", "tapestryadultsNEW_TADULT02 | \n", "
20 | \n", "TOTPOP_CY | \n", "2021 Total Population | \n", "populationtotals | \n", "populationtotals.TOTPOP_CY | \n", "populationtotals_TOTPOP_CY | \n", "
21 | \n", "FAMPOP_CY | \n", "2021 Family Population | \n", "populationtotals | \n", "populationtotals.FAMPOP_CY | \n", "populationtotals_FAMPOP_CY | \n", "
22 | \n", "POPGRW10CY | \n", "2010-2021 Growth Rate: Population | \n", "populationtotals | \n", "populationtotals.POPGRW10CY | \n", "populationtotals_POPGRW10CY | \n", "
23 | \n", "DIVINDX_CY | \n", "2021 Diversity Index | \n", "raceandhispanicorigin | \n", "raceandhispanicorigin.DIVINDX_CY | \n", "raceandhispanicorigin_DIVINDX_CY | \n", "
24 | \n", "ACSTOTPOP | \n", "2019 Total Population (ACS 5-Yr) | \n", "veterans | \n", "veterans.ACSTOTPOP | \n", "veterans_ACSTOTPOP | \n", "
\n", " | name | \n", "alias | \n", "data_collection | \n", "enrich_name | \n", "enrich_field_name | \n", "
---|---|---|---|---|---|
0 | \n", "MEDHINC_CY | \n", "2021 Median Household Income | \n", "Health | \n", "Health.MEDHINC_CY | \n", "Health_MEDHINC_CY | \n", "
1 | \n", "MOETOTPOP | \n", "2019 Total Population MOE (ACS 5-Yr) | \n", "ACS_Housing_Summary_rep | \n", "ACS_Housing_Summary_rep.MOETOTPOP | \n", "ACS_Housing_Summary_rep_MOETOTPOP | \n", "
2 | \n", "TADULTBASE | \n", "2021 Tapestry Adult Pop Base | \n", "travelMPI | \n", "travelMPI.TADULTBASE | \n", "travelMPI_TADULTBASE | \n", "
3 | \n", "TOTPOP_CY | \n", "2021 Total Population | \n", "Age_by_Sex_by_Race_Profile_rep | \n", "Age_by_Sex_by_Race_Profile_rep.TOTPOP_CY | \n", "Age_by_Sex_by_Race_Profile_rep_TOTPOP_CY | \n", "
4 | \n", "DIVINDX_CY | \n", "2021 Diversity Index | \n", "Policy | \n", "Policy.DIVINDX_CY | \n", "Policy_DIVINDX_CY | \n", "
5 | \n", "ACSMEDHINC | \n", "2019 Median HH Income (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.ACSMEDHINC | \n", "householdincome_ACSMEDHINC | \n", "
6 | \n", "MOEMEDHINC | \n", "2019 Median HH Income MOE (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.MOEMEDHINC | \n", "householdincome_MOEMEDHINC | \n", "
7 | \n", "RELMEDHINC | \n", "2019 Median HH Income REL (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.RELMEDHINC | \n", "householdincome_RELMEDHINC | \n", "
8 | \n", "X11001_I | \n", "2021 Index: Education | \n", "Community_Profile_rep | \n", "Community_Profile_rep.X11001_I | \n", "Community_Profile_rep_X11001_I | \n", "
9 | \n", "MP09147a_B | \n", "2021 Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_B | \n", "ElectronicsInternet_MP09147a_B | \n", "
10 | \n", "MP09147a_I | \n", "2021 Index: Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_I | \n", "ElectronicsInternet_MP09147a_I | \n", "
11 | \n", "MP09148a_B | \n", "2021 Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_B | \n", "ElectronicsInternet_MP09148a_B | \n", "
12 | \n", "MP09148a_I | \n", "2021 Index: Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_I | \n", "ElectronicsInternet_MP09148a_I | \n", "
13 | \n", "MP09134a_B | \n", "2021 Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_B | \n", "ElectronicsInternet_MP09134a_B | \n", "
14 | \n", "MP09134a_I | \n", "2021 Index: Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_I | \n", "ElectronicsInternet_MP09134a_I | \n", "
15 | \n", "X11001_X | \n", "2021 Education | \n", "education | \n", "education.X11001_X | \n", "education_X11001_X | \n", "
16 | \n", "X11001_A | \n", "2021 Avg: Education | \n", "education | \n", "education.X11001_A | \n", "education_X11001_A | \n", "
17 | \n", "MP14129a_B | \n", "2021 Typically Spend 1-3 Hrs Exercising/Wk | \n", "HealthPersonalCare | \n", "HealthPersonalCare.MP14129a_B | \n", "HealthPersonalCare_MP14129a_B | \n", "
18 | \n", "INDAGRI_CY | \n", "2021 Industry: Agriculture | \n", "industry | \n", "industry.INDAGRI_CY | \n", "industry_INDAGRI_CY | \n", "
19 | \n", "INDMIN_CY | \n", "2021 Industry: Mining | \n", "industry | \n", "industry.INDMIN_CY | \n", "industry_INDMIN_CY | \n", "
20 | \n", "INDCONS_CY | \n", "2021 Industry: Construction | \n", "industry | \n", "industry.INDCONS_CY | \n", "industry_INDCONS_CY | \n", "
21 | \n", "HHWHTHHR10 | \n", "2010 HHs w/White HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHWHTHHR10 | \n", "householdsbyraceofhouseholder_HHWHTHHR10 | \n", "
22 | \n", "HHBLKHHR10 | \n", "2010 HHs w/Black HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHBLKHHR10 | \n", "householdsbyraceofhouseholder_HHBLKHHR10 | \n", "
23 | \n", "HHAIHHR10 | \n", "2010 HHs w/Amer Indian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHAIHHR10 | \n", "householdsbyraceofhouseholder_HHAIHHR10 | \n", "
24 | \n", "HHASNHHR10 | \n", "2010 HHs w/Asian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHASNHHR10 | \n", "householdsbyraceofhouseholder_HHASNHHR10 | \n", "
25 | \n", "HHPIHHR10 | \n", "2010 HHs w/Pacific Isl HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHPIHHR10 | \n", "householdsbyraceofhouseholder_HHPIHHR10 | \n", "
26 | \n", "HHOTHHHR10 | \n", "2010 HHs w/Other Race HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHOTHHHR10 | \n", "householdsbyraceofhouseholder_HHOTHHHR10 | \n", "
27 | \n", "POPGRW10CY | \n", "2010-2021 Growth Rate: Population | \n", "KeyUSFacts | \n", "KeyUSFacts.POPGRW10CY | \n", "KeyUSFacts_POPGRW10CY | \n", "
28 | \n", "TADULT01 | \n", "2021 Pop 18+ in Tapestry Seg 1A | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT01 | \n", "tapestryadultsNEW_TADULT01 | \n", "
29 | \n", "TADULT02 | \n", "2021 Pop 18+ in Tapestry Seg 1B | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT02 | \n", "tapestryadultsNEW_TADULT02 | \n", "
30 | \n", "ACSTOTPOP | \n", "2019 Total Population (ACS 5-Yr) | \n", "population | \n", "population.ACSTOTPOP | \n", "population_ACSTOTPOP | \n", "
31 | \n", "RELTOTPOP | \n", "2019 Total Population REL (ACS 5-Yr) | \n", "population | \n", "population.RELTOTPOP | \n", "population_RELTOTPOP | \n", "
32 | \n", "HHPOP_CY | \n", "2021 Household Population | \n", "populationtotals | \n", "populationtotals.HHPOP_CY | \n", "populationtotals_HHPOP_CY | \n", "
33 | \n", "FAMPOP_CY | \n", "2021 Family Population | \n", "populationtotals | \n", "populationtotals.FAMPOP_CY | \n", "populationtotals_FAMPOP_CY | \n", "
\n", " | name | \n", "alias | \n", "data_collection | \n", "enrich_name | \n", "enrich_field_name | \n", "
---|---|---|---|---|---|
0 | \n", "ACSMEDHINC | \n", "2019 Median HH Income (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.ACSMEDHINC | \n", "householdincome_ACSMEDHINC | \n", "
1 | \n", "MEDHINC_CY | \n", "2021 Median Household Income | \n", "householdincome | \n", "householdincome.MEDHINC_CY | \n", "householdincome_MEDHINC_CY | \n", "
2 | \n", "MP09147a_B | \n", "2021 Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_B | \n", "ElectronicsInternet_MP09147a_B | \n", "
3 | \n", "MP09148a_B | \n", "2021 Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_B | \n", "ElectronicsInternet_MP09148a_B | \n", "
4 | \n", "MP09134a_B | \n", "2021 Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_B | \n", "ElectronicsInternet_MP09134a_B | \n", "
5 | \n", "X11001_X | \n", "2021 Education | \n", "education | \n", "education.X11001_X | \n", "education_X11001_X | \n", "
6 | \n", "MP14129a_B | \n", "2021 Typically Spend 1-3 Hrs Exercising/Wk | \n", "HealthPersonalCare | \n", "HealthPersonalCare.MP14129a_B | \n", "HealthPersonalCare_MP14129a_B | \n", "
7 | \n", "INDAGRI_CY | \n", "2021 Industry: Agriculture | \n", "industry | \n", "industry.INDAGRI_CY | \n", "industry_INDAGRI_CY | \n", "
8 | \n", "INDMIN_CY | \n", "2021 Industry: Mining | \n", "industry | \n", "industry.INDMIN_CY | \n", "industry_INDMIN_CY | \n", "
9 | \n", "INDCONS_CY | \n", "2021 Industry: Construction | \n", "industry | \n", "industry.INDCONS_CY | \n", "industry_INDCONS_CY | \n", "
10 | \n", "HHWHTHHR10 | \n", "2010 HHs w/White HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHWHTHHR10 | \n", "householdsbyraceofhouseholder_HHWHTHHR10 | \n", "
11 | \n", "HHBLKHHR10 | \n", "2010 HHs w/Black HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHBLKHHR10 | \n", "householdsbyraceofhouseholder_HHBLKHHR10 | \n", "
12 | \n", "HHAIHHR10 | \n", "2010 HHs w/Amer Indian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHAIHHR10 | \n", "householdsbyraceofhouseholder_HHAIHHR10 | \n", "
13 | \n", "HHASNHHR10 | \n", "2010 HHs w/Asian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHASNHHR10 | \n", "householdsbyraceofhouseholder_HHASNHHR10 | \n", "
14 | \n", "HHPIHHR10 | \n", "2010 HHs w/Pacific Isl HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHPIHHR10 | \n", "householdsbyraceofhouseholder_HHPIHHR10 | \n", "
15 | \n", "HHOTHHHR10 | \n", "2010 HHs w/Other Race HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHOTHHHR10 | \n", "householdsbyraceofhouseholder_HHOTHHHR10 | \n", "
16 | \n", "TADULTBASE | \n", "2021 Tapestry Adult Pop Base | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULTBASE | \n", "tapestryadultsNEW_TADULTBASE | \n", "
17 | \n", "TADULT01 | \n", "2021 Pop 18+ in Tapestry Seg 1A | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT01 | \n", "tapestryadultsNEW_TADULT01 | \n", "
18 | \n", "TADULT02 | \n", "2021 Pop 18+ in Tapestry Seg 1B | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT02 | \n", "tapestryadultsNEW_TADULT02 | \n", "
19 | \n", "TOTPOP_CY | \n", "2021 Total Population | \n", "populationtotals | \n", "populationtotals.TOTPOP_CY | \n", "populationtotals_TOTPOP_CY | \n", "
20 | \n", "HHPOP_CY | \n", "2021 Household Population | \n", "populationtotals | \n", "populationtotals.HHPOP_CY | \n", "populationtotals_HHPOP_CY | \n", "
21 | \n", "FAMPOP_CY | \n", "2021 Family Population | \n", "populationtotals | \n", "populationtotals.FAMPOP_CY | \n", "populationtotals_FAMPOP_CY | \n", "
22 | \n", "POPGRW10CY | \n", "2010-2021 Growth Rate: Population | \n", "populationtotals | \n", "populationtotals.POPGRW10CY | \n", "populationtotals_POPGRW10CY | \n", "
23 | \n", "DIVINDX_CY | \n", "2021 Diversity Index | \n", "raceandhispanicorigin | \n", "raceandhispanicorigin.DIVINDX_CY | \n", "raceandhispanicorigin_DIVINDX_CY | \n", "
24 | \n", "ACSTOTPOP | \n", "2019 Total Population (ACS 5-Yr) | \n", "veterans | \n", "veterans.ACSTOTPOP | \n", "veterans_ACSTOTPOP | \n", "
\n", " | guided_workflow_names | \n", "pro_enrich_names | \n", "fieldnames_arcmap | \n", "fieldnames_pro | \n", "search_names | \n", "
---|---|---|---|---|---|
0 | \n", "TOTPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.totpop_cy | \n", "TOTPOP_CY | \n", "populationtotals_totpop_cy | \n", "TOTPOP_CY | \n", "
1 | \n", "HHPOP_CY.2021 Key Demographic Indicators (Esri... | \n", "householdtotals.tothh_cy | \n", "HHPOP_CY | \n", "populationtotals_hhpop_cy | \n", "HHPOP_CY | \n", "
2 | \n", "FAMPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.fampop_cy | \n", "FAMPOP_CY | \n", "populationtotals_fampop_cy | \n", "FAMPOP_CY | \n", "
3 | \n", "MP14129a_B.2021 Health (Market Potential) (Esr... | \n", "healthpersonalcare.mp14129a_b | \n", "MP14129a_B | \n", "healthpersonalcare_mp14129a_b | \n", "MP14129a_B | \n", "
4 | \n", "X11001_X.2021 Education (Consumer Spending) (E... | \n", "education.x11001_x | \n", "X11001_X | \n", "education_x11001_x | \n", "X11001_X | \n", "
\n", " | name | \n", "alias | \n", "data_collection | \n", "enrich_name | \n", "enrich_field_name | \n", "
---|---|---|---|---|---|
0 | \n", "MEDHINC_CY | \n", "2021 Median Household Income | \n", "Health | \n", "Health.MEDHINC_CY | \n", "Health_MEDHINC_CY | \n", "
1 | \n", "MOETOTPOP | \n", "2019 Total Population MOE (ACS 5-Yr) | \n", "ACS_Housing_Summary_rep | \n", "ACS_Housing_Summary_rep.MOETOTPOP | \n", "ACS_Housing_Summary_rep_MOETOTPOP | \n", "
2 | \n", "TADULTBASE | \n", "2021 Tapestry Adult Pop Base | \n", "travelMPI | \n", "travelMPI.TADULTBASE | \n", "travelMPI_TADULTBASE | \n", "
3 | \n", "TOTPOP_CY | \n", "2021 Total Population | \n", "Age_by_Sex_by_Race_Profile_rep | \n", "Age_by_Sex_by_Race_Profile_rep.TOTPOP_CY | \n", "Age_by_Sex_by_Race_Profile_rep_TOTPOP_CY | \n", "
4 | \n", "DIVINDX_CY | \n", "2021 Diversity Index | \n", "Policy | \n", "Policy.DIVINDX_CY | \n", "Policy_DIVINDX_CY | \n", "
5 | \n", "ACSMEDHINC | \n", "2019 Median HH Income (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.ACSMEDHINC | \n", "householdincome_ACSMEDHINC | \n", "
6 | \n", "MOEMEDHINC | \n", "2019 Median HH Income MOE (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.MOEMEDHINC | \n", "householdincome_MOEMEDHINC | \n", "
7 | \n", "RELMEDHINC | \n", "2019 Median HH Income REL (ACS 5-Yr) | \n", "householdincome | \n", "householdincome.RELMEDHINC | \n", "householdincome_RELMEDHINC | \n", "
8 | \n", "X11001_I | \n", "2021 Index: Education | \n", "Community_Profile_rep | \n", "Community_Profile_rep.X11001_I | \n", "Community_Profile_rep_X11001_I | \n", "
9 | \n", "MP09147a_B | \n", "2021 Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_B | \n", "ElectronicsInternet_MP09147a_B | \n", "
10 | \n", "MP09147a_I | \n", "2021 Index: Own Any Tablet | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09147a_I | \n", "ElectronicsInternet_MP09147a_I | \n", "
11 | \n", "MP09148a_B | \n", "2021 Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_B | \n", "ElectronicsInternet_MP09148a_B | \n", "
12 | \n", "MP09148a_I | \n", "2021 Index: Own Any E-Reader | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09148a_I | \n", "ElectronicsInternet_MP09148a_I | \n", "
13 | \n", "MP09134a_B | \n", "2021 Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_B | \n", "ElectronicsInternet_MP09134a_B | \n", "
14 | \n", "MP09134a_I | \n", "2021 Index: Own E-Reader/Tablet: Amazon Kindle | \n", "ElectronicsInternet | \n", "ElectronicsInternet.MP09134a_I | \n", "ElectronicsInternet_MP09134a_I | \n", "
15 | \n", "X11001_X | \n", "2021 Education | \n", "education | \n", "education.X11001_X | \n", "education_X11001_X | \n", "
16 | \n", "X11001_A | \n", "2021 Avg: Education | \n", "education | \n", "education.X11001_A | \n", "education_X11001_A | \n", "
17 | \n", "MP14129a_B | \n", "2021 Typically Spend 1-3 Hrs Exercising/Wk | \n", "HealthPersonalCare | \n", "HealthPersonalCare.MP14129a_B | \n", "HealthPersonalCare_MP14129a_B | \n", "
18 | \n", "INDAGRI_CY | \n", "2021 Industry: Agriculture | \n", "industry | \n", "industry.INDAGRI_CY | \n", "industry_INDAGRI_CY | \n", "
19 | \n", "INDMIN_CY | \n", "2021 Industry: Mining | \n", "industry | \n", "industry.INDMIN_CY | \n", "industry_INDMIN_CY | \n", "
20 | \n", "INDCONS_CY | \n", "2021 Industry: Construction | \n", "industry | \n", "industry.INDCONS_CY | \n", "industry_INDCONS_CY | \n", "
21 | \n", "HHWHTHHR10 | \n", "2010 HHs w/White HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHWHTHHR10 | \n", "householdsbyraceofhouseholder_HHWHTHHR10 | \n", "
22 | \n", "HHBLKHHR10 | \n", "2010 HHs w/Black HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHBLKHHR10 | \n", "householdsbyraceofhouseholder_HHBLKHHR10 | \n", "
23 | \n", "HHAIHHR10 | \n", "2010 HHs w/Amer Indian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHAIHHR10 | \n", "householdsbyraceofhouseholder_HHAIHHR10 | \n", "
24 | \n", "HHASNHHR10 | \n", "2010 HHs w/Asian HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHASNHHR10 | \n", "householdsbyraceofhouseholder_HHASNHHR10 | \n", "
25 | \n", "HHPIHHR10 | \n", "2010 HHs w/Pacific Isl HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHPIHHR10 | \n", "householdsbyraceofhouseholder_HHPIHHR10 | \n", "
26 | \n", "HHOTHHHR10 | \n", "2010 HHs w/Other Race HHr | \n", "householdsbyraceofhouseholder | \n", "householdsbyraceofhouseholder.HHOTHHHR10 | \n", "householdsbyraceofhouseholder_HHOTHHHR10 | \n", "
27 | \n", "POPGRW10CY | \n", "2010-2021 Growth Rate: Population | \n", "KeyUSFacts | \n", "KeyUSFacts.POPGRW10CY | \n", "KeyUSFacts_POPGRW10CY | \n", "
28 | \n", "TADULT01 | \n", "2021 Pop 18+ in Tapestry Seg 1A | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT01 | \n", "tapestryadultsNEW_TADULT01 | \n", "
29 | \n", "TADULT02 | \n", "2021 Pop 18+ in Tapestry Seg 1B | \n", "tapestryadultsNEW | \n", "tapestryadultsNEW.TADULT02 | \n", "tapestryadultsNEW_TADULT02 | \n", "
30 | \n", "ACSTOTPOP | \n", "2019 Total Population (ACS 5-Yr) | \n", "population | \n", "population.ACSTOTPOP | \n", "population_ACSTOTPOP | \n", "
31 | \n", "RELTOTPOP | \n", "2019 Total Population REL (ACS 5-Yr) | \n", "population | \n", "population.RELTOTPOP | \n", "population_RELTOTPOP | \n", "
32 | \n", "HHPOP_CY | \n", "2021 Household Population | \n", "populationtotals | \n", "populationtotals.HHPOP_CY | \n", "populationtotals_HHPOP_CY | \n", "
33 | \n", "FAMPOP_CY | \n", "2021 Family Population | \n", "populationtotals | \n", "populationtotals.FAMPOP_CY | \n", "populationtotals_FAMPOP_CY | \n", "
\n", " | enrich_name | \n", "
---|---|
name | \n", "\n", " |
MEDHINC_CY | \n", "Health.MEDHINC_CY | \n", "
MOETOTPOP | \n", "ACS_Housing_Summary_rep.MOETOTPOP | \n", "
TADULTBASE | \n", "travelMPI.TADULTBASE | \n", "
TOTPOP_CY | \n", "Age_by_Sex_by_Race_Profile_rep.TOTPOP_CY | \n", "
DIVINDX_CY | \n", "Policy.DIVINDX_CY | \n", "
\n", " | guided_workflow_names | \n", "pro_enrich_names | \n", "fieldnames_arcmap | \n", "fieldnames_pro | \n", "search_names | \n", "enrich_name | \n", "
---|---|---|---|---|---|---|
0 | \n", "TOTPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.totpop_cy | \n", "TOTPOP_CY | \n", "populationtotals_totpop_cy | \n", "TOTPOP_CY | \n", "Age_by_Sex_by_Race_Profile_rep.TOTPOP_CY | \n", "
1 | \n", "HHPOP_CY.2021 Key Demographic Indicators (Esri... | \n", "householdtotals.tothh_cy | \n", "HHPOP_CY | \n", "populationtotals_hhpop_cy | \n", "HHPOP_CY | \n", "populationtotals.HHPOP_CY | \n", "
2 | \n", "FAMPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.fampop_cy | \n", "FAMPOP_CY | \n", "populationtotals_fampop_cy | \n", "FAMPOP_CY | \n", "populationtotals.FAMPOP_CY | \n", "
3 | \n", "MP14129a_B.2021 Health (Market Potential) (Esr... | \n", "healthpersonalcare.mp14129a_b | \n", "MP14129a_B | \n", "healthpersonalcare_mp14129a_b | \n", "MP14129a_B | \n", "HealthPersonalCare.MP14129a_B | \n", "
4 | \n", "X11001_X.2021 Education (Consumer Spending) (E... | \n", "education.x11001_x | \n", "X11001_X | \n", "education_x11001_x | \n", "X11001_X | \n", "education.X11001_X | \n", "
\n", " | guided_workflow_names | \n", "enrich_name | \n", "
---|---|---|
0 | \n", "TOTPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "Age_by_Sex_by_Race_Profile_rep.TOTPOP_CY | \n", "
1 | \n", "HHPOP_CY.2021 Key Demographic Indicators (Esri... | \n", "populationtotals.HHPOP_CY | \n", "
2 | \n", "FAMPOP_CY.2021 Key Demographic Indicators (Esr... | \n", "populationtotals.FAMPOP_CY | \n", "
3 | \n", "MP14129a_B.2021 Health (Market Potential) (Esr... | \n", "HealthPersonalCare.MP14129a_B | \n", "
4 | \n", "X11001_X.2021 Education (Consumer Spending) (E... | \n", "education.X11001_X | \n", "
5 | \n", "X11001_A.2021 Education (Consumer Spending) (E... | \n", "education.X11001_A | \n", "
6 | \n", "X11001_I.2021 Education (Consumer Spending) (E... | \n", "Community_Profile_rep.X11001_I | \n", "
7 | \n", "MP09147a_B.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09147a_B | \n", "
8 | \n", "MP09147a_I.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09147a_I | \n", "
9 | \n", "MP09148a_B.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09148a_B | \n", "
10 | \n", "MP09148a_I.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09148a_I | \n", "
11 | \n", "MP09134a_B.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09134a_B | \n", "
12 | \n", "MP09134a_I.2021 Electronics (Market Potential)... | \n", "ElectronicsInternet.MP09134a_I | \n", "
13 | \n", "ACSTOTPOP.2015-2019 Key Demographic Indicators... | \n", "population.ACSTOTPOP | \n", "
14 | \n", "MOETOTPOP.2015-2019 Key Demographic Indicators... | \n", "ACS_Housing_Summary_rep.MOETOTPOP | \n", "
15 | \n", "RELTOTPOP.2015-2019 Key Demographic Indicators... | \n", "population.RELTOTPOP | \n", "
16 | \n", "INDAGRI_CY.2021 Labor Force (Esri) (US 2021 Re... | \n", "industry.INDAGRI_CY | \n", "
17 | \n", "INDMIN_CY.2021 Labor Force (Esri) (US 2021 Ret... | \n", "industry.INDMIN_CY | \n", "
18 | \n", "INDCONS_CY.2021 Labor Force (Esri) (US 2021 Re... | \n", "industry.INDCONS_CY | \n", "
19 | \n", "HHWHTHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.HHWHTHHR10 | \n", "
20 | \n", "HHBLKHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.HHBLKHHR10 | \n", "
21 | \n", "HHAIHHR10.2010 Households by Race_Hispanic Ori... | \n", "householdsbyraceofhouseholder.HHAIHHR10 | \n", "
22 | \n", "HHASNHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.HHASNHHR10 | \n", "
23 | \n", "HHPIHHR10.2010 Households by Race_Hispanic Ori... | \n", "householdsbyraceofhouseholder.HHPIHHR10 | \n", "
24 | \n", "HHOTHHHR10.2010 Households by Race_Hispanic Or... | \n", "householdsbyraceofhouseholder.HHOTHHHR10 | \n", "
25 | \n", "TADULTBASE.2021 Tapestry Market Segmentation (... | \n", "travelMPI.TADULTBASE | \n", "
26 | \n", "TADULT01.2021 Tapestry Market Segmentation (Ad... | \n", "tapestryadultsNEW.TADULT01 | \n", "
27 | \n", "TADULT02.2021 Tapestry Market Segmentation (Ad... | \n", "tapestryadultsNEW.TADULT02 | \n", "
28 | \n", "POPGRW10CY.2021 Key Demographic Indicators (Es... | \n", "KeyUSFacts.POPGRW10CY | \n", "
29 | \n", "DIVINDX_CY.2021 Race and Hispanic Origin (Esri... | \n", "Policy.DIVINDX_CY | \n", "
30 | \n", "MEDHINC_CY.2021 Income (Esri) (Esri USA 2021) | \n", "Health.MEDHINC_CY | \n", "
31 | \n", "ACSMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.ACSMEDHINC | \n", "
32 | \n", "MOEMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.MOEMEDHINC | \n", "
33 | \n", "RELMEDHINC.2015-2019 Income (ACS) (Esri USA 20... | \n", "householdincome.RELMEDHINC | \n", "