Re: [postgis-users] pgsql2shp output truncated - work around

2013-12-18 Thread Ben Madin
G’day again, for lack of better solution I’ve found that ogr2ogr is working better - or at least in it is returning all the rows: ogr2ogr -f 'ESRI Shapefile' ${DIRPATH}${YEAR}/${MAPTYPE}bnda${YEAR}.shp PG:'host=localhost user=ben dbname=maps password=whatever’ interestingly, it also appears t

Re: [postgis-users] Building a 2D Array

2013-12-18 Thread Stephen Woodbridge
On 12/18/2013 1:12 PM, Nathaniel Hunter Clay wrote: Hi all, I am trying to build a dynamic 2d array of elements in plpgsql, however I am running in to the problem that plpgsql will not support dynamic allocation of 2d arrays. So how do you build a 2d array when you don't know what its size will

[postgis-users] Building a 2D Array

2013-12-18 Thread Nathaniel Hunter Clay
Hi all, I am trying to build a dynamic 2d array of elements in plpgsql, however I am running in to the problem that plpgsql will not support dynamic allocation of 2d arrays. So how do you build a 2d array when you don't know what its size will be until runtime? Prefferably with in a nested fo

[postgis-users] FW: Old question resurfacing

2013-12-18 Thread Basques, Bob (CI-StPaul)
From: Basques, Bob (CI-StPaul) Sent: Wednesday, December 18, 2013 11:04 AM To: 'PostGIS Users Discussion' Subject: RE: [postgis-users] Old question resurfacing Rémi, I’ve already played around with Cloud Compare, found it a few weeks ago during another research cycle. I think the first step i

Re: [postgis-users] raster with pixel < map unit

2013-12-18 Thread Rémi Cura
Ok I think I get it : the width are in pixel and not in map unit. Cheers, Rémi-C 2013/12/18 Rémi Cura > Hey list, > > again noob question. > > It seems impossible to create an empty raster with less than one scale > (takes integer !). > Now when I want to update the scale, the number of pixel

[postgis-users] raster with pixel < map unit

2013-12-18 Thread Rémi Cura
Hey list, again noob question. It seems impossible to create an empty raster with less than one scale (takes integer !). Now when I want to update the scale, the number of pixel is not updated : Is it normal/what should I do? Cheers, Rémi-C DROP TABLE IF EXISTS patch_to_raster; CREATE TABLE patc

Re: [postgis-users] point to raster conversion

2013-12-18 Thread Pierre Racine
I would rather use the user custom function mapalgebra technique used in ST_ExtracToRaster() in the PostGIS Add-ons to extract a mean value for the group of point intersecting with each pixel. This should work well if 1) most pixels have points inside so there is no need to interpolate 2) it is

[postgis-users] point to raster conversion

2013-12-18 Thread Rémi Cura
Hey, not very original question : I would like to convert parts of a point cloud into a raster. I'm under the impression that currently this is more easily done outside PostGIS (with grass, gdal, R, or wathever). I this simple process a good idea? for each small part of point cloud (a patch) g

Re: [postgis-users] Old question resurfacing

2013-12-18 Thread Rémi Cura
The LOD problem is much more complicated for city, because you hit the "generalization" problem. To simplify : there is currently no satisfactory automated way to generate complex 3D or 2D geographic information in multiple level of details. It is actively researched. The closest format we have fo

Re: [postgis-users] GeometryCollection with GEOMETRYCOLLECTIONM, POINTM etc.. value in constructor.

2013-12-18 Thread Baris Ergun
Exactly correct. I also tried to tell that the problem was originated from org.postgis.GeometryCollection constructor. So I posted to here to understand why constructor was behaving like this. This constructor is in postgis-jdbc.jar . Anyone knowing about this problem on the org.postgis.GeometryCol

Re: [postgis-users] GeometryCollection with GEOMETRYCOLLECTIONM, POINTM etc.. value in constructor.

2013-12-18 Thread Rémi Cura
Hey, using this in sql : SELECT ST_AsText(ST_GeomFromText( 'GEOMETRYCOLLECTIONM( POINTM(10 10 100), LINESTRINGM(0 50 100, 100 50 100), POLYGONM((25 25 100,75 25 100,75 75 100,25 75 100,25 25 100),(45 45 100,55 45 100,55 55 100,45 55 100,45 45 100)) )' )) It gives you the expected output. I would g

Re: [postgis-users] GeometryCollection with GEOMETRYCOLLECTIONM, POINTM etc.. value in constructor.

2013-12-18 Thread Rémi Cura
Sorry, output : GEOMETRYCOLLECTION M (POINT M (10 10 100),LINESTRING M (0 50 100,100 50 100),POLYGON M ((25 25 100,75 25 100,75 75 100,25 75 100,25 25 100),(45 45 100,55 45 100,55 55 100,45 55 100,45 45 100))) Cheers, Rémi-C 2013/12/18 Rémi Cura > Hey, > using this in sql : > SELECT ST_AsTex

Re: [postgis-users] Old question resurfacing

2013-12-18 Thread Frank Henze
Hi, thanks for this very interesting approach! We need LOD not only for point clouds, but also for large 3D models (e.g. 3D city models / CityGML). Is there a solution for PostGIS? Interesting approaches for visualization of large 3D can also find on X3DOM (see homepage and search on Youtube

[postgis-users] GeometryCollection with GEOMETRYCOLLECTIONM, POINTM etc.. value in constructor.

2013-12-18 Thread Baris Ergun
Hello I create a GeometryCollection as below GeometryCollection coll = new GeometryCollection( "SRID=-1;GEOMETRYCOLLECTIONM(POINTM(10 10 100),LINESTRINGM(0 50 100, 100 50 100),POLYGONM((25 25 100,75 25 100,75 75 100,25 75 100,25 25 100),(45 45 100,55 45 100,55 55 100,4