Skip to content

Frank-Mich's Blog

  • About

Tag: postgis

bookmark_borderIt’s a Trap! Postgis Geometry with SRID 4326 is not a Geography

Posted on 2024/04/302024/04/30 by Frank-Mich L'Heureux

Long story short, you create a table with a geometry column that stores points with srid 4326 (read geographic lat/lng, or should I write lng/lat, coordinates). That should be interpreted as geography right? Not at all!

Continue reading “It’s a Trap! Postgis Geometry with SRID 4326 is not a Geography”
Posted in ITTagged IT, postgis, Python, sqlalchemyLeave a Comment on It’s a Trap! Postgis Geometry with SRID 4326 is not a Geography

Recent Posts

  • Postgres – Array Index Equivalence Miss
  • True sqlalchemy unit testing
  • Measuring Sentry Impact on AWS Lambda Cold Start and Time to Handler
  • It’s a Trap! Postgis Geometry with SRID 4326 is not a Geography
  • Hybrid Pydantic/FastAPI Model

Categories

  • Games
  • IT
  • Uncategorized

Tags

Amazon EC2 Apache AWS benchmarks bière boto3 boto3-stubs Chrome CI/CD CircleCI DevLog docker Extension fastapi GIS Github gpg IT JavaScript Jest lambda Lightsail MongoDb monkeypatch moto mypy mysql NoSQL PHP piège poetry postgis postgres pydantic pytest Python Selenium serverless shapely SIG sqlalchemy StarCluster Télétravail WordPress YAPF
keyboard_arrow_up
Theme: Noto Simple