Skip to content

DelimitedFeatureSource

Namespace: ThinkGeo.Core

public class DelimitedFeatureSource : FeatureSource

Inheritance ObjectFeatureSourceDelimitedFeatureSource

Properties

DelimitedPathFilename

public string DelimitedPathFilename { get; set; }

Property Value

String

XColumnName

public string XColumnName { get; set; }

Property Value

String

YColumnName

public string YColumnName { get; set; }

Property Value

String

WellKnownTextColumnName

public string WellKnownTextColumnName { get; set; }

Property Value

String

Delimiter

public string Delimiter { get; set; }

Property Value

String

SpatialColumnType

public DelimitedSpatialColumnsType SpatialColumnType { get; set; }

Property Value

DelimitedSpatialColumnsType

Encoding

public Encoding Encoding { get; set; }

Property Value

Encoding

RequireIndex

public bool RequireIndex { get; set; }

Property Value

Boolean

IsEditable

public bool IsEditable { get; }

Property Value

Boolean

Id

public string Id { get; }

Property Value

String

CanExecuteSqlQuery

This property specifies whether the FeatureSource can excute a SQL query or not. If it is false, then it will throw exception when these APIs are calleds: ExecuteScalar, ExecuteNonQuery, ExecuteQuery

public bool CanExecuteSqlQuery { get; }

Property Value

Boolean

Remarks:

The default implementation is false.

IsOpen

This property returns true if the FeatureSource is open and false if it is not.

public bool IsOpen { get; }

Property Value

Boolean

Remarks:

Various methods on the FeatureSource require that it be in an open state. If one of those methods is called when the state is not open, then the method will throw an exception. To enter the open state, you must call the FeatureSource's Open method. The method will raise an exception if the current FeatureSource is already open.

Projection

public Projection Projection { get; protected set; }

Property Value

Projection

CanModifyColumnStructure

public bool CanModifyColumnStructure { get; }

Property Value

Boolean

IsInTransaction

This property returns true if the FeatureSource is in a transaction and false if it is not.

public bool IsInTransaction { get; }

Property Value

Boolean

Remarks:

To enter a transaction, you must first call the BeginTransaction method of the FeatureSource. It is possible that some FeatureSources are read-only and do not allow edits. To end a transaction, you must either call CommitTransaction or RollbackTransaction.

IsTransactionLive

This property returns true if the features currently modified in a transaction are expected to reflect their state when calling other methods on the FeatureSource, such as spatial queries.

public bool IsTransactionLive { get; set; }

Property Value

Boolean

Remarks:

The live transaction concept means that all of the modifications you perform during a transaction are live from the standpoint of the querying methods on the object.

As an example, imagine that you have a FeatureSource that has 10 records in it. Next, you begin a transaction and then call GetAllFeatures. The result would be 10 records. After that, you call a delete on one of the records and call the GetAllFeatures again. This time you only get nine records, even though the transaction has not yet been committed. In the same sense, you could have added a new record or modified an existing one and those changes would be considered live, though not committed.

In the case where you modify records -- such as expanding the size of a polygon -- those changes are reflected as well. For example, you expand a polygon by doubling its size and then do a spatial query that would not normally return the smaller record, but instead would return the larger records. In this case, the larger records are returned. You can set this property to be false, as well; in which case, all of the spatially related methods would ignore anything that is currently in the transaction buffer waiting to be committed. In such a case, only after committing the transaction would the FeatureSource reflect the changes.

ProjectionConverter

This property holds the projection object that is used within the FeatureSource to ensure that features inside of the FeatureSource are projected.

public ProjectionConverter ProjectionConverter { get; set; }

Property Value

ProjectionConverter

Remarks:

By default this property is null, meaning that the data being passed back from any methods on the FeatureSource will be in the coordinate system of the raw data. When you specify a projection object in the property, all incoming and outgoing method calls will subject the features to projection.

For example, if the spatial database you are using has all of its data stored in decimal degrees, but you want to see the data in UTM, you would create a projection object that goes from decimal degrees to UTM and set that as the projection. With this one property set, we will ensure that it will seem to you the developer that all of the data in the FeatureSource is in UTM. That means every spatial query will return UTM projected shapes. You can even pass in UTM shapes for the parameters. Internally, we will ensure that the shapes are converted to and from the projection without any intervention on the developer's part.

