Tag Info

New answers tagged


If you load Natural Earth data into PostGIS, you can extract the extents of each province with a query: WITH provinces AS (SELECT name, ST_Envelope(geom) AS geom FROM ne_10m_admin_1_states_provinces WHERE admin = 'Canada') SELECT name, ST_XMin(geom) AS xmin, ST_YMin(geom) AS ymin, ST_XMax(geom) AS xmax, ST_YMax(geom) AS ymax FROM provinces; ...

Top 50 recent answers are included