Road Use Tax Fund Efficiency Report, June 30, 2013

Senate File 2314, 84th General Assembly, states the Iowa Department of Transportation shall submit quarterly reports regarding the implementation of efficiency measures identified in the "Road Use Tax Fund Efficiency Report," January 2012. This report shall provide details of activities undertaken in the previous quarter relating to one-time and long-term program efficiencies and partnership efficiencies. Issues covered include savings realized from the implementation of particular efficiency measures; updates concerning measures that have not been implemented; efforts involving cities, counties, other jurisdictions, or stakeholder interest groups; any new efficiency measures identified or undertaken; and identification of any legislative action that may be required to achieve efficiencies.

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, June 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, July 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.

MEPDG Work Plan Task No. 7: Existing Pavement Input Information for the Mechanistic-Empirical Pavement Design Guide, 2009

The objective of this study is to systematically evaluate the Iowa Department of Transportation’s (DOT’s) existing Pavement Management Information System (PMIS) with respect to the input information required for Mechanistic-Empirical Pavement Design Guide (MEPDG) rehabilitation analysis and design. To accomplish this objective, all of available PMIS data for interstate and primary roads in Iowa were retrieved from the Iowa DOT PMIS. The retrieved data were evaluated with respect to the input requirements and outputs for the latest version of the MEPDG software (version 1.0). The input parameters that are required for MEPDG HMA rehabilitation design, but currently unavailable in the Iowa DOT PMIS were identified. The differences in the specific measurement metrics used and their units for some of the pavement performance measures between the Iowa DOT PMIS and MEPDG were identified and discussed. Based on the results of this study, it is recommended that the Iowa DOT PMIS should be updated, if possible, to include the identified parameters that are currently unavailable, but are required for MEPDG rehabilitation design. Similarly, the measurement units of distress survey results in the Iowa DOT PMIS should be revised to correspond to those of MEPDG performance predictions. *******************Large File**************************

MEPDG Work Plan Task No. 8: Validation of Pavement Performance Curves for the Mechanistic-Empirical Pavement Design Guide, 2009

The objective of this research is to determine whether the nationally calibrated performance models used in the Mechanistic-Empirical Pavement Design Guide (MEPDG) provide a reasonable prediction of actual field performance, and if the desired accuracy or correspondence exists between predicted and monitored performance for Iowa conditions. A comprehensive literature review was conducted to identify the MEPDG input parameters and the MEPDG verification/calibration process. Sensitivities of MEPDG input parameters to predictions were studied using different versions of the MEPDG software. Based on literature review and sensitivity analysis, a detailed verification procedure was developed. A total of sixteen different types of pavement sections across Iowa, not used for national calibration in NCHRP 1-47A, were selected. A database of MEPDG inputs and the actual pavement performance measures for the selected pavement sites were prepared for verification. The accuracy of the MEPDG performance models for Iowa conditions was statistically evaluated. The verification testing showed promising results in terms of MEPDG’s performance prediction accuracy for Iowa conditions. Recalibrating the MEPDG performance models for Iowa conditions is recommended to improve the accuracy of predictions. ****************** Large File**************************

Non-Destructive Evaluation of Iowa Pavements Phase 2: Development of a Fully Automated Software System for Rapid Analysis/Processing of the Falling Weight Deflectometer Data, 2009

The Office of Special Investigations at Iowa Department of Transportation (DOT) collects FWD data on regular basis to evaluate pavement structural conditions. The primary objective of this study was to develop a fully-automated software system for rapid processing of the FWD data along with a user manual. The software system automatically reads the FWD raw data collected by the JILS-20 type FWD machine that Iowa DOT owns, processes and analyzes the collected data with the rapid prediction algorithms developed during the phase I study. This system smoothly integrates the FWD data analysis algorithms and the computer program being used to collect the pavement deflection data. This system can be used to assess pavement condition, estimate remaining pavement life, and eventually help assess pavement rehabilitation strategies by the Iowa DOT pavement management team. This report describes the developed software in detail and can also be used as a user-manual for conducting simulation studies and detailed analyses. *********************** Large File ***********************

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, August 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.

