Addiction and Treatment Statistics for Flagstaff, Arizona
June 25, 2020
In central Arizona the city of Flagstaff is a mid-sized metropolis home to Northern Arizona University, the Arizona Snowbowl and the Grand Canyon Railway. Located less than 75 miles south of the Grand Canyon National Park, Flagstaff is in Coconino County and is easily accessible via Interstate 40 and U.S. Highway 180.
Airport Information
South of downtown Flagstaff is the Flagstaff Pulliam Airport. It’s the closest commercial airport serving the city and is just five miles from downtown. Visitors to Flagstaff can fly in via U.S. Airway Express, which is a connecting flight from the Phoenix Sky Harbor International Airport. These connecting flights are available daily. Another option is the Phoenix Sky Harbor International Airport, about a 2 hour and 15 minute drive from Flagstaff. It’s the 11th busiest airport in the world and offers flights to destinations throughout the U.S. and world.
Rehab Facilities and Healthcare
The Flagstaff Medical Center’s Behavioral Health Services offers both inpatient and outpatient care. Services and programs focus on substance addiction and mental health, providing 24-hour medical care that is private and comprehensive. Inpatient services range from alcohol/drug detox programs to treatment for emotional/behavioral disorders. Outpatient services include relapse prevention, DUI evaluation, psychological testing, therapy sessions, and outpatient programs designed for chemical dependency.
Places to Stay
Whether visiting a patient at a treatment center in Flagstaff or visiting the city to check out relocation possibilities, the area offers many choices for overnight stays. Not only is the Flagstaff Medical Center close to Interstate 40, it’s also minutes from Amtrak, the Flagstaff Plaza and places to stay such as The Inn at 410 Bed & Breakfast, England House Bed & Breakfast, Hotel Monte Vista and the Hotel Aspen Flagstaff Grand Canyon.
Hotel options throughout the city include upscale accommodations from Embassy Suites, the Hilton Garden Inn, the Radisson Woodlands and the Twin Arrows Casino Resort. National chain hotels in Flagstaff include Drury Inn & Suites, Fairfield Inn, La Quinta, SpringHill Suites, Hampton Inn and Holiday Inn Express. The Weatherford is a local hotel and located in the heart of downtown Flagstaff.
Employment Opportunities
As a mid-size city, Flagstaff offers a variety of employment opportunities to patients who’ve recently completed an inpatient stay at a rehab facility. Flagstaff has a thriving tourism economy which provides many jobs in industries such as accommodations, food service, maintenance, construction, entertainment and the arts. Both the health care and the educational industries are blossoming in Flagstaff as well.
Weather in Flagstaff
Flagstaff enjoys low humidity year-round plus more days of sunshine than the average U.S. city. July and August are the warmest months with average highs in the 80s and lows that can reach 50. December and January are the coolest months with highs in the 40s and lows in the teens. Snow can and does fall in Flagstaff but the city enjoys below average precipitation throughout the year in comparison to other U.S. cities.
//$startTime = microtime(true);
require_once 'inc/db.php';
require_once 'inc/lookups.php';
$requestLookup = $requestLookup ? $requestLookup : sanitize_text_field($_GET['lookup']);
$requestState = $requestState ? $requestState : sanitize_text_field($_GET['state']);
$requestCity = $requestCity ? $requestCity : sanitize_text_field($_GET['city']);
$requestLocation = $requestLocation? $requestLocation : sanitize_text_field($_GET['location']);
$dataOnly = $dataOnly ? $dataOnly : (bool) $_GET['dataonly'];
if ($requestLookup) {
if (array_key_exists($requestLookup, $lookupGroups)) {
$lookup = $requestLookup;
if (is_array($lookupGroups[$lookup])) {
$lookupGroup = $lookupGroups[$lookup];
}
$lookupName = $lookupTitles[$lookup];
}
if (!$lookup) {
$err['lookup'] = "Sorry, we couldn't find that category.";
}
}
if ($requestState && $lookup) {
$stateSlug = str_replace('-'.$requestLookup, '', $requestState);
$state = Model::factory('State')->where('url', $stateSlug)->find_one();
if (!$state) {
$err['state'] = "Sorry, we couldn't find that state.";
$is404 = true;
}
}
if ($requestCity && $state) {
$city = $state->city()->where('url', $requestCity)->find_one();
if (!$city) {
$err['city'] = "Sorry, we couldn't find that city.";
$is404 = true;
}
}
if ($requestLocation && $city ) {
/* Fetch Location Only under primary Lookup*/
if($lookup=='rehab-centers')
$location = $city->location()->where('url', $requestLocation)->find_one();
if (!$location) {
$err['location'] = "Sorry, we couldn't find that location.";
$is404 = true;
}
/* Special Header Addons - Locations Under Sub Lookups*/
if($lookup!='rehab-centers')
$sublookup_head = true;
}
/***
* Let's work backwards with what we have.
***/
// City Table Column Selector :: Num Locations by Lookup
switch($lookup){
case 'inpatient-rehab-centers' : $col = 'num_inpa'; break;
default : $col = 'num_locations';
}
if ($location) {
$attributes['S'] = $attributes['T'] = $attributes['D'] = $attributes['P'] = array();
foreach ($location->attribute()->find_many() as $attribute) {
$attributes[$attribute->type][] = $attribute;
}
$mapAddress = urlencode($location->location_street1 . ' ' . $location->location_street2 . ' ' . $city->name . ' ' . $state->abbr);
if ($dataOnly) {
// Reserved for location data-only
} else {
include_once 'templates/location.php';
}
}
else if ($city) {
if ($lookup == 'inpatient-rehab-centers') {
// Special case; exclude outpatient rehabs from inpatient list
$locations = ORM::for_table('location')
->raw_query('SELECT location.*
FROM location JOIN attribute_location ON location.id = attribute_location.location_id
WHERE location.city_id = ?
AND attribute_location.attribute_id IN (25,26,27)
AND location.id NOT IN (
SELECT location_id
FROM attribute_location
WHERE attribute_id = 23
)
GROUP BY location.id', array($city->id))
->find_many();
}
elseif ($lookupGroup) {
$built_re_state = explode('-'.$requestLookup,$requestState)[0];
$build_redirect = '/rehab-centers/'.$built_re_state.'-rehab-centers/'.$requestCity.'/';
header("HTTP/1.1 301 Moved Permanently");
header('Location: https://www.rehabcenter.net' . $build_redirect);
exit();
// Standard lookups
//$locations = ORM::for_table('location')->where('location.city_id', $city->id)->join('attribute_location', array('location.id', '=', 'attribute_location.location_id'))->where_in('attribute_location.attribute_id', $lookupGroup)->group_by('location.id')->find_many();
}
else {
// Show all rehab centers
$locations = $city->location()->find_many();
}
/* Show City Page Only if # Segments exist*/
if(count($segments)==3&&!$is404){
if ($dataOnly) {
// Reserved for city data-only
include_once 'templates/city-data.php';
} else {
include_once 'templates/city.php';
}
}
}elseif ($state) {
if ($lookup == 'inpatient-rehab-centers') {
// Special case; exclude outpatient rehabs from inpatient list
$cities = ORM::for_table('city')
->raw_query('SELECT city.*
FROM city
JOIN location ON city.id = location.city_id
JOIN attribute_location ON location.id = attribute_location.location_id
WHERE city.state_id = ?
AND attribute_location.attribute_id IN (25,26,27)
AND location.id NOT IN (
SELECT location_id
FROM attribute_location
WHERE attribute_id = 23
)
GROUP BY city.id', array($state->id))
->find_many();
}
else if ($lookupGroup) {
$cities = ORM::for_table('city')->select('city.*')->where('city.state_id', $state->id)->join('location', array('city.id', '=', 'location.city_id'))->join('attribute_location', array('location.id', '=', 'attribute_location.location_id'))->where_in('attribute_location.attribute_id', $lookupGroup)->group_by('city.id')->find_many();
}
else {
$cities = $state->city()->find_many();
}
// Let's make sure we only have # segments on the URL array(3)
if(count($segments)==2){
if ($dataOnly) {
include_once 'templates/state-data.php';
} else {
include_once 'templates/state.php';
}
}
}
else if ($lookup&&!$is404) {
$states = Model::factory('State')->find_many();
if ($dataOnly&&!$is404) {
include_once 'templates/lookup-data.php';
} else {
include_once 'templates/lookup.php';
}
}
else {
$is404 = true;
header('HTTP/1.0 404 Not Found');
}
// $endTime = microtime(true);
//echo '';
?>