Re: [gdal-dev] Executing a query getting null layer

2017-03-23 Thread jratike80
#x27;,4326)));"; Looks good but I do not have your data. You use ST_BuildArea, does it mean that geometries in areas.GEOMETRY are not polygons? And why all the 4 members in MULTIPOINT and identical? -Jukka Rahkonen- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gda

Re: [gdal-dev] Executing a query getting null layer

2017-03-23 Thread Ahmed Tolba
--- From: gdal-dev [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of jratike80 Sent: Wednesday, March 22, 2017 9:13 PM To: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] Executing a query getting null layer andreahmed wrote > I'm using WFS-T. Does ogrinfo support that ? Can you show me

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread jratike80
with SQLite dialect I would try ST_ConvexHull select ST_AsText( ST_ConvexHull(ST_GeomFromText('MULTIPOINT(0 0, 0 1, 1 1, 1 0)'))) -Jukka Rahkonen- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Executing-a-query-getting-null-layer-tp5313639p5313720.h

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread andreahmed
I'm using WFS-T. Does ogrinfo support that ? Can you show me the full syntax please. I'm beginner in that topic. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Executing-a-query-getting-null-layer-tp5313639p5313704.html Sent from the GDAL - Dev ma

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread jratike80
d say that asking same questions here and in gis.stackexchange usually does not make people to serve you any faster. -Jukka Rahkonen- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Executing-a-query-getting-null-layer-tp5313639p5313687.html Sent from the G

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
Note that m_wfs_t is of type OGRDataSource is that correct ? Ahmed From: Even Rouault [mailto:even.roua...@spatialys.com] Sent: Wednesday, March 22, 2017 3:05 PM To: gdal-dev@lists.osgeo.org Cc: Ahmed Tolba; jratike80 Subject: Re: [gdal-dev] Executing a query getting null layer On mercredi 22

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
dal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Cc: Ahmed Tolba; jratike80 Subject: Re: [gdal-dev] Executing a query getting null layer On mercredi 22 mars 2017 13:58:52 CET Ahmed Tolba wrote: > My data is in mapserver database which is PostGres PostGIS. What's the > e

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
.org Cc: Ahmed Tolba; jratike80 Subject: Re: [gdal-dev] Executing a query getting null layer On mercredi 22 mars 2017 13:58:52 CET Ahmed Tolba wrote: > My data is in mapserver database which is PostGres PostGIS. What's the > equivalent function for st_linefrommultipoint ? Ah ok just put N

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Even Rouault
stgres side. > -Original Message- > From: gdal-dev [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of > jratike80 Sent: Wednesday, March 22, 2017 2:40 PM > To: gdal-dev@lists.osgeo.org > Subject: Re: [gdal-dev] Executing a query getting null layer > > andreahmed wrote >

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
o.org Subject: Re: [gdal-dev] Executing a query getting null layer andreahmed wrote > I replaced OGRSQL with SQLite, It says now > > No such function: st_linefrommultipoint That's no wonder because SpatiaLite does not have such function https://www.gaia-gis.it/gaia-sins/spatial

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread jratike80
IS which has a native support for http://postgis.net/docs/ST_LineFromMultiPoint.html? -Jukka Rahkonen.- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Executing-a-query-getting-null-layer-tp5313639p5313646.html Sent from the GDAL - Dev mailing list archive

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
I replaced OGRSQL with SQLite, It says now No such function: st_linefrommultipoint From: Even Rouault [mailto:even.roua...@spatialys.com] Sent: Wednesday, March 22, 2017 2:30 PM To: gdal-dev@lists.osgeo.org Cc: Ahmed Tolba Subject: Re: [gdal-dev] Executing a query getting null layer On

Re: [gdal-dev] Executing a query getting null layer

2017-03-22 Thread Even Rouault
On mercredi 22 mars 2017 13:12:14 CET Ahmed Tolba wrote: > Hi All, > I'm trying to execute that query > string query = "SELECT *FROM areas WHERE > st_contains(st_polygon(st_addpoint(st_linefrommultipoint(areas.geom),st_sta > rtpoint(st_linefrommultipoint(areas.geom)),-1),st_srid(areas.geom)),st_mpo

[gdal-dev] Executing a query getting null layer

2017-03-22 Thread Ahmed Tolba
Hi All, I'm trying to execute that query string query = "SELECT *FROM areas WHERE st_contains(st_polygon(st_addpoint(st_linefrommultipoint(areas.geom),st_startpoint(st_linefrommultipoint(areas.geom)),-1),st_srid(areas.geom)),st_mpointfromtext('MULTIPOINT(16.17951 47.85549, 16.17951 47.85549, 16.1