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:"Form 477 requires broadband providers to submit data on a census-tract basis. For the filing of data as of December 31, 2011, or later dates, the Form 477 electronic filing system will recognize as valid the combinations of County and Census tract codes from the Year 2010 Census."- from http://transition.fcc.gov/form477/censustracts.htmlReturning the FIPS code makes it easy for SmartSimple's clients to submit forms electronically to the FCC.</pre>
==Returning Census Data==
===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.
:* ''year'' is the census year from which {need to enter allowable year values}the data is returned. Accepts '''2012''', '''2011''', and '''2010'''
:* ''Address or FIPS code'' accepts
::* a variable reference to the address, such as ''@address@ @city@ @state@''
::* '''county''' or
::* '''state'''
:* ''template'' is the type of census data to be returned. Over 45,000 different database fields can be reported on from the online census database. [[Census_Integration#List_of_Commonly-used_Templates|Examples]] are listed below. Note that the template should be enclosed within a double set of square brackets (e.g., <nowiki>[[</nowiki>B01003_001E<nowiki>]]</nowiki>will return the ''Total Population'')
'''Example:'''
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]]
