Once the function has been created, the trigger must be created like this (assuming the geometry column is called the_geom:
This script reads a table fom CartoDB using the SQL API, geocodes one of its fields using Google's geocoder and updates the data on CartoDB.
If no valid credentials are provided for Google's geocoder, the free limits will apply.
TODO: multithread support
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no"> | |
| <title>Torque category selector</title> | |
| <link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.14/themes/css/cartodb.css" /> | |
| <style type="cartocss/text" id="cartocss"> | |
| Map { |
| #!/bin/bash | |
| # | |
| # startpy: starts/stops a python script, storing its PID in /var/run, | |
| # so that it can be run from monit | |
| # | |
| # Scripts must be placed in a folder under /home/sm/scripts. Startpy | |
| # will look in that folder for a script named after the folder (plus | |
| # .py extension). | |
| # | |
| # (In the following example we'll assume a script test.py exists in |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <!-- See Javier Arce's original for Leaflet: http://bl.ocks.org/javierarce/e7ec4b39013aa03ebd5e --> | |
| <title>Map with image overlay | CartoDB.js</title> | |
| <meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> | |
| <meta http-equiv="content-type" content="text/html; charset=UTF-8"/> | |
| <link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" /> | |
| <style> | |
| html, body, #map { |
| [cartodb] | |
| account_name= | |
| api_key= | |
| table_name= | |
| columns= | |
| [file] | |
| name= |
| <!doctype html> | |
| <html lang="en-us"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no"> | |
| <title>CARTO + Tangram + MVT example</title> | |
| <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.0.0-rc.3/leaflet.css" /> | |
| <style> |
| <!doctype html> | |
| <!-- | |
| Tangram: real-time WebGL rendering for OpenStreetMap | |
| http://github.com/tangrams/tangram | |
| http://mapzen.com | |
| --> | |
| <html lang="en-us"> | |
| <head> | |
| <meta charset="utf-8"> |
| <!doctype html> | |
| <html lang="en-us"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no"> | |
| <title>CARTO + Openlayers + MVT example</title> | |
| <link rel="stylesheet" href="https://openlayers.org/en/v3.18.2/css/ol.css" type="text/css" /> | |
| <script src="https://openlayers.org/en/v3.18.2/build/ol.js"></script> |
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" /> | |
| <script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script> | |
| <title>Password-protected named map example</title> | |
| </head> | |
| <body> | |
| <div id="map" style="height: 500px"></div> |