Форумы GIS-Lab.info

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

-- Table: nodes

CREATE TABLE nodes
(
  id bigint NOT NULL,
  "version" integer NOT NULL,
  user_id integer NOT NULL,
  tstamp timestamp without time zone NOT NULL,
  changeset_id bigint NOT NULL,
  geom geometry,
  CONSTRAINT pk_nodes PRIMARY KEY (id),
  CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
  CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POINT'::text OR geom IS NULL),
  CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 4326)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE nodes OWNER TO osm;

-- Index: idx_nodes

CREATE INDEX idx_nodes
  ON nodes
  USING btree
  (id, user_id, tstamp, changeset_id);

-- Index: nodes_geom_idx
CREATE INDEX nodes_geom_idx
  ON nodes
  USING gist
  (geom);

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

select id, geom from nodes where ST_Within(nodes.geom, 'ЗДЕСЬ ГЕОМЕТРИЯ В WKB') = TRUE;

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

bitmap Heap Scan on nodes  (cost=8764395.63..18458106.78 rows=91293905 width=108)
    [QUERY PLAN] => Bitmap Heap Scan on nodes  (cost=8764395.63..18458106.78 rows=91293905 width=108)