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
Roberto Rosario
September 03, 2014
Programming
0
290
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
490
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
siloraptor
0
1.5k
Django tasty salad- DOs and DON'Ts using Celery
siloraptor
0
900
Dockerizing Django projects
siloraptor
0
250
An educational retro game using only Python? Challenge Accepted!
siloraptor
0
150
Packaging Django Projects for PyPI
siloraptor
1
610
Other Decks in Programming
See All in Programming
Web フロントエンドエンジニアに開かれる AI Agent プロダクト開発 - Vercel AI SDK を観察して AI Agent と仲良くなろう! #FEC余熱NIGHT
izumin5210
3
390
非同期jobをtransaction内で 呼ぶなよ!絶対に呼ぶなよ!
alstrocrack
0
520
フロントエンド開発に役立つクライアントプログラム共通のノウハウ / Universal client-side programming best practices for frontend development
nrslib
7
3.9k
iOS 17で追加されたSubscriptionStoreView を利用して5分でサブスク実装チャレンジ
natmark
0
590
CSC509 Lecture 03
javiergs
PRO
0
330
Swift Concurrency - 状態監視の罠
objectiveaudio
2
450
私はどうやって技術力を上げたのか
yusukebe
43
17k
ててべんす独演会〜Flowの全てを語ります〜
tbsten
1
220
CSC509 Lecture 04
javiergs
PRO
0
290
『毎日の移動』を支えるGoバックエンド内製開発
yutautsugi
2
180
Catch Up: Go Style Guide Update
andpad
0
170
育てるアーキテクチャ:戦い抜くPythonマイクロサービスの設計と進化戦略
fujidomoe
1
150
Featured
See All Featured
Automating Front-end Workflow
addyosmani
1371
200k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
KATA
mclloyd
32
15k
How to Think Like a Performance Engineer
csswizardry
27
2k
[RailsConf 2023] Rails as a piece of cake
palkan
57
5.9k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
Rebuilding a faster, lazier Slack
samanthasiow
84
9.2k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
48
9.7k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
252
21k
It's Worth the Effort
3n
187
28k
Producing Creativity
orderedlist
PRO
347
40k
Reflections from 52 weeks, 52 projects
jeffersonlam
352
21k
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