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
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
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
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
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
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
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
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
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
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
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
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
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
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
14 matches
Mail list logo