[{"latitude":"0","longitude":"0","branchName":"Johnstone Supply","branchId":"928","branchCode":"88","locality":"Birmingham, AL 35223","street":"3801 1st Ave North","phone":"(205) 251-3440","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Birmingham","state":"AL","zip":"35223","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":928,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.johnstonesupply.com/store88"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":928,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Johnstone Supply","branchId":"929","branchCode":"700","locality":"Dothan, AL 36301","street":"739 SOUTH OATES STREET","phone":"(334)-792-3148","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Dothan","state":"AL","zip":"36301","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":929,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.johnstonesupply.com/store700"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":929,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"United Refrigeration","branchId":"935","branchCode":"E8","locality":"Mobile, AL 36606","street":"2300 Halls Mill Road","phone":"251-450-0044","faxNum":"","workHour":"","note":"","email":"branche8@uri.com","distance":0.0,"city":"Mobile","state":"AL","zip":"36606","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":935,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":935,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.uri.com/"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Johnstone Supply","branchId":"932","branchCode":"546","locality":"Montgomery, AL 36110","street":"4405 Northchase Blvd","phone":"334-612-7052","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Montgomery","state":"AL","zip":"36110","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":932,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.johnstonesupply.com/store546"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":932,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"United Refrigeration","branchId":"937","branchCode":"427","locality":"Birmingham, AL 35222","street":"516 A 35th Street North","phone":"205-307-7800","faxNum":"","workHour":"","note":"","email":"branch427@uri.com","distance":0.0,"city":"Birmingham","state":"AL","zip":"35222","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":937,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.uri.com/"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":937,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"APEX CONTROLS Veris Disctributors","branchId":"908","branchCode":"55400","locality":"West Chester, PA 19382","street":"24 Hagerty Boulevard, Suite 6","phone":"310-344-9156","faxNum":"sales@apexcontrols.c","workHour":"","note":"","email":"sales@apexcontrols.com","distance":0.0,"city":"West Chester","state":"PA","zip":"19382","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":908,"fieldName":" WAREHOUSE_URL","customFieldvalue":" "},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":908,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Johnstone Supply","branchId":"931","branchCode":"481","locality":"Mobile, AL 36693","street":"776 Lakeside Drive","phone":"251-343-3899","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Mobile","state":"AL","zip":"36693","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":931,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.johnstonesupply.com/store481"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":931,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Arizona Climate Supply","branchId":"942","branchCode":"ACS2","locality":"Mesa, AZ 85210","street":"130 W Hampton Ave #9","phone":"480-219-9740","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Mesa","state":"AZ","zip":"85210","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":942,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":942,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://azclimatesupply.com/"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Johnstone Supply","branchId":"930","branchCode":"676","locality":"Huntsville, AL 35816","street":"1120 PUTMAN DR N.W.","phone":"256-430-3440","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Huntsville","state":"AL","zip":"35816","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":930,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.johnstonesupply.com/store152"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":930,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"United Refrigeration","branchId":"936","branchCode":"410","locality":"Montgomery, AL 36109","street":"1100 Lincoln Road","phone":"334-262-1210","faxNum":"","workHour":"","note":"","email":"branch410@uri.com","distance":0.0,"city":"Montgomery","state":"AL","zip":"36109","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":936,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.uri.com/"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":936,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Hasco, Inc.","branchId":"940","branchCode":"Hasco","locality":"Anchorage, AK 99503","street":"136 EAST 6TH AVE","phone":"","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Anchorage","state":"AK","zip":"99503","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":940,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":940,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://www.hascoak.com/"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Arizona Climate Supply","branchId":"941","branchCode":"ACS","locality":"Phoenix, AZ 85009","street":"2930 W Willetta St","phone":"602-278-3020","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Phoenix","state":"AZ","zip":"85009","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":941,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":941,"fieldName":" WAREHOUSE_URL","customFieldvalue":"https://azclimatesupply.com/"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"CONTROLCO","branchId":"943","branchCode":"ctrlco","locality":"Pleasant Hill, CA 94523","street":"2493 Estand Way","phone":"510-636-7900","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Pleasant Hill","state":"CA","zip":"94523","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":943,"fieldName":"DISTRIBUTOR_URL","customFieldvalue":"https://controlco.com/"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":943,"fieldName":"LOCATION_TYPE","customFieldvalue":"D"}],"serviceManager":""}]
database
$googleSpreadSheetUrl