Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Liberation and modernization of legacy government data using Django
Search
Roberto Rosario
September 03, 2014
Programming
0
260
Liberation and modernization of legacy government data using Django
Roberto Rosario
September 03, 2014
Tweet
Share
More Decks by Roberto Rosario
See All by Roberto Rosario
Geospatial three amigos: Python, Leaflet, and ElasticSearch
siloraptor
1
420
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
siloraptor
0
1.1k
Django tasty salad- DOs and DON'Ts using Celery
siloraptor
0
620
Dockerizing Django projects
siloraptor
0
200
An educational retro game using only Python? Challenge Accepted!
siloraptor
0
120
Packaging Django Projects for PyPI
siloraptor
1
390
Other Decks in Programming
See All in Programming
Folding Cheat Sheet #3
philipschwarz
PRO
0
110
ドメイン・ファーストで考える問題解決に役立つモデル設計 / Domain First Model Design
suzushin54
2
2.1k
Ruby製社内ツールのGo移行
bgpat
2
330
Elm Form Validation
bkuhlmann
0
500
1BRC--Nerd Sniping the Java Community
gunnarmorling
0
300
DMMプラットフォームがTiDB Cloudを採用した背景
pospome
8
3.5k
CircleCIを活用して AWSへの継続的デリバリーを 実践する
coconala_engineer
1
230
脱・初心者!脱・マネコン!AWS CDKを使ってみませんか!?
har1101
0
300
Javaエンジニアのための Nodejs/Nuxt3入門
hidekatsu_izuno
0
280
Designing for tomorrow's programming workflows
honnibal
PRO
2
110
Prepare for Jakarta EE 11 - Performance and Developer Productivity
ivargrimstad
0
430
Git Rebase
bkuhlmann
11
1.6k
Featured
See All Featured
The Art of Programming - Codeland 2020
erikaheidi
41
12k
GraphQLとの向き合い方2022年版
quramy
31
12k
The MySQL Ecosystem @ GitHub 2015
samlambert
242
12k
Building an army of robots
kneath
300
41k
Building a Scalable Design System with Sketch
lauravandoore
455
32k
Gamification - CAS2011
davidbonilla
76
4.6k
Infographics Made Easy
chrislema
237
18k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
356
22k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
18
6.9k
Into the Great Unknown - MozCon
thekraken
10
980
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
24
2.3k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
273
13k
Transcript
Liberation and modernization of legacy government data using Django Roberto
Rosario Director of Information Technologies Cryptico Corp.
[email protected]
robertorosario.com
http://CrypticoCorp.com
None
Who am I?
Who am I? Liberation and modernization of legacy government data
using Django
How it all started Liberation and modernization of legacy government
data using Django
Original problem Liberation and modernization of legacy government data using
Django
Current “solution” Liberation and modernization of legacy government data using
Django
Liberation and modernization of legacy government data using Django
Re-think the problem Liberation and modernization of legacy government data
using Django
Liberation and modernization of legacy government data using Django
Result L.I.B.R.E. Large Information Batch Restructuring Engine Liberation and modernization
of legacy government data using Django
What it does Liberation and modernization of legacy government data
using Django
What it does Liberation and modernization of legacy government data
using Django
Turn this... Liberation and modernization of legacy government data using
Django
Into this! Liberation and modernization of legacy government data using
Django
This... Liberation and modernization of legacy government data using Django
Into this! Liberation and modernization of legacy government data using
Django
For developers Liberation and modernization of legacy government data using
Django
For developers Liberation and modernization of legacy government data using
Django
I LIKE IT! Liberation and modernization of legacy government data
using Django
For administrators Liberation and modernization of legacy government data using
Django
For administrators Liberation and modernization of legacy government data using
Django
Liberation and modernization of legacy government data using Django
Web services? Liberation and modernization of legacy government data using
Django
Web services?!?!?! Liberation and modernization of legacy government data using
Django
Liberation and modernization of legacy government data using Django
Liberation and modernization of legacy government data using Django
JSON Liberation and modernization of legacy government data using Django
XML Liberation and modernization of legacy government data using Django
Browseable API Liberation and modernization of legacy government data using
Django
Unified Query Language? Liberation and modernization of legacy government data
using Django
Liberation and modernization of legacy government data using Django
Liberation and modernization of legacy government data using Django
Liberation and modernization of legacy government data using Django What
could go wrong?
SQL == Structured Query Language Liberation and modernization of legacy
government data using Django
SQL != Standard Query Language Liberation and modernization of legacy
government data using Django
https://stackoverflow.com/questions/1528604/how-universal-is-the-limit-statement-in-sql Liberation and modernization of legacy government data using Django
https://libre.readthedocs.org/en/latest/topics/LQL.html LQL (LIBRE Query Language) Liberation and modernization of legacy
government data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) + Liberation and modernization of legacy
government data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/? geometry__within=Geometry<generic-city- limits&properties.Municipio=”Arecibo”&_json_path=[0]. geometry>)&_renderer__geometry=Geometry (<generic-city-limits&properties.Municipio=”Arecibo” &_json_path=[0].geometry>)&_format=map_leaflet
Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/ geometry__within=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry >) _renderer__geometry=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry
>) _format=map_leaflet Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/ geometry__within=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry >) _renderer__geometry=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry
>) _format=map_leaflet Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/ geometry__within=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry >) _renderer__geometry=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry
>) _format=map_leaflet Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/ geometry__within=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry >) _renderer__geometry=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry
>) _format=map_leaflet Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/ geometry__within=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry >) _renderer__geometry=Geometry(< generic-city-limits&properties.Municipio=”Arecibo”&_json_path=[0].geometry
>) _format=map_leaflet Liberation and modernization of legacy government data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/? geometry__within=Point([-66.6837945358,18.3852]).buffer(0.1) _renderer__geometry=Point([-66.6837945358,18.3852]).buffer (0.1) _format=map_leaflet Liberation
and modernization of legacy government data using Django
LQL (LIBRE Query Language) Liberation and modernization of legacy government
data using Django
LQL (LIBRE Query Language) http://libre.pr.gov/api/sources/police-crimes/data/? geometry__within=Polygon([[-66.1928,18.4269], [-66.1175,18.4269],[-66.1175,18.4182],[-66.1928,18.4182]]) _renderer__geometry=Polygon([[-66.1928,18.4269], [-66.1175,18.4269],[-66.1175,18.4100],[-66.1928,18.4100]]) _format=map_leaflet
Liberation and modernization of legacy government data using Django
How it works Liberation and modernization of legacy government data
using Django
How it works Liberation and modernization of legacy government data
using Django
How it works Liberation and modernization of legacy government data
using Django
Next level Liberation and modernization of legacy government data using
Django
Real world examples Liberation and modernization of legacy government data
using Django
Next level Liberation and modernization of legacy government data using
Django
Next level Liberation and modernization of legacy government data using
Django
Next level Liberation and modernization of legacy government data using
Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples http://www.geo-tire.com/ Liberation and modernization of legacy government
data using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Real world examples Liberation and modernization of legacy government data
using Django
Next level http://www.elnuevodia.com/XStatic/endi/template/content.aspx?id=1763058&se=nota Liberation and modernization of legacy government data
using Django
Demos Liberation and modernization of legacy government data using Django
Questions? Liberation and modernization of legacy government data using Django
Thank you! @siloraptor robertorosario.com
[email protected]
http://bit.ly/django-open-data Liberation and modernization of
legacy government data using Django