Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Looking for a way to automatically assign an 8-character Sink ID to every upstream feature in a geometric network. There are over 500 sinks and about 5000 points and lines upstream from those sinks. Would be great to click on any point or line and see what the Sink ID is, or quickly select records based on which sink they are upstream from. A similar question is here: How do I assign attributes from hydrologic sinks to upstream features?

share|improve this question
Do you have any polygon/polyline data related to your Sink/Facility ID? (E.g., watershed polygons that include the sink and upstream locations, or polyline streams that go through both sinks and junctions). Are your sinks and junctions point data or some other format? – Baltok Oct 25 '12 at 19:26
They're part of a combined sanitary/stormwater network. Not really working with watersheds or catchments in this case. The sinks are actually the lowest point at which stormwater features enter a combined system. The combined system itself has been removed temporarily so that it's a little easier to work with. – Rayner Oct 25 '12 at 19:35
That's okay, the concept is still the same. For example, do you have pipeline/canal polyline data that goes through both sinks and junctions? What I'm getting at is the eventual ability to link sinks to junctions spatially through another layer, or some common attribute. – Baltok Oct 25 '12 at 19:43
No polygons. As far as polyline data, I only have what I've described. Just the stormwater pipes and stormwater structures. There is one pipe segment between structures, so I don't have a long polyline that 'goes through' all the junctions upstream from a sink. I suppose I could merge each group of pipes upstream from each sink and then do a spatial join. Unfortunately, that would involve manually selecting and merging 500 groups of lines. – Rayner Oct 25 '12 at 20:00
And I'm assuming your pipeline data doesn't have any attributing related to the Sink ID? If your Sink ID is only found with the sinks data, and you have no other unique ID to connect with the junctions, and no spatial connection with the sinks and junctions, I think you may be stuck with a manual method. Maybe somebody else has a clever workaround. Sorry. – Baltok Oct 25 '12 at 20:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.