crate / crate-admin

The admin user interface for CrateDB.
Apache License 2.0
26 stars 19 forks source link

"Could not parse JSON" message when following link to geojson.io for geo_shape polygon #847

Open hlcianfagna opened 3 months ago

hlcianfagna commented 3 months ago

CrateDB version

5.7.2

Steps to Reproduce

select 
 {type='Polygon', coordinates=[
       [[16.979667, 48.123497], [16.903754, 47.714866],
       [16.340584, 47.712902], [16.534268, 47.496171],
       [16.202298, 46.852386], [16.011664, 46.683611],
       [15.137092, 46.658703], [14.632472, 46.431817],
       [13.806475, 46.509306], [12.376485, 46.767559],
       [12.153088, 47.115393], [11.164828, 46.941579],
       [11.048556, 46.751359], [10.442701, 46.893546],
       [9.932448, 46.920728], [9.47997, 47.10281],
       [9.632932, 47.347601], [9.594226, 47.525058],
       [9.896068, 47.580197], [10.402084, 47.302488],
       [10.544504, 47.566399], [11.426414, 47.523766],
       [12.141357, 47.703083], [12.62076, 47.672388],
       [12.932627, 47.467646], [13.025851, 47.637584],
       [12.884103, 48.289146], [13.243357, 48.416115],
       [13.595946, 48.877172], [14.338898, 48.555305],
       [14.901447, 48.964402], [15.253416, 49.039074],
       [16.029647, 48.733899], [16.499283, 48.785808],
       [16.960288, 48.596982], [16.879983, 48.470013],
       [16.979667, 48.123497]]
 ]}::geo_shape
/* Austria from https://cratedb.com/docs/crate/reference/en/latest/general/dql/geo.html */
;

Then follow the link in the results panel: http://geojson.io/#data=data:application/json,%7B%22value%22%3A%7B%22type%22%3A%22Polygon%22%2C%22coordinates%22%3A%5B%5B%5B16.979667%2C48.123497%5D%2C%5B16.903754%2C47.714866%5D%2C%5B16.340584%2C47.712902%5D%2C%5B16.534268%2C47.496171%5D%2C%5B16.202298%2C46.852386%5D%2C%5B16.011664%2C46.683611%5D%2C%5B15.137092%2C46.658703%5D%2C%5B14.632472%2C46.431817%5D%2C%5B13.806475%2C46.509306%5D%2C%5B12.376485%2C46.767559%5D%2C%5B12.153088%2C47.115393%5D%2C%5B11.164828%2C46.941579%5D%2C%5B11.048556%2C46.751359%5D%2C%5B10.442701%2C46.893546%5D%2C%5B9.932448%2C46.920728%5D%2C%5B9.47997%2C47.10281%5D%2C%5B9.632932%2C47.347601%5D%2C%5B9.594226%2C47.525058%5D%2C%5B9.896068%2C47.580197%5D%2C%5B10.402084%2C47.302488%5D%2C%5B10.544504%2C47.566399%5D%2C%5B11.426414%2C47.523766%5D%2C%5B12.141357%2C47.703083%5D%2C%5B12.62076%2C47.672388%5D%2C%5B12.932627%2C47.467646%5D%2C%5B13.025851%2C47.637584%5D%2C%5B12.884103%2C48.289146%5D%2C%5B13.243357%2C48.416115%5D%2C%5B13.595946%2C48.877172%5D%2C%5B14.338898%2C48.555305%5D%2C%5B14.901447%2C48.964402%5D%2C%5B15.253416%2C49.039074%5D%2C%5B16.029647%2C48.733899%5D%2C%5B16.499283%2C48.785808%5D%2C%5B16.960288%2C48.596982%5D%2C%5B16.879983%2C48.470013%5D%2C%5B16.979667%2C48.123497%5D%5D%5D%7D%2C%22type%22%3A%22geo_shape%22%7D