San Diego County Total Maximum Daily Load

by metapack

TMDL data for San Diego county, through September 2015.

ceden.waterboards.ca.gov-tmdl-sandiego-2

Resources

  • tmdl-sd. San Diego Total Maximum Daily Load data

Documentation

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Packages

Accessing Packages in Metapack

import metapack as mp
# ZIP Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/ceden.waterboards.ca.gov-tmdl-sandiego-2.zip')
# CSV Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/ceden.waterboards.ca.gov-tmdl-sandiego-1.csv') 

resource = pkg.resource('resource_name') # Get a resource
df = resource.dataframe() # Create a pandas Dataframe
gdf = resource.geoframe() # Create a GeoPandas GeoDataFrame

Last Modified 2018-08-09T14:59:16

Continue Reading →

San Diego Coastkeeper Water Monitoring

by metapack

Monitoring measurements for San Diego creeks. Temperature, pH, conductivity, bacteria, turbidity and nutrients.

ceden.waterboards.ca.gov-sdck_monitoring-2

Resources

Documentation

This dataset is San Diego Costkeeper’s submission to CEDEN of almost 10 years of water monitoring in San Diego county creeks, rivers and wetlands.

See the Water project’s station map for a view of the loacations of the monitoring stations.

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Packages

Accessing Packages in Metapack

import metapack as mp
# ZIP Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/ceden.waterboards.ca.gov-sdck_monitoring-2.zip')
# CSV Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/ceden.waterboards.ca.gov-sdck_monitoring-1.csv') 

resource = pkg.resource('resource_name') # Get a resource
df = resource.dataframe() # Create a pandas Dataframe
gdf = resource.geoframe() # Create a GeoPandas GeoDataFrame

Last Modified 2018-08-22T20:15:00

Continue Reading →

San Diego Beachwatch Data

by metapack

Water quality data for San Diego county beaches.

ceden.waterboards.ca.gov-beachwatch-sandiego-2

Resources

Documentation

The Beachwatch data set has four bacteria measurements from 172 stations on the coast of San Diego county, from July 1998 to Decenber 2013. The four measurements are:

  • Coliform, Total 66992
  • Coliform, Fecal 65827
  • Enterococcus 65010
  • E. coli 4428

There are two units for the measurements:

  • MPN/100 mL: “Most Probable Number”
  • cfu/100mL: “Colony forming units”. Number of viable bacteria, excluding the dead ones.

From Cascade Analytical:

Continue Reading →

California Unemployment

by metapack

BLS employment measures for California

bls.gov-laus-ca-1

Resources

Documentation

This file is a conversion of the BLS Local Area Unemployment (LAUS) file for California. The conversion breaks out parts of the series_id code, and includes a Census ACS geoid for most areas.

Measure Codes

The measure_code value indicates the type of measure:

measure_code    measure_text
03              unemployment rate
04              unemployment
05              employment
06              labor force

Local Area Unemployment Statistics Series Identifier

The following is a sample format description of the Local Area Unemployment Statistics’ series identifier:

Continue Reading →

Water Quality Project Example Data

by metapack

Collection of example data for the Water Project

sandiegodata.org-water_project_data-1

Resources

Documentation

Data from a variety of sources for the Data Library’s summer water quality project.

Contacts

  • Wrangler

Eric Busboom, San Diego Regional Data Library

Packages

Last Modified 2019-05-15T21:58:23

Continue Reading →

US Civic Engagement, Large Cities, 2004 to 2011

by metapack

Per-capital volunteer hours. The values appear to be the number of hours volunteered in a year, per resident.

volunteeringinamerica.gov-civic_engagement-1

Resources

Documentation

Civic Engagement data for large US cities, from 2004 to 2011, extracted from http://www.volunteeringinamerica.gov/export.cfm

Continue Reading →

Trolley Ridership

by metapack

Trolley Ridership for Sept 2013

sandiego.gov-trolley_ridership-1

Resources

Documentation

Average weekday ridership for Trolley from the Fall/Winter 2013-2014 Booking. This is the average of each of the trips sampled during the entire booking (September 1, 2013 – January 25, 2014).

Tabs

  • By Trip and Stop – This is all the trips in the day sorted by route, trip time, and the stop order
  • By Stop – Sum of all data for each stop in each direction for each route
  • By Trip – Sum of all the stops for each trip
  • By Route – Sum of all stops for each route

Provided via email by Rob Schupp, Director of Marketing and Communications, Metropolitan Transit System

Continue Reading →

SANDAG Traffic Data

by metapack

A collection of shapefiles use as inputs to the SANDAG traffic model, for a variety of years.

sandag.org-traffic_geo-1

Resources

Documentation

A collection of traffic data submitted to the Library through links to internal pages of the SANDAG website. We don’t really understand the provenance and metadata of the data, so use at your own risk.

Continue Reading →

SANDAG Average Daily Traffic Volumes 2006-2010

by metapack

SANDAG Average Daily Traffic Volumes 2006-2010

sandag.org-avg_traffic-2006e2010-1

Resources

Documentation

Average daily traffic volumes for street segments in SANDAG area cities. This file was received from SANDAG for Public Records Act request 13-048 on 19 April 2013.

The file is likely to be difficult to use, since the volumes are reported per street segment, with no fields for city or lat/lon. The file may be useful for extracting a small number of segments by hand, but automated use will require programatic linking to SANGIS road network data.

Continue Reading →

Private Schools in California

by metapack

Private Schools in California

cde.ca.gov-private_schools-1

Resources

Documentation

Conversions to CSV of the lists of private schools for the state of California, from [http://www.cde.ca.gov/ds/si/ps/].

Continue Reading →