Canadensys_canadensys-explorer.sql

UPDATE occurrence SET the_geom_webmercator = st_transform_null WHERE the_geom IS NOT NULL
UPDATE occurrence SET the_geom = st_geometryfromtext WHERE decimallatitude IS NOT NULL AND decimallongitude IS NOT NULL
SELECT * FROM {{table_name}}",opacity:1,auto_bound:false,debug:false,visible:true,layer_order:"top",tiler_domain:"cartodb.com",tiler_port:"80",tiler_protocol:"http",sql_domain:"cartodb.com",sql_port:"80",sql_protocol:"http"};this.options=this._extend({},this.options,options);if(!this.options.table_name||!this.options.map){if(this.options.debug){throw ("cartodb-gmapsv3 needs at least a CartoDB table name and the gmapsv3 map object :(")}else{return}}this.initialize();this.setMap(options.map)}CartoDBLayer.prototype.extend=function(obj1,obj2){return(function(object){for(var property in object.prototype){this.prototype[property]=object.prototype[property]}return this}).apply(obj1,[obj2])};CartoDBLayer.prototype.initialize=function(){if(this.options.auto_bound){this.setBounds()}if(this.options.map_style){this._setMapStyle()}this._addWadus()};CartoDBLayer.prototype.draw=function(){};CartoDBLayer.prototype.onAdd=function(map){this._addInteraction()};CartoDBLayer.prototype.onRemove=function(ma