SQL error: Unrecognized geometry type 13—PolyhedralSurface encountered

Data and Databases
1

Encountering a 3D spatial mismatch error when retrieving a mine’s foreign key via geometry intersection. For instance:

INSERT INTO project_z.areas_data (area_title, mine_key, output, geo)
VALUES (
  'Zone Z1',
  (SELECT id_val FROM project_z.mines_data WHERE geometry_overlap(geo, geo_from_text('POLYGON((10 10,20 10,20 20,10 20,10 10))', 4326))),
  350.0,
  geo_from_text('POLYGON((10 10,20 10,20 20,10 20,10 10))', 4326)
);

How can this issue be resolved?

2

hey, try to cast the 3d geo to 2d using st_force2d. that fixed the error on my side by matching expected types