Hey,
I'm not an expert,
I would say the first thing would be to create a table with this query,
then try to load the result into qgis.
Another option is to encapsulate your group by into a sub querry, QGis
might be confused by the number of rows.
Try :
SELECT *
FROM (
SELECT row_number() over()
Thanks Remi
of course I can materialize the query, but I don't want to create n new
tables..
The incapsulation don't work
I found this to work but with strage results
SELECT row_number() over() as id, ST_CollectionHomogenize(st_collect(geom))
as geom, f1, f2
FROM schema.table
group by 3,4
Sorry the second link is this
https://dl.dropboxusercontent.com/u/15885512/strangequeryresult2.jpg
2014-03-28 11:14 GMT+01:00 Pietro Rossin pieri...@gmail.com:
Thanks Remi
of course I can materialize the query, but I don't want to create n new
tables..
The incapsulation don't work
I found
Maybe you should check that the result of you querry is valid geometry
(ST_Isvalid()).
Another think is you could force your query output geometry type to multi
of one type,
for example : ST_Multi(ST_CollectionExtract(geom,2)) enforce that output
type is multi line.
Cheers,
Rémi-C
2014-03-28
Hi there,
To make a Raytracing Analysis of a 3DCity Area I will use the CityGML Format
and therefore database format. I decided to choose PostgreSQL with PostGIS
and 3DCityDB.
But when creating a new database, after entering my password, the SRID and
the SRSName the following error occurs:
SELECT postgis_full_version()
error : no postgis
Cheers,
Rémi-C
2014-03-28 12:14 GMT+01:00 Morten Sickel mor...@sickel.net:
spatial_ref_sys should have been created and populated when postgis was
installed. Double check that that has been done correctly.
Morten
3DCityModeler skrev:
On Thu, Mar 27, 2014 at 11:25:05AM -0500, Dan Gast wrote:
overcommit = 2 is definitely the best choice in this situation (i.e.
give the daemon a chance to give up gracefully), but I still don't
understand why memory balloons in the first place.
ST_Buffer is known to possibly use a lot of
You don't need to do that,
just
'CREATE EXTENSION postgis;'
assuming you have a decently recent postgres and postgis
Cheers,
Rémi-C
2014-03-28 12:26 GMT+01:00 Robert Burgholzer rburg...@vt.edu:
Loojs like postGIS did not get installed. Two tables are created and
populated as part of the
On Tue, Mar 25, 2014 at 03:13:13PM +0100, Rémi Cura wrote:
Back after some other testing .
(_from memory, suppressing checks in addpoints was about 2 sec instead of 3
sec.
_About 21k unique points.)
Here is a little comparison :
(32k polylines,21k unique points, already 'topological'(
It is working now. I needed to install it again.
Thanks for your help guys!
--
View this message in context:
http://postgis.17.x6.nabble.com/3DCityDB-Error-with-creation-of-database-tp5005987p5005997.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
Surely !
I have to outline that grass export to postgis topology is still in beta
mode.
Also, I have a feeling the grass export to postgis topology uses the
postgis topology functions, which kind of defeat the purpose (should bulk
insert into tables).
I sent a separate message, but GEOS is also
Hi, I am trying to convert a raster from SAGA GIS to Postgis using
raster2pgsql.The command line and its output is:
C:\\Progra~1\\PostgreSQL\\9.3\\bin\\raster2pgsql.exe -F -d -
I -C -M -s 2193 I:\cb09\cb09_3dem.sdat cb09_3 | psql -d NZTPU
Processing 1/1: I:\cb09\cb09_3dem.sdat
BEGIN
NOTICE:
You should tell raster2pgsql to tile the raster into smaller bite-size
chucks, 256x256 is a safe value. It sounds like the raster is too big for
what memory is available.
-bborie
On Fri, Mar 28, 2014 at 5:29 PM, georgew gws...@hotmail.com wrote:
Hi, I am trying to convert a raster from SAGA
Thanks bborie, however from the error message I received the problem seems
due to the need to convert the original raster to utf-8. But the original
raster is in utf-8 already.
If I follow your suggestion (and after this mystery conversion is done) will
I be able to recombine the tiles to create
How big is the original? Numbers of pixels width and height? Number of
bands? Pixel types of the bands? I just want to know so that I can tell you
if its even possible to store that raster as one database value.
Utf-8 shouldn't be an issue as the raster data itself isn't in any
character set
Wait a minute. I wonder what your psql's client encoding is. This seems
familiar...
-bborie
On Mar 28, 2014 5:30 PM, georgew gws...@hotmail.com wrote:
Hi, I am trying to convert a raster from SAGA GIS to Postgis using
raster2pgsql.The command line and its output is:
Found the answer.
http://postgis.net/docs/RT_FAQ.html#qa_raster_fails_encoding_conversion
Got to love robe2 and her due diligence.
-bborie
On Mar 28, 2014 5:30 PM, georgew gws...@hotmail.com wrote:
Hi, I am trying to convert a raster from SAGA GIS to Postgis using
raster2pgsql.The command
thanks again bborie, my original raster is only 135MB in size, the generated
sql is 270MB in size. As for the FAQ, I had looked at it, but could not work
out how to find out how my client encoding is set and where. Also where is
the postgresql load script for windows?
--
View this message in
Assuming you are running psql at the terminal/console, you should run set
PGCLIENTENCODING=UTF8 before running psql.
I can't say I can be of much more help as I don't have a windows box handy.
-bborie
On Mar 28, 2014 7:01 PM, georgew gws...@hotmail.com wrote:
thanks again bborie, my original
Thanks bborie, this is what I did, but no improvement:
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\WINDOWS\system32set PGCLIENTENCODING=UTF8
C:\WINDOWS\system32psql -U postgres -d NZTPU -f c:\cb09.sql
BEGIN
psql:c:/cb09.sql:2: NOTICE: table
20 matches
Mail list logo