pg_tileserv
Service Metadata
Table Layers
-
_template.cabinets (preview | json)
Signal, ITS, splice/FDP, and hub cabinets (source: Cabinets dsId 127)
-
_template.changesets (preview | json)
-
_template.channel_territory (preview | json)
-
_template.comm_cable (preview | json)
Communication cables — fiber, ethernet, wireless links (source: CommCable dsId 100)
-
_template.comm_fdp (preview | json)
Fiber distribution panels (source: CommFDP dsId 102)
-
_template.comm_splice_point (preview | json)
Splice enclosures and termination points (source: CommSplicePoint dsId 101)
-
_template.device_link (preview | json)
Device-to-device connections: wireless P2P, ethernet, serial, coax links between device_port pairs
-
_template.electrical_cable (preview | json)
Electrical power cables (source: ElectricalCable dsId 107)
-
_template.electrical_term (preview | json)
Power meters, sub panels, solar panels (source: ElectricalTerm dsId 106)
-
_template.fiber_break (preview | json)
-
_template.locate_submission (preview | json)
One row per 811 Locate Export run: who, when, owner filter, scope, options, counts, output file. The audit artifact for partial-replacement submissions.
-
_template.map_annotations (preview | json)
Spatial annotations/comments for collaborative issue reporting and notes
-
_template.network_device (preview | json)
Network device registry — switches, cameras, DMS, signal controllers with spatial location
-
_template.planning_level_fiber (preview | json)
Planning-level fiber corridor segments (source: PlanningLevelFiber dsId 147)
-
_template.project (preview | json)
Project boundaries — defines scope for fiber construction/maintenance projects
-
_template.project_asset_event (preview | json)
Plan 17a §4 — append-only progress log. Mistakes corrected via voided_at/voided_by/void_reason — voided rows excluded from current-status derivation and trigger-driven writebacks. supersedes_event_fk optionally chains a corrective event to the voided one.
-
_template.reference_features (preview | json)
-
_template.reference_layers (preview | json)
-
_template.structure_line (preview | json)
Conduit, duct bank, messenger spans, cable tray (source: StructureLine dsId 134)
-
_template.structure_point (preview | json)
Junctions, poles, aerial infrastructure (source: StructurePoint dsId 128)
-
_template.structure_polygon (preview | json)
Buildings, site locations (source: StructurePolygon dsId 136)
-
_template.v_cable_utilization (preview | json)
Cable details with decoded domain labels and strand utilization metrics
-
_template.v_corridor_summary (preview | json)
Flattened planning corridor view with pivoted evaluation criteria and computed scores for QGIS symbology
-
_template.v_device_connection_detail (preview | json)
Flattened device → port → FDP → strand view with decoded lookups for connection tracing
-
_template.v_device_port_utilization (preview | json)
Per-device port utilization summary: total, active, available, connected, uplink, and FDP-linked counts
-
_template.v_fdp_port_detail (preview | json)
FDP port allocation with decoded domain values and parent FDP location
-
_template.v_fiber_break_active (preview | json)
-
_template.v_map_annotations_active (preview | json)
Top-level annotations (open/ack/resolved/dismissed). Web client controls resolved/dismissed visibility via legend toggles.
-
_template.v_map_annotations_centroids (preview | json)
Representative point per non-point annotation (ST_PointOnSurface). Drives low-zoom icon layer; fades out as native geometry takes over at high zoom.
-
_template.v_segment_priority (preview | json)
Segment-level weighted priority with capacity/age/ops multipliers and opportunity scoring
-
_template.v_splice_orphan_count (preview | json)
-
_template.v_splice_unconnected (preview | json)
Per-splice rows for splices with no non-orphaned connections — drives the map overlay (amber ring/dot on splices still needing connections). Carries lifecycle_status so the overlay can hide proposed splices by default.
-
cdot._bak_f01151_20260828 (preview | json)
-
cdot.cabinets (preview | json)
-
cdot.changesets (preview | json)
-
cdot.channel_territory (preview | json)
-
cdot.comm_cable (preview | json)
-
cdot.comm_fdp (preview | json)
-
cdot.comm_splice_point (preview | json)
-
cdot.device_link (preview | json)
-
cdot.electrical_cable (preview | json)
-
cdot.electrical_term (preview | json)
-
cdot.fiber_break (preview | json)
-
cdot.locate_submission (preview | json)
One row per 811 Locate Export run: who, when, owner filter, scope, options, counts, output file. The audit artifact for partial-replacement submissions.
-
cdot.map_annotations (preview | json)
-
cdot.network_device (preview | json)
-
cdot.planning_geography (preview | json)
-
cdot.planning_level_fiber (preview | json)
-
cdot.project (preview | json)
-
cdot.project_asset_event (preview | json)
-
cdot.reference_features (preview | json)
-
cdot.reference_layers (preview | json)
-
cdot.signal (preview | json)
-
cdot.signal_geom_local (preview | json)
Locally-held signal geometry and agency drift (ticket 19, mig 20260821_011). claimed_at NOT NULL means signal.geom is OURS and fn_signal_merge skips it. agency_geom is the last point upstream published and the baseline for moved_ft. A row exists only for a claimed signal or one that has drifted.
-
cdot.signal_src_existing (preview | json)
-
cdot.signal_src_future (preview | json)
-
cdot.structure_line (preview | json)
-
cdot.structure_point (preview | json)
-
cdot.structure_polygon (preview | json)
-
cdot.v_cable_utilization (preview | json)
-
cdot.v_device_connection_detail (preview | json)
-
cdot.v_device_port_utilization (preview | json)
-
cdot.v_fdp_port_detail (preview | json)
-
cdot.v_fiber_break_active (preview | json)
-
cdot.v_map_annotations_active (preview | json)
-
cdot.v_map_annotations_centroids (preview | json)
-
cdot.v_planning_fiber_styled (preview | json)
pg_tileserv styling source (UX redesign 4.3): planning fiber + representative enrollment scope_code + owning project status. Drafts have NULL scope_code; Promoted-project lines carry is_promoted = TRUE (default-hidden on the web map per D6).
-
cdot.v_shared_ncdot_cabinets (preview | json)
-
cdot.v_shared_ncdot_comm_cable (preview | json)
-
cdot.v_shared_ncdot_comm_fdp (preview | json)
-
cdot.v_shared_ncdot_comm_splice_point (preview | json)
-
cdot.v_shared_ncdot_network_device (preview | json)
-
cdot.v_shared_ncdot_structure_line (preview | json)
-
cdot.v_shared_ncdot_structure_point (preview | json)
-
cdot.v_signal_connectivity (preview | json)
-
cdot.v_signal_profile (preview | json)
-
cdot.v_signal_reconcile (preview | json)
-
cdot.v_splice_orphan_count (preview | json)
-
cdot.v_splice_unconnected (preview | json)
-
concord.cabinets (preview | json)
-
concord.changesets (preview | json)
-
concord.channel_territory (preview | json)
-
concord.comm_cable (preview | json)
-
concord.comm_fdp (preview | json)
-
concord.comm_splice_point (preview | json)
-
concord.device_link (preview | json)
-
concord.electrical_cable (preview | json)
-
concord.electrical_term (preview | json)
-
concord.fiber_break (preview | json)
-
concord.locate_submission (preview | json)
One row per 811 Locate Export run: who, when, owner filter, scope, options, counts, output file. The audit artifact for partial-replacement submissions.
-
concord.map_annotations (preview | json)
-
concord.network_device (preview | json)
-
concord.planning_geography (preview | json)
-
concord.planning_level_fiber (preview | json)
-
concord.project (preview | json)
-
concord.project_asset_event (preview | json)
-
concord.reference_features (preview | json)
-
concord.reference_layers (preview | json)
-
concord.signal (preview | json)
-
concord.signal_geom_local (preview | json)
Locally-held signal geometry and agency drift (ticket 19, mig 20260821_011). claimed_at NOT NULL means signal.geom is OURS and fn_signal_merge skips it. agency_geom is the last point upstream published and the baseline for moved_ft. A row exists only for a claimed signal or one that has drifted.
-
concord.structure_line (preview | json)
-
concord.structure_point (preview | json)
-
concord.structure_polygon (preview | json)
-
concord.v_cable_utilization (preview | json)
-
concord.v_corridor_summary (preview | json)
-
concord.v_device_connection_detail (preview | json)
-
concord.v_device_port_utilization (preview | json)
-
concord.v_fdp_port_detail (preview | json)
-
concord.v_fiber_break_active (preview | json)
-
concord.v_map_annotations_active (preview | json)
-
concord.v_map_annotations_centroids (preview | json)
-
concord.v_planning_fiber_styled (preview | json)
pg_tileserv styling source (UX redesign 4.3): planning fiber + representative enrollment scope_code + owning project status. Drafts have NULL scope_code; Promoted-project lines carry is_promoted = TRUE (default-hidden on the web map per D6).
-
concord.v_segment_priority (preview | json)
-
concord.v_signal_connectivity (preview | json)
-
concord.v_signal_profile (preview | json)
-
concord.v_signal_reconcile (preview | json)
-
concord.v_splice_orphan_count (preview | json)
-
concord.v_splice_unconnected (preview | json)
-
ncdot.cabinets (preview | json)
-
ncdot.changesets (preview | json)
-
ncdot.channel_territory (preview | json)
-
ncdot.comm_cable (preview | json)
-
ncdot.comm_fdp (preview | json)
-
ncdot.comm_splice_point (preview | json)
-
ncdot.device_link (preview | json)
-
ncdot.electrical_cable (preview | json)
-
ncdot.electrical_term (preview | json)
-
ncdot.fiber_break (preview | json)
-
ncdot.locate_submission (preview | json)
One row per 811 Locate Export run: who, when, owner filter, scope, options, counts, output file. The audit artifact for partial-replacement submissions.
-
ncdot.map_annotations (preview | json)
-
ncdot.network_device (preview | json)
-
ncdot.planning_level_fiber (preview | json)
-
ncdot.project (preview | json)
-
ncdot.project_asset_event (preview | json)
-
ncdot.reference_features (preview | json)
-
ncdot.reference_layers (preview | json)
-
ncdot.signal (preview | json)
-
ncdot.signal_geom_local (preview | json)
Locally-held signal geometry and agency drift (ticket 19, mig 20260821_011). claimed_at NOT NULL means signal.geom is OURS and fn_signal_merge skips it. agency_geom is the last point upstream published and the baseline for moved_ft. A row exists only for a claimed signal or one that has drifted.
-
ncdot.structure_line (preview | json)
-
ncdot.structure_point (preview | json)
-
ncdot.structure_polygon (preview | json)
-
ncdot.v_cable_utilization (preview | json)
-
ncdot.v_corridor_summary (preview | json)
-
ncdot.v_device_connection_detail (preview | json)
-
ncdot.v_device_port_utilization (preview | json)
-
ncdot.v_fdp_port_detail (preview | json)
-
ncdot.v_fiber_break_active (preview | json)
-
ncdot.v_map_annotations_active (preview | json)
-
ncdot.v_map_annotations_centroids (preview | json)
-
ncdot.v_segment_priority (preview | json)
-
ncdot.v_shared_cdot_cabinets (preview | json)
-
ncdot.v_shared_cdot_comm_cable (preview | json)
-
ncdot.v_shared_cdot_comm_fdp (preview | json)
-
ncdot.v_shared_cdot_comm_splice_point (preview | json)
-
ncdot.v_shared_cdot_network_device (preview | json)
-
ncdot.v_shared_cdot_structure_line (preview | json)
-
ncdot.v_shared_cdot_structure_point (preview | json)
-
ncdot.v_signal_connectivity (preview | json)
-
ncdot.v_signal_profile (preview | json)
-
ncdot.v_signal_reconcile (preview | json)
-
ncdot.v_splice_orphan_count (preview | json)
-
ncdot.v_splice_unconnected (preview | json)
-
ncdot_ext.county_boundaries (preview | json)
-
ncdot_ext.division_boundaries (preview | json)
-
ncdot_ext.its_devices (preview | json)
-
ncdot_ext.municipal_boundaries (preview | json)
Incorporated-place (city limits) polygons mirrored from US Census TIGERweb, not from NCDOT. Feeds the tighter tier of the per-schema map focus (schema_config.focus_places holds GEOIDs). Census vintage: generalised and lagging annexations -- display only, never authoritative for legal or billing use. Reload: python etl/municipal/load_places.py.
-
ncdot_ext.road_characteristics (preview | json)
-
ncdot_ext.signal_system_hulls (preview | json)
-
ncdot_ext.stip_projects_line (preview | json)
-
ncdot_ext.stip_projects_point (preview | json)
-
ncdot_ext.traffic_signals (preview | json)
-
public.project_geom_backup_20260626 (preview | json)
Function Layers