 --Gets the column id for a census variable given a human readable version of it
 -- Old: OBS_LOOKUP_CENSUS_HUMAN
 
-CREATE OR REPLACE FUNCTION OBS_LookupCensusHuman(
+CREATE OR REPLACE FUNCTION cdb_observatory.OBS_LookupCensusHuman(
   column_names text[],
   -- TODO: change variable name table_name to table_id
   table_name text DEFAULT '"us.census.acs".extract_block_group_5yr_2013_69b156927c'


--Test polygon cause Stuart always seems to make random points in the water
-- TODO: remove as it's not used anywhere?
CREATE OR REPLACE FUNCTION _TestArea()
  RETURNS geometry
AS $$
BEGIN


--Used to expand a column based response to a table based one. Give it the desired
--columns and it will return a partial query for rolling them out to a table.
CREATE OR REPLACE FUNCTION cdb_observatory.OBS_BuildSnapshotQuery(names text[])
RETURNS TEXT
AS $$
DECLARE
