Skip to content

Instantly share code, notes, and snippets.

@mtreg
Last active May 8, 2017 15:37
Show Gist options
  • Save mtreg/1389b23c4cf2984d37764cdd3b3577a7 to your computer and use it in GitHub Desktop.
Save mtreg/1389b23c4cf2984d37764cdd3b3577a7 to your computer and use it in GitHub Desktop.
FacDB pgtable Unique Entries
pgtable
usnps_facilities_parks
usdot_facilities_airports
dcas_facilities_colp;dot_facilities_parkingfacilities
dcas_facilities_colp;omb_facilities_libraryvisits
bic_facilities_tradewaste
dfta_facilities_contracts;hhs_facilities_proposals
acs_facilities_daycareheadstart;doe_facilities_universalprek;dohmh_facilities_daycare
doe_facilities_schoolsbluebook;hhs_facilities_proposals
nycdoc_facilities_corrections
hrpt_facilities_sfpsd
acs_facilities_daycareheadstart;dcas_facilities_colp;hhs_facilities_financialscontracts
nysparks_facilities_historicplaces
sbs_facilities_workforce1
dcas_facilities_colp;hhs_facilities_financialscontracts
dcas_facilities_colp;dsny_facilities_mtsgaragemaintenance
fbop_facilities_corrections
uscourts_facilities_courts
dcas_facilities_colp;nycdep_facilities_sfpsd
hhs_facilities_proposals
amtrak_facilities_sfpsd
dcas_facilities_colp;nycdoc_facilities_corrections
dcas_facilities_colp;dfta_facilities_contracts;hhs_facilities_proposals
rioc_facilities_sfpsd
dcla_facilities_culturalinstitutions
acs_facilities_daycareheadstart;hhs_facilities_financialscontracts
doe_facilities_schoolsbluebook
dycd_facilities_compass
dycd_facilities_otherprograms;hhs_facilities_financialscontracts
dot_facilities_parkingfacilities
dcas_facilities_colp;dot_facilities_mannedfacilities
nysomh_facilities_mentalhealth
dcas_facilities_colp;dcla_facilities_culturalinstitutions;nysed_facilities_activeinstitutions
dcas_facilities_colp;dfta_facilities_contracts
doe_facilities_universalprek;dohmh_facilities_daycare
dot_facilities_mannedfacilities
doe_facilities_schoolsbluebook;nysed_facilities_activeinstitutions
dca_facilities_operatingbusinesses
dcas_facilities_colp;dcla_facilities_culturalinstitutions
nysdec_facilities_solidwaste
dhs_facilities_shelters
nysdot_facilities_sfpsd
nycdep_facilities_sfpsd
dot_facilities_pedplazas
dsny_facilities_mtsgaragemaintenance
dcas_facilities_colp;nycourts_facilities_courts
nycha_facilities_policeservice
dcla_facilities_culturalinstitutions;nysed_facilities_activeinstitutions
acs_facilities_daycareheadstart
hhs_facilities_financialscontracts
doe_facilities_busroutesgarages
dca_facilities_operatingbusinesses;nysdec_facilities_solidwaste
dcas_facilities_colp;doe_facilities_schoolsbluebook;nysed_facilities_activeinstitutions
acs_facilities_daycareheadstart;dcas_facilities_colp
dfta_facilities_contracts
nysoasas_facilities_programs
tgi_facilities_sfpsd
bbpc_facilities_sfpsd
dycd_facilities_otherprograms
dcas_facilities_colp
acs_facilities_daycareheadstart;dohmh_facilities_daycare
acs_facilities_daycareheadstart;doe_facilities_universalprek
dpr_parksproperties
nysocfs_facilities_facilities
dycd_facilities_otherprograms;hhs_facilities_proposals
dcas_facilities_colp;mta_facilities_sfpsd
dcas_facilities_colp;nysdec_facilities_solidwaste
nysopwdd_facilities_providers
dcas_facilities_colp;nysed_facilities_activeinstitutions
panynj_facilities_sfpsd
nycourts_facilities_courts
dot_facilities_bridgehouses
nysdoccs_facilities_corrections
hra_facilities_centers
mta_facilities_sfpsd
dcas_facilities_colp;doe_facilities_schoolsbluebook
foodbankny_facilities_foodbanks
bic_facilities_tradewaste;nysdec_facilities_solidwaste
omb_facilities_libraryvisits
Agencies listed by abbreviation:
datasource
NYCACS;NYCDCAS;NYCHHS
USCOURTS
NYCACS;NYCDOE
NYCDCA
MTA;NYCDCAS
NYCDCAS;NYCDCLA;NYSED
NYSOPRHP
NYCACS;NYCHHS
PANYNJ
BBPC
NYCOURTS
NYCDCAS;NYCDFTA;NYCHHS
NYCHRA/DSS
NYCDFTA
NYCACS;NYCDOHMH
NYCDCAS;NYCDEP
NYCDCAS;NYCDOE
NYCDEP
HRPT
USNPS
NYSDOH
FBNYC
MTA
NYCHHS
NYCDOE;NYCDOHMH
FBOP
NYCDOE;NYSED
NYSOASAS
NYCDHS
NYCDCAS;NYCOMB
NYCDCAS;NYCDOE;NYSED
NYCDCAS
Amtrak
NYSDOCCS
NYCDOC
NYCDCAS;NYCDPR
NYCDCAS;NYCDOT
NYSDOT
NYCDYCD
TGI
NYSOPWDD
NYSOCFS
NYSDEC
NYCDOHMH
NYCDFTA;NYCHHS
NYCDCA;NYSDEC
NYCDCAS;NYCDSNY
NYCOMB
NYCDCAS;NYCHHS
NYCDOE;NYCHHS
NYCDCAS;NYCDFTA
NYCACS
NYCDPR
NYCACS;NYCDCAS
NYCBIC;NYSDEC
USDOT
NYCDCAS;NYCDOC
NYSOMH
NYCDCAS;NYCDCLA
NYCDOT
NYCDYCD;NYCHHS
RIOC
NYCHA
NYCDCAS;NYCOURTS
NYCDCLA
NYCDCAS;NYSED
NYSED
NYCSBS
NYCACS;NYCDOE;NYCDOHMH
NYCDCLA;NYSED
NYCDCAS;NYSDEC
NYCACS;NYCDCAS;NYCDOHMH
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment