Difference between revisions of "Census Integration"
| Line 29: | Line 29: | ||
Example: @FFD(profile;;2012;;@address@ @city@ @state@;;county;; [[B01003_001E]]) | 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 | ||
| + | |||
| + | |||
| + | The census data templates used in the illustration at the top of the page are as follows: | ||
{| | {| | ||
Revision as of 14:16, 2 July 2014
General Description
SmartSimple In the example below, a Web Page View has been configured to display all three levels of census data on an organization profile.
Returning the Tract Code
U.S. Federal Census Tract Code
@FFD(FIPS;;@address@ @city@ @state@)@
Returning Census Data
The census data can be retrieved at three levels, the tract, county, and state.
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
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}
