Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Liberation and modernization of legacy governme...

Avatar for Roberto Rosario Roberto Rosario
September 03, 2014
Programming
0
280

Liberation and modernization of legacy government data using Django

Avatar for Roberto Rosario

Roberto Rosario

September 03, 2014
Tweet

More Decks by Roberto Rosario

See All by Roberto Rosario
Geospatial three amigos: Python, Leaflet, and ElasticSearch
Avatar for Roberto Rosario siloraptor
1
490
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
Avatar for Roberto Rosario siloraptor
0
1.4k
Django tasty salad- DOs and DON'Ts using Celery
Avatar for Roberto Rosario siloraptor
0
880
Dockerizing Django projects
Avatar for Roberto Rosario siloraptor
0
240
An educational retro game using only Python? Challenge Accepted!
Avatar for Roberto Rosario siloraptor
0
150
Packaging Django Projects for PyPI
Avatar for Roberto Rosario siloraptor
1
590

Other Decks in Programming

See All in Programming
The Modern View Layer Rails Deserves: A Vision For 2025 And Beyond @ RailsConf 2025, Philadelphia, PA
Avatar for Marco Roth marcoroth
2
830
型で語るカタ
Avatar for irof irof
1
870
ソフトウェア設計とAI技術の活用
Avatar for 増田 亨 masuda220
PRO
25
6.9k
JetBrainsのAI機能の紹介 #jjug
Avatar for yusuke yusuke
0
130
AWS Summit Japan 2024と2025の比較／はじめてのKiro、今あなたは岐路に立つ
Avatar for Satoshi Kaneyasu satoshi256kbyte
1
260
リバースエンジニアリング新時代へ！
GhidraとClaude DesktopをMCPで繋ぐ/findy202507
Avatar for @tkmru tkmru
4
1.6k
No Install CMS戦略 〜 5年先を見据えたフロントエンド開発を考える / no_install_cms
Avatar for Masahiko Sakakibara rdlabo
0
380
プロダクトという一杯を作る - プロダクトチームが味の責任を持つまでの煮込み奮闘記
Avatar for 幡ヶ谷亭直吉 hiliteeternal
0
290
AIに安心して任せるためにTypeScriptで一意な型を作ろう
Avatar for Yuki Yata arfes0e2b3c
0
280
Jakarta EE Meets AI
Avatar for ivargrimstad ivargrimstad
0
420
The Evolution of Enterprise Java with Jakarta EE 11 and Beyond
Avatar for ivargrimstad ivargrimstad
0
570
MCPで実現できる、Webサービス利用体験について
Avatar for syumai syumai
7
2.2k

Featured

See All Featured
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
42
7.4k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
3.9k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
90
590k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
462
33k
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
379
70k
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
512
110k
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
29
2.8k
Designing for Performance
Avatar for Lara Hogan lara
610
69k
Designing Experiences People Love
Avatar for Jonathan Moore moore
142
24k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
31
8.7k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
96
6.1k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M

