Opened 5 years ago
Closed 5 years ago
#4540 closed defect (invalid)
ST_AsMVT silently drops json columns
| Reported by: | nextstopsun | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.5.4 |
| Component: | postgis | Version: | 2.5.x -- EOL |
| Keywords: | Cc: |
Description
ST_AsMVT doesn't encode columns of type JSON/JSONB. It's output doesn't contain properties from json and no message is raised while encoding.
MVT spec currently doesn't have this data type, but these types could first be cast to TEXT type and then encoded (i.e. tippecanoe does internal conversion to text for nested json properties).
Change History (2)
comment:1 by , 5 years ago
comment:2 by , 5 years ago
| Resolution: | → invalid |
|---|---|
| Status: | new → closed |
Closing this for now. Feel free to reopen with an example.
Note:
See TracTickets
for help on using tickets.
ST_AsMVT extracts and includes JSONB properties, for example: https://github.com/postgis/postgis/blob/9796ad61e18f2390622ccb4fc95c235df2c0e390/regress/core/mvt_jsonb.sql#L1
Can you share an example of a query where this doesn't work?