Vizzuality

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

Vizzuality

{"time":0.002,"total_rows":1,"rows":[{"lon":-87.6376,"lat":41.8824}]}

Vizzuality

# encoding: UTF-8
# Copyright (C) 2011 by Vizzuality SL
# 
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:
#