 
 and ResourceTypeAcronym!='WEAP'
 
-  /*
+
 and
 -- limit the search to within the specified boundaries
 ("Longitude_x">='-111.648' 
 AND "Longitude_x"<='-110.82'
 AND "Latitude_y_x">='40.712'
 AND "Latitude_y"<='42.848') 
-*/
+
 --
 AND (ObjectTypeCV IN 
 

--They have nodes or links within the specified boundary 
-- the controlled ObjectTypes and Attributes match between WEAP and the other datasets   

SELECT Distinct ObjectTypeCV,ObjectType,ResourceTypeAcronym, AttributeNameCV,AttributeName,InstanceNameCV

--SELECT Distinct ObjectTypeCV, AttributeNameCV
--SELECT COUNT(Distinct ObjectTypeCV) as CountOfObjects,COUNT(Distinct AttributeNameCV) As CountOfAttributes


*/
-- This SELECT statement shows the list of WEAP Objects and their Attributes that have one or many native terms available them that have available data in the datasets
Select Distinct WEAPObjectType ,ObjectTypeCV,ObjectType,ResourceTypeAcronym, WEAPAttributeName,AttributeNameCV,AttributeName_Abstract
--,InstanceNameCV

From 
