Re: Getting FIR from map

Hi, Unless your PDF is a geoPDF, you won't be able to retrieve any geometries from it. Try to drag and drop it into QGIS, if it loads, then you can use the import to PostgreSQL (new connection) to send the layer to the database. A sexta, 13/12/2024, 17:25, Luca Bertoncello escreveu: > Dear all

Re: uploading geopackage file onto to postgis

Hi David, Can you provide more details about the issue you're encountering? Specifically: - The exact error message you're seeing. - The version of PostGIS and PostgreSQL you are using. - The steps you followed to upload the geopackage file. - Any relevant configuration settings or logs. This inf

RE: pgr_alphashape is returning a geometry collection?

9.1587 > 38.7343,-9.15956 38.7329,-9.15955 38.7328,-9.15961 38.7331,-9.1587 > 38.7343)),POLYGON((-9.15826 38.7346,-9.15779 38.7345,-9.15844 > 38.7344,-9.15826 38.7346)),POLYGON((-9.16211 38.7321,-9.16213 > 38.7319,-9.16224 38.732,-9.16211 38.7321)),POLYGON((-9.16018 38.7362,-9.16009

pgr_alphashape is returning a geometry collection?

expected behaviour. Alexandre Neto Sent with Shortwave <https://www.shortwave.com?utm_medium=email&utm_content=signature&utm_source=c2VuaG9yLm5ldG9AZ21haWwuY29t>

Re: [postgis-users] QGIS freezes when saving table with AFTER INSERT or UPDATE

Again, Alexandre Neto Sent with Shortwave <https://www.shortwave.com?utm_medium=email&utm_content=signature&utm_source=c2VuaG9yLm5ldG9AZ21haWwuY29t> On Thu Jan 4, 2024, 11:45 AM GMT, Nicolas Ribot <mailto:nicolas.ri...@gmail.com> wrote: > Hello, > > A trigger is exec

[postgis-users] QGIS freezes when saving table with AFTER INSERT or UPDATE

feature to be commit. Is this expected for a AFTER INSERT OR UPDATE trigger? Shouldn't PostgreSQL commit the changes, inform QGIS that the operation was successful and only then execute the trigger? Thanks, Alexandre Neto Sent with Shortwave <https://www.shortwave.com?utm_medium=email&

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

On November 7, 2023 12:40:47 PM GMT+01:00, Alexandre Neto > wrote: >> Hi Sandro, >> >> Many thanks for your answer, I think that running the clearTopoGeom in the >> trigger function may work, as the idea is do all this inside a before update >> trigger functio

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

Hi Sandro, Many thanks for your answer, I think that running the clearTopoGeom in the trigger function may work, as the idea is do all this inside a before update trigger function row by row, whenever the original geometry is changed. Thanks, Alexandre Neto On Tue Nov 7, 2023, 11:33 AM GMT

[postgis-users] Topology - RemoveUnusedPrimitives workflow

Hi, I am trying to use the RemoveUnusedPrimitives function to clean up my topology and clean unnecessary primitives in the following (not working) way. I have created a topology using SELECT createtopology('master_topology', 3763); To an existing linestring table I have added a topogeometry co

Re: [postgis-users] st_intersection of 3D objects

e first geometry Z values prevails. SELECT st_intersection('LINESTRINGZ(0 0 5, 5 5 5, 10 10 5)'::geometry, 'LINESTRINGZ(0 10 0, 5 5 0, 10 0 0)'::geometry) POINT Z(5 5 5) Alexandre Neto On Fri Apr 28, 2023, 03:54 AM GMT, Mike Taves <mailto:mwto...@gmail.com> wrote: > On Fri,

[postgis-users] st_intersection of 3D objects

Hi, PostGIS documentation for the st_intersection states the following > If working with 3D geometries, you may want to use SFGCAL based > ST_3DIntersection which > does a proper 3D intersection f

Re: [postgis-users] Free Online or Cloud PostGreSQL and PostGIS

https://www.crunchydata.com/developers/playground, maybe? A sexta, 31/03/2023, 19:59, Tahir Tamba escreveu: > Hi, > Is there a free PostgreSQL or PostGIS environment online or in the cloud > allowing beginners to access the PostgreSQL and PostGIS server for learning > purposes with the possibili

Re: [postgis-users] No extension

Did you uninstall PostgreSQL 13? A sexta, 30/09/2022, 04:08, Simon SPDBA Greener escreveu: > I decided to switch the port back to 5432 following your recipe (because > I have many apps that access postgresql). > > I can connect using qGIS/pgAdmin 4 etc but when I try to connect using > GeoServer

Re: [postgis-users] DE-9IM pattern string for end of a line meeting start of another line

I would work with ST_startpoint and ST_endpoint A segunda, 9/05/2022, 20:05, Martin Davis escreveu: > The DE-9IM model isn't able to express line direction. > > On Mon, May 9, 2022 at 11:42 AM Shaozhong SHI > wrote: > >> The DE-9IM pattern string for two lines meeting at both end is found to >>

Re: [postgis-users] How long does iteration over 4-5 million rows usually take?

It really depends on many factors, but mainly of what you are trying to do. Can you explain what you are trying to do, can you share your query and data structure? On Sat Apr 2, 2022, 01:33 AM GMT, Shaozhong SHI wrote: I have a script running to iterate over 4-5 million rows. It keeps showing u

Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

for this type of work , and was quite useful too. Alexandre Neto A terça, 1/03/2022, 21:34, Shaozhong SHI escreveu: > > > On Tue, 1 Mar 2022 at 18:02, Giuseppe Broccolo > wrote: > >> Hi, >> >> On Tue, 1 Mar 2022, 12:55 Shaozhong SHI, wrote: >> >&g

Re: [postgis-users] Does ArcGIS 2.7 Pro work with PostgreSQL 13 / PostGIS 3.1

I have this question for years... Never got a straight answer. Is it possible to edit PostGIS tables/geometries using ArcGIS? (Without converting into the proprietary geometry type) If so, what license level is needed? Thanks, Alexandre Neto A sábado, 22/05/2021, 12:29, Marco Boeringa

Re: [postgis-users] ST_3dintersects returns false for linestrings pairs with touching vertex

Hi Nicklas, Sorry, I just saw this now. I am glad I was not crazy :-p Thanks for your work. Alexandre Neto A sexta, 13/11/2020, 12:41, Nicklas Avén escreveu: > I filed a ticket and a Merge Request > > > https://trac.osgeo.org/postgis/ticket/4790 > > > > ATB > >

[postgis-users] ST_3dintersects returns false for linestrings pairs with touching vertex

.5032 148.9768,-27975.4229 -110210.9441 149.0093)'), st_geometryfromtext('LINESTRING Z (-28001.1829 -110201.8973 149.4396,-28000.3665 -110199.7073 149.3765,-27995.4183 -110201.8041 149.3354,-27975.4229 -110210.9441 149.0093)')) Any idea what could be happening in here? Tha

Re: [postgis-users] breake lines

Hello Paul, It seems that, at least, one geometry in the data table is not correctly defined. Use this to confirm: SELECT geom, ST_Geometrytype(geom) FROM data; Best regards, Alexandre Neto QGIS/PostGIS Support www.cooperative.net On Tue, Oct 27, 2020 at 9:40 AM wrote: > > > H

[postgis-users] St_snaptogrid doesn't seem to snap all the time.

.1497 44.1234004,-30231.22340003 267132.8641 44.0588005,-30228.5936 267137.1744 43.9301,-30225.9381| I found this old bug report, but I wonder if there's a workaround for it. https://trac.osgeo.org/postgis/ticket/3929 Thanks, Alex

Re: [postgis-users] Ideas for 3D snapping for linestrings

Never mind, It seems that, despite not saying in the documentation, ST_SNAP will also snap vertexes to the Z value of the reference feature. The only thing that is not taken into consideration is the 3D distance for the tolerance, which seems to be planimetric. Thanks Alexandre Neto On Wed

[postgis-users] Ideas for 3D snapping for linestrings

that have the same XY? Thanks, Alexandre Neto Now, I also need to do it in 3D, any ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] Doubt about toTopoGeom tolerance

