Google Product Forums

So close but cannot figure out WHERE statement! Please help!

mpinter09 Jul 17, 2012 9:45 PM
Posted in group: Google Fusion Tables

Categories: How do I...? :

I am a new programmer trying to figure out how to filter FusionTable information with where statements.  I have a Congressional District map and when an address is entered, I ONLY want the district the address is in as well as the information associated with that address displayed. 

Specifically I want the following parameters displayed:

Assembly District
Representative
Population

Here is a link to my FusionTable (I don't want that Description information displayed, but cannot figure out how to remove it from the table -- https://www.google.com/fusiontables/DataSource?docid=1EXBosdqDnZ_Uz0K-PiOXCtGVGfddFv6OYMcAaus)

Here's the bit of code with the where statement:

var whereClause = ' = \'' + '\' AND ST_INTERSECTS(geometry, CIRCLE(LATLNG('+ results
[0].geometry.location.lat() + ','+ results[0].geometry.location.lng() +'), 10))';

AssemblyDistrictQuery.where = whereClause;
SenateDistrictQuery.where = whereClause;

Can anyone fix this statement to make it work?