[JDBC-V2] Spatial data returned as double[]

Description

Spatial data like Point should be returned in the format recognizable as geometry data. This works on V1 JDBC but newer JDBC version returns Point as Double[].

Example query:

select 
	cast(arrayJoin([(4.837388, 52.38795),
			(4.951513, 52.354582),
			(4.961987, 52.371763),
			(4.870017, 52.334932),
			(4.89813, 52.357238),
			(4.852437, 52.370315),
			(4.901712, 52.369567),
			(4.874112, 52.339823),
			(4.856942, 52.339122),
			(4.870253, 52.360353)]
			)
		as Point) as Point

Relates: dbeaver/dbeaver#39111

There is a problem with v2 implementation because for array types (which Point is) returns java.sql.Array but v1 returns Double[]:

2025-09-10 12:03:46.073 - Can't read column 'Point' value
java.lang.ClassCastException: class com.clickhouse.jdbc.types.Array cannot be cast to class [D (com.clickhouse.jdbc.types.Array is in unnamed module of loader org.jkiss.dbeaver.registry.driver.DriverClassLoader @65efc5a8; [D is in module java.base of loader 'bootstrap')
	at org.jkiss.dbeaver.ext.clickhouse.model.data.ClickhouseGeometryValueHandler.getValueFromObject(ClickhouseGeometryValueHandler.java:71)
	at org.jkiss.dbeaver.ext.clickhouse.model.data.ClickhouseGeometryValueHandler.fetchColumnValue(ClickhouseGeometryValueHandler.java:90)
	at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:49)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchRow(ResultSetDataReceiver.java:126)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.fetchQueryData(SQLQueryJob.java:943)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:708)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$2(SQLQueryJob.java:550)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:569)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1043)
	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:4363)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:128)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:126)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5145)
	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:119)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

