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

Liberation and modernization of legacy governme...

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Roberto Rosario Roberto Rosario
September 03, 2014
Programming
310
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
940
Dockerizing Django projects
Avatar for Roberto Rosario siloraptor
0
270
An educational retro game using only Python? Challenge Accepted!
Avatar for Roberto Rosario siloraptor
0
170
Packaging Django Projects for PyPI
Avatar for Roberto Rosario siloraptor
1
660

Other Decks in Programming

See All in Programming
iOS26時代の新規アプリ開発
Avatar for 野瀬田　裕樹 yuukiw00w
0
140
要はバランスからの卒業 #yumemi_grow
Avatar for Takuma Kajikawa kajitack
0
170
【ディップ｜26年新卒研修資料】OpenAPI/Swagger REST API研修
Avatar for ディップ株式会社 dip_tech
PRO
0
170
開発体験を左右するライブラリの API 設計 - GraphQL スキーマ構築ライブラリから考える #tskaigi
Avatar for izumin5210 izumin5210
1
210
Structured Concurrency, Scoped Values and Joiners in the JDK 25 26 27
Avatar for José josepaumard
1
150
Cloudflare で始める Data Platform
Avatar for Takumi Abe ta93abe
0
190
横断組織出身のQAEがインプロセスQAEでつまずいたこと・活かせたこと
Avatar for Taiki Yamashita ty89
0
150
AI駆動開発勉強会 広島支部 第一回勉強会 AI駆動開発概要とワークショップ
Avatar for smz hyt hayatoshimiu
0
200
tsserverとは何だったのか_これからどうなるのか
Avatar for Ryota Nakamura nowaki28
0
210
AIを導入する前にやるべきこと
Avatar for Negima negima
2
370
PHPでローカル環境用のSSL/TLS証明書を発行することはできるのか？ #phpconkagawa
Avatar for akase244 akase244
0
370
Hive Metastoreを通して学ぶIceberg REST Catalog ― 仕様から実装まで
Avatar for okumin okumin
0
160

Featured

See All Featured
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
Avatar for soudai sone soudai
PRO
65
54k
Technical Leadership for Architectural Decision Making
Avatar for Kenny Baas-Schwegler baasie
3
370
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
3.4k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.4k
Getting science done with accelerated Python computing platforms
Avatar for Jacob Tomlinson jacobtomlinson
2
200
The Impact of AI in SEO - AI Overviews June 2024 Edition
Avatar for Aleyda Solis aleyda
5
1.1k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.5k
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
370
20k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
810
The Language of Interfaces
Avatar for Des Traynor destraynor
162
26k

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