gis table create

-- Table: sample_gis

-- DROP TABLE sample_gis;

CREATE TABLE sample_gis
(
  id serial NOT NULL,
  "time" timestamp with time zone,
  variable character varying(64) NOT NULL,
  value double precision NOT NULL,
  geom geometry(Geometry,4326) NOT NULL,
  CONSTRAINT sample_gis_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE sample_gis
  OWNER TO vizmill;

-- Index: sample_gis_geom_id

-- DROP INDEX sample_gis_geom_id;

CREATE INDEX sample_gis_geom_id
  ON sample_gis
  USING gist
  (geom);