Structured Query Language (SQL) queries allow you to select features by using feature attributes. When you choose the feature attributes you want to use in the query, you can then specify a range of values to use to define a selection set for a tool. InArcGIS Production Mapp...
查询用于搜索和选择要素子集和表记录。ArcGIS Pro中所有查询表达式都使用结构化查询语言 (SQL) 对搜索规范进行格式化。 查询构建器用于在多个位置构建查询,包括以下各项: 在按属性选择图层地理处理工具中按属性选择要素 为图层或独立表设置定义查询 设置图层上的显示过滤器 ...
常见查询:搜索字符串 查询中的字符串必须始终用单引号括起,例如: STATE_NAME ='California' 表达式中的字符串区分大小写。 要进行区分大小写的搜索,可使用 SQL 函数将所有值转换为相同的大小写形式。 对于基于文件的数据源(例如地理数据库或 shapefile),可使用 UPPER 或 LOWER 函数设置选择的大小写形式。...
fields : SqlFieldList insertId : object isActive : bool isForwardOnly : bool isPrepared : bool isSelect : bool isValid : bool rowsAffected : int values : object Signals queryChanged() Methods object boundValue(string name) object boundValue(int index) bool execute(string sql, ...) bool...
--SQL Server and PostgreSQL querySELECTrelationships.type,origin_items.nameAS"Origin Name",dest_items.nameAS"Dest Name"FROMgdb_itemsASorigin_items,gdb_itemrelationshipsASrelationships,gdb_itemsASdest_itemsWHEREorigin_items.UUID=relationships.originidANDdest_items.UUID=relationships.destid;--Oracle query...
ArcGIS 中的查询表达式遵循标准 SQL 表达式。 表达式中所使用的 SQL 语法因数据源的不同而有所差异。 每个数据源都有其自己的 SQL 变体,称为 SQL 方言,如下所示:基于文件的数据(包括文件地理数据库、shapefile、内存型表视图、文本文件(如 .dbf、.csv、.txt、.xlsx 表)和使用标准化查询的要素服...
Examples // While this example uses FeatureLayer, this same pattern can be // used for other layers that may be loaded from portalItem ids. const layer = new FeatureLayer({ portalItem: { // autocasts as new PortalItem() id: "caa9bd9da1f4487cb4989824053bb847" } // the first layer...
query query dynamic Spatial reference system srs string Select spatial reference system Returns 展開資料表 NamePathTypeDescription Value of the variable value number Geoenrichment variable value Name of the variable parameterName string The name of the variable that is being analyzed during th...
View examples for existing chart specifications. Bar chart example { "type": "bar", "datasets": [ { "url": "https://services.arcgis.com/uDTUpUPbk8X8mXwl/arcgis/rest/services/Public_Schools_in_Onondaga_County/FeatureServer/0", "name": "Number_of_SUM", "query": { "orderByFields": "...
Click SQL Query to open the Label Class pane. In the Label Class pane, click + New expression. Toggle SQL on. Specify the following expression in the SQL expression text box. Replace <field_name> with the name of the field containing the contour elevation value, and <Interval> ...