Skip to main content
100%

Notes

✓ Published0🌍 Public
Aandrewxhill
Last edited May 13, 2014
Created on May 13, 2014

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.

AI-generated description

Similar vizzes

Loading thumbnail…

NACIS Workshop | CartoDB

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.

Aandrewxhill
75% 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
72% 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
71% match
Loading thumbnail…

CartoDB SQL tricks: Various things that as a SQL-newbie I had to search for >10 minutes to find answers for.

This example demonstrates a collection of SQL recipes for solving common spatial data problems in CartoDB, ranging from merging neighboring county polygons with ST_Union to creating great circle lines via ST_MakeLine and ST_Segmentize. It shows practical techniques like updating geometries with conditional CASE statements, extracting coordinates with ST_X and ST_Y, stripping HTML tags using regexp_replace, and formatting zip codes with to_char. The code also covers performance strategies for large updates and querying spatial relationships with st_contains. Each snippet targets PostGIS functions within the CartoDB platform, emphasizing data preparation and geometric transformations.

Aandrewbt
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
Loading thumbnail…

Map - Table

A map and sortable table display geographic data from a CartoDB visualization, with the table listing attribute columns and rows from the map's underlying dataset. The interface uses the CartoDB.js library to render the map and SQL API to query data, while jQuery DataTables provides interactive sorting and pagination. Users can filter table entries by column values, which dynamically updates the map's SQL query to highlight matching features. The example demonstrates a linked map-table workflow for exploring spatial and tabular data together.

Aandrewxhill
68% match
Loading thumbnail…

Gist 5830532

This example displays a map with a set of geographic features loaded from a CartoDB SQL query, which returns data in GeoJSON format. The visualization uses the Leaflet mapping library to render the map and a `L.geoJson` layer to draw the features. Each feature is processed with an `onEachFeature` callback that assigns a `cartodb_id` property to the corresponding Leaflet layer and adds it to a `drawnItems` layer group, which is then added to the map. The data source is the `leaflet_data` table from the osm2 CartoDB account.

Aandrewxhill
68% match
Loading thumbnail…

Basic CartoDB Layer in D3

This example displays geographic features from a CartoDB table as violet polygons on a map. It uses D3.js with a GeoJSON data format to load the geometry through the CartoDB SQL API. The code applies `d3.geoPath` with a projection to convert GeoJSON coordinates into SVG path data, appending `path` elements to a selected layer. The map relies on the `d3.json` method to fetch the data asynchronously and render it directly into the SVG.

Aandrewxhill
67% match