Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Postgres geography type is not limited to Earth.
For example, in Korea a bunch of mapping providers use "UTM-K", which is some custom UTM projection
(defined such that coordinate [1_000_000, 2_000_000] is some point in the mountains in the north of South Korea (38.0, 127.5 lat/lon))
Just search UTM-K on spatialreference, http://spatialreference.org/ref/sr-org/7308/
And you get the magic postgis incantation http://spatialreference.org/ref/sr-org/7308/postgis/
Then just set the srid and everything should work nicely.
There are no comments on this comment yet.
For example, in Korea a bunch of mapping providers use "UTM-K", which is some custom UTM projection
(defined such that coordinate [1_000_000, 2_000_000] is some point in the mountains in the north of South Korea (38.0, 127.5 lat/lon))
Just search UTM-K on spatialreference, http://spatialreference.org/ref/sr-org/7308/
And you get the magic postgis incantation http://spatialreference.org/ref/sr-org/7308/postgis/
Then just set the srid and everything should work nicely.