{"version":"1.0","type":"rich","title":"jQuery - Display SQL Results","description":"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.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-8547753?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}