StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>There are a lot of systems to map the earth. For example you want to map some state in USA. You can set the most south-east point as 0,0 and map all other spatial coordinates according to this point. On the other hand you may want to map some spatial data that span all over the map. In any case you must choose some point as 0,0. In addition you must select some sort of measurement unit: miles/kilometers/degrees/some other magical unit that suits you better. Over the years a lot of such systems where developed. Each has its own zero point, its own coordinates, its own rules about if the earth is flat or not. SRID or SRS is the id of such system. Using this id you can map point expressed in one system to another system, although sometimes it involves some pretty complex math.</p> <p>And about 4326 SRID. It also called "WGS 84" (<a href="http://en.wikipedia.org/wiki/World_Geodetic_System" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/World_Geodetic_System</a>) system. It's the most common system to represent point on spherical(not flat) earth. It uses degree,minute,second notation and its x and y coordinates are usually called latitude and longitude. </p> <p>Most used non-spherical earth projection is called UTM. You can read about it here: <a href="http://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system</a></p> <p>Anyway, as long you are not doing any spatial conversions from one system to other, you don't really care about the system that you data uses. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload