Sure, that would be really awesome. Could you fill the proposal template and we could go from there? Thanks much.
From: Jennifer Bell
Sent: Friday, February 15, 2019 11:05 AM
To: Sirisha Karamchedu SKaramchedu@esri.com; Riley Peake RPeake@esri.com
Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
I’m happy to write a blog and help with the lesson as well if that is something of interest to you all.
From: Sirisha Karamchedu
Sent: Friday, February 15, 2019 11:01 AM
To: Jennifer Bell JBell@esri.com; Riley Peake RPeake@esri.com
Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
This is really cool. I am thinking we could showcase as a blog too. Any thoughts?
From: Jennifer Bell
Sent: Thursday, February 14, 2019 3:09 PM
To: Riley Peake RPeake@esri.com
Cc: Sirisha Karamchedu SKaramchedu@esri.com
Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
No problem!
From: Riley Peake
Sent: Thursday, February 14, 2019 3:05 PM
To: Jennifer Bell JBell@esri.com
Cc: Sirisha Karamchedu SKaramchedu@esri.com
Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Jen!
This is so cool, thanks for the connection! CC’ing our PM Sirisha to put in our backlog
Riley
From: Jennifer Bell
Sent: Thursday, February 14, 2019 2:46 PM
To: Riley Peake RPeake@esri.com
Subject: FW: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Riley! At our Living Atlas meeting, you mentioned that we have Learn Lessons from customers. If you are looking for one, the below could be a good customer example.
From: Jennifer Bell
Sent: Thursday, February 14, 2019 2:44 PM
To: 'Deepak (DemLabs)' Deepak@thedemlabs.org
Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Deepak,
Here is an app and map example of the target audience. To create this map for all of California, or all of the U.S., please reference the following steps:
Log into your ArcGIS Online account.
Click Map at the top of the page.
Click the yellow Add button at the top left of the page.
Select Browse Living Atlas Layers.
Type “Tracts” in the search bar.
Click on the plus sign next to the USA Tracts layer which is created by Esri.
If you want to only do this for California and not the whole U.S., click on the yellow filter button under the USA Tracts layer.
a. In the dropdown, select State FIPS. The next dropdown is “is”. And in the last rectangle, type “06”. This will filter the layer and only show tracts that are in California, or State FIPS 06.
b. Click Apply Filter.
To get this data inside the layer, click on the Analysis button under the USA Tracts layer.
Expand Data Enrichment, then select Enrich Layer.
In step 2 of the Enrich Layer tool, click on the green button that says Select Variables.
Find the following variables and click on the checkbox next to each one:
a. 2018 Population Age 18
b. 2018 Population Age 19
c. 2018 Population Age 20
d. 2018 Population Age 21
e. 2018 Population Age 22
f. 2018 Population Age 23
g. 2018 Population Age 24
h. 2012-2016 ACS Percent of Households with Income Below Poverty Level
i. 2018 Total Population
j. 2018 Education: < 9th Grade
k. 2018 Education: High School/No Diploma
l. 2018 Education: High School Diploma
m. 2018 Education: Some College/No Degree
n. ACS Civilian Population Age 18+
o. 2018 Unemployed Population 16+
p. 2018 Employed Civilian Pop 16+
Then click Apply.
Uncheck the button that says “Use current map extent”.
Then click Run Analysis. This will add the demographic information to a new layer saved in your organizational account.
Now it’s time to set the map symbology to only show the Tracts that meet certain requirements.
Under the new layer that you created (this is seen at the top of the list in the Content tab), click on the Change Style icon.
For Step 1, click on the dropdown and scroll down to the very bottom of the list and select New Expression.
Paste this expression in the window:
var PercentAge18to24 = (($feature["AGE18_CY"]+$feature["AGE19_CY"]+$feature["AGE20_CY"]+$feature["AGE21_CY"]+$feature["AGE22_CY"]+$feature["AGE23_CY"]+$feature["AGE24_CY"])/$feature["TOTPOP_CY"])*100
var AveragePercentAge18to24 = 8
var PercentHouseholdsBelowPoverty = $feature.PACSHHBPOV
var AveragePercentHouseholdsBelowPoverty = 10
var PercentNoCollege = (($feature["NOHS_CY"]+$feature["HSGRAD_CY"]+$feature["SOMEHS_CY"]+$feature["SMCOLL_CY"])/$feature["TOTPOP_CY"])*100
var AveragePercentNoCollege = 29
var PercentUnemployed = ($feature["UNEMP_CY"]/$feature["EMP_CY"])*100
var AveragePercentUnemployed = 4
When (PercentAge18to24 > AveragePercentAge18to24 &&
PercentHouseholdsBelowPoverty >AveragePercentHouseholdsBelowPoverty &&
PercentNoCollege > AveragePercentNoCollege &&
PercentUnemployed > AveragePercentUnemployed,
"YearUp Zone", "Does not meet target demographic")
a. This expression is like a filter that only shows tracts that meet specific requirements. In this case, the expression only shows tracts that are above average in youth, poverty, low education, and unemployment. You can change any of these average values to change the filter (e.g., you might want to show tracts where more than 5% of the households are living in poverty. To do this, next to var AveragePercentHouseholdsBelowPoverty, change 10 to 5).
Click OK.
Change the colors to match YearUp’s color scheme. To do this, Click Options under Types (Unique Symbols) and click on the colorful square next to each category. The YearUp Zone will be hex value color #F4AD18and the tracts that do not meet target demographics will be #375FAA. The outline color for each will be the same color as the fill.
In the Transparency section, move the slider to 0% transparency.
Click OK. Then click Done.
Save the map.
You can turn the map into a Story Map by clicking Share then Create a Web App and choose a Story Map like the Map Series.
I look forward to seeing what you create for them or what they create!
Best,
Jennifer
From: Deepak (DemLabs) Deepak@thedemlabs.org
Sent: Wednesday, February 13, 2019 9:56 AM
To: Jennifer Bell JBell@esri.com; Deepak deepak@thedemlabs.org
Subject: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Jennifer,
I'm helping YearUp a non-profit that helps you disadvantaged youth get the training they need to find a job.
Their target audience is people between 18-24, low-income families, no college degree, often high school drop-outs, unemployed.
They'd like to understand areas with such high concentrations with an initial focus on California, so they can focus their outreach better.
Is this something you could help me with a map for ? Thanks.
Sure, that would be really awesome. Could you fill the proposal template and we could go from there? Thanks much.
From: Jennifer Bell Sent: Friday, February 15, 2019 11:05 AM To: Sirisha Karamchedu SKaramchedu@esri.com; Riley Peake RPeake@esri.com Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
I’m happy to write a blog and help with the lesson as well if that is something of interest to you all.
From: Sirisha Karamchedu Sent: Friday, February 15, 2019 11:01 AM To: Jennifer Bell JBell@esri.com; Riley Peake RPeake@esri.com Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
This is really cool. I am thinking we could showcase as a blog too. Any thoughts?
From: Jennifer Bell Sent: Thursday, February 14, 2019 3:09 PM To: Riley Peake RPeake@esri.com Cc: Sirisha Karamchedu SKaramchedu@esri.com Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
No problem!
From: Riley Peake Sent: Thursday, February 14, 2019 3:05 PM To: Jennifer Bell JBell@esri.com Cc: Sirisha Karamchedu SKaramchedu@esri.com Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Jen!
This is so cool, thanks for the connection! CC’ing our PM Sirisha to put in our backlog
Riley
From: Jennifer Bell Sent: Thursday, February 14, 2019 2:46 PM To: Riley Peake RPeake@esri.com Subject: FW: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Riley! At our Living Atlas meeting, you mentioned that we have Learn Lessons from customers. If you are looking for one, the below could be a good customer example.
From: Jennifer Bell Sent: Thursday, February 14, 2019 2:44 PM To: 'Deepak (DemLabs)' Deepak@thedemlabs.org Subject: RE: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Deepak,
Here is an app and map example of the target audience. To create this map for all of California, or all of the U.S., please reference the following steps:
var PercentHouseholdsBelowPoverty = $feature.PACSHHBPOV var AveragePercentHouseholdsBelowPoverty = 10
var PercentNoCollege = (($feature["NOHS_CY"]+$feature["HSGRAD_CY"]+$feature["SOMEHS_CY"]+$feature["SMCOLL_CY"])/$feature["TOTPOP_CY"])*100 var AveragePercentNoCollege = 29
var PercentUnemployed = ($feature["UNEMP_CY"]/$feature["EMP_CY"])*100 var AveragePercentUnemployed = 4
When (PercentAge18to24 > AveragePercentAge18to24 && PercentHouseholdsBelowPoverty >AveragePercentHouseholdsBelowPoverty && PercentNoCollege > AveragePercentNoCollege && PercentUnemployed > AveragePercentUnemployed, "YearUp Zone", "Does not meet target demographic") a. This expression is like a filter that only shows tracts that meet specific requirements. In this case, the expression only shows tracts that are above average in youth, poverty, low education, and unemployment. You can change any of these average values to change the filter (e.g., you might want to show tracts where more than 5% of the households are living in poverty. To do this, next to var AveragePercentHouseholdsBelowPoverty, change 10 to 5).
I look forward to seeing what you create for them or what they create!
Best, Jennifer
From: Deepak (DemLabs) Deepak@thedemlabs.org Sent: Wednesday, February 13, 2019 9:56 AM To: Jennifer Bell JBell@esri.com; Deepak deepak@thedemlabs.org Subject: YearUp request for a map of disadvantaged youth in CA that they could reach out to.
Hi Jennifer, I'm helping YearUp a non-profit that helps you disadvantaged youth get the training they need to find a job. Their target audience is people between 18-24, low-income families, no college degree, often high school drop-outs, unemployed. They'd like to understand areas with such high concentrations with an initial focus on California, so they can focus their outreach better. Is this something you could help me with a map for ? Thanks.
Deepak