2.7 miles
SAN DIEGO COUNTY ROP
6401 LINDA VISTA ROAD, ROOM 40
SAN DIEGO, CA 92111
USA
2.7 miles
SAN DIEGO CO. OFFICE OF EDUCATION
6401 LINDA VISTA ROAD
SAN DIEGO, CA 92111
USA
3.8 miles
SAN DIEGO UNIFIED
4100 NORMAL ST.
SAN DIEGO, CA 92103
USA
8 miles
CORONADO UNIFIED
555 D AVE.
CORONADO, CA 92118
USA
8.7 miles
GROSSMONT UNION HIGH
P.O. BOX 1043
LA MESA, CA 91944
USA
8.8 miles
LA MESA-SPRING VALLEY
4750 DATE AVE.
LA MESA, CA 91941
USA
9.4 miles
LEMON GROVE ELEMENTARY
8025 LINCOLN ST.
LEMON GROVE, CA 91945
USA
10.2 miles
NATIONAL ELEMENTARY
1500 N AVE.
NATIONAL CITY, CA 91950
USA
11 miles
SANTEE ELEMENTARY
9625 CUYAMACA ST.
SANTEE, CA 92071
USA
11.6 miles
DEL MAR UNION ELEMENTARY
225 NINTH ST.
DEL MAR, CA 92014
USA
DEBUGING
Address: San Diego 92111
Full Address:
Username: NexusRex
Lat: 32.8072
Lon: -117.1649
Geo Source:
Query: SELECT DISTINCT locations.id, locations.location_number, locations.name, locations.street_address, locations.street_address_line2, locations.street_address_line3, locations.city, locations.state_province, locations.zip_postal_code, locations.country, locations.phone, locations.toll_free, locations.fax, locations.email, locations.website_url, locations.contact_name, locations.contact_title, locations.additional_info, locations.custom1, locations.custom2, locations.custom3, locations.custom4, locations.custom5, locations.custom6, locations.image, locations.marker_url, locations.featured, locations.rank, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((32.8072 - locations.lat) * pi()/180 / 2), 2) + COS(32.8072 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.1649 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (`locations`)
LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id`
WHERE `accounts`.`username` = 'NexusRex'
AND `locations`.`lat` <> ""
ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc
LIMIT 10
Total Rows: 10
Rows: Array
(
[0] => stdClass Object
(
[id] => 1762
[location_number] => 0600138
[name] => SAN DIEGO COUNTY ROP
[street_address] => 6401 LINDA VISTA ROAD, ROOM 40
[street_address_line2] =>
[street_address_line3] =>
[city] => SAN DIEGO
[state_province] => CA
[zip_postal_code] => 92111
[country] => USA
[phone] => M
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.769764
[lon] => -117.179596
[distance] => 2.7218993192082745
)
[1] => stdClass Object
(
[id] => 2730
[location_number] => 0691030
[name] => SAN DIEGO CO. OFFICE OF EDUCATION
[street_address] => 6401 LINDA VISTA ROAD
[street_address_line2] =>
[street_address_line3] =>
[city] => SAN DIEGO
[state_province] => CA
[zip_postal_code] => 92111
[country] => USA
[phone] => 8582923500
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.769764
[lon] => -117.179596
[distance] => 2.7218993192082745
)
[2] => stdClass Object
(
[id] => 2494
[location_number] => 0634320
[name] => SAN DIEGO UNIFIED
[street_address] => 4100 NORMAL ST.
[street_address_line2] =>
[street_address_line3] =>
[city] => SAN DIEGO
[state_province] => CA
[zip_postal_code] => 92103
[country] => USA
[phone] => 6197258000
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.753403
[lon] => -117.148056
[distance] => 3.840987623172121
)
[3] => stdClass Object
(
[id] => 1960
[location_number] => 0609870
[name] => CORONADO UNIFIED
[street_address] => 555 D AVE.
[street_address_line2] =>
[street_address_line3] =>
[city] => CORONADO
[state_province] => CA
[zip_postal_code] => 92118
[country] => USA
[phone] => 6195228900
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.692493
[lon] => -117.177452
[distance] => 7.9534109977576675
)
[4] => stdClass Object
(
[id] => 2092
[location_number] => 0616230
[name] => GROSSMONT UNION HIGH
[street_address] => P.O. BOX 1043
[street_address_line2] =>
[street_address_line3] =>
[city] => LA MESA
[state_province] => CA
[zip_postal_code] => 91944
[country] => USA
[phone] => 6196448000
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.767899
[lon] => -117.022400
[distance] => 8.70519382500623
)
[5] => stdClass Object
(
[id] => 2179
[location_number] => 0620250
[name] => LA MESA-SPRING VALLEY
[street_address] => 4750 DATE AVE.
[street_address_line2] =>
[street_address_line3] =>
[city] => LA MESA
[state_province] => CA
[zip_postal_code] => 91941
[country] => USA
[phone] => 6196685700
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.765034
[lon] => -117.022034
[distance] => 8.789047150631937
)
[6] => stdClass Object
(
[id] => 2205
[location_number] => 0621330
[name] => LEMON GROVE ELEMENTARY
[street_address] => 8025 LINCOLN ST.
[street_address_line2] =>
[street_address_line3] =>
[city] => LEMON GROVE
[state_province] => CA
[zip_postal_code] => 91945
[country] => USA
[phone] => 6198255600
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.738274
[lon] => -117.025986
[distance] => 9.364137382018548
)
[7] => stdClass Object
(
[id] => 2326
[location_number] => 0626670
[name] => NATIONAL ELEMENTARY
[street_address] => 1500 N AVE.
[street_address_line2] =>
[street_address_line3] =>
[city] => NATIONAL CITY
[state_province] => CA
[zip_postal_code] => 91950
[country] => USA
[phone] => 6193367500
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.673786
[lon] => -117.090263
[distance] => 10.180472710403286
)
[8] => stdClass Object
(
[id] => 2533
[location_number] => 0635880
[name] => SANTEE ELEMENTARY
[street_address] => 9625 CUYAMACA ST.
[street_address_line2] =>
[street_address_line3] =>
[city] => SANTEE
[state_province] => CA
[zip_postal_code] => 92071
[country] => USA
[phone] => 6192582300
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] => Product 1
)
[lat] => 32.852886
[lon] => -116.983292
[distance] => 10.998514481010288
)
[9] => stdClass Object
(
[id] => 1975
[location_number] => 0610740
[name] => DEL MAR UNION ELEMENTARY
[street_address] => 225 NINTH ST.
[street_address_line2] =>
[street_address_line3] =>
[city] => DEL MAR
[state_province] => CA
[zip_postal_code] => 92014
[country] => USA
[phone] => 8587559301
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 32.953110
[lon] => -117.263680
[distance] => 11.588765543758345
)
)