[postgis-users] Best settings for a big clusterdbscan

I need to cluster a few million points at once. Can anyone advise on what hardware and database settings would be best? I'm eventually going to be running this on AWS. Thanks Alex ⁣Get BlueMail for Android ​___ postgis-users mailing list

Re: [postgis-users] Solar azimuth calculator

The reason is that I need special permission to use this at my company since it is not part of the standard package. Technically there is no issue. ⁣Get BlueMail for Android ​ On Apr 18, 2021, 10:27 AM, at 10:27 AM, Bruce Rindahl wrote: >As an added bonus putting it in the wiki makes bug

Re: [postgis-users] Solar azimuth calculator

Can this be added as a native function to Postgresql or postGIS? I'm getting a lot of requests for this data. Thanks Alex ⁣Get BlueMail for Android ​ On Apr 17, 2021, 1:57 PM, at 1:57 PM, Alexander Gataric wrote: >Thanks! > >⁣Get BlueMail for Android ​ > >On Apr 17, 2021, 9:12

Re: [postgis-users] Solar azimuth calculator

Thanks! ⁣Get BlueMail for Android ​ On Apr 17, 2021, 9:12 AM, at 9:12 AM, Bruce Rindahl wrote: >Here it is in psql. Doesn't need PostGIS. Fun little exercise. > > >CREATE OR REPLACE FUNCTION public.solarazelev( > >obs_time timestamp with time zone, > >latitude numeric, > >

[postgis-users] Solar azimuth calculator

Does anyone have the SQL for PostGIS to calculate the solar azimuth and elevation for a time and point? Thanks ⁣Get BlueMail for Android ​ On Apr 12, 2021, 8:38 AM, at 8:38 AM, "Palacios García Cuevas, Elena" wrote: >Thank you Martin. With ST_ReducePrecision I got the expected result. >The

[postgis-users] Source code for st_simplify

I'd like to create a customized version of st_simplify. Is there a way to get the source code for this? Is it in C or SQL? Thanks Alex ⁣Get BlueMail for Android ​___ postgis-users mailing list postgis-users@lists.osgeo.org

Re: [postgis-users] Forcibly parallelizing very expensive st_unaryunion in sequential scan on 20 row MultiLineString Table

Have you tried st_linemerge to combine the linestrings? ⁣Get BlueMail for Android ​ On Nov 26, 2020, 2:20 PM, at 2:20 PM, Andrew Joseph wrote: >I need to union chunks of MultiLineString together efficiently before >feeding each chunk to st_polygonize. I know that the st_union aggregate

Re: [postgis-users] Any good examples for cutting line and polygon features neatly with a boundary/polygon?

I use st_exteriorring to turn a polygon into a cookie cutter line. ⁣Get BlueMail for Android ​ On Oct 28, 2020, 2:22 PM, at 2:22 PM, Shaozhong SHI wrote: >Any example for cookie-cut line and polygon features neatly with a >boundary/polygon? > >Regards, > >David > >

Re: [postgis-users] Setting multiple columns in one UPDATE request

t is part of UPDATE in >PostgreSQL?: > >https://www.postgresql.org/docs/12/sql-update.html > >It would have been nice to see an example of such usage in the >PostgreSQL help, but I'll figure it out. > >Marco > >Op 27-9-2020 om 13:59 schreef Alexander Gataric:

Re: [postgis-users] Running raster2pgsql on AWS

r best bet is just to >run the tools from within a docker container. Unfortunately I think >all the packages that have raster2pgsql install the whole PostgreSQL >service. > > > >From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On >Behalf Of Alexander Gat

Re: [postgis-users] st_collect et st_union - multipart geometry

Have you tried st_linemerge on the collection? ⁣Get BlueMail for Android ​ On Jun 26, 2020, 8:29 AM, at 8:29 AM, Guillaume ARNAUD wrote: >Hello, > > From a series of continuous lines, I must join them to have only one. >With St_collect or st_union, it joins the lines in any direction and

[postgis-users] Running raster2pgsql on AWS

I want to run command line Postgres tools directly on AWS. What is the best approach for this? I know how to access AWS Postgres via psql on my machine and connecting to the host. On Jun 18, 2020, 12:18 PM, at 12:18 PM, Regina Obe wrote: >You are probably installing into a newer version of

Re: [postgis-users] query a certain row from a table.

