How would PostGIS and MySQL Spatial store the Equator?
Point
0% (0 votes)
Line
50% (2 votes)
Polygon
25% (1 vote)
Surface
25% (1 vote)
Ray
0% (0 votes)
Total votes: 4
Groups:
Login to post comments

Poll Reasoning
Let's say for the sake of this poll - You are storing the Equator to determine if a point is on the equator or in the Northern Hemisphere or Southern Hemisphere.
equator = x axis
Well, you should never need to store the equator. The equator is the X-axis of our latitude/longitude system, so whenever you talk about latitudes, you're already talking about where something is in relation to the equator. To tell whether a point is in the northern or southern hemisphere, you can just look at the latitude: positive or followed by an 'N' means a point is in the northern hemisphere; negative or followed by an 'S' means southern hemisphere.
You could store the "northern hemisphere" and "southern hemisphere" as polygons, but it's less efficient and enough of a special case that you might as well just look specifically at points' latitudes.
Aaand that's it for this little geography lesson... :)