how to use Shape in FileGDBAPI.table search whereclause

802
2
03-02-2017 09:34 AM
LiChou
by
New Contributor

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.

0 Kudos
2 Replies
JoshuaBixby
MVP Esteemed Contributor

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.

0 Kudos
LiChou
by
New Contributor

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.

0 Kudos