gical error there even if it's 0.01 m. I think I have a query for that somewhere. Some time ago I was planning to do a blog post about it, but it never came out. Let me see if I can find it. Alexandre Neto A quarta, 1/07/2020, 17:05, Alexandre Silva escreveu: > Hi, > > Sorr

Re: [postgis-users] Doubt about toTopoGeom tolerance

Hi, I am not sure I understood your affirmation. wanting to snap to the nearest edge, its the same as using a very large tolerance. Alexandre Neto On Wed, Jul 1, 2020 at 3:47 PM Alexandre Silva < amsi...@infoportugal.impresa.pt> wrote: > Hi, > > Thank you for your response.

Re: [postgis-users] Doubt about toTopoGeom tolerance

: UPDATE lines_table SET topo = topology.toTopoGeom(geom, clearTopoGeom(topo), 0.1) WHERE id = 1263; http://postgis.net/docs/manual-dev/toTopoGeom.html Good luck, Alexandre Neto On Mon, Jun 29, 2020 at 5:53 PM Alexandre Silva < amsi...@infoportugal.impresa.pt> wrote: > Hi, > > I have t

Re: [postgis-users] Postgis spatial join display error

have a unique id column, it's suggested that it's the first column, so that QGIS pick it up automatically. Alexandre Neto A terça, 28/04/2020, 17:51, Simon Norris escreveu: > Also, the DB manager insists on a unique key per feature. > If there is more than one station per neighbourh

