Hi All, I am with Jason on this one. Making a unique ID that includes some location description just adds another element to manage in your database one feature at a time. I think it is useful to have another field with something like the basin ID, but I wouldn't rely on it as part of the unique ID. That way you can just apply the basin ID to all the points within that basin all at once. If you have to change it on individual features it just gets messy when you have to edit a catchment boundary or something. If you have 1000 DMHs and CBs spread across 10 basins, I would recommend numbering them 1-1000, and keeping the basin ID separate. Then you can still quickly query basins by the other field (or symbolize), but your labels are shorter because you don't need to have the prefix representing the basin. And if you DO want to label with the basin, your labeling expression can be: [basin]&"_"&[ID] I also stay away from the prefixes CB, DMH, SMH for the same reason: you can symbolize your maps to indicate whether something is a manhole or a catch basin, so adding the prefix "SMH_" or "CB_" before every number doesn't really help, it just makes your labels longer. Jeff On Wed, Aug 3, 2016 at 4:03 PM, Brett R. Horr <[log in to unmask]> wrote: > > +2. > > We use a meaningful hydro feature name that is adjacent to or a part of > the system like Long Beach (LB) or Bridges Swamp (BS) as the prefix and > then start increasing the numbers as one moves away from the outfall. > > Brett Horr, GISP > Director of GIS and Technology > Town of York > 186 York Street > York, Maine 03909-1314 > (207) 363-1007x243 > http://www.yorkmaine.org/ > > From: Northeast Arc Users Group [mailto:[log in to unmask]] On > Behalf Of Lynne Fielding > Sent: Wednesday, August 03, 2016 3:57 PM > To: [log in to unmask]<mailto:[log in to unmask]> > Subject: Re: Stormwater Feature Numbering > > Hi All > > For what it’s worth I advocate for a numbering schema that means something > (ie DCB_xxx, SMH_xxx) and here in Westwood the numbering itself relates to > the location in town they are…..sewer mini-systems or catchments, which > really helps when you’re trying to find it/them. I’ve worked with the other > way and those numbers are illogical and get really big and then just try to > label your map! Having a layer that shows where the ‘catchments’ are helps > too. > > My two cents before I retire ☺…………………… > > Lynne W Fielding GISP > GIS Specialist > IT Dept > Town of Westwood > 781-320-1082 > > From: Northeast Arc Users Group [mailto:[log in to unmask]] On > Behalf Of Jason Wise > Sent: Wednesday, August 03, 2016 3:48 PM > To: [log in to unmask]<mailto:[log in to unmask]> > Subject: Re: Stormwater Feature Numbering > > I'm a big fan of unique IDs that don't mean anything. If you have 1,000 > catchbasins, call the next one 1001, regardless of where it is. If it's in > a GIS, the number doesn't need to tell you where it is. > > Your boss will hate this idea, so of course you'll have to come up with > some kind of watershed-based system. > ________________________________ > From: Gambrel, Sean<mailto:[log in to unmask]> > Sent: 8/3/2016 11:36 AM > To: [log in to unmask]<mailto:[log in to unmask]> > Subject: Stormwater Feature Numbering > Hello all, > > Here in Bangor we’ve had our stormwater infrastructure in GIS for some > time, but currently use a grid-based numbering system which is not > particularly useful for anyone. We’re considering a switch, as we have not > done a significant amount of asset management on stormwater yet and the > current system is quite confusing for our field crews. Looking ahead, > toward more asset management work, we’d like to have a better system in > place. > > Our sanitary sewer system is numbered like a branching tree, with a two > letter prefix denoting subsection and a three number pipe id number, which > are divided into branches by 100s / 10s as necessary. So for instance > AB123. This system works well for us, but unfortunately can’t easily be > replicated for our stormwater system because it is discontiguous in nature. > > Our current grid-based system is more-or-less arbitrary, but includes the > complication of using a grid which is otherwise unreferenced elsewhere in > the city. This is creating many headaches and conflicts among staff. > > Would you be willing to share what your community is using for stormwater > numbering and what the pros and cons have been in using this numbering > system? > > Thank you very much, > Sean > > > Sean Gambrel, GISP > GIS Administrator > Addressing Officer > > City of Bangor, Maine > 207-992-4245 > [log in to unmask]<mailto:[log in to unmask]> > > ------------------------------------------------------------------------- > This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. > > If you no longer wish to receive e-mail from this list, you can remove > yourself by going to http://s.uconn.edu/nearcsubscribe. > ------------------------------------------------------------------------- > This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. > > If you no longer wish to receive e-mail from this list, you can remove > yourself by going to http://s.uconn.edu/nearcsubscribe. > ------------------------------------------------------------------------- > This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. > > If you no longer wish to receive e-mail from this list, you can remove > yourself by going to http://s.uconn.edu/nearcsubscribe. > > CONFIDENTIALITY: The information contained in this electronic mail message > and any electronic files attached to it may be confidential information, > and may also be the subject of legal professional privilege and/or public > interest immunity. If you are not the intended recipient you are required > to delete it. Any use, disclosure or copying of this message and any > attachments is unauthorized. If you have received this electronic message > in error, please inform the sender or contact [log in to unmask] This > footnote also confirms that this email message has been checked for the > presence of computer viruses. > > ------------------------------------------------------------------------- > This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. > > If you no longer wish to receive e-mail from this list, you can remove > yourself by going to http://s.uconn.edu/nearcsubscribe. > ------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://s.uconn.edu/nearcsubscribe.