select measured_value,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

javax.swing.JFrame f = new javax.swing.JFrame();
geoJsonContent="{\n" +
	"  \"type\": \"FeatureCollection\",\n" +
	"  \"metadata\": {\n" +
	"    \"importantPropertyNames\": [\n" +
	"      \"name\",\n" +
	"    ],\n" +
	"    \"notSoImportantPropertyNames\": [\n" +
	"      \"measured_value\"\n" +
	"    ],\n" +
	"    \"showNamesOnSymbols\": \"True\",\n" +
	"    \"idPropertyName\": \"name\"\n" +
	"  },\n" +
	"  \"features\": [";
geoJsonColumn=1;
javax.swing.table.TableModel tm=sQLshellAPI.getCurrentlyVisibleShell().getVisibleView().getSortedAndFilteredData();
for(int i=0;i<tm.getRowCount();++i)
{
	if (i > 0)
		geoJsonContent += ",\n";
	geoJsonContent += tm.getValueAt(i, geoJsonColumn);
}

geoJsonContent+="]}";
java.net.URL stem=new java.net.URL("https://b.tile.opentopomap.org//$ZOOM$/$X$/$Y$.png");
int zoomOffset=0;
f.setContentPane(new de.elbosso.db.scratch.GeoPrototype(stem,zoomOffset,geoJsonContent));
f.pack();
f.setVisible(true);