[gdal-dev] Executing a query getting null layer

[jratike80]

andreahmed wrote
> What I'm trying to achieve is to check if 4 points is contained inside the
> polygon, so I'm doing currently that query with SQLite dialect: 
> I'm not sure if its correct or no, I have tried it, but it seems its
> working, I don't have enough data to test it out, so would you check the
> query please ?
> 
> string query = "SELECT * from areas WHERE
> st_contains(ST_BuildArea(areas.GEOMETRY),ST_ConvexHull(ST_GeomFromText('MULTIPOINT(16.17951
> 47.85549, 16.17951 47.85549, 16.17951 47.85549, 16.17951
> 47.85549)',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/gdal-dev-Executing-a-query-getting-null-layer-tp5313639p5313820.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.