aklein-1s commented on issue #34748:
URL: https://github.com/apache/superset/issues/34748#issuecomment-3210885854
Ok yes I extracted that :
`SELECT jsonb_build_object('type', 'Feature', 'geometry',
st_asgeojson(st_transform(geometry, 4326))::jsonb, 'properties',
jsonb_build_object())::text AS geometry
FROM (
SELECT * FROM (VALUES
(ST_GeomFromText('POINT (853778.0045595274 6516351.593782518)', 2154)),
(ST_GeomFromText('POINT (828245.68892 6588140.943354)', 2154)),
(ST_GeomFromText('POINT (849549.1255430854 6424346.487474646)', 2154)),
(ST_GeomFromText('POINT (839138.911189078 6388543.805272557)', 2154)),
(ST_GeomFromText('POINT (832483.7289913156 6384095.543174613)', 2154)),
(ST_GeomFromText('POINT (834448.8495350456 6358541.398964814)', 2154)),
(ST_GeomFromText('POINT (842410.5 6484632.5)', 2154)),
(ST_GeomFromText('POINT (842461.9049286958 6456273.545988022)', 2154)),
(ST_GeomFromText('POINT (840816.1537722007 6476831.7549293395)', 2154)),
(ST_GeomFromText('POINT (840792.7419336346 6477554.5716457805)', 2154))
) AS samples(geometry)
) AS sample_points;`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
