Proposal to connect NHD waterways in Oklahoma with a mechanical edit, requesting feedback

stevea · 2024-02-08T02:53:17.413Z

Excellent. I’m doing a “handoff” here to @watmildon who is also watching closely and others here who are more quiet. Buff it to a polished shine, folks. Peace, out.

watmildon · 2024-02-08T04:17:01.327Z

waterwaymap only looks at things tagged as waterway= so all of the natural=water features are completely invisible to it. I’m sure there’s some extra preprocessing that could, for example, collapse all water= features to points so all of the in and outflows are “connected” but that requires features like w61823627 to get patched up as you suggest.

Setting aside that this area needs a redraw, I think it’s unusual to have waterways begin at the back of a water= feature. I wouldn’t say it is wrong just unusual for how folks map them. I don’t think connecting them up is wrong but it’s also not meaningfully more correct than leaving it disconnected. Honestly, I’d be tempted to delete those “originator” ways so the import seemed a bit more consistent with OSM “style”. But again, I don’t feel strongly about them.

Matt · 2024-02-09T03:18:30.129Z

Oh wow, I hadn’t looked at the satellite. I’ve fixed those manually now. I deleted the ArtificalPath too.

I had read the “lakes are basically water-roundabouts” idea before but I never though of collapsing them to one node, that’s really interesting.

Thank you for continuing to bear with me. I’ve been trying to compare OSM to the NHD to confirm these ways inside ponds are really the beginning of a stream, that there isn’t a segment missing in OSM, outside the pond and flowing into it that should be connected to the ArtificialPath. I did find and fix a few instances manually today, where a small connection between two ponds or under a roadway probably got deleted at some point.

But then I found way/139502473, it doesn’t currently connect to anything with its first node, but I see a way dated 2019 in the NHD that leads right up to it:

NHD query of the immediate area, layer 6 - flowlines
The waterway newer than when this was imported, its “fdate” is 2/20/2019:

 {
            "type": "Feature",
            "id": 8456072,
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        -99.6095370210525,
                        35.7899612207287,
                        0,
                        9.648375
                    ],
                    [
                        -99.6097273773557,
                        35.7902229606474,
                        0,
                        4.469875
                    ],
                    [
                        -99.6097743272835,
                        35.7904827525027,
                        0,
                        0
                    ]
                ]
            },
            "properties": {
                "OBJECTID": 8456072,
                "permanent_identifier": "{46333995-D382-42E4-8188-7BA840803DAE}",
                "fdate": 1550620800000,
                "resolution": 2,
                "gnis_id": null,
                "gnis_name": null,
                "lengthkm": 0.06329655,
                "reachcode": "11090201009372",
                "flowdir": 1,
                "wbarea_permanent_identifier": null,
                "ftype": 460,
                "fcode": 46007,
                "innetwork": 1,
                "mainpath": 0,
                "visibilityfilter": 24000,
                "Shape_Length": 77.7378083086172,
                "globalid": "{F4B011AB-2297-4D56-871E-9A4C4E3E7FF8}"
            }
        },

I understand getting rid of useless ArtificialPaths, but I kinda want to leave 'em for now… or at least I don’t know that I want to be responsible for deleting them, there’s about 4000 of these cases. Another thing I came across, is if I were to delete them, and their last node connects to a waterway heading out of the lake, that waterway could be left connected to nothing, since many of the imported waterways had already been connected without including the edge of the surrounding water.

So in short, I tried to make it easier for me to make a decision, and ended up just making it harder.

I can work on figuring out how to delete these ArtificialPaths inside ponds and making sure anything connected to their last node gets connected back to the water’s edge. And if anybody does an import of newer waterways in the future, they already have to worry about connecting things and can figure it out then.

Or, I can still leave them and just connect everything else outside of the ponds as planned. I am definitely going to sleep on it.

Thank you!

watmildon · 2024-02-09T03:43:27.234Z

One thing that is useful to think about it how easy would it be to “undo” this if we discovered 6 months from now we have decide we want to backtrack. Given that this is all sourced from NHD, it’s pretty hard to do enough damage that a dedicated person couldn’t (through reverts or redo of import) patch things to how they were. It’s even easier to backtrack for solely tagging changes.

In contrast, updating all the geometry for a ton of varying and connected feature types over many weeks that would need to be hand entered? Much more to worry about.

They’ve been there a while, having them in for a while longer doesn’t hurt anything. As you’ve noted, there are some that may be useful to keep around for if the import is redo/extended etc. I’m glad you’re thinking about what happens for the next folks to come along. I don’t think the map is damaged hugely either way.

