SELECT places.*, '15108' AS see_zip_code, (3958.8 * 2 * ASIN(SQRT( POWER(SIN(RADIANS(40.51 - latitude) / 2), 2) + COS(RADIANS(40.51)) * COS(RADIANS(latitude)) * POWER(SIN(RADIANS(-80.16 - longitude) / 2), 2) ))) AS distance, (DEGREES(ATAN2( SIN(RADIANS(longitude - -80.16)) * COS(RADIANS(latitude)), COS(RADIANS(40.51)) * SIN(RADIANS(latitude)) - SIN(RADIANS(40.51)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude - -80.16)) )) + 360) % 360 AS place_bearing FROM places WHERE (latitude BETWEEN 39.51 AND 41.51) AND (longitude BETWEEN -81.16 AND -79.16) AND ((3958.8 * 2 * ASIN(SQRT( POWER(SIN(RADIANS(40.51 - latitude) / 2), 2) + COS(RADIANS(40.51)) * COS(RADIANS(latitude)) * POWER(SIN(RADIANS(-80.16 - longitude) / 2), 2) ))) < 25.01) ORDER BY distance ASC

Physician Profile

Andrea Gallant. Her primary practice is as a Speech-Language Pathologist.

MS CCC-SLP: Master of Science, Certificate of Clinical Competence in Speech-Language Pathology


Specialties include: