I am trying to create a spatial view in ArcMap where I run a ST_Intersect against a ST_Geometry point dataset and a PostgreSQL geometry polygon dataset. Both datasets are the same SRID. I am having an issue converting the PostgreSQL geometry to ST_Geometry. I haven't ever done anything like this before. Where I am going wrong?
Below is the query I have been working with. I am receiving an error on line 6 stating "function sde.st_geometry(geometry, integer) is not unique at [b.shape]"
SELECT a.objectid, a.shape, b.objectid AS oid FROM cd.points a, sw.risk_polygons b WHERE sde.st_intersects(a.shape, sde.st_geometry(b.shape, 4326)) = 1 ORDER BY a.objectid;