I'm trying to write a query to find if any features in a layer intersect with a certain polygon, but it is always returning 0 rows. I've tried messing with SRIDs, different geom types, sizes, shapes, etc. and have never had it return a single result, making me think there is just a basic misunderstanding I'm having.
The geometry data in the database is stored under the "geometry" column in the WKT format with the 3857 SRID. All I want to is to get returned all the rows whose geometry touches the polygon at all.
The query I wrote looks like this:
SELECT * FROM tableOfFeatures WHERE ST_Intersects(ST_GeomFromText('SRID=3857;POLYGON((-118.09636448889168 83.80774305261292, -103.722647355961 -83.72028886793554, -13.87670908426287 -83.7764092545634, -38.85866039455652 84.01409674357751, -118.09636448889168 83.80774305261292))'), geometry);
Am I missing some kind of conversion or cast?