Skip to content

Instantly share code, notes, and snippets.

View aborruso's full-sized avatar

Andrea Borruso aborruso

178 followers · 45 following
View GitHub Profile
@aborruso
aborruso / open_pompei.geojson
Created March 1, 2014 18:43 — forked from anonymous/open_pompei.geojson
Layer exported from QGIS
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / layer.map
Created March 4, 2014 16:01
my test mapserver layer
LAYER
CLASSITEM "Status"
CONNECTION "mappa_di_base.shp"
CONNECTIONTYPE OGR
FILTER ('[Status]' eq '3' OR '[Status]' eq '2' OR '[Status]' eq '1')
LABELITEM "ID"
METADATA
"coordsys_name" "Popular Visualisation CRS / Mercator (deprecated)"
END # METADATA
NAME "geo_32633"
@aborruso
aborruso / import.py
Created March 19, 2014 09:38
import logging, importio, threading, json
# We define a latch class as python doesn't have a counting latch built in
class _Latch(object):
def __init__(self, count=1):
self.count = count
self.lock = threading.Condition()
def countDown(self):
with self.lock:
@aborruso
aborruso / route_line.geojson
Created March 23, 2014 20:58 — forked from anonymous/route_line.geojson
Layer exported from QGIS
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / route_line.geojson
Created March 23, 2014 20:58 — forked from anonymous/route_line.geojson
Layer exported from QGIS
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / civici.geojson
Created June 24, 2014 08:00
Civici PCN
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / gb.geojson
Created June 25, 2014 07:43
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / percesare.txt
Created July 29, 2014 15:40
<OGRVRTDataSource>
<OGRVRTLayer name="civici">
<SrcDataSource>wfs:http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map</SrcDataSource>
<SrcLayer>IN.NUMERICIVICI.2012</SrcLayer>
<SrcRegion clip="true">POLYGON((44.82960736463044071 7.5892761493695664,44.83504584054348641 7.58974498350000104,44.8351396073695696 7.58674444506521795,44.82951359780435752 7.5866506782391312,44.82960736463044071 7.5892761493695664))</SrcRegion>
</OGRVRTLayer>
</OGRVRTDataSource>
@aborruso
aborruso / beni_toscana
Created July 31, 2014 11:45
{ "type": "FeatureCollection",
"features": [{ "geometry": {"type": "Point", "coordinates": [1696718.0, 4789302.0] },
"properties": {"id":"24",
"prov":"SI",
"comune":"Monteroni d'arbia",
"indirizzo":"Strada Monteroni, Vescovado, 3003/A",
"macrotipologia":"Società e aziende",
"tipologia":"Aziende in gestione",
@aborruso
aborruso / geocode_nominatim_gdrive
Created August 1, 2014 08:35
Geocoding con le API di MapQuest Nominatim a partire da GDrive
#Geocoding con le API di MapQuest Nominatim a partire da GDrive
Per fare il Geocoding con le **API** di **[MapQuest Nominatim](http://developer.mapquest.com/web/products/open/nominatim)** a partire da un foglio elettronico GDrive, basta applicare la funzione [ImportXML](https://support.google.com/docs/answer/3093342?hl=it) di GDrive alle celle che contengono i toponimi che vogliamo trasformare in una coppia di coordinate.
Se ad esempio ho il mio toponimo nella cella A2, la formula da applicare sarà:
=JOIN(",", ImportXML(CONCATENATE("http://open.mapquestapi.com/nominatim/v1/search?format=xml&q=",A2), "//searchresults/place[1]/@lat | //searchresults/place[1]/@lon"))
Il tutto in azione [qui](https://docs.google.com/spreadsheets/d/1s8dTaPSUCORUsXsylcu4PsesTJ9ddG-_fXlNHkEPEGs/edit?usp=sharing).