This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#super-simple bounding box match | |
bbox\=([\+\-]?[0-9]+\.[0-9]+),([\+\-]?[0-9]+\.[0-9]+),([\+\-]?[0-9]+\.[0-9]+),([\+\-]?[0-9]+\.[0-9]+) | |
#bounding box, strictly matches long,lat,long,lat by limiting to +/-90 and +/-180 | |
bbox\=([\+\-]?([0-9]|[0-8][0-9]|90)\.[0-9]+),([\+\-]?([0-9]|[0-9][0-9]|1[0-7][0-9]|180)\.[0-9]+),([\+\-]?([0-9]|[0-8][0-9]|90)\.[0-9]+),([\+\-]?([0-9]|[0-9][0-9]|1[0-7][0-9]|180)\.[0-9]+) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Landuse and major roads | |
# Useful filter when mapping landuse=residential areas, only want to attach them to major features. | |
# The first bit is for ways you're creating, so you can add landuse tags | |
(type:way AND -tags:0) AND (type:way AND (-waterway=riverbank AND -landuse=* AND -leisure=* AND -natural=* AND -amenity=* -highway=trunk AND -highway=primary AND -highway=secondary)) | |
# Other useful filters?... |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# When lat/lon are the wrong way round in a table called "location". Where clause works for UK, adjust for elsewhere. | |
# UPDATE location SET lat=(@temp:=lat), lat = lon, lon = @temp WHERE lat < 45; |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.