BostonGIS company blog

Postgres geography type is not limited to Earth

bostongis.com 2 min read

It's a little known fact that the PostGIS geography type since PostGIS 2.2 (well was introduced in 2.1 I think but had a bug in it until 2.1.4 or so), supports any spheroidal spatial reference system that measures in degrees. When an srid is not specified, it defaults to using 4326, Earth WGS 84 long lat.

Points

154

HN comments

35

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2017

Related posts from the same era

Apple open-sources FoundationDB

FFoundationDB Blog20182,136 points441 comments details

RethinkDB is shutting down

RethinkDB Blog20161,674 points441 commentscited by 9 details

Announcing SQL Server on Linux

Microsoft Blog20161,344 points476 commentscited by 5 details

Why we lost Uber as a user

PostgreSQL20161,234 points285 comments details

Congress votes to make open government data the default in the United States

E Pluribus Unum20181,130 points154 comments details

Introducing Cloud Spanner, a Global Database Service

Google Cloud Blog20171,068 points434 comments details