pg_tileserv

Service Metadata

• index.json for layer list

Table Layers

• public.artwork (preview | json)
• public.bench (preview | json)
• public.building_concept_qgis (preview | json)
• public.buildings (preview | json)
• public.campsite (preview | json)
• public.campuses (preview | json)
• public.coastline (preview | json)
• public.contours_1m_qgis (preview | json)
• public.contours_5m_qgis (preview | json)
• public.driveways (preview | json)
• public.frog (preview | json)
  lmb - fiberglass frogs - just move point into thing
• public.grass (preview | json)
• public.image_overlay (preview | json)
  A raster image (e.g. a hand-drawn map annotation) georeferenced onto lmb-maptwo as a MapLibre image source. geom is the image's top-left corner; width_m is the desired on-the-ground width, height derived from the image's own aspect ratio. filename is a static asset filename served from lmb-maptwo's static dir (e.g. port-blakely-label.png), not a path/URL. See ontologies.mapping.image_overlay_coordinates for the georeferencing math, and the build_map_style_job Dagster asset that regenerates map-style.json from these rows.
• public.islands (preview | json)
• public.landcover (preview | json)
• public.landings (preview | json)
  lmb - polygons for landings - used on prototype map. this for the whole Puget sound area. label_x, label_y are for QGIS label positions
• public.landings_label (preview | json)
  lmb - points for landings labels - used on prototype map
• public.landuse (preview | json)
• public.lushotseed_place_names_kitsap_peninsula (preview | json)
  lmb - Lushotseed - imported from their My Google Maps or something
• public.ohm_building_blakely (preview | json)
  lmb - Port Blakely project - buildings - don't know this corresponds to OHM data
• public.ohm_pier_blakely (preview | json)
  lmb - Port Blakely project - just two wharfs
• public.parcels (preview | json)
  lmb - parcels - imported from COBI or Kitsap ArcGIS server
• public.parcels_qgis (preview | json)
• public.parks (preview | json)
• public.poi_things_qgis (preview | json)
• public.public_bookcase (preview | json)
• public.random_shit (preview | json)
  lmb - prototype project - all sorts, esp. our own place labels (marine, neighborhoods)
• public.road_ends (preview | json)
  mostly COBI data on road ends from their ArcGIS server
• public.roads (preview | json)
• public.roads_qgis (preview | json)
• public.thing_geometries_linestring_qgis (preview | json)
• public.thing_geometries_multipolygon_label_qgis (preview | json)
• public.thing_geometries_multipolygon_qgis (preview | json)
• public.thing_label_render (preview | json)
• public.thing_relationship_qgis (preview | json)
  One row per thing_relationship triple with both endpoints' identity, concept glyph, and a synthesized LineString geometry (ST_MakeLine of the two things' points) connecting subject to object -- the real data source for drawing relationship lines on the map, replacing the hardcoded K18/K1 prototype in lmb-maptwo/map.js. Plain view, not materialized, per Toby's request -- refresh cost is just thing_relationship's own sync (see sync_thing_relationships in lmb-sdk) plus two indexed joins, no separate REFRESH step needed. Skips either-geom-null rows outright (a relationship whose subject or object has no thing.geom set can't draw a line), and skips any relationship involving K1 (Bainbridge Island itself, kid=1) -- too coarse an endpoint to draw a useful line to/from (e.g. R38 location to the island itself would stretch across the whole map); the underlying thing_relationship triple is untouched, this is purely a rendering exclusion. subject_glyph/object_glyph are LEFT JOINed from concept_qgis (via lmb_has_type_cid) since a thing may have no concept assigned at all -- NULL, not a missing row, in that case. forward_phrase/inverse_phrase (not heading/inverse_heading) are the real verb-phrase sentence form -- "{subject_label} {forward_phrase} {object_label}" reads as an actual sentence, e.g. "Helix House is part of Naval Radio Transmitting Station Battle Point".
• public.trail_routes (preview | json)
• public.trails (preview | json)
• public.trails_qgis (preview | json)
• public.transportation (preview | json)
• public.transportation_qgis (preview | json)
• public.trees (preview | json)
• public.umap_historic_buildings_2025 (preview | json)
  lmb - old historic buildings points - get into thing
• public.umap_significant_trees (preview | json)
  lmb - trees project - based on COBI heritage tress and Ribiero too I think
• public.water (preview | json)
• public.water_qgis (preview | json)
• public.waterways (preview | json)
• public.wetlands (preview | json)

Function Layers