Problem in Storing Satellite imagey(Geotiff file)

On 10/1/21 9:25 AM, Vijay Garg wrote:

Dear Sir/madam,

I am using PostgreSQL to store the Satellite imagery(Geotiff file). I
have uploaded the satellite image using raster2pgsql but it's not stored
in table format. I want to show a layer on Geoserver so that I could
send SQL/CQL queries on it.

Waiting for your reply.

Upon receipt of complete information:

1) Postgres version?

2) PostGIS version?

3) Text of query used?

4) Table definition?

5) Where is being stored?

6) If failure what is error message?

--
*Thanks & Regards*
Vijay Garg
Contact Number: 6283101848
Sabudh Foundation
New Delhi

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi Adrian,

I am using postgres 13.4 version & postgis 3.1 version. I have used the
following command to upload the data.

raster2pgsql -I -C -s 4326 C:\Users\Admin\Desktop\dem.tif raster.dem |
psql -U postgres -d India -h localhost -p 5432

I am able to upload dem file in postgres but I am not able to check any
table.

I am attaching the screenshot in this email.

[image: image.png]

--
*Thanks & Regards*
Vijay Garg
Contact Number: 6283101848
Sabudh Foundation
New Delhi

On Sun, Oct 3, 2021 at 2:18 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 10/1/21 9:25 AM, Vijay Garg wrote:

Dear Sir/madam,

I am using PostgreSQL to store the Satellite imagery(Geotiff file). I
have uploaded the satellite image using raster2pgsql but it's not stored
in table format. I want to show a layer on Geoserver so that I could
send SQL/CQL queries on it.

Waiting for your reply.

Upon receipt of complete information:

1) Postgres version?

2) PostGIS version?

3) Text of query used?

4) Table definition?

5) Where is being stored?

6) If failure what is error message?

--
*Thanks & Regards*
Vijay Garg
Contact Number: 6283101848
Sabudh Foundation
New Delhi

--
Adrian Klaver
adrian.klaver@aklaver.com

--
*Thanks & Regards*
Vijay Garg
Contact Number: 6283101848
Sabudh Foundation
New Delhi

On 10/4/21 2:19 AM, Vijay Garg wrote:

Hi Adrian,

I am using postgres 13.4 version & postgis 3.1 version. I have used the
following command to upload the data.

raster2pgsql -I -C -s 4326  C:\Users\Admin\Desktop\dem.tif raster.dem |
psql -U postgres -d India -h localhost -p 5432

I am able to upload dem file in postgres but I am not able to check any
table.

The image shows that you can check(select from) the table. What you are
seeing is the image data stored in a binary format. You will not see the
actual image. To get that see this section of PostGIS docs:

https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Applications

I am attaching the screenshot in this email.

image.png

--
*Thanks & Regards*
Vijay Garg
Contact Number: 6283101848
Sabudh Foundation
New Delhi

On Sun, Oct 3, 2021 at 2:18 AM Adrian Klaver <adrian.klaver@aklaver.com

--
Adrian Klaver
adrian.klaver@aklaver.com