Exemple #1
0
def newRegion():
    """
    Creates new region with given code and geometry in region table 
    """
    
    code = request.args.get('code')
    
    if Region.filter_by(code = code).count() > 0:
        return flask.jsonify({
            'result': 'failed',
            'error': 'already_exists',
            'errorMsg': 'Region with same code already exists' }), 500
    
    wkt  = request.args.get('wkt')
    gjson  = request.args.get('geo_json')
    
    if wkt is None and gjson is not None:
        conn = DBSession.connection()
        result = conn.execute("SELECT ST_AsText(ST_Multi(ST_GeomFromGeoJSON('%s'))) as g" % gjson)
        for row in result:
            wkt = row['g']
    
    name  = request.args.get('name')
    if name is None:
        name = code
        
    simpl_buf = request.args.get('simpl_buf')
    simpl_dp  = request.args.get('simpl_dp')    
    
    if code != None and wkt != None :
        expression = "ST_SetSRID(ST_Multi(ST_GeomFromText('%s')), 4326)" % wkt 
        
        Region(name = name, code = code, 
               expression = expression, 
               simpl_buf = simpl_buf,
               simpl_dp = simpl_dp).add()
        DBSession.commit()
        
        region = Region.filter_by(code=code).one()
        
        return flask.jsonify({
            'id': region.id, 
            'result': 'created' })
    
    else:    
        return flask.jsonify({
            'result': 'failed',
            'error': 'not_enough_arguments',
            'errorMsg': 'You need to specify code and wkt or geo_json at least' }), 500    
Exemple #2
0
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),
    )