Timestamp-offset field

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
// prepare data for total accidents by time of day chart
let hourData = [], hourLabels = [];

// run stats query to return total number of accidents by time of day
// stats results will be grouped by the time of day
const hourResult = await runQuery("extract(hour from tsodate)");
hourResult.features.forEach((feature) => {
  hourData.push(feature.attributes["count"]);
  hourLabels.push(feature.attributes["EXPR_1"]);
});

// create a bar chart showing total number of accidents by time of day
updateChart("chart-day", hourData, hourLabels);

// this function is called 3 times when the app loads and generates
// count stats for accidents 1. by time of day 2. by day of week and 3. by month
async function runQuery(groupStats) {
  // create a query object that honors the layer settings
  let query = layer.createQuery();
  query.where = "1=1";
  query.outStatistics = [{
    "statisticType": "count",
    "onStatisticField": "*",
    "outStatisticFieldName": "count"
  }];
  query.groupByFieldsForStatistics = [groupStats];
  query.orderByFields = [groupStats];
  let result = await layer.queryFeatures(query);
  return result;
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
let renderer = {
  type: "unique-value",
  valueExpression: `
    var d = $feature.TSODate;
    var h = Hour(d);

    When(
      h <= 6, "night",
      h <= 12, "morning",
      h <= 18, "afternoon",
      "evening"
    );
  `,
  uniqueValueInfos: [{
    value: "morning",
    symbol: createSymbol("purple")
  }, {
    value: "afternoon",
    symbol: createSymbol("orange")
  }, {
    value: "evening",
    symbol: createSymbol("blue")
  }, {
    value: "night",
    symbol: createSymbol("black")
  }],
  defaultSymbol: createSymbol("gray"),
};

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
let popupTemplate = {
  title: "Crash information",
  fieldInfos: [
    {
      fieldName: "expression/TSO-from-server",
    }
  ],
  expressionInfos: [{
    // timestamp-offset field will display in the time zone from the server
    // with an abbreviated time zone suffix
    expression: `Text($feature.TSODate, "M/D/Y, h:mm A ZZZZ")`,
    name: "TSO-from-server",
  }],
  content: [{
    type: "fields"
  }]
};