Skip to content

Instantly share code, notes, and snippets.

@giobel
Last active July 16, 2019 06:25
Show Gist options
  • Save giobel/09519582b8f5e3280c2be43ca622a6c8 to your computer and use it in GitHub Desktop.
Save giobel/09519582b8f5e3280c2be43ca622a6c8 to your computer and use it in GitHub Desktop.
# Collection of SQL queries to use with Metamorphosis addin
select _objects_id.id, _objects_id.external_id, _objects_id.category,_objects_id.isType, _objects_geom.BoundingBoxMax, _objects_geom.BoundingBoxMin
from _objects_geom
join _objects_id
on _objects_geom.id = _objects_id.id
select category, count(category)
from _objects_id
where isType = 0
group by category
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment