Geography Reference
In-Depth Information
Or we can find the geographic center point of the county in the same coordinates as the
actual geometry.
SELECT name2,AsText(ST_Centroid(the_geom)) FROM ukcountys WHERE name2 = 'Durham'
Figure 61: Geographic Center of County Durham
Or we can output a summary of what the object is.
SELECT name2,ST_Summary(the_geom) FROM ukcountys WHERE name2 = 'Durham'
Figure 62: Summary of County Durham Object
We can also break down the underlying geometry. There are functions to dump entire sets of
points that make up a boundary.
SELECT name2,ST_DumpPoints(the_geom) FROM ukcountys WHERE name2 = 'Durham' LIMIT 5
Figure 63: County Durham Boundary Points
