# OR amenity IN ('graveyard')
# OR landuse IN ('cemetery')
# OR leisure IN ('sports_centre', 'golf_course', 'stadium',
# 'track', 'pitch')
# OR landuse IN ('recreation_ground')
# OR landuse IN ('forest', 'wood')
#
# ORDER BY ST_Area(way) DESC
green_areas = Polygons(name='green_areas',
fields=(('area', PseudoArea()), ),
mapping={
'leisure':
('park', 'water_park', 'marina', 'nature_reserve',
'playground', 'garden', 'common', 'sports_centre',
'golf_course', 'stadium', 'track', 'pitch'),
'landuse':
('cemetery', 'park', 'water_park', 'marina',
'nature_reserve', 'playground', 'garden', 'common',
'forest', 'wood'),
'amenity': ('graveyard')
})
green_areas_z13 = GeneralizedTable(
name='green_areas_z13',
tolerance=zoom_threshold(13),
origin=green_areas,
)
green_areas_z10 = GeneralizedTable(
name='green_areas_z10',
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),
origin=water_areas_z13,
)
'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'),
})
'city',
'town',
'village',
'hamlet',
'suburb',
'neighbourhood',
'locality',
])),
('population', Integer()),
),
)
admin = Polygons(
name='admin',
mapping={
'boundary': ('administrative', ),
},
fields=(('admin_level', OneOfInt('1 2 3 4 5 6'.split())), ),
)
motorways = Highway(name='motorways',
mapping={
'highway': (
'motorway',
'motorway_link',
'trunk',
'trunk_link',
),
})
mainroads = Highway(name='mainroads',
('barrier', String()),
('cycleway', String()),
('railway', String()),
('network', String())
),
)
amenitiesbuilding = Polygons(
name='amenitiesbuilding',
mapping = {
'amenity': (
"bicycle_parking",
"bicycle_rental",
),
'bicycle_parking': ( 'shed', 'building' ),
'railway': ('halt', 'station')
},
fields = (
('access', String()),
('bicycle_parking', String()),
('operator', String()),
('railway', String())
),
)
sensuniques = LineStrings(
name = 'sensuniques',
mapping = {
'oneway' : ('yes','1','-1'),
},
fields = (
landusages = Polygons(
name = 'landusages',
with_label_field = True,
fields = (
('name', Name()),
('name:en', Name()),
('name:de', Name()),
('name:ru', Name()),
('area', PseudoArea()),
('z_order', ZOrder([
'military',
'nature_reserve',
'protected_area',
'national_park',
])),
),
mapping = {
'landuse': (
'military',
),
'leisure': (
'nature_reserve',
'protected_area',
'national_park',
),
'boundary': (
'nature_reserve',
'protected_area',
'national_park',
),
})
landusages = Polygons(
name = 'landusages_march18',
fields = (
('area', PseudoArea()),
('leaf_type', String()),
('leaf_cycle', String()),
),
mapping = {
'waterway': ('riverbank',),
'landuse': (
'basin',
'reservoir'
'park',
'forest',
'residential',
'retail',
'commercial',
'industrial',
'railway',
'cemetery',
'grass',
'farmyard',
'farm',
'farmland',
'wood',
'meadow',
'village_green',
'recreation_ground',
'allotments',
'quarry',
'orchard',
'vineyard',
'greenhouse_horticulture',
),
'leisure': (
'park',
'garden',
'playground',
'golf_course',
'sports_centre',
'pitch',
'stadium',
'common',
'nature_reserve',
),
'natural': (
'wood',
'land',
'scrub',
'wetland',
'water',
'heath',
'grassland',
),
'highway': (
'pedestrian',
'footway',
),
'amenity': (
'university',
'school',
'college',
'library',
'fuel',
'parking',
'cinema',
'theatre',
'place_of_worship',
'hospital',
),
'place': (
'island',
),
'tourism': (
'zoo',
),
'aeroway': (
'aerodrome',
'helipad',
'apron',
),
})