# HG changeset patch # User Sascha L. Teichmann # Date 1571644232 -7200 # Node ID ea570f43d7a9fcb6a2f838a436f2a53e5ba678d4 # Parent a2f16bbcc8465b016fc5bec7da443f707f35a236 Loading of concrete clipping polygon is not needed any more. diff -r a2f16bbcc846 -r ea570f43d7a9 pkg/octree/polygon.go --- a/pkg/octree/polygon.go Mon Oct 21 02:01:56 2019 +0200 +++ b/pkg/octree/polygon.go Mon Oct 21 09:50:32 2019 +0200 @@ -15,13 +15,10 @@ import ( "bytes" - "context" - "database/sql" "encoding/binary" "fmt" "log" "math" - "time" "github.com/tidwall/rtree" @@ -42,56 +39,11 @@ ) const ( - clippingPolygonSQL = ` -WITH joined AS ( - SELECT - sr.area AS area, - sr.date_info AS date_info - FROM waterway.sounding_results sr - WHERE sr.bottleneck_id = $1 -) -SELECT ST_AsBinary( - ST_Buffer(ST_intersection( - (SELECT ST_Transform(area::geometry, $2::int) FROM joined WHERE date_info = $3::date), - (SELECT ST_Transform(area::geometry, $2::int) FROM joined WHERE date_info = $4::date) - ), 0.1) - ) AS area -` -) - -const ( IntersectionInside IntersectionType = iota IntersectionOutSide IntersectionOverlaps ) -func LoadClippingPolygon( - ctx context.Context, - conn *sql.Conn, - epsg uint32, - bottleneck string, - first, second time.Time, -) (*Polygon, error) { - - var clip []byte - - if err := conn.QueryRowContext( - ctx, clippingPolygonSQL, - bottleneck, - epsg, - first, second, - ).Scan(&clip); err != nil { - return nil, err - } - - var polygon Polygon - if err := polygon.FromWKB(clip); err != nil { - return nil, err - } - polygon.Indexify() - return &polygon, nil -} - func (ls lineSegment) Rect(interface{}) ([]float64, []float64) { var min, max [2]float64