Skip to content
ZillionInfo DataSphereX

Space-Time Aggregation

Space-Time Aggregation aggregates the input data into space-time series data based on the spatial relationship between the target data and the join data, or the join fields. The output data can be used in the Space-Time Patterns (VIS-STAMP) service.

1. Set the target data

  • Target Data: Spatial data only.

2. Set the join data

  • Join Data: It can be spatial data or attribute data.
  • Longitude and Latitude Fields: When joining attribute data, you need to select longitude and latitude fields for determining the spatial relationship.

3. Set the join type

  • Join Type: Contains or Join By Attributes.
    • Contains: The spatial relationship between the target data and the join data.
    • Join By Attributes: Match the values in the join fields of the target data and the join data.
      • Target Data Join Field: The join field of the target data.
      • Join Data Join Field: The join field of the join data.

4. Set the calculation type

  • Calculate Values: Calculate the statistics of multiple records in the same space-time category.
  • Count Units: Count the number of units in the same space-time category.

5. Set the output fields

5.1 Caculate values

  • Output Fields: The fields to be added to the new data.
  • Merge Rule: The rule to merge the values of multiple records in a space-time category.
    • First: Use the value of the first record in a space-time category.
    • Last: Use the value of the last record in a space-time category.
    • Join by Semicolon: Concatenate the values of multiple records in a space-time category with semicolons.
    • Sum: Calculate the sum of the values of the records in a space-time category.
    • Average: Calculate the average of the values of records in a space-time category.
    • Count: Calculate the number of the records in a space-time category.
    • Min: Use the minimum value of the records in a space-time category.
    • Max: Use the maximum value of the records in a space-time category.
    • Standard Deviation: Calculate the standard deviation of the values of the records in a space-time category.

5.2 Count units

  • Count Field (optional): When no count field is selected, count the number of units that match the spatial relationship of the join data. When the count field is selected, the number of different values of the field in the spatially related units of the join data is counted.
  • Input Keywords (optional): If no keywords are entered, all different values in the count field are counted. When keywords are entered, only the values of the count fields that match the keywords are counted. Multiple keywords should be separated by ”;” (e.g. “Restaurant;Starbucks”).
  • Match Type: Exact match or fuzzy match for the entered keywords.

6. Set the time field

  • Time Field: Its values will be used as the time.

7. Set the join ID field

  • Join ID Field: Its values will be used to relate the output spatial data to the output space-time attribute data. The values should be unique.

8. Set the time category

  • Date Time Category (Optional): Hour, Day, Day of Week, Day of Week_Hour,Weekday/Weekend, Week, Month, Quarter, Year, and Year_Month. If it is not set, the different values in the time field will be used as time categories.

9. Set the output data

  • Output Data Name: If no name is set, the default is “toolName_time”.

10. Submit

After completing the above settings, click Submit to start the tool.
When it finishes successfully, a message will be shown at the top of the page. You can click the Open Data button to start accessing the data or go to the Data page to view it.