topic Re: Writing features to a feature class by a batch process in ArcGIS Pro SDK Questions

Writing features to a feature class by a batch process

TyroneLigon1 — Tue, 22 Oct 2024 21:53:37 GMT

I apologize in advance that I can't post any of our code. We have an add-in that manages the display of a couple of WMS services. A feature of the add-in is the ability to export the displayed points to a feature class. We accomplish this by running a WFS request; it returns a GeoJSON list of features, which we then write to a new feature class.

The issue is that the user might have tens of thousands of points on the map, and in some cases over 100,000 features. The add-in iterates through this list and adds the features to the feature class one at a time. In the test I ran, it took almost 3 minutes to write about 14,000 features. We were wondering if there's a batch write method somewhere in the SDK, or maybe we incorporate a Python script to do the feature writing.

Re: Writing features to a feature class by a batch process

GKmieliauskas — Wed, 23 Oct 2024 08:18:36 GMT

Hi,

Have you tried to call geoprocessing tool Batch import data from you add'in? It can import GeoJSON to featureclass.

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Wed, 23 Oct 2024 18:10:50 GMT

Can I call the tool via Geoprocessing.ExecuteToolAsync? If so, what is the tool's alias?

Otherwise, will I have to open the tool in the geoprocessing panel? If so, do I have to save the GeoJSON to the file system, then have the user open the file and specify the geodatabase location? Or, can I populate those fields on my own?

Re: Writing features to a feature class by a batch process

GKmieliauskas — Wed, 23 Oct 2024 19:01:44 GMT

Yes, You can call Geoprocessing.ExecuteToolAsync. Tool name will be "BatchImportData_intelligence". You need to have minimum Standard ArcGIS Pro license to use that tool.

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Wed, 23 Oct 2024 21:16:08 GMT

Do I first execute Geoprocessing.MakeValueArray with the GeoJSON and the geodatabase location as the arguments? Also, how can I then specify the feature class name? Currently, we first create the feature class in the map project's default geodatabase (the name is a concatenation of a timestamp and WMS layer name), then we add the fields, then we populate the feature class one feature at a time.

Re: Writing features to a feature class by a batch process

GKmieliauskas — Thu, 24 Oct 2024 10:19:21 GMT

Yes, you need to create parameters first:

IReadOnlyList<string> importParams = Geoprocessing.MakeValueArray(@"c:\data\sourcedata", @"\\data\operationaldata.sde", "*airports*.shp", "NO_SUBFOLDERS"); IGPResult result = await Geoprocessing.ExecuteToolAsync("intelligence.BatchImportData", importParams); if (result.IsFailed) { MessageBox.Show("Unable to import", "Batch import"); return; }

Parameters from documentation sample. Use yours. As I understand featureclass names will be created automatically from source names. After you can rename them.

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Fri, 25 Oct 2024 20:44:18 GMT

Can you give me a link to this sample? I can't find it in the Pro SDK documentation.

Re: Writing features to a feature class by a batch process

GKmieliauskas — Sat, 26 Oct 2024 18:24:18 GMT

Link is above. This is python sample at the bottom of page. There is no documentation for each geoprocessing tool for ArcGIS Pro SDK for .NET.

Re: Writing features to a feature class by a batch process

Aashis — Tue, 29 Oct 2024 03:10:38 GMT

@TyroneLigon1 , The Insert Cursor API should be used for your level of bulk insertion; it is designed to insert faster rows in the Pro SDK.

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Tue, 29 Oct 2024 15:14:23 GMT

Sorry, I got pulled away from this project for a few days. The parameter array is failing - I believe it's because I'm directly injecting a GeoJSON list object. Do I have to save the list to the file system first?

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Tue, 29 Oct 2024 15:14:57 GMT

I got pulled away for a couple of days. I'll give this a shot.

Re: Writing features to a feature class by a batch process

GKmieliauskas — Tue, 29 Oct 2024 19:10:09 GMT

Yes. Documentation says that first parameter must be file or folder:

Name	Explanation	Data Type
in_data [in_data,...]	The folders containing the data files or the data files to convert to geodatabase feature classes.	Folder; File

Re: Writing features to a feature class by a batch process

TyroneLigon1 — Fri, 01 Nov 2024 16:06:01 GMT

I went with the "Insert Cursor" solution. My testing indicates that our batch exports now run between 2 and 4.5 times faster.