8월 2026 PostGIS 시장 점유율 분석

Firstly, it’s not! But a frequent question we get is of the form, “the geography intersects test is saying this point is side this box, when clearly it is not, why?” Here’s the example: WITH wkt AS ( SELECT 'POLYGON((0 0, 80 0, 80 10, 0 10, 0 0))' AS box, 'POINT(40 10.1)' AS pt ) SELECT ST_Intersects(wkt.box::geography, wkt.pt::geography) AS intersects_geog, ST_Intersects(wkt.box::geometry, wkt.pt::geometry) AS intersects_geom FROM wkt; Same box, same point, but different answers depending on if you evaluate as geometry, or geography.