Tag Info

Hot answers tagged


You are looking for ST_Reclass. There are three types of function signature, essentially differing on how you pass the reclassargs, which is essentially a textual encoding for mapping input to output pixel ranges. UPDATE bin_rast SET reclass_rast = ST_Reclass(bin_rast, 1, '0:-999, 1:100', '8BUI', 0) WHERE rid = 1; where obviously you will need to put in ...


SELECT ST_Intersects(a.geom, b.geom) FROM (SELECT ST_SetSrid(ST_MakePoint(300000, 300000), 3587) as geom) a, (SELECT ST_SetSrid(ST_MakePoint(300000, 300000), 900913) as geom) b; returns ERROR: Operation on mixed SRID geometries, ie, even though these are identical points, and the SRIDs 900913 and 3857 describe identical coordinate reference systems, ...

Only top voted, non community-wiki answers of a minimum length are eligible