def index(): return render_template( 'index.html', region_groups=RegionGroup.query(), version=DumpVersion.query().one(), export_url=app.env.config['web'].get('export_url', None) )
def region(code): region = Region.filter_by(code=code).one() qgeom = DBSession.execute( """SELECT ST_AsGeoJSON(ST_Difference(geom_out, geom_in )) AS ring, ST_AsGeoJSON(geom) AS geom, ST_AsGeoJSON(eval(expression)) AS current, ST_XMin(geom_out) AS min_x, ST_XMax(geom_out) AS max_x, ST_YMin(geom_out) AS min_y, ST_YMax(geom_out) AS max_y FROM region WHERE id = :id""", dict(id=region.id) ).fetchone() return render_template( 'region.html', region=region, qgeom=qgeom, version=DumpVersion.query().one(), export_url=app.env.config['web'].get('export_url', None), )