spatial Archives

MSSQL Geography STIntersects returns 1 when 0 is expected

By adminPosted on March 21, 2023

Question : I’m experiencing an MSSQL Geography issue I can’t explain. Assume that I’m math-challenged, but it seems like the […]

By adminPosted on March 16, 2023

Question : Table T_PIN has 300,000 pins and T_POLYGON has 36,000 polygons. T_PIN has this index: CREATE SPATIAL INDEX [T_PIN_COORD] […]

By adminPosted on March 10, 2023

Question : We have over 2 million poi data in our mysql db. At any time we need to find […]

By adminPosted on March 9, 2023

Question : I am considering whether I should add columns to my existing tables or use a new table. The […]

By adminPosted on March 9, 2023

Question : I have this trigger: DELIMITER $$ CREATE TRIGGER geometrytrigger BEFORE INSERT ON users FOR EACH ROW BEGIN SET […]

By adminPosted on March 7, 2023

Question : I have a table Event that has 30 million rows and a table Location that has 35 million […]

By adminPosted on March 6, 2023

Question : I have some normalized tables with about 1,2M records that I collect in a view in a SQL […]

By adminPosted on February 26, 2023

Question : I have a large Postgres table contain geographic positions (latitude and longitude) both fields are indexed, and both […]

By adminPosted on February 20, 2023

Question : I have an issue where whatever I do I cannot get MySQL to use a spatial index. A […]

By adminPosted on February 12, 2023

Question : I have a table (around 60-80 million rows) in a postgresql database, that identifies census tracts that the […]