20220123
19313400
1.0
TRUE
20220418
110633
150000000
5000
ItemDescription
withheld
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The geographic scale references the KBS’s NHF, which consists of hexagons nested within each other. The selected option will be the geographic output layer of this tool. The selectable options (from largest to smallest) includes:Hexagon = 1 squared kilometerCog = 7 squared kilometersWheel = 49 squared kilometersRing = 343 squared kilometers</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The selection statement (based on the SQL where clause) will query the NHF and LDSB dataset and produce an NHF and LDSB sub-datasets. Only results that match the SQL query will be created as outputs.The selection statement should follow this format “Dataset: [LSDB Table] | Query: [SQL Where Clause].” The dataset is the LSDB table to query from, and the SQL Where Clause is the query that will be applied to the dataset. Below is an example. Example: Dataset: Landscape and Habitat | Query: description = Percent Water AND number >1 AND number < 10The selectable tables and queryable attribute fields can be found in the associated LDSB Query Tool Summary document. The SQL Where Clause supports the “OR” and “AND” conjunctions, though both cannot be used in the same selection statement. Additionally, the SQL Where Clauses supports the following operators [=, >, <, >=, <=, !=, LIKE, NOT LIKE, IS, IS NOT].Any invalid selection statements such as referencing tables that do not exist, attribute fields not apart available in the referenced tables, or selection statements not following proper format will generate an error in the tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>If turned on, this Boolean will invert the associated selection statement. In other words, the data that does not meet the query requirements will be the output of this tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The selection statement (based on the SQL where clause) will query the NHF and LDSB dataset and produce an NHF and LDSB sub-datasets. Only results that match the SQL query will be created as outputs.The selection statement should follow this format “Dataset: [LSDB Table] | Query: [SQL Where Clause].” The dataset is the LSDB table to query from, and the SQL Where Clause is the query that will be applied to the dataset. Below is an example. Example: Dataset: Landscape and Habitat | Query: description = Percent Water AND number >1 AND number < 10The selectable tables and queryable attribute fields can be found in the associated LDSB Query Tool Summary document. The SQL Where Clause supports the “OR” and “AND” conjunctions, though both cannot be used in the same selection statement. Additionally, the SQL Where Clauses supports the following operators [=, >, <, >=, <=, !=, LIKE, NOT LIKE, IS, IS NOT].Any invalid selection statements such as referencing tables that do not exist, attribute fields not apart available in the referenced tables, or selection statements not following proper format will generate an error in the tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>If turned on, this Boolean will invert the associated selection statement. In other words, the data that does not meet the query requirements will be the output of this tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The selection statement (based on the SQL where clause) will query the NHF and LDSB dataset and produce an NHF and LDSB sub-datasets. Only results that match the SQL query will be created as outputs.The selection statement should follow this format “Dataset: [LSDB Table] | Query: [SQL Where Clause].” The dataset is the LSDB table to query from, and the SQL Where Clause is the query that will be applied to the dataset. Below is an example. Example: Dataset: Landscape and Habitat | Query: description = Percent Water AND number >1 AND number < 10The selectable tables and queryable attribute fields can be found in the associated LDSB Query Tool Summary document. The SQL Where Clause supports the “OR” and “AND” conjunctions, though both cannot be used in the same selection statement. Additionally, the SQL Where Clauses supports the following operators [=, >, <, >=, <=, !=, LIKE, NOT LIKE, IS, IS NOT].Any invalid selection statements such as referencing tables that do not exist, attribute fields not apart available in the referenced tables, or selection statements not following proper format will generate an error in the tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>If turned on, this Boolean will invert the associated selection statement. In other words, the data that does not meet the query requirements will be the output of this tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The selection statement (based on the SQL where clause) will query the NHF and LDSB dataset and produce an NHF and LDSB sub-datasets. Only results that match the SQL query will be created as outputs.The selection statement should follow this format “Dataset: [LSDB Table] | Query: [SQL Where Clause].” The dataset is the LSDB table to query from, and the SQL Where Clause is the query that will be applied to the dataset. Below is an example. Example: Dataset: Landscape and Habitat | Query: description = Percent Water AND number >1 AND number < 10The selectable tables and queryable attribute fields can be found in the associated LDSB Query Tool Summary document. The SQL Where Clause supports the “OR” and “AND” conjunctions, though both cannot be used in the same selection statement. Additionally, the SQL Where Clauses supports the following operators [=, >, <, >=, <=, !=, LIKE, NOT LIKE, IS, IS NOT].Any invalid selection statements such as referencing tables that do not exist, attribute fields not apart available in the referenced tables, or selection statements not following proper format will generate an error in the tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>If turned on, this Boolean will invert the associated selection statement. In other words, the data that does not meet the query requirements will be the output of this tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The selection statement (based on the SQL where clause) will query the NHF and LDSB dataset and produce an NHF and LDSB sub-datasets. Only results that match the SQL query will be created as outputs.The selection statement should follow this format “Dataset: [LSDB Table] | Query: [SQL Where Clause].” The dataset is the LSDB table to query from, and the SQL Where Clause is the query that will be applied to the dataset. Below is an example. Example: Dataset: Landscape and Habitat | Query: description = Percent Water AND number >1 AND number < 10The selectable tables and queryable attribute fields can be found in the associated LDSB Query Tool Summary document. The SQL Where Clause supports the “OR” and “AND” conjunctions, though both cannot be used in the same selection statement. Additionally, the SQL Where Clauses supports the following operators [=, >, <, >=, <=, !=, LIKE, NOT LIKE, IS, IS NOT].Any invalid selection statements such as referencing tables that do not exist, attribute fields not apart available in the referenced tables, or selection statements not following proper format will generate an error in the tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>If turned on, this Boolean will invert the associated selection statement. In other words, the data that does not meet the query requirements will be the output of this tool.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>A temporary output geographic layer. The output geographic file will be saved into the output ZIP file.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The output ZIP File is the location where the output files will be saved. The files will be automatically formatted based on the geographic scale selected and the selected tables from the selection statements.The geographic layer will be formatted as: “queried_” + [geographic scale] + [Minute_Hour_Day_Month_Year]Queried Geographic Layer Example: “queried_ring_11_33_08_03_2022.shp”The geographic layer will be formatted as: “queried_” + [Table Name] + [Minute_Hour_Day_Month_Year]Queried Table Example: “queried_landscape_and_habitat_11_33_08_03_2022.csv”</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>The LSDB Query Tool allows users to query data into summary statistics based upon the developed Kansas Biological Survey’s (KBS) nested hexagon framework (NHF) and the Landscape Summary Database (LSDB). The LSDB database contains summaries of data layers of interest to state agencies, private companies, NGO’s, and the public, and is an additive compilation of data layers associated with landscapes, wildlife, energy, weather/climate, and socio-economic data. See the associated LDSB Query Tool Summary for more information.</SPAN></P></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:12pt">This tool can generate geographic layers based upon the nested hexagon framework (NHF) with associated summary statistics from the Landscape Summary Database (LSBD). The user selects a desired geographic scale from the NHF and inputs SQL selection statements for the LDSB formatted as “Dataset: [</SPAN><SPAN STYLE="font-style:italic;font-size:12pt">LSDB Table</SPAN><SPAN STYLE="font-size:12pt">] | Query: [</SPAN><SPAN STYLE="font-style:italic;font-size:12pt">SQL Where Clause</SPAN><SPAN STYLE="font-size:12pt">].” Please use the associated LDSB Query Tool Summary for more information and guidance on using this tool.</SPAN></P></DIV></DIV></DIV>
LSDB Query by Attribute
Landscape Summary Database
LDSB
Nested Hexagon Framework
NHF
Kansas Biological Survey
KBS
Kansas Applied Remote Sensing Program
KARS
Remote Sensing
Summary Statistics
Water
Energy
Land Cover
Solar
Query Tool
Kansas Applied Remote Sensing Programs (KARS) developed this tool as part of the Kansas Biological Survey & Center for Ecological Research (KBS-CER)
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Public Use.</SPAN></P></DIV></DIV></DIV>
ArcToolbox Tool
20220418