Timeline for ST_Within is only working on selective rows
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 10, 2022 at 13:58 | vote | accept | Learner120 | ||
| Apr 7, 2022 at 6:50 | history | edited | Learner120 | CC BY-SA 4.0 |
added 6 characters in body
|
| Apr 6, 2022 at 17:31 | answer | added | Lee Hachadoorian | timeline score: 4 | |
| Apr 6, 2022 at 16:33 | history | edited | Lee Hachadoorian | CC BY-SA 4.0 |
Removed python wrapper around SQL statement as question is only about spatial SQL; Changed table names in text to correspond to code.
|
| Apr 6, 2022 at 16:02 | history | edited | Learner120 | CC BY-SA 4.0 |
added 30 characters in body
|
| Apr 6, 2022 at 15:59 | comment | added | Learner120 |
@MerseyViking so I used a system of 4326 to construct the geometries (i.e. ALTER TABLE `Table2` ADD COLUMN `geom` Geometry; UPDATE `Table2` SET geom = ST_GeomFromText(coordinates, 4326)) But for the POINT generation, I didn't use a projection (i.e. POINT(table1.`longitude`, table1.`latitude`)). Are you saying I should add 4326 into my Point Generation too?
|
|
| Apr 6, 2022 at 15:24 | comment | added | MerseyViking | What projection/coordinate system is your geom column in? Make sure that you are transforming your point geometry to the same coordinate system. | |
| Apr 6, 2022 at 14:52 | history | edited | Matt | CC BY-SA 4.0 |
added python syntax highlighting to code
|
| Apr 6, 2022 at 14:24 | history | edited | Learner120 | CC BY-SA 4.0 |
Added a way to create a minimum re-creatable example
|
| Apr 6, 2022 at 13:45 | comment | added | Learner120 | @IanTurton it actually isn't on the border, it's slightly inside the border when I do try to zoom in, I will update the question to have both the lat and long and also the Polygon | |
| Apr 6, 2022 at 9:02 | comment | added | Ian Turton | On the border is not within | |
| Apr 6, 2022 at 1:12 | history | edited | Learner120 | CC BY-SA 4.0 |
edited body
|
| Apr 6, 2022 at 1:11 | comment | added | Learner120 |
@Mapperz that's correct but I have two type of geometries in my ST_WITHIN function: (i) POINT(table1.`longitude`, table1.`latitude`) converts it to a geom type object, and (ii) the Polygon object (stored in my table2)
|
|
| Apr 6, 2022 at 1:08 | comment | added | Mapperz♦ | You will need to have geometry in both tables to be able to use ST_WITHIN mariadb.com/kb/en/st-within ST_WITHIN(g1,g2) >Returns 1 or 0 to indicate whether geometry g1 is spatially within geometry g2. | |
| S Apr 6, 2022 at 0:42 | review | First questions | |||
| Apr 6, 2022 at 1:32 | |||||
| S Apr 6, 2022 at 0:42 | history | asked | Learner120 | CC BY-SA 4.0 |