Description: Limited English Neighborhood layer was modeled after a similar layer produced by Pennoni and ejscreen technical documentation for Limited English Speaking Household. It uses a similar Land Use clipping process of Pennoni's workflow and considers all non-English speaking fields to calculate Limited English Percent similar to how EJScreen determines Limited English Speaking Households for the EJ Screen Supplemental Index.Workflow steps:Extract residential land use. Get parcels that are either DSHA site, MHP site, or have been identified through other EJ activities and export parcels to geodatabase. Dissolve/merge parcels and LU residential areas into one boundary layer. Total LEP percent in latest ACS data in the LIMITEDENGLISH_CURRENT field column.Add previous years results.Calculate Percent Change.Clip LEP layer to residential land use parcels. Residential Areas AKA LU Areas SQL snippet: • LULC_CATEGORY2022 IN ('Commercial', 'Industrial', 'Institutional/Governmental', 'Marinas/Port Facilities/Docks', 'Mixed Urban or Built-up Land', 'Mobile Home Parks/Courts', 'Multi-Family Dwellings', 'Single Family Dwellings', 'Mixed Single and Multi-Family Residential') • LULC_CATEGORY2022 NOT IN ('Farms, Pasture and Cropland', 'Open Water', 'Man-made Reservoirs and Impoundments', 'Recreational', 'Rangeland', 'Evergreen Forest', 'Forested Wetland - Tidal and Non-tidal', 'Deciduous Forest', 'Mixed Forest')Limited English Percentage = (% Spanish + % Indo-European +% Asian and Pacific Islander + % Other)!B16007_calc_pctSpanE!+!B16007_calc_pctIEE!+!B16007_calc_pctAPIE!+!B16007_calc_pctOtherE!Field Name,Field AliasB16007_calc_pctOtherE, Percent of population age 5+ who speak Other languages at home: % OtherB16007_calc_PctSpanE, Percent of population age 5+ who speak Spanish at home: % SpanishB16007_calc_PctIEE, Percent of population age 5+ who speak Asian and Pacific Islander at home: % Asian & Pacific IslanderB16007_calc_PctAPIE, Percent of population age 5+ who speak Indo-European at home: % Indo-European
Copyright Text: U.S. Census Bureau's American Community Survey (ACS) 2020-2024 5-year estimates, Table(s) B16007
B16007_001E
(
type: esriFieldTypeInteger, alias: Total Population 5 Years and Over
)
B16007_001M
(
type: esriFieldTypeDouble, alias: Total Population 5 Years and Over - Margin of Error
)
B16007_002E
(
type: esriFieldTypeInteger, alias: Population 5 to 17 Years
)
B16007_002M
(
type: esriFieldTypeDouble, alias: Population 5 to 17 Years - Margin of Error
)
B16007_014E
(
type: esriFieldTypeInteger, alias: Population 65 Years and Over
)
B16007_014M
(
type: esriFieldTypeDouble, alias: Population 65 Years and Over - Margin of Error
)
B16007_CALC_PCTENGONLYE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Only Speak English at Home
)
B16007_CALC_PCTENGONLYM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Only Speak English at Home - Margin of Error
)
B16007_CALC_PCTSPANE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Spanish at Home
)
B16007_CALC_PCTSPANM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Spanish at Home - Margin of Error
)
B16007_CALC_PCTIEE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak another Indo-European Language at Home
)
B16007_CALC_PCTIEM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak another Indo-European Language at Home - Margin of Error
)
B16007_CALC_PCTAPIE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak an Asian and Pacific Islander Language at Home
)
B16007_CALC_PCTAPIM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak an Asian and Pacific Islander Language at Home - Margin of Error
)
B16007_CALC_PCTOTHERE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Other Languages at Home
)
B16007_CALC_PCTOTHERM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Other Languages at Home - Margin of Error
)
LIMITEDENGLISH_CURRENT
(
type: esriFieldTypeDouble, alias: Limited English Percent (LEP) Total
)
LIMITEDENGLISHPCT_2023
(
type: esriFieldTypeDouble, alias: LEP Total from 2019-2023
)
LIMITEDENGLISHPCT_2021
(
type: esriFieldTypeDouble, alias: LEP Total from 2017-2021
)
LIMITEDENGLISHPCT_2022
(
type: esriFieldTypeDouble, alias: LEP Total from 2018-2022
)
PCTCHANGE_2022
(
type: esriFieldTypeDouble, alias: Percent Change from 2021 to 2022 versions of ACS data
)
PCTCHANGE_2023
(
type: esriFieldTypeDouble, alias: Percent Change from 2022 to 2023 versions of ACS data
)
PCTCHANGE_2024
(
type: esriFieldTypeDouble, alias: Percent Change from 2023 to 2024 versions of ACS data
)
Description: Variables included are the following: 1. Dependency ratio 45% - Percent of population in dependent age groups (under 18 and 65+) is >= 45% (P012_calc_pctDepend from Total Population 2020 Census)2. LEP 15% - Limited English Percent is >=15% (ACS) 2020-2024 5-year estimates, Table(s) B16007, ACS_Language_by_Age_2020_2024_Boundaries)3. Renters >30% - Percent of Renter Households for whom Gross Rent is 30% or More of Household Income is above 50% (B25070_calc_pctGE30pctE from ACS 2020-2024: ACS_Housing_Costs_View_Boundaries)4. Age of housing <1978 - Predominant building date is before the 1980s (2018-2022 ACS Tracts Housing Units by Year Built Boundaries)5. Distribution of multifamily housing - Number of DSHA multifamily housing units above 50? Y/N (Delaware State Housing Authority sites as of October 2024)6. High poverty area - Percent of population whose income is below poverty level is above 20% (ACS 2020-2024 Tracts ACS_Poverty_Status_View)7. Educational attainment - Percent of population 25 years and over whose highest education completed is less than high school > 15%. (ACS 2020-2024 B15002 ACS Educational Attainment View)8. Unemployment - Percent of unemployed above 10%. (B23025 from 2020-2024 ACS Tracts ACS Employment Status View)9. Internet - Percent of Households with no internet access is above 10%. (B28002_calc_pctNoIntE from ACS 2020-2024 Internet Connectivity View)10. Access to Healthcare - Percent of population with no health insurance is above 10%. (B27010_calc_pctNoInsE 2018-2022 ACS Health Insurance)
Copyright Text: Delaware Department of Natural Resources and Environmental Control (DNREC) Environmental Justice Office (EJO).
PCTDEPEND_ABOVE45
(
type: esriFieldTypeInteger, alias: Percent of population in dependent age groups (under 18 and 65+) is 45% or more
)
LEP_ABOVE15
(
type: esriFieldTypeInteger, alias: Is the LEP greater than or equal to 15%? )
ACS_B25070_PCTGE30_ABOVE50
(
type: esriFieldTypeInteger, alias: Percent of Renter Households for whom Gross Rent (Contract Rent Plus Tenant-Paid Utilities) is 30.0 Percent or More of Household Income Above 50%
)
DSHA_UNITSABOVE50
(
type: esriFieldTypeInteger, alias: Number of DSHA multifamily housing units above 50?
)
B17020_CALC_PCTPOVE_ABOVE20
(
type: esriFieldTypeInteger, alias: Percent of Population whose income in the past 12 months is below poverty level is above 20%
)
B15002_CALC_PCTLTHSE_ABOVE15
(
type: esriFieldTypeInteger, alias: Percent of Population 25 Years and Over whose Highest Education Completed is Less Than High School is Above 15%
)
B28002_CALC_PCTNOINTE_ABOVE10
(
type: esriFieldTypeInteger, alias: Percent of Households with No Internet Access Above 10%
)
B27010_CALC_PCTNOINSE_ABOVE10
(
type: esriFieldTypeInteger, alias: Percent of Population with No Health Insurance Coverage Above 10%
)
H0010001
(
type: esriFieldTypeInteger, alias: Total Housing Units
)
P0010001
(
type: esriFieldTypeInteger, alias: Total Population
)
P0020002
(
type: esriFieldTypeInteger, alias: Urban population
)
P012_CALC_NUMWORK
(
type: esriFieldTypeInteger, alias: Working-age population (18-64)
)
B16007_001E
(
type: esriFieldTypeInteger, alias: Total Population 5 Years and Over
)
B16007_001M
(
type: esriFieldTypeDouble, alias: Total Population 5 Years and Over - Margin of Error
)
B16007_002E
(
type: esriFieldTypeInteger, alias: Population 5 to 17 Years
)
B16007_002M
(
type: esriFieldTypeDouble, alias: Population 5 to 17 Years - Margin of Error
)
B16007_014E
(
type: esriFieldTypeInteger, alias: Population 65 Years and Over
)
B16007_014M
(
type: esriFieldTypeDouble, alias: Population 65 Years and Over - Margin of Error
)
B16007_CALC_PCTENGONLYE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Only Speak English at Home
)
B16007_CALC_PCTENGONLYM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Only Speak English at Home - Margin of Error
)
B16007_CALC_PCTSPANE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Spanish at Home
)
B16007_CALC_PCTSPANM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Spanish at Home - Margin of Error
)
B16007_CALC_PCTIEE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak another Indo-European Language at Home
)
B16007_CALC_PCTIEM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak another Indo-European Language at Home - Margin of Error
)
B16007_CALC_PCTAPIE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak an Asian and Pacific Islander Language at Home
)
B16007_CALC_PCTAPIM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak an Asian and Pacific Islander Language at Home - Margin of Error
)
B16007_CALC_PCTOTHERE
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Other Languages at Home
)
B16007_CALC_PCTOTHERM
(
type: esriFieldTypeDouble, alias: Percent of Population Age 5+ Who Speak Other Languages at Home - Margin of Error
)
B25070_001E
(
type: esriFieldTypeInteger, alias: Total Renter-Occupied Housing Units (Renter Households)
)
B25070_001M
(
type: esriFieldTypeDouble, alias: Total Renter-Occupied Housing Units (Renter Households) - Margin of Error
)
B25070_CALC_NUMGE30PCTE
(
type: esriFieldTypeInteger, alias: Count of Renter Households for whom Gross Rent (Contract Rent Plus Tenant-Paid Utilities) is 30.0 Percent or More of Household Income
)
B25070_CALC_NUMGE30PCTM
(
type: esriFieldTypeInteger, alias: Count of Renter Households for whom Gross Rent (Contract Rent Plus Tenant-Paid Utilities) is 30.0 Percent or More of Household Income - Margin of Error
)
B25070_CALC_PCTGE30PCTE
(
type: esriFieldTypeDouble, alias: Percent of Renter Households for whom Gross Rent (Contract Rent Plus Tenant-Paid Utilities) is 30.0 Percent or More of Household Income
)
B25070_CALC_PCTGE30PCTM
(
type: esriFieldTypeDouble, alias: Percent of Renter Households for whom Gross Rent (Contract Rent Plus Tenant-Paid Utilities) is 30.0 Percent or More of Household Income - Margin of Error
)
B25091_001E
(
type: esriFieldTypeInteger, alias: Total Owner-Occupied Housing Units (Owner Households)
)
B25091_001M
(
type: esriFieldTypeDouble, alias: Total Owner-Occupied Housing Units (Owner Households) - Margin of Error
)
B25091_CALC_NUMMORTGE30PCTE
(
type: esriFieldTypeInteger, alias: Count of Owner Households with Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income
)
B25091_CALC_NUMMORTGE30PCTM
(
type: esriFieldTypeInteger, alias: Count of Owner Households with Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income - Margin of Error
)
B25091_CALC_PCTMORTGE30PCTE
(
type: esriFieldTypeDouble, alias: Percent of Owner Households with Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income
)
B25091_CALC_PCTMORTGE30PCTM
(
type: esriFieldTypeDouble, alias: Percent of Owner Households with Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income - Margin of Error
)
B25091_CALC_NUMNOMORTGE30PCTE
(
type: esriFieldTypeInteger, alias: Count of Owner Households without Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income
)
B25091_CALC_NUMNOMORTGE30PCTM
(
type: esriFieldTypeInteger, alias: Count of Owner Households without Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income - Margin of Error
)
B25091_CALC_PCTNOMORTGE30PCTE
(
type: esriFieldTypeDouble, alias: Percent of Owner Households without Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income
)
B25091_CALC_PCTNOMORTGE30PCTM
(
type: esriFieldTypeDouble, alias: Percent of Owner Households without Mortgages whose Monthly Owner Costs are 30.0 Percent or More of Household Income - Margin of Error
)
B15002_001E
(
type: esriFieldTypeInteger, alias: Total Population 25 Years and Over
)
B15002_001M
(
type: esriFieldTypeDouble, alias: Total Population 25 Years and Over - Margin of Error
)
B15002_CALC_NUMLTHSE
(
type: esriFieldTypeInteger, alias: Population 25 Years and Over whose Highest Education Completed is Less Than High School
)
B15002_CALC_NUMLTHSM
(
type: esriFieldTypeInteger, alias: Population 25 Years and Over whose Highest Education Completed is Less Than High School - Margin of Error
)
B15002_CALC_PCTLTHSE
(
type: esriFieldTypeDouble, alias: Percent of Population 25 Years and Over whose Highest Education Completed is Less Than High School
)
B15002_CALC_PCTLTHSM
(
type: esriFieldTypeDouble, alias: Percent of Population 25 Years and Over whose Highest Education Completed is Less Than High School - Margin of Error
)
B17020_001E
(
type: esriFieldTypeInteger, alias: Total Population for whom Poverty Status is Determined
)
B17020_001M
(
type: esriFieldTypeDouble, alias: Total Population for whom Poverty Status is Determined - Margin of Error
)
B17020_CALC_PCTPOVE
(
type: esriFieldTypeDouble, alias: Percent of Population whose income in the past 12 months is below poverty level
)
B17020_CALC_PCTPOVM
(
type: esriFieldTypeDouble, alias: Percent of Population whose income in the past 12 months is below poverty level - Margin of Error
)
B23025_002E
(
type: esriFieldTypeInteger, alias: All Population in Labor Force
)
B23025_002M
(
type: esriFieldTypeDouble, alias: All Population in Labor Force - Margin of Error
)