This requires adjusting behavior for geo types. :-( again.

@chernser

Hi @chernser, thanks for picking up this issue that I actually opened on DBeaver, thinking the issue was there. I saw the above PR fixing the issue and just wanted to verify that this fix extends to other geometries as well?

For example, I have included 2 additional code snippets for linestring & polygons, as they also share this issue.

Linestring:

select 
'LINESTRING(4.86779 52.35528,4.86779 52.35528,4.86779 52.35528,4.867837 52.3553,4.867837 52.3553,4.86796 52.35535,4.86891 52.355568,4.87018 52.35592,4.870685 52.35609,4.870952 52.356157,4.871932 52.356387,4.873325 52.356752,4.874803 52.357177,4.874872 52.357208,4.875612 52.357418,4.876638 52.357707,4.877533 52.35794,4.878192 52.35818,4.87812 52.35852,4.87794 52.35876,4.87794 52.35876,4.877832 52.359038,4.877412 52.359682,4.87739 52.359717,4.877388 52.359718,4.87727 52.35989,4.876772 52.360588,4.876175 52.361427,4.875588 52.362232,4.875118 52.36281,4.874987 52.363042,4.874903 52.363197,4.8749 52.363228,4.8749 52.363228,4.87488 52.363257,4.874842 52.363292,4.874702 52.363538,4.874242 52.364263,4.873647 52.365158,4.873527 52.365838,4.873527 52.365838,4.873595 52.365878,4.874352 52.366145,4.874435 52.366615,4.875303 52.366893,4.876183 52.367162,4.876708 52.367342,4.876743 52.367863,4.876505 52.368488,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876605 52.368525,4.877153 52.368685,4.877178 52.368693,4.877225 52.368708,4.877248 52.368715,4.877617 52.368888,4.878187 52.368955,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048)' as route,
readWKTLineString(route) as geom

which produces:

and Polygon:

select 
'POLYGON((4.827461242675782 52.35091275849595,4.827461242675782 52.37339840013861,4.918956756591798 52.37339840013861,4.918956756591798 52.35091275849595,4.827461242675782 52.35091275849595))' as envelope,
readWKTPolygon(envelope) as geom

which produces:

I am almost certain that this would imply that Multi - geometries (Multipolygon etc) will also be affected. Looking at the PR I do see these geom types included.

I am also happy to send you sample data that can be used for more integration tests for every geometry Type, just let me know.

@duvenagep

Good day, @duvenagep !
yes, the PR will fix all geo types. Currently it fixes only Point just to confirm the fix.

I will appreciate any sample data and what to test.

@chernser

Hi @chernser

The OGC standard lists the following Geometry types:

Point: A single location in space.
LineString: A sequence of points connected by lines.
Polygon: A closed surface defined by a boundary line.
MultiPoint: A collection of points.
MultiLineString: A collection of LineStrings.
MultiPolygon: A collection of Polygons.
GeometryCollection: A collection of other geometry objects, which can be of mixed types.

Thus I have compiled a list of queries to test all geo types. Obviously you have already included Point but for completeness sake I included it again. Hopefully this can serve as a comprehensive testbed for geo types going forward.

Please let me know if you need any additional information of more sample data for testing.

Point

select 
	cast(arrayJoin([(4.837388, 52.38795),
			(4.951513, 52.354582),
			(4.961987, 52.371763),
			(4.870017, 52.334932),
			(4.89813, 52.357238),
			(4.852437, 52.370315),
			(4.901712, 52.369567),
			(4.874112, 52.339823),
			(4.856942, 52.339122),
			(4.870253, 52.360353)]
			)
		as Point) as Point

Results

Desired Results

Linestring

select 
'LINESTRING(4.86779 52.35528,4.86779 52.35528,4.86779 52.35528,4.867837 52.3553,4.867837 52.3553,4.86796 52.35535,4.86891 52.355568,4.87018 52.35592,4.870685 52.35609,4.870952 52.356157,4.871932 52.356387,4.873325 52.356752,4.874803 52.357177,4.874872 52.357208,4.875612 52.357418,4.876638 52.357707,4.877533 52.35794,4.878192 52.35818,4.87812 52.35852,4.87794 52.35876,4.87794 52.35876,4.877832 52.359038,4.877412 52.359682,4.87739 52.359717,4.877388 52.359718,4.87727 52.35989,4.876772 52.360588,4.876175 52.361427,4.875588 52.362232,4.875118 52.36281,4.874987 52.363042,4.874903 52.363197,4.8749 52.363228,4.8749 52.363228,4.87488 52.363257,4.874842 52.363292,4.874702 52.363538,4.874242 52.364263,4.873647 52.365158,4.873527 52.365838,4.873527 52.365838,4.873595 52.365878,4.874352 52.366145,4.874435 52.366615,4.875303 52.366893,4.876183 52.367162,4.876708 52.367342,4.876743 52.367863,4.876505 52.368488,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876525 52.3685,4.876605 52.368525,4.877153 52.368685,4.877178 52.368693,4.877225 52.368708,4.877248 52.368715,4.877617 52.368888,4.878187 52.368955,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048,4.878703 52.369048)' as route,
readWKTLineString(route) as geom

Results

Desired Result

Polygon

select 
'POLYGON((4.827461242675782 52.35091275849595,4.827461242675782 52.37339840013861,4.918956756591798 52.37339840013861,4.918956756591798 52.35091275849595,4.827461242675782 52.35091275849595))' as envelope,
readWKTPolygon(envelope) as geom

Results

Desired Result

MultiPoint

select 
'MULTIPOINT ((4.83739 52.3879), (4.95151 52.3546), (4.96199 52.3718), (4.87002 52.3349), (4.83739 52.3879), (4.89813 52.3572), (4.85244 52.3703), (4.90171 52.3696), (4.87411 52.3398), (4.85694 52.3391), (4.87025 52.3604))' as multipoint

NOTE: seems multipoint is not supported

MultiLineString

select 
'MULTILINESTRING ((4.8935 52.351688, 4.893413 52.351647, 4.893352 52.351638, 4.892842 52.351575, 4.892227 52.351492, 4.891533 52.351427, 4.891533 52.351427, 4.891508 52.351453, 4.891285 52.351633, 4.891298 52.352107, 4.891072 52.352617, 4.890502 52.35258, 4.890497 52.352578, 4.890112 52.352513, 4.889135 52.352398, 4.888088 52.35228, 4.886977 52.352205, 4.88585 52.352222, 4.88551 52.352233, 4.885452 52.352218, 4.885408 52.352222, 4.88537 52.3522, 4.885265 52.352213, 4.885188 52.35222, 4.884722 52.35227, 4.884625 52.352282, 4.88431 52.352313, 4.883388 52.352488, 4.88233 52.352825, 4.8821 52.352977, 4.882097 52.353002, 4.882097 52.353002, 4.882097 52.353002, 4.882067 52.353015, 4.882067 52.353015, 4.881962 52.353148, 4.881487 52.353863, 4.880873 52.35475, 4.88029 52.355518, 4.879682 52.356322, 4.879682 52.356322, 4.879682 52.356322, 4.87969 52.35635, 4.87969 52.35635, 4.87969 52.35635, 4.879572 52.356532, 4.879288 52.356933, 4.878985 52.357365, 4.878653 52.357828, 4.878422 52.358038, 4.878282 52.35801, 4.878273 52.357977, 4.878248 52.357945, 4.878217 52.357912, 4.877938 52.357878, 4.87749 52.357752, 4.876415 52.357475, 4.875277 52.357242, 4.874668 52.357172, 4.874552 52.357257, 4.874187 52.357703, 4.874183 52.35772, 4.874235 52.357678, 4.874235 52.357678, 4.874235 52.357678, 4.874235 52.357678), (4.878402 52.377643, 4.878402 52.377643, 4.878528 52.37771, 4.878827 52.378272, 4.879228 52.378642, 4.879697 52.379392, 4.880218 52.380228, 4.880692 52.380962, 4.881292 52.381905, 4.88198 52.382962, 4.88267 52.383963, 4.883102 52.3847, 4.883147 52.384733, 4.883745 52.38529, 4.884165 52.385363, 4.88418 52.385337, 4.88418 52.385337, 4.88418 52.385337, 4.88418 52.385337, 4.884338 52.385265, 4.885342 52.384728, 4.88625 52.384233, 4.886582 52.384073, 4.887273 52.38368, 4.888023 52.383252, 4.888938 52.382802, 4.888962 52.382792, 4.888983 52.382783, 4.889508 52.382572, 4.890442 52.382143, 4.891352 52.381733, 4.892382 52.381363, 4.893378 52.380992, 4.894658 52.38051, 4.895955 52.380518, 4.896042 52.381023, 4.89674 52.381427, 4.897208 52.381233, 4.897192 52.381245, 4.897192 52.381245, 4.897192 52.381245), (4.911212 52.365387, 4.911152 52.365397, 4.910947 52.36546, 4.910392 52.36504, 4.909322 52.364848, 4.90797 52.364613, 4.90688 52.36444, 4.906047 52.364222, 4.905167 52.36404, 4.904405 52.363878, 4.903112 52.363735, 4.902367 52.363588, 4.901692 52.363437, 4.901848 52.36306, 4.902037 52.362548, 4.901543 52.362337, 4.900423 52.362202, 4.899658 52.362053, 4.898845 52.36189, 4.898177 52.361787, 4.89811 52.361747, 4.897633 52.361645, 4.897047 52.36158, 4.896373 52.361482, 4.895802 52.361447, 4.894738 52.36159, 4.893598 52.36175, 4.892398 52.361915, 4.89153 52.362028, 4.891492 52.36203, 4.891332 52.362022, 4.890365 52.362135, 4.889107 52.362285, 4.888037 52.362467, 4.887552 52.362097, 4.887098 52.361528, 4.886803 52.361147, 4.88668 52.361012, 4.886228 52.360668, 4.88581 52.360645, 4.885687 52.360707, 4.884707 52.361172, 4.883657 52.361603, 4.882357 52.361638, 4.881542 52.361808, 4.881077 52.361988, 4.880238 52.362662, 4.879695 52.362943, 4.87923 52.363302, 4.878678 52.36357, 4.878123 52.363438, 4.8775 52.363273, 4.87632 52.362923, 4.875073 52.36259, 4.874328 52.362422, 4.874128 52.362367, 4.87396 52.362322, 4.873718 52.362252, 4.873285 52.362132, 4.872705 52.36196, 4.872287 52.361863, 4.872108 52.361827, 4.871557 52.361683, 4.87044 52.361408, 4.868808 52.360968, 4.867138 52.36057, 4.865333 52.360145, 4.865307 52.360138, 4.865268 52.36014, 4.865268 52.36014, 4.865253 52.360137, 4.864245 52.359942, 4.862572 52.35955, 4.860948 52.35915, 4.859842 52.358817, 4.859783 52.358785, 4.859783 52.358785, 4.859783 52.358785, 4.859783 52.358785, 4.859343 52.35869, 4.857842 52.358318, 4.857145 52.358103, 4.856587 52.357958, 4.854942 52.357768, 4.854942 52.357768, 4.854942 52.357768, 4.854923 52.357772, 4.854097 52.358013, 4.8536 52.35807, 4.8534 52.357943, 4.852562 52.357785, 4.852482 52.357297, 4.851997 52.357155, 4.851885 52.356737, 4.851802 52.356733, 4.851802 52.356733), (4.993018 52.359248, 4.993018 52.359248, 4.993025 52.35925, 4.993698 52.359635, 4.994442 52.36013, 4.995642 52.359673, 4.996693 52.35916, 4.99705 52.359075, 4.998197 52.358502, 4.999517 52.357805, 5.000905 52.357068, 5.00228 52.356343, 5.003665 52.355608, 5.00505 52.35488, 5.006205 52.354272, 5.007517 52.353552, 5.008785 52.3528, 5.008782 52.352775, 5.008305 52.35222, 5.007195 52.351703, 5.007672 52.351293, 5.008827 52.350722, 5.010053 52.350058, 5.011325 52.349388, 5.012503 52.348773, 5.013435 52.34899, 5.013998 52.348722, 5.014802 52.34781, 5.015645 52.3468, 5.016432 52.34582, 5.016938 52.344745, 5.0163 52.343507, 5.015678 52.342558, 5.014997 52.34151, 5.01406 52.340578, 5.012993 52.339693, 5.011735 52.338782, 5.010508 52.337892, 5.00931 52.337005, 5.008105 52.336147, 5.006835 52.335475, 5.005252 52.335375, 5.003405 52.335588, 5.001518 52.33547, 4.999812 52.335067, 4.998053 52.334877, 4.996313 52.3353, 4.994667 52.335873, 4.99308 52.336523, 4.991747 52.337348, 4.990602 52.338272, 4.989077 52.338978, 4.987573 52.339502, 4.987555 52.339515, 4.987422 52.339648, 4.986128 52.339397, 4.986015 52.338427, 4.98552 52.337798, 4.984715 52.337945, 4.983755 52.337307, 4.982402 52.33652, 4.980755 52.335973, 4.98021 52.335025, 4.98001 52.333993, 4.979947 52.33359, 4.978493 52.333817, 4.977162 52.334392, 4.976717 52.334433, 4.976032 52.334532, 4.974345 52.335018, 4.972623 52.335518, 4.97097 52.335998, 4.969892 52.336272, 4.968372 52.336743, 4.967307 52.337042, 4.966062 52.337392, 4.964248 52.33768, 4.962757 52.337935, 4.961535 52.338113, 4.960728 52.338275, 4.960567 52.338185, 4.96022 52.337507, 4.959753 52.33688, 4.95993 52.336533, 4.959088 52.33601, 4.958182 52.335335, 4.957598 52.33476, 4.956817 52.333998, 4.95608 52.333833, 4.955293 52.333077, 4.954922 52.332722, 4.954393 52.332235, 4.953753 52.33145, 4.954058 52.330812, 4.954578 52.330107, 4.955198 52.329683, 4.955202 52.329675, 4.955202 52.329675, 4.955202 52.329675), (4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359005, 4.793163 52.358822, 4.793385 52.358397, 4.793683 52.357887, 4.794025 52.357307, 4.79464 52.357202, 4.795427 52.35736, 4.795837 52.357438, 4.795983 52.357463, 4.796632 52.357585, 4.797482 52.357762, 4.798567 52.357977, 4.799555 52.358178, 4.800333 52.358308, 4.800333 52.358308, 4.800333 52.358308, 4.800412 52.358317, 4.800957 52.358408, 4.801615 52.358543, 4.802622 52.358732, 4.803242 52.358833, 4.803512 52.358663, 4.803697 52.358418, 4.804047 52.357865, 4.804348 52.357612, 4.805057 52.357817, 4.805892 52.35799, 4.806732 52.358173, 4.80738 52.358307, 4.80785 52.358327, 4.808378 52.358222, 4.80856 52.357903, 4.808748 52.357612, 4.808935 52.357333, 4.809112 52.357043, 4.809198 52.356898, 4.80929 52.356702, 4.809572 52.356688, 4.810228 52.356833, 4.8112 52.357157, 4.812552 52.35739, 4.813865 52.357643, 4.814757 52.357813, 4.81554 52.357965, 4.816352 52.358135, 4.817232 52.357982, 4.818792 52.357897, 4.820183 52.357983, 4.821425 52.358175, 4.821442 52.358863, 4.822035 52.35915, 4.823363 52.359153, 4.824638 52.359185, 4.826048 52.359195, 4.82749 52.359235, 4.827927 52.359212, 4.828388 52.35923, 4.829288 52.359265, 4.830132 52.359293, 4.830887 52.359238, 4.831758 52.35926, 4.832773 52.359272, 4.83387 52.35931, 4.835052 52.359298, 4.83642 52.35932, 4.837885 52.359315, 4.83946 52.35933, 4.840818 52.359388, 4.842177 52.35932, 4.84334 52.359182, 4.844092 52.35835, 4.844117 52.358342, 4.844202 52.358342, 4.845255 52.358302, 4.846877 52.358227, 4.848628 52.358207, 4.849973 52.358177, 4.851393 52.358197, 4.852597 52.35849, 4.853628 52.358547, 4.85428 52.358155, 4.854312 52.358128, 4.854312 52.358128, 4.854312 52.358128, 4.854732 52.357972, 4.855708 52.35789, 4.856643 52.358135, 4.857928 52.358463, 4.859572 52.358905, 4.860518 52.359193, 4.861038 52.359292, 4.861828 52.359482, 4.861845 52.359485, 4.861863 52.359503, 4.86192 52.35953, 4.86192 52.35953, 4.86203 52.35956, 4.862402 52.35963, 4.862475 52.359645, 4.862475 52.359645, 4.862647 52.359692, 4.862963 52.359768, 4.86359 52.359917, 4.864465 52.360122, 4.865508 52.360385, 4.866935 52.360697, 4.86815 52.360953, 4.868222 52.360978, 4.869327 52.361277, 4.870707 52.36163, 4.871955 52.361965, 4.873425 52.362363, 4.874048 52.362555, 4.874388 52.362617, 4.87486 52.36272, 4.87553 52.362903, 4.876063 52.363045, 4.87622 52.36308, 4.876788 52.363205, 4.877243 52.363342, 4.87794 52.363543, 4.878718 52.36391, 4.878718 52.36391, 4.878718 52.36391, 4.878688 52.363935, 4.878637 52.364008, 4.878618 52.364037, 4.878573 52.364208, 4.878648 52.365008, 4.878207 52.365855, 4.878132 52.36621, 4.878143 52.366213, 4.878192 52.366235, 4.878192 52.366235, 4.878193 52.366235, 4.878717 52.366447, 4.879583 52.36661, 4.879965 52.365942, 4.880277 52.365422, 4.880425 52.36549, 4.880695 52.365595, 4.881255 52.365785, 4.88195 52.366023, 4.882512 52.366195, 4.883028 52.366282, 4.883723 52.365788, 4.884525 52.365245, 4.884967 52.365015, 4.885248 52.364802, 4.885477 52.364628, 4.885673 52.364507, 4.885985 52.364272, 4.886492 52.363827, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.886497 52.363843), (4.87266 52.341542, 4.87266 52.341542, 4.87266 52.341542, 4.87266 52.341542, 4.872738 52.34156, 4.872738 52.34156, 4.872743 52.341548, 4.872828 52.341358, 4.872772 52.341123, 4.872602 52.341062, 4.872602 52.341062, 4.87241 52.340987, 4.871243 52.340958, 4.869778 52.34091, 4.868758 52.34086, 4.868758 52.34086, 4.868307 52.340863, 4.868065 52.341235, 4.867867 52.341497, 4.866777 52.341452, 4.865353 52.341403, 4.864647 52.341267, 4.863325 52.341185, 4.862022 52.341117, 4.860503 52.34102, 4.859275 52.340977, 4.858153 52.341037, 4.857222 52.341127, 4.857222 52.341127, 4.85719 52.34113, 4.856398 52.341205, 4.855327 52.341283, 4.854515 52.341303, 4.853623 52.34114, 4.852752 52.341083, 4.851708 52.340937, 4.850872 52.340832, 4.849815 52.340683, 4.848877 52.340502, 4.84773 52.340365, 4.847415 52.33995, 4.847367 52.339445, 4.84685 52.339418, 4.846182 52.33947, 4.846088 52.340093, 4.846183 52.340802, 4.84638 52.341402, 4.84602 52.341672, 4.846073 52.342183, 4.845657 52.342232, 4.844665 52.342178, 4.844658 52.342167, 4.844612 52.342193, 4.844603 52.342168, 4.844603 52.342168, 4.844603 52.342168, 4.844603 52.342168), (4.890497 52.344585, 4.890562 52.344583, 4.890562 52.344583, 4.890562 52.344583, 4.890618 52.344605, 4.890815 52.344953, 4.890942 52.345798, 4.890913 52.34653, 4.890875 52.346927, 4.889775 52.34701, 4.887985 52.347115, 4.886848 52.34746, 4.88684 52.34747, 4.887538 52.347488, 4.889105 52.347402, 4.89066 52.347375, 4.891372 52.347357, 4.891397 52.347358, 4.891397 52.347358, 4.891438 52.347362, 4.891438 52.347362, 4.891438 52.347362, 4.891438 52.347362, 4.891495 52.34737, 4.89156 52.347372, 4.89167 52.347363, 4.892033 52.347305, 4.892775 52.34722, 4.894412 52.347127, 4.895448 52.347083, 4.895477 52.34708, 4.896222 52.347013, 4.898102 52.346948, 4.899922 52.346867, 4.901665 52.346772, 4.903038 52.3466, 4.90408 52.346325, 4.905042 52.346423, 4.90597 52.346532, 4.907097 52.346607, 4.908353 52.346775, 4.909553 52.346938, 4.910815 52.347133, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.91249 52.347347, 4.913557 52.347443, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913855 52.347227, 4.913855 52.347227, 4.913855 52.347227, 4.913855 52.347223, 4.914072 52.346807, 4.914458 52.346142, 4.915062 52.345757, 4.916123 52.345178, 4.917018 52.344585, 4.917877 52.344022, 4.918277 52.343297, 4.918697 52.342533, 4.919125 52.341703, 4.919593 52.340762, 4.920188 52.33986, 4.920765 52.339103, 4.92134 52.338395, 4.920753 52.338082, 4.920753 52.338082, 4.920753 52.338082, 4.920753 52.338082, 4.920765 52.338087, 4.920795 52.338105, 4.920795 52.338105, 4.920828 52.338137, 4.920828 52.338137, 4.920947 52.33828, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248), (4.896565 52.347072, 4.896565 52.347072, 4.89661 52.34706, 4.896653 52.34706, 4.897307 52.346992, 4.898772 52.346928, 4.90033 52.346847, 4.901993 52.346737, 4.903388 52.346425, 4.904052 52.346223, 4.905062 52.346378, 4.905773 52.346472, 4.905773 52.346472, 4.905773 52.346472, 4.905773 52.346472, 4.905777 52.346472, 4.90637 52.346538, 4.907793 52.346703, 4.908543 52.346798, 4.909432 52.346923, 4.911027 52.347165, 4.91206 52.347292, 4.912403 52.347347, 4.913352 52.347488, 4.913442 52.3478, 4.913182 52.348355, 4.913145 52.34874, 4.913597 52.349065, 4.914453 52.349417, 4.915082 52.349333, 4.915807 52.34945, 4.916548 52.349825, 4.916842 52.349967, 4.916842 52.349967, 4.916842 52.349967, 4.916852 52.349978, 4.916658 52.350143, 4.916715 52.350372, 4.917298 52.350643, 4.917058 52.350933, 4.916665 52.351185, 4.916592 52.351215, 4.916687 52.351218, 4.916687 52.351218), (4.945237 52.351265, 4.945237 52.351265, 4.945237 52.351265, 4.94531 52.351323, 4.945398 52.351348, 4.945753 52.351537, 4.9459 52.351838, 4.945382 52.352185, 4.944607 52.35269, 4.94378 52.353188, 4.943073 52.353632, 4.942352 52.354122, 4.941633 52.354553, 4.940945 52.35487, 4.940162 52.35536, 4.939537 52.355753, 4.939147 52.356002, 4.938505 52.356338, 4.937435 52.356793, 4.936668 52.357085, 4.936668 52.357085, 4.936513 52.357168, 4.935605 52.357017, 4.934353 52.356758, 4.9333 52.35657, 4.933003 52.356878, 4.932187 52.35671, 4.931227 52.356515, 4.93087 52.356455, 4.930748 52.356428, 4.93045 52.356705, 4.930607 52.356772, 4.930607 52.356772), (4.911508 52.36197, 4.911458 52.361965, 4.911382 52.36183, 4.910475 52.361503, 4.909327 52.361313, 4.90831 52.361078, 4.908677 52.360445, 4.908405 52.359977, 4.908347 52.359972, 4.908347 52.359972, 4.908347 52.359972, 4.908347 52.359972, 4.907738 52.359723, 4.906388 52.35915, 4.904723 52.358788, 4.903385 52.358627, 4.903385 52.358627, 4.903385 52.358627, 4.903342 52.358613, 4.903342 52.358613, 4.90329 52.358593, 4.902595 52.35846, 4.90144 52.35818, 4.900585 52.357977, 4.898965 52.35761, 4.8972 52.357503, 4.895392 52.357593, 4.893593 52.35769, 4.891803 52.357817, 4.89078 52.357797, 4.890675 52.357413, 4.89069 52.356768, 4.890523 52.355927, 4.89038 52.354955, 4.89055 52.35415, 4.890093 52.353805, 4.888905 52.353643, 4.888865 52.35318, 4.889062 52.352692, 4.888857 52.352442, 4.8876 52.352307, 4.88628 52.352227, 4.885763 52.352267, 4.885738 52.352248, 4.885738 52.352248, 4.885693 52.352243, 4.88569 52.352245, 4.88494 52.352302, 4.88378 52.352452, 4.882657 52.352782, 4.882033 52.353063, 4.882027 52.35311, 4.882022 52.35312, 4.881998 52.353155, 4.881932 52.353245, 4.88154 52.353817, 4.88109 52.354497, 4.880738 52.354978, 4.880292 52.355552, 4.879683 52.356313, 4.879202 52.356995, 4.878687 52.357697, 4.878215 52.357978, 4.877818 52.35786, 4.876648 52.357565, 4.875062 52.35715, 4.873455 52.356705, 4.871928 52.356295, 4.870857 52.355967, 4.8695 52.355662, 4.868085 52.355175, 4.867338 52.354313, 4.86569 52.353893, 4.864145 52.353527, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307))' as linestring,
readWKTMultiLineString(linestring) as geom

Results

Desired Results

MultiPolygon

select 
'MULTIPOLYGON (((4.743518829345703 52.34341500154798, 4.743518829345703 52.38031475706198, 4.801883697509766 52.38031475706198, 4.801883697509766 52.34341500154798, 4.743518829345703 52.34341500154798)), ((4.933204650878906 52.33733197082112, 4.933204650878906 52.37706630007989, 5.001354217529298 52.37706630007989, 5.001354217529298 52.33733197082112, 4.933204650878906 52.33733197082112)))' as poly,
readWKTMultiPolygon(poly) as geom

Results

Desired Results

GeometryCollection

select
'GEOMETRYCOLLECTION (POINT (4.869689941406251 52.34771457014923), POLYGON ((4.743518829345703 52.34341500154798, 4.743518829345703 52.38031475706198, 4.801883697509766 52.38031475706198, 4.801883697509766 52.34341500154798, 4.743518829345703 52.34341500154798)), POLYGON ((4.933204650878906 52.33733197082112, 4.933204650878906 52.37706630007989, 5.001354217529298 52.37706630007989, 5.001354217529298 52.33733197082112, 4.933204650878906 52.33733197082112)), MULTILINESTRING ((4.8935 52.351688, 4.893413 52.351647, 4.893352 52.351638, 4.892842 52.351575, 4.892227 52.351492, 4.891533 52.351427, 4.891533 52.351427, 4.891508 52.351453, 4.891285 52.351633, 4.891298 52.352107, 4.891072 52.352617, 4.890502 52.35258, 4.890497 52.352578, 4.890112 52.352513, 4.889135 52.352398, 4.888088 52.35228, 4.886977 52.352205, 4.88585 52.352222, 4.88551 52.352233, 4.885452 52.352218, 4.885408 52.352222, 4.88537 52.3522, 4.885265 52.352213, 4.885188 52.35222, 4.884722 52.35227, 4.884625 52.352282, 4.88431 52.352313, 4.883388 52.352488, 4.88233 52.352825, 4.8821 52.352977, 4.882097 52.353002, 4.882097 52.353002, 4.882097 52.353002, 4.882067 52.353015, 4.882067 52.353015, 4.881962 52.353148, 4.881487 52.353863, 4.880873 52.35475, 4.88029 52.355518, 4.879682 52.356322, 4.879682 52.356322, 4.879682 52.356322, 4.87969 52.35635, 4.87969 52.35635, 4.87969 52.35635, 4.879572 52.356532, 4.879288 52.356933, 4.878985 52.357365, 4.878653 52.357828, 4.878422 52.358038, 4.878282 52.35801, 4.878273 52.357977, 4.878248 52.357945, 4.878217 52.357912, 4.877938 52.357878, 4.87749 52.357752, 4.876415 52.357475, 4.875277 52.357242, 4.874668 52.357172, 4.874552 52.357257, 4.874187 52.357703, 4.874183 52.35772, 4.874235 52.357678, 4.874235 52.357678, 4.874235 52.357678, 4.874235 52.357678), (4.878402 52.377643, 4.878402 52.377643, 4.878528 52.37771, 4.878827 52.378272, 4.879228 52.378642, 4.879697 52.379392, 4.880218 52.380228, 4.880692 52.380962, 4.881292 52.381905, 4.88198 52.382962, 4.88267 52.383963, 4.883102 52.3847, 4.883147 52.384733, 4.883745 52.38529, 4.884165 52.385363, 4.88418 52.385337, 4.88418 52.385337, 4.88418 52.385337, 4.88418 52.385337, 4.884338 52.385265, 4.885342 52.384728, 4.88625 52.384233, 4.886582 52.384073, 4.887273 52.38368, 4.888023 52.383252, 4.888938 52.382802, 4.888962 52.382792, 4.888983 52.382783, 4.889508 52.382572, 4.890442 52.382143, 4.891352 52.381733, 4.892382 52.381363, 4.893378 52.380992, 4.894658 52.38051, 4.895955 52.380518, 4.896042 52.381023, 4.89674 52.381427, 4.897208 52.381233, 4.897192 52.381245, 4.897192 52.381245, 4.897192 52.381245), (4.911212 52.365387, 4.911152 52.365397, 4.910947 52.36546, 4.910392 52.36504, 4.909322 52.364848, 4.90797 52.364613, 4.90688 52.36444, 4.906047 52.364222, 4.905167 52.36404, 4.904405 52.363878, 4.903112 52.363735, 4.902367 52.363588, 4.901692 52.363437, 4.901848 52.36306, 4.902037 52.362548, 4.901543 52.362337, 4.900423 52.362202, 4.899658 52.362053, 4.898845 52.36189, 4.898177 52.361787, 4.89811 52.361747, 4.897633 52.361645, 4.897047 52.36158, 4.896373 52.361482, 4.895802 52.361447, 4.894738 52.36159, 4.893598 52.36175, 4.892398 52.361915, 4.89153 52.362028, 4.891492 52.36203, 4.891332 52.362022, 4.890365 52.362135, 4.889107 52.362285, 4.888037 52.362467, 4.887552 52.362097, 4.887098 52.361528, 4.886803 52.361147, 4.88668 52.361012, 4.886228 52.360668, 4.88581 52.360645, 4.885687 52.360707, 4.884707 52.361172, 4.883657 52.361603, 4.882357 52.361638, 4.881542 52.361808, 4.881077 52.361988, 4.880238 52.362662, 4.879695 52.362943, 4.87923 52.363302, 4.878678 52.36357, 4.878123 52.363438, 4.8775 52.363273, 4.87632 52.362923, 4.875073 52.36259, 4.874328 52.362422, 4.874128 52.362367, 4.87396 52.362322, 4.873718 52.362252, 4.873285 52.362132, 4.872705 52.36196, 4.872287 52.361863, 4.872108 52.361827, 4.871557 52.361683, 4.87044 52.361408, 4.868808 52.360968, 4.867138 52.36057, 4.865333 52.360145, 4.865307 52.360138, 4.865268 52.36014, 4.865268 52.36014, 4.865253 52.360137, 4.864245 52.359942, 4.862572 52.35955, 4.860948 52.35915, 4.859842 52.358817, 4.859783 52.358785, 4.859783 52.358785, 4.859783 52.358785, 4.859783 52.358785, 4.859343 52.35869, 4.857842 52.358318, 4.857145 52.358103, 4.856587 52.357958, 4.854942 52.357768, 4.854942 52.357768, 4.854942 52.357768, 4.854923 52.357772, 4.854097 52.358013, 4.8536 52.35807, 4.8534 52.357943, 4.852562 52.357785, 4.852482 52.357297, 4.851997 52.357155, 4.851885 52.356737, 4.851802 52.356733, 4.851802 52.356733), (4.993018 52.359248, 4.993018 52.359248, 4.993025 52.35925, 4.993698 52.359635, 4.994442 52.36013, 4.995642 52.359673, 4.996693 52.35916, 4.99705 52.359075, 4.998197 52.358502, 4.999517 52.357805, 5.000905 52.357068, 5.00228 52.356343, 5.003665 52.355608, 5.00505 52.35488, 5.006205 52.354272, 5.007517 52.353552, 5.008785 52.3528, 5.008782 52.352775, 5.008305 52.35222, 5.007195 52.351703, 5.007672 52.351293, 5.008827 52.350722, 5.010053 52.350058, 5.011325 52.349388, 5.012503 52.348773, 5.013435 52.34899, 5.013998 52.348722, 5.014802 52.34781, 5.015645 52.3468, 5.016432 52.34582, 5.016938 52.344745, 5.0163 52.343507, 5.015678 52.342558, 5.014997 52.34151, 5.01406 52.340578, 5.012993 52.339693, 5.011735 52.338782, 5.010508 52.337892, 5.00931 52.337005, 5.008105 52.336147, 5.006835 52.335475, 5.005252 52.335375, 5.003405 52.335588, 5.001518 52.33547, 4.999812 52.335067, 4.998053 52.334877, 4.996313 52.3353, 4.994667 52.335873, 4.99308 52.336523, 4.991747 52.337348, 4.990602 52.338272, 4.989077 52.338978, 4.987573 52.339502, 4.987555 52.339515, 4.987422 52.339648, 4.986128 52.339397, 4.986015 52.338427, 4.98552 52.337798, 4.984715 52.337945, 4.983755 52.337307, 4.982402 52.33652, 4.980755 52.335973, 4.98021 52.335025, 4.98001 52.333993, 4.979947 52.33359, 4.978493 52.333817, 4.977162 52.334392, 4.976717 52.334433, 4.976032 52.334532, 4.974345 52.335018, 4.972623 52.335518, 4.97097 52.335998, 4.969892 52.336272, 4.968372 52.336743, 4.967307 52.337042, 4.966062 52.337392, 4.964248 52.33768, 4.962757 52.337935, 4.961535 52.338113, 4.960728 52.338275, 4.960567 52.338185, 4.96022 52.337507, 4.959753 52.33688, 4.95993 52.336533, 4.959088 52.33601, 4.958182 52.335335, 4.957598 52.33476, 4.956817 52.333998, 4.95608 52.333833, 4.955293 52.333077, 4.954922 52.332722, 4.954393 52.332235, 4.953753 52.33145, 4.954058 52.330812, 4.954578 52.330107, 4.955198 52.329683, 4.955202 52.329675, 4.955202 52.329675, 4.955202 52.329675), (4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359123, 4.793143 52.359005, 4.793163 52.358822, 4.793385 52.358397, 4.793683 52.357887, 4.794025 52.357307, 4.79464 52.357202, 4.795427 52.35736, 4.795837 52.357438, 4.795983 52.357463, 4.796632 52.357585, 4.797482 52.357762, 4.798567 52.357977, 4.799555 52.358178, 4.800333 52.358308, 4.800333 52.358308, 4.800333 52.358308, 4.800412 52.358317, 4.800957 52.358408, 4.801615 52.358543, 4.802622 52.358732, 4.803242 52.358833, 4.803512 52.358663, 4.803697 52.358418, 4.804047 52.357865, 4.804348 52.357612, 4.805057 52.357817, 4.805892 52.35799, 4.806732 52.358173, 4.80738 52.358307, 4.80785 52.358327, 4.808378 52.358222, 4.80856 52.357903, 4.808748 52.357612, 4.808935 52.357333, 4.809112 52.357043, 4.809198 52.356898, 4.80929 52.356702, 4.809572 52.356688, 4.810228 52.356833, 4.8112 52.357157, 4.812552 52.35739, 4.813865 52.357643, 4.814757 52.357813, 4.81554 52.357965, 4.816352 52.358135, 4.817232 52.357982, 4.818792 52.357897, 4.820183 52.357983, 4.821425 52.358175, 4.821442 52.358863, 4.822035 52.35915, 4.823363 52.359153, 4.824638 52.359185, 4.826048 52.359195, 4.82749 52.359235, 4.827927 52.359212, 4.828388 52.35923, 4.829288 52.359265, 4.830132 52.359293, 4.830887 52.359238, 4.831758 52.35926, 4.832773 52.359272, 4.83387 52.35931, 4.835052 52.359298, 4.83642 52.35932, 4.837885 52.359315, 4.83946 52.35933, 4.840818 52.359388, 4.842177 52.35932, 4.84334 52.359182, 4.844092 52.35835, 4.844117 52.358342, 4.844202 52.358342, 4.845255 52.358302, 4.846877 52.358227, 4.848628 52.358207, 4.849973 52.358177, 4.851393 52.358197, 4.852597 52.35849, 4.853628 52.358547, 4.85428 52.358155, 4.854312 52.358128, 4.854312 52.358128, 4.854312 52.358128, 4.854732 52.357972, 4.855708 52.35789, 4.856643 52.358135, 4.857928 52.358463, 4.859572 52.358905, 4.860518 52.359193, 4.861038 52.359292, 4.861828 52.359482, 4.861845 52.359485, 4.861863 52.359503, 4.86192 52.35953, 4.86192 52.35953, 4.86203 52.35956, 4.862402 52.35963, 4.862475 52.359645, 4.862475 52.359645, 4.862647 52.359692, 4.862963 52.359768, 4.86359 52.359917, 4.864465 52.360122, 4.865508 52.360385, 4.866935 52.360697, 4.86815 52.360953, 4.868222 52.360978, 4.869327 52.361277, 4.870707 52.36163, 4.871955 52.361965, 4.873425 52.362363, 4.874048 52.362555, 4.874388 52.362617, 4.87486 52.36272, 4.87553 52.362903, 4.876063 52.363045, 4.87622 52.36308, 4.876788 52.363205, 4.877243 52.363342, 4.87794 52.363543, 4.878718 52.36391, 4.878718 52.36391, 4.878718 52.36391, 4.878688 52.363935, 4.878637 52.364008, 4.878618 52.364037, 4.878573 52.364208, 4.878648 52.365008, 4.878207 52.365855, 4.878132 52.36621, 4.878143 52.366213, 4.878192 52.366235, 4.878192 52.366235, 4.878193 52.366235, 4.878717 52.366447, 4.879583 52.36661, 4.879965 52.365942, 4.880277 52.365422, 4.880425 52.36549, 4.880695 52.365595, 4.881255 52.365785, 4.88195 52.366023, 4.882512 52.366195, 4.883028 52.366282, 4.883723 52.365788, 4.884525 52.365245, 4.884967 52.365015, 4.885248 52.364802, 4.885477 52.364628, 4.885673 52.364507, 4.885985 52.364272, 4.886492 52.363827, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.88649 52.363842, 4.886497 52.363843), (4.87266 52.341542, 4.87266 52.341542, 4.87266 52.341542, 4.87266 52.341542, 4.872738 52.34156, 4.872738 52.34156, 4.872743 52.341548, 4.872828 52.341358, 4.872772 52.341123, 4.872602 52.341062, 4.872602 52.341062, 4.87241 52.340987, 4.871243 52.340958, 4.869778 52.34091, 4.868758 52.34086, 4.868758 52.34086, 4.868307 52.340863, 4.868065 52.341235, 4.867867 52.341497, 4.866777 52.341452, 4.865353 52.341403, 4.864647 52.341267, 4.863325 52.341185, 4.862022 52.341117, 4.860503 52.34102, 4.859275 52.340977, 4.858153 52.341037, 4.857222 52.341127, 4.857222 52.341127, 4.85719 52.34113, 4.856398 52.341205, 4.855327 52.341283, 4.854515 52.341303, 4.853623 52.34114, 4.852752 52.341083, 4.851708 52.340937, 4.850872 52.340832, 4.849815 52.340683, 4.848877 52.340502, 4.84773 52.340365, 4.847415 52.33995, 4.847367 52.339445, 4.84685 52.339418, 4.846182 52.33947, 4.846088 52.340093, 4.846183 52.340802, 4.84638 52.341402, 4.84602 52.341672, 4.846073 52.342183, 4.845657 52.342232, 4.844665 52.342178, 4.844658 52.342167, 4.844612 52.342193, 4.844603 52.342168, 4.844603 52.342168, 4.844603 52.342168, 4.844603 52.342168), (4.890497 52.344585, 4.890562 52.344583, 4.890562 52.344583, 4.890562 52.344583, 4.890618 52.344605, 4.890815 52.344953, 4.890942 52.345798, 4.890913 52.34653, 4.890875 52.346927, 4.889775 52.34701, 4.887985 52.347115, 4.886848 52.34746, 4.88684 52.34747, 4.887538 52.347488, 4.889105 52.347402, 4.89066 52.347375, 4.891372 52.347357, 4.891397 52.347358, 4.891397 52.347358, 4.891438 52.347362, 4.891438 52.347362, 4.891438 52.347362, 4.891438 52.347362, 4.891495 52.34737, 4.89156 52.347372, 4.89167 52.347363, 4.892033 52.347305, 4.892775 52.34722, 4.894412 52.347127, 4.895448 52.347083, 4.895477 52.34708, 4.896222 52.347013, 4.898102 52.346948, 4.899922 52.346867, 4.901665 52.346772, 4.903038 52.3466, 4.90408 52.346325, 4.905042 52.346423, 4.90597 52.346532, 4.907097 52.346607, 4.908353 52.346775, 4.909553 52.346938, 4.910815 52.347133, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.912225 52.347315, 4.91249 52.347347, 4.913557 52.347443, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913847 52.34725, 4.913855 52.347227, 4.913855 52.347227, 4.913855 52.347227, 4.913855 52.347223, 4.914072 52.346807, 4.914458 52.346142, 4.915062 52.345757, 4.916123 52.345178, 4.917018 52.344585, 4.917877 52.344022, 4.918277 52.343297, 4.918697 52.342533, 4.919125 52.341703, 4.919593 52.340762, 4.920188 52.33986, 4.920765 52.339103, 4.92134 52.338395, 4.920753 52.338082, 4.920753 52.338082, 4.920753 52.338082, 4.920753 52.338082, 4.920765 52.338087, 4.920795 52.338105, 4.920795 52.338105, 4.920828 52.338137, 4.920828 52.338137, 4.920947 52.33828, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248, 4.92091 52.338248), (4.896565 52.347072, 4.896565 52.347072, 4.89661 52.34706, 4.896653 52.34706, 4.897307 52.346992, 4.898772 52.346928, 4.90033 52.346847, 4.901993 52.346737, 4.903388 52.346425, 4.904052 52.346223, 4.905062 52.346378, 4.905773 52.346472, 4.905773 52.346472, 4.905773 52.346472, 4.905773 52.346472, 4.905777 52.346472, 4.90637 52.346538, 4.907793 52.346703, 4.908543 52.346798, 4.909432 52.346923, 4.911027 52.347165, 4.91206 52.347292, 4.912403 52.347347, 4.913352 52.347488, 4.913442 52.3478, 4.913182 52.348355, 4.913145 52.34874, 4.913597 52.349065, 4.914453 52.349417, 4.915082 52.349333, 4.915807 52.34945, 4.916548 52.349825, 4.916842 52.349967, 4.916842 52.349967, 4.916842 52.349967, 4.916852 52.349978, 4.916658 52.350143, 4.916715 52.350372, 4.917298 52.350643, 4.917058 52.350933, 4.916665 52.351185, 4.916592 52.351215, 4.916687 52.351218, 4.916687 52.351218), (4.945237 52.351265, 4.945237 52.351265, 4.945237 52.351265, 4.94531 52.351323, 4.945398 52.351348, 4.945753 52.351537, 4.9459 52.351838, 4.945382 52.352185, 4.944607 52.35269, 4.94378 52.353188, 4.943073 52.353632, 4.942352 52.354122, 4.941633 52.354553, 4.940945 52.35487, 4.940162 52.35536, 4.939537 52.355753, 4.939147 52.356002, 4.938505 52.356338, 4.937435 52.356793, 4.936668 52.357085, 4.936668 52.357085, 4.936513 52.357168, 4.935605 52.357017, 4.934353 52.356758, 4.9333 52.35657, 4.933003 52.356878, 4.932187 52.35671, 4.931227 52.356515, 4.93087 52.356455, 4.930748 52.356428, 4.93045 52.356705, 4.930607 52.356772, 4.930607 52.356772), (4.911508 52.36197, 4.911458 52.361965, 4.911382 52.36183, 4.910475 52.361503, 4.909327 52.361313, 4.90831 52.361078, 4.908677 52.360445, 4.908405 52.359977, 4.908347 52.359972, 4.908347 52.359972, 4.908347 52.359972, 4.908347 52.359972, 4.907738 52.359723, 4.906388 52.35915, 4.904723 52.358788, 4.903385 52.358627, 4.903385 52.358627, 4.903385 52.358627, 4.903342 52.358613, 4.903342 52.358613, 4.90329 52.358593, 4.902595 52.35846, 4.90144 52.35818, 4.900585 52.357977, 4.898965 52.35761, 4.8972 52.357503, 4.895392 52.357593, 4.893593 52.35769, 4.891803 52.357817, 4.89078 52.357797, 4.890675 52.357413, 4.89069 52.356768, 4.890523 52.355927, 4.89038 52.354955, 4.89055 52.35415, 4.890093 52.353805, 4.888905 52.353643, 4.888865 52.35318, 4.889062 52.352692, 4.888857 52.352442, 4.8876 52.352307, 4.88628 52.352227, 4.885763 52.352267, 4.885738 52.352248, 4.885738 52.352248, 4.885693 52.352243, 4.88569 52.352245, 4.88494 52.352302, 4.88378 52.352452, 4.882657 52.352782, 4.882033 52.353063, 4.882027 52.35311, 4.882022 52.35312, 4.881998 52.353155, 4.881932 52.353245, 4.88154 52.353817, 4.88109 52.354497, 4.880738 52.354978, 4.880292 52.355552, 4.879683 52.356313, 4.879202 52.356995, 4.878687 52.357697, 4.878215 52.357978, 4.877818 52.35786, 4.876648 52.357565, 4.875062 52.35715, 4.873455 52.356705, 4.871928 52.356295, 4.870857 52.355967, 4.8695 52.355662, 4.868085 52.355175, 4.867338 52.354313, 4.86569 52.353893, 4.864145 52.353527, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307, 4.863752 52.353307)))'

NOTE: seems geometrycollection is not supported

@duvenagep

Thank you @duvenagep so much for the dataset!
I will continue working on the issue and it should be in 0.9.3 by end of September.

ClickHouse doesn't support GeometryCollection, MultiPoint. Here is link for supported types https://clickhouse.com/docs/sql-reference/data-types/geo

There is a Ring what may be a MultiPoint.

Navigation Menu

Repository navigation

[JDBC-V2] Spatial data returned as double[] #2577

Description

Point

Linestring

Polygon

MultiPoint

MultiLineString

MultiPolygon

GeometryCollection

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[JDBC-V2] Spatial data returned as double[] #2577

Description

Description

Activity

chernser commented on Sep 10, 2025

duvenagep commented on Sep 11, 2025

chernser commented on Sep 11, 2025

duvenagep commented on Sep 17, 2025

Point

Linestring

Polygon

MultiPoint

MultiLineString

MultiPolygon

GeometryCollection

chernser commented on Sep 17, 2025

chernser commented on Sep 22, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions