Skip to content

Instantly share code, notes, and snippets.

@theeban275

theeban275/android fetch visible entities

Created October 17, 2014 01:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save theeban275/76f4f5322be6fe07d3f6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save theeban275/76f4f5322be6fe07d3f6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
android fetch visible entities
select uuid, response, hex(asbinary(geospatialcolumn))
from latestnondeletedarchentidientifiers join latestnondeletedarchent using (uuid)
WHERE arowid in (SELECT pkid
FROM idx_archentity_geospatialcolumn
WHERE pkid MATCH RTreeIntersects(?, ?, ?, ?))
ORDER BY uuid, attributename ASC, valuetimestamp desc)
GROUP BY limit ?;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment