Difference between revisions of "Census Integration"

Revision as of 13:27, 2 July 2014

Template:UnderConstruction

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.

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

The census data templates used in the illustration at the top of the page are as follows:

A full list of the census data templates can be found here: {link to census templates}

http://www.ffiec.gov/Geocode/default.aspx