SomeoneElse · 2024-02-09T10:34:37.059Z

Matt:

there are waterways throughout Oklahoma where the ways don’t actually connect and just end in nodes at the same coordinates

(just to comment on the original question)

To be honest, that looks like a bug in the initial import? Now that you’ve fixed it, this stream and this lake look OK to me.

watmildon · 2024-02-09T18:48:48.669Z

Yeah, this is a super common issue with older NHD imports.

Matt · 2024-02-10T02:13:52.176Z

Ok, I think I’ve figured out what I’d like to do. Here are before and after zipped *.osm files, none of these changes have been uploaded. The files contain the objects to be modified and everything sharing nodes with them.

Edit: I made a mistake before, there are a lot of connections to be made where the nodes are exactly 7.2cm apart for some darn reason. The below is updated to reflect upping the range limit from 5cm to 8cm.

ok_before.zip - 18.3MB compressed, unzips to a 124MB osm file
ok_after.zip - 19.1MB compressed, unzips to a 141.0MB osm file

5,226 ways to delete (all ArtificialPaths inside of bodies of water, with nothing flowing into the body of water to connect to it, and nothing in the NHD to connect to it either.)

About 60% of them, the last node in the way is connected to the beginning of another waterway that would be left dangling, so that node is then merged with one belonging to the body of water (the nearest node within 8 cm).

Then the other 40%, the waterway flowing out of the body of water that our deleted ArtificalPath connects to is already connected to the lake edge, OR there’s just nothing the deleted way was connected to. So simply deleting the way is enough.

There are about 150 ArtificalPaths (already tagged as waterway=stream) inside of lakes I want to leave alone because of one of these cases:

The NHD shows something that could connect to it that doesn’t exist in OSM
The way inside the waterbody has a name tag
There’s a way outside the body of water flowing away from it that would be left connected to nothing because there isn’t a node belonging to the instance of natural=water within about 8cm to merge with
There are multiple ArtificialPaths connected to each other inside the same large lake
Any of the nodes in the way besides the very last one also belong to another way

20,159 node merges, all but 10 of which involve only two nodes, connecting the end of a waterway to the edge of a body of water where that end had connected to nothing previously. Then 10 instances of 3 nodes being merged because I found some canals I didn’t pick up before whose ends are touching.

And then there are JOSM validator warnings I’ll work through manually before committing changes to an area. I didn’t address them all yet in the files linked above.

I’m really grateful for all of this feedback, and for the ability to pursue this. It’s really satisfying doing this work.

Is it okay for me to create a wiki page, and begin making these changes, do you think? Or should I slow down, or work more on part of it?

Thank you thank you thank you.

watmildon · 2024-02-10T04:58:15.143Z

This looks sensible to me. I would love to know what the other 200 are and if we can work through them manually. I haven’t had a ton of time the last couple weeks but may be able to work through some (and the dams! so many dams!) in coming weeks.

Matt · 2024-02-10T14:04:07.687Z

Thank you! I updated my previous post, there were a large number of instances of nodes being exactly 7.2 centimeters apart. By looking within 5cm, and then only if nothing is found upping it to 8cm there are a few thousand more connections to make.

I will put that list together of about 150 lone ways being left behind and post it here, later today probably.

Thank you for all of your time, I love the workflow of using MapRoulette for the dams. Any you’ve done or you do in the future (with or without MR, all is good) is wonderful, thank you. But don’t feel pressure! I’ll do them all eventually if nothing else. Your guidance has given me the freedom to work through them in a way that’s comfortable and efficient for me. So I appreciate it!

Matt · 2024-02-10T15:10:17.061Z

[ok_ways_left · GitHub]

Here are the 147 ways in Oklahoma with NHD tags, inside of bodies of water, that don’t have anything connecting to their first node, that I didn’t want to delete automatically. Most of them, they have names and that’s why I left them. The rest should all be: the last node of the way was more than 8cm from the nearest node belonging to the body of water. I think. I haven’t looked at them all.

The columns mentioning old and new: old is “ways and relations the last node of the way is already connected to” and new is “ways and relations this way would become connected to if all nodes within 8cm of its last node were merged.”

Edit: Here’s a bonus, the 18 ways where the NHD has another way that doesn’t exist in OSM that might connect to it. Their ends are all about 1 meter apart though. And in one case I think the way in the NHD is the same way in OSM but its ids are different. I haven’t looked at all of these.

[ok_ways_left_nhd_conn · GitHub]

