d,
> st_intersection(t.geom, d.geom)::geometry(linestring,4326) AS geom
> ,t.trails_id, d.id
> FROM public.temp_trails as t, public.polys as d;
>
>
> Cheers,
> Rémi-C
>
> 2016-03-17 8:15 GMT+01:00 Franço
Hello,
Dis you take a look at the query result ? I think you should first try to
see what is the type of geometry returned using ST_GeometryType(). You may
have some geometrycollections and I’m not sure QGis can handle it. In this
case you could extract lines using ST_CollectionExtract().
Hi Guillaume,
Did you try to use directly raster2pgsql.exe ?
http://postgis.net/docs/manual-2.2/using_raster_dataman.html#RT_Raster_Loader
Regards,
Hugues.
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf
Of Guillaume ARNAUD
Sent: Friday, January 22,
Hello,
I think using order by desc + limit close with st_distance could do what toi need.
Hug
Le 22 juin 2015 9:30 PM, Gerry Creager - NOAA Affiliate gerry.crea...@noaa.gov a écrit :Ive two tables, one with a set of city centroids, and one with radar locations. I need to select the 4 (or maybe 5)