topic Re: how to use Shape in FileGDBAPI.table search whereclause in File Geodatabase API Questions

how to use Shape in FileGDBAPI.table search whereclause

LiChou — Thu, 02 Mar 2017 17:34:42 GMT

hi, I am new to GIS and also FileGDBAPI C. I am trying to query the geodatabase using Point's x, y, z . I can't find in anywhere for the format of using Shape in where clause or is it possible to use Table.Search to query geodatabase? Thanks.

Re: how to use Shape in FileGDBAPI.table search whereclause

JoshuaBixby — Fri, 03 Mar 2017 03:43:03 GMT

See Using the File Geodatabase API from the 2015 DevSummit proceedings:

Perform attribute and (limited) spatial queries on datasets
Spatial queries are limited to the envelope-intersects operator

Although I am not exactly clear what you are trying to do, I am under the impression it isn't going to work. If doing an envelope-intersects operator will suffice for your needs, the envelope can be defined and passed to the table search function along with your whereClause.

Re: how to use Shape in FileGDBAPI.table search whereclause

LiChou — Fri, 03 Mar 2017 14:43:27 GMT

hi Joshua, thank you for your reply.

I am trying to export our gis data from our sqlite db to the geodatabase. Both databases have the same points coordinates info, and I need to query the geodatabase to get the OBJECTID in order to update its gis data. I assume I need to do something like

SELECT OBJECTID FROM coord WHERE coord.Shape = '(x, y)';

I am not sure what envelope-interset operator, but I will look up.

The Using the File Geodatabase API is half white out, so I can't read.

Thank you.