a" Praliaskouski
> *Sent:* Friday, May 15, 2020 5:55 AM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Fwd: Re: Broken installs for PostGIS for
> Ubuntu 20.04LTS / Focal?
>
>
>
> It is mentioned in changelog and removed from the docs. For some reaso
>
>> Hi Tom,
>>
>> Thanks for the tip, but what did you do to remove the old install? Did
>> you rely on Apt or Synaptic to remove the old libgeos version, or did you
>> manually clean up folders? I had two versions of libgeos as well (3.7 and
>> 3.8) if
(3.7 and
> 3.8) if I remember well (need to start up the VM again to check), and
> removed the older one through Synaptic just leaving the 3.8 version, but
> that wasn't enough to solve my particular issues.
>
> Marco
> Op 14-5-2020 om 10:32 schreef Tom van Tilburg:
>
> I t
;postgis-3.so" library when trying to use some tool in QGIS?
>>
>> I have installed PostgreSQL 12 and PostGIS 3.0.1 via Synaptic on Ubuntu
>> 20.04 (Focal) and use CREATE EXTENSION (via pgAdmin4), when I encounter the
>> error.
>> Marco
>>
>> O
" error related to the
>> "postgis-3.so" library when trying to use some tool in QGIS?
>>
>> I have installed PostgreSQL 12 and PostGIS 3.0.1 via Synaptic on Ubuntu
>> 20.04 (Focal) and use CREATE EXTENSION (via pgAdmin4), when I encounter the
>> error.
Same problem with qgis
On Wed, 13 May 2020, 11:14 Marco Boeringa, wrote:
> Hi all,
>
> Is there someone who can confirm they have been able to install PostGIS
> 3.0.1 via the official APT repository?:
>
> https://wiki.postgresql.org/wiki/Apt
>
> After using the Synaptics Package Manager to insta
Somehow I feel there is no need for plpgsql in what you are doing and that
indeed the ST_AsEwkt is too much.
I can't wrap my head around what this script is exactly trying to do
though. Can you elaborate a bit on your use-case? What is the original data
and what would you like to know from it?
Be
ow drawing the polygon
> completely into Google Earh.
> I using Postgis 1.3.5.
>
> Juan
>
>
> On Thu, Jun 1, 2017 at 2:55 PM, Tom van Tilburg-2 [via PostGIS] <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=5011240&i=0>> wrote:
>
>> Hi Ju
Hi Juan,
I'm not sure I understand your question. Do you mean that you want to
simplify the polygon so it has less points? In that case, use ST_Simplify
before your ST_AsKml function.
Read more about it over here: https://postgis.net/docs/ST_Simplify.html
Best,
Tom
On Thu, Jun 1, 2017 at 9:50 P
Brent,
It is generally a better idea to serve your raster from a filesystem
instead of postgis. Postgis only makes sens if you want to query on your
raster data (i.e. give me the number of cells containing water within
distance K of point X), otherwise it only gives needless overhead.
Another opt
Yes, this should be done with the ST_Equals function:
http://postgis.net/docs/ST_Equals.html
>From the docs: "Returns true if the given geometries represent the same
geometry. Directionality is ignored."
Best,
Tom
On Fri, May 19, 2017 at 7:55 PM, Basques, Bob (CI-StPaul) <
bob.basq...@ci.stpaul
Hi Gerard,
Considering that your points will always be in the heart of your polygons,
an ST_Intersects would be faster than ST_Within. 1000 points x 1000
polygons should not be a problem at all in this matter, but you might
consider adding a spatial index to the polygons.
On a side note: if your G
Carlo,
Your query seems a bit complicated and I'm not sure what you are trying to
do in it. Maybe you could simplify it a bit? Or at least give a real world
example of what you are trying to do? For sure try to set a projection
(SRID) to your geometries before turning them into rasters.
Best,
T
Hi Das,
I had to look three times to your email to notice the tricky difference
between *LWGEOMFromWKB and *geomfromewkb() (notice the extra 'e'?)
Seems you're trying to import an dump from an older version of postgis
(1.5?) into a newer 2.2 version. There will be a lot more problems than
only t
sed 2014/04/16" LIBXML="2.9.1"
> LIBJSON="UNKNOWN" TOPOLOGY RASTER
>
> Cedric
>
> Le 15/01/2016 09:09, Tom van Tilburg a écrit :
> >
> > Cedric,
> >
> > Are you sure rasters are enabled in your new postgis dbase? Ple
Cedric,
Are you sure rasters are enabled in your new postgis dbase? Please check
for the existence of raster functions (st_bandmetadata in particular) in
public.functions and run SELECT postgis_full_version()
Tom
On Thu, 14 Jan 2016 14:46 Cedric Duprez wrote:
> Hi all,
>
> I am trying to copy
We did some automated exports from postgis raster and vector to an anuga
flood model and put the results back into postgis for presentations.
Involved quite some python glue in between but in the end the postgis
database is usefull for administration of your data. Especially if you want
to deliver
est,
Tom
On 7/31/2015 6:35 PM, Kishore raju wrote:
I am trying to get pixels intersected in raster layer with polygons in
vector layer. can you please help me in designing the query.
On Wed, Jul 29, 2015 at 5:26 PM, Tom van Tilburg
mailto:tom.van.tilb...@gmail.com>> wrote:
Hi Ah
Hi Juli,
I think you were close but made a mistake in the aggregates.
Try to split your functionality with the help of 'WITH' statements and
see if you can do the grouping in that way in a subselect.
Something like:
WITH clips AS (
SELECT p.ecoregion_cod, ST_Union(ST_Clip(r.rast,1, p.geom,
Hi Ahmet,
It depends on how you would like to have the values returned.
If it's an average (or some other kind of statistics) I think you need a
two step approach:
1) Clip the raster where it intersects with the polygon:
http://postgis.net/docs/RT_ST_Clip.html
2) Do you stats on the resul
I think 3D is still in it's infancy in the world of GIS, so for many
things you have to things manually.
If it's just visualizing, you may try to export them as X3D and open
them in an X3D capable viewer.
Regina made a first (impressive) effort on a viewer with this:
https://github.com/ro
Hi,
A straight skeleton might be what you need:
http://postgis.net/docs/ST_StraightSkeleton.html
I know there are some blog posts on this but couldn't find them that
quickly.
Best,
Tom
On 20-5-2015 4:29, KhunSanAung wrote:
Hello All,
I'd like to generated line from elongated polygon in Pos
Hi Paolo,
I bumped into this as well, but it is by design and the solution is
fairly easy.
Read this:
http://postgis.net/docs/postgis_installation.html#install_short_version
Bottom line:
```
As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are
disabled by default. In order to re-
Hi Oliver,
I think you question is more for the postgres user list, since it hasn't
got anything to do with postgis.
Nevertheless, you can look into window functions of postgres where you
are able to get the value of the 'next' row, based on a sorting with
'lead(rowname,1)'. Once you calcula
Hi Olivier,
Thanks, I'll play around with the functions and come back to you with
some more specific questions.
In the meantime, it seems that the function is spelled incorrectly. I
think it should be ST_Tessellate.
Beste regards,
Tom
On 24-4-2014 22:19, Oliver Courtin wrote:
You're rig
Hi,
I'm starting to experiment with the SFCGAL functions in postgis like
ST_Tesselate(), especially with the idea to create TINS with breaklines
out of pg_pointcloud and vector data.
The functions are working as expected, however I notice that the
documentation is *very* sparse to non-existan
Luca,
Can you confirm that the function exists in the topology schema?
On 5-9-2013 9:56, Luca Morandini wrote:
On 09/05/2013 05:30 PM, Tom van Tilburg wrote:
The topology functions are not in the public schema so you have to
add the
explicit schema 'path' to the function.
Also, y
Hi Luca,
The topology functions are not in the public schema so you have to add
the explicit schema 'path' to the function.
Also, you got the function name wrong, it should be 'AsTopoJson'.
Try this: select topology.AsTopoJSON(topology) from
abs_asgc.lga06aaustlines;
Chrs,
Tom
On 5-9-201
Hi Carsten,
What you need is a *left join* :
|select grid.gid, count(kioskdhd3.geom) AS totale
FROM grid
LEFT JOIN kioskdhd3
ON st_contains(grid.geom,kioskdhd3.geom)
GROUP BY grid.gid;|
Note that I changed the * in count to a column from your points table
because you only want to count when yo
29 matches
Mail list logo
