Smartstaff, administrator
686
edits
Changes
updating categories
SmartSimple integrates with the U.S. Census online database to provide our clients with the ability to access the most up-to-date geographically-relevant data pertaining to their clients.
Census data is provided at three different levels: ''Tract'', ''County'' and ''State''. Census ''Tract''s are the lowest level of geographic region for which census data is aggregatedcan be returned.
In the example below, a {{WPV}} has been configured to display all three levels of census data on an organization [[profile]].
In the above example, the ''census block number'' for Abbeville Womens Equality's location is returned using the following [[variable]]:
:<font size="3">'''@ssGet(FFD(,FIPS;;@address@ @city@ @state@)@'''</font>
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">FFD stands for "Federal Financial Data" and FIPS stands for Federal Information Processing Standards.</pre>
On a {{UTA}} record, the ''census block number'' can be returned for an associated Organization by using:
:<font size="3">'''@ssGet(FFD(,FIPS;;@client.address@ @client.city@ @client.state@)@'''</font>
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Note: The U.S. Federal Communications Commission writes:
===Census Data Variable Syntax===
:<font size="3">'''@ssGet(FFD(,Profile;;''year'';;''Address or FIPS code'';;''level'';;<nowiki>[[</nowiki>''template''<nowiki>]]</nowiki>)@'''</font>
'''Where:'''
:* ''Profile'' is a constant.
In the example at the top of the page, the Median Family Income for Louisiana in 2012 ($56,047.00) is returned using
:<font size="3">'''@ssGet(FFD(profile,Profile;;2012;;@address@ @city@ @state@;;state;;<nowiki>[[</nowiki>B19113_001E<nowiki>]]</nowiki>)@'''</font> ==Characteristics Available in the Census Templates== A variety of datasets are available from the Census Bureau's templates. Using the [[List of census templates|templates]], you can return census data broken out by the following categories:*'''Demographic Characteristics'''**Sex**Age**Race**Hispanic Origin*'''Social Characteristics'''**Education**Marital Status**Fertility**Grandparent Caregivers**Veterans**Disability Status**Health Insurance**Place of Birth**Citizenship**Year of Entry**Language Spoken at Home**Ancestry / Tribal Affiliation*'''Economic Characteristics'''**Income**Benefits**Employment Status**Occupation**Industry**Commuting to Work**Place of Work**Housing Characteristics**Housing Tenure**Occupancy & Structure**Housing Value**Taxes & Insurance**Utilities**Mortgage/Monthly Rent
==List of Commonly-used Templates==
|}
A full list of the census data templates can be found here: {link to [[List of census templates}]] ==See Also==* [[SsGet]]* [[US census graphs]]
[[Category:Integration]]
[[Category:External Data Source]]
