Re: [postgis-users] https://postgis.net/docs/geometry_distance_knn.html and index usage

and g2 and > that did not make any difference. > > Tested also with big workmem (1000 MB ) and the result was the same. > > I am running on POSTGIS="3.3.0dev 3.1.0alpha2-1532-gc8eedf3ae" > [EXTENSION] PGSQL="120" GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" > LIBXML="2.9.10"

[postgis-users] problem trying to compile postgis 3.2.1 on Mac arm64

nst", referenced from: std::__1::__vector_base, std::__1::allocator > >::__throw_length_error() const in libflatgeobuf.la(flatgeobuf_c.o) cheers Ben -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director

Re: [postgis-users] PostGIS generic dumper/loader

gt; Thanks! > > Diego > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing D

[postgis-users] Order of linestrings when using st_linemerge

15.9769961743295,106.663050248418 -5.99905605734687 16))'))); cheers Ben -- Ben Madin BVMS PhD m : +61 448 887 220 e : b...@ausvet.com.au 5 Shuffrey Street, Fremantle Western Australia on the web: www.ausvet.com.au This transmission is for the intended addressee only and is confidential

Re: [postgis-users] TR: strange behavior of ST_Area(geography)

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

Re: [postgis-users] Create trigger latitude and longitude

tell me how I should create a trigger for > this? > > Thanks, > > Rafael > > > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Dr

Re: [postgis-users] PostGIS export - data is inexplicably truncated from 3234 records to 3221 when using 'pgsql2shp', PGAdmin, AND QGIS 2.6+

) Feature geometry not imported (OGR error: ) >> Feature geometry not imported (OGR error: ) *Only 3221 of 3234 >> features written.* >> >> Export Using PostGIS 2.0 Shapefile and DBF Loader Exporter >> >> *3221 record counts* >> >> Exporting with configuration: as_clean_test_ogr_export_utf8, public,

[postgis-users] Problem extracting SQL Server Geometry (or, what is the 0x character?)

G'day all, I hope a simple case of something I've missed, but we are trying to extract data from a SQL Server database into PostGIS use tds_fdw... the data in SQL Server appears to be in WKB - but when when connect to this field we have a precursor 0x. I can't find any references to anyone else

Re: [postgis-users] Fw: Mapserver displays an empty map using layer from postgis

/postgis-users -- Ben Madin BVMS PhD, MANZCVS t : +61 8 6102 5535 m : +61 448 887 220 e : b...@ausvet.com.au AusVet Animal Health Services Western Australia www.ausvet.com.au ___ postgis-users mailing list postgis-users@lists.osgeo.org http

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

mailing listpostgis-users@lists.osgeo.orghttp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Ben Madin BVMS

Re: [postgis-users] Trouble installing PostGIS using MacOSx

___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Ben Madin BVMS PhD, MANZCVS t : +61 8 6102 5535 m : +61 448 887 220 e : b...@ausvet.com.au AusVet Animal Health Services

Re: [postgis-users] export

-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Ben Madin BVMS PhD, MANZCVS t : +61 8 6102 5535 m : +61 448 887 220 e : b...@ausvet.com.au AusVet Animal Health Services Western Australia www.ausvet.com.au

Re: [postgis-users] postgis_full_version error

___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Ben Madin ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis

Re: [postgis-users] Geoportal Server vs Postgres Geoportal

of geometries? And don't use esri geoportal server? Thanks! -Nicholas ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Ben Madin t : +61 8 6102 5535 m : +61 448