Last active
February 1, 2018 09:57
-
-
Save ponceta/24794bd03c7dc4cba9505b8fd4da6783 to your computer and use it in GitHub Desktop.
Create_QGEP_Drawing_Scheme
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE SCHEMA qgep_dr | |
AUTHORIZATION qgep; | |
COMMENT ON SCHEMA qgep_dr | |
IS 'QGEP drawing tools'; | |
/* CREATE TABLE */ | |
CREATE TABLE qgep_dr.constructionpoint (id serial PRIMARY KEY); | |
COMMENT ON TABLE qgep_dr.constructionpoint IS 'construction points are artificials points to build objects.'; | |
/* columns */ | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN altitude decimal(10,3) ; | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN fk_object_reference integer ; | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN code varchar(15) ; | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN measurement_campaign varchar(200) ; | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN remark text ; | |
/* geometry */ | |
ALTER TABLE qgep_dr.constructionpoint ADD COLUMN geometry geometry('POINTZ',:SRID); | |
CREATE INDEX constructionpoint_geoidx ON qgep_dr.constructionpoint USING GIST ( geometry ); | |
/* CREATE TABLE */ | |
CREATE TABLE qgep_dr.constructionline (id serial PRIMARY KEY); | |
COMMENT ON TABLE qgep_dr.constructionline IS 'construction lines are artificials polylines to build objects.'; | |
/* columns */ | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN altitude decimal(10,3) ; | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN fk_object_reference integer ; | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN code varchar(15) ; | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN measurement_campaign varchar(200) ; | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN remark text ; | |
/* geometry */ | |
ALTER TABLE qgep_dr.constructionline ADD COLUMN geometry geometry('LINESTRINGZ',:SRID); | |
CREATE INDEX constructionline_geoidx ON qgep_dr.constructionline USING GIST ( geometry ); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment