County Subdivision

Dataset

Description

Each county can consist of one or more county subdivisions. These can be either Minor Civil Divisions (MCDs) or Census County Divisions (MCDs). A county cannot have both. An MCD has legal boundaries and names as well as a government or administrative purpose defined by State law. CCDs are statistical entities established cooperatively by the US Census Bureau and State/local government.

Many counties are divided into a combination of subdivisions, Indian Land Areas, and Places. Each county contains at least one county subdivision. The following map shows the dissection of two Southern California counties.

Examples

County Subdivision Demographics for a Property

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

/*
 * County Subdivision demographics for a specific property.
 * Demonstrates how to match properties to County Subdivision such as demographics
 */
SELECT 
	-- Property Details
	pa.[ATTOM ID],
	CONCAT(pa.SitusAddress,', ', pa.SitusCity,' ',pa.SitusState,' ',pa.SitusZip) AS Address,
    
	-- County Subdivision
	dt.Label,
	dt.LandAreaSquareMiles,
    
	-- 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.DimCountySubdivision dt on pbm.GeographyKey = dt.CountySubdivisionKey 		 -- County Subdivision

Where
	pa.[ATTOM ID] = 156293872 And 		-- Specific Property
	pbm.GeographyTypeKey = 38		-- County Subdivision