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

  • 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
  • My Python Toolbox, 2024 Edition

Categories

  • Games
  • IT
  • Uncategorized

Tags

Amazon EC2 Anti-Patron Apache AWS benchmarks boto3 boto3-stubs Chrome Courriel DevLog DivX docker Documentation Extension GIS Github IT JavaScript Jest JSON Lightsail Marteau Doré MongoDb monkeypatch moto mypy mysql NoSQL PHP poetry postgis pydantic pytest Python Recyclage serverless shapely SIG sqlalchemy StarCluster Système de surveillance Télétravail Vocabulaire Windows WordPress
keyboard_arrow_up
Theme: Noto Simple