Describes in detail the available settings and controls for a feature in the product.
The "near" and "farther than" keywords provide proximity searches. If your table contains Latitude and Longitude data, you can use these to do searches that find entities related to each other by location.
Columns that can be designated as "Geo" columns need to contain text (VARCHAR) data unless they contain latitude/longitude data. Latitude and longitude columns can contain numeric data (DOUBLE) or text.
- Set Column Type to ATTRIBUTE.
- Set Additive to NO.
- Set Aggregation Type to NONE.
- near…within n miles|km|meters
- farther than n miles|km|meters from
the data source (worksheet or one of the tables) must contain a column of type longitude and a column of type latitude, and these must be set using the appropriate GeoType, as shown in this procedure. These keywords allow you to search with spatial filters on data contained in a table or worksheet which contains geo type columns with latitude/longitude data. This lets you search based on spherical distance. The distance is calculated as a straight-line distance (not road distance) radius using miles, kilometers, or meters from the central point. If not specified, the default is 10 km.
- Find the GeoType for the column that contains the geographical data.
- Change the value to the appropriate GeoType, depending on the kind of data the column contains.
- If your data includes latitude and/or longitude columns that are stored as a numeric data type (DOUBLE), make these changes for those columns:
- Change the Type or ColumnType to ATTRIBUTE.
- Change Additive to NO/FALSE.
- Save your changes.