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

Liberation and modernization of legacy governme...

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Roberto Rosario Roberto Rosario
September 03, 2014
Programming
300
0

Liberation and modernization of legacy government data using Django

Avatar for Roberto Rosario

Roberto Rosario

September 03, 2014

More Decks by Roberto Rosario

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

Other Decks in Programming

See All in Programming
夢の無限スパゲッティ製造機 -実装篇- #phpstudy
Avatar for hideki kinjyo o0h
PRO
0
210
How We Benchmarked Quarkus: Patterns and anti-patterns
Avatar for Holly Cummins hollycummins
1
140
Running Swift without an OS
Avatar for Kishikawa Katsumi kishikawakatsumi
0
840
ふりがな Deep Dive try! Swift Tokyo 2026
Avatar for watura watura
0
210
「Linuxサーバー構築標準教科書」を読んでみた #ツナギメオフライン.7
Avatar for akase244 akase244
0
1.4k
LM Linkで(非力な！)ノートPCでローカルLLM
Avatar for 瀬尾佳隆 seosoft
0
490
The Monolith Strikes Back: Why AI Agents ❤️ Rails Monoliths
Avatar for Rodrigo Serradura serradura
0
330
3分でわかるatama plusのQA/about atama plus QA
Avatar for atama plus atamaplus
0
170
実用！Hono RPC2026
Avatar for yodaka yodaka
2
210
tRPCの概要と少しだけパフォーマンス
Avatar for Keigo Ebihara misoton665
2
200
2026_04_15_量子計算をパズルとして解く
Avatar for HideakiTakechi hideakitakechi
0
100
Vibe하게 만드는 Flutter GenUI App With ADK , 박제창, BWAI Incheon 2026
Avatar for JaiChangPark itsmedreamwalker
0
550

Featured

See All Featured
A Guide to Academic Writing Using Generative AI - A Workshop
Avatar for Kenji Saito ks91
PRO
1
270
Reflections from 52 weeks, 52 projects
Avatar for Jefferson Lam jeffersonlam
356
21k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
730
Navigating the Design Leadership Dip - Product Design Week Design Leaders+ Conference 2024
Avatar for Andy Polaine apolaine
0
270
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1032
470k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
Kristin Tynski - Automating Marketing Tasks With AI
Avatar for Tech SEO Connect techseoconnect
PRO
0
220
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
2
1.7k
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
1
110
Believing is Seeing
Avatar for Spiro Bolos oripsolob
1
110
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
740

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