source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/database/spatial_data_MEDIN.sql @ 7185

/* 
 * Table storing spatial information
 * 
 * C Byrom Apr 08
 * 
 */
DROP TABLE spatial_data CASCADE;
CREATE TABLE spatial_data
(
        spatial_data_id SERIAL primary key,
        original_document_id int references original_document(original_document_id),
        description character varying (255),
        create_date     timestamp
);
--ALTER TABLE spatial_data OWNER TO postgres;

-- add 2D geometry column, 'geometry', to table - with SRS val of 4326
select addgeometrycolumn('spatial_data','geometry',4326,'GEOMETRY',2);

-- Create index on searchable column to speed up searches
CREATE INDEX spatialsearch_idx ON spatial_data USING GIST(geometry);