SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TOWNPOPN
WHERE TOWNCODE = #URL.ProfileTown#
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_townnames
WHERE town NOT LIKE '#ProfileTown#'
ORDER BY TOWNNAME
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#' AND GEOTYPE = 't'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_qualitative
WHERE TOWNNAME = '#ProfileTown#'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntynames
WHERE CNTYNAME = '#ProfileCounty#'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR
WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY
WHERE GEOTYPE = 's'
SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR
WHERE GEOTYPE = 's'
#getTownRec0.TOWNNAME#
Click on Hyperlinked
numbers to get a historical trend report.
Click on Variable Titles to access data definitions and sources.