Road Use Tax Fund Efficiency Report, September 2013

Senate File 2314, 84th General Assembly, states the Iowa Department of Transportation shall submit quarterly reports regarding the implementation of efficiency measures identified in the "Road Use Tax Fund Efficiency Report," January 2012. This report shall provide details of activities undertaken in the previous quarter relating to one-time and long-term program efficiencies and partnership efficiencies. Issues covered include savings realized from the implementation of particular efficiency measures; updates concerning measures that have not been implemented; efforts involving cities, counties, other jurisdictions, or stakeholder interest groups; any new efficiency measures identified or undertaken; and identification of any legislative action that may be required to achieve efficiencies.

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, September 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.

Mynodbcsv: Lightweight Zero-Config Database Solution for Handling Very Large CSV Files.

Volumes of data used in science and industry are growing rapidly. When researchers face the challenge of analyzing them, their format is often the first obstacle. Lack of standardized ways of exploring different data layouts requires an effort each time to solve the problem from scratch. Possibility to access data in a rich, uniform manner, e.g. using Structured Query Language (SQL) would offer expressiveness and user-friendliness. Comma-separated values (CSV) are one of the most common data storage formats. Despite its simplicity, with growing file size handling it becomes non-trivial. Importing CSVs into existing databases is time-consuming and troublesome, or even impossible if its horizontal dimension reaches thousands of columns. Most databases are optimized for handling large number of rows rather than columns, therefore, performance for datasets with non-typical layouts is often unacceptable. Other challenges include schema creation, updates and repeated data imports. To address the above-mentioned problems, I present a system for accessing very large CSV-based datasets by means of SQL. It's characterized by: "no copy" approach - data stay mostly in the CSV files; "zero configuration" - no need to specify database schema; written in C++, with boost [1], SQLite [2] and Qt [3], doesn't require installation and has very small size; query rewriting, dynamic creation of indices for appropriate columns and static data retrieval directly from CSV files ensure efficient plan execution; effortless support for millions of columns; due to per-value typing, using mixed text/numbers data is easy; very simple network protocol provides efficient interface for MATLAB and reduces implementation time for other languages. The software is available as freeware along with educational videos on its website [4]. It doesn't need any prerequisites to run, as all of the libraries are included in the distribution package. I test it against existing database solutions using a battery of benchmarks and discuss the results.

Iowa Plan for Energy Independence, 2007

Iowa’s first annual Energy Independence Plan kicks off a new era of state leadership in energy transformation. Supported by Governor Chet Culver, Lieutenant Governor Patty Judge, and the General Assembly, the Office of Energy Independence was established in 2007 to coordinate state activities for energy independence. The commitment of the state to lead by example creates opportunities for state government to move boldly to achieve its goals, track its progress, measure the results, and report the findings. In moving to energy independence, the active engagement of every Iowan will be sought as the state works in partnership with others in achieving the goals. While leading ongoing efforts within the state, Iowa can also show the nation how to effectively address the critical, complex challenges of shifting to a secure energy future of affordable energy, cost-effective efficiency, reliance on sustainable energy, and enhanced natural resources and environment. In accordance with House File 918, “the plan shall provide cost effective options and strategies for reducing the state’s consumption of energy, dependence on foreign sources of energy, use of fossil fuels, and greenhouse gas emissions. The options and strategies developed in the plan shall provide for achieving energy independence from foreign sources of energy by the year 2025.” Energy independence is a term which means different things to different people. We use the term to mean that we are charting our own course in the emerging energy economy. Iowa can chart its own course by taking advantage of its resources: a well-educated population and an abundance of natural resources, including rich soil, abundant surface and underground water, and consistent wind patterns. Charting our own course also includes further developing our in-state industry, capturing renewable energy, and working toward improved energy efficiency. Charting our own course will allow Iowa to manage its economic destiny while protecting our environment, while creating new, “green collar” industries in every corner of Iowa. Today Iowa is in a remarkable position to capitalize on the current situation globally and at home. Energy drives the economy and has impacts on the environment, undeniable links that are integral for energy security and independence. With the resources available within the state, the combination of significant global changes in energy and research leading to new technologies that continue to drive down the costs of sustainable energy, Iowa can take bold strides toward the goal of energy independence by 2025. The Office of Energy Independence, with able assistance from hundreds of individuals, organizations, agencies, and advisors, presents its plan for Iowa’s Energy Independence.

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, October 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.

