I am running PostgreSQL 9.4 and PostGIS 2.1 and have loaded a small piece USGS SRTM data for North America successfully into my database. I am attempting to export a small piece of of the rasters I have loaded using this CLI command:
gdal_translate -of GTiff PG:"host='localhost' port='5433' dbname='srtm' user='my_usr' password='****' schema='stg' table='minneapolis' where='ST_Intersects(rast, ST_MakeEnvelope(44.78,-93.42,45.18,-93.071,4326))'mode=2" /home/my_usr/gis/data/test/downtown.tifI am following the example given in PostGIS in Action 2nd Edition (p. 109 if you have the book) but using my own options. When I use this command I am met by the following error:
Warning 1: Cannot find information about stg.minneapolis table inraster_columns view. The raster table loading would take a lot of time. Please, execute AddRasterConstraints PostGIS function to registerthis table as raster table in raster_columns view. This will save loading time.ERROR 1: Error browsing database for PostGIS Raster propertiesGDALOpen failed - 1Error browsing database for PostGIS Raster propertiesHowever, when I examine the raster_columns view, the output shows the table:
srtm=# SELECT r_table_schema, r_table_name, srid FROM raster_columns; r_table_schema | r_table_name | srid ----------------+--------------+------stg | na | 4326stg | minneapolis | 4326Any ideas? I'm completely stumped. I'm rather new to PostGIS and PostgreSQL, but am in love with GIS and looking to learn them to use as a backend for cloud-based GIS. I need to get this figured out for my master's research - your expertise is much appreciated!
أكثر...
gdal_translate -of GTiff PG:"host='localhost' port='5433' dbname='srtm' user='my_usr' password='****' schema='stg' table='minneapolis' where='ST_Intersects(rast, ST_MakeEnvelope(44.78,-93.42,45.18,-93.071,4326))'mode=2" /home/my_usr/gis/data/test/downtown.tifI am following the example given in PostGIS in Action 2nd Edition (p. 109 if you have the book) but using my own options. When I use this command I am met by the following error:
Warning 1: Cannot find information about stg.minneapolis table inraster_columns view. The raster table loading would take a lot of time. Please, execute AddRasterConstraints PostGIS function to registerthis table as raster table in raster_columns view. This will save loading time.ERROR 1: Error browsing database for PostGIS Raster propertiesGDALOpen failed - 1Error browsing database for PostGIS Raster propertiesHowever, when I examine the raster_columns view, the output shows the table:
srtm=# SELECT r_table_schema, r_table_name, srid FROM raster_columns; r_table_schema | r_table_name | srid ----------------+--------------+------stg | na | 4326stg | minneapolis | 4326Any ideas? I'm completely stumped. I'm rather new to PostGIS and PostgreSQL, but am in love with GIS and looking to learn them to use as a backend for cloud-based GIS. I need to get this figured out for my master's research - your expertise is much appreciated!
أكثر...