Changes

Jump to: navigation, search

Census Integration

1,583 bytes added, 18:17, 20 July 2017
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]].
<!--what are the last four digits?-->
U.S. Federal Census Tract ===FIPS Code Federal Information Processing StandardsSyntax===
The 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 Code Syntax===stands for Federal Information Processing Standards.</pre>
@FFD(FIPS;;@address@ @city@ @state@)@ 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>
This function returns census block number, it <pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; is a 15word-wrap: break-digit word;"FIPS>Note: The U.S. Federal Communications Commission writes:" code that incorporates - reading from left Form 477 requires broadband providers to right submit data on a census- tract basis. For the location's 2-digit State codefiling of data as of December 31, 2011, or later dates, 3-digit the Form 477 electronic filing system will recognize as valid the combinations of County code, and 6Census tract codes from the Year 2010 Census."-digit census tract from http://transition.fcc.gov/form477/censustracts.htmlReturning the FIPS codemakes it easy for SmartSimple's clients to submit forms electronically to the FCC.</pre>
==Returning Census Data==
  The Detailed census data can be retrieved at three levels, the ''tract'', ''county'', and ''state''.
===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@''::* the 15-digit ''census block number'':* ''level'' is accepts three values, one of
::* '''tract'''
::* '''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'')You would then use '''Example:'''In the example at the following template: for top of the tract level @FFD(Profile;;year;;Address or FIPS code;;tract;;template) for page, the county level @FFD(Profile;;year;;Address or FIPS code;;county;;template) Median Family Income for the state level @FFDLouisiana in 2012 (Profile;;year;;Address or FIPS code;;state;;template) Example: @FFD(profile;;2012;;@address@ @city@ @state@;;county;; [[B01003_001E]]$56,047.00)is returned using
:<font size="3">'''@ssGet(FFD,Profile;;2012;;@address@ @city@ @state@;;state;;<nowiki>[[</nowiki>B19113_001E<nowiki>]]</nowiki>)@'''</font>
Profile – constant, query name==Characteristics Available in the Census Templates== Year – integer value A variety of year like 2012,2013. Normally last year statistics datasets are not available until second halve of from the Census Bureau's templates. Using the current yearAddress 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_001EList 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**CitizenshipWhere B06002_001E is field name **Year of Census data (please refer Entry**Language Spoken at Home**Ancestry / Tribal Affiliation*'''Economic Characteristics'''**Income**Benefits**Employment Status**Occupation**Industry**Commuting to the xlsx for complete list I sent earlier) ,2 square brackets are used to embed a fieldnameWork**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==http://www.ffiec.gov/Geocode/default.aspx* [[SsGet]] * [[US census graphs]]
[[Category:Integration]]
[[Category:External Data Source]]
Chin
Smartstaff, administrator
686
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/22490...30547’

Navigation menu