Use yahoo string geolocation api and drop results into cartodb

Gist 89811213f98645c51fa8

Using CartoDB’s SQL API and PostGIS functions, this notebook explores Gilt purchase data aggregated by zip code. It shows a series of interactive maps, including a bubble map of average session time and choropleths of purchase rates, built from geocoded postal points and polygon tables. The workflow demonstrates nested SQL subqueries to join transaction aggregates with geometries, spatial filtering with `ST_Intersects` and `ST_Buffer` around New York City, and on-the-fly centroid generation via `st_centroid` for a target audience map. Geocoding and tile rendering rely on CartoDB’s default web-mercator projection.

65% match

Gist 9378741

This interactive interface guides users through geocoding tabular data, first classifying location columns by type—city names, postal codes, IP addresses, or street addresses—then offering point or polygon output options. After georeferencing, it displays result summaries with success counts, failure explanations, and cost feedback, including free and paid quota messaging. The example uses CartoDB’s geocoding API and a dynamic form interface, with state-driven prompts and dropdowns to collect necessary country or region details before triggering the geocoding process.

65% match

Node.js app to harvest a georss feed into CartoDB

A Node.js app harvests live GeoRSS incident reports from Portland’s 911 feed and inserts new records into a CartoDB table. The animation shows a continuously updating map of emergency locations as fresh entries are parsed from XML using `xml2js`, then posted via CartoDB’s SQL API with `http.request`. Each feed item’s title, timestamps, category label, and point coordinates are extracted and formatted into an SQL `VALUES` insert, skipping duplicates. The process runs repeatedly, appending visible points to the map over time.

63% match

Gist 4354110

This visualization displays a map rendered with CartoDB, showing geographic data from a hosted visualization. The page loads a full-screen map using the CartoDB.js library, which initializes the map via `cartodb.createVis` and connects to a remote visualization URL. The map itself is embedded in a fixed-size `<div>` element and relies on CartoDB’s built-in rendering and tile services to draw the geographic layers. The code does not include custom data processing or interaction logic; it simply leverages the CartoDB API to present the pre-configured map.

63% match

CartoDB CSV Bulkloader for Python

This example demonstrates a Python script that bulk-loads CSV data into a CartoDB table via the CartoDB SQL API, converting latitude and longitude columns into geometry using the CDB_LatLng function. It reads rows from a local CSV file, batches inserts of up to 25,000 rows per request, and skips records already present by checking a unique identifier against the table’s latest entry. The code uses Python’s csv, urllib2, and json modules to parse data and send HTTP POST requests, with error handling that writes failed SQL statements to a log file.

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.

Gist a61b3f54da810f6e9490

This example demonstrates how to map and animate earthquake data from the USGS CSV feed using CartoDB’s mapping tools. It shows temporal earthquake occurrences through an interactive map, with points updating over time. The code relies on CartoDB’s SQL API and JavaScript library for layer management, alongside D3.js for data-driven visualizations. It also integrates Chart.js for supplementary graphs and uses dynamic styling via CartoDB’s tile rendering. The visualization highlights both spatial distribution and time-based animation of seismic events.

Web Speech API Demo

This demo uses the Web Speech API to drive a CartoDB map visualization. It listens for spoken words, converts them to text, and submits the transcribed phrase as a search query through the cartodb.js search overlay. The map renders a CartoDB-hosted dataset, and after each utterance, the speech recognition restarts to allow continuous voice-controlled searching. The code relies on `webkitSpeechRecognition` for speech-to-text and the CartoDB `createVis` function to display the map layer.