Re: [postgis-users] ArcGIS Online without ArcGIS server

2023-09-15 Thread Phil Bartie
ArcGIS online supports WMS, WMTS, and WFS OGC web services. https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm Best, Phil On Fri, 15 Sept 2023 at 16:43, Martin Davis wrote: > It's my educated guess that the answer is no. The AGOL client talks via > web services to the

Re: [postgis-users] Where a full list of DE-9IM pattern can be found for ST_Relate?

2022-03-29 Thread Phil Bartie
Hi David, There are a large number (6561) of theoretical possible relationships between 2 features which can be expressed by DE-9IM. Not sure what you mean by 'type of errors', but from what I understand the DE-9IM is a mathematically complete set of all options for how 2 features can interact.

Re: [postgis-users] Custom st_simplify function

2020-02-15 Thread Phil Bartie
for Android <http://www.bluemail.me/r?b=15774> > On Feb 15, 2020, at 12:50 PM, Phil Bartie wrote: >> >> Would ST_Segmentize() do what you are after? >> Run it after the simplify. >> >> https://postgis.net/docs/ST_Segmentize >> >> Might need to use

Re: [postgis-users] Custom st_simplify function

2020-02-15 Thread Phil Bartie
Would ST_Segmentize() do what you are after? Run it after the simplify. https://postgis.net/docs/ST_Segmentize 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

Re: [postgis-users] [OFF-TOPIC] SQL question

2015-02-19 Thread Phil Bartie
Hi Steve, Does this help? select * from (select gid,item,data, ROW_NUMBER() OVER (Partition by item order by gid) as subid from a) as t1 join (select gid,item,moredata, ROW_NUMBER() OVER (Partition by item order by gid) as subid from b) as t2 on t1.item=t2.item and t1.subid=t2.subid; Cheers