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-29 Thread Vincent Picavet (ml)
ion on the extension topic. Could you elaborate on your SRS magic in another thread when it's mature enough ? Vincent > > P. > > On Wed, Oct 28, 2015 at 2:58 AM, Vincent Picavet (ml) > wrote: >> Hello Regina, >> >> We do have cases where we do not need ra

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 Postgis,

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 Po

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 na