Latest Contributions by JJD84

‎05-31-2017

Yeah yeah whatever I was out by 1 !! Its too bad that you removed this from the original post as it is now missing the context from which I had replied to. That being that ObjectID's were not purely sequential on MSSQL SDE and that each edit session caused ObjectID to jump by ~ 400. Was that not the discussion in original thread... So basically my situation would be 2,147,483,647/400 = 5368709 rows before maximum is reached. All I asked was should I be concerned. Abrasive day at ESRI HQ huh? But I do thank you for responding.

‎05-26-2017

I read that the maximum of the ObjectID field is 2,147,483,648, so as I am on MS SQL Server SDE enabled database am I at risk of consuming this maximum number. My IDs are already hitting 20000 after 67 features and I plan to roll out this layer via Geocortex to about 500 users to use regularly. I am a little alarmed, should I be? https://community.esri.com/groups/geodatabase?sr=search&searchId=4c0b6eb2-c018-40b5-b711-c7121b8d8394&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=38f76010-ffb3-43e3-b726-8a4486b3bde0&searchIndex=0‌

‎09-08-2013

I never seemed to get that working. Given my issue I decided to utilise gp.ExecuteAsync and Queue the geoprocessing tasks in the background. Then if the GP tool took too long or hung the user could still save their project and cancel the GP task.

‎08-09-2013

I have a UI that has a button that exports currently selected vector features to a KML using the LayerToKML Geoprocessor. Whilst it works great on locally stored featureclasses there are certain featureclasses (eg statewide cadastre) on our greater network that are way too big (and our WAN network is very slow!!), and hence take forever to process, even if just a few features are selected for export. While part of my code does a quick check to see how many features exist in the dataset before executing the GP, and gives a warning that it may take until the end of time itself to complete, I want to allow the user to terminate the LayerToKML process should they find them selves onto their second cup of coffee while it is running. Currently if my form is closed whilst this GP is running the whole ArcGIS drops out and all is lost. Is this possible to do programatically? This is my GP sub Private Sub KMZGenerator(pfeaturelayer As IFeatureLayer, LayerName As String, FolderPath As String) ' Initialize the geoprocessor. Dim GP As Geoprocessor = New Geoprocessor() 'Calculates current date and time and provides as a string Dim rightNow As DateTime = DateTime.Now Dim strCurrentDateTimeString As String strCurrentDateTimeString = rightNow.ToString("ddd_dd_MMM_yyyy_hh_mm_sstt") 'Creates KMZ Dim LayerToKMLTool As ESRI.ArcGIS.ConversionTools.LayerToKML = New ESRI.ArcGIS.ConversionTools.LayerToKML() GP.SetEnvironmentValue("workspace", FolderPath) LayerToKMLTool.layer = pfeaturelayer LayerToKMLTool.layer_output_scale = 1 LayerToKMLTool.out_kmz_file = LayerName & "_" & strCurrentDateTimeString & ".kmz" GP.Execute(LayerToKMLTool, Nothing) Process.Start(LayerToKMLTool.out_kmz_file) End Sub Thnx Justin

‎07-23-2013

Ah so simple, this had me bogged for a while tonight .... many thanks Ken. J

‎07-23-2013

I am writing code for a button in a windows.form to export to KMZ any selected features from any vector layer in a maps TOC. Code works well with vector layers but seems to crash if there is any imagery or raster in the TOC. I understand that Ifeaturelayer is for vector geometries only, so I am guessing I need to include a check if the current layer is a vector, if so continue with code, otherwise skip the code. But being very new to arcobjects, I cant figure out how to do this? See below: Public Sub ExportSelectedFeaturesToKML() Dim pMxDoc As IMxDocument Dim pMap As IMap Dim pFeatureLayer As IFeatureLayer Dim LayerName As String pMxDoc = My.ArcMap.Document pMap = pMxDoc.FocusMap 'Counts number of Layers in TOC Dim LayerCount As Integer LayerCount = pMap.LayerCount '******** Loops through layers in TOC and checks if there are any selected features, if so exports them as KMZ. For i = 0 To LayerCount - 1 pFeatureLayer = pMap.Layer(i) 'Determines the Name of current Layer for KMZ file name LayerName = pMap.Layer(i).Name 'Calculates current date and time and provides as a string Dim rightNow As DateTime = DateTime.Now Dim strCurrentDateTimeString As String strCurrentDateTimeString = rightNow.ToString("ddd_dd_MMM_yyyy_hh_mm_ss_tt") 'Checks if layer has any selected features Dim pLayer As ILayer pLayer = pMap.Layer(i) Dim pFeatureSelection As IFeatureSelection pFeatureSelection = pLayer Dim PSelectionSet As ISelectionSet2 PSelectionSet = pFeatureSelection.SelectionSet Dim SelectionCount As Integer SelectionCount = PSelectionSet.Count If SelectionCount > 0 Then ' Initialize the geoprocessor. Dim GP As Geoprocessor = New Geoprocessor() Dim LayerToKMLTool As ESRI.ArcGIS.ConversionTools.LayerToKML = New ESRI.ArcGIS.ConversionTools.LayerToKML() GP.SetEnvironmentValue("workspace", "C:\Data") LayerToKMLTool.layer = pFeatureLayer LayerToKMLTool.layer_output_scale = 1 LayerToKMLTool.out_kmz_file = LayerName & "_" & strCurrentDateTimeString & ".kmz" GP.Execute(LayerToKMLTool, Nothing) End If Next End Sub Any suggestions would be greatly appreciated. Justin

Online Status	Offline
Date Last Visited	‎03-09-2021 12:33 PM

My Ideas

Latest Contributions by JJD84

Re: ObjectID of an SDE feature class skipping values

ObjectID of an SDE feature class skipping values

Re: Terminating a GP tool while running (in VB.Net)

Terminating a GP tool while running (in VB.Net)

Re: How do you check if a layer in TOC is a vector or a raster/image? vb.net

How do you check if a layer in TOC is a vector or a raster/image? vb.net

Re: ObjectID of an SDE feature class skipping valu...