Dry weather flow map geometry is reversed

[leendertvanwolfswinkel]

The dry weather flow map is a line from the connection_node.geom to the dry_weather_flow.geom, but is should be the other way around.

[margrietpalm]

@leendertvanwolfswinkel Should this only be swapped for the dry weather flow map or also for the surface map?

Yes, also for surface_map

[margrietpalm]

@leendertvanwolfswinkel can you double check this? Because I run the following command to make these lines:

    query = f"""
        UPDATE {basename}_map AS map
        SET geom = (
            SELECT MakeLine(PointOnSurface(obj.geom), vcn.the_geom)
            FROM {basename} obj
            JOIN v2_connection_nodes vcn ON map.connection_node_id = vcn.id
            WHERE obj.id = map.{basename}_id
        );        
    """

Which I'd assume makes a line from the PointOnSurface to the connection node

[leendertvanwolfswinkel]

LGTM

[margrietpalm]

@leendertvanwolfswinkel does the sqlite look good or the result? Because this sqlite is already in the currently released schema.

[leendertvanwolfswinkel]

@margrietpalm I migrated a spatialite with threedi-schema 0.228.2, but unfortunately the geometry is still wrong. It is a line from the connection node to the dry_weather_flow polygon. It should be the other way around. This is odd, because the SQL statement you shared in the comment above should in my view result in a correct geometry.