Hello,
I am not sure what you wanted to do, but the query you wrote runs union
pairwise between all objects of the first table and second table, creating
NxM objects each of which is a sum of two different polygons in the first
and second layer. It is entirely possible that this consumes all of yo
https://postgis.net/docs/ST_LocateBetweenElevations.html should just do the
trick.
On Tue, Jun 3, 2025 at 7:58 PM Paul Ramsey
wrote:
> If instead of putting your value on the Z, you put it on the M, you could
> have recourse to the https://postgis.net/docs/ST_LocateBetween.html function.
> Maybe
stronger.
>
> El mar., 18 oct. 2022 12:34, Darafei "Komяpa" Praliaskouski
> escribió:
>
>> Hi,
>>
>> RSSI has very complex shapes in the city terrain, not really following a
>> usable distance formula.
>>
>> That being said I once upon a time go
Hi,
RSSI has very complex shapes in the city terrain, not really following a
usable distance formula.
That being said I once upon a time got myself a ladder, excel spreadsheet
and measured one specific access point using my phone and regressed this
piece of formula.
0.2347 * exp(-0.07877 * (ap -
Hi,
Your function sounds a lot like existing
https://postgis.net/docs/ST_AsMVTGeom.html
On Mon, Jun 27, 2022 at 9:10 PM wrote:
> Thank you for your feedback. Since I see no practical way for me to use
> liblwgeom functionality after installing postgis 3.x I tried another
> approach and added my
Hi Marko,
The scenarios you benchmarked don't hit any of the reasons to use the
Subdivide. The interesting ones are KNN K=1 and exists(where
ST_Intersects()).
On Thu, Feb 17, 2022 at 9:49 PM Marco Boeringa
wrote:
> Hi all,
>
> As a follow up to the mail that I attached below and that unfortunat
+1 Darafei.
On Sun, Feb 13, 2022 at 8:22 AM Regina Obe wrote:
> PostgreSQL 9.6 has reached EOL so I don't think there is any point in
> supporting it in PostGIS 3.3.
>
> https://www.postgresql.org/support/versioning/
>
>
> PostgreSQL 10 will be EOL'd before or very close to our planned 3.3 relea
Hi,
Projections I use are all standard:
- EPSG:4326 for unprojected OpenStreetMap
- EPSG:3857 for tiles and quick 2D calculations
- EPSG:3395 for some legacy systems that can't go to 3857
- EPSG:4978 for 3D XYZ calculations like all-globe clustering
On Fri, Feb 4, 2022 at 8:05 PM Sandro Sa
Does not reproduce on my 3.2 and 3.1.4 installs:
10:17:37 [gis] > select postgis_full_version();
┌
Hi,
outdb rasters are not part of supported Postgres machinery and are really a
pretty illegal hack.
If you keep your inputs out of DB, and your outputs out of DB, you may
really want to move the processing part out of DB too and use GDAL to do
the calculations.
The postgres way to handle that w
Hi,
I have not seen flatgeobuf in the wild, and I believe it can be safely
removed.
The current implementation is impaired by Postgres' life choices of 1GB
limit and thus not usable for any data, just size-limited subset. ogr2ogr
seems like a better suited place for it to reside.
I'm -0 on addin
In Minsk, Belarus, we're planning to go to the bar in the evening
of PostGIS day.
telegram chat to sync up: https://t.me/bygis
(for locals - зарегистрироваться можно тут:
https://forms.gle/apeK38jWpkjdK6bw5 )
On Thu, Nov 11, 2021 at 12:09 AM Paul Ramsey
wrote:
> Hey all, just a reminder that t
Hello, can you show what exactly is your problem? The example is on the doc
page:
https://postgis.net/docs/ST_QuantizeCoordinates.html
On Fri, Nov 12, 2021 at 11:24 AM Shaozhong SHI
wrote:
> Any example of how to use st_quantizecoordinates?
>
> Regards,
>
> David
> __
Hey,
In the past I've used https://github.com/tudelft3d/pprepair for this kind
of data. Nowadays you can node the linework, take the
ConstranedDelaunayTriangles of it and reassign all of the triangles to
closest polygons to re-union back to simulate it.
On Wed, Oct 27, 2021 at 8:15 PM Richard Gre
Hi,
This is tracked on the wiki:
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS#Currentbest
The latest stable is good. If you're building a new long project, you may
want to start with current alpha/beta versions instead so by the time it's
done they're mature and everywhere.
Dar
g. So clearly I am missing something somewhere or my understanding
> of exclusion constraints is lacking...or both. Any suggestions to get the
> desired outcome? (Using a trigger doesn't count :-D )
>
> But
> Rhys
> Peace & Love | Live Long & Prosper
> ___
Your Proj installation seems broken.
аў, 22 чэр 2021, 23:32 карыстальнік Ben Boughton
напісаў:
> I am having issues loading raster via raster2pgsql (RELEASE: 3.1.2
> GDAL_VERSION=30 (cbe925d)); postgres (PostgreSQL) 13.3 (Ubuntu
> 13.3-1.pgdg20.04+1)
>
> If I run:
>
> raster2pgsql -C -R testr.ti
ers mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
rather get it from
> the Canonical maintained Ubuntu repository.
>
> Marco
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Darafei "Kom
stgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
ersection of the subdivision lines, even if the geometry part
> above or below the horizontal subdivision line, won't be cut vertically
> at that point.
>
> Marco
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.o
to be reported as
a bug with specific inputs you feed it.
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
ucabert.de)
>> ___
>> postgis-users mailing list
>> postgis-users@lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
&
gres added
infrastructure and after they push out we can start using it. You're
welcome to join the ride and help testing.
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-u
ave a particularly good sense of the costs here. It's obvious
> >> that the benefits would be very significant, but you don't need me to
> >> say that. The hard parts are 1.) determining the costs, and 2.)
> >> determining if the benefits are worth it.
> >>
> >>
> >> --
> >> Peter Geoghegan
> > ___
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
Hello,
Cluster functions don't have cross-PostGIS-version stability guarantee. For
many production applications that is equal to being non-deterministic.
While debugging KMeans I believe I've seen blinking tests on different
compiler flags as some optimizations may mean your distance computation
SQL?
>
> Thanks
> Alex
>
> Get BlueMail for Android <http://www.bluemail.me/r?b=16421>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Hello,
People make neural networks for this kind of task:
https://github.com/openvenues/libpostal
сб, 9 сту 2021, 12:40 карыстальнік Shaozhong SHI
напісаў:
> Hi, Steve W,
>
> it is easy to parse addresses as tokens. But it is difficult to put
> tokens in right columns, due to that the same ad
isting in GEOS for planar
> geometries.
>
> Adding the support for the geography type would mean to re-implement the
> algorithm specifically for
> spherical objects, as you mentioned.
>
> Regards,
> Giuseppe.
> ___
> postgis-users m
Hi,
Here is a gist I use to put notes of all my upgrades:
https://gist.github.com/Komzpa/994d5aaf340067ccec0e
чц, 17 сне 2020, 23:46 карыстальнік Clifford Snow
напісаў:
> I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on
> a Fedora Workstation. Is it possible?
>
> I thou
allel sort faster
> (Darafei Praliaskouski)
> >> - #4625, Correlation statistics now calculated.
> >>Run ANALYZE for BRIN indexes to start kicking in.
> >> (Darafei Praliaskouski)
> >> - Fix axis order
list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
Hello,
Let's start with first things:
- is postgis installed into the same database where you are unpacking dump
to? common issue is installing to "postgres" database and then expecting to
have it in "gis" or "$yourapp" one.
- can you share a full reproducer scenario? there are two in the ticket
It's easy to see the difference if you ask for more precision:
18:26:40 [gis] > SELECT
ST_AsText(ST_GeomFromWKB('\x0101000ad7a3f0735727c13d0ad7a3ae0c30c1'),150);
┌───┐
│
Hello Marco,
Scope for PG13 was fixed half a year ago. This is up for PG14, and needs
your care and help to happen - there is a possibility to get it in
parallel, since this sorting build is still single thread.
On Thu, Sep 17, 2020 at 12:24 AM Marco Boeringa
wrote:
> Thanks Peter,
>
> That cer
Hello,
Please note 2.4 is not the latest version, 3.0 is.
You're expected to add ST_ prefix to all the functions to find their modern
name. ST_SRID, ST_GeometryType in your example.
On Tue, Aug 18, 2020 at 10:26 PM S Bob wrote:
> All;
>
>
> We are upgrading from postgis 1.5 -> 2.4
>
>
> Is th
Hello,
You followed the best practice to report it. Trac is officially a bug
tracker.
Best way to get it fixed is to stomp it into a Github pull request with
minimized version of your case in regress suite.
Somewhere in here:
https://github.com/postgis/postgis/tree/master/raster/test/regress - pr
You don't. Garbage in, garbage out.
Finding the closest address will work best for now.
Find the dataset that has at least house numbers at all the corners and
street starts and ends, if you're operating in US-like culture. If you're
operating in a culture where houses are numbered by constructio
It is mentioned in changelog and removed from the docs. For some reason
there is stray page from older release.
On Fri, May 15, 2020 at 12:52 PM Tom van Tilburg
wrote:
> It's the first thing I ran into as well after upgrading .
> But it hasn't been mentioned in the docs? Whoops... time for an is
gt; On May 1, 2020, at 13:38, Darafei Komяpa Praliaskouski
> wrote:
> >
> > There is a hint on what's happening. Someone pressed Ctrl+C, so the rest
> of the message is just whatever debug messages there are on the way out of
> the function that processed the Ctrl+C.
>
&
There is a hint on what's happening. Someone pressed Ctrl+C, so the rest of
the message is just whatever debug messages there are on the way out of the
function that processed the Ctrl+C.
NOTICE: liblwgeom code interrupted
It also happens some times that Ctrl+C interrupt flag does not get reset,
uot;);
> | cross_right++;
> | if ( ! first_cross )
> | first_cross = SEG_CROSS_LEFT;
> | }
>
> Thanks,
>
> 2020年4月19日(日) 23:31 Darafei "Komяpa" Praliaskouski :
> >
> > Hi,
> >
> > the link you have is setting variable th
Hi,
the link you have is setting variable this_cross, and L526 sets
first_cross from it if it was not set and there is LEFT or RIGHT cross
(not no-cross and not COLLINEAR). Looks expected to me.
On Sat, Apr 18, 2020 at 6:32 PM Kohei KaiGai wrote:
>
> Hello,
>
> I noticed a strange code at liblwg
ST_MakeValid by definition does anything it likes, the only thing that
should happen: output is valid and no vertices are lost. The "no
vertices are lost" forbids to discard the hole.
If MakeValid will change behavior there it will stop being useful for
"inners and outers are marked incorrectly" ca
Hello,
Equality has been significantly reworked in 3.0. Can you reproduce
your issue in PostGIS 3.0?
On Thu, Mar 5, 2020 at 9:46 AM Ryo NEYAMA wrote:
>
> Hello,
>
> I had a performance issue when I JOIN two tables by using the equivalence
> of two ST_Point()s.
> I'm wondering if it is a kind of
eed processing in the minutes per
> record. I certainly do not see issues with "multiple queries running at
> the same time" as inhibiting the multi-threaded process flow. With 8-16
> connections opened (one for each processing thread) in my multi-threaded
> implementation, PostgreS
Hi,
Can you please be more specific with the question?
Parallelism is tuple level. All load balancing is provided by Postgres
- different Parallel Scan types have different ordering properties and
different tuple passing graph.
Parallel index scan pushes out each tuple to next free worker,
essent
The PostGIS Team is pleased to release PostGIS 3.0.1.
Best served with PostgreSQL 12.2, GEOS 3.8.0, SFCGAL 1.3.7, GDAL
3.0.4, PROJ 6.3.1, protobuf-c 1.3.3, json-c 0.13.1.
source download https://download.osgeo.org/postgis/source/postgis-3.0.1.tar.gz
NEWS https://git.osgeo.org/gitea/postgis/postgi
Hi,
Does this help?
https://github.com/postgis/postgis/blob/master/raster/doc/RFC2-WellKnownBinaryFormat
On Wed, Jan 22, 2020 at 12:06 AM Felix Schütt
wrote:
> Hi,
>
> I'm currently working to understand the raster format of PostGIS,
> especially the binary encoding. Let's say that I have a bun
Hi,
Can you share a testcase?
Are you running PostGIS 2.5+ so ST_Subdivide will try to reuse the original
node?
On Tue, Nov 26, 2019 at 7:24 PM Eduardo Ramos wrote:
> Hello all.
>
> I'm exploring the function ST_Subdivide(with type geometry) and noticed
> that the nodes that this function creat
Try the next dance:
alter extension postgis update to "2.4.1next";
alter extension postgis update to "2.4.1";
alter extension postgis update to "3.0.0";
On Thu, Nov 14, 2019 at 4:57 PM Thor Bach
wrote:
> I am trying to upgrade a large postgres 9.6.6 database (10TB+) from
> postgis 2.4.1 to 2.5.
Hi,
Similarity search for text is a task of pg_trgm, not PostGIS. Here's doc
with how you do it:
https://www.postgresql.org/docs/12/pgtrgm.html
On Mon, Oct 14, 2019 at 10:23 PM Shaozhong SHI
wrote:
> This is an interesting problem.
>
> SELECT 'city centre' ~* 'city centRe ';
>
> Between city a
Hi,
The one I've seen was similar, but there was also text in German and no
huge postgis logo on the bottom. There was also German version. Are there
other flyers?
On Tue, Sep 24, 2019 at 8:02 PM Regina Obe wrote:
> We should update it once we release 3.0 since extension list would have
> chang
Hi,
I've been on State of the Map and FOSS4G and seen that OSGeo hands out one
page PostGIS project info. It seemed very popular, as number of papers
available was close to 0. I did not take one (and the one in German won't
help me much) - is it on the web somewhere?
And how do we make sure there
On Tue, Sep 10, 2019 at 1:04 PM Devrim Gündüz wrote:
>
> Hi,
>
> On Wed, 2019-09-04 at 15:05 +0300, Darafei "Komяpa" Praliaskouski wrote:
> > According to repology, CentOS 7 doesn't even ship PostGIS. See table at
> the
> > end of https://trac.osgeo.o
On Tue, Sep 3, 2019 at 7:48 PM wrote:
> It is not possible to use update on the table when splitting one geomety
> to two.
>
For cases where you want to change number of rows in processing, there's a
CTE trick that is INSERT FROM DELETE, you can find an example in
ST_Subdivide manual page and ad
Hello,
According to repology, CentOS 7 doesn't even ship PostGIS. See table at the
end of https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS - it
contains all distributions.
If you are installing from some custom repository - which one is that?
Please find that repository's GDAL maint
Hi,
By the looks of it - you have a geography, not geometry, column, with a
SRID set. As far as I remember, geography looks up the SRID in the
spatial_ref_sys table to check if it's indeed a degrees-on-a-spheroid one.
This probably needs a ticket on https://trac.osgeo.org/postgis/.
On Mon, Sep 2,
You're getting a copy of each ocean for each island with that island
removed, and only one gets back into the table. You probably want to remove
an union of all islands from each ocean.
UPDATE public."Ocean"
SET the_geom = coalesce(ST_Multi(ST_Difference("Ocean".the_geom, (select
ST_Union(the_g
Hi Christian,
To understand the query please try plotting your polygon on a globe and
then imagine axis aligned box that will contain it (one side parallel to
equator, other parallel to 0 and third to 90th meridian). You will see that
your "large" geometry is really 40 degrees wide spot around ant
Hi,
The issue is indeed you are using Postgres polygons instead of PostGIS
polygons. ST_MakePoint (note ST_ prefix) builds a postgis point.
Non-working countertpart would be this:
SELECT ST_WITHIN('(1,1)'::point, '(1,1)'::point ) ;
On Tue, Aug 6, 2019 at 7:37 AM Michael Lubinsky
wrote:
> Envir
Hi,
To cross check your actions please have a look at this definitely working
recipe:
https://github.com/postgis/postgis-build-env/blob/master/Dockerfile#L49
You may also want to utilize prebuilt distribution provided packages, say,
from Ubuntu 19.04 or Debian Sid.
On Fri, Aug 2, 2019 at 1:53 PM
Hi,
Please install SFCGAL and its dependencies, as suggested by the error.
Current version of libsfcgal is 1.3.7.
On Fri, Aug 2, 2019 at 1:16 PM Pradeep Kanth G
wrote:
> Thanks, now it is in progress.
>
>
>
> Getting the below error
>
> In file included from lwgeom_sfcgal.c:26:0:
>
> lwgeom_sfc
This file is shipped as part of Proj library. If you are installing it via
your package management system, make sure you're installing libproj-dev (in
Debian-like) or proj-devel (in RPM-like).
On Fri, Aug 2, 2019 at 12:59 PM Pradeep Kanth G
wrote:
> Hi,
>
>
>
> I have tried but not getting this
Hi,
Can you check that development headers of proj are actually available,
looking for proj_api.h in your file system?
On Fri, Aug 2, 2019 at 12:55 PM Pradeep Kanth G
wrote:
> Hi,
>
>
>
> Installed latest(PostGIS2.5.2 & GEOS 3.7.2) version, but getting the same
> error.
>
>
>
> configure: error
Hello,
PostGIS 2.2 is End of Life. Current release is 2.5.2.
GEOS 3.3 is End of Life. Current release is 3.7.2.
Please consult this matrix when choosing the best versions combinations:
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
On Fri, Aug 2, 2019 at 12:33 PM Pradeep Kanth
Hello,
what are the versions of proj and postgis that you are using?
On Fri, Aug 2, 2019 at 12:03 PM Pradeep Kanth G
wrote:
> Dear All,
>
> While installing the PostGIS, getting the below error.
>
> ./configure --with-pgconfig=/home/postgres/pgxl/bin/pg_config
>
> Error:
>
> configure: error: c
Hi,
There were changes ST_ConcaveHull that fixed robustness of it in 2.2 -> 2.5
chain.
To point where the penalty comes from, try to run a query and on a side
console server-side run `sudo perf top`. Function names will get you a
rough idea where the execution process lives now.
To further debug,
Hi,
Please describe the problem you're facing more precisely.
On Thu, Aug 1, 2019 at 7:45 AM Pradeep Kanth G
wrote:
> Anyone did it?
>
>
>
> Regards
>
> Pradeep Kanth
>
>
>
> *From:* postgis-users *On Behalf
> Of *Pradeep Kanth G
> *Sent:* Wednesday, July 31, 2019 3:41 PM
> *To:* 'PostGIS User
gt;
> *New database after hard upgrade :* SELECT srtext FROM spatial_ref_sys
> where srid=*911423*;
> returns :
> GEOCCS["St Pierre et Miquelon 1950",DATUM["St Pierre et Miquelon
> 1950",SPHEROID["Clarke
> 1866",6378206.4000,294.978698200,AUTHORITY
Hi,
Can you describe how the operations like Intersection should behave in such
type? E.g. if you have a type with 0 decimals (say), and have a line going
from (0,0) to (1,1) intersect with a line going from (1, 0) to (0, 1) -
what is the intersection point that is going to be reported? Will that
mate values
> at intra-segment points. We can put this on the list for future
> development.
>
> On Mon, May 6, 2019 at 4:48 AM Darafei "Komяpa" Praliaskouski <
> m...@komzpa.net> wrote:
>
>> Hi,
>>
>> GEOS operations do not preserve M, but someti
Hi,
GEOS operations do not preserve M, but sometimes preserve Z. You can try
ST_SwapOrdinates(ST_Intersection(ST_SwapOrdinates(geom, 'zm'),...), 'zm').
On Thu, May 2, 2019 at 5:19 AM Bo Guo wrote:
> Hi there,
>
> I was trying to cut a portion of the LRS route with an area using
> ST_Intersectio
PostGIS can do partial indexes, but because of how Postgres infrastructure
works you will need to drag the geom && clause into all
queries.
On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde wrote:
> yup, probably indexing.
>
> If it's a big pointcloud a BRIN index can make sense.
> For some guidance
Hi,
Thing you explain may be called Indexing. Have a look here:
http://postgis.net/workshops/postgis-intro/indexing.html
On Thu, Mar 21, 2019 at 10:11 PM Pawel Pocwiardowski
wrote:
> Hi
>
> I am complete newbe in postGIS so I appology for stupid question.
>
> Is there a mechanism in PostGIS's i
Hi,
PostGIS 2.2 is End of Life. No bugs are going to be fixed in it. Current
version is 2.5.2, please upgrade both.
GeoJSON serialization was tweaked in 2.5.0, please check if bug still
reproduces there.
On Thu, Mar 21, 2019 at 3:47 PM Micha Silver wrote:
> I am getting a segfault when trying t
Hi,
Simplest way would be to read definition of ST_DWithin and use index
lookups for smaller box, but rechecks for bigger. Don't ST_Simplify, it's
just wasting cycles.
select ... where geom && ST_Expand(other_geom, 100) and _ST_DWithin(geom,
other_geom, 110)
It will exit loop in ST_DWithin faste
If someone is willing, there is an old Geography Overlays patch that needs
lots of love: https://github.com/postgis/postgis/pull/191
On Tue, Jan 22, 2019 at 12:13 AM Paul Ramsey
wrote:
>
>
> > On Jan 21, 2019, at 1:00 PM, Simon Greener
> wrote:
> >
> > When a geography is casted to geometry for
Hello,
will that be useful for someone not fluent in German?
On Fri, Jan 18, 2019 at 3:47 PM Konferenzorganisation <
konferenz-o...@fossgis.de> wrote:
> Sehr geehrte FOSSGIS-Aktive, sehr geehrte FOSSGIS-Anfänger,
> OSM-Begeisterte und Interessierte,
>
> das Programm der FOSSGIS-Konferenz 2019 is
Hi Ashan,
are you able to provide the exact string being reported to 'select
version()'? A screen shot or photo will be good. (rephrased "it's going to
be ..." not.)
пн, 14 янв. 2019 г. в 14:46, Ahsan Hadi :
> On Mon, Jan 14, 2019 at 4:15 PM Raúl Marín Rodríguez <
> rmrodrig...@carto.com> wrote:
Hi,
These are all hacks with different meanings. ST_CollectionExtract removes
sliver parts that became lines, and ST_Multi just transforms a
GEOMETRYCOLLECTION into MULTI*. Basically ST_Multi is most of time used
with badly-written software that does not expect GEOMETRYCOLLECTION at all,
or wants
Hi,
did you create spatial index on your geometry?
your screenshot also does not show any geometry field.
On Thu, Dec 6, 2018 at 7:29 PM Manchon Pierre
wrote:
> Hello,
>
> The indexes are code_zoneinteret and code_tuile on recouvrement
>
>
>
>
>
> *De :* postgis-users *De la part
> de* Darafei
Hello,
What are the indexes on the table?
On Thu, Dec 6, 2018 at 7:16 PM Manchon Pierre
wrote:
> Yes the request took about ~100ms to be executed before but now it never
> ends (I left it 1h)
>
> (thx for the tip with where clause)
>
>
>
> *De :* postgis-users *De la part
> de* Tumasgiu Rossin
Hi,
I once developed a custom solution for this that I don't have source code
for. Logic for that was the following:
1. unbuffer the polygon by 500m. Now the contour of the unbuffered polygon
is candidate center points.
2. find the most distant point on it. this is a creative task, I just took
a
> On Wed, Dec 5, 2018 at 5:53 PM Ahsan Hadi
> wrote:
>
>>
>>
>> On Wed, Dec 5, 2018 at 3:55 PM Darafei "Komяpa" Praliaskouski <
>> m...@komzpa.net> wrote:
>>
>>> Hi Ashan,
>>>
>>> PostGIS 2.4.6 was released after Pos
Hi Ashan,
PostGIS 2.4.6 was released after PostGIS 2.5.0. You need to upgrade to
2.5.1 that was released after 2.4.6.
On Wed, Dec 5, 2018 at 1:50 PM Ahsan Hadi
wrote:
> Hi Regina,
>
> Do you know if a user running postgis 2.4.6 with PG 11 can upgrade to
> postgis 2.5 with v11 using the alter ex
If you are managing large geometries, splitting them off into "geometry
table" with non-uniquie ID and subdivided parts sometimes helps.
You want to build a tree on top of your geometry internals to make it all
fast, one way to do that is to make sure the internal parts of geometry are
available fo
Привет,
That chapter is part of PostGIS documentation which is part of PostGIS
itself. You can edit here:
https://github.com/postgis/postgis/blob/svn-trunk/doc/installation.xml
(just push [Edit], do your changes and [Save] -> [New pull request]).
Please also mention what is IGN and why it produc
Hi,
Please feed in your WKT polygons in EWKT format:
SRID=4326;POLYGON(...)
Since every update in Postgres is essentially Delete+Insert, time of
rewriting each and every row being equal to initial Insert time is expected
thing.
You can also update SRID in two columns in one go:
update tablenam
Some things I've been using PostGIS for:
- render OpenStreetMap. That's how I got to know about PostGIS, osm2pgsql,
mapnik and its styles. Changing order of things, removing clutter of icons
from map, adding clutter of icons you need for this map, getting tile
server online. Sorting by area to ge
Hi,
I keep a gist with upgrading tldr:
https://gist.github.com/Komzpa/994d5aaf340067ccec0e
You can notice most upgrades are similar and can be done by analogy.
Versions 2.1 and 2.5 have 5 years between them, so there are quite a lot of
small changes. However, if you weren't using weird tricks, th
Hi,
ST_Dump returns geometry_dump object that consists of two fields.
To get geometry from it:
(ST_Dump(whatever)).geom as geom
чт, 18 окт. 2018 г. в 19:46, Shane Carey :
> Hi,
>
> I still dont get any GIS layers returning, when I do:
>
> SELECT ST_Dump(ST_Split(polygon.geom, line.geom))
> IN
Hi,
I don't know what is GWC. This mailing list is about PostGIS.
This looks like the overlay does not do proper reprojection and instead
just takes proportion of latitude and longitude. You need to reproject all
the coordinates into underlay's projection before working with linear
proportions.
PostGIS 2.1 is End of Life and the only way to resolve issues in it should
be upgrading to latest version:
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
ср, 10 окт. 2018 г. в 16:49, Agustin Ignacio Genoves <
agustingeno...@gmail.com>:
> Here we have installed postgis 2.1.4. I rea
Hi,
Image didn't attach.
What I would try to do is to buffer your polygon iteratively with -1 meters
until it disappears, and reset the width on each segment of line to the
number of polygons it managed to intersect.
пн, 24 сент. 2018 г. в 8:44, Shane Carey :
> Hi,
>
> I have a river polygon an
get access to my old userID, I will file the them as a ticket.
>
> In the meantime I will try to union the problematic geometries in a loop
> one at a time with st_makevalid after each loop - maybe that will work as a
> workaround, now I could reduce the number of geometries dr
t; one at a time with st_makevalid after each loop - maybe that will work as a
> workaround, now I could reduce the number of geometries dramatically.
>
>
> Thank you very much for your help!
>
> Kind regards,
> Birgit
>
>
>
> --
> *Von
Hi,
This is not supposed to happen.
Can you please isolate the offending rows unioning them pairwise and file
them as a ticket? Here's a handy helper function that returns True if Union
failed:
create or replace function st_union_fails(geom1 geometry, geom2 geometry)
returns boolean
as $$
be
Hi,
Check that you are indeed connecting to Postgres 10 database. It looks like
you are connecting to 9.3 instance. Likely you need to change port in your
psql connection parameters.
select version();
пт, 7 сент. 2018 г. в 20:21, David Haynes :
> Hello,
>
> I'm having a bit of trouble getting t
Hi!
First case sounds like ST_Snap.
For second case, if you are not going to write an extending loop I would
try to get the polygon after buffering and then try with
ST_StraightSkeleton and ST_ApproximateMedialAxis.
Can you share a dataset to play with?
пн, 27 авг. 2018 г. в 19:34, Hemant Bist
1 - 100 of 152 matches
Mail list logo