Write a query using predicate ST_IsValid(geom_column) is false ⁣Get BlueMail for Android ​ On Mar 21, 2020, 10:06 AM, at 10:06 AM, John Polo wrote: >They are stored as Point. One per row. > > > >On Saturday, March 21, 2020, Alexander Gataric wrote: > >> What form

Re: [postgis-users] query a certain row from a table.

What format are the points stored in? Point, multipoint? How many points per row? ⁣Get BlueMail for Android ​ On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo wrote: >Hi, > >I'm trying to export a table of points to a shapefile. The table has >over 8,000,000 rows. I'm using PostGIS 3.0 and

Re: [postgis-users] PostGIS functions not working on AWS via Lambda function

ly qualified names of the functions in your UDF. > >Giuseppe. > >Il giorno mar 17 mar 2020 alle ore 18:16 Alexander Gataric > >ha scritto: > >> It says the extension already exists. >> >> Get BlueMail for Android <http://www.bluemail.me/r?b=15824> >

Re: [postgis-users] PostGIS functions not working on AWS via Lambda function

is extension with > >cur.execute("CREATE EXTENSION postgis") > >then try to run your UDF. > >Giuseppe. > >Il giorno mar 17 mar 2020 alle ore 14:38 Alexander Gataric > >ha scritto: > >> I get the same error message as if PostGIS isn't installed. Function >

Re: [postgis-users] PostGIS functions not working on AWS via Lambda function

but AFAIK AWS lambda runs on preconfigured RDS >environments, >maybe it's just enough to include the CREATE EXTENSION. > >Giuseppe. > >Il giorno mar 17 mar 2020 alle ore 12:55 Alexander Gataric > >ha scritto: > >> I'm trying to create a service to invoke Postgres UDFs tha

[postgis-users] PostGIS functions not working on AWS via Lambda function

I'm trying to create a service to invoke Postgres UDFs that utilize PostGIS functions via an AWS lambda function. The error I get is as if the PostGIS extension is not installed. Has anyone encountered this before? Thanks Alex ___ postgis-users mailing

Re: [postgis-users] Inconsistent results on ST_Intersects and ST_Distance

You could also try st_disjoint or st_touches. ⁣Get BlueMail for Android ​ On Feb 26, 2020, 10:07 AM, at 10:07 AM, Paul Ramsey wrote: > > >> On Feb 26, 2020, at 2:02 AM, Palmetzhofer Dietmar > wrote: >> >> I have a simple LINE-Geometry and a POINT, that I want to query, if >it intersects the

[postgis-users] AWS RDS performance

I've been using PostGIS on AWS with low CPU utilization. I tried 11.6 and 10.11 and RDS size db.m5.2xlarge (8 vCPU, 32 GB). Any suggestions? Performance is not what I'd expect from a box with those specs. ⁣Get BlueMail for Android ​ On Feb 25, 2020, 10:34 AM, at 10:34 AM, Alexander Gataric

Re: [postgis-users] Performance Postgres12/Postgis3 vs Postgres10/Postgis2.4

What parameter file settings are you using? I got low CPU utilization on 11.6 with postgis 2.4. ⁣Get BlueMail for Android ​ On Feb 25, 2020, 3:31 AM, at 3:31 AM, Stefan Duling wrote: >Sorry there is a major typor in my previous mail with the postgres >version. Each time i wrote 10.4 it has to

Re: [postgis-users] Custom st_simplify function

gt; >Might need to use in conjunction with ST_Union() > > > > > >On Sat, 15 Feb 2020 at 18:44, Alexander Gataric >wrote: > >> I mean if a line is one mile long and is simplified into five 1000 >foot >> segments, I want the longest segment to be 500 feet in

Re: [postgis-users] Custom st_simplify function

til there are no segments of >length >greater than the maximum? (Presumably excluding input segments already >longer?) > >On Fri, Feb 14, 2020, 1:57 PM Alexander Gataric >wrote: > >> Is there a way to modify st_simplify to have a maximum segment >length? I >> want to be

[postgis-users] Custom st_simplify function

Is there a way to modify st_simplify to have a maximum segment length? I want to be able to limit it to 500 feet. ⁣Get BlueMail for Android ​ On Feb 14, 2020, 1:13 PM, at 1:13 PM, Regina Obe wrote: >gdal_translate does not have a PostGIS raster writer (or at least not >last time I checked).