1<YYYY-MM-DD-vN>/
2├── README.md                     # version metadata (OSM date, Overture release, model)
3├── osm-parquet/                  # OSM-only snapshot, hive-partitioned by primary_tag
4├── osm-pmtiles/osm.pmtiles       # OSM snapshot as a single PMTiles archive
5├── conflated-parquet/            # OSM × Overture conflated snapshot, hive-partitioned by shared_label
6└── conflated-pmtiles/conflated.pmtiles

1<YYYY-MM-DD-vN>/
2├── README.md                     # version metadata (OSM date, Overture release, model)
3├── osm-parquet/                  # OSM-only snapshot, hive-partitioned by primary_tag
4├── osm-pmtiles/osm.pmtiles       # OSM snapshot as a single PMTiles archive
5├── conflated-parquet/            # OSM × Overture conflated snapshot, hive-partitioned by shared_label
6└── conflated-pmtiles/conflated.pmtiles

1import pyarrow.dataset as ds
2import pyarrow.fs as pafs
3
4BASE = "us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
5VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
6
7fs = pafs.S3FileSystem(anonymous = True, region = "us-west-2")
8pois = ds.dataset(
9    f"{BASE}/{VERSION}/conflated-parquet/",
10    filesystem = fs,
11    format = "parquet",
12    partitioning = "hive",
13)
14print(pois.schema)
15print(f"{pois.count_rows():,} POIs")

1import pyarrow.dataset as ds
2import pyarrow.fs as pafs
3
4BASE = "us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
5VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
6
7fs = pafs.S3FileSystem(anonymous = True, region = "us-west-2")
8pois = ds.dataset(
9    f"{BASE}/{VERSION}/conflated-parquet/",
10    filesystem = fs,
11    format = "parquet",
12    partitioning = "hive",
13)
14print(pois.schema)
15print(f"{pois.count_rows():,} POIs")

1import duckdb
2
3BASE = "s3://us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
4VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
5
6con = duckdb.connect()
7con.execute("INSTALL httpfs; LOAD httpfs;")
8con.execute("""
9    CREATE OR REPLACE SECRET srccoop (
10        TYPE s3, PROVIDER config,
11        REGION 'us-west-2', URL_STYLE 'path',
12        KEY_ID '', SECRET ''
13    );
14""")
15df = con.execute(f"""
16    SELECT shared_label, COUNT(*) AS n
17    FROM read_parquet('{BASE}/{VERSION}/conflated-parquet/**/*.parquet',
18                      hive_partitioning = true)
19    GROUP BY shared_label
20    ORDER BY n DESC
21    LIMIT 20
22""").df()
23print(df)

1import duckdb
2
3BASE = "s3://us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
4VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
5
6con = duckdb.connect()
7con.execute("INSTALL httpfs; LOAD httpfs;")
8con.execute("""
9    CREATE OR REPLACE SECRET srccoop (
10        TYPE s3, PROVIDER config,
11        REGION 'us-west-2', URL_STYLE 'path',
12        KEY_ID '', SECRET ''
13    );
14""")
15df = con.execute(f"""
16    SELECT shared_label, COUNT(*) AS n
17    FROM read_parquet('{BASE}/{VERSION}/conflated-parquet/**/*.parquet',
18                      hive_partitioning = true)
19    GROUP BY shared_label
20    ORDER BY n DESC
21    LIMIT 20
22""").df()
23print(df)

1import geopandas as gpd
2import pyarrow.fs as pafs
3
4BASE = "us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
5VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
6
7fs = pafs.S3FileSystem(anonymous = True, region = "us-west-2")
8# conflated-parquet is hive-partitioned by shared_label.
9gdf = gpd.read_parquet(
10    f"{BASE}/{VERSION}/conflated-parquet/shared_label=Cafe/part-0.parquet",
11    filesystem = fs,
12)
13print(gdf.head())

1import geopandas as gpd
2import pyarrow.fs as pafs
3
4BASE = "us-west-2.opendata.source.coop/henryspatialanalysis/openpois"
5VERSION = "latest"   # or pin a specific dated folder, e.g. "2026-04-23-v0"
6
7fs = pafs.S3FileSystem(anonymous = True, region = "us-west-2")
8# conflated-parquet is hive-partitioned by shared_label.
9gdf = gpd.read_parquet(
10    f"{BASE}/{VERSION}/conflated-parquet/shared_label=Cafe/part-0.parquet",
11    filesystem = fs,
12)
13print(gdf.head())

