verspm-scope-tool.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook is used to rip the output scope from a VisionEval \"Query-Spec.R\" file.\n",
    "\n",
    "It is not compatible with all possible query specs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.544182Z",
     "start_time": "2020-11-17T23:10:32.547504Z"
    }
   },
   "outputs": [],
   "source": [
    "import emat\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.550327Z",
     "start_time": "2020-11-17T23:10:34.546245Z"
    }
   },
   "outputs": [],
   "source": [
    "qs_file = \"./VERSPM/Query-Spec.R\"\n",
    "\n",
    "with open(qs_file, 'rt') as qs_f:\n",
    "    qs = qs_f.read()\n",
    "\n",
    "# change from R syntax to Python syntax\n",
    "qs = qs.replace(\" <- \",\" = \")\n",
    "qs = qs.replace(\"list(\",\"r_list(\")\n",
    "qs = qs.replace(\"c(\",\"r_list(\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T14:17:31.137513Z",
     "start_time": "2020-11-17T14:17:31.134321Z"
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.557585Z",
     "start_time": "2020-11-17T23:10:34.553854Z"
    }
   },
   "outputs": [],
   "source": [
    "# R has named list types, Python uses seperate dicts and lists.\n",
    "\n",
    "def r_list(*args, **kwargs):\n",
    "    if args and kwargs:\n",
    "        raise ValueError('all unnamed or named arguments only')\n",
    "    if args:\n",
    "        return list(args)\n",
    "    if kwargs:\n",
    "        return dict(**kwargs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.566206Z",
     "start_time": "2020-11-17T23:10:34.560241Z"
    }
   },
   "outputs": [],
   "source": [
    "exec(qs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.594872Z",
     "start_time": "2020-11-17T23:10:34.567825Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Name': 'UrbanHhDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(UrbanHhDvmt)',\n",
       "   'Units_': {'UrbanHhDvmt': 'MI/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by households residing in the urban area'},\n",
       " {'Name': 'UrbanHhDvmt_MaAz',\n",
       "  'Summarize': {'Expr': \"sum(Dvmt[Azone == 'RVMPO' & LocType == 'Urban'] )\",\n",
       "   'Units_': {'Dvmt': 'MI/DAY', 'LocType': '', 'Azone': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by households residing in the urban area in RVMPO county'},\n",
       " {'Name': 'UrbanHhDvmt_MaAzMx',\n",
       "  'Summarize': {'Expr': \"sum(Dvmt[Azone == 'RVMPO'& LocType == 'Urban'&  IsUrbanMixNbrhd == '1'])\",\n",
       "   'Units_': {'Dvmt': 'MI/DAY',\n",
       "    'LocType': '',\n",
       "    'Azone': '',\n",
       "    'IsUrbanMixNbrhd': '',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by households residing in mixed use in the urban area in RVMPO county'},\n",
       " {'Name': 'UrbanVanDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(VanDvmt)',\n",
       "   'Units': {'VanDvmt': 'MI/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by on-demand transit vans in the Urban area.'},\n",
       " {'Name': 'UrbanComSvcDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(ComSvcUrbanDvmt)',\n",
       "   'Units': {'ComSvcUrbanDvmt': 'MI/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Commercial service vehicle daily vehicle miles traveled attributable to the demand of households and businesses located in the urban area'},\n",
       " {'Name': 'UrbanLdvDvmt_Ma',\n",
       "  'Function': 'UrbanHhDvmt_Ma + UrbanVanDvmt_Ma + UrbanComSvcDvmt_Ma',\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Sum of daily vehicle miles traveled by households residing in the urban area, commercial service travel attributable to the demand of urban area households and businesses, and on-demand transit van travel in the urban area.'},\n",
       " {'Name': 'UrbanHhPop_Ma',\n",
       "  'Summarize': {'Expr': \"sum(HhSize[LocType == 'Urban'])\",\n",
       "   'Units_': {'HhSize': '', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Persons',\n",
       "  'Description': 'Number of persons residing in urban area'},\n",
       " {'Name': 'UrbanHhPop_MaAz',\n",
       "  'Summarize': {'Expr': \"sum(HhSize[Azone == 'RVMPO' & LocType == 'Urban'])\",\n",
       "   'Units_': {'HhSize': '', 'LocType': '', 'Azone': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Persons',\n",
       "  'Description': 'Number of persons residing in urban area in RVMPO county'},\n",
       " {'Name': 'UrbanHhPop_MaAzMx',\n",
       "  'Summarize': {'Expr': \"sum(HhSize[Azone == 'RVMPO'& LocType == 'Urban'& IsUrbanMixNbrhd == '1'])\",\n",
       "   'Units_': {'HhSize': '',\n",
       "    'LocType': '',\n",
       "    'Azone': '',\n",
       "    'IsUrbanMixNbrhd': '',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Persons',\n",
       "  'Description': 'Number of persons residing in mixed use in urban area in RVMPO county'},\n",
       " {'Name': 'UrbanHhPopLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"sum(HhSize[LocType == 'Urban'])\",\n",
       "   'Units_': {'HhSize': '', 'LocType': '', 'Income': 'USD', 'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Persons',\n",
       "  'Description': 'Number of persons in low income (0to20K 2010$) households residing in urban area'},\n",
       " {'Name': 'UrbanLdvDmvtPerCap_Ma',\n",
       "  'Function': 'UrbanLdvDvmt_Ma / UrbanHhPop_Ma',\n",
       "  'Units': 'Dvmt per person',\n",
       "  'Description': 'daily vehicle miles traveled per person residing in the urban area.'},\n",
       " {'Name': 'UrbanLdvDmvtPerCap_MaAz',\n",
       "  'Function': 'UrbanHhDvmt_MaAz / UrbanHhPop_MaAz',\n",
       "  'Units': 'Dvmt per person',\n",
       "  'Description': 'daily vehicle miles traveled per person residing in the urban area in RVMPO county.'},\n",
       " {'Name': 'UrbanLdvDmvtPerCap_MaAzMx',\n",
       "  'Function': 'UrbanHhDvmt_MaAzMx / UrbanHhPop_MaAzMx',\n",
       "  'Units': 'Dvmt per person',\n",
       "  'Description': 'daily vehicle miles traveled per person residing in mixed use in the urban area in RVMPO county.'},\n",
       " {'Name': 'UrbanBusDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(BusFwyDvmt)+ sum(BusArtDvmt) + sum(BusOthDvmt)',\n",
       "   'Units': {'BusFwyDvmt': 'MI/DAY',\n",
       "    'BusArtDvmt': 'MI/DAY',\n",
       "    'BusOthDvmt': 'MI/DAY',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by Bus in the Urban area.'},\n",
       " {'Name': 'UrbanHvyTrkDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(HvyTrkFwyDvmt)+ sum(HvyTrkArtDvmt) + sum(HvyTrkOthDvmt)',\n",
       "   'Units': {'HvyTrkFwyDvmt': 'MI/DAY',\n",
       "    'HvyTrkArtDvmt': 'MI/DAY',\n",
       "    'HvyTrkOthDvmt': 'MI/DAY',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by Heavy Truck in the Urban area.'},\n",
       " {'Name': 'UrbanRailDvmt_Ma',\n",
       "  'Summarize': {'Expr': 'sum(RailDvmt)',\n",
       "   'Units': {'RailDvmt': 'MI/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by Rail in the Urban area.'},\n",
       " {'Name': 'UrbanHhGGE_Ma',\n",
       "  'Summarize': {'Expr': \"sum(DailyGGE[LocType == 'Urban'])\",\n",
       "   'Units': {'DailyGGE': 'GGE/DAY', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for the travel of households residing in the Urban'},\n",
       " {'Name': 'UrbanComSvcGGE_Ma',\n",
       "  'Summarize': {'Expr': 'sum(ComSvcUrbanGGE )',\n",
       "   'Units': {'ComSvcUrbanGGE': 'GGE/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for commercial services vehicle travel arising from households and businesses located in the Urban'},\n",
       " {'Name': 'UrbanVanGGE_Ma',\n",
       "  'Summarize': {'Expr': 'sum(VanGGE)',\n",
       "   'Units': {'VanGGE': 'GGE/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for public transit van in the urban area'},\n",
       " {'Name': 'UrbanLdvGGE_Ma',\n",
       "  'Function': 'UrbanHhGGE_Ma + UrbanComSvcGGE_Ma + UrbanVanGGE_Ma',\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for light-duty vehicle travel attributable to households and businesses in the urban area'},\n",
       " {'Name': 'UrbanBusGGE_Ma',\n",
       "  'Summarize': {'Expr': 'sum(BusGGE)',\n",
       "   'Units': {'BusGGE': 'GGE/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for Bus in the urban area'},\n",
       " {'Name': 'UrbanRailGGE_Ma',\n",
       "  'Summarize': {'Expr': 'sum(RailGGE)',\n",
       "   'Units': {'RailGGE': 'GGE/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for Rail in the urban area'},\n",
       " {'Name': 'UrbanHvyTrkGGE_Ma',\n",
       "  'Summarize': {'Expr': 'sum(HvyTrkUrbanGGE)',\n",
       "   'Units': {'HvyTrkUrbanGGE': 'GGE/DAY', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Gas gallon equivalents per day',\n",
       "  'Description': 'Average daily fuel consumption for heavy truck in the urban area'},\n",
       " {'Name': 'UrbanHhNum_Ma',\n",
       "  'Summarize': {'Expr': \"count(HhSize[LocType == 'Urban'])\",\n",
       "   'Units_': {'HhSize': '', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Households',\n",
       "  'Description': 'Number of households residing in urban area'},\n",
       " {'Name': 'UrbanHhVehicles_Ma',\n",
       "  'Summarize': {'Expr': \"sum(NumAuto[LocType == 'Urban']) + sum(NumLtTrk[LocType == 'Urban'])\",\n",
       "   'Units_': {'NumAuto': 'VEH', 'NumLtTrk': 'VEH', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Household light-duty vehicles',\n",
       "  'Description': 'Total number of light-duty vehicles owned/leased by households residing in urban area'},\n",
       " {'Name': 'UrbanHhAveVehPerHh_Ma',\n",
       "  'Function': 'UrbanHhVehicles_Ma / UrbanHhNum_Ma',\n",
       "  'Units': 'Household light-duty vehicles per household',\n",
       "  'Description': 'Average number of light-duty vehicles owned/leased by households residing in urban area'},\n",
       " {'Name': 'UrbanHhWorkers_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Workers[LocType == 'Urban'])\",\n",
       "   'Units_': {'Workers': 'PRSN', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Workers',\n",
       "  'Description': 'Number of workers residing in urban'},\n",
       " {'Name': 'UrbanHhDrivers_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Drivers[LocType == 'Urban'])\",\n",
       "   'Units_': {'Drivers': 'PRSN', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Drivers',\n",
       "  'Description': 'Number of drivers residing in urban'},\n",
       " {'Name': 'NumUrbanMixHh_Ma',\n",
       "  'Require': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': \"sum(IsUrbanMixNbrhd[LocType == 'Urban'])\",\n",
       "   'Units_': {'IsUrbanMixNbrhd': '', 'LocType': 'category', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Households',\n",
       "  'Description': 'Number of households residing in urban-mixed neighborhoods in urbanized area'},\n",
       " {'Name': 'NumUrbanMixHh_Ma',\n",
       "  'RequireNot': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': 'sum(IsUrbanMixNbrhd)',\n",
       "   'Units_': {'IsUrbanMixNbrhd': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Households',\n",
       "  'Description': 'Number of households residing in urban-mixed neighborhoods in urbanized area'},\n",
       " {'Name': 'UrbanHhCO2e_Ma',\n",
       "  'Summarize': {'Expr': \"sum(DailyCO2e[LocType == 'Urban'])\",\n",
       "   'Units': {'DailyCO2e': 'MT/YR', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from light-duty vehicle travel by households residing in the urban area'},\n",
       " {'Name': 'UrbanComSvcCO2e_Ma',\n",
       "  'Summarize': {'Expr': 'sum(ComSvcUrbanCO2e)',\n",
       "   'Units': {'ComSvcUrbanCO2e': 'MT/YR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from commercial service light-duty vehicle travel attributable to households and businesses in the urban area'},\n",
       " {'Name': 'UrbanVanCO2e_Ma',\n",
       "  'Summarize': {'Expr': 'sum(VanCO2e)',\n",
       "   'Units': {'VanCO2e': 'MT/YR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from public transit van travel in the urban area'},\n",
       " {'Name': 'UrbanLdvCO2e_Ma',\n",
       "  'Function': 'UrbanHhCO2e_Ma + UrbanVanCO2e_Ma + UrbanComSvcCO2e_Ma',\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from light-duty vehicle travel of households and businesses in the urban area'},\n",
       " {'Name': 'UrbanLdvCO2eRate_Ma',\n",
       "  'Function': 'UrbanLdvCO2e_Ma / (UrbanLdvDvmt_Ma * 365)',\n",
       "  'Units': 'Grams CO2e per mile',\n",
       "  'Description': 'Average greenhouse gas emissions per mile of light duty vehicle travel in the urban area'},\n",
       " {'Name': 'UrbanBusCO2e_Ma',\n",
       "  'Summarize': {'Expr': 'sum(BusCO2e)',\n",
       "   'Units': {'BusCO2e': 'MT/YR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from public transit bus travel in the urban area'},\n",
       " {'Name': 'UrbanRailCO2e_Ma',\n",
       "  'Summarize': {'Expr': 'sum(RailCO2e)',\n",
       "   'Units': {'RailCO2e': 'MT/YR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from Rail travel in the urban area'},\n",
       " {'Name': 'UrbanBusCO2eRate_Ma',\n",
       "  'Function': '(UrbanBusCO2e_Ma * 1000000) / (UrbanBusDvmt_Ma * 365)',\n",
       "  'Units': 'grams CO2e per mile',\n",
       "  'Description': 'Average greenhouse gas emissions per mile of public transit bus travel in the urban area'},\n",
       " {'Name': 'UrbanHvyTrkCO2e_Ma',\n",
       "  'Summarize': {'Expr': 'sum(HvyTrkUrbanCO2e)',\n",
       "   'Units': {'HvyTrkUrbanCO2e': 'MT/YR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Metric tons CO2e per year',\n",
       "  'Description': 'Average annual production of greenhouse gas emissions from heavy truck travel in the urban area'},\n",
       " {'Name': 'UrbanHvyTrkAveCO2eRate_Ma',\n",
       "  'Function': '(UrbanHvyTrkCO2e_Ma * 1000000) / (UrbanHvyTrkDvmt_Ma * 365)',\n",
       "  'Units': 'Grams CO2e per mile',\n",
       "  'Description': 'Average greenhouse gas emissions per mile of heavy truck travel in the urban area'},\n",
       " {'Name': 'UrbanWalkTrips_Ma',\n",
       "  'Summarize': {'Expr': \"sum(WalkTrips[LocType == 'Urban'])\",\n",
       "   'Units_': {'WalkTrips': 'TRIP/DAY', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Trips per Day',\n",
       "  'Description': 'Average number walk trips per day in urban area'},\n",
       " {'Name': 'UrbanBikeTrips_Ma',\n",
       "  'Summarize': {'Expr': \"sum(BikeTrips[LocType == 'Urban'])\",\n",
       "   'Units_': {'BikeTrips': 'TRIP/DAY', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Trips per Day',\n",
       "  'Description': 'Average number bike trips per day in urban area'},\n",
       " {'Name': 'UrbanTransitTrips_Ma',\n",
       "  'Summarize': {'Expr': \"sum(TransitTrips[LocType == 'Urban'])\",\n",
       "   'Units_': {'TransitTrips': 'TRIP/DAY', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Trips per Day',\n",
       "  'Description': 'Average number transit trips per day in urban area'},\n",
       " {'Name': 'UrbanModeShiftTrips_Ma',\n",
       "  'Function': 'UrbanWalkTrips_Ma+UrbanBikeTrips_Ma+UrbanTransitTrips_Ma',\n",
       "  'Units': 'Trips per Day',\n",
       "  'Description': 'Average number mode shift trips (Bike, Walk, & Transit) per day in urban area'},\n",
       " {'Name': 'UrbanLdv_TotalDelay_Ma',\n",
       "  'Summarize': {'Expr': 'sum(LdvTotDelay)',\n",
       "   'Units': {'LdvTotDelay': 'HR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Hours',\n",
       "  'Description': 'Total light-duty vehicle delay (hours per day) on urban area roads'},\n",
       " {'Name': 'UrbanHvyTrk_TotalDelay_Ma',\n",
       "  'Summarize': {'Expr': 'sum(HvyTrkTotDelay)',\n",
       "   'Units': {'HvyTrkTotDelay': 'HR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Hours',\n",
       "  'Description': 'Total heavy truck vehicle delay (hours per day) on urban area roads'},\n",
       " {'Name': 'UrbanLdv_HvyTrk_TotalDelay_Ma',\n",
       "  'Function': 'UrbanLdv_TotalDelay_Ma + UrbanHvyTrk_TotalDelay_Ma',\n",
       "  'Units': 'Hours',\n",
       "  'Description': 'Total light duty vehicle and heavy truck delay (hours per day) on the urban area roads'},\n",
       " {'Name': 'UrbanLvdAveSp_Ma',\n",
       "  'Summarize': {'Expr': 'mean(LdvAveSpeed)',\n",
       "   'Units': {'LdvAveSpeed': 'MI/HR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per Hour',\n",
       "  'Description': 'Average speed (miles per hour) of light-duty vehicle travel on urban area roads'},\n",
       " {'Name': 'UrbanHvyTrkAveSp_Ma',\n",
       "  'Summarize': {'Expr': 'mean(HvyTrkAveSpeed)',\n",
       "   'Units': {'HvyTrkAveSpeed': 'MI/HR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per Hour',\n",
       "  'Description': 'Average speed (miles per hour) of heavy truck travel on urban area roads'},\n",
       " {'Name': 'UrbanBusAveSp_Ma',\n",
       "  'Summarize': {'Expr': 'mean(BusAveSpeed)',\n",
       "   'Units': {'BusAveSpeed': 'MI/HR', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Marea'},\n",
       "  'Units': 'Miles per Hour',\n",
       "  'Description': 'Average speed (miles per hour) of bus travel on urban area roads'},\n",
       " {'Name': 'UrbanVehOwnershipCost_Ma',\n",
       "  'Summarize': {'Expr': \"mean(OwnCost[LocType == 'Urban'])\",\n",
       "   'Units_': {'OwnCost': 'USD', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': 'Average annual household vehicle ownership cost (depreciation, finance, insurance, taxes) in urban area'},\n",
       " {'Name': 'UrbanAveVehCostPM_Ma',\n",
       "  'Summarize': {'Expr': \"mean(AveVehCostPM[LocType == 'Urban'])\",\n",
       "   'Units_': {'AveVehCostPM': 'USD', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD',\n",
       "  'Description': ' Average out-of-pocket cost in dollars per mile of vehicle travel in urban area'},\n",
       " {'Name': 'UrbanVehOperatingCost_Ma',\n",
       "  'Summarize': {'Expr': \"mean(AveVehCostPM[LocType == 'Urban']) * mean(Dvmt[LocType == 'Urban'])*365\",\n",
       "   'Units_': {'AveVehCostPM': 'USD',\n",
       "    'Dvmt': 'MI/DAY',\n",
       "    'LocType': '',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': ' Average annual household vehicle operating cost in urban area'},\n",
       " {'Name': 'UrbanTotalHhIncome_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Income[LocType == 'Urban'])\",\n",
       "   'Units_': {'Income': 'USD', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': ' Total annual household income in urban area'},\n",
       " {'Name': 'UrbanAveHhIncome_Ma',\n",
       "  'Function': 'UrbanTotalHhIncome_Ma / UrbanHhNum_Ma',\n",
       "  'Units': 'USD per year',\n",
       "  'Description': 'Average annual household income in the urban area'},\n",
       " {'Name': 'UrbanTotalHhIncomeLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Income[LocType == 'Urban'])\",\n",
       "   'Units_': {'Income': 'USD', 'LocType': '', 'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': ' Total annual low household income (0to20K 2010$) in urban area'},\n",
       " {'Name': 'UrbanHhNumLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"count(HhSize[LocType == 'Urban'])\",\n",
       "   'Units_': {'HhSize': '', 'LocType': '', 'Income': 'USD', 'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Households',\n",
       "  'Description': 'Number of low income (0to20K 2010$) households residing in urban area'},\n",
       " {'Name': 'UrbanAveHhIncomeLowInc_Ma',\n",
       "  'Function': 'UrbanTotalHhIncomeLowInc_Ma.min / UrbanHhNumLowInc_Ma.min',\n",
       "  'Units': 'USD per year',\n",
       "  'Description': 'Average annual low household income (0to20K 2010$) in the urban area'},\n",
       " {'Name': 'UrbanAveHhDVMT_Ma',\n",
       "  'Function': 'UrbanHhDvmt_Ma / UrbanHhNum_Ma',\n",
       "  'Units': 'Vehicle Mile Travel',\n",
       "  'Description': 'Average household DVMT in urban area'},\n",
       " {'Name': 'UrbanVehOperatingCostLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"mean(AveVehCostPM[LocType == 'Urban'])* mean(Dvmt[LocType == 'Urban'])*365\",\n",
       "   'Units_': {'AveVehCostPM': 'USD',\n",
       "    'LocType': '',\n",
       "    'Income': 'USD',\n",
       "    'Dvmt': 'MI/DAY',\n",
       "    'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': 'Average annual household vehicle operating cost for low income (0to20K 2010$) in urban area'},\n",
       " {'Name': 'UrbanVehOwnershipCostLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"mean(OwnCost[LocType == 'Urban'])\",\n",
       "   'Units_': {'OwnCost': 'USD', 'LocType': '', 'Income': 'USD', 'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per year',\n",
       "  'Description': 'Average annual household vehicle ownership cost for low income(0to20K 2010$) in urban area'},\n",
       " {'Name': 'UrbanHhDvmtLowInc_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Dvmt[LocType == 'Urban'])\",\n",
       "   'Units_': {'Dvmt': 'MI/DAY', 'LocType': '', 'Income': 'USD', 'Marea': ''},\n",
       "   'By': ['Income', 'Marea'],\n",
       "   'Breaks': {'Income': [20000, 40000, 60000, 80000, 100000]},\n",
       "   'BreakNames': {'Income': ['20000', '40000', '60000', '80000', '100000']},\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Miles per day',\n",
       "  'Description': 'Daily vehicle miles traveled by low income (0to20K 2010$) households residing in the urban area'},\n",
       " {'Name': 'HhVehTravCostShareLowInc_Ma',\n",
       "  'Function': '(UrbanVehOperatingCostLowInc_Ma.min  + UrbanVehOwnershipCostLowInc_Ma.min * UrbanHhNumLowInc_Ma.min)/ UrbanTotalHhIncomeLowInc_Ma.min',\n",
       "  'Units': 'Proportion',\n",
       "  'Description': 'Low income (0to20K 2010$) household vehicle Own & out-of-pocket costs share of HH low income total (all low income HHs)in urban area'},\n",
       " {'Name': 'HhVehTravCostShare_Ma',\n",
       "  'Function': '((UrbanVehOperatingCost_Ma + UrbanVehOwnershipCost_Ma)* UrbanHhNum_Ma) / UrbanTotalHhIncome_Ma',\n",
       "  'Units': 'Proportion',\n",
       "  'Description': 'Household vehicle Own & out-of-pocket costs share of HH income total (all HHs) in urban area'},\n",
       " {'Name': 'UrbanLdvDmvtPerCapLowInc_Ma',\n",
       "  'Function': 'UrbanHhDvmtLowInc_Ma.min / UrbanHhPopLowInc_Ma.min',\n",
       "  'Units': 'Dvmt per person',\n",
       "  'Description': 'daily vehicle miles traveled per person in low income (0to20K 2010$) households residing in the urban area.'},\n",
       " {'Name': 'MareaCarSvcLtTrkDvmtProp_Ma',\n",
       "  'Summarize': {'Expr': \"sum(DvmtProp[VehicleAccess != 'Own' & Type == 'LtTrk']) / sum(DvmtProp[VehicleAccess != 'Own'])\",\n",
       "   'Units_': {'DvmtProp': '', 'VehicleAccess': '', 'Type': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Vehicle'},\n",
       "  'Units': 'Proportion',\n",
       "  'Description': 'Average proportion car service vehicle DVMT in light trucks used by households residing in the Marea'},\n",
       " {'Name': 'UrbanAvePopDen_Ma',\n",
       "  'Summarize': {'Expr': 'sum(UrbanPop) / sum(UrbanArea)',\n",
       "   'Units_': {'UrbanArea': 'ACRE', 'UrbanPop': 'PRSN', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Persons per acre',\n",
       "  'Description': 'Average number of persons per acre in the urbanized area'},\n",
       " {'Name': 'MedianBzonePopDen_Ma',\n",
       "  'Require': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': \"median(D1B[LocType == 'Urban'])\",\n",
       "   'Units_': {'D1B': 'PRSN/ACRE', 'LocType': 'Category', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Persons per acre',\n",
       "  'Description': 'Median Bzone population density in urbanized area'},\n",
       " {'Name': 'MedianBzonePopDen_Ma',\n",
       "  'RequireNot': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': 'median(UrbanPop / UrbanArea)',\n",
       "   'Units_': {'UrbanPop': 'PRSN', 'UrbanArea': 'ACRE', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Persons per acre',\n",
       "  'Description': 'Median Bzone population density in urbanized area'},\n",
       " {'Name': 'AveActivityDen_Ma',\n",
       "  'Require': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': \"sum(NumHh[LocType == 'Urban'] + TotEmp[LocType == 'Urban']) / sum(UrbanArea)\",\n",
       "   'Units_': {'NumHh': 'HH',\n",
       "    'TotEmp': 'PRSN',\n",
       "    'UrbanArea': 'ACRE',\n",
       "    'LocType': 'category',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Households and jobs per acre',\n",
       "  'Description': 'Average number of households and jobs per acre in the urbanized area'},\n",
       " {'Name': 'PropUrbanMixHh_Ma',\n",
       "  'Function': 'NumUrbanMixHh_Ma / UrbanHhNum_Ma',\n",
       "  'Units': 'Proportion of Households',\n",
       "  'Description': 'Proportion of urbanized area households that reside in urban-mixed neighborhoods'},\n",
       " {'Name': 'HhTotDailyWkrParkingCost_Ma',\n",
       "  'Summarize': {'Expr': \"sum(ParkingCost[LocType == 'Urban'])\",\n",
       "   'Units_': {'ParkingCost': '', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': {'Worker': ['ParkingCost'], 'Household': ['Marea', 'LocType']},\n",
       "   'Key': 'HhId'},\n",
       "  'Units': 'USD per day',\n",
       "  'Description': 'Total daily work parking expenditures by households living in the urbanized portion of the Marea'},\n",
       " {'Name': 'HhTotDailyOthParkingCost_Ma',\n",
       "  'Summarize': {'Expr': \"sum(OtherParkingCost[LocType == 'Urban'])\",\n",
       "   'Units': {'OtherParkingCost': '', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'USD per day',\n",
       "  'Description': 'Total daily non-work parking expenditures by households living in the urbanized portion of the Marea'},\n",
       " {'Name': 'PropSFDU_Ma',\n",
       "  'Require': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': \"sum(SFDU[LocType == 'Urban']) / (sum(NumHh[LocType == 'Urban']))\",\n",
       "   'Units': {'SFDU': 'DU', 'NumHh': 'HH', 'LocType': 'category', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Proportion of Households',\n",
       "  'Description': 'Proportion of urbanized area households that reside in single-family dwellings'},\n",
       " {'Name': 'PropSFDU_Ma',\n",
       "  'RequireNot': {'Dataset': 'LocType', 'Table': 'Bzone'},\n",
       "  'Summarize': {'Expr': 'sum(SFDU) / (sum(NumHh))',\n",
       "   'Units': {'SFDU': 'DU', 'NumHh': 'HH', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Bzone'},\n",
       "  'Units': 'Proportion of Households',\n",
       "  'Description': 'Proportion of urbanized area households that reside in single-family dwellings'},\n",
       " {'Name': 'UrbanVehicleTrips_Ma',\n",
       "  'Summarize': {'Expr': \"sum(VehicleTrips[LocType == 'Urban'])\",\n",
       "   'Units': {'VehicleTrips': 'TRIP/DAY', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Trips per day',\n",
       "  'Description': 'Average number of vehicle trips per day by household members in urban'},\n",
       " {'Name': 'UrbanVehTripLen_Ma',\n",
       "  'Summarize': {'Expr': \"sum(AveVehTripLen[LocType == 'Urban'])\",\n",
       "   'Units': {'AveVehTripLen': 'MI', 'LocType': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Household'},\n",
       "  'Units': 'Miles',\n",
       "  'Description': 'Average household vehicle trip length in miles in urban'},\n",
       " {'Name': 'MareaCarSvcAutoDvmtProp_Ma',\n",
       "  'Summarize': {'Expr': \" sum(DvmtProp[VehicleAccess != 'Own' & Type == 'Auto']) / sum(DvmtProp[VehicleAccess != 'Own'])\",\n",
       "   'Units_': {'DvmtProp': '', 'VehicleAccess': '', 'Type': '', 'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': 'Vehicle'},\n",
       "  'Units': 'Proportion',\n",
       "  'Description': 'Average proportion car service vehicle DVMT in autos used by households residing in the Marea'},\n",
       " {'Name': 'MareaHouseholdCarSvcDvmt_Ma',\n",
       "  'Summarize': {'Expr': \"sum(Dvmt[VehicleAccess != 'Own' ] * DvmtProp[VehicleAccess != 'Own' ])\",\n",
       "   'Units': {'Dvmt': 'MI/DAY',\n",
       "    'DvmtProp': '',\n",
       "    'VehicleAccess': '',\n",
       "    'Marea': ''},\n",
       "   'By': 'Marea',\n",
       "   'Table': {'Household': ['Dvmt', 'Marea'],\n",
       "    'Vehicle': ['DvmtProp', 'VehicleAccess']},\n",
       "   'Key': 'HhId'},\n",
       "  'Units': 'miles per day',\n",
       "  'Description': 'Total DVMT in car service vehicles of persons in households and non-institutional group quarters in Marea'}]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PMSpecifications"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.604037Z",
     "start_time": "2020-11-17T23:10:34.596337Z"
    }
   },
   "outputs": [],
   "source": [
    "pm_scope = emat.Scope(None)\n",
    "\n",
    "filename = 'Measures_VERSPM_2010,2038_Marea=RVMPO.csv'\n",
    "\n",
    "def add_measure(*args, **kwargs):\n",
    "    try:\n",
    "        pm_scope.add_measure(*args, **kwargs)\n",
    "    except ValueError:\n",
    "        pass\n",
    "\n",
    "for measure in PMSpecifications:\n",
    "    \n",
    "    if 'Require' in measure:\n",
    "        if measure.get('Require',{}).get(\"Table\") == 'Bzone':\n",
    "            continue\n",
    "    \n",
    "    summarize = measure.get('Summarize',{})\n",
    "    name = measure['Name'].replace(\"_MaAz\",\"_Az\").replace(\"_Ma\",\"\")\n",
    "    if 'BreakNames' in summarize:\n",
    "        breaks = list(summarize['BreakNames'].values())[0]\n",
    "        add_measure(\n",
    "            f\"{name}.min\", \n",
    "            desc=measure['Description']+f\" (up to {breaks[0]})\",\n",
    "            parser=dict(file=filename, loc=[f\"{name}.min\", 2038]),\n",
    "        )\n",
    "        for b0,b1 in zip(breaks[:-1], breaks[1:]):\n",
    "            add_measure(\n",
    "                f\"{name}.{b0}\", \n",
    "                desc=measure['Description']+f\" ({b0} to {b1})\",\n",
    "                parser=dict(file=filename, loc=[f\"{name}.{b0}\", 2038]),\n",
    "            )\n",
    "        b0 = breaks[-1]\n",
    "        add_measure(\n",
    "            f\"{name}.{b0}\", \n",
    "            desc=measure['Description']+f\" ({b0} and up)\",\n",
    "            parser=dict(file=filename, loc=[f\"{name}.{b0}\", 2038]),\n",
    "        )\n",
    "    else:\n",
    "        add_measure(\n",
    "            name, \n",
    "            desc=measure['Description'],\n",
    "            parser=dict(file=filename, loc=[name, 2038]),\n",
    "        )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.670977Z",
     "start_time": "2020-11-17T23:10:34.605572Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scope:\n",
      "    name: Empty-Scope\n",
      "    desc: ''\n",
      "inputs: {}\n",
      "outputs:\n",
      "    UrbanHhDvmt:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by households residing in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmt\n",
      "            - 2038\n",
      "    UrbanHhDvmt_Az:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by households residing in the urban area\n",
      "            in RVMPO county\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmt_Az\n",
      "            - 2038\n",
      "    UrbanHhDvmt_AzMx:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by households residing in mixed use in\n",
      "            the urban area in RVMPO county\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmt_AzMx\n",
      "            - 2038\n",
      "    UrbanVanDvmt:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by on-demand transit vans in the Urban\n",
      "            area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVanDvmt\n",
      "            - 2038\n",
      "    UrbanComSvcDvmt:\n",
      "        kind: info\n",
      "        desc: Commercial service vehicle daily vehicle miles traveled attributable\n",
      "            to the demand of households and businesses located in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanComSvcDvmt\n",
      "            - 2038\n",
      "    UrbanLdvDvmt:\n",
      "        kind: info\n",
      "        desc: Sum of daily vehicle miles traveled by households residing in the urban\n",
      "            area, commercial service travel attributable to the demand of urban area\n",
      "            households and businesses, and on-demand transit van travel in the urban\n",
      "            area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvDvmt\n",
      "            - 2038\n",
      "    UrbanHhPop:\n",
      "        kind: info\n",
      "        desc: Number of persons residing in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPop\n",
      "            - 2038\n",
      "    UrbanHhPop_Az:\n",
      "        kind: info\n",
      "        desc: Number of persons residing in urban area in RVMPO county\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPop_Az\n",
      "            - 2038\n",
      "    UrbanHhPop_AzMx:\n",
      "        kind: info\n",
      "        desc: Number of persons residing in mixed use in urban area in RVMPO county\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPop_AzMx\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.min:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (up to 20000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.min\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.20000:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (20000 to 40000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.20000\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.40000:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (40000 to 60000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.40000\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.60000:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (60000 to 80000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.60000\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.80000:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (80000 to 100000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.80000\n",
      "            - 2038\n",
      "    UrbanHhPopLowInc.100000:\n",
      "        kind: info\n",
      "        desc: Number of persons in low income (0to20K 2010$) households residing in\n",
      "            urban area (100000 and up)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhPopLowInc.100000\n",
      "            - 2038\n",
      "    UrbanLdvDmvtPerCap:\n",
      "        kind: info\n",
      "        desc: daily vehicle miles traveled per person residing in the urban area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvDmvtPerCap\n",
      "            - 2038\n",
      "    UrbanLdvDmvtPerCap_Az:\n",
      "        kind: info\n",
      "        desc: daily vehicle miles traveled per person residing in the urban area in\n",
      "            RVMPO county.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvDmvtPerCap_Az\n",
      "            - 2038\n",
      "    UrbanLdvDmvtPerCap_AzMx:\n",
      "        kind: info\n",
      "        desc: daily vehicle miles traveled per person residing in mixed use in the\n",
      "            urban area in RVMPO county.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvDmvtPerCap_AzMx\n",
      "            - 2038\n",
      "    UrbanBusDvmt:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by Bus in the Urban area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBusDvmt\n",
      "            - 2038\n",
      "    UrbanHvyTrkDvmt:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by Heavy Truck in the Urban area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrkDvmt\n",
      "            - 2038\n",
      "    UrbanRailDvmt:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by Rail in the Urban area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanRailDvmt\n",
      "            - 2038\n",
      "    UrbanHhGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for the travel of households residing\n",
      "            in the Urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhGGE\n",
      "            - 2038\n",
      "    UrbanComSvcGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for commercial services vehicle travel\n",
      "            arising from households and businesses located in the Urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanComSvcGGE\n",
      "            - 2038\n",
      "    UrbanVanGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for public transit van in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVanGGE\n",
      "            - 2038\n",
      "    UrbanLdvGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for light-duty vehicle travel attributable\n",
      "            to households and businesses in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvGGE\n",
      "            - 2038\n",
      "    UrbanBusGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for Bus in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBusGGE\n",
      "            - 2038\n",
      "    UrbanRailGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for Rail in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanRailGGE\n",
      "            - 2038\n",
      "    UrbanHvyTrkGGE:\n",
      "        kind: info\n",
      "        desc: Average daily fuel consumption for heavy truck in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrkGGE\n",
      "            - 2038\n",
      "    UrbanHhNum:\n",
      "        kind: info\n",
      "        desc: Number of households residing in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNum\n",
      "            - 2038\n",
      "    UrbanHhVehicles:\n",
      "        kind: info\n",
      "        desc: Total number of light-duty vehicles owned/leased by households residing\n",
      "            in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhVehicles\n",
      "            - 2038\n",
      "    UrbanHhAveVehPerHh:\n",
      "        kind: info\n",
      "        desc: Average number of light-duty vehicles owned/leased by households residing\n",
      "            in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhAveVehPerHh\n",
      "            - 2038\n",
      "    UrbanHhWorkers:\n",
      "        kind: info\n",
      "        desc: Number of workers residing in urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhWorkers\n",
      "            - 2038\n",
      "    UrbanHhDrivers:\n",
      "        kind: info\n",
      "        desc: Number of drivers residing in urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDrivers\n",
      "            - 2038\n",
      "    NumUrbanMixHh:\n",
      "        kind: info\n",
      "        desc: Number of households residing in urban-mixed neighborhoods in urbanized\n",
      "            area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - NumUrbanMixHh\n",
      "            - 2038\n",
      "    UrbanHhCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from light-duty\n",
      "            vehicle travel by households residing in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhCO2e\n",
      "            - 2038\n",
      "    UrbanComSvcCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from commercial\n",
      "            service light-duty vehicle travel attributable to households and businesses\n",
      "            in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanComSvcCO2e\n",
      "            - 2038\n",
      "    UrbanVanCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from public transit\n",
      "            van travel in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVanCO2e\n",
      "            - 2038\n",
      "    UrbanLdvCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from light-duty\n",
      "            vehicle travel of households and businesses in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvCO2e\n",
      "            - 2038\n",
      "    UrbanLdvCO2eRate:\n",
      "        kind: info\n",
      "        desc: Average greenhouse gas emissions per mile of light duty vehicle travel\n",
      "            in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvCO2eRate\n",
      "            - 2038\n",
      "    UrbanBusCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from public transit\n",
      "            bus travel in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBusCO2e\n",
      "            - 2038\n",
      "    UrbanRailCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from Rail travel\n",
      "            in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanRailCO2e\n",
      "            - 2038\n",
      "    UrbanBusCO2eRate:\n",
      "        kind: info\n",
      "        desc: Average greenhouse gas emissions per mile of public transit bus travel\n",
      "            in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBusCO2eRate\n",
      "            - 2038\n",
      "    UrbanHvyTrkCO2e:\n",
      "        kind: info\n",
      "        desc: Average annual production of greenhouse gas emissions from heavy truck\n",
      "            travel in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrkCO2e\n",
      "            - 2038\n",
      "    UrbanHvyTrkAveCO2eRate:\n",
      "        kind: info\n",
      "        desc: Average greenhouse gas emissions per mile of heavy truck travel in the\n",
      "            urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrkAveCO2eRate\n",
      "            - 2038\n",
      "    UrbanWalkTrips:\n",
      "        kind: info\n",
      "        desc: Average number walk trips per day in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanWalkTrips\n",
      "            - 2038\n",
      "    UrbanBikeTrips:\n",
      "        kind: info\n",
      "        desc: Average number bike trips per day in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBikeTrips\n",
      "            - 2038\n",
      "    UrbanTransitTrips:\n",
      "        kind: info\n",
      "        desc: Average number transit trips per day in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTransitTrips\n",
      "            - 2038\n",
      "    UrbanModeShiftTrips:\n",
      "        kind: info\n",
      "        desc: Average number mode shift trips (Bike, Walk, & Transit) per day in urban\n",
      "            area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanModeShiftTrips\n",
      "            - 2038\n",
      "    UrbanLdv_TotalDelay:\n",
      "        kind: info\n",
      "        desc: Total light-duty vehicle delay (hours per day) on urban area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdv_TotalDelay\n",
      "            - 2038\n",
      "    UrbanHvyTrk_TotalDelay:\n",
      "        kind: info\n",
      "        desc: Total heavy truck vehicle delay (hours per day) on urban area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrk_TotalDelay\n",
      "            - 2038\n",
      "    UrbanLdv_HvyTrk_TotalDelay:\n",
      "        kind: info\n",
      "        desc: Total light duty vehicle and heavy truck delay (hours per day) on the\n",
      "            urban area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdv_HvyTrk_TotalDelay\n",
      "            - 2038\n",
      "    UrbanLvdAveSp:\n",
      "        kind: info\n",
      "        desc: Average speed (miles per hour) of light-duty vehicle travel on urban\n",
      "            area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLvdAveSp\n",
      "            - 2038\n",
      "    UrbanHvyTrkAveSp:\n",
      "        kind: info\n",
      "        desc: Average speed (miles per hour) of heavy truck travel on urban area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHvyTrkAveSp\n",
      "            - 2038\n",
      "    UrbanBusAveSp:\n",
      "        kind: info\n",
      "        desc: Average speed (miles per hour) of bus travel on urban area roads\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanBusAveSp\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCost:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost (depreciation, finance,\n",
      "            insurance, taxes) in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCost\n",
      "            - 2038\n",
      "    UrbanAveVehCostPM:\n",
      "        kind: info\n",
      "        desc: ' Average out-of-pocket cost in dollars per mile of vehicle travel in\n",
      "            urban area'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanAveVehCostPM\n",
      "            - 2038\n",
      "    UrbanVehOperatingCost:\n",
      "        kind: info\n",
      "        desc: ' Average annual household vehicle operating cost in urban area'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCost\n",
      "            - 2038\n",
      "    UrbanTotalHhIncome:\n",
      "        kind: info\n",
      "        desc: ' Total annual household income in urban area'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncome\n",
      "            - 2038\n",
      "    UrbanAveHhIncome:\n",
      "        kind: info\n",
      "        desc: Average annual household income in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanAveHhIncome\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.min:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (up\n",
      "            to 20000)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.min\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.20000:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (20000\n",
      "            to 40000)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.20000\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.40000:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (40000\n",
      "            to 60000)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.40000\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.60000:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (60000\n",
      "            to 80000)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.60000\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.80000:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (80000\n",
      "            to 100000)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.80000\n",
      "            - 2038\n",
      "    UrbanTotalHhIncomeLowInc.100000:\n",
      "        kind: info\n",
      "        desc: ' Total annual low household income (0to20K 2010$) in urban area (100000\n",
      "            and up)'\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanTotalHhIncomeLowInc.100000\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.min:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (up to 20000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.min\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.20000:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (20000 to 40000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.20000\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.40000:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (40000 to 60000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.40000\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.60000:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (60000 to 80000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.60000\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.80000:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (80000 to 100000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.80000\n",
      "            - 2038\n",
      "    UrbanHhNumLowInc.100000:\n",
      "        kind: info\n",
      "        desc: Number of low income (0to20K 2010$) households residing in urban area\n",
      "            (100000 and up)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhNumLowInc.100000\n",
      "            - 2038\n",
      "    UrbanAveHhIncomeLowInc:\n",
      "        kind: info\n",
      "        desc: Average annual low household income (0to20K 2010$) in the urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanAveHhIncomeLowInc\n",
      "            - 2038\n",
      "    UrbanAveHhDVMT:\n",
      "        kind: info\n",
      "        desc: Average household DVMT in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanAveHhDVMT\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.min:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (up to 20000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.min\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.20000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (20000 to 40000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.20000\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.40000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (40000 to 60000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.40000\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.60000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (60000 to 80000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.60000\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.80000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (80000 to 100000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.80000\n",
      "            - 2038\n",
      "    UrbanVehOperatingCostLowInc.100000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle operating cost for low income (0to20K\n",
      "            2010$) in urban area (100000 and up)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOperatingCostLowInc.100000\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.min:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (up to 20000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.min\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.20000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (20000 to 40000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.20000\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.40000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (40000 to 60000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.40000\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.60000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (60000 to 80000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.60000\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.80000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (80000 to 100000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.80000\n",
      "            - 2038\n",
      "    UrbanVehOwnershipCostLowInc.100000:\n",
      "        kind: info\n",
      "        desc: Average annual household vehicle ownership cost for low income(0to20K\n",
      "            2010$) in urban area (100000 and up)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehOwnershipCostLowInc.100000\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.min:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (up to 20000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.min\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.20000:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (20000 to 40000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.20000\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.40000:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (40000 to 60000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.40000\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.60000:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (60000 to 80000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.60000\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.80000:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (80000 to 100000)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.80000\n",
      "            - 2038\n",
      "    UrbanHhDvmtLowInc.100000:\n",
      "        kind: info\n",
      "        desc: Daily vehicle miles traveled by low income (0to20K 2010$) households\n",
      "            residing in the urban area (100000 and up)\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanHhDvmtLowInc.100000\n",
      "            - 2038\n",
      "    HhVehTravCostShareLowInc:\n",
      "        kind: info\n",
      "        desc: Low income (0to20K 2010$) household vehicle Own & out-of-pocket costs\n",
      "            share of HH low income total (all low income HHs)in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - HhVehTravCostShareLowInc\n",
      "            - 2038\n",
      "    HhVehTravCostShare:\n",
      "        kind: info\n",
      "        desc: Household vehicle Own & out-of-pocket costs share of HH income total\n",
      "            (all HHs) in urban area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - HhVehTravCostShare\n",
      "            - 2038\n",
      "    UrbanLdvDmvtPerCapLowInc:\n",
      "        kind: info\n",
      "        desc: daily vehicle miles traveled per person in low income (0to20K 2010$)\n",
      "            households residing in the urban area.\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanLdvDmvtPerCapLowInc\n",
      "            - 2038\n",
      "    MareaCarSvcLtTrkDvmtProp:\n",
      "        kind: info\n",
      "        desc: Average proportion car service vehicle DVMT in light trucks used by\n",
      "            households residing in the Marea\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - MareaCarSvcLtTrkDvmtProp\n",
      "            - 2038\n",
      "    UrbanAvePopDen:\n",
      "        kind: info\n",
      "        desc: Average number of persons per acre in the urbanized area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanAvePopDen\n",
      "            - 2038\n",
      "    MedianBzonePopDen:\n",
      "        kind: info\n",
      "        desc: Median Bzone population density in urbanized area\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - MedianBzonePopDen\n",
      "            - 2038\n",
      "    PropUrbanMixHh:\n",
      "        kind: info\n",
      "        desc: Proportion of urbanized area households that reside in urban-mixed neighborhoods\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - PropUrbanMixHh\n",
      "            - 2038\n",
      "    HhTotDailyWkrParkingCost:\n",
      "        kind: info\n",
      "        desc: Total daily work parking expenditures by households living in the urbanized\n",
      "            portion of the Marea\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - HhTotDailyWkrParkingCost\n",
      "            - 2038\n",
      "    HhTotDailyOthParkingCost:\n",
      "        kind: info\n",
      "        desc: Total daily non-work parking expenditures by households living in the\n",
      "            urbanized portion of the Marea\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - HhTotDailyOthParkingCost\n",
      "            - 2038\n",
      "    PropSFDU:\n",
      "        kind: info\n",
      "        desc: Proportion of urbanized area households that reside in single-family\n",
      "            dwellings\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - PropSFDU\n",
      "            - 2038\n",
      "    UrbanVehicleTrips:\n",
      "        kind: info\n",
      "        desc: Average number of vehicle trips per day by household members in urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehicleTrips\n",
      "            - 2038\n",
      "    UrbanVehTripLen:\n",
      "        kind: info\n",
      "        desc: Average household vehicle trip length in miles in urban\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - UrbanVehTripLen\n",
      "            - 2038\n",
      "    MareaCarSvcAutoDvmtProp:\n",
      "        kind: info\n",
      "        desc: Average proportion car service vehicle DVMT in autos used by households\n",
      "            residing in the Marea\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - MareaCarSvcAutoDvmtProp\n",
      "            - 2038\n",
      "    MareaHouseholdCarSvcDvmt:\n",
      "        kind: info\n",
      "        desc: Total DVMT in car service vehicles of persons in households and non-institutional\n",
      "            group quarters in Marea\n",
      "        transform: none\n",
      "        metamodeltype: linear\n",
      "        parser:\n",
      "            file: Measures_VERSPM_2010,2038_Marea=RVMPO.csv\n",
      "            loc:\n",
      "            - MareaHouseholdCarSvcDvmt\n",
      "            - 2038\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(pm_scope.dump(indent=4))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.675810Z",
     "start_time": "2020-11-17T23:10:34.673832Z"
    }
   },
   "outputs": [],
   "source": [
    "from emat.model.core_files.parsers import TableParser, MappingParser, loc, key\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:10:34.680405Z",
     "start_time": "2020-11-17T23:10:34.677519Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "loc['MareaHouseholdCarSvcDvmt','2038'] - loc['MareaHouseholdCarSvcDvmt','2010']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loc['MareaHouseholdCarSvcDvmt','2038'] - loc['MareaHouseholdCarSvcDvmt','2010']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-17T23:13:22.269554Z",
     "start_time": "2020-11-17T23:13:22.266154Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "loc['MareaHouseholdCarSvcDvmt','2038'] - loc['MareaHouseholdCarSvcDvmt','2010']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "eval(\"\"\"(\n",
    "loc['MareaHouseholdCarSvcDvmt','2038'] \n",
    "- loc['MareaHouseholdCarSvcDvmt','2010']\n",
    ")\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.6"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}