Re: [postgis-users] Geoprocessing & BigData

2016-01-18 Thread Vincent Picavet (ml)
Hi Ravi, On 18/01/2016 19:14, Ravi Pavuluri wrote: > Hi All, > > I am checking if there is a way to process quickly large datasets such > as census blocks in PostGIS and also by leveraging big data platform. I > have few questions in this regard. > > 1) When I try intersect for sample census

Re: [postgis-users] [postgis-devel] postgis extension sans raster (only for folks who can't compile with raster support) - PSC Vote and developer/packager comments please

2015-10-28 Thread Vincent Picavet (ml)
Hello Regina, We do have cases where we do not need raster at all (>90% of our users), and must compile everything from scratch (~10% of our users). We would be pleased to not having to compile GDAL in this case. And it would be great to still use the CREATE EXTENSION mechanism to install

Re: [postgis-users] The pcpatch datatype

2015-02-13 Thread Vincent Picavet - ML
Hi, Le vendredi 13 février 2015, 14:35:51 Jonathan Moules a écrit : Thanks Steve (and Martijn!) An extension of an extension then, that might get confusing. PointCloud is actually a PostgreSQL extension, and can work without PostGIS. There are convenience functions on top of PointCloud and

Re: [postgis-users] Recursive CTE nearest neighbour function

2015-02-08 Thread Vincent Picavet - ML
Hello Mark, Any reason for not using the standard KNN search mechanism ? With the LATERAL keyword you can solve the reference issue of subqueries. Like this : -- find 2 closest bar from each bus stop select bus.gid, bus.name, lat.gid, lat.name, lat.dist from points as bus , lateral

Re: [postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS

2015-02-05 Thread Vincent Picavet - ML
Hello, Le jeudi 29 janvier 2015, 15:22:15 Tahir Tamba a écrit : [...] Otherwise, are there another ways to load tables from Oracle Spatial database to PostGIS ? As Brent suggested, you can use Oracle Foreign Data Wrapper. There is now full support for Oracle spatial included in Oracle_fdw