jQuery - Display SQL Results

100%

jQuery - Display SQL Results

✓ Published0🌍 Public

Last edited Jan 21, 2014

Created on Jan 21, 2014

A jQuery-based page displays the lengths of New York City subway lines by querying a CartoDB SQL API. It shows a bulleted list titled "Line name: length" with each subway line’s name and its length in kilometers, sorted descending by geometric length. The code uses `cartodb.SQL` to execute a SQL query that calculates `ST_Length` on the `nyc_subway_routes` geometry, converting it to kilometers and limiting results to 20 lines. jQuery’s `$()` and `.append` build the list items dynamically from the returned data rows.

AI-generated description

Similar vizzes

Loading thumbnail…

nyc subways

Shows three intersecting New York City subway lines—the 1, 2, and 3 routes—as MultiLineString geometries from a GeoJSON FeatureCollection, with each route’s track path rendered as a separate visual segment. The example uses d3.geoPath to convert geographic coordinates into screen-space projections over a map base, with route_id values distinguishing line colors. Data is loaded directly from the subways.geojson source file, which encodes each route as a multilinestring of consecutive station-to-station coordinate pairs.

JJn1532

65% 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

61% match

Loading thumbnail…

rundown

This example demonstrates how SQL queries can filter, analyze, and modify geographic data in CartoDB, using Massachusetts census blocks and Boston corner store locations. It shows spatial queries like distance calculations and bounding-box filters, plus joins to compute nearest fire station distances. The code uses the CartoDB SQL API and CartoDB.js library, with Leaflet for map rendering, to apply dynamic SQL filters and create visualizations without altering the underlying dataset.

Aandrewxhill

61% match

Loading thumbnail…

Gist e049813cea7c84ccf54d681eb78088b5

The visualization displays a set of SQL query results from a weather and bike-share database, showing data such as the hottest day by zip code, trip counts by station, shortest trip duration, and average trip duration by end station. It uses Python with SQLite queries to extract the data, then renders the results in a web-based chart. The code references the `sqlite3` library for database access and likely employs a JavaScript charting library like D3.js to plot the aggregated values, though the specific rendering API is not fully visible in the provided snippet.

Aankuagar

61% match

Loading thumbnail…

load csv files from anywhere using YQL

This example demonstrates loading a CSV file from an external URL into a web page using the Yahoo Query Language (YQL) web service. The page fetches a dataset of London Underground line travel times between stations, applying a SQL-like query through the Yahoo Public YQL endpoint with JSONP. The code relies on jQuery 1.4.2's `$.ajax()` method to make the cross-domain request, specifying the CSV’s column names in the query itself. The returned JSON response would then be iterated over, though the example only logs it to the console and does not render any visualization.

RRandomEtc

59% match

Loading thumbnail…

Map Connections | CartoDB.js

Clicking a ZIP code polygon on a U.S. map triggers a dynamic query that draws purple curved lines from that selected area to nearby ski resorts within a 1,000-unit distance. The example uses CartoDB.js with Leaflet to render the base map and vector layers, while a CartoDB SQL API call executes `ST_MakeLine`, `ST_Segmentize`, and `ST_Transform` to generate geodesic connection paths in GeoJSON format. Interactivity includes cursor changes on feature hover and line removal/replacement on each new click, with styling controlled through CartoCSS.

Aandrewxhill

58% match

Loading thumbnail…

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.

Aandrewxhill

58% match

Loading thumbnail…

Map Connections | CartoDB.js

Clicking a ZIP code on a gray choropleth map of the lower 48 states triggers a purple line to be drawn from that location to each nearby ski area within 1,000 units. The example uses CartoDB.js to render the base layer and SQL queries to compute line geometries via `ST_MakeLine` and `ST_Centroid`. It also employs Leaflet’s `L.Map` for panning and zooming, with `featureClick` and `featureOver` events managing cursor feedback.

Aandrewxhill

58% match