spotdatamodel

-- Table: vizdata_spotbasemodel

-- DROP TABLE vizdata_spotbasemodel;

CREATE TABLE vizdata_spotbasemodel
(
  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 vizdata_spotbasemodel_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE vizdata_spotbasemodel
  OWNER TO vizmill;

-- Index: vizdata_spotbasemodel_geom_id

-- DROP INDEX vizdata_spotbasemodel_geom_id;

CREATE INDEX vizdata_spotbasemodel_geom_id
  ON vizdata_spotbasemodel
  USING gist
  (geom);