Aclaración anti-boludos: si van a hacer escándalo, asegúrense de no estar diciendo cualquier cosa. Chequeen contra los telegramas publicados en resultados.gob.ar
Copyright (C) 2012-2013 Manuel Aristarán jazzido@jazzido.com
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:
The above copyright notice and this permission notice shall be included in all
Los datasets con información geográfica publicados en http://datos.gba.gob.ar están formato CSV. Para poder usarlos hace falta convertirlos a un formato apropiado. Tomando como ejemplo el dataset Recorrido de colectivos de líneas provinciales:
-
Renombrar el CSV al nombre
cole.csv
. -
Crear un archivo
input.vrt
con este contenido<OGRVRTDataSource>
I hereby claim:
- I am jazzido on github.
- I am manuelaristaran (https://keybase.io/manuelaristaran) on keybase.
- I have a public key whose fingerprint is 2794 80C8 5BE6 4EC6 4236 A76B 3AE4 55E9 7D81 3620
To claim this, I am signing this object:
# -*- coding: utf-8 -*- | |
# very old (1999?) code for syllabification of spanish words | |
# based on this thesis: http://www.fismat.umich.mx/~karina/tesisLicenciatura/capitulo2.html | |
# Author: Manuel Aristarán (jazzido.com) | |
# License: Creative Commons Atribución 2.5 Argentina -- http://creativecommons.org/licenses/by/2.5/ar/ | |
# usage: determina_caso('cadena de entrada') | |
vocales = u'aeiouyáéíóúÁÉÍÓÚAEIOUY' |
WITH votos_summary AS | |
(SELECT ve.mesa_desde, | |
ve.mesa_hasta, | |
SUM(total) AS total_parcodigo, | |
ve.vot_parcodigo, | |
ve.dne_distri, | |
ve.dne_seccio, | |
row_number() over(partition BY ve.mesa_desde,ve.mesa_hasta | |
ORDER BY sum(total) DESC) AS rk | |
FROM votos_establecimiento_octubre ve |