how to use Shape in FileGDBAPI.table search whereclause

Question

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.

LiChou · Answer

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.

JoshuaBixby · Answer

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.