Skip to content

Instantly share code, notes, and snippets.

View alasarr's full-sized avatar

Alberto Asuero alasarr

View GitHub Profile
@alasarr
alasarr / index.html
Last active August 23, 2017 14:30
CARTO template
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<link rel="stylesheet" href="main.css" />
@alasarr
alasarr / index.html
Last active August 28, 2017 12:22
Postal codes
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Postal Codes</title>
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<link rel="stylesheet" href="main.css" />
@alasarr
alasarr / index.html
Created August 28, 2017 14:37
Valencia hexagon grid
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Postal Codes</title>
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<link rel="stylesheet" href="main.css" />
@alasarr
alasarr / curl.sh
Last active September 15, 2017 17:21
Topology exception isolines
curl -d @data.json -X POST https://posterscope-admin.carto.com/api/v2/sql --header "Content-Type:application/json"
@alasarr
alasarr / index.html
Created November 23, 2017 21:53
Salesquest Iframe sample
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Sample Iframe</title>
<style>
body,iframe,html{
width:100%;
@alasarr
alasarr / batch.py
Last active December 5, 2017 08:37
CARTO Batch API sample
from longitude.models.cartomodel import CartoModel
from longitude.config import cfg
cfg['CARTO_USER'] = 'XXX'
cfg['CARTO_API_KEY'] = 'XXXX'
cm = CartoModel()
q = '''
select pg_sleep(10)
'''
@alasarr
alasarr / index.html
Last active January 11, 2018 07:45
Manhattan 3D building extrusion
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8' />
<title>MapboxGL CARTO Building</title>
<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.40.1/mapbox-gl.js'></script>
<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.40.1/mapbox-gl.css' rel='stylesheet' />
<script src='https://cdnjs.cloudflare.com/ajax/libs/nanoajax/0.4.3/nanoajax.min.js'></script>
<style>
@alasarr
alasarr / index.html
Created January 11, 2018 07:45
Manhattan 3D building filling
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8' />
<title>MapboxGL CARTO Building</title>
<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.40.1/mapbox-gl.js'></script>
<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.40.1/mapbox-gl.css' rel='stylesheet' />
<script src='https://cdnjs.cloudflare.com/ajax/libs/nanoajax/0.4.3/nanoajax.min.js'></script>
<style>
@alasarr
alasarr / deploy.sh
Created April 24, 2018 11:52
Easy script to deploy a website in Google Cloud. It's optimized for Angular or any other HTML 5 application who manages URLs
#!/bin/bash
# CNAME -> c.storage.googleapis.com
bad_usage(){
echo 'Bad parameters:'
echo "Usage: $0 <init|update> <domain> <folder_to_upload>"
exit 1
}
init(){
@alasarr
alasarr / copyfrom.py
Created July 28, 2018 07:54
COPY from CARTO
# create table trans_amt_rank_201805(
# region_type text,
# region_id text,
# month text
# industry_code text,
# industry_name text,
# trans_amt_share text,
# trans_amt_rank integer
#
# )