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
320
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
520
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
Avatar for Roberto Rosario siloraptor
0
1.7k
Django tasty salad- DOs and DON'Ts using Celery
Avatar for Roberto Rosario siloraptor
0
950
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
Welcome to the "Parametricity" 🏙️ − Generic だけど Specific な世界 −
Avatar for TAKASE Kazuyuki guvalif
PRO
1
200
JAWS-UG横浜 #102 AWSサ終供養LT会 成仏できない AWS サービスたち 〜本日、三体供養します〜
Avatar for maroon1st maroon1st
0
300
言語を使う側から、作る側へ。 自作 Lisp で得た新たな気づき。
Avatar for ANDPAD inc andpad
0
140
属人化した知識を、 AIが辿れる地図にする
Avatar for PKSHA Technology（パークシャテクノロジー） pkshadeck
PRO
1
130
継続モナドとリアクティブプログラミング
Avatar for ゆきくらげ yukikurage
3
670
テーブルをDELETEした
Avatar for yuzneri yuzneri
0
130
作るコストが小さくなった時代 幸せに働くために改めて考えたいこと 〜エンジニアとして価値を出し続けるために注視している二分野〜
Avatar for YuppeEng yuppeeng
0
180
メールのエイリアス機能を履き違えない
Avatar for 船長（せんちょう） isshinfunada
0
210
全PRの83%がAIレビューだけでマージできるようになった開発組織はその後どうなったか
Avatar for a-thug athug
1
1.2k
<title><a id="</title>君はこのHTMLをパースできるか"></a></title> #雑LT_study
Avatar for pizzacat83 pizzacat83
0
130
今さら聞けない .NET CLI
Avatar for tkym htkym
0
170
音楽のための関数型プログラミング言語mimiumにおける多段階計算の活用
Avatar for Tomoya Matsuura tomoyanonymous
1
380

Featured

See All Featured
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
2
240
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
7k
Design of three-dimensional binary manipulators for pick-and-place task avoiding obstacles (IECON2024)
Avatar for konakalab konakalab
0
500
Impact Scores and Hybrid Strategies: The future of link building
Avatar for Tamara Novitovic tamaranovitovic
0
350
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
333
25k
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
4.2M
From π to Pie charts
Avatar for Rasagy Sharma rasagy
0
240
The Illustrated Children's Guide to Kubernetes
Avatar for Chris Short chrisshort
51
53k
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1.1k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
430
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.4k
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
Avatar for Christian Goodrich cargoodrich
3
760

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