Hello, thank you for your list of questions. I will answer them as best as I can. I will state that I am fairly new to this position as well as this Stormwater GIS analyst position is new. So I am dealing with a database that may or may not have been maintained well. I have a lot of data cleanup in my near future 😊
1) The screen shots of the application.
- We do have arrows that are used to visually identify water flow of the pips.
- The manholes, inlets, outfalls, etc. are all given a separate FeatureID separate from the ObjectID.
- Visually speaking we can tell the direction of water flow, however we need the upstream and downstream fields filled in with infrastructure to which the pipes are flowing from and to.
- EX.
- We need to populate the two fields to fill in the data relating to either a manhole to manhole or manhole to inlet or inlet to outfall etc. Note: I manually added the data here to show what I am trying to do.
- The reason we need this data is for one of our camera truck vendors need these fields filled in for their work flow to begin.
2) Attribute table.
3) Spatial Join, I am unsure if that will be useful but I can look into it.
4) I would like to batch-populate all current fields and then manually update as we move forward and add new infrastructure. Although that might be nice to find a way to automatically populate the fields every time a feature is created or modified, using an attribute rule, but to start I just need to populate the fields so that our vendors can start work.
5) ArcGIS Pro 3.2.0
6) I am pretty sure it is just a file geodatabase.
7) Yes the pipe features are created to indicate the flow of water.
😎 Inlet and manhole invert elevations--- not really. That data is unfortunately not the best maintained. The feature layers for inlets and manholes do have some invert elevation data but I would not rely on it. The pipe feature layer does have the invert elevation data.
- Inlet feature layer attribute table
- Pipe feature layer attribute table
9) I believe so that the up_stream is always going to be either a manhole or an inlet.
10) Yes, once again I believe so. Some downstream may empty via a outfall or a ditch.
11) I hear ya, this is one of the biggest issues I am dealing with.
- Your screen shot is what I need to accomplish and the only way I know which manhole or inlet is up or down stream is by visually looking at the map with the labels turned on and filling in the fields manually
12) I was unaware with the state of the data that I am working with, so even if I can figure out a way to populate the two new field with as much data as I can and then I can manually add the rest. There are over 900,000 pipe segments in this database and our elevation data is not the best kept. So even if I can get a portion of that filled in that would be great. I have a lot of work to do cleaning up years’ worth of data.
Thank you.