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, )
mapping={ 'amenity': ( 'university', 'school', 'library', 'fuel', 'hospital', 'fire_station', 'police', 'townhall', ), }) motorways_gen1 = GeneralizedTable( name='motorways_gen1', tolerance=meter_to_mapunit(50.0), origin=motorways, ) mainroads_gen1 = GeneralizedTable( name='mainroads_gen1', tolerance=meter_to_mapunit(50.0), origin=mainroads, ) railways_gen1 = GeneralizedTable( name='railways_gen1', tolerance=meter_to_mapunit(50.0), origin=railways, )
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', tolerance=zoom_threshold(10), origin=green_areas_z13, ) # WHERE amenity IN ('school', 'college', 'university', 'bus_station', # 'ferry_terminal', 'hospital', 'kindergarten', # 'place_of_worship', 'public_building', 'townhall') # OR landuse IN ('industrial', 'commercial') grey_areas = Polygons(name='grey_areas',
mapping={ 'amenity': ( 'university', 'school', 'library', 'fuel', 'hospital', 'fire_station', 'police', 'townhall', ), }) roads_gen1 = GeneralizedTable( name='roads_gen1', tolerance=meter_to_mapunit(50.0), origin=roads, where="type in ('motorway','trunk','primary','secondary','tertiary')", ) roads_gen0 = GeneralizedTable( name='roads_gen0', tolerance=meter_to_mapunit(200.0), origin=roads_gen1, where="type in ('motorway','trunk','primary')", ) railways_gen1 = GeneralizedTable( name='railways_gen1', tolerance=meter_to_mapunit(50.0), origin=railways, ) railways_gen0 = GeneralizedTable(