GIS Developer

PostgreSQL에서 geometry 타입을 갖는 Table을 생성하고자 할때, 사용한 SQL 문에 대해 정리해 봅니다. 아래와 같은 형태의 테이블 2개에 대한 생성인데요.

위 형태의 테이블 2개에 대한 CREATE 문은 아래와 같습니다. 실제 용도는 네트워크 DB에 대한 Node, Link 관련 데이터를 저장하는 Table 생성에 대한 SQL입니다.

CREATE TABLE public.ecl_network_link

(

networkid uuid PRIMARY KEY,

facility_layer character varying(30),

snode_id uuid,

snode_layer character varying(30),

enode_id uuid,

enode_layer character varying(30),

the_geom geometry(MultiLineString)

);

ALTER TABLE public.ecl_network_link

OWNER TO postgres;

CREATE INDEX ecl_network_link_geom_idx

ON public.ecl_network_link

USING gist

(the_geom);

CREATE TABLE public.ecl_network_link ( networkid uuid PRIMARY KEY, facility_layer character varying(30), snode_id uuid, snode_layer character varying(30), enode_id uuid, enode_layer character varying(30), the_geom geometry(MultiLineString) ); ALTER TABLE public.ecl_network_link OWNER TO postgres; CREATE INDEX ecl_network_link_geom_idx ON public.ecl_network_link USING gist (the_geom);

CREATE TABLE public.ecl_network_link
(
  networkid uuid PRIMARY KEY,  
  facility_layer character varying(30),
  snode_id uuid,
  snode_layer character varying(30),
  enode_id uuid,
  enode_layer character varying(30),
  the_geom geometry(MultiLineString)
);

ALTER TABLE public.ecl_network_link
  OWNER TO postgres;

CREATE INDEX ecl_network_link_geom_idx
  ON public.ecl_network_link
  USING gist
  (the_geom);

CREATE TABLE public.ecl_network_node

(

networkid uuid PRIMARY KEY,

facility_layer character varying(30),

the_geom geometry(Point)

);

ALTER TABLE public.ecl_network_node

OWNER TO postgres;

CREATE INDEX ecl_network_node_geom_idx

ON public.ecl_network_node

USING gist

(the_geom);

CREATE TABLE public.ecl_network_node ( networkid uuid PRIMARY KEY, facility_layer character varying(30), the_geom geometry(Point) ); ALTER TABLE public.ecl_network_node OWNER TO postgres; CREATE INDEX ecl_network_node_geom_idx ON public.ecl_network_node USING gist (the_geom);

CREATE TABLE public.ecl_network_node
(
  networkid uuid PRIMARY KEY,  
  facility_layer character varying(30),
  the_geom geometry(Point)
);

ALTER TABLE public.ecl_network_node
  OWNER TO postgres;

CREATE INDEX ecl_network_node_geom_idx
  ON public.ecl_network_node
  USING gist
  (the_geom);

글

[PostgreSQL] CREATE TABLE 예제

Javascript로 URL의 QueryString을 파싱하고 값 얻기