Hello everyone,
I use Postgres 9.4 and PostGIS 2.1 to represent about 13.000.000
vertices in a 3D space (growing). Many points are connected in tree
structures of varying size, often around 5000 nodes per tree. Therefore,
we use single edges to represent them in our table. My aim is to have
very
From: dimitradimi...@windowslive.com
To: postgis-users@lists.osgeo.org
Subject: RE: [postgis-users] Problem in 3Dcitydatabase importer/exporter
Date: Tue, 30 Jun 2015 14:46:34 +0300
Hello Felix,
Thank you for your reply. I am using the newest version of 3Dcitydatabase and
during the
Hello Felix,
Thank you for your reply. I am using the newest version of 3Dcitydatabase
and during the import, there are no errors. I have been experimenting with
the coordinate system but with no result. However, the main problem is that
all building parts and textures are not been displayed. I
You can select pixels fulfilling an expression using the one-raster variant of
ST_MapAlgebra
http://postgis.net/docs/RT_ST_MapAlgebra_expr.html
So just do something like:
ST_MapAlgebra(rast, '8BUI'::text, '[rast] 0')
before computing stats.
To count the number of pixels of a certain value
Maybe you can even reduce this with cte :
with collected_geom AS (
select st_collect(geom) as geoms
from your_points
)
SELECT ST_LonguestLine(t1.geoms,t2.geoms)
FROM collected_geom AS t1, collected_geom AS t2
Cheers,
Rémi-C
2015-06-30 8:48 GMT+02:00 Nick Ves vesni...@gmail.com:
Didn't know
Didn't know about st_LongestLine.
Just tried and it amazed me!
on a dataset of 220k points (on a projected crs) it took ~ 1.5 secs to
answer the querry :
select 1 as id, ST_LongestLine(st_collect(geom),st_collect(geom)) geom
from points ;
N
On Sat, Jun 27, 2015 at 2:41 PM, Nicklas Avén