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 governme...
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
Roberto Rosario
September 03, 2014
Programming
0
300
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
510
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
siloraptor
0
1.6k
Django tasty salad- DOs and DON'Ts using Celery
siloraptor
0
930
Dockerizing Django projects
siloraptor
0
260
An educational retro game using only Python? Challenge Accepted!
siloraptor
0
160
Packaging Django Projects for PyPI
siloraptor
1
660
Other Decks in Programming
See All in Programming
おれのAgentic Coding 2026/03
tsukasagr
1
120
存在論的プログラミング: 時間と存在を記述する
koriym
5
560
条件判定に名前、つけてますか? #phperkaigi #c
77web
2
860
テレメトリーシグナルが導くパフォーマンス最適化 / Performance Optimization Driven by Telemetry Signals
seike460
PRO
2
190
AI活用のコスパを最大化する方法
ochtum
0
350
どんと来い、データベース信頼性エンジニアリング / Introduction to DBRE
nnaka2992
1
340
Codex CLI でつくる、Issue から merge までの開発フロー
amata1219
0
240
車輪の再発明をしよう!PHP で実装して学ぶ、Web サーバーの仕組みと HTTP の正体
h1r0
2
440
20260313 - Grafana & Friends Taipei #1 - Kubernetes v1.36 的開發雜記:那些困在 Alpha 加護病房太久的 Metrics
tico88612
0
240
AI Assistants for YourAngular Solutions @Angular Graz, March 2026
manfredsteyer
PRO
0
120
Rethinking API Platform Filters
vinceamstoutz
0
2.8k
Tamach-sre-3_ANDPAD-shimaison93
mane12yurks38
0
170
Featured
See All Featured
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
madoxten
62
53k
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
uxyall
0
880
Tips & Tricks on How to Get Your First Job In Tech
honzajavorek
0
470
Rebuilding a faster, lazier Slack
samanthasiow
85
9.4k
Mind Mapping
helmedeiros
PRO
1
130
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
35
3.4k
16th Malabo Montpellier Forum Presentation
akademiya2063
PRO
0
83
Navigating the Design Leadership Dip - Product Design Week Design Leaders+ Conference 2024
apolaine
0
250
BBQ
matthewcrist
89
10k
GraphQLの誤解/rethinking-graphql
sonatard
75
12k
More Than Pixels: Becoming A User Experience Designer
marktimemedia
3
360
The AI Search Optimization Roadmap by Aleyda Solis
aleyda
1
5.5k
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