In fact, even when you override virtual or abstract core methods in the FeatureSource, you will not need to know about projections at all. Simply work with the data in its native coordinate system. We will handle all of the projection at the high level method.

GeoCache

The cache system.

public FeatureCache GeoCache { get; set; }

Property Value

FeatureCache

Remarks:

You must set IsActive to true for the Cache system. The default is not active.

FeatureIdsToExclude

A collection of strings representing record id of features not to get in the Layer.

public Collection<string> FeatureIdsToExclude { get; }

Property Value

Collection<String>

Remarks:

This string collection is a handy place to specify what records not to get from the source. Suppose you have a shape file of roads and you want to hide the roads within a particular rectangle, simply execute GetFeaturesInsideBoundingBox() and add the id of the return features to the collection and forget about them. Since you can set this by Layer it makes is easy to determine what to and what not to.

TransactionBuffer

The TransactionBuffer used in the Transaction System.

public TransactionBuffer TransactionBuffer { get; set; }

Property Value

TransactionBuffer

Remarks:


The Transaction System

The transaction system of a FeatureSource sits on top of the inherited implementation of any specific source, such as Oracle Spatial or Shape files. In this way, it functions the same way for every FeatureSource. You start by calling BeginTransaction. This allocates a collection of in-memory change buffers that are used to store changes until you commit the transaction. So, for example, when you call the Add, Delete or Update method, the changes to the feature are stored in memory only. If for any reason you choose to abandon the transaction, you can call RollbackTransaction at any time and the in-memory buffer will be deleted and the changes will be lost. When you are ready to commit the transaction, you call CommitTransaction and the collections of changes are then passed to the CommitTransactionCore method and the implementer of the specific FeatureSource is responsible for integrating your changes into the underlying FeatureSource. By default the IsLiveTransaction property is set to false, which means that until you commit the changes, the FeatureSource API will not reflect any changes that are in the temporary editing buffer.

In the case where the IsLiveTransaction is set to true, then things function slightly differently. The live transaction concept means that all of the modifications you perform during a transaction are live from the standpoint of the querying methods on the object.

As an example, imagine that you have a FeatureSource that has 10 records in it. Next, you begin a transaction and then call GetAllFeatures. The result would be 10 records. After that, you call a delete on one of the records and call the GetAllFeatures again. This time you only get nine records, even though the transaction has not yet been committed. In the same sense, you could have added a new record or modified an existing one and those changes would be considered live, though not committed.

In the case where you modify records -- such as expanding the size of a polygon -- those changes are reflected as well. For example, you expand a polygon by doubling its size and then do a spatial query that would not normally return the smaller record, but instead would return the larger records. In this case, the larger records are returned. You can set this property to be false, as well; in which case, all of the spatially related methods would ignore anything that is currently in the transaction buffer waiting to be committed. In such a case, only after committing the transaction would the FeatureSource reflect the changes.

MaxRecordsToDraw

public int MaxRecordsToDraw { get; set; }

Property Value

Int32

Constructors

DelimitedFeatureSource()

public DelimitedFeatureSource()

DelimitedFeatureSource(String, String, String, String)

public DelimitedFeatureSource(string delimitedPathFilename, string xColumnName, string yColumnName, string delimiter)

Parameters

delimitedPathFilename String

xColumnName String

yColumnName String

delimiter String

DelimitedFeatureSource(String, String, String)

public DelimitedFeatureSource(string delimitedPathFilename, string wellKnownTextColumnName, string delimiter)

Parameters

delimitedPathFilename String

wellKnownTextColumnName String

delimiter String

Methods

OpenCore()

protected void OpenCore()

CanGetCountQuicklyCore()

protected bool CanGetCountQuicklyCore()

Returns

Boolean

CloseCore()

protected void CloseCore()

GetCountCore()

protected long GetCountCore()

Returns

Int64

GetBoundingBoxCore()

protected RectangleShape GetBoundingBoxCore()

Returns

RectangleShape

GetColumnsCore()

protected Collection<FeatureSourceColumn> GetColumnsCore()

Returns

Collection<FeatureSourceColumn>

GetFeaturesByIdsCore(IEnumerable<String>, IEnumerable<String>)

protected Collection<Feature> GetFeaturesByIdsCore(IEnumerable<string> ids, IEnumerable<string> returningColumnNames)

Parameters

ids IEnumerable<String>

returningColumnNames IEnumerable<String>

Returns

Collection<Feature>

GetFeatureIdsCore()

