topic REST.api Query in ArcGIS REST APIs and Services Questions

topic REST.api Query in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query/m-p/488704#M2344 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P>I have a query, <SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">using Python</SPAN> that returns all the Map Image layers.</P><P>I am trying to filter the query:</P><P>a) to filter out owner: esri_livingatlas</P><P>b) to filter out title: USA</P><P></P><P><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">If I use != or NOT  for owner, to filter. I get an error??</SPAN></P><P style="background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; min-height: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">I can only use two parameters in the Query??</SPAN></P><P></P><P>Thanks,</P><P></P><P>Clive</P><P></P><P>The code:</P><P></P><DIV>source = GIS(source_portal, source_admin, source_admin_password, verify_cert=False)<BR />print("LOGGED INTO SOURCE")</DIV><DIV></DIV><DIV>title = "*"<BR />owner != "esri*"<BR />content = source.content.search("title:" + title, item_type="Map Image Layer", max_items=500)</DIV><DIV>print("OUTPUT")<BR />for item in content:<BR />    if 'title:' != '*USA*':<BR />        print(item)</DIV><DIV></DIV><DIV>The output:</DIV><DIV></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">START </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">LOGGED INTO SOURCE </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">OUTPUT </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;"><Item title:"National Weather Service Wind Forecast" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Weather Warnings and Watches" type:Map Image Layer owner:esri_livingatlas> <Item title:"National Weather Service Wind Gust Forecast" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Soil Map Units 2014 (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Organic Food Consumption" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Diabetes Medication Users (Non-Insulin)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA 401(k) Retirement Plans" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Diabetes Medication Users (Insulin)" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA USFS Lands (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Clothing/Accessory Store Market Opportunity" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA 401(k) Retirement Plans" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Soils Map Units" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Transportation Fuel Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Child Care Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Online Banking" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Storm Reports" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Hazardous Waste Sites" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Water and Public Services Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA NPS Lands (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Wetlands 2015" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Food Service Market Opportunity" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Per Capita Income" type:Map Image Layer owner:esri_livingatlas> <Item title:"Elevation Coverage Map" type:Map Image Layer owner:esri_livingatlas> </SPAN></DIV></BODY></HTML> Wed, 12 Feb 2020 12:56:08 GMT CliveSwan 2020-02-12T12:56:08Z REST.api Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query/m-p/488704#M2344 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P>I have a query, <SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">using Python</SPAN> that returns all the Map Image layers.</P><P>I am trying to filter the query:</P><P>a) to filter out owner: esri_livingatlas</P><P>b) to filter out title: USA</P><P></P><P><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">If I use != or NOT  for owner, to filter. I get an error??</SPAN></P><P style="background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; min-height: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">I can only use two parameters in the Query??</SPAN></P><P></P><P>Thanks,</P><P></P><P>Clive</P><P></P><P>The code:</P><P></P><DIV>source = GIS(source_portal, source_admin, source_admin_password, verify_cert=False)<BR />print("LOGGED INTO SOURCE")</DIV><DIV></DIV><DIV>title = "*"<BR />owner != "esri*"<BR />content = source.content.search("title:" + title, item_type="Map Image Layer", max_items=500)</DIV><DIV>print("OUTPUT")<BR />for item in content:<BR />    if 'title:' != '*USA*':<BR />        print(item)</DIV><DIV></DIV><DIV>The output:</DIV><DIV></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">START </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">LOGGED INTO SOURCE </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;">OUTPUT </SPAN></DIV><DIV><SPAN style="display: inline !important; float: none; background-color: transparent; color: #000000; font-family: monospace; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 16.94px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: pre-wrap; word-break: break-all; word-spacing: 0px; word-wrap: break-word;"><Item title:"National Weather Service Wind Forecast" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Weather Warnings and Watches" type:Map Image Layer owner:esri_livingatlas> <Item title:"National Weather Service Wind Gust Forecast" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Soil Map Units 2014 (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Organic Food Consumption" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Diabetes Medication Users (Non-Insulin)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA 401(k) Retirement Plans" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Diabetes Medication Users (Insulin)" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA USFS Lands (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Clothing/Accessory Store Market Opportunity" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA 401(k) Retirement Plans" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Soils Map Units" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Transportation Fuel Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Child Care Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"2016 USA Online Banking" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Storm Reports" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Hazardous Waste Sites" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Water and Public Services Spending" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA NPS Lands (Mature Support)" type:Map Image Layer owner:esri_livingatlas> <Item title:"USA Wetlands 2015" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Food Service Market Opportunity" type:Map Image Layer owner:esri_livingatlas> <Item title:"2017 USA Per Capita Income" type:Map Image Layer owner:esri_livingatlas> <Item title:"Elevation Coverage Map" type:Map Image Layer owner:esri_livingatlas> </SPAN></DIV></BODY></HTML> Wed, 12 Feb 2020 12:56:08 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query/m-p/488704#M2344 CliveSwan 2020-02-12T12:56:08Z Re: REST.api Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query/m-p/488705#M2345 <HTML><HEAD></HEAD><BODY><P>I placed the NOT in the variable, this worked..</P><P>It excluded all the esri_ layers</P><P></P><DIV>owner = "* NOT esri"<BR />#content = source.content.search("title:" + title, item_type="Map Image Layer", max_items=500)<BR />content = source.content.search("Owner:" + owner, item_type="Map Image Layer", max_items=500)</DIV><DIV>print("OUTPUT")<BR />for item in content:<BR />    print(item)</DIV></BODY></HTML> Wed, 12 Feb 2020 13:28:05 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query/m-p/488705#M2345 CliveSwan 2020-02-12T13:28:05Z