Skip to content

Instantly share code, notes, and snippets.

@Denubis

Denubis/android fetch visible entities

Forked from theeban275/android fetch visible entities
Last active August 29, 2015 14:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Denubis/bce9e1d1c7e9001b6f62 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Denubis/bce9e1d1c7e9001b6f62 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)
join createdModifiedAtBy using (uuid)
WHERE arowid in (SELECT pkid
FROM idx_archentity_geospatialcolumn
WHERE pkid MATCH RTreeIntersects(?, ?, ?, ?)
)
order by createdAt
limit ?;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment