gistfile1.txt

    "queries": [
        {
            "name": "main_query",
            "display name": "Stats By Country",
            "styles": ["outline_style","loft_style"],
                "query": "http://mousebird.cartodb.com/api/v2/sql?format=GeoJSON&q=SELECT ne_110m_admin_0_map_units.the_geom,(0.1*(une_measurements.measurement-({{data_set_min}}))/({{data_set_max}}-({{data_set_min}}))+0.01) as height, une_measurements.measurement as measurement,((une_measurements.measurement-({{data_set_min}}))/({{data_set_max}}-({{data_set_min}}))) as color_ramp, ne_110m_admin_0_map_units.name FROM ne_110m_admin_0_map_units inner join une_nations on ne_110m_admin_0_map_units.adm0_a3 = une_nations.iso3 inner join une_measurements on une_nations.id = une_measurements.nation_id WHERE ST_Intersects(ne_110m_admin_0_map_units.the_geom,ST_SetSRID(ST_Point({{taplon}},{{taplat}}),4326)) AND une_measurements.data_set_id = {{data_set}}"
        },