Icon for Socrata external plugin
Open repository in Console
Updated 20 days ago
Indexed 1 hour ago

Wifi Activity - City Owned Access Points

Wifi Activity as connected to city-owned access points. Note: only devices that connected to an SSID is listed. Note that SSID @mesa generally reflects WiFi sessions by members of the public (non city employees or city devices). Other devices that may have been in the area but did not connect are not included. Sensitive fields such as device MAC address have been scrambled and are not actual addresses. However, although these have been changed, the uniqueness and mobility of the device has been maintained for listed sessions.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/wifi-activity-city-owned-access-points-2vtm-mpvz\".\"wifi_activity_city_owned_access_points\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • wifi_activity_city_owned_access_points
Upstream Metadata