Skip to content

Instantly share code, notes, and snippets.

View aborruso's full-sized avatar

Andrea Borruso aborruso

177 followers · 45 following
View GitHub Profile
@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).
@aborruso
aborruso / mibac.xml
Last active August 29, 2015 14:04
<?xml version="1.0" encoding="UTF-8"?>
<mibac>
<metainfo>
<workflow>
<stato>Validato</stato>
<enteCompilatore ruolo="Compilatore">
<denominazione>DIREZIONE REGIONALE PER I BENI CULTURALI E PAESAGGISTICI DELL'ABRUZZO</denominazione>
</enteCompilatore>
<nomeRedattore>DBUnico Supporto</nomeRedattore>
<nomeCapoRedattore>DBUnico Supporto</nomeCapoRedattore>
@aborruso
aborruso / geojson_out.json
Created September 1, 2014 09:15
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / geojson_in.json
Created September 1, 2014 09:15
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso
aborruso / mydp
Created September 13, 2014 13:45
{
"title": "Avvisi di Gara - Albo Pretorio Comune Palermo",
"description": "Gli ultimi avvisi di gara, pubblicati sull'albo pretorio del Comune di Palermo",
"name": "avvisi_gara",
"licenses": [
{
"id": "CC BY 4.0",
"name": "CC BY 4.0",
"version": "4",
"url": "http://creativecommons.org/licenses/by/4.0/"
@aborruso
aborruso / geo.json
Created September 18, 2014 09:37
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.