songololo commented on issue #11625: URL: https://github.com/apache/incubator-superset/issues/11625#issuecomment-724658659
@srinify @mistercrunch @junlincc Here are some examples that should be fairly easy to reproduce. These make use of the SQL editor and I'm using the amancevice docker container (v0.37.2). Running a query to create a rectangular polygon (using PostGIS): `SELECT 1 as mock_data, ST_MakeEnvelope(-0.127677, 51.507515, -0.122161, 51.510021, 4326) as geom;` Gives a jagged polygon (instead of rectangular): <img width="1585" alt="Screen Shot 2020-11-10 at 11 40 31" src="https://user-images.githubusercontent.com/4347878/98671432-26c71500-234c-11eb-946c-ee6811b121ed.png"> Similarly, when casting the geometry to Well Known Text format: `SELECT 1 as mock_data, ST_AsText(ST_MakeEnvelope(-0.127677, 51.507515, -0.122161, 51.510021, 4326)) as geom;` <img width="1589" alt="Screen Shot 2020-11-10 at 11 46 36" src="https://user-images.githubusercontent.com/4347878/98671479-3cd4d580-234c-11eb-82d8-21590a117656.png"> And with GeoJSON it displays nothing: `SELECT 1 as mock_data, ST_AsGeoJSON(ST_MakeEnvelope(-0.127677, 51.507515, -0.122161, 51.510021, 4326)) as geom;` <img width="1585" alt="Screen Shot 2020-11-10 at 11 49 50" src="https://user-images.githubusercontent.com/4347878/98671551-5aa23a80-234c-11eb-838c-41b7420c4c04.png"> Any information or advice on how to display a polygon would be much appreciated. Thanks. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
