Skip to main content
100%

NACIS Workshop | CartoDB

✓ Published0🌍 Public
Aandrewxhill
Last edited Oct 14, 2013
Created on Oct 12, 2013

A step-by-step workshop guide demonstrates CartoDB's mapping and data-analysis capabilities through a sequence of exercises. The HTML page embeds a Speaker Deck presentation and lists tasks covering data import, visualization styling with CartoCSS, SQL filtering, and spatial queries. It references downloadable shapefiles, including tornado paths, NYC bike blocks, and tracked location data, with example SQL statements for distance calculations. The code loads CartoDB.js v3 and its CSS to support interactive map rendering throughout the tutorial.

AI-generated description

Similar vizzes

Loading thumbnail…

Notes

A set of tutorial notes for CartoDB demonstrates a progression through mapping workflows, from importing CSV data with latitude/longitude coordinates to styling visualizations with CartoCSS and querying tables via SQL. The notes cover data editing, georeferencing, privacy settings, and integrating CartoDB.js for web maps, referencing external resources like colorbrewer2.org and PostGIS documentation.

Aandrewxhill
75% match
Loading thumbnail…

Easy example | CartoDB.js

This example shows a full-screen interactive map that renders a dataset called "untitled_table_5" with custom CartoCSS styling. The map displays points, lines, and polygons in a red color scheme with white outlines, and includes tooltips triggered by interactivity on the `cartodb_id` field. The code uses the CartoDB.js library version 3, specifically `cartodb.createVis`, which loads the visualization from a JSON configuration object. The base map is provided by OpenStreetMap tiles via Leaflet, while the geographic data is queried from a CartoDB table using SQL and styled with CartoCSS rules for each geometry type.

Aandrewxhill
74% match
Loading thumbnail…

Gist 7c1efd9bdead734010b0

This tutorial demonstrates how to build interactive maps and animated visualizations of a cat’s GPS tracking data using CartoDB’s web interface, SQL, and CartoCSS. It shows point, categorical, and temporal bubble maps, including a Torque animation of Spencer the Cat’s movements over time. The code uses CartoDB’s SQL API with functions like `ST_MakeLine` and `date_part`, along with CartoCSS styling for markers. It also covers importing polygon building datasets from MassGIS and querying them with spatial operations like `ST_Distance` and `CDB_LatLng`.

Aandrewxhill
74% match
Loading thumbnail…

DataKind Workshop | Demo

This demo embeds a CartoDB map visualization centered on global coordinates, displaying geographic data points as an interactive web map. The iframe loads a published CartoDB visualization with pan and zoom controls enabled, while hiding search, layer selection, and legends for a clean presentation. The underlying map uses CartoDB’s tile-based rendering to show spatial patterns, with the page’s HTML and CSS ensuring the map fills the entire viewport. The code relies on the CartoDB embed API and standard iframe integration rather than custom JavaScript libraries.

Aandrewxhill
73% match
Loading thumbnail…

CartoDB Workshop | CartoDB.js

This example uses CartoDB.js to display an interactive map inside a full-screen div. The code initializes a map with a single custom overlay button labeled “Do Something,” which sits in the top-right corner and changes its background on hover. The map itself is rendered using the CartoDB library’s tile layers, while the button is styled with the included cartodb-infobox CSS class. The JavaScript structure defines a main function tied to the window load event, though no map layers or data sources are explicitly loaded in the provided snippet.

Aandrewxhill
72% match
Loading thumbnail…

DataKind Workshop | Demo

This demo shows New York State sewage overflow reports as a bubble map, where each bubble’s size represents the volume of gallons discharged, ordered from largest to smallest. The visualization is built with CartoDB, using its hosted map tiles and an embedded iframe that loads a preconfigured SQL query. The map applies CartoCSS styling to handle null volume values, and the underlying data comes from a public CSV hosted at Nijel.org.

Aandrewxhill
70% match
Loading thumbnail…

CartoDB Backbone for data-driven webpages

This example demonstrates how to integrate CartoDB’s geographic data services with the Backbone.js framework to build data-driven webpages. The code defines a custom Backbone model that queries the `nyc_parks` table via SQL, fetching the ten largest parks by area and then binding a `reset` event to display their names in an alert. It uses CartoDB’s `CartoDBCollection` and the `fetch()` method to load remote data asynchronously, while Backbone’s event system triggers the callback. The example shows a minimal pattern for combining SQL queries with a client-side MVC structure.

Aandrewxhill
70% match
Loading thumbnail…

Fun SQL statements for CartoDB

This example shows how to explore and analyze tornado and county data in CartoDB using SQL statements. It demonstrates basic queries for filtering, sorting, and aggregating records, followed by spatial functions that inspect geometry types, compute areas, distances, and intersections. The code uses PostGIS functions such as `ST_Area`, `ST_Distance`, `ST_Intersects`, and `ST_DWithin`, alongside CartoDB-specific helpers like `CDB_LatLng`. It also includes updates to add tornado counts and density per county, highlighting how SQL can drive interactive map visualizations.

Aandrewxhill
70% match