Place

Dataset

Description

Census places are geographical areas defined by the US Census Bureau that include both Incorporated Places and Census Designated Places (CDPs). Incorporated Places are legally bounded entities established by the government in each state, including cities, towns, villages, and boroughs. CDPs are statistical entities. A Place can span county boundaries, but cannot cross state lines.

Incorporated Place

An incorporated place has a legally defined boundary. Depending on the state,m they may be known as a city, borough, town, or village.

Census Designated Place (CDP)

Statistical entities occupying a contiguous area that are defined by the Census Bureau in the absence of Incorporated Places. They provide a way of accumulating data in areas with settled populations. To qualify as a CDP, they must contain some population or housing units, usually at least 10 housing units.

Geo ID	1802 : 2f5090ffe082453a270e083c992236c6
Name	Irvine city
Label	Irvine, County, CA
FIPS Code	36770 (Orange)
Type	Incorporated place
Land Area (sq. miles)	65.64
Water Area (sq. miles)	0.31
Total Area (sq. miles)	65.94
Longitude (Downtown)	-117.82311
Latitude (Downtown)	33.66946
Longitude	-117.770151
Latitude	33.68655

Place versus Postal City

It is common for a postal city to share the name of the main place around which it is based. If that place is incorporated, its boundaries will have a legal definition. The postal city is defined based on the way USPS delivers mail to that rea. In most cases, the postal city will be larger than the incorporated place (city, town, borough). Parts of an incorporated city may be included in a neighboring postal city. Confusion often exists between the place name and the postal city assigned. Residents often identify themselves as belonging to the official name of the place leading to the name of the place being substituted for the postal city when providing an address for a property.

Note: While postal cities will be unique within a state, place names may only be unique within a county. e.g. California has an incorporated city called 'Burbank' in Los Angeles County and a CDP called 'Burbank' in Santa Clara County.

In the example below we can see the difference between the incorporated city of Las Vegas and the larger postal city.

Tables/Views

DimPlace

Profile for each Place currently defined by the Census Bureau.

MafTigerFeatureClass: Identifies Incorporated Places ('Incorporated place') and Census Designated Places ('Census designated place')

LegalStatisticalAreaDescription: Identifies the name assigned to the Place Type - e.g. city, CDP, town, borough, village

FIPSClassCode: An alternate designation of Place Types - see Census Bureau Class Codes and Definitions - e.g. C1 (Incorporated place), C5 (incorporated place independent of a county subdivision)

Examples

Place Demographics for a Property

The following example demonstrates how to find the Place for a property and then obtain the demographics for that Place.

/*
 * Place demographics for a specific property.
 * Demonstrates how to match properties to Place data such as demographics
 */
SELECT 
	-- Property Details
	pa.[ATTOM ID],
	CONCAT(pa.SitusAddress,', ',pa.SitusCity,' ',pa.SitusState,' ',pa.SitusZip) AS Address,
    
    -- County Subdivision
    pbm.GeographyTypeKey,
    dt.Label,
    dt.AreaSquareMiles,
    
	-- Demographic data
	cd.Population,
	cd.Households
	
From adw.PropertyAddresses pa																-- Addresses
Left Join adw.PropertyBoundaryMatch pbm on pa.[ATTOM ID] = pbm.[ATTOM ID] 					-- Geocodes
Left Join adw.CommunityDemographics cd on pbm.GeographyKey = cd.GeographyKey And pbm.GeographyTypeKey = cd.GeographyTypeKey -- Demographics
Left Join adw.DimPlace dt on pbm.GeographyKey = dt.PlaceKey 						  	-- Place

Where
	pa.[ATTOM ID] = 51118543 And 		-- Specific Property
	pbm.GeographyTypeKey = 45			-- Place