Код: Выделить всё
SELECT st_snaptogrid(st_force_2d(the_geom), 0.009,0.005) AS snapped_geom,
count(the_geom) AS count
FROM metro
GROUP BY st_snaptogrid(st_force_2d(the_geom), 0.009,0.005)
ORDER BY count(the_geom) DESC
Код: Выделить всё
SELECT st_snaptogrid(st_force_2d(the_geom), 0.009,0.005) AS snapped_geom,
count(the_geom) AS count
FROM metro
GROUP BY st_snaptogrid(st_force_2d(the_geom), 0.009,0.005)
ORDER BY count(the_geom) DESC
Код: Выделить всё
var layer = new OpenLayers.Layer.WMS("x", "http://x/geoserver/gwc/service/wms", {
layers: "x",
format: 'image/png',
tiled: true,
sphericalMercator: true,
visibility: true,
}, {tileOrigin: new OpenLayers.LonLat(0, 0)},{
attribution: 'В©copy rights',
transitionEffect: 'resize',
}, {
isBaseLayer: true
});
Сейчас этот форум просматривают: нет зарегистрированных пользователей и 1 гость