search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

[Enhancement] Add "Switch IP" field to Camera Maintenance Priority List #8676

Open atdservicebot opened 2 years ago

atdservicebot commented 2 years ago

What application are you using?

Data Tracker

Describe the outcome you'd like to see when this feature is implemented.

Add "Switch IP" field to Camera Maintenance Priority List so we can easily verify comm while verifying camera operations. https://atd.knack.com/amd#cameras-maintenance/

Describe any workarounds you currently have in place or alternative solutions you've considered.

have to look at separate lists and it just takes longer

Requested By Lance B.

Request ID: DTS22-103600

amenity commented 2 years ago

This is complicated since there's not currently a relationship that supports this query.

However, it may make sense to rework the data structure so that cameras are associated to a cabinet in addition to a location.

amenity commented 2 years ago

AR - Not every camera associated with signal, e.g. the one on top of the Austonian.

BC - Have discussed with John and thinks we could come up with a logic that makes sense.

dianamartin commented 2 years ago

@amenity what should we do about this?

amenity commented 2 years ago

@dianamartin - what would you recommend?

dianamartin commented 2 years ago

@amenity I would say we should circle back with Lance to see if he's given this more thought about how the AMD assets should be related. We need to figure out if the "Switch IP" is captured anywhere else already and if we need to associate the cameras to another table to bring in that information.

amenity commented 2 years ago

@dianamartin - sounds good. Adding it to AMD stakeholder discussions

dianamartin commented 2 years ago

8/2

Switch IP (Cabinet) Cabinets are not always associated with Signals Cameras are associated to Locations (can be shared to a Signal)

Current Relationships Cabinets

Locations

Long Term: Locations: