Orchard is an early preview — connector details below are illustrative while we iterate.

Public data

Citi Bike

A free, ready-to-attach connector serving NYC Citi Bike’s public station, status, and trip-history feeds as tidy SQL tables — great for demos and learning.

Stable By Query.Farm Python worker

Pricing

What Citi Bike does

The Citi Bike connector wraps the public Citi Bike GBFS and trip-history feeds into a clean SQL catalog. Live station status, station metadata, and historical trips are all queryable without downloading and unzipping CSVs yourself.

It is free to attach and is the connector behind several of the Query.Farm homepage examples. Use it to learn the Orchard workflow, prototype geospatial joins, or build a quick dashboard against real, constantly-changing data.

Highlights

Live station status and capacity
Station metadata with coordinates
Historical trips by month
Geospatial-ready latitude/longitude columns
Free to attach — no subscription required

Tables & functions it exposes

Once attached, the connector adds these objects to your SQL session.

Table citibike.stations: Station id, name, capacity, and coordinates.
Table citibike.status: Live bikes and docks available per station.
Table citibike.trips: Historical trip records by month.

What teams build with Citi Bike

Learn the Orchard attach-and-query workflow for free.

Prototype geospatial joins against weather or census data.

Build a live “where are the bikes” dashboard.

Ready to attach Citi Bike?

Pricing

Attach & query

citibike.sql

-- Attach the free Citi Bike connector (no token required)
ATTACH 'citibike' AS citibike (
  TYPE vgi,
  LOCATION 'https://orchard.query.farm/citibike'
);

-- Busiest stations that are nearly empty right now
SELECT s.name, st.num_bikes_available, st.num_docks_available
FROM citibike.status   AS st
JOIN citibike.stations AS s USING (station_id)
WHERE st.num_bikes_available <= 2
ORDER BY s.capacity DESC
LIMIT 10;

Requires the VGI extension. Set ORCHARD_TOKEN after subscribing.

Keep exploring