Census - enterprise_tax - web_services - 23.1

Spectrum Web Services Guide

Product type
Software
Portfolio
Integrate
Product family
Spectrum
Product
Spectrum > Web Services
Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Web Services Guide
First publish date
2007
Last updated
2024-10-17
Published on
2024-10-17T00:33:46.811413

The census output fields contains census information from the U.S. Census, including Minor Civil Divisions (MCDs) and Census County Division (CCD) names and codes. MCDs are the primary political or administrative divisions of a county, representing many kinds of legal entities with a variety of governmental and administrative functions. CCDs are established in states where there are no legally established MCDs. The Census Bureau recognizes MCDs in 28 states and has established CCDs in 21 states. The District of Columbia has no primary divisions, and the city of Washington, DC is considered equivalent to an MCD for data presentation purposes.

Census data also contains the Federal Information Processing Standards (FIPS) codes for each state and county. The FIPS State Code and the FIPS County Code are both used by the Census Bureau to identify these geographic units.

The table below lists the output fields that contain census data. To include census data in the output, set GeoTAXOutputRecordType Option.GeoTAXOutputRecordType = C. To include census file data in the output, click the Output tab, then under Include data, select the Census check box.
Note: Fields denoted by an asterisk "*" are always included in the output regardless of whether or not you choose to include census data in the output. Contents returned when available; otherwise, left blank.
columnName Field Name Response Element Max. Field Length with null terminator Description

Census.Block

4

Census Block ID.

Census.BlockGroup

2

Census Block Group code.

Census.MatchCode*

2

The level of match obtained against the databases.

5
ZIP Code level match
9
ZIP + 4 Code level match
A
User Auxiliary file match
C
Street centroid match
F
Geographic fallback match
G
State-supplied file match
I
Intersection match
L
Landmark Auxiliary file match
M
Multiple match (multi-match)
O
Input latitude/longitude coordinates match
P
Address point match
S
Street address match
U
GeoTAX Auxiliary file match
X
Cancelled processing or expired database
Blank
Did not match

Census.MatchLevel*

19

The level of match obtained against the databases.

AbortedExpiredData
Cancelled processing or expired database
Aux2
GeoTAX Auxiliary file match
Auxiliary
Auxiliary street match
FallbackGeographic
Geographic fallback match
Gov
State file address match
Intersection
Intersection match
LatLonInput
Input latitude/longitude coordinates match
LandmarkAux
Landmark Auxiliary file match
MultiMatch
Multiple match
Point
Address point match
Street
Street address match
StreetCentroid
Street centroid match
ZIP
ZIP Code level match
ZIP+4
ZIP + 4 Code level match
NoMatch
Did not match

Census.Tract

7

Six-digit tract number extracted from the Census.BlockCode.

County.Code*

4

Extracted from the Census.BlockCode.

County.Name*

26

Name of the county.

MCD.Code

6

Minor Civil Division/Census County Division (MCD/CCD) Code.

MCD.Name

41

Minor Civil Division/Census County Division (MCD/CCD) name.

MCD.PointStatus*

2

An address can be compared to a Minor Civil Division (MCD)/county subdivision file (Cousub.txt). This output field returns the result for a comparison between the matched address point to the polygon defined by the Cousub.txb file.

For more information on buffers, see Buffering.

Note: The buffer distance for Cousub.txb is internally set to zero and cannot be modified.
P
The point is in the polygon.
I
The point is in the buffer area inside the polygon.
B
The point is in the buffer area and outside of the polygon.
blank
Polygon not found.

MCD.DistanceToBorder*

10

Returns the distance in feet between the matched address point to the polygon defined by the Cousub.txb file.

MCD.Confidence

4

Provides the percentage overlap of the geocode to the MCD polygon layer. The returned percentage value describes the probability that the point falls in the MCD.

CBSA.Code

6

Core Based Statistical Area (CBSA) code.

CBSA.Name

76

Core Based Statistical Area (CBSA) name.

CBSA.MetroFlag

2

Indicates if the CBSA is a "Metropolitan Statistical Area" or a "Micropolitan Statistical Area".

Y
Metropolitan Statistical Area - A Core Based Statistical Area associated with at least one urbanized area that has a population of at least 50,000. The Metropolitan Statistical Area comprises the central county or counties containing the core, plus adjacent outlying counties having a high degree of social and economic integration with the central county as measured through commuting.
N
Micropolitan Statistical Area - A Core Based Statistical Area associated with at least one urban cluster that has a population of at least 10,000, but less than 50,000. The Micropolitan Statistical Area comprises the central county or counties containing the core, plus adjacent outlying counties having a high degree of social and economic integration with the central county as measured through commuting.

CBSAD.Code

6

Core Based Statistical Area Division (CBSAD) code.

CBSAD.Name

73

Core Based Statistical Area Division (CBSAD) name.

CSA.Code

4

Combined Statistical Area (CSA) code.

CSA.Name

78

Combined Statistical Area (CSA) name.

State.Abbreviation*

3

Two-character state abbreviation.

StateCode*

3

Two-digit Federal Information Processing Standards (FIPS) state code extracted from the Census.BlockCode.