ArcGIS REST Services Directory Login
JSON

Layer: Population by Census Tract (2021) (ID: 4)

View In:   ArcGIS Online Map Viewer

Name: Population by Census Tract (2021)

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: A polygon layer representing 2021 Census Tracts with the American Community Survey DP05 Table "Demographic and Housing Estimates" 2021 data joined with each tract. Each column is named with the alias by data subject. The field names are numeric with the table name "DP05" then a numeric code for the subject. If they end with the letter "E" they are an estimated count, and if the end with "PE" than it is a percentage from the total population in each section. 0001-0032 are SEX AND AGE0033 - 0069 are RACE and Race Alone0070 - 0085 are HISPANIC OR LATINO AND RACE0086 - 0089 are Housing units and Voting Age. The original data are text files (.csv) downloaded directly from https://data.census.gov/table. These contain other columns concerning Annotation and Margin of Error. please see the the following file ACSDP5Y2021.DP05-Column-Metadata.csv for all column names in the original data. Processing Steps:1. Deleted the 2nd row2. Pull the last 10 digits of the GEOID into a new field to match the Census 2021 Tract Layer ID3. Converted from .csv to geodatabase table but make sure to set all columns that end with "E" only to long and all columns that end with "PE" only to double. Deleteother columns that end with anything other than "E" or "PE" 4. Created the Demographic_Tract_Census_2021 feature class by exporting the 2021 Census Tract Layer. Placed inside the "Demographic_Layers_Census_2021 Geodatabase.5. Ran the join tool to merge the ACS data to the new feature class. Following fields were calculated:1. CALC_Total_Minority_count(Total_Minority_Count) - Estimate_Race alone or in combination with one or more other races_Total population - Estimate_Race alone or in combination with one or more other races_Total population_White (DP05_0063E - DP05_0064E)2.CALC_Total_Minority_Percent(Total_Minority_Percent) - Percent_Race alone or in combination with one or more other races_Total population(this field is a count and equals Estimate_Race alone or in combination with one or more other races_Total population) convert to 100% or 1.0 and then subtract Percent_Race alone or in combination with one or more other races_Total population_White. Equation for python: (DP05_0064E/DP05_0063E *100)3. CALC_Total_Population_25_and_over(Total_Population_25_and_over) - To get 25 and over, sum SEX AND AGE_Total population_25 to 34 years DP05_0010E to SEX AND AGE_Total population_85 years and over DP05_0017E (DP05_0010E +DP05_0011E+DP05_0012E+DP05_0013E+DP05_0014E+DP05_0015E+DP05_0016E+DP05_0017E)4. CALC_Total_Population_Under_25(Total_Population_Under_25) - Tract level polygon layer linked to Census Demographic population 2021 data. Sum SEX AND AGE_Total population_Under 5 years, 5 to 9 years, 10 to 14 years, 15 to 19 years, 20 to 24 years (DP05_0005E+DP05_0006E+DP05_0007E+DP05_0008E+DP05_0009E)5. CALC_Total_Pop_Under_25_Prcnt(Total_Pop_Under_25_Prcnt) - Tract level polygon layer linked to Census Demographic population 2021 data. Sum SEX AND AGE_Total population_Under 5 years, 5 to 9 years, 10 to 14 years, 15 to 19 years, 20 to 24 years (DP05_0005PE+DP05_0006PE+DP05_0007PE+DP05_0008PE+DP05_0009PE)6. CALC_Total_Pop_Over_64_Count(Total_Pop_Over_64_Count) - Tract level polygon layer linked to Census Demographic population 2021 data. sum: SEX AND AGE Total Population 65 to 74, 75 to 84, 85 and over (DP05_0015E+ DP05_0016E+DP05_0017E)7. CALC_Total_Pop_Over_64_Prcnt(Total_Pop_Over_64_Prcnt) - Tract level polygon layer linked to Census Demographic population 2021 data. sum: SEX AND AGE Total Population 65 to 74, 75 to 84, 85 and over (DP05_0015PE+ DP05_0016PE+DP05_0017PE)

Service Item Id: 22aaf2e337974faf8369d53ce09ae988

Copyright Text: Census.org

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
Drawing Info: Advanced Query Capabilities:
HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields: Templates:
Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata