$api, 'origins' => $zip, 'destinations' => 'California State University, Los Angeles', 'units' => 'imperial');
$url = $endpoint . '?' . http_build_query($params);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$output = curl_exec($ch);
curl_close($ch);
$output = json_decode($output);
if($output->rows[0]->elements[0]->status != 'NOT_FOUND') {
$distance = $output->rows[0]->elements[0]->distance->text;
$distance = number_format(floatval(explode(" ", $distance)[0]), 2, '.', '');
}
return $distance;
}
$total_enrollment = 26671;
$on_campus_population = 650;
$daily_permits_percentage = 18.31;
$parking_permit_percentage = 37.44;
$public_transportation_percentage = 14.08;
$own_transportation_percentage = $daily_permits_percentage + $parking_permit_percentage;
$public_transportation_population = floor($public_transportation_percentage * $total_enrollment / 100);
$own_transportation_population = $total_enrollment - ($public_transportation_population + $on_campus_population);
$result = pg_query("SELECT * FROM transportation_survey WHERE year=2019 ORDER BY id");
$i = 0;
$own_transportation_energy = 0.0;
$public_transportation_energy = 0.0;
$public_transportation_count = 0;
$own_transportation_count = 0;
$total_energy = array();
$total_distance = array();
$energy_trend = array();
$total_energy["drove_alone"] = 0;
$total_energy["carpool"] = 0;
$total_energy["rideshare"] = 0;
$total_energy["metrolink"] = 0;
$total_energy["bus"] = 0;
$total_distance["drove_alone"] = 0;
$total_distance["carpool"] = 0;
$total_distance["rideshare"] = 0;
$total_distance["metrolink"] = 0;
$total_distance["bus"] = 0;
$energy_trend["sun"] = 0;
$energy_trend["mon"] = 0;
$energy_trend["tue"] = 0;
$energy_trend["wed"] = 0;
$energy_trend["thu"] = 0;
$energy_trend["fri"] = 0;
$energy_trend["sat"] = 0;
$bus = array();
$rail = array();
$carpool = array();
$rideshare = array();
$drove_alone = array();
$bus_count = array();
$rail_count = array();
$carpool_count = array();
$rideshare_count = array();
$drove_alone_count = array();
$no_commute_count = array();
$bus["sun"] = 0;
$bus["mon"] = 0;
$bus["tue"] = 0;
$bus["wed"] = 0;
$bus["thu"] = 0;
$bus["fri"] = 0;
$bus["sat"] = 0;
$rail["sun"] = 0;
$rail["mon"] = 0;
$rail["tue"] = 0;
$rail["wed"] = 0;
$rail["thu"] = 0;
$rail["fri"] = 0;
$rail["sat"] = 0;
$carpool["sun"] = 0;
$carpool["mon"] = 0;
$carpool["tue"] = 0;
$carpool["wed"] = 0;
$carpool["thu"] = 0;
$carpool["fri"] = 0;
$carpool["sat"] = 0;
$rideshare["sun"] = 0;
$rideshare["mon"] = 0;
$rideshare["tue"] = 0;
$rideshare["wed"] = 0;
$rideshare["thu"] = 0;
$rideshare["fri"] = 0;
$rideshare["sat"] = 0;
$drove_alone["sun"] = 0;
$drove_alone["mon"] = 0;
$drove_alone["tue"] = 0;
$drove_alone["wed"] = 0;
$drove_alone["thu"] = 0;
$drove_alone["fri"] = 0;
$drove_alone["sat"] = 0;
$bus_count["sun"] = 0;
$bus_count["mon"] = 0;
$bus_count["tue"] = 0;
$bus_count["wed"] = 0;
$bus_count["thu"] = 0;
$bus_count["fri"] = 0;
$bus_count["sat"] = 0;
$rail_count["sun"] = 0;
$rail_count["mon"] = 0;
$rail_count["tue"] = 0;
$rail_count["wed"] = 0;
$rail_count["thu"] = 0;
$rail_count["fri"] = 0;
$rail_count["sat"] = 0;
$carpool_count["sun"] = 0;
$carpool_count["mon"] = 0;
$carpool_count["tue"] = 0;
$carpool_count["wed"] = 0;
$carpool_count["thu"] = 0;
$carpool_count["fri"] = 0;
$carpool_count["sat"] = 0;
$rideshare_count["sun"] = 0;
$rideshare_count["mon"] = 0;
$rideshare_count["tue"] = 0;
$rideshare_count["wed"] = 0;
$rideshare_count["thu"] = 0;
$rideshare_count["fri"] = 0;
$rideshare_count["sat"] = 0;
$drove_alone_count["sun"] = 0;
$drove_alone_count["mon"] = 0;
$drove_alone_count["tue"] = 0;
$drove_alone_count["wed"] = 0;
$drove_alone_count["thu"] = 0;
$drove_alone_count["fri"] = 0;
$drove_alone_count["sat"] = 0;
$no_commute_count["sun"] = 0;
$no_commute_count["mon"] = 0;
$no_commute_count["tue"] = 0;
$no_commute_count["wed"] = 0;
$no_commute_count["thu"] = 0;
$no_commute_count["fri"] = 0;
$no_commute_count["sat"] = 0;
while($row = pg_fetch_assoc($result)) {
if($row['roundtrip_miles'] == NULL) {
$distance = number_format(getDistance($row['zipcode']) * 2, 2, '.', '');
pg_query("UPDATE transportation_survey SET roundtrip_miles=".$distance." WHERE zipcode='".$row['zipcode']."'");
}
else
$distance = $row['roundtrip_miles'];
$modes = array();
$modes["sun"] = $row['sun_mode'];
$modes["mon"] = $row['mon_mode'];
$modes["tue"] = $row['tue_mode'];
$modes["wed"] = $row['wed_mode'];
$modes["thu"] = $row['thu_mode'];
$modes["fri"] = $row['fri_mode'];
$modes["sat"] = $row['sat_mode'];
if(in_array(4, $modes) || in_array(6, $modes))
$public_transportation_count++;
else if (in_array(5, $modes) || in_array(3, $modes) || in_array(2, $modes))
$own_transportation_count++;
foreach ($modes as $key => $value) {
$trip_energy = 0;
switch ($value) {
case '2':
$vehicle_milage = $row['vehicle_milage'];
$vehicle_type = $row['vehicle_type'];
$vehicle_type_carbon = pg_fetch_assoc(pg_query("SELECT * FROM vehicle_type WHERE id=".$vehicle_type))['carbon_equivalent'];
$trip_energy = $distance * $vehicle_type_carbon;
$total_distance["drove_alone"] = $total_distance["drove_alone"] + $distance;
$total_energy["drove_alone"] = $total_energy["drove_alone"] + $trip_energy;
$drove_alone[$key] = $drove_alone[$key] + $trip_energy;
$drove_alone_count[$key] = $drove_alone_count[$key] + 1;
$own_transportation_energy += $trip_energy;
break;
case '3':
$vehicle_milage = 24.7;
$vehicle_type_carbon = pg_fetch_assoc(pg_query("SELECT * FROM vehicle_type WHERE id=1"))['carbon_equivalent'];
$persons = $row['carpool_persons'];
$trip_energy = $distance * $vehicle_type_carbon;
$trip_energy = $trip_energy / $persons;
$total_distance["carpool"] = $total_distance["carpool"] + $distance;
$total_energy["carpool"] = $total_energy["carpool"] + $trip_energy;
$carpool[$key] = $carpool[$key] + $trip_energy;
$carpool_count[$key] = $carpool_count[$key] + 1;
$own_transportation_energy += $trip_energy;
break;
case '4':
$vehicle_type_carbon = pg_fetch_assoc(pg_query("SELECT * FROM vehicle_type WHERE id=12"))['carbon_equivalent'];
$trip_energy = $distance * $vehicle_type_carbon;
$total_distance["metrolink"] = $total_distance["metrolink"] + $distance;
$total_energy["metrolink"] = $total_energy["metrolink"] + $trip_energy;
$rail[$key] = $rail[$key] + $trip_energy;
$rail_count[$key] = $rail_count[$key] + 1;
$public_transportation_energy += $trip_energy;
break;
case '5':
$vehicle_milage = 24.7;
$vehicle_type_carbon = pg_fetch_assoc(pg_query("SELECT * FROM vehicle_type WHERE id=1"))['carbon_equivalent'];
$trip_energy = $distance * $vehicle_type_carbon;
$total_distance["rideshare"] = $total_distance["rideshare"] + $distance;
$total_energy["rideshare"] = $total_energy["rideshare"] + $trip_energy;
$rideshare[$key] = $rideshare[$key] + $trip_energy;
$rideshare_count[$key] = $rideshare_count[$key] + 1;
$own_transportation_energy += $trip_energy;
break;
case '6':
$vehicle_type_carbon = pg_fetch_assoc(pg_query("SELECT * FROM vehicle_type WHERE id=11"))['carbon_equivalent'];
$trip_energy = $distance * $vehicle_type_carbon;
$total_distance["bus"] = $total_distance["bus"] + $distance;
$total_energy["bus"] = $total_energy["bus"] + $trip_energy;
$bus[$key] = $bus[$key] + $trip_energy;
$bus_count[$key] = $bus_count[$key] + 1;
$public_transportation_energy += $trip_energy;
break;
default:
$no_commute_count[$key] = $no_commute_count[$key] + 1;
}
$energy_trend[$key] = $energy_trend[$key] + $trip_energy;
}
}
foreach ($energy_trend as $key => $value) {
$energy_trend[$key] = number_format($energy_trend[$key], 2, '.', '');
}
foreach ($total_energy as $key => $value) {
$total_energy[$key] = number_format($total_energy[$key], 2, '.', '');
}
foreach ($total_distance as $key => $value) {
$total_distance[$key] = number_format($total_distance[$key], 2, '.', '');
}
$total_student_Emissions = ((($own_transportation_population / $own_transportation_count) * $own_transportation_energy) + (($public_transportation_population / $public_transportation_count) * $public_transportation_energy)) * (288 / 7);
?>
0) {
$mon_mode = $row['monday'];
$tue_mode = $row['tuesday'];
$wed_mode = $row['wednesday'];
$thu_mode = $row['thursday'];
$fri_mode = $row['friday'];
$mon_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$mon_mode'"))['carbon_equivalent'];
$tue_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$tue_mode'"))['carbon_equivalent'];
$wed_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$wed_mode'"))['carbon_equivalent'];
$thu_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$thu_mode'"))['carbon_equivalent'];
$fri_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$fri_mode'"))['carbon_equivalent'];
$employee_Emissions = $distance * ($mon_Emissions + $tue_Emissions + $wed_Emissions + $thu_Emissions + $fri_Emissions);
$total_employee_Emissions = $total_employee_Emissions + $employee_Emissions;
$total_employee_miles = $total_employee_miles + $distance;
}
}
else {
if($row['trip_distance'] > 0) {
$mon_mode = $row['monday'];
$tue_mode = $row['tuesday'];
$wed_mode = $row['wednesday'];
$thu_mode = $row['thursday'];
$fri_mode = $row['friday'];
$mon_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$mon_mode'"))['carbon_equivalent'];
$tue_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$tue_mode'"))['carbon_equivalent'];
$wed_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$wed_mode'"))['carbon_equivalent'];
$thu_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$thu_mode'"))['carbon_equivalent'];
$fri_Emissions = pg_fetch_assoc(pg_query("SELECT * FROM transportation_mode WHERE code='$fri_mode'"))['carbon_equivalent'];
$employee_Emissions = $row['trip_distance'] * ($mon_Emissions + $tue_Emissions + $wed_Emissions + $thu_Emissions + $fri_Emissions);
$total_employee_Emissions = $total_employee_Emissions + $employee_Emissions;
$total_employee_miles = $total_employee_miles + $row['trip_distance'];
}
}
}
$total_employee_Emissions = $total_employee_Emissions * (288 / 7);
$total_employee_miles = $total_employee_miles * (288 / 7);
$drove_alone_per_person = round((array_sum($drove_alone) * 100 ) / array_sum($drove_alone_count), 2);
$carpool_per_person = round((array_sum($carpool) * 100 ) / array_sum($carpool_count), 2);
$rideshare_per_person = round((array_sum($rideshare) * 100 ) / array_sum($rideshare_count), 2);
?>