 --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,DatasetAcronym, AttributeNameCV,AttributeName
+SELECT Distinct ObjectTypeCV,ObjectType,DatasetAcronym, AttributeNameCV,AttributeName,InstanceNameCV
 
 --SELECT Distinct ObjectTypeCV, AttributeNameCV
 --SELECT COUNT(Distinct ObjectTypeCV) as CountOfObjects,COUNT(Distinct AttributeNameCV) As CountOfAttributes

Then they can choose which ones to import to their model 

Adel Abdallah 
Last updated Dec 5, 2017

*/
-- 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,DatasetAcronym, WEAPAttributeName,AttributeNameCV,AttributeName,DatasetAcronym

From 


-- If a native attribute is not registered with a controlled attribute, then exclude the native one 
-- because it has no value as far as it cannot be related to other attributes  
WHERE AttributeNameCV is not null
  /*
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 

