Reputation
3,057
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 19 39
Impact
~159k people reached

Jan
4
awarded  Notable Question
Oct
20
awarded  Famous Question
Oct
15
awarded  Nice Question
Oct
3
awarded  Notable Question
Sep
24
awarded  Popular Question
Aug
3
comment Full list of ISO ALPHA-2 and ISO ALPHA-3 country codes
@DirkvanBergen That's a nice move, but their table is far from being nicely formatted. 10-page pagination, no CSV link.
Jul
31
awarded  Yearling
Jul
17
revised Why is ST_Distance_Sphere using WGS 80?
edited title
Jul
16
comment Why is ST_Distance_Sphere using WGS 80?
Thanks. A silly mistake on my part!
Jul
16
accepted Why is ST_Distance_Sphere using WGS 80?
Jul
16
asked Why is ST_Distance_Sphere using WGS 80?
Jul
8
awarded  Popular Question
Jun
2
comment Auto-Sanitizing illegal PostGIS WGS84 (lat, lon) coordinates
@Vince Would you like to write that last comment, distinguishing GEOGRAPHY and GEOMETRY as an answer?
May
31
revised Auto-Sanitizing illegal PostGIS WGS84 (lat, lon) coordinates
edited title
May
31
comment Auto-Sanitizing illegal PostGIS WGS84 (lat, lon) coordinates
@Vince The same way I expect floats and integers to be, well, floats and integers, I expect WGS84 Coordinates to be WGS84 Coordinates. Allowing latitude of 117 is the same as allowing division by zero because it saves validation time.
May
31
comment Auto-Sanitizing illegal PostGIS WGS84 (lat, lon) coordinates
@Vince thanks. I do know how to validate my input, but I thought that PostgreSQL might have a configuration flag that would reject illegal output for me. It is worth mentioning that I only discovered one flaw, and there might be quite a few more.
May
31
asked Auto-Sanitizing illegal PostGIS WGS84 (lat, lon) coordinates
May
29
awarded  Popular Question
May
18
comment What's the difference between vincenty and great circle distance calculations?
@MartinF Sure, added. Is that wha you meant?
May
18
revised What's the difference between vincenty and great circle distance calculations?
added 87 characters in body