0 && strlen($_REQUEST[county]) < 4) {
$county = $_REQUEST[county];
} else {
$county = 0;
}
if ( $county == 0) {
echo('Quarterly Statistics for Ohio
');
echo('Select a county name to view individual county data collection
');
} else {
$sql_cty="SELECT * FROM buckeye_counties where cty_id=" . $county;
$RScty = mysql_query($sql_cty);
while ( $row = mysql_fetch_array($RScty) ) {
$countyName = $row["County"];
}
echo('' . $countyName . ' County Safety Statistics
');
echo('View statistics for entire state of Ohio
');
}
?>
|
Civil Information |
Foreclosures |
| # received |
| # sold |
| # returned |
CCW License |
| # registered |
Sex Offenders |
| # registered |
| # of verifications |
Court Process |
| # papers received |
| # papers served |
Law Enforcement Information |
Calls for Service |
| #of incoming calls |
Incidents |
| # of Offense Reports or Incident Reports |
Crashes |
| # of crash reports taken |
| # of crash assists to other agencies |
Traffic Citations |
| # of moving violations |
| # of non-moving violations |
Arrests |
| # of Felony arrests |
| # of Misdemeanor arrests |
Jail Information |
Bookings |
| # of Bookings |
Average Daily Population |
| # of Felons |
| # sentenced |
| # pre-trial detainees |
| # of Misdemeanants |
| # sentenced |
| # pre-trial detainees |
| # of Males |
| # of Females |
|
0) {
$sql_totals="SELECT
SUM(foreclosures_received) as var1,
SUM(foreclosures_sold) as var2,
SUM(foreclosures_returned) as var3,
SUM(ccw_licensed) as var4,
SUM(so_registered) as var5,
SUM(so_verifications) as var6,
SUM(papers_received) as var7,
SUM(papers_served) as var8,
SUM(incoming_calls) as var9,
SUM(offense_reports) as var10,
SUM(crash_reports) as var11,
SUM(crash_assists) as var12,
SUM(moving_violations) as var13,
SUM(nonmoving_violations) as var14,
SUM(felony_arrests) as var15,
SUM(misdemeanor_arrests) as var16,
SUM(bookings) as var17,
SUM(felons) as var18,
SUM(felons_sentenced) as var19,
SUM(felons_detainees) as var20,
SUM(misdemeanants) as var21,
SUM(misdemeanants_sentenced) as var22,
SUM(misdemeanants_detainees) as var23,
SUM(males) as var24,
SUM(females) as var25
FROM buckeye_stats
WHERE report_period=" . $row["b_stats_time_id"] . $where;
$RStotals = mysql_query($sql_totals);
while ( $rowT = mysql_fetch_array($RStotals) ) {
echo ('');
echo ('');
echo ('' . $row["buckeye_date"] . '
' . $row["buckeye_time"] . ' | ');
echo (' | ');
echo (' | ');
echo ('| ' . $rowT["var1"] . ' | ');
echo ('| ' . $rowT["var2"] . ' | ');
echo ('| ' . $rowT["var3"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var4"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var5"] . ' | ');
echo ('| ' . $rowT["var6"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var7"] . ' | ');
echo ('| ' . $rowT["var8"] . ' | ');
echo (' | ');
echo (' | ');
echo ('| ' . $rowT["var9"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var10"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var11"] . ' | ');
echo ('| ' . $rowT["var12"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var13"] . ' | ');
echo ('| ' . $rowT["var14"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var15"] . ' | ');
echo ('| ' . $rowT["var16"] . ' | ');
echo (' | ');
echo (' | ');
echo ('| ' . $rowT["var17"] . ' | ');
echo (' | ');
echo ('| ' . $rowT["var18"] . ' | ');
echo ('| ' . $rowT["var19"] . ' | ');
echo ('| ' . $rowT["var20"] . ' | ');
echo ('| ' . $rowT["var21"] . ' | ');
echo ('| ' . $rowT["var22"] . ' | ');
echo ('| ' . $rowT["var23"] . ' | ');
echo ('| ' . $rowT["var24"] . ' | ');
echo ('| ' . $rowT["var25"] . ' | ');
echo (' ');
echo (' | ');
} //end while
} else {
echo "
{$row['buckeye_date']}
{$row['buckeye_time']}
|
";
echo (' | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo (' | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo (' | ');
echo (' | ');
echo ('| | ');
echo (' | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo ('| | ');
echo (' ');
echo (' | ');
} //end if
} //$RSdates
?>
' . $num_reporting . ' counties reporting.');
}
?>
