Andy Eschbacher andy-esch

PostGIS in CartoDB

Andy Eschbacher, Map Scientist, CartoDB, @MrEPhysics

Find this document here:

http://bit.ly/cdb-osgeo

Webinar Write-up

Andy Eschbacher | Map Scientist | CartoDB | @MrEPhysics | [email protected]

Find this document here: http://bit.ly/cdb-namedmaps

You can easily make Named Maps through the CartoDB Editor anytime you create a public visualization with your private data. Just because the visualization is public doesn't mean that your data is exposed. Only the data that is sent is the data that you configure ahead of time.

Making Named Maps in CartoDB.js is similar but requires more technical skills.

This is an IPython notebook made to show how CartoDB's PostgreSQL/PostGIS backend easily connects with Plotly via panda's read_csv. Check out the notebook on Plotly's servers: https://plot.ly/ipython-notebooks/cartodb/ or view the notebook on nbviewer: http://nbviewer.ipython.org/gist/ohasselblad/1d6040d93c1a9e6cfff2/cartodb.ipynb

Cornell Data Science Hackathon

Andy Eschbacher, Map Scientist, CartoDB

@MrEPhysics | [email protected]

Find notes here: bit.ly/cdb-cornell-notes
Gist stored here: bit.ly/cornell-hack-cdb

What is CartoDB?

Introduction to CartoDB

March 9th, 2015

Andy Eschbacher, Map Scientist, CartoDB

@MrEPhysics | [email protected]

	<!DOCTYPE html>
	<html>
	<head>
	<title>CartoDB</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" />

	<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css">
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.12/themes/css/cartodb.css" />

	<!DOCTYPE html>
	<html>
	<head>
	<title>Tile Explorer \| CartoDB</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" />

	<!-- Map takes up full browser window -->
	<style>


	-- Convert your states (or other geometries id'd by state) to
	-- display as with Alaska, Hawaii, and Puerto Rico transcaled
	--
	-- @param g: input geometry
	-- @param state: column identifying the state (name, postal abbreviation, state FP)
	--
	-- output: geometries of states in albers projections of the states
	--
	-- Projections:

	<!DOCTYPE html>
	<html>
	<head>
	<title>Map Academy \| CartoDB.js & Torque.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 {
	height: 100%;

	<!DOCTYPE html>
	<html>
	<head>
	<title>
	customhoverwindows \| CartoDB
	</title>

	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8" />

Andy Eschbacher andy-esch

PostGIS in CartoDB

http://bit.ly/cdb-osgeo

Webinar Write-up

Cornell Data Science Hackathon

Andy Eschbacher, Map Scientist, CartoDB

What is CartoDB?

Introduction to CartoDB

March 9th, 2015

Find this write up here: bit.ly/cdb-stanford