blocks by andrewxhill

example random access formats

A list of frameworks for decision making and where they are most helpful.

Chain of Trust - but verify...

Generate queryable ownership records and transfer logs in any ERC721. This example is extending OpenZepplin functions. You can see the contract here https://mumbai.polygonscan.com/address/0xB837771546756D58d2EB79CDb0281Bc5F84bC704 and the owner logs here https://testnets.opensea.io/assets/mumbai/0x4b48841d4b32c4650e4abc117a03fe8b51f38f68/5969 and transfer logs here https://testnets.opensea.io/assets/mumbai/0x4b48841d4b32c4650e4abc117a03fe8b51f38f68/5970.

Tableland game workshop

Uses midpointapi.com to return a single cell value from any table or sql request on Tableland

4b02d1558eb34ecad764

hello-remote-threads.go

Powergate Workshop

b12541a7e22482d8e57d

fed2ab60d0a8b68f30f9

a73c0a23221773fd3032

1e7ec4d379a1e6a16c52

7c4b54a12822d8cb5c4f

Update an IPFS record in Cloudflare DNS

856f34e76a439df2c77e

567e762d2ad71c36b243

84c19b830de7ca18d8bc

bc0b0435c4549d790093

6e87e5526f80c649c74c

4417ed600fc17af2ed84

a6d52d798025f521616f

c52a8d028d9be31e5ee2

5d553ade7d332fe430be

Create small multiples through the Static Maps API

quick example of using the batch api over python

Get a static map from a viz.json using python

Example of a CartoDB iframe in the Amp library

Minimum spanning tree in SQL... just because

Static Image Generator Example

fixed election map

Test of SunCalc in SQL

Use yahoo string geolocation api and drop results into cartodb

Simple createLayer

Use Goldberry to harvest a single basketball game and push it to CartoDB. WARNING This will pull ~2-3,000,000 points, so probably not for your typical free CartoDB account :)

USPO map lives again!

list all points at a point

How the Twitter Template works

Create a table to store changes from any of your tables in a log table.

d7a736227751a4a49072

currency map

Quick POW map!

quick linear regression test

Census Tracts - 2010 Column Descriptions

9f9b2c7c5c3ab0bdbca9

Publish a map with a filterable table

Simple table view

a81c267615bde4d028ee

projections for fun

multi layer toggle for ferzoco

0d1d3528ef534696ac4f

Torque date format picker

Speak a place to go to it on a map

Blow into make to move the car

1df8fd0f770b319d9395

7c1efd9bdead734010b0

template for harvard workshop

Merging an entire directory of data and loading it to CartoDB

rundown

f16c88ecd8d151eae384

a61b3f54da810f6e9490

Fun with Torque

CartoCSS for Animated Bubble Map

6bf5a60d08034143bf8b

46fd5ee6e8f80b62bd42

Steps used to make map of California rivers

CartoDB Fiesta

Choropleth Service

ecohack example

61a8156b4d767a9f0154

Space Launch Report - An example of Torque with labels

easily add sunlight layer to your Torque maps

Totally random

torque static bubble map

Tight torque control over color of static map

Static torque for heatmap effect

Toggle different vis.json layers on a map

Node.js app to harvest a georss feed into CartoDB

Tim's transform of dentists

Maps, Lies & Storytelling | Class 1

Volumetric OSM Buildings

PlpgSQL to cross dateline when drawing two points

d3537756e170de30f8a6

one minute demo of metro extracts

Grid snapping only in SQL!

Williams Transco leak history

e5d18b76113fe1762f54

2c13fffce0f32b169624

24e4e0ec42cdeff6633c

159e7fca2c18ecc945c8

CartoDB Internships

Use Leaflet Draw to filter and style a CartoDB layer

Course notes

command-line python interface for manipulating data on CartoDB

County selector example

Default map from tablename / username

5278747cb93e11c9468c

6fed65f80143feeae823

89811213f98645c51fa8

size by column sum

small multiples using many maps

ee42fd1328722214864c

67fa3790166d6549f4a9

2e969e0d45ceb3555cc4

Notes

8ffcc52f67202a3c65bd

734eccf8853aef50f07b

fc77170db4eeca1daeb7

f122bb03086cd80b0d17

Tricking CartoDB into new projections

cdb_latlng

