Community and City and Tract Boundaries in San Diego County

by metapack

Combines geographic boundary files for communities, cities and tracts in San Diego County.

sandiegodata.org-geography-2018-13

Resources

Documentation

This package combines three SANGIS datasets for communities and cities in San Diego county into a single file, in the communities resource, with Census tract definitions for San Diego count. The source files are:

Continue Reading →

San Diego Planning Database

by metapack

__

sandiegodata.org-planning-1

Resources

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/sandiegodata.org-planning-1.zip')
# CSV Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/sandiegodata.org-planning-1.csv') 

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

Data Dictionary

tracts | tract_links | community_boundaries | tract_diabetes | hpi | tract_boundaries | acs_pdb | tract_communities | business_sites | business_tract_counts | cen10_pdb

Continue Reading →

County Planning Database

by metapack

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

sandiegodata.org-planning-tracts-9

Resources

Documentation

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.

Continue Reading →

Gaslamp Homeless Counts

by metapack

Monthly homeless counts for the Gaslamp district in Downtown San Diego

downtownsandiego.org-homeless_count-gaslamp-2

Resources

Documentation

Since 2014, the Downtown San Diego Partnership has been conducting monthly counts of the homeless in the Downtown neighborhood. The positions of homeless sleepers are recorded on paper maps, which are compiled into a spreadsheet. The San Diego Regional Data Library is running a project to digitize these paper maps](https://downtown-homelesness.sandiegodata.org/) into geographic datasets.

This dataset covers only the Gaslamp district, from 2014-01-01 to 2018-06-28.

Continue Reading →

San Diego Pedestrian Counts

by metapack

Counts of pedestrian traffic from the San Diego CityIQ system

cityiq.io-pedestrians-san_diego-1

Resources

Documentation

This dataset is pedestrian directions and counts for walkwaks in the San Diego CityIQ system. The package includes pedestrian counts for most walkway locations in the San Diego CityIQ system, but not all of them. The date range for the data is 1 August 2018 to the last full month before the package was built. For Version 1, then end date is 1 June 2019.

Continue Reading →

San Diego City IQ Assets and Locations

by metapack

All assets types extracted form the San Diego City Iq system

cityiq.io-objects-san_diego-5. Modified 2020-04-12T16:44:03

Resources

Documentation

These datafile are extracts of the assets and locations from the San Diego CityIQ system. Refer to the [CityIQ developer documentation](<https://ie-cities-docs.run.aws-usw02-pr.ice.predix.io/#c_overview _of_general_apis.html>) for details about these data records. The data are extracted using the cityiq Python package. See the ExtractAssets.ipynb notebook for the extract process.

Continue Reading →

SDHC Meal Programs Data Collection

by metapack

A collection of files from other data packages, from the California Department of Education, for the San Diego Hunger Coalition’s Hunger Free Kids program

sandiegohungercoalition.org-meal_programs-1

Resources

Documentation

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Continue Reading →

Reimbursement Rates

by metapack

Child Nutrition Program meal program reimbursement rates.

cde.ca.gov-reimbursements-1.1.1. Modified 2021-03-11T00:14:44

Resources

Documentation

Reimbursement rates that were manually scraped from CDE web pages, then combined into this data package.

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Continue Reading →

CAASPP Test Results

by metapack

California Assessment of Student Performance and Progress

cde.ca.gov-caaspp-2015e-2.1.1. Modified 2022-08-09T20:25:49

Resources

Documentation

This dataset is a simple combination of multiple years of California Assessment of Student Performance and Progress (CAASPP) results, for the years 2015 on. The CAASPP was conducted in 2014, but the 2014 file has a different structure from other years ( it’s a “pp” file, see below) so it is excluded from this package.

Continue Reading →

Student Poverty FRPM Data

by metapack

Data files pertaining to students eligible for Free or Reduced Price Meals (FRPM).

cde.ca.gov-frpm-1.2.1. Modified 2021-03-11T00:51:02

Resources

Documentation

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Data Dictionary

combined | frp_meals

combined

Column NameData TypeDescription
yearinteger
academic_yearstringThe academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted to the California Longitudinal Pupil Achievement Data System (CALPADS) by districts and charter schools. Census Day or Information Day is always the first Wednesday in October.
county_codeintegerA unique two-digit code corresponding to the county.
county_namestring
district_codeintegerA unique five-digit code corresponding to the district.
district_namestringDistrict or Administrative Authority Name
district_typestring
school_codeintegerA unique seven-digit code corresponding to the school.
school_nametext
school_typestring
lea_namestringLocal educational agency (LEA) name.
charter_funding_typestringIndicates the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
charter_school_numberstringA four character value (any combination of numbers and letters) assigned to a charter school. A blank value indicates the school is not a charter school.
charter_school_y_nstringA “Y” or “N” value indicating whether a school is a charter school in the current academic year.
direct_funded_charter_school_numberstring
low_gradestring
high_gradestring
educational_option_typestring
ircstring
fund_typestring
nslp_provision_2_or_3_schoolstringA Y or N value to indicate whether a school is on a National School Lunch Program (NSLP) provision 2 or 3 status. “Y” indicates the school is on a provisional status; “N” indicates the school is not. For more information on provision status, please refer to the United States Department of Agriculture (USDA) Food Nutrition Service Web page External link opens in new window or tab..
nslp_provision_statusstring
provision_2_or_3_school_y_nstring
calpads_enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
calpads_enrollment_k_12integer
enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
enrollment_k_12integerA total count of K-12 students enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
calpads_fall_1_certification_statusstringA Y or N value to indicate whether data were submitted and certified in CALPADS. No data are provided where the certification status is “N”.
free_meal_countstring
free_meal_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free meals based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The Free Meal Count (K-12) is not displayed on any CALPADS report; however, this count represents the official Free Meal Count (K-12) for the academic year.
frpm_countintegerOf the Enrollment (Ages 5-17), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (Ages 5-17) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count with the 5-17 Year Olds filter applied; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (Ages 5-17) for the academic year.
frpm_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (K-12) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (K-12) for the academic year.
frpm_total_unduplicated_countstringOf the students (Ages 5–17) enrolled in the school, the total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
frpm_total_unduplicated_count_k_12stringOf the students (K–12) enrolled in the school, the total unduplicated count of who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
percent_eligible_freenumberThe percent of students eligible for free meals. [Free Meal Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
percent_eligible_free_k_12numberThe percent of students eligible for free meals. [Free Meal Count (K-12) divided by Enrollment (K-12)].
percent_eligible_frpmnumberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
percent_eligible_frpm_k_12numberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (K-12) divided by Enrollment (K-12)].
percent_frpmnumber
reduced_price_mealsinteger
total_frpminteger
unadjusted_free_meal_countinteger
unadjusted_free_meal_count_k_12integer
unadjusted_frpm_countintegerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free meals. Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility – Count.
unadjusted_frpm_count_k_12integerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free or reduced price meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free & Reduced Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility - Count.
data_source_for_frpmstring
data_source_for_provision_2_or_3_schoolstringThis indicates the data source for Provision 2 or 3 school data. “NSD” indicates that the data are sourced from October 2012 claim data submitted to the CDE’s Nutrition Services Division (NSD); “CARS” indicates that the data are sourced from base percentages that LEAs certified in the Consolidated Application and Reporting System (CARS) in 2011–12. Since only percentages were collected for Provision 2 and 3 schools, a value of “NULL” is displayed instead of counts of students eligible for these schools.

frp_meals

Column NameData TypeDescription
county_codeintegerA unique two-digit code corresponding to the county.
district_codeintegerA unique five-digit code corresponding to the district.
school_codeintegerA unique seven-digit code corresponding to the school.
charter_school_numberintegerA four character value (any combination of numbers and letters) assigned to a charter school. A blank value indicates the school is not a charter school.
charter_funding_typestringIndicates the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
lea_namestringLocal educational agency (LEA) name.
school_nametext
low_gradestring
high_gradeinteger
enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
free_meal_countinteger
reduced_price_mealsinteger
total_frpminteger
percent_frpmnumber
county_namestring
data_source_for_frpmstring
academic_yearstringThe academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted to the California Longitudinal Pupil Achievement Data System (CALPADS) by districts and charter schools. Census Day or Information Day is always the first Wednesday in October.
provision_2_or_3_school_y_nstring
data_source_for_provision_2_or_3_schoolstringThis indicates the data source for Provision 2 or 3 school data. “NSD” indicates that the data are sourced from October 2012 claim data submitted to the CDE’s Nutrition Services Division (NSD); “CARS” indicates that the data are sourced from base percentages that LEAs certified in the Consolidated Application and Reporting System (CARS) in 2011–12. Since only percentages were collected for Provision 2 and 3 schools, a value of “NULL” is displayed instead of counts of students eligible for these schools.
free_meal_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free meals based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The Free Meal Count (K-12) is not displayed on any CALPADS report; however, this count represents the official Free Meal Count (K-12) for the academic year.
percent_eligible_free_k_12numberThe percent of students eligible for free meals. [Free Meal Count (K-12) divided by Enrollment (K-12)].
frpm_total_unduplicated_count_k_12stringOf the students (K–12) enrolled in the school, the total unduplicated count of who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
percent_eligible_frpm_k_12numberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (K-12) divided by Enrollment (K-12)].
calpads_enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
percent_eligible_freenumberThe percent of students eligible for free meals. [Free Meal Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
nslp_provision_2_or_3_schoolstringA Y or N value to indicate whether a school is on a National School Lunch Program (NSLP) provision 2 or 3 status. “Y” indicates the school is on a provisional status; “N” indicates the school is not. For more information on provision status, please refer to the United States Department of Agriculture (USDA) Food Nutrition Service Web page External link opens in new window or tab..
unadjusted_free_meal_count_k_12integer
unadjusted_frpm_count_k_12integerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free or reduced price meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free & Reduced Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility - Count.
frpm_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (K-12) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (K-12) for the academic year.
unadjusted_free_meal_countinteger
unadjusted_frpm_countintegerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free meals. Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility – Count.
frpm_countintegerOf the Enrollment (Ages 5-17), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (Ages 5-17) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count with the 5-17 Year Olds filter applied; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (Ages 5-17) for the academic year.
calpads_fall_1_certification_statusstringA Y or N value to indicate whether data were submitted and certified in CALPADS. No data are provided where the certification status is “N”.
district_typestring
school_typestring
educational_option_typestring
nslp_provision_statusstring
charter_school_y_nstringA “Y” or “N” value indicating whether a school is a charter school in the current academic year.
ircstring

References

Urls used in the creation of this data package.

Continue Reading →