Struggling to limit a GeoJsonCatalogItem to a single date

[Sivloc]

Hello,

I'm trying to add multiple layers to my terriamap instance, each one displaying data related to a date.
The geoJsons i'm using are coming from a PostGIS DB and are formatted as such :

id : datetime : data : [...] geom : { type: "Polygon", coordinates: (1)[…] }

the layer are displayed just fine, but i would like them to appear only when the timeline is on the related date.
I'm adding my geojson layers dynamically, and i tried fiddling with multiple options such as :

geoJsonItem.setTrait(CommonStrata.user, "startTime", selectedDate+"T00:00:00"); geoJsonItem.setTrait(CommonStrata.user, "stopTime", selectedDate+"T23:59:59"); geoJsonItem.setTrait(CommonStrata.user, "currentTime", selectedDate+"T00:00:00");

But it only affect the bounds of the timeline and the date at which the cursor is placed.

By adding :

geoJsonItem.setTrait(CommonStrata.user, "timeProperty", "datetime");

The layer was invisible before the desired datetime, but visible afterwards until the end of the timeline, and the layer had its style disabled.

After looking at the documentation, i really don't know what is the option i'm looking for.

[zoran995]

Hi @Sivloc, If I understand correctly, you would like to show only features with datetime as the chosen timeline date. Here is a sample of how this can be done with the bike_racks dataset available in our CI catalog: http://ci.terria.io/main/#share=s-nC98LNJ5aTxZxmdXEKsJxdsdcal. If you move through the datetime selector in the workbench, you will see features appear and disappear from the map.
Here is also a copy of catalog item definition

 {
  "id": "DL4Av6wY5h",
  "type": "geojson",
  "name": "GeoJSON Test",
  "url": "test/bike_racks.geojson",
  "initialTimeSource": "start",
  "isPaused": true,
  "styles": [
    {
      "id": "number_of_",
      "color": { "colorPalette": "Reds" },
      "time": {
        "timeColumn": "inspection",
        "endTimeColumn": "",
        "idColumns": ["asset_numb"],
        "isSampled": true,
        "displayDuration": 1440,
        "spreadStartTime": false,
        "spreadFinishTime": false
      },
      "hidden": false
    }
  ]
}

[Sivloc]

Hi @zoran995, thanks for your answer.
I don't know what i'm doing wrong, but i don't even have the datetime selector appearing in the workbench.

My datetime format is "YYYY-MM-DDThh:mm:ss" if that matters.
Also, i don't find any mention of the "initialTimeSource" property in the documentation, what are you supposed to input here ?
I don't quite understand the idColumns neither. is it required ?
But yeah, the display of your CI example is pretty much what i'd like to do.

[zoran995]

Can you share a redacted dataset sample, i.e. only a couple of features with randomised props and positions with dates in the correct format, so that I can check it?

[Sivloc]

Sure, here you go :

{
    "type": "FeatureCollection",
    "features": [{
        "type": "Feature",
        "geometry": {
            "type": "Polygon",
            "coordinates": [
                [
                    [0.0, 0.0],
                    [1.0, 0.0],
                    [1.0, 1.0],
                    [0.0, 1.0],
                    [0.0, 0.0]
                ]
            ]
        },
        "properties": {
            "id": 237,
            "datetime": "2023-10-01T00:00:00",
            "temperature": 20.5,
            "water_depth": 5.0
        }
    },{
        "type": "Feature",
        "geometry": {
            "type": "Polygon",
            "coordinates": [
                [
                    [1.0, 1.0],
                    [2.0, 1.0],
                    [2.0, 2.0],
                    [1.0, 2.0],
                    [1.0, 1.0]
                ]
            ]
        },
        "properties": {
            "id": 250,
            "datetime": "2023-10-01T00:00:00",
            "temperature": 18,
            "water_depth": 7.2
        }
    },{
        "type": "Feature",
        "geometry": {
            "type": "Polygon",
            "coordinates": [
                [
                    [-1.0, -1.0],
                    [0.0, -1.0],
                    [0.0, 0.0],
                    [-1.0, 0.0],
                    [-1.0, -1.0]
                ]
            ]
        },
        "properties": {
            "id": 124,
            "datetime": "2023-10-01T00:00:00",
            "temperature": 34,
            "water_depth": 6
        }
    }]
}

I removed some features cause it would get too big, but the idea is there

[zoran995]

To show a timeline, you need to have features with different times. We won't show a timeline option if all features have the same date. I have updated your sample to have different dates, and it is working with the following catalog definition:

{
  "id": "test-7633",
  "type": "geojson",
  "name": "test-7633",
  "url": "test/test-7633.geojson",
  "initialTimeSource": "start",
  "isPaused": true,
  "activeStyle": "polygons-time",
  "styles": [
    {
      "id": "polygons-time",
      "color": { "colorPalette": "Reds" },
      "time": {
        "timeColumn": "datetime",
        "idColumns": ["id"],
        "displayDuration": 1339
      },
      "hidden": false
    }
  ]
}

Here is the link to CI http://ci.terria.io/main/#clean&https://gist.githubusercontent.com/zoran995/b1d6cabc6b171c5e6f60bf38e83f4b77/raw/a5583182f5cfae8b94a4e59535c40768b9f2d95d/catalog.json&share=s-pBU77JrRy8cw4vyhszZHqM22wrX

The initialTimeSource it is described in docs as

The initial time to use if Current Time is not specified. Valid values are

• start - the dataset's start time
• stop - the dataset's stop time
• now - the current system time. If the system time is after Stop Time, Stop Time is used. If the system time is before Start Time, Start Time is used.
• none - do not automatically set an initial time
  This value is ignored if Current Time is specified.

and idColumns identify your features across time, and we use them to group features so they can be tracked over time

[Sivloc]

Oh i see.
I was adding multiple layers with each layer having a single date on every polygon. So in order to make it work, i would have to fuse the different layers together correct ?
Thanks a lot !