11071111

10926745

10926650

Random tiles: CartoDB hates me

CartoDB.js Layer Selector

Quick list of CartoDB weather and climate related maps

9378741

Torque plus Chart.js

Chart.js using SQL API

Torque using createLayer in CartoDB.js

Create hex bins on the fly

Country name, iso, synonyms

Madison workshop documents

PLPGSQL Function to cross the dateline

Tribeca New Media - Breakout 2: Building community

Tribeca New Media - Breakout 1: Drivers for participation

Spreading points found at the same location

Clustering using snaptogrid

Double pane with focus

clustering with slider

How to fully customize infowindows in CartoDB

CartoDB SQL results plus jQuery

That's not a map...

Moving Alaska and Hawaii in CartoDB

DataKind mapping crash course

Curved connection paths with CartoDB

Polygon connections

Point clustering no label for single

Style selector menu for CartoDB

example.html from mapshot

Zoom based point clustering in CartoDB

First pass at a simple point clustering algo for plpgsql

8240756

Fun SQL statements for CartoDB

Important bits for rainy cities visualization

Raincloud CartoCSS

hover demo

6954283

cartodb workshop links

PLUTO reverse geocode SQL

6114786

Instructions for Mapbox basemap in CartoDB

Link two datasets into lines between nearest points

Import CartoDB file with cURL

Import CartoDB file with cURL (Mac version)

torque query and output

Leaflet.draw control for CartoDB

upsert the_geom with security definer

5830532

CartoDB CSV Bulkloader for Python

Efficient bulk update and insert

Polygon insert Named Function

On the fly size sort of polygons in CartoDB

A rain of meteors, a quick retool of earthquake map in D3

Color World: Collect data from Google Form and insert into CartoDB

Fustion Tables CSV => Postgresql => Geom fix

Using Bootstrap Typeahead based on a CartoDB column

working try!

World Bank Climate CO2 Emissions (per country) D3 + CartoDB

World Bank Climate CO2 Emissions (per capita) D3 + CartoDB

Regional breakdowns by month (CartoDB + D3)

Regional breakdowns by month (CartoDB + D3)

January, March, May, July Drought Maps in D3 + CartoDB

CartoDB + D3 Earthquakes (alt)

Exploding globe in D3

First try: TopoJSON on CartoDB

4503902

4495761

Basic CartoDB Layer in D3

Simple CartoDB + D3 earthquake example

CartoDB + D3 Bubble Map

Basic CartoDB + D3 Choropleth

4391555

4354110

Faking building height by using polygon size (CartoCSS)

Faking building height by using polygon size

kmeans function and examples

Super naive but fast kmeans

Kmeans better still, ~5 seconds for 50,000 points

4063106

4047799

4047791

carbon poly tool sum SQL

parenthesis enclosed NYC open data lat/lon to the_geom

Better Kmeans loop for any number of clusters

Order polygons by size/height

kmean cartocss style

Straight SQL Kmean

Longer single line text

New SQL statement for bigline generation

Create an equal area grid over a buffer of points

SQL for building a dynamic topo

Color ramp for a topology

Converts a directory of images into two directories, one large, one small of PNGs

sernec project data

CartoDB Backbone for data-driven webpages

Rasters to polygons for CartoDB

Python script to covert GeoTiff .CLR file to a Carto style for CartoDB

cartodb_test.md

cartodb_test.html

3163949

Create a density grid from geometries. For use in CartoDB

Creates a bounding circle from the_geom_webmercator on cartodb

1750808

fastest query for admin content

combining styles across layers

Sum PostgreSQL arrays in place [1,2,3] + [2,3,4] = [3,5,7]

Finding longest path between two geoms

A temporary fix to raster2pgsql.py to work with current PostGIS HEAD

Clustering stylings for CartoDB

ST_ClipEx a working variation of ST_Clip for raster

1447684

1353427

1353003

1198897

1127799

1127779

Commplish Bitcoin Awarding API

Commplish Badge Awarding API

Python Commplish User Profile API Example

Python Commmplish API Signature

991610

991608

991607

Third pass at collections metadata JSON from Andrew

975514

973618

972852

956273

954761

954622

954147

taxonomy service

908456

896930

894879

890902

canvas marker

localhost quick work

First implementation of a taxonomy model for the Map of Life project