resultat.sql

来自「用于GIS(全球地理系统)的分析和处理的代码。」· SQL 代码 · 共 42 行

--
-- This file is part of the GeOxygene project source files. 
-- 
-- GeOxygene aims at providing an open framework which implements OGC/ISO specifications for 
-- the development and deployment of geographic (GIS) applications. It is a open source 
-- contribution of the COGIT laboratory at the Institut G閛graphique National (the French 
-- National Mapping Agency).
-- 
-- See: http://oxygene-project.sourceforge.net 
--  
-- Copyright (C) 2005 Institut G閛graphique National
--
-- This library is free software; you can redistribute it and/or modify it under the terms
-- of the GNU Lesser General Public License as published by the Free Software Foundation; 
-- either version 2.1 of the License, or any later version.
--
-- This library is distributed in the hope that it will be useful, but WITHOUT ANY 
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A 
-- PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
--
-- You should have received a copy of the GNU Lesser General Public License along with 
-- this library (see file LICENSE if present); if not, write to the Free Software 
-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
--  
--

-- POUR POSTGIS
-- Exemple de creation de table "RESULTAT" 
-- utilisee pour stocker des resultats de traitements geographiques. 


SELECT DropGeometrycolumn ('','resultat','geom');
DROP TABLE RESULTAT ;
CREATE TABLE RESULTAT (
        COGITID    	    INTEGER  PRIMARY KEY,
        DOUBLE1     DOUBLE PRECISION,
        INT1        INTEGER,
        STRING1     VARCHAR(255),
		BOOLEAN1    BOOLEAN
        );
SELECT AddGeometrycolumn ('','resultat','geom','-1','GEOMETRY',3);