Date Type Column Not Included in attributes

[sethdumaguin]

Hello!

I have an MVTLayer with a last_updated column that is a date type as one of its attributes. When I click on a geometry for that layer, it seems like last_updated is not included in the object.properties that gets passed in inside the onClick. Any ideas as to why it's not being included? Thanks

[padawannn]

According to the specification, in mvt format attributes are encoded as number or string so it sounds like a problem with the system that encodes your data in mvt format. Can you give us an example of the MVT that you are using?

[padawannn]

If you're using Carto Maps API it's probably a problem with your query. Have you tried to convert date data into a string in the query that you are sending to the Carto Maps API. For example

SELECT name, age, to_char(last_updated, 'YYYY-MM-DD') AS updated, the_geom, the_geom_webmercator FROM your_table

[dgaubert]

Hi!

MVT doesn't support every type in Postgres, the supported types are:

• bool
• int8, int2, int4
• float4, float8
• numeric
• bpchar, varchar, text, literal

So, as @padawannn mentioned above, you might need to cast the required column to one type of the supported list in the query of the layer. You can cast dates as timestamp from epoch as follows:

select name, age, date_part('epoch', "last_updated") as "last_updated", ... from your_table

[ibgreen]

@padawannn Just a thought: it could potentially be helpful to add @dgaubert general comments to the @loaders.gl/mvt documentation, and reference those docs from the deck.gl MVTLayer

[Pessimistress]

@ibgreen we already have a link in the MVTLayer doc: https://deck.gl/docs/api-reference/geo-layers/mvt-layer#loadoptions

[ibgreen]

OK great, then adding a table with supported data types and a sample SQL stanza to the MVT loader docs would do it :)