Partners & Integrations for Smart City IoT Aggregation

Time-Series Integration Example

The following example demonstrates a typical query integration that translates between our platform's query language and a specific time-series database:

// Time-Series Query Translation Example

// Original Platform Query
const platformQuery = {
  metric: "temperature",
  tags: { location: "district-5", sensor_type: "outdoor" },
  aggregation: "avg",
  interval: "1h",
  timeRange: {
    start: "2025-01-01T00:00:00Z",
    end: "2025-01-07T23:59:59Z"
  }
};

// Translated to InfluxDB Query
const influxQuery = `
SELECT mean("value") AS "avg_temperature"
FROM "sensors"."temperature"
WHERE "location" = 'district-5' AND "sensor_type" = 'outdoor'
  AND time >= '2025-01-01T00:00:00Z' AND time <= '2025-01-07T23:59:59Z'
GROUP BY time(1h)
`;

// Translated to TimescaleDB (PostgreSQL) Query
const timescaleQuery = `
SELECT 
  time_bucket('1 hour', time) AS bucket,
  AVG(value) AS avg_temperature
FROM temperature_readings
WHERE location = 'district-5' AND sensor_type = 'outdoor'
  AND time >= '2025-01-01T00:00:00Z' AND time <= '2025-01-07T23:59:59Z'
GROUP BY bucket
ORDER BY bucket
`;

Edge Deployment Example

The following configuration demonstrates a typical edge node deployment in a smart city environment:

// Edge Node Configuration Example

{
  "node_id": "edge-district5-node12",
  "location": {
    "lat": 54.6872,
    "lng": 25.2797,
    "zone": "district-5",
    "description": "Intersection of Main St and Oak Ave"
  },
  "hardware": {
    "model": "NeuraEdge-3000",
    "cpu": "4 cores @ 1.5GHz",
    "ram": "4GB",
    "storage": "128GB SSD",
    "power": "PoE+ / Solar backup"
  },
  "connectivity": {
    "primary": {
      "type": "fiber",
      "bandwidth": "1Gbps",
      "provider": "CityNet"
    },
    "backup": {
      "type": "lte",
      "bandwidth": "50Mbps",
      "provider": "MobileLink"
    },
    "mesh": {
      "enabled": true,
      "protocol": "802.11s",
      "peers": ["edge-district5-node11", "edge-district5-node13"]
    }
  },
  "processing": {
    "filters": [
      {
        "sensor_type": "traffic",
        "condition": "value.count < 2",
        "action": "drop"
      },
      {
        "sensor_type": "environmental",
        "condition": "abs(value - last_value) < threshold",
        "action": "drop",
        "parameters": {
          "threshold": {
            "temperature": 0.5,
            "humidity": 2.0,
            "air_quality": 5.0
          }
        }
      }
    ],
    "aggregations": [
      {
        "sensor_type": "traffic",
        "window": "5m",
        "functions": ["avg", "max", "count"],
        "group_by": ["direction", "vehicle_type"]
      }
    ],
    "events": [
      {
        "name": "high_congestion",
        "condition": "traffic.count > 100 && traffic.speed < 10",
        "actions": [
          {
            "type": "alert",
            "priority": "high",
            "recipients": ["traffic_control", "emergency_services"]
          },
          {
            "type": "actuator",
            "target": "traffic_signals",
            "command": "congestion_mode"
          }
        ]
      }
    ]
  }
}

API Examples

The following examples demonstrate typical API interactions with our platform:

Data Retrieval Example

// Request
GET /api/v1/data/sensors/temperature?location=district-5&start=2025-01-01T00:00:00Z&end=2025-01-02T00:00:00Z&interval=1h
Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...
Accept: application/json

// Response
{
  "status": "success",
  "data": {
    "sensor_type": "temperature",
    "location": "district-5",
    "unit": "celsius",
    "interval": "1h",
    "readings": [
      {
        "timestamp": "2025-01-01T00:00:00Z",
        "value": 21.5,
        "min": 20.8,
        "max": 22.3,
        "count": 12
      },
      {
        "timestamp": "2025-01-01T01:00:00Z",
        "value": 20.9,
        "min": 20.1,
        "max": 21.7,
        "count": 12
      },
      // Additional data points...
    ]
  },
  "meta": {
    "total_points": 24,
    "aggregation": "avg"
  }
}

Webhook Configuration Example

// Request
POST /api/v1/webhooks
Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...
Content-Type: application/json

{
  "name": "Traffic Alert Notification",
  "target_url": "https://traffic.citymanagement.lt/api/alerts",
  "events": [
    "sensor.threshold.exceeded",
    "traffic.congestion.detected"
  ],
  "filters": {
    "location": ["district-5", "district-6"],
    "severity": ["high", "critical"]
  },
  "headers": {
    "X-API-Key": "city_traffic_system_key_123"
  },
  "secret": "webhook_signing_secret_456",
  "active": true
}

// Response
{
  "status": "success",
  "data": {
    "webhook_id": "wh_7f9a8b7c6d5e",
    "name": "Traffic Alert Notification",
    "target_url": "https://traffic.citymanagement.lt/api/alerts",
    "events": [
      "sensor.threshold.exceeded",
      "traffic.congestion.detected"
    ],
    "created_at": "2025-01-21T14:32:10Z",
    "status": "active"
  }
}