giobel · July 16, 2019 06:25
diff --git a/*SQL queries* b/*SQL queries*
 # Collection of SQL queries to use with Metamorphosis addin
diff --git a/combineTables.sql b/combineTables.sql
 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
diff --git a/groupByCategory.sql b/groupByCategory.sql
 select category, count(category)
 from _objects_id
 where isType = 0
 group by category
	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