Re: [postgis-users] Overlap analysis / polygonize precision problem

Fri, Mar 27, 2020 at 4:08 PM Alexandre Neto wrote: > Hi, > > I finally got to test this situation a bit more. The culprit seems to be > the Union process: > > with this to get all rings from the polygons, and which return their > linestrings in full precision: > &g

Re: [postgis-users] Overlap analysis / polygonize precision problem

geom FROM isolated_polygons ); create materialized view boundaries3 as ( SELECT ST_MemUnion(geom) AS geom FROM isolated_polygons ); BTW, my data is in EPSG:4326 I am now trying to convert data to another EPSG, to see what happens. Thanks, Alexandre Neto On Tue, Mar 17, 2020 at 4:19 PM

Re: [postgis-users] Overlap analysis / polygonize precision problem

ach query > and doing a "SELECT * FROM cte_tbl" . Then post the results here if you > need help analyzing them, and so we can investigate further. > > Even better would be to provide the dataset which is causing the problem, > to aid in sorting this out. > > On Mon

[postgis-users] Overlap analysis / polygonize precision problem

-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit POSTGIS="2.5.3 r17699" [EXTENSION] PGSQL="100" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" LIBXML="2.9.4"

Re: [postgis-users] st_union

Uhmmm... So, if there's no join or where clause, the index is not used at all? Somehow, I thought that internally ST_union would still use it to decide which geometries need be merged together in the same part. Thanks for clarifying. Alexandre Neto A segunda, 2/03/2020, 22:02, Paul R

Re: [postgis-users] st_union

Stating the obvious, Do you have a spatial index on your geom column? Alexandre Neto A segunda, 2/03/2020, 17:04, Paul Ramsey escreveu: > No, if it’s returning the answer you want, that’s the way to do it, and > there’s no way around it. > > > On Mar 2, 2020, at 6:25 AM, wr

Re: [postgis-users] help with a SQL Command

m, b.geom) THEN ST_Split(a.the_geom, b.geom) ELSE a.the_geom END as geom1 FROM shifted AS a, blade AS b ) SELECT *, (St_dump(geom1)),geom as geom Alexandre Neto Support team www.qcooperative.net @alexnetogeo A quinta, 13/02/2020, 13:55, escreveu: > Hi list! &g

