Changes

Jump to: navigation, search

Census Integration

629 bytes added, 18:16, 2 July 2014
no edit summary
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:
{|
8,849
edits

Navigation menu