Ask Your Mates Open Forum

Expand all | Collapse all

CCTV scheduling

  • 1.  CCTV scheduling

    Posted 11 June 2020 20:48
    Hi all,

    Interested in how other Councils store CCTV data and schedule CCTV programmes. We have access to Wincan and get results in the usual tabular and excel formats. Do you integrate this information with your asset management systems (structural/peak scores and codes), and if so, how? How is the CCTV schedule itself stored and updated... do you use the traditional excel or another method? We're finding that updating the CCTV schedule with new condition scores, and adjusting the programme frequency accordingly, is quite cumbersome... so we're looking at ways to improve in this area. Appreciate any thoughts.

    Cheers
    Sala
    Pro Cert 2


  • 2.  RE: CCTV scheduling

    Posted 14 June 2020 21:22
    Good morning Sala,

    There are a few points in this discussion, and we have a few different aspects so I'll start from the top.

    Do you integrate this information with your asset management systems (structural/peak scores and codes)?
    We have just started doing this.  To do individually is, as you've likely found, quite laborious.  Depending on the version of Wincan and level of licensing you have it can be easier.  For instance, the advanced version of Wincan VX is not particularly helpful for exporting this data , however the office or expert are.  For this aspect of it we are really only beginning, and have only done a couple of exports of data.  The idea is using the report generator function to export the structural condition as a spreadsheet that can then be uploaded to the asset management system.  I'm hoping that if Meta-Db can start to function properly, or if I can work out how to use it properly, it may make it easier to export larger amounts of data.

    How is the schedule stored and updated?
    I built a Gantt chart functionality in excel for storing the schedule and have this stored in the network as a shared document so that it is more accessible.  It has links to each of the completed tasks etc.  Unfortunately it has been much harder to get the foreman who oversees the work to update it when things are complete, but I'm hoping that over the next few months he will begin to use it a bit more (at the moment this is a reasonable hope).

    We're finding that updating the CCTV schedule with new condition scores, and adjusting the programme frequency accordingly, is quite cumbersome
    We don't typically store the condition scores in the schedule.  This would require that each line that is inspected has a line in the spreadsheet.  That gets very large very quickly.
    Before we acquired Wincan VX I had a spreadsheet for inspections.  It was laced with macros to handle a lot of the data and tabulate it.  It also did not handle the condition data, but I had started working on it.
    The format for data storage that I had created was simple.
    {Asset ID} {Number of inspections} {Date of most recent insp} {Storage location of most recent insp} {Date of second most recent insp} {Storage location of second most recent insp} etc etc.  I think I made provision for up to 20 inspections in this format.

    I had started working on adjusting the macros to pop struc and serv columns in to each inspection.  The data was going to come straight from the report generator of Wincan and combine with this.  However, as we have gone down the wincan vx and t1 asset management route, I chose not to continue.

    Have a great day
    Michael
    Pro Cert 2


  • 3.  RE: CCTV scheduling

    Posted 14 days ago
    We know that CCTV is a security camera. We can record audio and video data through that device. But Recently I format the system and wanted to cctv installation again in my system but could not be installed. I tried many possible processes but could not be solve the problem. If anyone has any information then suggest to me.

    ------------------------------
    Brad cit
    abc tech
    associate
    alaska
    United States
    ------------------------------

    Pro Cert 2