Sono un geomatico
Mi occupo rilevamento e trattamento informatico
dei dati relativi alla terra e all’ambiente.
mappa: Stamen design
Open Data Sicilia
Un'iniziativa civica che si propone di far conoscere e diffondere la cultura dell'open government e le prassi dell'open data nel nostro territorio e aprire una discussione pubblica partecipata.
Open data is publicly available data that can be universally and readily accessed, used, and redistributed free of charge. It is structured for usability and computability.
Project Open Data: https://project-open-data.cio.gov/principles/
Project Open Data: https://project-open-data.cio.gov/principles/
Complete. Open data are published in primary forms (i.e., as collected at the source), with the finest possible level of granularity that is practicable and permitted by law and other requirements. Derived or aggregate open data should also be published but must reference the primary data.
Timely. Open data are made available as quickly as necessary to preserve the value of the data. Frequency of release should account for key audiences and downstream needs.
Managed Post-Release. A point of contact must be designated to assist with data use and to respond to complaints about adherence to these open data requirements.
Project Open Data: https://project-open-data.cio.gov/principles/
foto da Wikipedia
Download
curl -s "https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artworks.csv" > artworks.csv
Check e visualizzazione
head -n 3 artworks.csv
head -n 3 artworks.csv | csvlook
Filtri "orizzontali"
head -n 3 artworks.csv | csvcut -c 1,3 | csvlook
csvlook -n artworks.csv
csvcut -c Artist,ArtistBio,Date
"Analisi"
csvstat artworks.csv
SQL
csvsql --query "select count(*) AS 'numero', Artist from '10000' where Artist like 'Bernard Tschumi' group by Artist" 10000.csv
Andrea Borruso
@aborruso | aborruso@gmail.com