[[["1307 NE 102ND AVE STE L-2, Portland, OR"]],[["111 Coors Blvd. NW Suite C5 and C6, Albuquerque, NM"]],[["2415 HIGHWAY 93 NORTH STE 1, Kalispell, MT"]],[["2760 CANYON BLVD, BOULDER, CO"]],[["6949 PARK CENTRE DR, Salt Lake City, UT"]],[["4585 E 2nd St, Casper, WY"]],[["1620 N School St. #123, Honolulu, HI"]],[["2330 Kalakaua Avenue Space 231, Honolulu, HI"]],[["1821 S SAN JACINTO AVE STE A, San Jacinto, CA"]],[["40820 WINCHESTER ROAD UNIT 1130, TEMECULA, CA"]],[["7100 SANTA MONICA BLVD STE 117, WEST HOLLYWOOD, CA"]],[["3855 Overland Avenue, CULVER CITY, CA"]],[["9006 SEPULVEDA BLVD, NORTH HILLS, CA"]],[["7160 W Beverly Blvd, Los Angeles, CA"]],[["18100 Chatsworth St, Granada Hills, CA"]],[["32195 Temecula Parkway, Temecula, CA"]],[["9060 Tampa Ave., Northridge, CA"]],[["40464 Winchester Road, Temecula, CA"]],[["6000 Sepulveda Blvd STE 1521, Culver City, CA"]],[["8687 North Central Expy Suite 2304, Dallas, TX"]],[["Northridge Fashion Center 9301 Tampa Ave, Northridge, CA"]],[["4929 Junipero Serra Blvd, Colma, CA"]],[["510 Showers Drive Suite 1, Mountain View, CA"]],[["1501 SLOAT BLVD STE C, San Francisco, CA"]],[["436 Westlake Center, Daly City, CA"]],[["3251 20TH AVE. SUITE 242, SAN FRANCISCO, CA"]],[["5800 NORTHGATE MALL STE 106, SAN RAFAEL, CA"]],[["1150 EL CAMINO REAL SUITE #191, SAN BRUNO, CA"]],[["365 S MCDOWELL BLVD, PETALUMA, CA"]],[["2527 EL CAMINO REAL, REDWOOD CITY, CA"]],[["1135 INDUSTRIAL RD STE B, San Carlos, CA"]],[["132 Vintage Way Space #F-11, Novato, CA"]],[["830 Market Street, San Francisco, CA"]],[["350 N Milwaukee ST STE 1183, Boise, ID"]],[["9311 COORS BLVD NW STE 01-3, Albuquerque, NM"]],[["1119 S SANDERSON AVE, HEMET, CA"]],[["2825 W Main ST Space #5H, Bozeman, MT"]],[["6800 Balboa Blvd STE H, Van Nuys, CA"]],[["2910 N. Campbell Avenue, Tucson, AZ"]],[["9700 WOODMAN AVE STE 20A, Arleta, CA"]],[["8164 W. Overland Rd, Boise, ID"]],[["1580 NW 9th St Suite 104, Corvallis, OR"]],[["330 Eubank NE STE C, Albuquerque, NM"]],[["127-C SERRAMONTE CTR, Daly City, CA"]],[["6600 Topanga Canyon #2001, Canoga Park, CA"]],[["750 Stony Point Plaza Suite A165, Santa Rosa, CA"]],[["3000 184TH ST SW STE 580, Lynnwood, WA"]],[["24919 PICO CANYON RD, STEVENSON RANCH, CA"]],[["1400 DELL RANGE SPACE 66, CHEYENNE, WY"]],[["31840 PACIFIC HWY S STE B, Federal Way, WA"]],[["1321 N Columbia Center Blvd STE 479, Kennewick, WA"]],[["4328 SE 82ND AVE STE 3000, Portland, OR"]],[["1200 TOWNE CENTER BLVD SPACE 1088, PROVO, UT"]],[["152 S. RIO GRANDE ST SPACE # 1111, SALT LAKE CITY, UT"]],[["25312 Madison Ave, Murrieta, CA"]],[["10800 WEST PICO BLVD SPACE 353, LOS ANGELES, CA"]],[["15600 NE 8TH STE B-2, Bellevue, WA"]],[["1933 S COMMONS STE E-22, FEDERAL WAY, WA"]],[["24201 VALENCIA BLVD. SUITE 2089, VALENCIA, CA"]],[["960 S. Colorado Blvd, Denver, CO"]],[["801 S. Workman St., San Fernando, CA"]],[["19203 Ventura Blvd., Tarzana, CA"]],[["831 LANCASTER DR NE STE 27, SALEM, OR"]],[["8000 Van Nuys, Van Nuys, CA"]],[["5620 East Broadway Blvd., Tucson, AZ"]],[["757 E 20TH AVE Ste 380, Denver, CO"]],[["457 HILLSDALE MALL SPC 2132, SAN MATEO, CA"]],[["405 E WETMORE RD Ste G113, Tucson, AZ"]],[["7505 EAST 35TH AVENUE, DENVER, CO"]],[["1910 LINCOLN BLVD, SANTA MONICA, CA"]],[["2673 MISSION ST, SAN FRANCISCO, CA"]],[["N 1102 COLUMBIA CTR BLVD STE B, KENNEWICK, WA"]]]

$address = pg_query($conn, "
SELECT
CONCAT(incident.address, ', ' ,incident.city, ', ' , incident.state_1)
FROM
  fpscdb001_ws_001.incident
WHERE
  incident.initial_symptom = 'Chrome Upgrade' AND
  incident.status_1 = 'staging' AND
  incident.site_id != '2RS' AND
  incident.soft_delete_id < '1';");

  if (!$address) {
      echo "Query failedn";
      exit;
    }

while ($coords = pg_fetch_row($address)){
$arr[] = array($coords);
}
echo json_encode($arr);

var xhrred = new XMLHttpRequest();
xhrred.onreadystatechange = function() {

if (xhrred.readyState == 4) {
var arrred = JSON.parse(xhrred.responseText);
console.log(xhrred.responseText);
if(Array.isArray(arrred)){
showMarkersRed(arrred);
}
}
}
xhrred.open('GET', 'rest.php', true);
xhrred.send();