SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TOWNPOPN WHERE FIPS6 = #URL.ProfileTown# SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TOWNPOPN WHERE FIPS6 = #URL.ProfileSecondTown# SELECT * FROM VCGI_Admin.TABLE_INDICATORS_townnames WHERE town NOT LIKE '#ProfileTown#' ORDER BY town SELECT * FROM VCGI_Admin.TABLE_INDICATORS_townnames WHERE TOWNNAME = '#ProfileTown#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR WHERE TOWNNAME = '#ProfileTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_CIVC WHERE TOWNNAME = '#ProfileTown#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_qualitative WHERE TOWNNAME = '#ProfileTown#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_townnames WHERE town NOT LIKE '#ProfileSecondTown#' ORDER BY town SELECT * FROM VCGI_Admin.TABLE_INDICATORS_townnames WHERE TOWNNAME = '#ProfileSecondTown#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR WHERE TOWNNAME = '#ProfileSecondTown#' AND GEOTYPE = 't' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_CIVC WHERE TOWNNAME = '#ProfileSecondTown#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_qualitative WHERE TOWNNAME = '#ProfileSecondTown#'

#getTownRec0.TOWN# & #getTown2Rec0.Town#

Click on Hyperlinked numbers to get a historical trend report.
Click on Variable Titles to access data definitions and sources.

View A Theme Table

Select A New Town To Profile

Compare a Second Town