Location is a type that contains latitude, longitude and address. Location is accessed as an array with 3 elements in it. These elements are:
address– The street address of the location.
city– The city this address is in
state– The state this address is in
zip– The zip code for this address
The following table describes the functions that can be used with locations.
||Returns different values based on the evaluation of boolean comparisons||2.1|
||Returns a count of a given set of records||2.0 and 2.1|
||Returns the rows that have geodata within the specified box, defined by latitude, longitude corners||2.0 and 2.1|
||Returns the rows that have locations within a specified circle, measured in meters||2.0 and 2.1|
For example, to query for all of the Seattle Fire 911 Calls calls within 500 meters of the Socrata offices in Seattle: