San Diego Point In Time Count 2018, Tracts

Unsheltered counts per tract and sheltered counts per facility, for 2018 San Diego Point in Time Count of homeless.

rtfhsd.org-pitc-2018-4

Resources

Documentation

This dataset includes the sheltered and unsheltered homeless counts from the San Diego Continuum of Care, CA-601.

Caveats

The sheltered count, sheltered_2018, is based on a data extract from HUD, and is similar, although not exactly, the same as the 2018 records for CA-601 from the official HUD HIC dataset, which has been packaged to combine multiple years. . The sheltered_2018 resource in this dataset differs from the HUD dataset in two rows ( 336790, 347741 ) which appear to have been removed in an update made after source file for sheltered_2018 was extracted. However, the PITC beds for the removed rows appear to have been re-allocated, because both datasets have the same value for the sum of the pit_count variable. For many analytical uses, these datasets will be identical.

However, the HUD HIC file has many columns that the sheltered_2018 file does not, including street addresses for the facilities

Versions

  1. Initial Version
  2. Added descriptions to data dictionary

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/rtfhsd.org-pitc-2018-4.zip')

# Create Dataframes

unsheltered_2018_df = pkg.resource('unsheltered_2018').dataframe()
sheltered_2018_df = pkg.resource('sheltered_2018').dataframe()

Data Dictionary

unsheltered_2018 | sheltered_2018

unsheltered_2018

Column NameData TypeDescription
geoidstringTract Geoid
tractstringTract number
communitystringCommunity Name where tract is located
countnumberCount of unsheltered homless

sheltered_2018

Column NameData TypeDescription
rowintegerRow #
yearintegerYear
proj_typestringProj. Type
organization_namestringOrganization Name
project_namestringProject Name
geo_codeintegerGeo Code
inventory_typestringInventory Type
bed_typestringBed Type
target_pop_astringTarget Pop. A
target_pop_bstringTarget Pop. B
beds_hh_w_childrenintegerBeds HH w/ Children
units_hh_w_childrenintegerUnits HH w/ Children
beds_hh_w_o_childrenintegerBeds HH w/o Children
beds_hh_w_only_childrenintegerBeds HH w/ only Children
veteran_beds_hh_w_childrenintegerVeteran Beds HH w/ Children
youth_beds_hh_w_childrenintegerYouth Beds HH w/ Children
ch_beds_hh_w_childrenintegerCH Beds HH w/ Children
veteran_beds_hh_w_o_childrenintegerVeteran Beds HH w/o Children
youth_beds_hh_w_o_childrenintegerYouth Beds HH w/o Children
ch_beds_hh_w_o_childrenintegerCH Beds HH w/o Children
ch_beds_hh_w_only_childrenintegerCH Beds HH w/ only Children
additional_federal_funding_hud_vashstringAdditional Federal Funding: HUD-VASH
additional_federal_funding_ssvfstringAdditional Federal Funding: SSVF
additional_federal_funding_gpdstringAdditional Federal Funding: GPD
additional_federal_funding_gpd_bhstringAdditional Federal Funding: GPD-BH
additional_federal_funding_gpd_ldstringAdditional Federal Funding: GPD-LD
additional_federal_funding_gpd_hhstringAdditional Federal Funding: GPD-HH
additional_federal_funding_gpd_ctstringAdditional Federal Funding: GPD-CT
additional_federal_funding_gpd_sithstringAdditional Federal Funding: GPD-SITH
additional_federal_funding_gpd_tpunknownAdditional Federal Funding: GPD-TP
additional_federal_funding_hchvstringAdditional Federal Funding: HCHV
additional_federal_funding_hchv_crsunknownAdditional Federal Funding: HCHV-CRS
additional_federal_funding_hchv_shunknownAdditional Federal Funding: HCHV-SH
additional_federal_funding_cwt_trstringAdditional Federal Funding: CWT/TR
additional_federal_funding_bcpstringAdditional Federal Funding: BCP
additional_federal_funding_tlpstringAdditional Federal Funding: TLP
additional_federal_funding_mghstringAdditional Federal Funding: MGH
additional_federal_funding_hopwastringAdditional Federal Funding: HOPWA
additional_federal_funding_hopwa_hmvunknownAdditional Federal Funding: HOPWA-HMV
additional_federal_funding_hopwa_phstringAdditional Federal Funding: HOPWA-PH
additional_federal_funding_hopwa_stsfunknownAdditional Federal Funding: HOPWA-STSF
additional_federal_funding_hopwa_thstringAdditional Federal Funding: HOPWA-TH
additional_federal_funding_pihstringAdditional Federal Funding: PIH
additional_federal_funding_otherstringAdditional Federal Funding: Other
housing_typetextHousing Type
mckinney_vento_esgstringMcKinney- Vento: Esg
mckinney_vento_esgesstringMcKinney- Vento: EsgEs
mckinney_vento_esgrrhstringMcKinney- Vento: EsgRrh
mckinney_vento_cocstringMcKinney- Vento: Coc
mckinney_vento_cocshstringMcKinney- Vento: CocSh
mckinney_vento_cocthstringMcKinney- Vento: CocTh
mckinney_vento_cocpshstringMcKinney- Vento: CocPsh
mckinney_vento_cocrrhstringMcKinney- Vento: CocRrh
mckinney_vento_cocsrostringMcKinney- Vento: CocSro
mckinney_vento_spcstringMcKinney- Vento: SpC
mckinney_vento_s8stringMcKinney- Vento: S8
mckinney_vento_shpstringMcKinney- Vento: Shp
year_round_bedsintegerYear-Round Beds
hmis_beds_hh_w_childrenintegerHMIS Beds HH w/ Children
hmis_beds_hh_w_o_childrenintegerHMIS Beds HH w/o Children
hmis_beds_hh_w_only_childrenintegerHMIS Beds HH w/ only Children
pct_of_hmis_beds_hh_with_childreninteger% of HMIS Beds HH with Children
pct_of_hmis_beds_hh_without_childreninteger% of HMIS Beds HH without Children
pct_of_hmis_beds_hh_w_only_childreninteger% of HMIS Beds HH w/ only Children
total_seasonal_bedsintegerTotal Seasonal Beds
seasonal_beds_available_in_hmisintegerSeasonal Beds Available in HMIS
availability_start_dateintegerAvailability Start Date
availability_end_dateintegerAvailability End Date
overflow_bedsintegerOverflow Beds
hmis_overflow_bedsintegerHMIS Overflow Beds
pit_countintegerPIT Count
total_bedsintegerTotal Beds
utilization_ratenumberUtilization Rate
last_update_onnumberLast Update On

References

Urls used in the creation of this data package.

  • file:data/pitc-2018.csv# &encoding=ascii.
  • pitc_2018_pdf (no longer available). PDF document from which pitc_2018_source data were scraped

Last Modified 2019-07-17T16:32:44

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/rtfhsd.org-pitc-2018-4.zip')

# Create Dataframes

unsheltered_2018_df = pkg.resource('unsheltered_2018').dataframe()
sheltered_2018_df = pkg.resource('sheltered_2018').dataframe()