Skip to Main Content
Preset Feature Feedback
Status Needs review
Categories Enhancement
Created by Customer Engagement
Created on Feb 5, 2025

Deck.gl GeoJSON chart extra tags for visualization

What is the problem or goal the end user is trying to solve or accomplish?

R: When the users want to visualize the database from geojson need to check this extra tag for the visualization work.

For example:
Query from the user at first instance:

SELECT "METRO" AS "METRO", "OBJ_ID" AS "OBJ_ID", "OBJ_NAME" AS "OBJ_NAME", ST_ASGEOJSON(GEOM) AS "ASGEOJSON"

FROM community.neighborhood_boundaries_objects_usa_auto_update GROUP BY "METRO", "OBJ_ID", "OBJ_NAME", ST_ASGEOJSON(GEOM)

LIMIT 100


After I help him with the tags:

SELECT "METRO" AS "METRO", "OBJ_ID" AS "OBJ_ID", "OBJ_NAME" AS "OBJ_NAME", '{"type" : "Feature", "properties":{}, "geometry" : ' || ST_ASGEOJSON(GEOM)::varchar || '}' AS "ASGEOJSON"

FROM community.neighborhood_boundaries_objects_usa_auto_update

WHERE "METRO" IN ('Minneapolis - St. Paul, MN') GROUP BY "METRO", "OBJ_ID", "OBJ_NAME", '{"type" : "Feature", "properties":{}, "geometry" : ' || ST_ASGEOJSON(GEOM)::varchar || '}'

LIMIT 10


How are they solving it currently?

R: Need always to put the tag.

What is the recommended solution by the Customer?

R: To have a guide or a tip when create the deck.gl charts that explain that the databases must have the geojson tag.

  • Attach files
      Drop here to upload
    • +1