Una cuenta trial de CARTO. Todos los datos usados en este taller están disponibles en abierto dentro de la plataforma.
Vamos a utilizar CARTO en este taller y el motor de base de datos que lo respalda es BigQuery, así que el código SQL hace uso de las funciones y eventuales peculiaridades de dicho motor y de las extensiones de CARTO.
| #!/bin/zsh | |
| autoload colors && colors | |
| echo '' | |
| echo $fg_bold[magenta] 'Let`s update everything...'$reset_color | |
| echo '' | |
| echo $fg_no_bold[green] '1. Snap'$reset_color | |
| if ! command -v snap &> /dev/null | |
| then | |
| echo $fg_no_bold[yellow] 'There`s no app installed via Snap'$reset_color | |
| else |
Lets say you need to refresh your tiles every X seconds to render live information, let's make use of Custom Protocos support.
Let's say your tiles are timestamped using epoc, and the endpoint reacts to URI params like this example
https://example.com/12/2005/1545.pbf?timestamp=1628597308254
Then you just
| #!/bin/zsh | |
| autoload colors && colors | |
| echo '' | |
| echo $fg_bold[magenta] 'Let`s free some disk space...'$reset_color | |
| echo '' | |
| echo $fg_no_bold[green] '1. journal space'$reset_color | |
| journalctl --disk-usage | |
| echo '' | |
| sudo journalctl --rotate | |
| echo '' |
| The MIT License (MIT) | |
| Copyright (c) 2018 Abel Vázquez Montoro | |
| Permission is hereby granted, free of charge, to any person obtaining a copy | |
| of this software and associated documentation files (the "Software"), to deal | |
| in the Software without restriction, including without limitation the rights | |
| to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
| copies of the Software, and to permit persons to whom the Software is | |
| furnished to do so, subject to the following conditions: |
| WITH | |
| input_query as( | |
| SELECT | |
| * | |
| FROM airports | |
| order by cartodb_id asc | |
| limit 1000 | |
| ), | |
| moran as( | |
| SELECT |
| WITH point1 AS ( | |
| SELECT cdb_geocode_postalcode_point(<%= postcode1 %>, 'USA') as geo | |
| ), | |
| point2 AS ( | |
| SELECT cdb_geocode_postalcode_point(<%= postcode2 %>, 'USA') as geo | |
| ), | |
| route AS ( | |
| SELECT | |
| r.shape as geo, | |
| r.length |