Difference between revisions of "Census Integration"
| Line 43: | Line 43: | ||
===Census Data Variable Syntax=== | ===Census Data Variable Syntax=== | ||
| − | :<font size="3">'''@FFD(Profile;;''year'';;''Address or FIPS code'';;''level'';;[[''template'']])@'''</font> | + | :<font size="3">'''@FFD(Profile;;''year'';;''Address or FIPS code'';;''level'';;<nowiki>[[</nowiki>''template''<nowiki>]]</nowiki>)@'''</font> |
'''Where:''' | '''Where:''' | ||
:* ''Profile'' | :* ''Profile'' | ||
| Line 52: | Line 52: | ||
::* '''county''' or | ::* '''county''' or | ||
::* '''state''' | ::* '''state''' | ||
| − | :* ''template'' Note that the template should be enclosed within a double set of square brackets (e.g., [[B01003_001E]]) | + | :* ''template'' Note that the template should be enclosed within a double set of square brackets (e.g., <nowiki>[[</nowiki>B01003_001E<nowiki>]]</nowiki>) |
You would then use the following template: for the tract level @FFD(Profile;;year;;Address or FIPS code;;tract;;template) | You would then use the following template: for the tract level @FFD(Profile;;year;;Address or FIPS code;;tract;;template) | ||
for the county level @FFD(Profile;;year;;Address or FIPS code;;county;;template) | for the county level @FFD(Profile;;year;;Address or FIPS code;;county;;template) | ||
Revision as of 14:21, 2 July 2014
Contents
Overview
SmartSimple In the example below, a Web Page View has been configured to display all three levels of census data on an organization profile.
Census Data can be referenced anywhere in SmartSimple:
...on a list view:
...on a record:
...or anywhere else. Data from the U.S. census can also be used to drive branching logic on SmartSimple workflows, or perform other calculations.
Returning the Tract Code
U.S. Federal Census Tract Code
Federal Information Processing Standards
The
FIPS Code Syntax
@FFD(FIPS;;@address@ @city@ @state@)@
- @FFD(FIPS;;@address@ @city@ @state@)@
Returning Census Data
The census data can be retrieved at three levels, the tract, county, and state.
Census Data Variable Syntax
- @FFD(Profile;;year;;Address or FIPS code;;level;;[[template]])@
Where:
- Profile
- year is the census year from which {need to enter allowable year values}
- Address or FIPS code
- level is one of
- tract
- county or
- state
- template Note that the template should be enclosed within a double set of square brackets (e.g., [[B01003_001E]])
You would then use the following template: for the tract level @FFD(Profile;;year;;Address or FIPS code;;tract;;template)
for the county level @FFD(Profile;;year;;Address or FIPS code;;county;;template)
for the state level @FFD(Profile;;year;;Address or FIPS code;;state;;template)
Example: @FFD(profile;;2012;;@address@ @city@ @state@;;county;; B01003_001E)
Profile – constant, query name
Year – integer value of year like 2012,2013. Normally last year statistics are not available until second halve of the current year
Address or FIPS code – can be full address or fips code like “@address@ @city@ @state@“ or “@FIPS@
Template – html template with statistic variables like “Earnings for Households:$B06002_001E”
Where B06002_001E is field name of Census data (please refer to the xlsx for complete list I sent earlier) ,2 square brackets are used to embed a fieldname
List of Commonly-used Templates
The census data templates used in the illustration at the top of the page are as follows:
| Template Name | Description |
| B01003_001E | Total Population |
| B05010_001E | Ratio of Income to Poverty Level in the Past 12 Months of Children by Living Arrangements and Nativity of Parents |
| B06002_001E | Median Age By Place of Birth In the United States |
| B17008_001E | Aggregate Income Deficit (Dollars) of Unrelated Individuals by Sex |
| B19051_001E | Earnings for Households |
| B19113_001E | Median Family Income |
A full list of the census data templates can be found here: {link to census templates}