Re: [postgis-users] Replacement for Oracle's TRANSFORM_LAYER procedure?

n error, please notify the sender > immediately by return email and destroy all copies of the email (and > attachments if any). > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailm

Re: [postgis-users] splitting a linestring with points

/mailman/listinfo/postgis-users > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > > --- > L'absence de virus dans ce cour

Re: [postgis-users] [Question] Point returned in ST_LineLocatePoint and ST_ClosestPoint is not able to detect in ST_Contains

The 0.1 value is in your coordinate system units. From your example it's probably degrees and not meters. Alexandre Neto Em qua, 30 de set de 2015 às 13:29, Dharshan Bharathur < dharshan4h...@gmail.com> escreveu: > Thanks for the reply, > > Yes, I tried with ST_DWith

Re: [postgis-users] function trigger to populate values based on spatial relationships

Hello Pietro On Tue, Oct 14, 2014 at 12:39 PM, Pietro Rossin wrote: > > If I try to add values from QGis 2.4 I don't get any message but no value > is > added.. > Where is my mistake?? > If you add values outside QGIS, does it work? Because the TRIGGER will only be triggered after you save your

Re: [postgis-users] Problem using ST_snap

he documentation says nothing about the use of geometry collections, maybe that's the problem? Thanks, Alexandre Neto On Wed, Sep 24, 2014 at 12:46 PM, Rémi Cura wrote: > Hey, > snap is deceiptively named. > As far as I know It just snaps points to points (or points in geome

[postgis-users] Problem using ST_snap

as geom FROM table_1 as f ) SELECT r.gid, st_snap(r.geom,q.geom,10) as geom FROM table2 as r, snap_grid as q WHERE r.gid = 53 I already tried dumping all point form the table 1 polygons, but the result is "similar". Thanks in advance, Alexandre Neto _

Re: [postgis-users] PG 2.0 to add table with heterogeneous geometry in QGIS

. Hope it helps, Alexandre Neto 2014-08-01 12:03 GMT+01:00 Preuß, Sylvia : > Hello Alexandre, > > > > thanks for your hint, but I can‘ t put Polygons into a Multipolygon - > table. When I try to insert the records into the table I get the message: > > > > FEHLER:

Re: [postgis-users] PG 2.0 to add table with heterogeneous geometry in QGIS

you can put polygons inside a multipolygon geometry. I would not even call it heterogeneous. You just need to use: the_geom geometry (multipolygon,25823). Hope it helps, Alexandre Neto Em 31/07/2014 12:46, "Preuß, Sylvia" escreveu: > Hi, > > > > I tried with and wit

Re: [postgis-users] Versioning system to use with QGIS + Postgis

014 00:28, Alexandre Neto ha scritto: > > > I already knew about pgversion, but I haven't been able to see its code > > http://plugins.qgis.org/plugins/pgversion/ > > https://www.kappasys.ch/svn/pgversion/trunk/ Paolo, thank you for the links. I have tried to find this before,

Re: [postgis-users] Versioning system to use with QGIS + Postgis

Hello José, I already knew about pgversion, but I haven't been able to see its code or use the plugin. Do you know if it is still working? Thanks, Alexandre Neto Em 05/06/2014 18:01, "José Carlos Martínez Llario" escreveu: > Hi, > pgversion is a nice approach and there

Re: [postgis-users] Versioning system to use with QGIS + Postgis

I forgot the link: https://github.com/SrNetoChan/PGHP/blob/master/new_versioning_system.sql Alexandre Neto On Thu, Jun 5, 2014 at 5:43 PM, Alexandre Neto wrote: > Hello all, > > I have been working on a versioning system to be used with QGIS. > > This is probably a very naive

[postgis-users] Versioning system to use with QGIS + Postgis

prove two things: 1 - Keep always the same primary key of features; 2 - Only save\backup changed columns instead of the full similar rows; Thanks for your help Alexandre Neto ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osge

[postgis-users] Problems with an update query

