I'm asking for help understanding why my sample data doesn't work in the spatial join as a group, but works one row at a time. See the code below for sample data and at the very bottom, the examples ...

I have a performance issue with a query in MySQL. I need to compare location data and am trying to use ST_CONTAINS in a join. However, I am having a performance issue as it is quite slow, taking ...

The spatial function ST_Transform returns weird results in MySQL. I tested the following query and compared with PostGIS and obtained very different results: The query (exactly the same used in MySQL ...

Here I have two shapefiles one containing reference points and second one is a multiline string containing broken line segments split across 3-4 lanes as shown. I need to connect them lane wise with ...

This is the following query : SELECT id, x, date_range_start FROM table_a WHERE ST_DWITHIN(point, shape_polygon, 30) After running some tests, i can confidently say that WHERE ST_DWITHIN(...

Like mentioned in the pic below: I’m generating perpendicular lines across a centerline (reference_line) in PostGIS. The goal is to create cross-sections using offset curves 20 meters left and right ...

I have been doing a spatial analysis. I have two regions, A and B, and I want to determine whether the roads crossing from A to B maintain the same classification or if the classification changes.I ...

I'm using neo4j library in python I want to check if a point is within a polygon (which will in our case will be state border) I have check all the neo4j documentation but couldn't find any resource ...

`I am working on a project that requires handling geospatial data, including coordinates (latitude and longitude) and performing spatial queries like proximity searches. I would like to store and ...

I'm dealing with a production level project that has SPATIAL queries for a large table [over 15 million rows] We are using MariaDB 10.10.6, along with springboot 2.7.18 I've added the extra ...

The st_read() command from the sf package in R can take SQL queries (see example here) when reading in shapefiles, but I'd like to be able to include a subquery. For example, there's a shapefile here ...

hey i would like to get some help, i use hibernate 6.5, i followed the documentions and everything, and use jts to add geometeric point to my entity in my project : @Entity @Table(name = "...

When importing spaces in polygon format from one DB to another something doesn't preserve. It is not possible to run ST_Intersects successfully on the imported data even though MySQL knows what SRID ...

So, I am using oracle to first find the intersections that exist between two geometries, and I have hit a snag where I think this may be an actual oracle error. It has overall been working well, ...

I'm trying to insert some polygons using MDSYS.SDO_GEOMETRY, but I'm getting the error "too many arguments for function", I did a simple test, because I suspected there was a limit of ...