lighting columns lighting columns ztote (Mechanical) (OP) 5 Apr 14 17:18 HI, i'm working on lighting columns i have to do a diagnostic of more than 100000 columns , i dont know how to do, if you can suggest any idea or method... i need your help. thank you. RE: lighting columns Tmoose (Mechanical) 6 Apr 14 09:32 like this ? http://www.srh.noaa.gov/images/bro/wxevents/2008/d... RE: lighting columns ztote (Mechanical) (OP) 6 Apr 14 17:39 yes, the light poles, i have to do an audit of all the 100000 poles ! the problem that i cant visit all these poles. RE: lighting columns MikeHalloran (Mechanical) 7 Apr 14 00:19 Find someone who does, or can, visit all the light poles, and get their help. Are you supposed to verify that the lamps work? ... that the wiring is correct? ... that the poles are still upright? ... that the poles were ever installed? ... that the poles were ever ordered? ... that the poles are of the correct material? ... etc. But first, explain how a light pole audit can possibly be a mechanical rotating bearing issue. Mike Halloran Pembroke Pines, FL, USA RE: lighting columns ztote (Mechanical) (OP) 7 Apr 14 09:54 i have to verifie the state of the poles, collect informations about mechanical characteristic and problems of different elements of the poles:sealing rod,screw, the sole...and these for all the 100000 poles! RE: lighting columns MikeHalloran (Mechanical) 7 Apr 14 12:09 Okay, you've had two days. How many poles did you inspect in that time? Mike Halloran Pembroke Pines, FL, USA RE: lighting columns ztote (Mechanical) (OP) 7 Apr 14 12:57 now, i think i will do a sample, i guess it's stupid to inspect all the poles. what do you think ? RE: lighting columns Skogsgurra (Electrical) 7 Apr 14 13:01 A very unexpected question in the Bearings forum. Indeed. One hundred thousand poles, you say? Thats a very long stretch of a road. With a typical spacing around 100 m, it will be the length of the Earth's quadrant - from pole to equator. Who gave you this assignment? Your boss? When? About a week ago? Is he known to pull legs? Gunnar Englund www.gke.org -------------------------------------- Half full - Half empty? I don't mind. It's what in it that counts. RE: lighting columns ztote (Mechanical) (OP) 9 Apr 14 18:08 it's a city !! the biggest city in morroco the real number is approximately 100000 poles. RE: lighting columns dvd (Mechanical) 10 Apr 14 19:53 ... the imaginary number is probably (100000+i) RE: lighting columns MikeHalloran (Mechanical) 10 Apr 14 21:48 Actually, it's not an unreasonable request, if, for example, you work for a utility and are expected to detect and document the power or cable thieves that are likely present in substantial number. ... or are expected to schedule maintenance for the poles that are not in good repair. ... or maybe for some other reason that I can't conjecture, because you haven't told us squat about how this came to be your problem. You need to get started. If you have a budget, you could delegate the work to others. If you don't have a budget, maybe you could glean the information you need from data stores that already exist, or induce collection of new data for you by people who will be in the vicinity of the poles for other reasons. IOW, it's a soluble problem, that will yield to any tactic except bitching about its apparent size. Mike Halloran Pembroke Pines, FL, USA RE: lighting columns Skogsgurra (Electrical) 11 Apr 14 00:19 Even if Morocco is a large city - do you really have so many lighting poles? I find that amazing. But, on the other hand, it isn't more than around 0.03 poles for each inhabitant. And that's a very reasonable number. Mike's suggestion is good. Make a realistic estimate that shows the amount of work that is involved. Tell your boss how many men, cars, set of tools and instruments you will need to carry the job out. Make him realize that this will cost - he may think that it could be done by one man in an afternoon, some bosses are like that. Make him understand the size of the undertaking. Gunnar Englund www.gke.org -------------------------------------- Half full - Half empty? I don't mind. It's what in it that counts. RE: lighting columns MikeHalloran (Mechanical) 11 Apr 14 00:53 Here's what I meant by 'external data stores': Here in the USA, a very small sample, comprising the few utility poles (power, communication, lighting, or combinations), comprising all the poles I have leaned against or otherwise observed over the course of a lifetime, suggests that every damn one of them had at least one, sometimes several, apparently unique identifying numbers or codes, burned in, stamped in, painted on, or nailed on. The essence of my assertion is that someone went to the trouble of applying some unique identifier to each pole. It follows that somewhere, for each similar set of poles, there exists a record, probably on paper, linking the unique identifiers to other attributes like street address, date of installation, date of last service, inventory of attached equipment, etc. If your lighting columns are of relatively recent manufacture, the information may be stored electronically, and linked to barcodes instead of physical tags and physical records, or it may be piles of paper records in file boxes in a dusty warehouse, but at least some of the information you seek exists. I suspect that, at the very least, you've got a list, somewhere, of all the poles to be audited. Getting a copy of that list in modifiable and extensible form would be a good start. That way you can keep track of which poles have been visited and which have not, in addition to keeping track of the audit results. This would probably be a good time to learn how to build, modify, extend, and maintain a database. Or hire someone to do it. OR, this is a long shot, but maybe you could crowdsource the work. I.e., you could ask the citizenry of the city, perhaps just for fun, perhaps for a chance in a drawing for some modest prize, to go out and take a few photos of each nearby lighting pole, one frame showing the serial number, one an overall shot, and one zoomed in to show the condition of the upper end, or whatever you'd like to see. You'd need to put up a website with a bunch of storage to collect the submissions, and some staff to dig through the haystack, extract the data you need, keep track of progress, issue updates to keep the crowd interested, and highlight the poles still in need of inspection by the crowd or a small followup crew. Mike Halloran Pembroke Pines, FL, USA RE: lighting columns Skogsgurra (Electrical) 11 Apr 14 07:41 I like that! That's a really creative approach. The prize could be substantial and the cost would still be extremely low in comparison to anything else. It gives a new and deeper meaning to "The Good Neighbour"! Gunnar Englund www.gke.org -------------------------------------- Half full - Half empty? I don't mind. It's what in it that counts.