def get_query(layer, z, x, y, ext):
layer = env.layers[layer]
coord = Coordinate(y, x, z)
bounds = u.bounds(layer.projection, coord)
mimetype, format = u.get_type_by_ext(ext)
return env.provider.get_query(layer, coord, bounds, format)
def explain_analyze_query(self, query, z, x, y, srid=3857):
query = build_bbox_query(query, u.bounds(z, x, y, srid),
'q.__geometry__', srid)
query = 'EXPLAIN ANALYZE ' + query
self.db.execute(query)
return self.db.fetchall()
def pr_query(self, query, z, x, y, srid=3857):
print(
build_bbox_query(query, u.bounds(z, x, y, srid), 'q.__geometry__',
srid))
def query_zxy(self, query, z, x, y, srid=3857):
return self.query_bounds(query, u.bounds(z, x, y, srid), srid)
def explain_analyze_query(self, query, z, x, y, srid=3857):
query = build_bbox_query(query, u.bounds(z, x, y, srid), 'q.__geometry__', srid)
query = 'EXPLAIN ANALYZE ' + query
self.db.execute(query)
return self.db.fetchall()
def pr_query(self, query, z, x, y, srid=3857):
print(build_bbox_query(query, u.bounds(z, x, y, srid), 'q.__geometry__', srid))
def query_zxy(self, query, z, x, y, srid=3857):
return self.query_bounds(query, u.bounds(z, x, y, srid), srid)
