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.4k
Django tasty salad- DOs and DON'Ts using Celery
siloraptor
0
890
Dockerizing Django projects
siloraptor
0
240
An educational retro game using only Python? Challenge Accepted!
siloraptor
0
150
Packaging Django Projects for PyPI
siloraptor
1
600
Other Decks in Programming
See All in Programming
tool ディレクティブを導入してみた感想
sgash708
1
120
What's new in Adaptive Android development
fornewid
0
140
LLMは麻雀を知らなすぎるから俺が教育してやる
po3rin
3
2.1k
それ CLI フレームワークがなくてもできるよ / Building CLI Tools Without Frameworks
orgachem
PRO
17
3.9k
サイトを作ったらNFCタグキーホルダーを爆速で作れ!
yuukis
0
350
DataformでPythonする / dataform-de-python
snhryt
0
170
JetBrainsのAI機能の紹介 #jjug
yusuke
0
200
マイコンでもRustのtestがしたい その2/KernelVM Tokyo 18
tnishinaga
2
2.3k
0から始めるモジュラーモノリス-クリーンなモノリスを目指して
sushi0120
1
280
WebAssemblyインタプリタを書く ~Component Modelを添えて~
ruccho
1
830
STUNMESH-go: Wireguard NAT穿隧工具的源起與介紹
tjjh89017
0
370
エンジニアのための”最低限いい感じ”デザイン入門
shunshobon
0
110
Featured
See All Featured
GraphQLの誤解/rethinking-graphql
sonatard
71
11k
Why You Should Never Use an ORM
jnunemaker
PRO
58
9.5k
Code Reviewing Like a Champion
maltzj
525
40k
Git: the NoSQL Database
bkeepers
PRO
431
65k
A Tale of Four Properties
chriscoyier
160
23k
The Cult of Friendly URLs
andyhume
79
6.5k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.8k
Building an army of robots
kneath
306
45k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
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