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

2022-06-22 Thread Ben Madin
ng geography when creating table g1 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&qu

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

2022-05-09 Thread Ben Madin
__throw_length_error() const", 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 MANZCV

Re: [postgis-users] Role of PostgreSQL and PostGIS in disease outbreak control

2020-08-14 Thread Ben Madin
gt; 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 Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...@ausvet.com.

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

2020-02-25 Thread Ben Madin
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 Manag

[postgis-users] Order of linestrings when using st_linemerge

2018-02-12 Thread Ben Madin
89 -6.01184678072196 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

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

2017-10-16 Thread Ben Madin
t; postgis-users mailing list >> > postgis-users@lists.osgeo.org >> > https://lists.osgeo.org/mailman/listinfo/postgis-users >> > >> > >> > --- >> > L'absence de virus dans ce courrier électronique a été vérifiée par le >> logiciel a

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

2017-09-21 Thread Ben Madin
ould 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 Ben Madin Man

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

2016-12-04 Thread Ben Madin
ported (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_u

Re: [postgis-users] Question on performance probably related to detoast and/or bboxes

2016-11-20 Thread Ben Madin
where as > ST_Intersects will often throw up its hands and throw false in your face > regardless how close the geometries are because the DEIM it relies on needs > the geometries to be valid. > > > > Hope that helps, > > Regina > > http://www.postgis.us > > ht

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

2016-10-14 Thread Ben Madin
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 su

Re: [postgis-users] issue loading shapefiles into postgis via batch

2016-08-26 Thread Ben Madin
Rather than putting a password into a plain text file, we prefer to create a user with very limit priviliges - ie can only access one schema and can only create and insert into that schema and read nothing. Then in the pg_hba.conf give that user local access to your database using trust. In realit

Re: [postgis-users] Query/View permission deny - strange behaviour

2016-05-17 Thread Ben Madin
What do you mean: If I select it, both as pippo and as a member of sitarpa_admins, an error rises saying: ERROR: permission denied for relation comuni_fvg_2014_3004 How do you "select" it? Cheers Ben On Monday, 16 May 2016, Pietro Rossin wrote: > Hello, I'm going crazy with this problems..

Re: [postgis-users] Postgis doesn't work after search_path

2015-08-05 Thread Ben Madin
st_union(wkb_geometry) AS wkb_geometry >> > >> > Have you any tips? >> >> show search_path; >> select n.nspname from pg_namespace n, pg_proc p where p.proname = >> 'st_union' and n.oid = p.pronamespace; >> >> --strk; >> >>

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

2015-03-08 Thread Ben Madin
as" > > "ows_extent" " > > -17.9334 30.5019 -17.7303 30.8789" > > END #metadata > > PROJECTION > > "init=epsg:4326" > > END > > CLASS > > NAME "ras" > > OUTLINECOLOR 255 255

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

2015-01-22 Thread Ben Madin
users > > > > _______ > 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...@ausv

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

2014-11-10 Thread Ben Madin
t; directory > > ** Error ** > > > ERROR: could not access file "$libdir/postgis-2.1": No such file or > > directory > > SQL state: 58P01 > > > > > Thanks- Jerry > > > __

Re: [postgis-users] export

2014-10-14 Thread Ben Madin
_ > 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

Re: [postgis-users] postgis_full_version error

2014-10-09 Thread Ben Madin
e two parts: > > 1. do I have / need jts (it is showing geos 3.4.2-CAPI-1.8.2 r3921) ? > > 2. if I don't have it, should it fail completely, or just return NULL ? > > cheers > > Ben > > > ___ > postgis-users mailing list >

[postgis-users] postgis_full_version error

2014-10-09 Thread Ben Madin
untu 12.04 without this problem. I guess there are two parts: 1. do I have / need jts (it is showing geos 3.4.2-CAPI-1.8.2 r3921) ? 2. if I don't have it, should it fail completely, or just return NULL ? cheers Ben -- Ben Madin ___ postgi

Re: [postgis-users] Associate CopyTopology Schema with TopoGeometry

2014-01-05 Thread Ben Madin
/postgis.net/docs/CopyTopology.html > 2: https://gist.github.com/mattmakesmaps/45fe32931cacdf40d107 > > -- > m a t t h e w k e n n y > http://mattmakesmaps.com > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org >

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

2013-12-30 Thread Ben Madin
t I'm talking about now? Are there any > postgres dbs that allow for direct download of geometries? And don't use esri > geoportal server? > > Thanks! > > -Nicholas > > ___ > postgis-users mailing list > post

Re: [postgis-users] pgsql2shp output truncated - work around

2013-12-18 Thread Ben Madin
it also appears to be working a little faster cheers Ben On 2013-12-17, at 15:46 , Ben Madin wrote: > G’day all, > > I’ve been using pgsql2shp to create shape files for a client by creating a > table which contains global level 1 administrative boundaries (3670 records). > W

[postgis-users] pgsql2shp output truncated

2013-12-16 Thread Ben Madin
9" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER Has anyone seen anything similar, any ideas where I can start. cheers Ben -- Ben Madin t : +61 8 6102 5535 m : +61 448 887 220 e : b...@ausvet.com.au AusVet Animal Health