Mercurial > gemma

comparison pkg/imports/bn.go @ 2752:018f979f9e23

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Bottlenecks import allow ISRS_from > ISRS_to. The order constraint on isrsranges are arbitrary and should be satisfied by the WAMOS back end not by the user data.
author Sascha Wilde <wilde@intevation.de>
date Thu, 21 Mar 2019 12:53:39 +0100
parents 02d012272dd4
children 41f5ac76d642
comparison
equal deleted inserted replaced
2751:5da81634bdc4 2752:018f979f9e23
62 ) VALUES( 62 ) VALUES(
63 $1, 63 $1,
64 isrs_fromText($2), 64 isrs_fromText($2),
65 $3, 65 $3,
66 $4, 66 $4,
67 isrsrange(isrs_fromText($5), isrs_fromText($6)), 67 isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
68 greatest(isrs_fromText($5), isrs_fromText($6))),
68 ISRSrange_area( 69 ISRSrange_area(
69 ISRSrange_axis(isrsrange(isrs_fromText($5), isrs_fromText($6)), $14), 70 ISRSrange_axis(isrsrange(least(isrs_fromText($5), isrs_fromText($6)),
71 greatest(isrs_fromText($5), isrs_fromText($6))),
72 $14),
70 (SELECT ST_Collect(CAST(area AS geometry)) 73 (SELECT ST_Collect(CAST(area AS geometry))
71 FROM waterway.waterway_area)), 74 FROM waterway.waterway_area)),
72 $7, 75 $7,
73 $8, 76 $8,
74 $9, 77 $9,