Hello,
I need to be able to perform an ST_intersects with a geometry that could be a
GeometryCollection.
I understand this is not supported from the PostGis documentation so I have
written this query:
select t.geometry
from schema.table t
where (st_intersects(t.geometry, st_collectionextract(
I imported timezone shapefile into postgis to get the timezone for the
lat/lon.
We have postgis on Greenplum with 32 segment and running postgis query to
get TZ for 100K records takes around 70-90 secs.
I've index on geom table on both tz_world and source table .
Question : Whether 70-90 second
Hi Tumasgiu,
Thanks a lot. You have been of great help.
On Tue, Apr 11, 2017 at 2:13 PM, Tumasgiu Rossini
wrote:
> Hi, I think that
> UPDATE table SET rast = ST_SetSRID(rast, mysrid) ;
> would do.
>
> However, doing so will leads to potentially inconsistent metadata between
> your
> pg ras
Hi Tumasgiu,
I agree with you regarding the warning. How do I then set the SRID for the
raster so that it is part of the metadata information?
On Tue, Apr 11, 2017 at 1:31 PM, Tumasgiu Rossini
wrote:
> Maybe a warning showing up when using -s and -R options together could be
> a nice thing to d
Hi Tumasgiu,
Thanks a lot, that solved the problem. You made my day.
On Tue, Apr 11, 2017 at 1:31 PM, Tumasgiu Rossini
wrote:
> Maybe a warning showing up when using -s and -R options together could be
> a nice thing to do ?
> Or maybe implementing another option which would use st_setsrid inst
Maybe a warning showing up when using -s and -R options together could be a
nice thing to do ?
Or maybe implementing another option which would use st_setsrid instead of
st_transform.
2017-04-11 14:25 GMT+02:00 Tumasgiu Rossini :
> Hi,
>
> I think I found the probelm, it is the -s option which m
Hi,
I think I found the probelm, it is the -s option which make the sql
applying a st_transfrom on the raster to reproject it into the desired CRS
before inserting it in the table, thus creating an in-db raster.
2017-04-11 12:14 GMT+02:00 Osahon Oduware :
> Hi Regina,
>
> I would like to add tha
Hi Regina,
I would like to add that the SHOW command below returns "on":
SHOW postgis.enable_outdb_rasters;
which I believe indicates that the environment variable is SET to enable
out-db raster. However, the result from your 1st query shows that the
raster table isn't created with out-db. Any r
Hi,
I am using Windows 7 OS and I have installed a GDAL with support for MrSID
format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to
point to this new GDAL.
How do I accomplish this in a Windows OS?
___
postgis-users mailing list
postg
Hi,
I am using Windows 7 OS and I have installed a GDAL with support for MrSID
format. I want to build my PostGIS with the GDAL-config-file to point to
this new GDAL.
How do I accomplish this in a Windows OS?
___
postgis-users mailing list
postgis-users
Hi Tumasgiu,
Yes, but I have tested it without the tiling too.
On Tue, Apr 11, 2017 at 10:27 AM, Tumasgiu Rossini
wrote:
> Hi,
>
> could it be that you are trying to tile your rasters with the option -"t
> auto" ?
>
> Sorry, I can't test it right now.
>
> 2017-04-11 11:07 GMT+02:00 Osahon Oduwa
Hi,
could it be that you are trying to tile your rasters with the option -"t
auto" ?
Sorry, I can't test it right now.
2017-04-11 11:07 GMT+02:00 Osahon Oduware :
> Hi Regina,
>
> I have tried the queries above. For the related raster table,
>
> SELECT r_table_name, r_raster_column, out_db FROM
Hi Regina,
I have tried the queries above. For the related raster table,
SELECT r_table_name, r_raster_column, out_db FROM raster_columns; RETURNS
"raster_table","rast","[False, False, False]"
SELECT t.rid, (md).isoutdb, (md).path
FROM nj_ned AS t, ST_BandMetaData(t.rast) AS md
limit 1; RETURNS
Hi James,
Thanks for your help. I have previously been able to convert the files from
MrSID format to other formats using GDAL, but my boss doesn't want to
consume extra storage space on the filesystem for another file format as
the initial data is stored as MrSID format and used by other GIS
appl
14 matches
Mail list logo
