Embed Size (px)
Citation preview
datos abiertos
david sasaki
@oso
Wednesday, August 8, 12
¿qué son los datos abiertos?
¿cómo se ven los datos abiertos?
¿qué son tres ejemplos?
¿por qué nos importan?
Wednesday, August 8, 12
los datos abiertos son como los hipsters
Wednesday, August 8, 12
1. completos
2. originarios
3. recientes
4. accesibles
5. procesables
6. no propietarios
7. sin licencia restrictiva
8. revisables
los datos abiertos tienen que ser ...
Wednesday, August 8, 12
¿cómo se ven los datos abiertos?
Wednesday, August 8, 12
así:
Id,Nombre,Calle,Nro,Piso,Dpto,CPostal,Pais,ProvinciaId,Localidad,CalleEntre1,CalleEntre2,BicicletasMinimas,BicicletasMaximas,Cascos,CreateDate,cLat,cLong1,EN TRANSITO,,0,NULL,NULL,,13,24,CAPITAL FEDERAL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,04/11/2010,NULL,NULL2,DEPOSITO IRALA,IRALA,100,NULL,NULL,1414,13,24,CABA,NULL,NULL,11,4232-3232,NULL,NULL,0,0,-7,04/11/2010,NULL,NULL3,RETIRO,AV. DR. J. RAMOS MEJIA,0,NULL,NULL,1002,13,24,CABA,AV. LIBERTADOR,GILARDI,11,3697-4188,NULL,NULL,0,60,27,04/11/2010,-34.592308,-58.375014,TALLER,RIVADAVIA,500,NULL,NULL,1002,13,24,CABA,NULL,NULL,11,1234-2358,NULL,NULL,0,0,NULL,04/11/2010,NULL,NULL5,ADUANA,MORENO,300,NULL,NULL,1002,13,24,CABA,PASEO COLON,AZOPARDO,11,3697-4188,NULL,NULL,0,60,6,04/11/2010,-34.611365,-58.3690776,DERECHO,AVENIDA FIGUEROA ALCORTA,2101,NULL,NULL,1001,13,24,CABA,F. ROMERO,J. V. GONZALEZ,11,3697-4984,NULL,NULL,0,20,66,20/11/2010,-34.583669,-58.3912437,PLAZA ROMA,L. N. ALEM,500,NULL,NULL,1001,13,24,CABA,NULL,NULL,11,12345678,NULL,NULL,0,65,45,13/12/2010,-34.601599,-58.3694218,PLAZA ITALIA,AV. SARMIENTO Y CALZADA CIRCULAR,1111,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,36974892,11,1234567,0,20,22,03/01/2011,-34.580224,-58.4207519,PARQUE LEZAMA,AV. MARTIN GARCIA E IRALA,111,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,36974042,NULL,NULL,0,30,-3,03/01/2011,-34.628017,-58.36985310,OBELISCO,9 DE JULIO,1111,NULL,NULL,111,13,24,CABA,J. D. PERON,NULL,11,36974422,NULL,NULL,0,34,17,11/01/2011,-34.606297,-58.38105111,PARQUE ROCA,CALLE 1,1,1,1,1111,13,24,CABA,NULL,NULL,11,43238115,NULL,NULL,0,0,0,18/01/2011,NULL,NULL12,PARQUE DE LOS NIÑOS,CALLE 2,2,2,2,2222,13,24,CABA,NULL,NULL,11,43238115,NULL,NULL,0,0,0,18/01/2011,NULL,NULL14,BICIS DE MUESTRA,PASEO COLON,1111,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,11111111,NULL,NULL,0,0,-19,24/01/2011,NULL,NULL15,CONGRESO,VIRREY CEVALLOS E HIPOLITO YRIGOYEN,1111,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,40272143,NULL,NULL,0,34,13,27/01/2011,-34.609829,-58.38928916,PARQUE LAS HERAS,SOBRE CORONEL DIAZ ENTRE PEÑA Y FRENCH,1111,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,36974749,NULL,NULL,0,0,48,10/02/2011,-34.58503,-58.40763717,UCA PUERTO MADERO,ALICIA MOREAU DE JUSTO,1111,NULL,NULL,1111,13,24,CABA,Y CHILE,NULL,11,36974162,NULL,NULL,0,60,21,25/02/2011,-34.615974,-58.36566618,TRIBUNALES,TUCUMAN Y TALCAHUANO,600,NULL,NULL,1002,13,24,CABA,NULL,NULL,11,40259663,NULL,NULL,0,60,11,28/03/2011,-34.601342,-58.38500819,PLAZA VICENTE LOPEZ,LAS HERAS,1111,NULL,NULL,1111,13,24,CABA,MONTEVIDEO,NULL,11,40273138,NULL,NULL,0,40,11,27/04/2011,-34.593367,-58.38969820,ONCE,RIVADAVIA,111,NULL,NULL,1111,13,24,CABA,CATAMARCA,NULL,11,11111111,NULL,NULL,0,20,29,21/05/2011,-34.609475,-58.40761521,PACIFICO,BULLRICH,1111,NULL,NULL,1111,13,24,CABA,SANTA FE,NULL,11,11111111,NULL,NULL,0,30,43,06/06/2011,-34.577468,-58.42615822,VIRREY CEVALLOS,VIRREY CEVALLOS,1111,NULL,NULL,1111,13,24,CABA,AV. SAN JUAN.,NULL,11,55859403,NULL,NULL,0,35,3,15/06/2011,-34.622755,-58.38894723,PLAZA HOUSSAY,CORDOBA,1111,NULL,NULL,1111,13,24,CABA,URIBURU,JUNIN,11,40245236,NULL,NULL,0,35,18,29/06/2011,-34.59902,-58.39821724,PLAZA DE MAYO,DIAGONAL SUR,111,NULL,NULL,1111,13,24,CABA,PERU,NULL,11,11111111,NULL,NULL,0,40,6,03/08/2011,-34.609917,-58.37472125,PLAZA ALMAGRO,PERON,1111,NULL,NULL,1111,13,24,CABA,BULNES,SALGUERO,11,11111111,NULL,NULL,0,34,5,30/08/2011,-34.605926,-58.41948226,CMD,VILLARINO,2498,NULL,NULL,1111,13,24,CABA,NULL,NULL,11,11111111,NULL,NULL,0,34,16,06/09/2011,-34.654286,-58.38042927,INDEPENDENCIA,BERNARDO DE IRIGOYEN,111,NULL,NULL,1111,13,24,CABA,INDEPENDENCIA,NULL,1115,11111111,NULL,NULL,0,34,13,16/09/2011,-34.617908,-58.3804728,PLAZA SAN MARTIN,AV.SANTA FE,111,NULL,NULL,1111,13,24,CABA,ESMERALDA,ARENALES,1115,11111111,NULL,NULL,0,34,13,16/09/2011,-34.594958,-58.378283
Wednesday, August 8, 12
y así:
EstacionId EstacionNombre
DomicilioCalle
DomicilioNro
DomicilioPiso
DomicilioDpto
DomicilioCPostal
DomicilioPaisId
DomicilioProvinciaId
DomicilioLocalidad
DomicilioCalleEntre1
DomicilioCalleEntre2
TelefonoArea1
TelefonoNumero1
TelefonoArea2
TelefonoNumero2
BicicletasMinimas
BicicletasMaximas
Cascos CreateDate
cLat cLong
1 EN TRANSITOEN TRANSITO 0 NULL NULL 13 24 CAPITAL FEDERAL
NULL NULL NULL NULL NULL NULL 0 0 0 4/11/10 NULL NULL
2 DEPOSITO IRALA
IRALA 100 NULL NULL 1414 13 24 CABA NULL NULL 11 4232-‐3232
NULL NULL 0 0 -‐7 4/11/10 NULL NULL
3 RETIRO AV. DR. J. RAMOS MEJIA
0 NULL NULL 1002 13 24 CABA AV. LIBERTADOR
GILARDI 11 3697-‐4188
NULL NULL 0 60 27 4/11/10 -‐34.59231 -‐58.37501
4 TALLER RIVADAVIA
500 NULL NULL 1002 13 24 CABA NULL NULL 11 1234-‐2358
NULL NULL 0 0 NULL 4/11/10 NULL NULL
5 ADUANA MORENO 300 NULL NULL 1002 13 24 CABA PASEO COLON
AZOPARDO
11 3697-‐4188
NULL NULL 0 60 6 4/11/10 -‐34.61137 -‐58.36908
6 DERECHO AVENIDA FIGUEROA ALCORTA
2101 NULL NULL 1001 13 24 CABA F. ROMERO
J. V. GONZALEZ
11 3697-‐4984
NULL NULL 0 20 66 20/11/2010
-‐34.58367 -‐58.39124
7 PLAZA ROMA
L. N. ALEM
500 NULL NULL 1001 13 24 CABA NULL NULL 11 12345678 NULL NULL 0 65 45 13/12/2010
-‐34.6016 -‐58.36942
8 PLAZA ITALIA
AV. SARMIENTO Y CALZADA CIRCULAR
1111 NULL NULL 1111 13 24 CABA NULL NULL 11 36974892 11 1234567 0 20 22 3/1/11 -‐34.58022 -‐58.42075
9 PARQUE LEZAMA
AV. MARTIN GARCIA E IRALA
111 NULL NULL 1111 13 24 CABA NULL NULL 11 36974042 NULL NULL 0 30 -‐3 3/1/11 -‐34.62802 -‐58.36985
10 OBELISCO 9 DE JULIO
1111 NULL NULL 111 13 24 CABA J. D. PERON
NULL 11 36974422 NULL NULL 0 34 17 11/1/11 -‐34.6063 -‐58.38105
11 PARQUE ROCA
CALLE 1 1 1 1 1111 13 24 CABA NULL NULL 11 43238115 NULL NULL 0 0 0 18/01/2011
NULL NULL
12 PARQUE DE LOS NIÑOS
CALLE 2 2 2 2 2222 13 24 CABA NULL NULL 11 43238115 NULL NULL 0 0 0 18/01/2011
NULL NULL
14 BICIS DE MUESTRA
PASEO COLON
1111 NULL NULL 1111 13 24 CABA NULL NULL 11 11111111 NULL NULL 0 0 -‐19 24/01/2011
NULL NULL
15 CONGRESO
VIRREY CEVALLOS E HIPOLITO YRIGOYEN
1111 NULL NULL 1111 13 24 CABA NULL NULL 11 40272143 NULL NULL 0 34 13 27/01/2011
-‐34.60983 -‐58.38929
16 PARQUE LAS HERAS
SOBRE CORONEL DIAZ ENTRE PEÑA Y FRENCH
1111 NULL NULL 1111 13 24 CABA NULL NULL 11 36974749 NULL NULL 0 0 48 10/2/11 -‐34.58503 -‐58.40764
17 UCA PUERTO MADERO
ALICIA MOREAU DE JUSTO
1111 NULL NULL 1111 13 24 CABA Y CHILE NULL 11 36974162 NULL NULL 0 60 21 25/02/2011
-‐34.61597 -‐58.36567
18 TRIBUNALES
TUCUMAN Y TALCAHUANO
600 NULL NULL 1002 13 24 CABA NULL NULL 11 40259663 NULL NULL 0 60 11 28/03/2011
-‐34.60134 -‐58.38501
19 PLAZA VICENTE LOPEZ
LAS HERAS
1111 NULL NULL 1111 13 24 CABA MONTEVIDEO
NULL 11 40273138 NULL NULL 0 40 11 27/04/2011
-‐34.59337 -‐58.3897
20 ONCE RIVADAVIA
111 NULL NULL 1111 13 24 CABA CATAMARCA
NULL 11 11111111 NULL NULL 0 20 29 21/05/2011
-‐34.60948 -‐58.40762
21 PACIFICO BULLRICH 1111 NULL NULL 1111 13 24 CABA SANTA FE NULL 11 11111111 NULL NULL 0 30 43 6/6/11 -‐34.57747 -‐58.42616
22 VIRREY CEVALLOS
VIRREY CEVALLOS
1111 NULL NULL 1111 13 24 CABA AV. SAN JUAN.
NULL 11 55859403 NULL NULL 0 35 3 15/06/2011
-‐34.62276 -‐58.38895
23 PLAZA HOUSSAY
CORDOBA 1111 NULL NULL 1111 13 24 CABA URIBURU JUNIN 11 40245236 NULL NULL 0 35 18 29/06/2011
-‐34.59902 -‐58.39822
24 PLAZA DE MAYO
DIAGONAL SUR
111 NULL NULL 1111 13 24 CABA PERU NULL 11 11111111 NULL NULL 0 40 6 3/8/11 -‐34.60992 -‐58.37472
25 PLAZA ALMAGRO
PERON 1111 NULL NULL 1111 13 24 CABA BULNES SALGUERO
11 11111111 NULL NULL 0 34 5 30/08/2011
-‐34.60593 -‐58.41948
26 CMD VILLARINO
2498 NULL NULL 1111 13 24 CABA NULL NULL 11 11111111 NULL NULL 0 34 16 6/9/11 -‐34.65429 -‐58.38043
27 INDEPENDENCIA
BERNARDO DE IRIGOYEN
111 NULL NULL 1111 13 24 CABA INDEPENDENCIA
NULL 1115 11111111 NULL NULL 0 34 13 16/09/2011
-‐34.61791 -‐58.38047
28 PLAZA SAN
AV.SANTA FE
111 NULL NULL 1111 13 24 CABA ESMERALDA
ARENALES 1115 11111111 NULL NULL 0 34 13 16/09/2011
-‐34.59496 -‐58.37828
Wednesday, August 8, 12
y así: <?xml version="1.0" encoding="ISO-8859-1" ?><current_observation>
<credit>NOAA's National Weather Service</credit><credit_URL>http://weather.gov/</credit_URL>
<image> <url>http://weather.gov/images/xml_logo.gif</url> <title>NOAA's National Weather Service</title> <link>http://weather.gov</link></image>
<location>New York/John F. Kennedy Intl Airport, NY</location><station_id>KJFK</station_id><latitude>40.66</latitude><longitude>-73.78</longitude><observation_time_rfc822>Mon, 11 Feb 2008 06:51:00 -0500 EST</observation_time_rfc822>
<weather>A Few Clouds</weather><temp_f>11</temp_f><temp_c>-12</temp_c><relative_humidity>36</relative_humidity><wind_dir>West</wind_dir><wind_degrees>280</wind_degrees><wind_mph>18.4</wind_mph><wind_gust_mph>29</wind_gust_mph><pressure_mb>1023.6</pressure_mb><pressure_in>30.23</pressure_in><dewpoint_f>-11</dewpoint_f><dewpoint_c>-24</dewpoint_c><windchill_f>-7</windchill_f><windchill_c>-22</windchill_c><visibility_mi>10.00</visibility_mi>
<icon_url_base>http://weather.gov/weather/images/fcicons/</icon_url_base><icon_url_name>nfew.jpg</icon_url_name><disclaimer_url>http://weather.gov/disclaimer.html</disclaimer_url><copyright_url>http://weather.gov/disclaimer.html</copyright_url>
</current_observation>
Wednesday, August 8, 12
datos abiertos: ¿Qué pasa, Riachuelo?
Wednesday, August 8, 12
datos cerrados: SIMAT
http://www.calidadaire.df.gob.mx/calidadaire
Wednesday, August 8, 12
datos abiertos: cirugías de corazón en Inglaterra
http://heartsurgery.cqc.org.uk
Wednesday, August 8, 12
datos abiertos: uso del metro
http://www.wmata.com/pdfs/planning/Historical%20Rail%20Ridership%20By%20Station.pdf
Wednesday, August 8, 12
datos abiertos: uso del metro
Wednesday, August 8, 12
datos abiertos: uso del metro
Wednesday, August 8, 12
¿por qué nos importan?
1. cuidar el medio ambiente
2. salvar vidas
3. mejorar el urbanismo
4. crear empleo
5. etc ....
Wednesday, August 8, 12
porque sólo cambiamos lo que vemos
Wednesday, August 8, 12
gracias
david sasaki
@oso
Wednesday, August 8, 12