rd was the fact that if I manual set gid = x from [1,10] none of the queries toke more that 400ms to perform. Therefore, I must do something wrong for sure! Thank you for your help, Alexandre Neto ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] mulitpolygon with type set to geometry(Geometry, 4326)

Hello Jason, All you need to cast a geometry as other more restrict geometry type is: *st_centroid(report_geom)::geometry(POINT,4326)* Hope this helps Alexandre Neto On Thu, May 8, 2014 at 9:49 PM, Jason Mathis wrote: > Hello, > > I am fairly new to postgis so it would be great i

Re: [postgis-users] Query performance really slow..

not wrong, && operator check if the boundary boxes of two features interect, but if you are using indexes in both columns St_Intersects will preform the same with the boundaries before doing it with the real geometries. Alexandre Neto On Thu, Mar 13, 2014 at 2:42 PM,

Re: [postgis-users] Saving a split polygon

he PK field, or this will give you a bad time. Just leave it blank, during the save\commit, both QGIS and Postgres will know what do do with it. Not sure where all this knowledge came from, but have a look here: http://www.postgresql.org/docs/9.1/static/functions-sequence.html Best regards, Alexa

Re: [postgis-users] Saving a split polygon

Hello, I'm not sure If I followed your question, but in my experience with QGIS editing Postgres\postgis spatial tables, I add some smal hickups, but never with splitting. If its a normal polygon and you wish to split it with a line, QGIS will assign to all your new polygons a nextval('yourtable_

Re: [postgis-users] Query PLanning for spatial containment

plain the difference? Best regards, Alexandre Neto No dia 29 de Ago de 2013 20:11, "Burgholzer, Robert (DEQ)" < robert.burghol...@deq.virginia.gov> escreveu: > I just noticed something interesting, perhaps its trivial and well > understood, but this is the first time I figure

Re: [postgis-users] 10 GB Raster Aerial Image in Quantum and POSTGIS

Try the QGIS User list . Whats your platform? Are you using windows? Best regards, Alexandre Neto On Tue, Aug 27, 2013 at 4:25 PM, Omer Saeed wrote: > Hello there, > I have a problem... I have been successful in uploading the raster in > postgis but when I access it through Qgis

Re: [postgis-users] Newbie having trouble with Multipolygon file and ST_Within

/some-objects-missing-after-importing-a-shp-into-postgis Hope it helps, Alexandre Neto On Tue, Jun 25, 2013 at 6:44 PM, willemb wrote: > I have imported a multipolygon shape file into postgis 2. When I look at > the > table I see that only a few of the areas are showing a value in

Re: [postgis-users] How to improve query with repeated spatial joinquery

xandre Neto On Fri, May 3, 2013 at 11:55 AM, Alexandre Neto wrote: > Hi! > > Thanks for the hint, I will try to use it and to understand what it is > doing. > > Alexandre Neto > > On Fri, May 3, 2013 at 11:32 AM, Hugues François < > hugues.franc...@irstea.fr> wrot

Re: [postgis-users] How to improve query with repeated spatial joinquery

Hi! Thanks for the hint, I will try to use it and to understand what it is doing. Alexandre Neto On Fri, May 3, 2013 at 11:32 AM, Hugues François wrote: > ** > Hello, > > I think over() can help you. You should try something like the query below > : > > select b.gid, volu

Re: [postgis-users] How to improve query with repeated spatial join query

adapt the query a bit to make it more obvious here, and forgot those two. It should be ST_CONTAIN(p.geom, ST_CENTROID(b.geom)) > Jo > > > > 2013/5/3 Alexandre Neto > >> Hello all, >> >> My goal is to calculate for each building it's volume >> perce

[postgis-users] How to improve query with repeated spatial join query

eatly appreciate if someone give me some advice about it. Thanks, Alexandre Neto --- SELECT b.gid, b.volume / t.total_volume as vol_per, b.geom, p.bgri11 as bgri11, FROM buildings as b, stat_parcels as p, (SELECT sum(b.volume) as total_volume, p.bgri11 as bgri11 FROM buildings