Transcript

  1. Liberation and modernization of legacy government data using Django Roberto

    Rosario Director of Information Technologies Cryptico Corp. [email protected] robertorosario.com

  2. http://CrypticoCorp.com

  3. None

  4. Who am I?

  5. Who am I? Liberation and modernization of legacy government data

    using Django

  6. How it all started Liberation and modernization of legacy government

    data using Django

  7. Original problem Liberation and modernization of legacy government data using

    Django

  8. Current “solution” Liberation and modernization of legacy government data using

    Django

  9. Liberation and modernization of legacy government data using Django

  10. Re-think the problem Liberation and modernization of legacy government data

    using Django

  11. Liberation and modernization of legacy government data using Django

  12. Result L.I.B.R.E. Large Information Batch Restructuring Engine Liberation and modernization

    of legacy government data using Django

  13. What it does Liberation and modernization of legacy government data

    using Django

  14. What it does Liberation and modernization of legacy government data

    using Django

  15. Turn this... Liberation and modernization of legacy government data using

    Django

  16. Into this! Liberation and modernization of legacy government data using

    Django

  17. This... Liberation and modernization of legacy government data using Django

  18. Into this! Liberation and modernization of legacy government data using

    Django

  19. For developers Liberation and modernization of legacy government data using

    Django

  20. For developers Liberation and modernization of legacy government data using

    Django

  21. I LIKE IT! Liberation and modernization of legacy government data

    using Django

  22. For administrators Liberation and modernization of legacy government data using

    Django

  23. For administrators Liberation and modernization of legacy government data using

    Django

  24. Liberation and modernization of legacy government data using Django

  25. Web services? Liberation and modernization of legacy government data using

    Django

  26. Web services?!?!?! Liberation and modernization of legacy government data using

    Django

  27. Liberation and modernization of legacy government data using Django

  28. Liberation and modernization of legacy government data using Django

  29. JSON Liberation and modernization of legacy government data using Django

  30. XML Liberation and modernization of legacy government data using Django

  31. Browseable API Liberation and modernization of legacy government data using

    Django

  32. Unified Query Language? Liberation and modernization of legacy government data

    using Django

  33. Liberation and modernization of legacy government data using Django

  34. Liberation and modernization of legacy government data using Django

  35. Liberation and modernization of legacy government data using Django What

    could go wrong?

  36. SQL == Structured Query Language Liberation and modernization of legacy

    government data using Django

  37. SQL != Standard Query Language Liberation and modernization of legacy

    government data using Django

  38. https://stackoverflow.com/questions/1528604/how-universal-is-the-limit-statement-in-sql Liberation and modernization of legacy government data using Django

  39. https://libre.readthedocs.org/en/latest/topics/LQL.html LQL (LIBRE Query Language) Liberation and modernization of legacy

    government data using Django

  40. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  41. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  42. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  43. LQL (LIBRE Query Language) + Liberation and modernization of legacy

    government data using Django

  44. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  45. 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

  46. 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

  47. 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

  48. 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

  49. 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

  50. 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

  51. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  52. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  53. 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

  54. LQL (LIBRE Query Language) Liberation and modernization of legacy government

    data using Django

  55. 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

  56. How it works Liberation and modernization of legacy government data

    using Django

  57. How it works Liberation and modernization of legacy government data

    using Django

  58. How it works Liberation and modernization of legacy government data

    using Django

  59. Next level Liberation and modernization of legacy government data using

    Django

  60. Real world examples Liberation and modernization of legacy government data

    using Django

  61. Next level Liberation and modernization of legacy government data using

    Django

  62. Next level Liberation and modernization of legacy government data using

    Django

  63. Next level Liberation and modernization of legacy government data using

    Django

  64. Real world examples Liberation and modernization of legacy government data

    using Django

  65. Real world examples Liberation and modernization of legacy government data

    using Django

  66. Real world examples Liberation and modernization of legacy government data

    using Django

  67. Real world examples Liberation and modernization of legacy government data

    using Django

  68. Real world examples Liberation and modernization of legacy government data

    using Django

  69. Real world examples http://www.geo-tire.com/ Liberation and modernization of legacy government

    data using Django

  70. Real world examples Liberation and modernization of legacy government data

    using Django

  71. Real world examples Liberation and modernization of legacy government data

    using Django

  72. Real world examples Liberation and modernization of legacy government data

    using Django

  73. Real world examples Liberation and modernization of legacy government data

    using Django

  74. Next level http://www.elnuevodia.com/XStatic/endi/template/content.aspx?id=1763058&se=nota Liberation and modernization of legacy government data

    using Django

  75. Demos Liberation and modernization of legacy government data using Django

  76. Questions? Liberation and modernization of legacy government data using Django

  77. Thank you! @siloraptor robertorosario.com [email protected] http://bit.ly/django-open-data Liberation and modernization of

    legacy government data using Django