Communications - Availability of TOPAZ Network

The TOPAZ Regional Wireless Cooperative (TRWC) is a multi-jurisdictional radio network whose members are the City of Apache Junction, the Fort McDowell Yavapai Nation, the Town of Gilbert, the City of Mesa, the Town of Queen Creek, the Rio Verde and the Superstition Fire & Medical districts. The TOPAZ voice radio network has a standalone system that monitors the radio system and records events that occur with the network. These events include the interruptions or failures that are counted for purposes of availability of the TOPAZ voice radio network. These event records include the time the interruption or failure began, the time the interruption or failure ended, and the time service returned to normal. This provides the duration of the event and is thus recorded in a log for inclusion in reports and metrics. Impairment means available, but not full capacity. In the TOPAZ network, impairments are usually not visible due to overlap in the radio site coverage or redundancy.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/communications-availability-of-topaz-network-iitq-ftrq\".\"communications_availability_of_topaz_network\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.