Query to view a way by object id for convenience (?) - https://hydro.nationalmap.gov/arcgis/rest/services/nhd/MapServer/6/query?where=OBJECTID%3D10292735&outFields=*&returnGeometry=true&geometryPrecision=&outSR=4326&f=geojson

Matt · 2024-02-12T04:58:43.728Z

All done

[Mechanical Edits/AutoMatt/Connecting NHD Waterways in Oklahoma 2 - OpenStreetMap Wiki]

[Changesets by AutoMatt_ | OpenStreetMap]

watmildon · 2024-02-12T22:23:51.218Z

This is a huge amount of cleanup and greatly appreciated!

Matt · 2024-02-19T15:19:31.356Z

Thank you for letting me! I want to provide an update, and ask about one last mass mechanical change please (setting intermittent=yes on streams, more info at the end). First, I’ve been manually connecting things, there’s less confetti in the north now.

image1920×898 428 KB

It’s not perfect but it’s a lot better. What I found was, there were many streams with big chunks missing. Here’s an example from Overpass. In green are the segments that I created manually.

image1537×763 157 KB

Here’s another example. Green were missing, now created by hand.

image1080×867 81.2 KB

Lastly, here are the waterway relations in Oklahoma, with thew new ones I created in green. After verifying a named waterway end to end, it made sense to me to throw a relation on it. I didn’t do it for all of them, I did about 30, each long enough to have 20+ segments.

image1055×652 105 KB

Question about a mass edit please:
There are 59,443 waterways in Oklahoma with NHD:FCode=46003 that don’t have an intermittent tag. Can, or should, I set intermittent=yes on them?

Thank you for your time!

watmildon · 2024-02-19T19:52:34.703Z

Really curious how there’s that many sections missing. Probably lost to time why…

I think adding relations for longer waterways is totally fine. It’s very common and makes a nice single place to grab the whole thing.

Features with that FCode should be marked as intermittent and, given the grography of OK, I’m not surprised at the large number of ways. In case you haven’t seen this, the wiki has a page talking generally about NHD imports that mentions this. There may be other FCodes that could use some scrutiny while you’re there.

Matt · 2024-02-20T01:50:38.670Z

For some of the missing waterways I created manually, it looked like the NHD had the stretch as a polygon that either didn’t get imported, or did but was tagged as some kind of river bank and got deleted after the fact. And the ArtificialPath down the middle never existed. But then, yeah, a lot of the missing segments, there’s nothing in the way…

Looking at lakes and streams in Oklahoma, there are:

NHD:FCode	Count	Count currently having intermittent	Wiki
46003	60,224	885	STREAM/RIVER waterway=stream intermittent=yes Hydrographic Category intermittent
46006	26,457	335	STREAM/RIVER waterway=stream Hydrographic Category perennial
39004	109,721	29	LAKE/POND natural=water Hydrographic Category perennial
55800	16,814	13	ARTIFICIAL PATH
39001	6,756	15	LAKE/POND natural=water intermittent=yes Hydrographic Category intermittent
39009	530	2	LAKE/POND natural=water Hydrographic Category perennial; stage average water elevation
33400	250	1	CONNECTOR

So, I think that would be (?)

59,399 waterways with NHD:FCode=46003 that need intermittent=yes
6,741 water bodies with NHD:FCode=39001that need intermittent=yes

What do you think?

watmildon · 2024-02-20T02:07:09.224Z

That seems sensible to me.

Matt · 2024-02-20T22:09:03.972Z

Thank you! Done!

https://wiki.openstreetmap.org/wiki/Mechanical_Edits/AutoMatt/Setting_Intermittent_on_NHD_Waterways_and_Lakes_in_Oklahoma

image1046×795 103 KB

Baloo_Uriza · 2024-03-01T16:01:00.312Z

Matt:

There are 59,443 waterways in Oklahoma with NHD:FCode=46003 that don’t have an intermittent tag. Can, or should, I set intermittent=yes on them?

I’m personally fine with this and believe it would be greatly useful. I’m on the assumption that the NHD code you mentioned is equivalent or near enough to it to be reasonably synonymous.

Baloo_Uriza · 2024-03-01T16:02:20.980Z

watmildon:

Really curious how there’s that many sections missing.

From experience? A lot of the hydrology at the headwaters here is alluvial, intermittent or otherwise completely I obvious when not currently innundated.

watmildon · 2024-03-01T17:59:58.404Z

Generally nhd will have those segments though so it’s a bit odd they are left out no?