NCNYC Civil Title Viewer
Profiles of NYC civil-service titles — descriptions, positions, roles and pay. Began as a standalone experiment and now lives as Databook’s titles section.
DA
activeopen government
Databook
An award-winning transparency tool that combines over 50 official NYC open datasets — agencies, people, jobs, capital projects, schools, districts and procurement — into one searchable picture of how city government works.
DASubprojects
In the open
Activity
Jul 30It also updates the liveness probe to use the unauthenticated `/health` endpoint and adds a script to generate the required credentials.wegovnyc/databook-private ↗Jul 30This pull request adds a documentation plan to establish the Postgres database as the authoritative system of record for the organization directory. It outlines a five-phase proposal to fix broken data refreshes, migrate parent links, build a new editing interface, and safely retire the legacy Airtable store.wegovnyc/databook-private ↗Jul 30Added a draft bug report documenting referential integrity issues in the OTI registry's "reports_to" field, where 17% of parent references match no published record. The report details the causes of these broken links and recommends publishing a machine-readable "reports_to_record_id" column to establish a stable, verifiable organizational hierarchy.wegovnyc/databook-private ↗Jul 30This update integrates OTI data to assign organization types and parent relationships, resolving all remaining synthetic hex IDs. It introduces a display_name field to show official OTI names without breaking URL paths or contract joins, and fixes four silent type-filtering bugs to improve data coverage.wegovnyc/databook-private ↗Jul 30This pull request adopts NYC's official agency registry by importing 133 missing OTI organizations and adding their attributes. It repairs 10,004 dangling organization IDs across 18 production tables, resolves a mapping issue for the NYC Districting Commission, and applies three database cleanup fixes.wegovnyc/databook-private ↗Jul 30Updated the API to read PostgreSQL credentials directly from the environment instead of the env.yaml file. This consolidates credential sourcing into a single, more secure location.wegovnyc/databook-private ↗Knowledge
No knowledge items yet.
Repositories
wegovnyc/databook_interfaceJan 26, 2022