"groups": [{"name": "access-to-health-care"}],
"notes": "Indicator: Cancer Mortality Rate. Source: Virginia Department of Health, Division of Health Statistics",
}
ind4_12 = {
"name": "infant-mortality",
"title": "Rate of Infant Mortality",
"groups": [{"name": "access-to-health-care"}],
"notes": "Indicator: Infant mortality rate per 1,000 live births. Source: Virginia Department of Health, Health Profile, Alexandria City, 2000-2009",
}
ind4_13 = {
"name": "teen-pregnancy",
"title": "Rate of Teen Pregnancy",
"groups": [{"name": "access-to-health-care"}],
"notes": "Indicator: Teen Pregnancy Rate (per 1000 girls). Source: Virginia Department of Health, Health Profile, Alexandria City, 2000-2009",
}
make_pkg(ind4_1)
make_pkg(ind4_2)
make_pkg(ind4_3)
make_pkg(ind4_4)
make_pkg(ind4_5)
make_pkg(ind4_6)
make_pkg(ind4_7)
make_pkg(ind4_8)
make_pkg(ind4_10)
make_pkg(ind4_11)
make_pkg(ind4_12)
make_pkg(ind4_13)
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import urllib2
import urllib
import json
import pprint
import ckan_api
from make_pkg import make_pkg
ind7_3 = {
"name" : "considered-suicide",
"title" : "Percent of Adolescents Who Reported That They Have Seriously Considered Suicide",
"groups" : [{"name" : "mental-health"}],
"notes" : "Source: Alexandria City Public Schools Youth Risk Behavior Survey, 2008 Final Report http://www.acps.k12.va.us/mes/reports/",
}
ind7_4 = {
"name" : "mentally-unhealthy-days",
"title" : "Mentally Unhealthy Days",
"groups" : [{"name" : "mental-health"}],
"notes" : "Indicator: Mentally Unhealthy Days per Month (mean). Source: BRFSS",
}
make_pkg(ind7_3)
make_pkg(ind7_4)
"group" : "Meeting Basic Needs",
"notes" : "Median gross rent",
}
ind2_5_dict = {
"name" : "foreclosure-by-type",
"title" : "Foreclosure",
"group" : "Meeting Basic Needs",
"notes" : "Number of foreclosures by type of Real Estate",
}
ind2_6_dict = {
"name" : "snap",
"title" : "Food Stamps",
"group" : "Meeting Basic Needs",
"notes" : "Number of SNAP (formerly Food Stamp) participants",
}
ind2_7_dict = {
"name" : "school-lunch-elig",
"title" : "School Lunch",
"group" : "Meeting Basic Needs",
"notes" : "Number of students eligible for free and reduced-price school lunch",
}
#make_pkg(ind2_1_dict)
make_pkg(ind2_3_dict)
make_pkg(ind2_4_dict)
make_pkg(ind2_5_dict)
make_pkg(ind2_6_dict)
make_pkg(ind2_7_dict)
"groups" : [{"name" : "employment-opportunities"}],
"notes" : "Indicator: ACPS High School Graduation Rate. Source: Alexandria City Public Schools",
}
ind11_5 = {
"name" : "unemployment",
"title" : "Unemployment",
"groups" : [{"name" : "employment-opportunities"}],
"notes" : "Indicator: Unemployment at local level. Source: Bureau of Labor Statistics",
}
ind11_6 = {
"name" : "hs-diploma",
"title" : "High School Diploma",
"groups" : [{"name" : "employment-opportunities"}],
"notes" : "Indicator: % adults aged 25 and older with a high school diploma or GED. Source: 2000 Decennial Census, 2005-2010 1-Year ACS Samples",
}
ind11_7 = {
"name" : "retail-occupancy",
"title" : "Retail Occupancy",
"groups" : [{"name" : "employment-opportunities"}],
"notes" : "Indicator: % Retail Occupancy. Source: Alexandria Economic Development Partnership. Contact: Christina Mindrup Robinson, Alexandria Economic Development Partnership, [email protected]",
}
make_pkg(ind11_1)
make_pkg(ind11_2)
make_pkg(ind11_3)
make_pkg(ind11_4)
make_pkg(ind11_5)
make_pkg(ind11_6)
make_pkg(ind11_7)
import urllib
import json
import pprint
import ckan_api
from make_pkg import make_pkg
ind9_1 = {
"name" : "fruits-and-vegetables",
"title" : "Fruits and Vegetables",
"groups" : [{"name" : "food-and-nutrition"}],
"notes" : "Indicator: % adults who report eating 5 or more fruits/vegetables a day. Source: BRFSS",
}
ind9_3 = {
"name" : "wic",
"title" : "WIC Program Participation",
"groups" : [{"name" : "food-and-nutrition"}],
"notes" : "Indicator: % residents who access WIC program. Source: Virginia Department of Health http://www.vahealth.org/DCN/Reports/UI/Pages/DSReports.aspx",
}
ind9_4 = {
"name" : "foodborne-illness-complaints",
"title" : "Foodborne Illness Complaints",
"groups" : [{"name" : "food-and-nutrition"}],
"notes" : "Indicator: Average # of major deficiencies per food safety evaluation of food establishments in the city. Source: Alexandria Health Department",
}
make_pkg(ind9_1)
make_pkg(ind9_3)
make_pkg(ind9_4)
import json
import pprint
import ckan_api
from make_pkg import make_pkg
ind10_1 = {
"name": "air-quality",
"title": "Air Quality",
"groups": [{"name": "cleanliness-and-beautification"}],
"notes": "Indicator: Number of “Air Quality Action” days per year. Source: Environmental Quality Commission",
}
ind10_2 = {
"name": "environmental-health",
"title": "Environmental Health",
"groups": [{"name": "cleanliness-and-beautification"}],
"notes": "Indicator: Number of complaints to Environmental Health regarding perceived environmental hazards (mold, radon, toxic exposures, etc.) or pests (bedbugs, mosquitoes, ticks etc.). Source: Alexandria Health Department",
}
ind10_3 = {
"name": "recycling",
"title": "Recycling",
"groups": [{"name": "cleanliness-and-beautification"}],
"notes": "Indicator: % of solid waste recycled. Source: Environmental Quality Commission",
}
make_pkg(ind10_1)
make_pkg(ind10_2)
make_pkg(ind10_3)
"name" : "child-abuse",
"title" : "Child Abuse Rate",
"groups" : [{"name" : "crime-and-safety"}],
"notes" : "Indicator: Rate of substantiated cases of child abuse and neglect per 1,000 Alexandria children. Source: Alexandria Department of Community and Human Services (ADCHS), Center for Children and Families, Child Welfare Services",
}
ind6_3 = {
"name" : "violent-property-crimes",
"title" : "Violent and Property Crimes (Part 1)",
"groups" : [{"name" : "crime-and-safety"}],
"notes" : "Source: Alexandria Police Department",
}
ind6_4 = {
"name" : "nuisance-crimes",
"title" : "Nuisance Crimes",
"groups" : [{"name" : "crime-and-safety"}],
"notes" : "Source: Alexandria Police Department",
}
ind6_5 = {
"name" : "fire-response",
"title" : "Fire Response Time",
"groups" : [{"name" : "crime-and-safety"}],
"notes" : "Indicator: Percentage of residential fires confined to room of origin. Source: Alexandria Fire/EMS",
}
make_pkg(ind6_1)
make_pkg(ind6_3)
make_pkg(ind6_4)
make_pkg(ind6_5)
"title" : "Percent of Residents Biking to Work",
"groups" : [{"name" : "built-environment"}],
"notes" : "Indicator: % of residents walking/biking to work. Source: ACS, 2005-2010, 1-year samples",
}
ind5_3 = {
"name" : "tree-canopy",
"title" : "Percent Tree Canopy Coverage",
"groups" : [{"name" : "built-environment"}],
"notes" : "Indicator: % tree canopy coverage. Source: Virginia Department of Health, Health Profile, Alexandria City, 2000-2009",
}
ind5_4 = {
"name" : "shared-use-paths",
"title" : "Shared Use Paths",
"groups" : [{"name" : "built-environment"}],
"notes" : "Indicator: Total miles of designated shared-use paths and bike lanes relative to total street miles (Revised from Strategic Plan Indicator). Source: Carrie Sanders, City of Alexandria ",
}
ind5_6 = {
"name" : "public-transport",
"title" : "Percent of Residents Taking Public Transport to Work",
"groups" : [{"name" : "built-environment"}],
"notes" : "Indicator: % residents who take public transportation to work. Source: ACS 1-Year Sample, Selected Economic Characteristics (DP03)",
}
make_pkg(ind5_1)
make_pkg(ind5_2)
make_pkg(ind5_3)
make_pkg(ind5_4)
make_pkg(ind5_6)
import urllib
import json
import pprint
import ckan_api
from make_pkg import make_pkg
ind8_1 = {
"name" : "adult-smokers",
"title" : "Adult Smokers",
"groups" : [{"name" : "substance-abuse-prevention"}],
"notes" : "Indicator: % of current adult smokers. Source: BRFSS",
}
ind8_2 = {
"name" : "youth-smoking",
"title" : "Youth Smoking",
"groups" : [{"name" : "substance-abuse-prevention"}],
"notes" : "Indicator: % of youth (grades 7-12) who have never smoked cigarettes in their lifetime. Source: ACPS (http://www.acps.k12.va.us/mes/reports/20070301_youthprofile_appendix.pdf)",
}
ind8_3 = {
"name" : "youth-drinking",
"title" : "Youth Drinking",
"groups" : [{"name" : "substance-abuse-prevention"}],
"notes" : "Indicator: % adolescents who report having used alcohol in past 30 days. Source: ACPS (http://www.acps.k12.va.us/mes/reports/20070301_youthprofile_appendix.pdf)",
}
make_pkg(ind8_1)
make_pkg(ind8_2)
make_pkg(ind8_3)