select measured_value,st_y(the_geom)as latitude,st_x(the_geom)as longitude,json_object('fill',case
			 when measured_value >10
             then 'red'
             when measured_value >2
             then 'yellow'
             when measured_value is not NULL
             then 'green'
        end) as style,name,json_object(
			'type',	'Feature',
			'id', id,
			'geometry',json(asgeojson(the_geom)),
'style',json_object('fill',case
			 when measured_value >10
             then 'red'
             when measured_value >2
             then 'yellow'
             when measured_value is not NULL
             then 'green'
        end),
'properties',json_object('name',name,'measured_value',measured_value))
AS JSON from test_geom WHERE the_geom is not null
AND
MBRContains(ST_GeomFromText('POLYGON((-1 -1,5 -1, 5 5 , -1 5, -1 -1))'), the_geom);

select measured_value,st_y(the_geom)as latitude,st_x(the_geom)as longitude,json_object('fill',case
			 when measured_value >10
             then 'red'
             when measured_value >2
             then 'yellow'
             when measured_value is not NULL
             then 'green'
        end) as style,name,json_object(
			'type',	'Feature',
			'id', id,
			'geometry',json(asgeojson(the_geom)),
'style',json_object('fill',case
			 when measured_value >10
             then 'red'
             when measured_value >2
             then 'yellow'
             when measured_value is not NULL
             then 'green'
        end),
'properties',json_object('name',name,'measured_value',measured_value))
AS JSON from test_geom WHERE the_geom is not null
AND
MBRContains(ST_GeomFromText('POLYGON((${/tmp/te.bsh$}))'), the_geom);

java.net.URL stem=new java.net.URL("https://services.arcgisonline.com/arcgis/rest/services/World_Imagery/MapServer/tile/$ZOOM$/$Y$/$X$");
int zoomOffset=0;
de.elbosso.db.scratch.GeoInterface geoInterface=new de.elbosso.db.scratch.GeoInterface(stem,zoomOffset);
de.netsysit.ui.dialog.GeneralPurposeInfoDialog.showComponentInDialog(geoInterface);
ul=geoInterface.getUpperLeft();
ur=geoInterface.getUpperRight();
ll=geoInterface.getLowerLeft();
lr=geoInterface.getLowerRight();
s=""+ul.getLatitude().getAsOneNumber()+" "+ul.getLongitude().getAsOneNumber()+
","+ur.getLatitude().getAsOneNumber()+" "+ur.getLongitude().getAsOneNumber()+
","+lr.getLatitude().getAsOneNumber()+" "+lr.getLongitude().getAsOneNumber()+
","+ll.getLatitude().getAsOneNumber()+" "+ll.getLongitude().getAsOneNumber()+
","+ul.getLatitude().getAsOneNumber()+" "+ul.getLongitude().getAsOneNumber();
return s;