Форумы GIS-Lab.info

Код: Выделить всё

SELECT 
         p.osm_id     as osm_id
        , p."NAME"     as name
        , p."MAN_MADE" as man_made
         , p."LEISURE"  as leisure 
         , p."AMENITY"  as amenity
         , p."OFFICE"   as office
         , p."SHOP"     as shop
         , p."TOURISM"  as tourism
         , p."SPORT"    as sport
         , ST_AsText(p.geom) as geom
         , ST_AsText(ST_Centroid(p.geom)) as centroid
FROM 
           layer."RU poi-point" as p    LEFT JOIN layer."RU settlement-polygon" as city ON (ST_Contains(city.geom, p.geom)) 
WHERE   
          city.osm_id IN (38198306)  AND (  p."AMENITY" IN ('school')  )

Код: Выделить всё

 SELECT ST_Contains(city.geom, p.geom)
  FROM
               layer."RU poi-point" as p    LEFT JOIN layer."RU settlement-polygon" as city ON (ST_Contains(city.geom, p.geom))
    WHERE   
              city.osm_id IN (38198306)  AND (  p."AMENITY" IN ('school')  )