Prevalence and correlates of DSM-5 bipolar and related disorders and hyperthymic personality in the community.

BACKGROUND: To 1) establish the lifetime and 12-month prevalence of DSM-5 bipolar and related disorders including the new algorithmically defined conditions grouped within Other Specified Bipolar and Related Disorders (OSBARD) as well as hyperthymic personality in a randomly selected community sample, and 2) determine the clinical relevance of the OSBARD category in terms of sociodemographic characteristics, course, comorbidity and treatment patterns by comparing the subjects of this category to those with bipolar-I (BP-I), bipolar-II (BP-II), major depressive disorder (MDD), and those with no history of mood disorders. METHODS: The semi-structured Diagnostic Interview for Genetic Studies was administered by masterslevel psychologists to a random sample of an urban area (n=3'719). RESULTS: The lifetime prevalence was 1.0% for BP-I, 0.8% for BP-II, 1.0% for OSBARD and 3% for hyperthymic personality. Subjects with OSBARD were more severely affected than subjects without a history of mood disorders regarding almost all clinical correlates. Compared to those with MDD, they also revealed an elevated risk of suicidal attempts, lower global functioning, more treatment seeking and more lifetime comorbidity including anxiety, substance use and impulse-control disorders. However, they did not differ from subjects with BP-II. LIMITATIONS: Small sample sizes for bipolar and related disorders and potential inaccurate recall of symptoms. CONCLUSIONS: The modifications of diagnostic criteria for manic/hypomanic episodes according to the DSM-5 only marginally affect the prevalence estimates for BP-I and BP-II. The new DSM-5 OSBARD category is associated with significant clinical burden, is hardly distinct from BP-II with respect to clinical correlates and deserves similar clinical attention.

Pieces of Iowa’s Past, April 4, 2012

Pieces of Iowa’s Past, published by the Iowa State Capitol Tour Guides weekly during the legislative session, features historical facts about Iowa, the Capitol, and the early workings of state government. All historical publications are reproduced here with the actual spelling, punctuation, and grammar retained. April 4, 2012 THIS WEEK: Dating an Epoch from Photographs. BACKGROUND: Iowa State Capitol Grounds Extension Project The Capitol extension project began about 1913. The purpose of the project was to purchase land surrounding the Capitol in order to improve the beauty of the grounds and obtain enough land to build new structures and alleviate the overcrowding in the Capitol. Senate File 538 levied a tax to pay for the purchase of the property. Van Buren and Wapello counties filed a suit against the state because it was believed by many people that this statewide tax was simply providing Des Moines with a “new park.” This case was argued before the Iowa Supreme Court and the photographs that follow are a portion of the brief filed with the Court.

B-1 Monthly Report of Medical Services Provided under Title XIX of the Social Security Act, November 2013

B-1 Medicaid Reports -- The monthly Medicaid series of eight reports provide summaries of Medicaid eligibles, recipients served, and total payments by county, category of service, and aid category. These reports may also be known as the B-1 Reports. These reports are each available as a PDF for printing or as a CSV file for data analysis. Report Report name IAMM1800-R001--Medically Needy by County - No Spenddown and With Spenddown; IAMM1800-R002--Total Medically Needy, All Other Medicaid, and Grand Total by County; IAMM2200-R002--Monthly Expenditures by Category of Service; IAMM2200-R003--Fiscal YTD Expenditures by Category of Service; IAMM3800-R001--ICF & ICF-MR Vendor Payments by County; IAMM4400-R001--Monthly Expenditures by Eligibility Program; IAMM4400-R002--Monthly Expenditures by Category of Service by Program; IAMM4600-R002--Elderly Waiver Summary by County.