regex fix for ctsurn capture
creating a seperate place for one-off methods
updating sql schema and latest info from fusion tables