Mercurial > gemma

comparison pkg/imports/bn.go @ 1631:6ee06eb37fa9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use new function to calculate bn area.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 19 Dec 2018 18:37:40 +0100
parents 1835d1c9eb9b
children a0982c38eac0
comparison
equal deleted inserted replaced
1630:f6218f11062a 1631:6ee06eb37fa9
55 $1, 55 $1,
56 isrs_fromText($2), 56 isrs_fromText($2),
57 $3, 57 $3,
58 $4, 58 $4,
59 isrsrange(isrs_fromText($5), isrs_fromText($6)), 59 isrsrange(isrs_fromText($5), isrs_fromText($6)),
60 ST_MakePolygon(ST_ExteriorRing(ST_Buffer(ST_SetSRID(ST_Makepoint(13.05501, 47.80949), 4326), 0.01)))::Geography, 60 ISRSrange_area(
61 isrsrange(isrs_fromText($5), isrs_fromText($6)),
62 (SELECT ST_Union(CAST(area AS geometry))
63 FROM waterway.fairway_dimensions
64 WHERE level_of_service = 3)),
61 $7, 65 $7,
62 $8, 66 $8,
63 $9, 67 $9,
64 $10, 68 $10,
65 $11, 69 $11,