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.