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

Liberation and modernization of legacy governme...

Roberto Rosario
September 03, 2014
Programming
0
280

Liberation and modernization of legacy government data using Django

Roberto Rosario

September 03, 2014
Tweet

More Decks by Roberto Rosario

See All by Roberto Rosario
Geospatial three amigos: Python, Leaflet, and ElasticSearch
siloraptor
1
460
OpenHolter project: D.I.Y. Electrocardiography using Arduino and Django
siloraptor
0
1.3k
Django tasty salad- DOs and DON'Ts using Celery
siloraptor
0
800
Dockerizing Django projects
siloraptor
0
230
An educational retro game using only Python? Challenge Accepted!
siloraptor
0
140
Packaging Django Projects for PyPI
siloraptor
1
530

Other Decks in Programming

See All in Programming
クリーンアーキテクチャから見る依存の向きの大切さ
shimabox
2
350
Open source software: how to live long and go far
gaelvaroquaux
0
630
AIの力でお手軽Chrome拡張機能作り
taiseiue
0
170
データの整合性を保つ非同期処理アーキテクチャパターン / Async Architecture Patterns
mokuo
47
17k
第3回 Snowflake 中部ユーザ会 - dbt × Snowflake ハンズオン
hoto17296
4
370
2,500万ユーザーを支えるSREチームの6年間のスクラムのカイゼン
honmarkhunt
6
5.3k
DROBEの生成AI活用事例 with AWS
ippey
0
130
Immutable ActiveRecord
megane42
0
140
社内フレームワークとその依存性解決 / in-house framework and its dependency management
vvakame
1
560
sappoRo.R #12 初心者セッション
kosugitti
0
250
昭和の職場からアジャイルの世界へ
kumagoro95
1
380
『テスト書いた方が開発が早いじゃん』を解き明かす #phpcon_nagoya
o0h
PRO
2
260

Featured

See All Featured
Documentation Writing (for coders)
carmenintech
67
4.6k
Fontdeck: Realign not Redesign
paulrobertlloyd
83
5.4k
YesSQL, Process and Tooling at Scale
rocio
172
14k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
6
550
Being A Developer After 40
akosma
89
590k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
4
410
ReactJS: Keep Simple. Everything can be a component!
pedronauck
666
120k
Code Review Best Practice
trishagee
67
18k
Docker and Python
trallard
44
3.3k
RailsConf 2023
tenderlove
29
1k
Producing Creativity
orderedlist
PRO
344
39k
Rebuilding a faster, lazier Slack
samanthasiow
80
8.8k

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