基于Landsat与PostGIS按地理位置检索栅格数据的疑问咨询

Hey there! I’ve dealt with this exact confusion a lot when working with Landsat data and QGIS—let’s clear this up quickly.

Why are you seeing six-figure coordinate values? #

Those large numbers (100k+ range) are a dead giveaway that QGIS is using a projected coordinate system (PCS) instead of the geographic coordinate system (GCS, i.e., latitude/longitude) you’re probably expecting.

• Geographic coordinates (like WGS84, EPSG:4326) use degrees, so values stay between -180 to 180 (longitude) and -90 to 90 (latitude).
• Projected systems (like UTM, which is super common for Landsat) flatten the spherical Earth into a 2D plane, using units like meters. For UTM, easting values (horizontal) typically fall between 100,000 and 900,000 meters, northing values (vertical) can go up to 10,000,000 meters in the Northern Hemisphere—hence those big numbers.

Step-by-step fix to get back to latitude/longitude display #

1. Check your current QGIS canvas CRS
   Look at the bottom-right corner of your QGIS window—you’ll see an icon (looks like a globe with grid lines) followed by the current CRS code/name. Click that icon to open the CRS selector.

2. Switch to a geographic coordinate system
   In the CRS selector, search for WGS 84 or EPSG:4326 (the standard global latitude/longitude system). Select it, and QGIS will instantly reproject your canvas to display coordinates in degrees.

   Important note: This only changes how coordinates are displayed on the canvas—your Landsat raster in PostGIS stays in its original projection. QGIS handles dynamic on-the-fly projection automatically.

3. Verify your PostGIS raster’s native CRS
   To confirm what projection your raster is stored in, run this SQL query against your PostGIS table:

   SELECT ST_SRID(rast) FROM your_landsat_raster_table LIMIT 1;
   

   Look up the EPSG code (e.g., 32610 = UTM Zone 10N) to confirm it’s a projected system—this explains why QGIS defaulted to large coordinate values when you loaded the layer.

Quick tip for future projects #

When loading layers into QGIS, you can set your preferred default canvas CRS (like EPSG:4326) in Settings > Options > CRS—this way, QGIS will always start with latitude/longitude unless you specify otherwise.

内容的提问来源于stack exchange，提问作者Evan McCoy