By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| st_astext |
|---|
| POLYGON((-4.499799143102978 54.15000250241551,-4.499802170911825 54.149979451852495,-4.499812801170775 54.149957190948996,-4.499830625354031 54.1499365751772,-4.499854958480624 54.14991839678672,-4.499884865439011 54.14990335435932,-4.499919196923359 54.14989202596341,-4.499956633600447 54.149884846939656,-4.499995736809923 54.14988209317172,-4.500035003849662 54.14988387048435,-4.500072925721904 54.14989011057693,-4.500108045121269 54.14990057364805,-4.500139012436535 54.14991485761069,-4.50016463761428 54.149932413543745,-4.50018393589149 54.149952566786204,-4.50019616563972 54.14997454286349,-4.500200856866455 54.14999749724952,-4.500197829278193 54.150020547821065,-4.500187199210902 54.15004280875709,-4.500169375161197 54.15006342458048,-4.500145042089716 54.15008160303374,-4.500115135099612 54.15009664552555,-4.500080803501547 54.15010797397774,-4.500043366646053 54.15011515304099,-4.500004263220643 54.15011790682573,-4.499964995960316 54.15011612950457,-4.499927073896417 54.15010988937946,-4.499891954363501 54.15009942625675,-4.499860986993122 54.15008514223134,-4.499835361847095 54.15006758623387,-4.499816063683604 54.15004743293514,-4.499803834113779 54.15002545681833,-4.499799143102978 54.15000250241551)) |
| POINT(-4.5 54.15) |
| POLYGON((-4.500142018871887 54.14991663195707,-4.500142018871887 54.15008336787427,-4.499857980557457 54.15008336787427,-4.499857980557457 54.14991663195707,-4.500142018871887 54.14991663195707)) |
| POLYGON((-4.500200856866455 54.14988209317172,-4.500200856866455 54.15011790682573,-4.499799143102978 54.15011790682573,-4.499799143102978 54.14988209317172,-4.500200856866455 54.14988209317172)) |
SELECT 4