Need some major help in refining our current system.
The Current Set Up: Currently, our county is divided into 40 or so zones (polygons). Each zone has response types defined in the attribute table such as, Residential 1st Alarm, Residential 2nd Alarm, etc. Fire trucks are manually assigned to these response types. This integrates with our county dispatch center's CAD system and displays for them which truck numbers to dispatch for which zones where the emergency call is located.
Desired system:
• Trucks are assigned to points (stations).
• The system automatically pulls the closest appropriate trucks (by response type) based on the address point and proximity to fire stations.
• The system cannot use the same truck if it's already been called out.
• Trucks that are out of service must be easily editable and info. must integrate with CAD immediately.
I have investigated this at the ArcGIS custom level....the cost is around $10k for the program, not to mention integration fees for the CAD system. On top of that, ArcGIS won't guarantee their program will work! So, looking for other ways of accomplishing this task within reason. Any help is appreciated.