az09

az09

az09

az09

ГИС и картография

группы

• https://t.me/gislab
• https://t.me/QGIS_mutual_aid
• https://t.me/nextgis_chat
• https://t.me/spbgeotex
• https://t.me/postgis
• https://t.me/geoserver_ru
• https://t.me/UAVPro
• https://t.me/bygis

az09

az09

explain(analyze,buffers,verbose)
SELECT ST_AsBinary("way") AS geom,"area","name","type"
FROM (
 SELECT COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS "type", name, way_area AS area, ST_PointOnSurface(way) AS way
 FROM planet_osm_polygon
 WHERE name IS NOT NULL
   AND way && ST_SetSRID('BOX3D(15573585.89094331 4224215.931154246,15617613.61923559 4268243.659446535)'::box3d, 3857)
   AND ST_IsValid(way)
 UNION ALL
 SELECT 'building' AS "type", name, way_area AS area, ST_PointOnSurface(way) AS way

az09

  SELECT way, COALESCE(p_o_l.highway, p_o_l.railway) AS "type", 1 AS bridge, access, render.render, layer, 0 as tunnel,
  COALESCE(hw.stylegroup, constr.stylegroup, rw.stylegroup, 'other') AS stylegroup
  FROM planet_osm_line as p_o_l
  INNER JOIN (values
        ('1_outline')
  ,     ('2_line')
  ,     ('3_inline')
  ) AS render (render) ON 1=1
  LEFT JOIN (values
        ('motorway', 'motorway')

az09

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
# "#" anywhere on a line.  The complete list of parameter names and allowed

az09

az09