How to Read and Use US Census Data for City Planning — A Water Infrastructure Case Study
The Census Bureau website is one of the most valuable free resources available to local government professionals — and one of the most confusing to navigate. Dozens of datasets, multiple survey types, overlapping geographies, and a data dissemination platform that rewards patience more than intuition make it easy to find the front page and hard to find the specific table your planning question actually requires.
This guide cuts through that complexity with a concrete, practical use case: a local government water department evaluating whether projected population growth will require a new reservoir. Every step — identifying the right dataset, navigating data.census.gov, downloading the data, and interpreting the results — is walked through in sequence using that real-world scenario as the throughline.
The Planning Question That Drives Everything
Before touching any Census tool, define your planning question precisely. Census data is only useful when you know what you are trying to answer.
For our scenario the question is: Based on current population growth trends and projected household formation, will Riverside City's existing reservoir capacity be sufficient to meet water demand over the next 20 years — and if not, what does the data suggest about the magnitude and timing of the gap?
That question has two components. The first is historical — how has Riverside City's population grown over the past decade, and at what rate? The second is forward-looking — what do current trends suggest about future growth, and what does that imply for per-capita water demand?
The Census Bureau's data addresses both directly. It does not make infrastructure decisions for you — but it gives you the demographic foundation that makes those decisions defensible to city council, grant reviewers, and the public.
Which Census Dataset Do You Actually Need?
The Census Bureau produces dozens of datasets and the terminology is genuinely confusing for first-time users. For population growth analysis in a local government planning context, three datasets are most relevant and worth understanding before you open data.census.gov.
The Decennial Census
Conducted every ten years, the decennial census is a complete count of every person living in the United States. It is the most accurate population count available — but it only happens once a decade. The most recent decennial census was conducted in 2020, which means its data is now six years old. For infrastructure planning that spans 20 years into the future, the decennial census provides your baseline anchor but not your growth trend.
The American Community Survey (ACS)
The American Community Survey is the premier source of detailed information about the nation's people and housing, conducted by the US Census Bureau since 2005. It collects detailed social, economic, housing, and demographic information from a sample of households annually, covering more than 40 topics including education, employment, income, housing, and transportation — and its data are used to plan roads, schools, and emergency services, and to guide the distribution of government funding. Springer
For water infrastructure planning the ACS provides two critical data points: current population estimates at the city and census tract level, and housing unit counts which serve as a proxy for service connections in a water utility context.
The ACS comes in two primary flavors. The one-year estimates, released annually, are the most current but are only available for areas with populations above 65,000 — which means many mid-size cities will not have one-year data available at the city level. The five-year estimates cover all geographies including smaller cities and census tracts and are statistically more reliable because they are based on a larger sample. The most recently released ACS five-year estimates cover the period 2020-2024, released in January 2026 — making them the most current comprehensive dataset available for small and mid-size city planning analysis. FutureIOT
For Riverside City's reservoir analysis, the ACS five-year estimates are the right starting point.
The Population Estimates Program (PEP)
The Census Bureau's Population Estimates Program produces annual estimates of the population for the United States, states, metropolitan areas, counties, cities, and towns — updated annually to reflect year-to-year changes. These estimates bridge the gap between decennial census counts by using administrative data on births, deaths, and migration to project current population at the city level each year. ThingsLog
For a 20-year infrastructure planning horizon, Population Estimates Program data combined with ACS five-year estimates gives you the most complete picture of current population and recent growth trajectory available from free federal sources.
Navigating data.census.gov Step by Step
Go to data.census.gov in your browser. This is the Census Bureau's primary data dissemination platform and the starting point for almost all Census data retrieval.
Step 1 — Search for your geography
In the search bar at the top of the page, type the name of your city and state — for example "Riverside City, Virginia." Census will return matching geographies. Select the one that matches your city at the "Place" level — this is the standard Census geography for incorporated cities and towns.
Step 2 — Find population data
Once your geography is selected, look for the Tables tab. Search for table DP05 — this is the ACS Demographic and Housing Estimates profile, which is the single most useful starting table for a population analysis. It contains total population, population by age group, sex, race and ethnicity, and housing unit counts — all in one table.
Select the most recent ACS 5-Year Estimates dataset from the dropdown to ensure you are getting data available for your city's geography.
Step 3 — Download the data
Click Download and select CSV format. This gives you a file you can open in Excel or Python for analysis. The CSV will contain two rows of headers — the first with table IDs, the second with plain-language descriptions. Delete the first header row before doing any analysis.
Step 4 — Pull historical data for trend analysis
For a growth trend analysis you need at least two non-overlapping five-year datasets to compare. The 2020-2024 ACS five-year estimates can be directly compared with the 2015-2019 ACS five-year estimates — the first time four non-overlapping five-year datasets have been available — making robust multi-period trend analysis now possible for the first time. Smart Columbus
Download both the 2020-2024 and 2015-2019 five-year estimates for your geography. The difference in total population and housing units between these two periods gives you a ten-year growth baseline.
Building the Reservoir Capacity Analysis
With your Census data downloaded, the actual analysis for a reservoir capacity question follows four steps.
Step 1 — Calculate your population growth rate
Compare total population between your two ACS five-year datasets. If Riverside City had 45,000 residents in the 2015-2019 estimate and 52,000 in the 2020-2024 estimate, that represents a 15.6% increase over a roughly ten-year period — or approximately 1.5% annual growth.
Step 2 — Project forward using that growth rate
Apply your historical growth rate to project population at 5, 10, 15, and 20 year intervals. A simple compound growth formula in Excel handles this in a single column:
=Current Population * (1 + Annual Growth Rate)^Years
For Riverside City at 1.5% annual growth: 52,000 residents today becomes approximately 70,000 in 20 years. That is a 35% increase in the service population your water infrastructure needs to support.
Step 3 — Convert population to water demand
The American Water Works Association standard for residential water demand is typically 50 to 100 gallons per person per day depending on climate, housing type, and local conservation programs. Using a conservative 75 gallons per person per day figure, Riverside City's current daily demand is approximately 3.9 million gallons. At projected 2046 population that becomes approximately 5.25 million gallons per day — a 35% increase that needs to be compared against your current reservoir capacity and planned infrastructure.
Step 4 — Layer in housing unit data
Population counts tell you how many people. Housing unit counts tell you how many service connections — which is more directly useful for a water utility doing capacity planning. ACS table DP04 provides housing unit estimates at the city level including occupied and vacant units. A growing city with 15% more housing units over ten years represents 15% more service connections regardless of household size trends.
An Important Limitation Worth Knowing
Census data is powerful but not infallible, and using it honestly requires understanding where it falls short.
Inaccurate population data in planning documents can distort resource allocation, misguide infrastructure investments, and undermine long-term planning efforts — and research suggests the ACS likely overestimates population figures in rapidly shrinking cities while potentially underestimating growth in fast-growing areas. For infrastructure planning, this means Census data should be used as one input among several — not as the sole basis for a capital investment decision. Smart Columbus
Cross-reference your Census population trends against locally available data wherever possible — building permit counts from your planning department, new water service connection applications from your billing system, school enrollment trends from your school district. When multiple data sources tell the same growth story, your infrastructure case becomes significantly more defensible.
Using Census Data for Grant Applications
One of the most practical applications of this analysis for a water department is grant funding. Federal and state infrastructure grants — including those available through the EPA's Water Infrastructure Finance and Innovation Act, the Drinking Water State Revolving Fund, and state-level water infrastructure programs — consistently require demographic justification for proposed capital projects.
A well-constructed Census-based population analysis that demonstrates projected service population growth, documents the gap between current capacity and future demand, and cross-references multiple Census datasets is exactly the type of evidence grant reviewers expect and reward. Departments that submit infrastructure grant applications without this demographic foundation are at a significant disadvantage compared to those that do.
Final Thoughts
Census data is not self-interpreting — it requires a planning question, a geographic focus, and an understanding of which dataset is appropriate for which purpose. The investment in learning to navigate data.census.gov pays dividends across nearly every function in local government: infrastructure planning, grant applications, budget justification, equity analysis, and long-range comprehensive planning all draw from the same underlying demographic foundation.
The reservoir capacity scenario in this article is one example. The same analytical framework — identify the question, select the right dataset, download and compare across time periods, apply to a planning decision — applies to school capacity analysis, transit demand forecasting, public health resource allocation, and dozens of other government planning contexts.
Start with table DP05 for your city. Download two non-overlapping five-year estimates. Calculate your growth rate. The rest follows from there.
Once you have your demographic baseline, the next step is often turning that data into a dashboard your leadership team can actually use in decision-making.
Ready to build dashboards for your department?
The Local Government Dashboard Template Pack includes three Excel dashboards built specifically for city analysts and utility managers — call center performance, utility billing, and public works service requests. Each template comes pre-loaded with fictional data so you can see it working immediately.