protected Collection<string> GetFeatureIdsCore()

Returns

Collection<String>

GetAllFeaturesCore(IEnumerable<String>, Int32, Int32)

protected Collection<Feature> GetAllFeaturesCore(IEnumerable<string> returningColumnNames, int startIndex, int takeCount)

Parameters

returningColumnNames IEnumerable<String>

startIndex Int32

takeCount Int32

Returns

Collection<Feature>

GetAllFeaturesCore(IEnumerable<String>)

protected Collection<Feature> GetAllFeaturesCore(IEnumerable<string> returningColumnNames)

Parameters

returningColumnNames IEnumerable<String>

Returns

Collection<Feature>

GetFeaturesInsideBoundingBoxCore(RectangleShape, IEnumerable<String>)

protected Collection<Feature> GetFeaturesInsideBoundingBoxCore(RectangleShape boundingBox, IEnumerable<string> returningColumnNames)

Parameters

boundingBox RectangleShape

returningColumnNames IEnumerable<String>

Returns

Collection<Feature>

CommitTransactionCore(TransactionBuffer)

protected TransactionResult CommitTransactionCore(TransactionBuffer transactions)

Parameters

transactions TransactionBuffer

Returns

TransactionResult

BuildIndexFile(String, String, String, String, BuildIndexMode)

public static void BuildIndexFile(string delimitedPathFilename, string xColumnName, string yColumnName, string delimiter, BuildIndexMode buildIndexMode)

Parameters

delimitedPathFilename String

xColumnName String

yColumnName String

delimiter String

buildIndexMode BuildIndexMode

BuildIndexFile(String, String, String, BuildIndexMode)

public static void BuildIndexFile(string delimitedPathFilename, string wellKnownTextColumnName, string delimiter, BuildIndexMode buildIndexMode)

Parameters

delimitedPathFilename String

wellKnownTextColumnName String

delimiter String

buildIndexMode BuildIndexMode

BuildIndexFile(String, String, String, String, BuildIndexMode, Encoding)

public static void BuildIndexFile(string delimitedPathFilename, string xColumnName, string yColumnName, string delimiter, BuildIndexMode buildIndexMode, Encoding encoding)

Parameters

delimitedPathFilename String

xColumnName String

yColumnName String

delimiter String

buildIndexMode BuildIndexMode

encoding Encoding

BuildIndexFile(String, String, String, BuildIndexMode, Encoding)

public static void BuildIndexFile(string delimitedPathFilename, string wellKnownTextColumnName, string delimiter, BuildIndexMode buildIndexMode, Encoding encoding)

Parameters

delimitedPathFilename String

wellKnownTextColumnName String

delimiter String

buildIndexMode BuildIndexMode

encoding Encoding

CreateDelimitedFile(String, IEnumerable<String>, String, OverwriteMode)

public static void CreateDelimitedFile(string delimitedPathFilename, IEnumerable<string> columnNames, string delimiter, OverwriteMode overwriteMode)

Parameters

delimitedPathFilename String

columnNames IEnumerable<String>

delimiter String

overwriteMode OverwriteMode

CreateDelimitedFile(String, IEnumerable<String>, String, OverwriteMode, Encoding)

public static void CreateDelimitedFile(string delimitedPathFilename, IEnumerable<string> columnNames, string delimiter, OverwriteMode overwriteMode, Encoding encoding)

Parameters

delimitedPathFilename String

columnNames IEnumerable<String>

delimiter String

overwriteMode OverwriteMode

encoding Encoding

OnBuildingIndex(BuildingIndexDelimitedFeatureSourceEventArgs)

protected static void OnBuildingIndex(BuildingIndexDelimitedFeatureSourceEventArgs e)

Parameters

e BuildingIndexDelimitedFeatureSourceEventArgs

Events

BuildingIndex

public static event EventHandler<BuildingIndexDelimitedFeatureSourceEventArgs> BuildingIndex;

DrawingProgressChanged

public event EventHandler<DrawingProgressChangedEventArgs> DrawingProgressChanged;

GettingColumns

public event EventHandler<GettingColumnsFeatureSourceEventArgs> GettingColumns;

GottenColumns

public event EventHandler<GottenColumnsFeatureSourceEventArgs> GottenColumns;

GettingFeaturesByIds

public event EventHandler<GettingFeaturesByIdsFeatureSourceEventArgs> GettingFeaturesByIds;

GettingFeaturesForDrawing