1<!doctype html>
2<meta charset="utf-8" />
3<title>OpenPOIs — conflated</title>
4<link href="https://unpkg.com/maplibre-gl@4/dist/maplibre-gl.css" rel="stylesheet" />
5<style>html, body, #map { height: 100%; margin: 0; }</style>
6<div id="map"></div>
7<script src="https://unpkg.com/maplibre-gl@4/dist/maplibre-gl.js"></script>
8<script src="https://unpkg.com/pmtiles@3/dist/pmtiles.js"></script>
9<script>
10  const BASE = "https://data.source.coop/henryspatialanalysis/openpois";
11  const VERSION = "latest";   // or pin a specific dated folder, e.g. "2026-04-23-v0"
12
13  const protocol = new pmtiles.Protocol();
14  maplibregl.addProtocol("pmtiles", protocol.tile);
15
16  const map = new maplibregl.Map({
17    container: "map",
18    style: "https://tiles.openfreemap.org/styles/positron",
19    center: [-73.9855, 40.758],   // Times Square
20    zoom: 16,
21  });
22
23  map.on("load", () => {
24    map.addSource("openpois", {
25      type: "vector",
26      url: `pmtiles://${BASE}/${VERSION}/conflated-pmtiles/conflated.pmtiles`,
27      minzoom: 14,
28    });
29    map.addLayer({
30      id: "openpois-points",
31      type: "circle",
32      source: "openpois",
33      "source-layer": "conflated_pois",   // set by publish.pmtiles.conflated_layer_name
34      paint: {
35        "circle-radius": 4,
36        "circle-stroke-width": 1,
37        "circle-stroke-color": "#ffffff",
38        // Red when stale (conf_mean ≈ 0), green when fresh (≈ 1).
39        "circle-color": [
40          "interpolate", ["linear"], ["get", "conf_mean"],
41          0.0, "#d73027",
42          0.3, "#fee08b",
43          0.7, "#1a9850",
44        ],
45      },
46    });
47    map.on("click", "openpois-points", (e) => {
48      const p = e.features[0].properties;
49      new maplibregl.Popup()
50        .setLngLat(e.lngLat)
51        .setHTML(
52          `<b>${p.name ?? "(no name)"}</b><br>` +
53          `${p.shared_label} · source=${p.source}<br>` +
54          `conf_mean = ${Number(p.conf_mean).toFixed(3)}`
55        )
56        .addTo(map);
57    });
58  });
59</script>

1<!doctype html>
2<meta charset="utf-8" />
3<title>OpenPOIs — conflated</title>
4<link href="https://unpkg.com/maplibre-gl@4/dist/maplibre-gl.css" rel="stylesheet" />
5<style>html, body, #map { height: 100%; margin: 0; }</style>
6<div id="map"></div>
7<script src="https://unpkg.com/maplibre-gl@4/dist/maplibre-gl.js"></script>
8<script src="https://unpkg.com/pmtiles@3/dist/pmtiles.js"></script>
9<script>
10  const BASE = "https://data.source.coop/henryspatialanalysis/openpois";
11  const VERSION = "latest";   // or pin a specific dated folder, e.g. "2026-04-23-v0"
12
13  const protocol = new pmtiles.Protocol();
14  maplibregl.addProtocol("pmtiles", protocol.tile);
15
16  const map = new maplibregl.Map({
17    container: "map",
18    style: "https://tiles.openfreemap.org/styles/positron",
19    center: [-73.9855, 40.758],   // Times Square
20    zoom: 16,
21  });
22
23  map.on("load", () => {
24    map.addSource("openpois", {
25      type: "vector",
26      url: `pmtiles://${BASE}/${VERSION}/conflated-pmtiles/conflated.pmtiles`,
27      minzoom: 14,
28    });
29    map.addLayer({
30      id: "openpois-points",
31      type: "circle",
32      source: "openpois",
33      "source-layer": "conflated_pois",   // set by publish.pmtiles.conflated_layer_name
34      paint: {
35        "circle-radius": 4,
36        "circle-stroke-width": 1,
37        "circle-stroke-color": "#ffffff",
38        // Red when stale (conf_mean ≈ 0), green when fresh (≈ 1).
39        "circle-color": [
40          "interpolate", ["linear"], ["get", "conf_mean"],
41          0.0, "#d73027",
42          0.3, "#fee08b",
43          0.7, "#1a9850",
44        ],
45      },
46    });
47    map.on("click", "openpois-points", (e) => {
48      const p = e.features[0].properties;
49      new maplibregl.Popup()
50        .setLngLat(e.lngLat)
51        .setHTML(
52          `<b>${p.name ?? "(no name)"}</b><br>` +
53          `${p.shared_label} · source=${p.source}<br>` +
54          `conf_mean = ${Number(p.conf_mean).toFixed(3)}`
55        )
56        .addTo(map);
57    });
58  });
59</script>