db='terrain',
host='localhost',
port=5432,
user='******',
password='',
sslmode='allow',
prefix='osm_new_',
proj='epsg:900913',
)
# WHERE "natural" IN ('water', 'bay')
# OR waterway = 'riverbank'
# OR landuse = 'reservoir'
water_areas = Polygons(name='water_areas',
fields=(('area', PseudoArea()), ),
mapping={
'natural': ('water', 'bay'),
'waterway': ('riverbank', ),
'landuse': ('reservoir', )
})
water_areas_z13 = GeneralizedTable(
name='water_areas_z13',
tolerance=zoom_threshold(13),
origin=water_areas,
)
water_areas_z10 = GeneralizedTable(
name='water_areas_z10',
tolerance=zoom_threshold(10),
'primary_link',
'secondary',
'secondary_link',
'tertiary',
'road',
'path',
'track',
'service',
'footway',
'bridleway',
'cycleway',
'steps',
'pedestrian',
'living_street',
'unclassified',
'residential',
)
})
landusages = Polygons(name='landusages',
fields=(
('area', PseudoArea()),
('z_order', ZOrder(['bar', 'cafe'])),
),
mapping={
'amenity': ('bar', 'cafe'),
})
amenities = Points(name='amenities', mapping={
'amenity': ('bar', 'cafe'),
})