public event EventHandler<GettingFeaturesForDrawingFeatureSourceEventArgs> GettingFeaturesForDrawing;

CustomColumnFetch

This event is raised when fields are requested in a feature source method that do not exist in the feature source. It allows you to supplement the data from any outside source you have.

public event EventHandler<CustomColumnFetchEventArgs> CustomColumnFetch;

Remarks:

This event is raised when fields are requested in a feature source method that do not exist in the feature source. It allows you to supplement the data from any outside source you have.

It is used primarily when you have data relating to a particular feature or set of features that is not within source of the data. For example, you may have a shape file of the world whose .dbf component describes the area and population of each country. Additionally, in an outside SQL Server table, you may also have data about the countries, and it is this data that you wish to use for determining how you want to color each country.

To integrate this SQL data, you simply create a file name that does not exist in the .dbf file. Whenever Map Suite is queried to return records that specifically require this field, the FeatureSource will raise this event and allow you the developer to supply the data. In this way, you can query the SQL table and store the data in some sort of collection, and then when the event is raised, simply supply that data.

As this is an event, it will raise for each feature and field combination requested. This means that the event can be raised quite often, and we suggest that you cache the data you wish to supply in memory. We recommend against sending out a new SQL query each time this event is raised. Image that you are supplementing two columns and your query returns 2,000 rows. This means that if you requested those fields, the event would be raised 4,000 times.

CommittingTransaction

This event is raised after the CommitTransaction method is called, but before the CommitTransactionCore is called. This allows you access to the TransactionBuffer before the transaction is committed. It also allows you to cancel the pending commit of the transaction.

public event EventHandler<CommittingTransactionEventArgs> CommittingTransaction;

Remarks:

This event is raised before the CommitTransactionCore is called and allows you access to the TransactionBuffer before the transaction is committed. It also allows you to cancel the pending transaction. The TransactionBuffer is the object that stores all of the pending transactions and is accessible through this event to allow you to either add, remove or modify transactions.

In the event that you cancel the CommitTransaction method, the transaction remains intact and you will still be editing. This makes it a nice place to possibly check for connectivity before the TransactionCore code is run, which is where the records are actually committed. Calling the RollBackTransaction method is the only way to permanently cancel a pending transaction without committing it.

CommittedTransaction

This event is raised after the CommitTransaction and the CommitTransactionCore are called and allows you access to the TransactionBuffer and the TransactionResults object before CommitTransaction method is returned.

public event EventHandler<CommittedTransactionEventArgs> CommittedTransaction;

Remarks:

This event is raised after the CommitTransactionCore is called and allows you access to the TransactionBuffer and the TransactionResults object before CommitTransaction method is returned.

With this event, you can analyse the results of the transaction and do any cleanup code necessary. In the event some of the records did not commit, you can handle those items here. The TransactionResults object is passed out of the CommitTransaction method so you could analyze it then; however, this is the only place where you have access to both the TransactionResults object and the TransactionBuffer object at the same time. These are useful together to try and determine what went wrong and possibly try and re-commit them.

At the time of this event you will technically be out of the current transaction.

OpeningFeatureSource

This event is called before the opening of the FeatureSource.

public event EventHandler<OpeningFeatureSourceEventArgs> OpeningFeatureSource;

Remarks:

This event is called before the opening of the FeatureSource. Technically, this event is called after the calling of the Open method on the FeatureSource, but before the protected OpenCore method.

It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.

OpenedFeatureSource

This event is called after the opening of the FeatureSource.

public event EventHandler<OpenedFeatureSourceEventArgs> OpenedFeatureSource;

Remarks:

This event is called after the opening of the FeatureSource. Technically, this event is called after the calling of the Open method on the FeatureSource and after the protected OpenCore method is called.

It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.

ClosingFeatureSource

This event is called before the closing of the FeatureSource.

public event EventHandler<ClosingFeatureSourceEventArgs> ClosingFeatureSource;

Remarks:

This event is called before the closing of the FeatureSource. Technically, this event is called after the calling of the Close method on the FeatureSource, but before the protected CloseCore method.

It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.

ClosedFeatureSource

This event is called after the closing of the FeatureSource.

public event EventHandler<ClosedFeatureSourceEventArgs> ClosedFeatureSource;

Remarks:

This event is called after the closing of the FeatureSource. Technically, this event is called after the calling of the Close method on the FeatureSource and after the protected CloseCore method.

It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.