comparison pkg/imports/bn.go @ 3703:b07511ff859e

Don't include calculated area in unchanged bottleneck detection. This makes BN imports considerably faster. The only downside is, that when die waterway area changes there is no easy way to recalculate the areas of existing BN. But the semantics in that case are somewhat hard anyway (think of historization for the old area) so this should be ok.
author Sascha Wilde <wilde@intevation.de>
date Wed, 19 Jun 2019 12:34:48 +0200
parents 063a1883b5cb
children 7006b92c0334
comparison
equal deleted inserted replaced
3702:ee7dc0bea083 3703:b07511ff859e
117 gauge_location, 117 gauge_location,
118 gauge_validity, 118 gauge_validity,
119 objnam, 119 objnam,
120 nobjnm, 120 nobjnm,
121 stretch, 121 stretch,
122 area,
123 rb, 122 rb,
124 lb, 123 lb,
125 responsible_country, 124 responsible_country,
126 revisiting_time, 125 revisiting_time,
127 limiting, 126 limiting,
134 location, 133 location,
135 validity, 134 validity,
136 $4, 135 $4,
137 $5, 136 $5,
138 (SELECT r FROM r), 137 (SELECT r FROM r),
139 ISRSrange_area(
140 ISRSrange_axis((SELECT r FROM r),
141 $15),
142 (SELECT ST_Collect(CAST(area AS geometry))
143 FROM waterway.waterway_area)),
144 $8, 138 $8,
145 $9, 139 $9,
146 $10, 140 $10,
147 $11::smallint, 141 $11::smallint,
148 $12, 142 $12,
457 country, 451 country,
458 revisitingTime, 452 revisitingTime,
459 limiting, 453 limiting,
460 bn.Date_Info, 454 bn.Date_Info,
461 bn.Source, 455 bn.Source,
462 tolerance,
463 ) 456 )
464 457
465 if err != nil { 458 if err != nil {
466 return err 459 return err
467 } 460 }