I have a table with point features saved in the my PostgreSQL database, and I can run the following query to get the extent of the point features and I turned the extent back into a geometry:
SELECT ST_AsText(ST_SetSRID(ST_Extent(pts.geom), 4026)) AS Extent_Geom FROM Table_w_Point_Features pts
Here is how the output geometry of a rectangle polygon that represents the extent of the point features looks like:
POLYGON((-117.536012078 33.7130048820001, -117.536012078 34.3860049530001, -116.825011941 34.3860049530001, -116.825011941 33.7130048820001, -117.536012078 33.7130048820001))
And here is my question: Is there any way in PostGIS that I can get the Width and Height of the extent that I created above?
Thanks a lot!