Points are off the map

[sciciliani]

Running this example query and visualizing through bigquerygeoviz

SELECT ST_GEOGPOINT(lat, lon) as geo FROM properati-data-public.properties_ar.properties_sell_201802 WHERE lat_lon <> '' limit 500

As you see results are outside the continent

Same point from resultset in Google Maps provides correct location

[donmccurdy]

The ST_GEOGPOINT SQL function requires lng, lat rather than lat, lng — see https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpoint.