Mercurial > gemma

comparison schema/gemma.sql @ 2529:45d51a49f191

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SR import: Use own triangulation and clipping when importing sounding results.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 06 Mar 2019 17:51:58 +0100
parents 960550ccca55
children fc7d828695c9
comparison
equal deleted inserted replaced
2528:113912129481 2529:45d51a49f191
503 area geography(POLYGON, 4326) NOT NULL 503 area geography(POLYGON, 4326) NOT NULL
504 CHECK(ST_IsValid(CAST(area AS geometry))), 504 CHECK(ST_IsValid(CAST(area AS geometry))),
505 surtyp varchar REFERENCES survey_types, 505 surtyp varchar REFERENCES survey_types,
506 coverage varchar REFERENCES coverage_types, 506 coverage varchar REFERENCES coverage_types,
507 depth_reference varchar(4) NOT NULL, -- REFERENCES depth_references, 507 depth_reference varchar(4) NOT NULL, -- REFERENCES depth_references,
508 point_cloud geography(MULTIPOINTZ, 4326) NOT NULL
509 CHECK(ST_IsSimple(CAST(point_cloud AS geometry))),
510 octree_checksum varchar, 508 octree_checksum varchar,
511 octree_index bytea, 509 octree_index bytea,
512 staging_done boolean NOT NULL DEFAULT false 510 staging_done boolean NOT NULL DEFAULT false
513 ) 511 )
514 512