Another way of querying geo data from JSON column

geo_on_json.sql

explain analyze 
SELECT tmp_table.tid,
   tmp_table.screen_name,
   tmp_table.text
FROM
  (SELECT tid,
    data->'user'->>'screen_name' AS screen_name,
    data->>'text' AS text,
    ST_GeomFromText('POINT(' || CAST(data#>>'{geo,coordinates,1}' as varchar) || ' ' || CAST(data#>>'{geo,coordinates,0}' as varchar) || ')', 4326) AS geom
   FROM tweet
   WHERE data->>'geo' <> '') AS tmp_table
WHERE ST_Distance(
    ST_Transform(geom, 26986),
    ST_Transform(ST_GeomFromText('POINT(77.620176 13.004616)',4326), 26986)
) < 50000;