View and Set Postal Address Filter

Because there may be more address points in an area than are practically useful, you can reduce the number of plotted address points by specifying an SQL WHERE clause to limit the points displayed. The database columns available are:

SQL column namecontents of columnOSM tags
isway1 for OSM Way, 0 for OSM Node-
idID number of Way or Node
a negative ID indicates a Relation converted into a Way, or an extremely tiny Way converted into a Node
id attribute of Node, Way, or Relation
latitudemillionths of degrees North latitudelatitude attribute of Node, centroid latitude of Way
longitudemillionths of degrees East longitudelongitude attribute of Node, centroid longitude of Way
housenumberpostal building number or building name for countries that use that, e.g. "Government House"addr:housenumber
addr:housename
streetlocalized name of the street the address is located onaddr:street
addr:place
citylocalized name of the city, town, or village the address is located inaddr:city
addr:town
addr:village
statelocalized name of the state or province of the countryaddr:state
addr:province
ISO3166-2
postcodecountry-specific postal service routing codeaddr:postcode
countryISO-3166 2-character country codeaddr:country
ISO3166-2

For example, if you were on a non-straight-line part of the border between the United States and Canada, you could specify the clause
COUNTRY = 'US'
to only get address points on the US side of the border (of course, this is applicable for any country-to-country border).

If the SQL WHERE clause syntax you provide is invalid, you will not see any address points, as the search will fail with the syntax error before any records are looked up. Errors will be logged in the YAAC.out log file, which can be seen on the "Error Log" tab of the Help->About dialog, or accessed directly in your configured log file directory.