title: SQL: How to check if an area is within a latitude / longitude position?
body: <p>Basically I want to check and update a new column (<strong>in_downtown</strong>) in above table by using a <strong>function</strong> if the above data lies in following location of Downtown Seattle with these coordinates: 
  Point A: ‐122.341518 47.578047 (longitude latitude)
  Point B: ‐122.284355 47.578047 (longitude latitude)
  Point C: ‐122.278004 47.630362 (longitude latitude)
  PointD: ‐122.371559 47.630362 (longitude latitude)</p>
  
  <p>If one household (hhid) is found in downtown, set the value of the new column "<strong>in_downtown</strong>” to be 1; otherwise, leave it as null.</p>