Office labeling edits - Githubissues

NYCPlanning / db-facilities-old

This repo contains all the scripts used to build the City Planning Facilities Database (FacDB). Please note this database and its build and maintenance processes are still in active development.

https://capitalplanning.nyc.gov/facilities

5 stars 3 forks source link

Office labeling edits #228

Open hannahkates opened 7 years ago

hannahkates commented 7 years ago

Change facsubgrp "Offices" to "Government Offices"
Concat agency name + office for facname

hannahkates commented 6 years ago

It would be preferred to use the FacDB agency abbreviation, instead of DCAS's agency field. For example, DCAS calls DCP "PLAN", so our offices show up as "PLAN Office" which could be confusing for users. This facname fix could happen as an UPDATE command after the insert.

SELECT DISTINCT facname FROM facilities WHERE facsubgrp LIKE '%Government Offices%' AND facname LIKE '% Office' ORDER BY facname