Code Context $storms = $this->Storm->query($sql);
$this->set('stateName', $this->Constants->states_lookup[$state]);
$state = 'ar'
$county = '2340'
$loc = (int) 5605
$location = array(
'Location' => array(
'id' => '5605',
'country' => 'USA',
'zipcode' => '72204',
'state' => 'AR',
'city' => 'Little Rock',
'county' => 'Pulaski',
'county_id' => '2340',
'premium' => false,
'active' => true,
'perm' => true,
'is_airport' => false,
'activated' => null,
'timezone' => 'America/Chicago',
'notes' => null,
'archived' => false,
'type' => 'shape'
),
'County' => array(
'id' => '2340',
'state' => 'AR',
'name' => 'Pulaski',
'county_group_id' => '4',
'core' => false
)
)
$defs = array(
(int) 6 => 'Rain',
(int) 7 => 'Snow',
(int) 8 => 'Sleet',
(int) 9 => 'Freezing Rain',
(int) 10 => 'Wintry Mix',
(int) 11 => 'Ice',
(int) 12 => 'None',
(int) 13 => 'Snow / Sleet'
)
$seasons = '2025,2024,2023'
$sql = '
select *
from storms
join storm_locations on storm_locations.storm_id = storms.id
join narratives on narratives.id = storm_locations.narrative_id
where storms.season_id in (2025,2024,2023)
and storm_locations.published = 1
and storm_locations.deleted = 0
and storms.published = 1
and storms.deleted = 0
and storm_locations.location_id = 5605
'
$storms = array(
(int) 0 => array(
'storms' => array(
'id' => '65289',
'county_group_id' => '4',
'season_id' => '2023',
'author' => '149',
'publisher' => '149',
'min_start' => '2024-01-05 05:00:00',
'max_end' => '2024-01-05 17:00:00',
'storm_obs_set_id' => '42246',
'minutes_worked' => '75',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-07 03:03:01',
'scheduled_publish' => '2024-01-07 03:00:00',
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-05 12:27:55',
'modified' => '2024-02-05 21:14:57'
),
'storm_locations' => array(
'id' => '12467691',
'storm_id' => '65289',
'location_id' => '5605',
'narrative_id' => '838414',
'note_id' => null,
'start' => '2024-01-05 08:00:00',
'start_high' => null,
'end_low' => null,
'end' => '2024-01-05 12:00:00',
'precip_type' => '13',
'snow_amount' => '0.8',
'snow_trace' => null,
'ice_amount' => '0.00',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => null,
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '838414',
'storm_id' => '65289',
'is_notes' => false,
'label' => 'C',
'text' => '',
'title' => 'Period of Rain, Snow, and Sleet on January 5th',
'body' => 'A mix of rain, snow, and sleet occurred between 8 AM - 12 PM January 5th, before changing over to plain rain, with temperatures holding steady between 32 – 36 degrees. The precipitation was light in intensity throughout the event. ',
'footer' => '',
'title_template' => 'Period of Rain, Snow, and Sleet on #STORMDATE',
'body_template' => 'A mix of rain, snow, and sleet occurred between #WINDOW, before changing over to plain rain, with temperatures holding steady between 32 – 36 degrees. The precipitation was light in intensity throughout the event. ',
'footer_template' => '',
'start_low' => '2024-01-05 08:00:00',
'start_high' => null,
'end_low' => null,
'end_high' => '2024-01-05 12:00:00',
'time_mode' => 'window'
)
),
(int) 1 => array(
'storms' => array(
'id' => '65603',
'county_group_id' => '4',
'season_id' => '2023',
'author' => '149',
'publisher' => '149',
'min_start' => '2024-01-14 10:00:00',
'max_end' => '2024-01-15 18:00:00',
'storm_obs_set_id' => '42688',
'minutes_worked' => '90',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-17 14:03:00',
'scheduled_publish' => '2024-01-17 14:00:00',
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-14 14:05:22',
'modified' => '2024-04-01 16:40:25'
),
'storm_locations' => array(
'id' => '12604176',
'storm_id' => '65603',
'location_id' => '5605',
'narrative_id' => '840752',
'note_id' => null,
'start' => '2024-01-14 12:00:00',
'start_high' => '2024-01-14 15:00:00',
'end_low' => '2024-01-15 10:00:00',
'end' => '2024-01-15 13:00:00',
'precip_type' => '13',
'snow_amount' => '2.8',
'snow_trace' => null,
'ice_amount' => '0.00',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => null,
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '840752',
'storm_id' => '65603',
'is_notes' => false,
'label' => 'Little Rock',
'text' => '',
'title' => 'Periods of Snow and Sleet on January 14-15',
'body' => 'Areas of snow with some sleet moved into the region between 12 - 3 PM January 14th, with temperatures holding steady between 10 – 20 degrees. Sleet and snow showers continued through the evening and overnight hours, before tapering off between 10 AM - 1 PM January 15th. The precipitation was light to moderate in intensity throughout the event. ',
'footer' => '',
'title_template' => 'Periods of Snow and Sleet on #STORMDATE',
'body_template' => 'Areas of snow with some sleet moved into the region between #START, with temperatures holding steady between 10 – 20 degrees. Sleet and snow showers continued through the evening and overnight hours, before tapering off between #END. The precipitation was light to moderate in intensity throughout the event. ',
'footer_template' => '',
'start_low' => '2024-01-14 12:00:00',
'start_high' => '2024-01-14 15:00:00',
'end_low' => '2024-01-15 10:00:00',
'end_high' => '2024-01-15 13:00:00',
'time_mode' => 'startend'
)
),
(int) 2 => array(
'storms' => array(
'id' => '65731',
'county_group_id' => '4',
'season_id' => '2023',
'author' => '149',
'publisher' => '149',
'min_start' => '2024-01-18 06:00:00',
'max_end' => '2024-01-18 13:00:00',
'storm_obs_set_id' => '42803',
'minutes_worked' => '15',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-19 14:59:00',
'scheduled_publish' => null,
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-18 10:44:20',
'modified' => '2024-01-19 14:59:00'
),
'storm_locations' => array(
'id' => '12657857',
'storm_id' => '65731',
'location_id' => '5605',
'narrative_id' => '841367',
'note_id' => null,
'start' => '2024-01-18 06:30:00',
'start_high' => null,
'end_low' => null,
'end' => '2024-01-18 12:30:00',
'precip_type' => '9',
'snow_amount' => '0.0',
'snow_trace' => null,
'ice_amount' => '0.00',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => '4',
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '841367',
'storm_id' => '65731',
'is_notes' => false,
'label' => 'Little Rock',
'text' => '',
'title' => 'Period of Freezing Rain on January 18th',
'body' => 'A period of freezing rain occurred between 6:30 AM - 12:30 PM January 18th, with temperatures between 28 – 32 degrees. The precipitation was light in intensity throughout the event. ',
'footer' => '',
'title_template' => 'Period of Freezing Rain on #STORMDATE',
'body_template' => 'A period of freezing rain occurred between #WINDOW, with temperatures between 28 – 32 degrees. The precipitation was light in intensity throughout the event. ',
'footer_template' => '',
'start_low' => '2024-01-18 06:30:00',
'start_high' => null,
'end_low' => null,
'end_high' => '2024-01-18 12:30:00',
'time_mode' => 'window'
)
),
(int) 3 => array(
'storms' => array(
'id' => '65805',
'county_group_id' => '4',
'season_id' => '2023',
'author' => '149',
'publisher' => '149',
'min_start' => '2024-01-21 19:00:00',
'max_end' => '2024-01-22 15:00:00',
'storm_obs_set_id' => '42948',
'minutes_worked' => '30',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-23 17:46:38',
'scheduled_publish' => null,
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-20 11:20:32',
'modified' => '2024-02-05 21:16:06'
),
'storm_locations' => array(
'id' => '12687819',
'storm_id' => '65805',
'location_id' => '5605',
'narrative_id' => '842094',
'note_id' => null,
'start' => '2024-01-22 05:00:00',
'start_high' => null,
'end_low' => null,
'end' => '2024-01-22 12:00:00',
'precip_type' => '9',
'snow_amount' => '0.0',
'snow_trace' => null,
'ice_amount' => '0.10',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => null,
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '842094',
'storm_id' => '65805',
'is_notes' => false,
'label' => 'Little Rock',
'text' => '',
'title' => 'Periods of Freezing Rain on January 22nd',
'body' => 'A period of freezing rain occurred between 5 AM - 12 PM January 22nd, with temperatures holding steady between 30 – 32 degrees. The freezing rain then changed over to plain rain as temperatures rose to 33 – 36 degrees. The freezing rain was light to moderate in intensity throughout the event. ',
'footer' => '',
'title_template' => 'Periods of Freezing Rain on #STORMDATE',
'body_template' => 'A period of freezing rain occurred between #WINDOW, with temperatures holding steady between 30 – 32 degrees. The freezing rain then changed over to plain rain as temperatures rose to 33 – 36 degrees. The freezing rain was light to moderate in intensity throughout the event. ',
'footer_template' => '',
'start_low' => '2024-01-22 05:00:00',
'start_high' => null,
'end_low' => null,
'end_high' => '2024-01-22 12:00:00',
'time_mode' => 'window'
)
)
)
StormHistoryController::history() - APP/Controller/StormHistoryController.php, line 90
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 107
