County Planning Database

County Planning Database

sandiegodata.org-planning-tracts-6 Last Update: 2018-10-15T20:24:13

A collection of data for demographics and housing from the Census planning database. Files are broken into counties, for San Diego and Los Angeles

The Planing Database is a Census product that combines a range of data from the American Community Survey and 2010 Decenial Census into a single file, with one row per census tract. This version of the file includes only tracts in San Diego County. The file is linked to ACS format geoids to identify tracts, so it can be easily linked to other tracts data. This data package includes links to two such files, one for San Diego communities, and one for tract geographics.

The planning database has about 450 columns. For full definitions of the columns, refer to the upstream documentation for the source file. In general, the column names in the documentation must be lowercased for use with the file in this data package.

In Python, use metapack to open the data package.

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegodata.org-planning-tracts-1.zip')

To display a simple map, link in the tract boundaries from the communities dataset and use the Geopandas .plot() function. The column argument names the column to use for coloring regions. Note that the column name is copied from the documentation with mixed case, then lowercased to index the dataset.

tracts = pkg.reference('communities').geoframe().set_index('geoid').fillna('')
df = tracts.join(cpdb)

fig, ax = plt.subplots(1, figsize=(15,10))
df.plot(ax=ax, column='pct_MLT_U10p_ACS_12_16'.lower())

After linking in the communities, you can also use the community id columns to group by city or community:

seniors = dfg.df.groupby('city_name').pop_65plus_acs_12_16.sum()
  1. First Release
  2. Clean more currency columns

Documentation Links

Contacts

Resources

References


Loading the ZIP Package

Zip packages are compressed, so large resources may load faster.

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegodata.org-planning-tracts-6.zip')

Loading the CSV Package

CSV packages load resources individually, so small resources may load faster.

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegodata.org-planning-tracts-6.csv')

Data and Resources

Additional Info

Field Value
Version 6
Last Updated October 15, 2018, 20:27 (UTC)
Created September 9, 2018, 22:36 (UTC)
root.ckanid 98027770-32e6-41ef-a72d-dd1b77c7f18e
root.created 2018-09-06T14:39:53
root.dataset planning
root.declare metatab-latest
root.description database. Files are broken into counties, for San Diego and Los Angeles
root.giturl https://github.com/sandiegodata/planning-database.git
root.grain tracts
root.group planning-project
root.identifier faecc038-4f5e-4524-8000-4b218b8a46bf
root.issued 2018-10-15T20:24:13
root.modified 2018-10-15T20:24:13
root.name sandiegodata.org-planning-tracts-6
root.origin sandiegodata.org
root.title County Planning Database
root.version 6