How to handle , Error parsing WKT: Invalid coordinate value '180' found at position
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2025 06:26 AM
DBR Version- 16.2
spark.databricks.geo.st.enabled true
SQL Query I am running:
%sql
WITH points (
SELECT st_astext(st_point(30D, 10D)) AS point_geom
UNION SELECT st_astext(st_point(10D, 90D)) AS point_geom
UNION SELECT st_astext(st_point(40D, 40D)) AS point_geom)
SELECT st_geoglength(st_astext(st_makeline(collect_list(st_geomfromtext(point_geom)))))
FROM points
Full Error :
[WKT_PARSE_ERROR] Error parsing WKT: Invalid coordinate value '90' found at position 21 SQLSTATE: 22023
How to handle this error, how can I make this geometry compatible with databricks' st_* functions?
Note: st_isvalid is true for above geometry
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 02:25 AM
Also ,other geospatial libraries like apache sedona, supports these geometries.

