The sql below is intended to create a point from a know X,Y. It should then buffer the point with a known distance. Last, the sql should intersect the buffer with an underlying polygon layer and return the name field from the polygon the buffer intersects. Seems straightforward.
SELECT nameFROM polygons t1WHERE sde.st_intersects (sde.st_buffer(sde.st_point(x, y), buffer), t1.SHAPE) = 1When I run the sql, I get the following:
Error at line 3ORA-20003: Geometry type "" is not a valid shape type.ORA-06512: at "SDE.ST_GEOM_UTIL", line 275ORA-06512: at "SDE.ST_POINT", line 21What am I doing wrong and how do I fix it? The X,Y I'm using are definitely in the correct area so buffering and finding an intersection should not be a problem.
I'm using st_geometry on Oracle from Arc 10.1
أكثر...
SELECT nameFROM polygons t1WHERE sde.st_intersects (sde.st_buffer(sde.st_point(x, y), buffer), t1.SHAPE) = 1When I run the sql, I get the following:
Error at line 3ORA-20003: Geometry type "" is not a valid shape type.ORA-06512: at "SDE.ST_GEOM_UTIL", line 275ORA-06512: at "SDE.ST_POINT", line 21What am I doing wrong and how do I fix it? The X,Y I'm using are definitely in the correct area so buffering and finding an intersection should not be a problem.
I'm using st_geometry on Oracle from Arc 10.1
أكثر...