Skip to content

Instantly share code, notes, and snippets.

@Vizzuality

Vizzuality/gist:1215968

Created September 14, 2011 06:20
Show Gist options
  • Save Vizzuality/1215968 to your computer and use it in GitHub Desktop.
Save Vizzuality/1215968 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT
st_x(the_geom) as lon,
st_y(the_geom) as lat
FROM geo_ips
WHERE ip_start <=inetmi('69.31.103.39','0.0.0.0')
ORDER BY ip_start DESC
LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment