Gets or sets the name of the column in the Table which stores geometries.
Namespace:
ESRI.ArcGISExplorer.DataAssembly: ESRI.ArcGISExplorer (in ESRI.ArcGISExplorer.dll) Version: 2.0.0.900 (2.0.0.900)
Syntax
| C# |
|---|
public string SpatialColumnName { get; set; } |
| Visual Basic (Declaration) |
|---|
Public Property SpatialColumnName As String |
Field Value
The geometry column name, which is typically called "Shape". ArcSDE feature classes may use a different column name, in which case use SpatialColumnName to return the name of the Column used to store geometries.Examples
The code below create creates a Filter object using the default constructor, sets Geometry,
SpatialSearchType, and SpatialColumnName properties then executes the query using the Table.Search method.
CopyC#CopyVB.NET
CopyC#//Open ArcSDE geodatabase Geodatabase gdb = new Geodatabase(@"C:\Data\SQLServer.sde"); //Open FirePerimeters feature class Table fires = gdb.OpenTable("sde.DBO.FirePerimeters"); //Open Properties feature class Table properties = gdb.OpenTable("sde.DBO.Properties"); //Get a fire polygon by its unique ID Geometry firePoly = fires.GetRow(14).Geometry; //Create the search criteria to find all properties affected by this fire Filter searchCriteria = new Filter(); searchCriteria.Geometry = firePoly; searchCriteria.SpatialSearchType = FilterSearchOptions.Intersects; searchCriteria.SpatialColumnName = properties.Columns.SpatialColumnName; //Execute the query RowCollection rows = properties.Search(searchCriteria);
CopyVB.NET'Open ArcSDE geodatabase Dim gdb As Geodatabase = New Geodatabase("C:\Data\SQLServer.sde") 'Open FirePerimeters feature class Dim fires As Table = gdb.OpenTable("sde.DBO.FirePerimeters") 'Open Properties feature class Dim properties As Table = gdb.OpenTable("sde.DBO.Properties") 'Get a fire polygon by its unique ID Dim firePoly As Geometry = fires.GetRow(14).Geometry 'Create the search criteria to find all properties affected by this fire Dim searchCriteria As Filter = New Filter() searchCriteria.Geometry = firePoly searchCriteria.SpatialSearchType = FilterSearchOptions.Intersects searchCriteria.SpatialColumnName = properties.Columns.SpatialColumnName 'Execute the query Dim rows As RowCollection = properties.Search(searchCriteria)
