Skip to content

Instantly share code, notes, and snippets.

@Vizzuality
Vizzuality / gist:1215968
Created September 14, 2011 06:20
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
Vizzuality / gist:1215966
Created September 14, 2011 06:18
{"time":0.002,"total_rows":1,"rows":[{"lon":-87.6376,"lat":41.8824}]}
@Vizzuality
Vizzuality / spanish_municipal_elections_data_2011.rb
Created May 23, 2011 23:46
Concurrent downloader for 2011 Spanish municipal election data. Outputs to CSV.
# 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:
#