Talk delivered 2015-07-29 at ICERM workshop on "mathematics and data science"
Tyler Dahlberg TDahlberg
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH point1 AS ( | |
| SELECT cdb_geocode_postalcode_point(<%= postcode1 %>, 'USA') as geo | |
| ), | |
| point2 AS ( | |
| SELECT cdb_geocode_postalcode_point(<%= postcode2 %>, 'USA') as geo | |
| ), | |
| route AS ( | |
| SELECT | |
| r.shape as geo, | |
| r.length |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
chrishwiggins
/ icerm.md
Last active
August 31, 2020 22:34
peterdesmet
/ 88c30be4-1063-11e5-a9ae-0e853d047bba.md
Last active
March 16, 2018 14:29
Bird migration forward trajectory visualizations in CartoDB
Nocturnal bird migration forward trajectory classified by airspeed into songbirds and waterbirds - Night of April 7-8, 2013
https://inbo.cartodb.com/u/lifewatch/viz/88c30be4-1063-11e5-a9ae-0e853d047bba/public_map
SELECT *,
CASE
WHEN airspeed = 0 THEN 0
jqtrde
/ modern-geospatial-python.md
Last active
August 1, 2023 14:50
Modern remote sensing image processing with Python
andrewxhill
/ harvard_workshop.md
Last active
September 30, 2015 17:26
This page can always be found at: http://bit.ly/cdb-harvard
- Tour of dashboard
- Common data
- Uploading data
- Tour of table and map view
- Publishing maps
- Public profile
Data: Denver Traffic Accidents
Go to your traffic_accidents table and let's start by creating a new visualization
key things
CartoDB Build Day
Hello!
briantjacobs
/ storytelling_from_space.md
Last active
February 18, 2024 10:02
Storytelling from Space
This list of resources is all about acquring and processing aerial imagery. It's generally broken up in three ways: how to go about this in Photoshop/GIMP, using command-line tools, or in GIS software, depending what's most comfortable to you. Often these tools can be used in conjunction with each other.
- USGS Earth Explorer - Browser and data access (create a login)
http://earthexplorer.usgs.gov/
- Landsat archive
This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
NewerOlder