Map viewport does not render MULTIPOLYGON geometries (PostgreSQL `geometry` column)

[canserhat77]

What

Support rendering MULTIPOLYGON geometries in the map viewport for PostgreSQL geometry-type columns. Currently the map viewport renders POLYGON values correctly, but rows containing MULTIPOLYGON values are not displayed.

Why (problem/use case)

We store geospatial boundaries (e.g. multi-part regions such as county/state groupings, or areas made up of disjoint landmasses) in a PostgreSQL geometry column. Some of these are simple POLYGONs and render fine in the map viewport, but others are legitimately MULTIPOLYGONs (a single feature made of multiple polygon parts). Since MULTIPOLYGON isn't supported, those rows silently fail to appear on the map, making it hard to visually inspect or QA the full dataset.

Additional Context

Example values from a geometry column (SRID 4326):

Renders correctly (POLYGON):
SRID=4326;POLYGON((140.945038 -38.09236,141.225508 -38.379756,141.910847 -38.467555,142.242741 -38.494548,143.410835 -38.94183,143.798763 -38.7699,144.440999 -38.406032,144.88496 -38.601672,145.665126 -38.7699,146.083226 -39.105168,146.56167 -39.32891,146.736028 -38.823764,147.044835 -38.523632,147.681354 -38.048748,148.14176 -37.879816,148.683747 -37.830056,149.622771 -37.765318,149.994254 -37.518367,148.193418 -36.804967,148.096888 -36.791717,148.215482 -36.613715,148.14421 -36.541041,148.035135 -36.189708,147.996584 -36.053975,147.704733 -35.922782,147.551437 -35.989599,147.38766 -35.965742,147.322804 -36.058742,147.11834 -36.018217,147.038744 -36.104138,146.930037 -36.085081,146.461306 -35.980186,146.349283 -36.051721,145.913993 -35.965871,145.504223 -35.81541,145.364086 -35.877528,144.946432 -35.833849,144.98685 -36.052,144.825178 -36.149971,144.434469 -35.855692,144.19196 -35.637,143.760834 -35.406728,143.558743 -35.351804,143.612634 -35.208826,143.383598 -35.175796,143.221925 -34.734107,142.723435 -34.567861,142.683017 -34.723035,142.534817 -34.767316,142.332727 -34.379047,142.198 -34.212091,141.820764 -34.122913,141.430055 -34.212091,140.958511 -34.020578,140.945038 -38.09236))

Does not render (MULTIPOLYGON):
SRID=4326;MULTIPOLYGON(((-0.509701572999973 51.46917593300003,-0.458640618999937 51.45631540900007,-0.45646772799995 51.438106667000056,-0.391342151999936 51.42232609100006,-0.383350192999956 51.408538289000035,-0.359139503999927 51.41190314800008,-0.327818022999963 51.39183712000005,-0.317698057999962 51.39366706100003,-0.307365584999957 51.37838352300008,-0.330510301999936 51.34841941800005,-0.330655712999942 51.32900961900003,-0.306192158999977 51.33508439900004,-0.285438000999932 51.36424916300007,-0.261148734999949 51.37959978400005,-0.245030424999925 51.38003394700007,-0.245405010999946 51.36684542800003,-0.222736600999951 51.35708604700005,-0.217264592999925 51.34338709000008,-0.229822837999961 51.33652279100005,-0.220942639999976 51.32986305800006,-0.197319517999972 51.34359514500005,-0.156543337999949 51.321508562000076,-0.155317877999948 51.30127437900006,-0.13731368699996 51.300780890000055,-0.12429304099993 51.28675863900003,-0.091168096999979 51.301472524000076,-0.078924035999933 51.31976923700006,-0.05130726699997 51.32244786900003,-0.037892463999924 51.33870447500004,0.002294552000023 51.32913883400005,0.015009201000055 51.29178604900005,0.032909247000021 51.30752089200007,0.042396328000052 51.29267303300003,0.085692928000071 51.29308422400004,0.085029146000068 51.31602318600005,0.117903743000056 51.32966322000004,0.118456131000073 51.344147777000046,0.136957934000066 51.34417459200006,0.152057572000047 51.369693691000066,0.147740878000036 51.39280098300003,0.162383996000074 51.392490285000065,0.148902581000073 51.40848296400003,0.152932273000033 51.40870847000008,0.155874873000073 51.43087656800003,0.16432800900003 51.42858494200004,0.172854168000072 51.443245164000075,0.203126097000052 51.45794263300007,0.217617951000022 51.48047470300003,0.210575616000028 51.490247741000076,0.229965173000039 51.49936590300007,0.226632797000036 51.50658601600003,0.241919125000038 51.50796011400007,0.237175792000073 51.519334411000045,0.24896459100006 51.52867401700007,0.253834137000069 51.51788586400005,0.263682736000021 51.51786978500007,0.26534709200007 51.532150251000076,0.334024050000039 51.540503785000055,0.313034910000056 51.56581811900003,0.290289554000026 51.56429937900003,0.269878711000047 51.59957478500007,0.254008537000061 51.601598195000065,0.264561793000041 51.60832065000005,0.252194127000053 51.61776937900004,0.224087585000063 51.63173775800004,0.200311402000068 51.62493574800004,0.138184059000025 51.62354538500006,0.072832057000028 51.60468736900003,0.021818868000025 51.62883277100008,0.02271937200004 51.641115479000064,-0.012259854999968 51.64622868500004,-0.011918849999972 51.680877800000076,-0.105779302999963 51.69187562700006,-0.163493450999965 51.68811507200007,-0.18208554499995 51.66860404600004,-0.191066870999975 51.66389669000006,-0.203353099999958 51.67012647800004,-0.212135195999963 51.66135351300005,-0.250582729999962 51.65605733400008,-0.257332835999932 51.641831843000034,-0.304459004999956 51.63635084500004,-0.316672404999963 51.640535544000045,-0.36262143099998 51.623504800000035,-0.404050343999927 51.61318390500003,-0.440575469999942 51.620073224000066,-0.457130922999966 51.61229388100003,-0.496846447999928 51.631733018000034,-0.500596058999975 51.599689890000036,-0.476620827999966 51.55918881900004,-0.495487527999956 51.538545216000045,-0.483162445999938 51.507127712000056,-0.490024904999927 51.49474761700003,-0.509701572999973 51.46917593300003)))

Both are stored in a standard PostGIS geometry column (SRID 4326).

[mikeburgh]

Fixed in 1.36.9 which has been released