L
man_made=water_well
drinking_water=yes
description=текст описания
Size: a a a
L
M
L
DP
01:12:57 [gis] > select osm_user, count(*) from osm where ST_DWithin(geog,(select geog from osm where tags@>'{"name":"Минск"}' and osm_type='relation'), 0) and ts > (now()-interval '6 month') and tags?'power' and (tags->>'power' in ('line', 'substation')) group by 1 order by 2 desc;
┌──────────────┬───────┐
│ osm_user │ count │
├──────────────┼───────┤
│ Prusaker │ 124 │
│ olehz │ 42 │
│ semigradsky │ 18 │
│ Latentor │ 4 │
│ Objektive │ 4 │
│ bad_mapper │ 3 │
│ danvyr │ 2 │
│ Reinkarnator │ 2 │
│ bes_internal │ 2 │
│ budgawl │ 2 │
│ Refl_ex │ 1 │
│ Guylamar2006 │ 1 │
│ Расслабон │ 1 │
│ matsumi │ 1 │
│ Falkongorki │ 1 │
│ paleshukgeo │ 1 │
└──────────────┴───────┘
(16 rows)
Time: 10141,448 ms (00:10,141)
i
i
YK
01:12:57 [gis] > select osm_user, count(*) from osm where ST_DWithin(geog,(select geog from osm where tags@>'{"name":"Минск"}' and osm_type='relation'), 0) and ts > (now()-interval '6 month') and tags?'power' and (tags->>'power' in ('line', 'substation')) group by 1 order by 2 desc;
┌──────────────┬───────┐
│ osm_user │ count │
├──────────────┼───────┤
│ Prusaker │ 124 │
│ olehz │ 42 │
│ semigradsky │ 18 │
│ Latentor │ 4 │
│ Objektive │ 4 │
│ bad_mapper │ 3 │
│ danvyr │ 2 │
│ Reinkarnator │ 2 │
│ bes_internal │ 2 │
│ budgawl │ 2 │
│ Refl_ex │ 1 │
│ Guylamar2006 │ 1 │
│ Расслабон │ 1 │
│ matsumi │ 1 │
│ Falkongorki │ 1 │
│ paleshukgeo │ 1 │
└──────────────┴───────┘
(16 rows)
Time: 10141,448 ms (00:10,141)
DR
i
DP
DS
DP
VD
PR
DP
YY
i
i
YY
VD