ztote
Mechanical
- Apr 5, 2014
- 5
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.
thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
lighting columns 1
- Thread starter ztote
- Start date
- Status
- Thread starter
- #3
MikeHalloran
Mechanical
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
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
- Thread starter
- #5
MikeHalloran
Mechanical
Okay, you've had two days.
How many poles did you inspect in that time?
Mike Halloran
Pembroke Pines, FL, USA
How many poles did you inspect in that time?
Mike Halloran
Pembroke Pines, FL, USA
- Thread starter
- #7
Skogsgurra
Electrical
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
- Thread starter
- #9
MikeHalloran
Mechanical
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
... 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
Skogsgurra
Electrical
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
-
1
- #13
MikeHalloran
Mechanical
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
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
Skogsgurra
Electrical
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
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
--------------------------------------
Half full - Half empty? I don't mind. It's what in it that counts.
- Status