Difference between revisions of "Census Integration"

From SmartWiki
Jump to: navigation, search
Line 31: Line 31:
  
 
{|
 
{|
 +
|bgcolor=#D1D0CE|'''Template Name'''
 +
|bgcolor=#D1D0CE|'''Description'''
 +
|-
 +
|B01003_001E
 
|Total Population:  
 
|Total Population:  
|B01003_001E
 
 
|-
 
|-
|Ratio of Income to Poverty Level in the Past 12 Months of Children by Living Arrangements and Nativity of Parents:  
+
|bgcolor=#D1D0CE|B05010_001E
|B05010_001E
+
|bgcolor=#D1D0CE|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:  
 
|Median Age By Place of Birth In the United States:  
|B06002_001E
 
 
|-
 
|-
|Aggregate Income Deficit (Dollars) of Unrelated Individuals by Sex:  
+
|bgcolor=#D1D0CE|B17008_001E
|B17008_001E
+
|bgcolor=#D1D0CE|Aggregate Income Deficit (Dollars) of Unrelated Individuals by Sex:  
 
|-
 
|-
 +
|B19051_001E
 
|Earnings for Households:  
 
|Earnings for Households:  
|B19051_001E
 
 
|-
 
|-
|Median Family Income:  
+
|bgcolor=#D1D0CE|B19113_001E
|B19113_001E
+
|bgcolor=#D1D0CE|Median Family Income:  
 
|}
 
|}
  

Revision as of 13:04, 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.

CensusProfileWPV.png

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)


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}



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