|
POST
|
Hi Josh, If you want to kick it up a notch, try load-only mode. This is something used in File GDB and SDE (although the way they actually work differs slightly between the two). For File GDB, basically it suspends all indexes - when you're finished, you knock it out of load-only mode, rebuilding the indexes. It should make a significant difference.
IFeatureClassLoad featureClassLoad = (IFeatureClassLoad)pNewTable;
featureClassLoad.LoadOnlyMode = true;
// Get cursor, do inserts, etc., then...
featureClassLoad.LoadOnlyMode = false;
Cheers, James Hi James- I tried your LoadOnlyMode method and set it in the correct spots as you suggested but it made no difference. Is there anyway I should be adding the data differently in my Do While loop? Should I be using IRowBuffer inside the Loop? Everything seems to be pointing to this loop as to why it's running so slow.. Please let me know any suggestions anyone. Many Thanks -Josh
... View more
12-27-2010
06:04 AM
|
0
|
0
|
666
|
|
POST
|
Also I should mention that "pTable" inside of that personal geodatabase has about 205,000 records. If I produce the table pTable through VBA code in ArcMap, I can run through the above loop and multiple other loops in my function in less than 4 minutes. What gives??
... View more
12-21-2010
10:33 AM
|
0
|
0
|
666
|
|
POST
|
My below code is taking 15 minutes or more to run and I need to find a more efficient way. Any ideas please?? Thanks for any help ICursor pCursor;
IRow pRow2;
ICursor pTableCursor;
pTableCursor = pTable.Search(null, true); //pTable is a table inside of a local personal geodatabase
pRow2 = pTableCursor.NextRow();
IRowBuffer pRowBuff;
pRowBuff = pNewTable.CreateRowBuffer(); //pNewTable is a table I just created inside a local File Geodatabase
pCursor = pNewTable.Insert(true);
do
{
//populate the row with values
pRowBuff.set_Value((Int32)l_FCWell_ID, pRow2.get_Value((Int32)l_Well_ID));
pRowBuff.set_Value((Int32)l_FCSidetrack_Number, pRow2.get_Value((Int32)l_Sidetrack_Number));
pRowBuff.set_Value((Int32)l_FCAlternate_ID, pRow2.get_Value((Int32)l_Alternate_ID));
pRowBuff.set_Value((Int32)l_FCMeasured_Depth, pRow2.get_Value((Int32)l_Measured_Depth));
pRowBuff.set_Value((Int32)l_FCInclination, pRow2.get_Value((Int32)l_Inclination));
pRowBuff.set_Value((Int32)l_FCAzimuth, pRow2.get_Value((Int32)l_Azimuth));
pRowBuff.set_Value((Int32)l_FCE_W, pRow2.get_Value((Int32)l_E_W));
pRowBuff.set_Value((Int32)l_FCN_S, pRow2.get_Value((Int32)l_N_S));
pRowBuff.set_Value((Int32)l_FCTVD, pRow2.get_Value((Int32)l_TVD));
pRowBuff.set_Value((Int32)l_FCState_Plane_Easting, pRow2.get_Value((Int32)l_State_Plane_Easting));
pRowBuff.set_Value((Int32)l_FCState_Plane_Northing, pRow2.get_Value((Int32)l_State_Plane_Northing));
pRowBuff.set_Value((Int32)l_FCSub_Sea_TVD, pRow2.get_Value((Int32)l_Sub_Sea_TVD));
pCursor.InsertRow(pRowBuff);
pRow2 = pTableCursor.NextRow();
} while (pRow2 != null);
... View more
12-21-2010
09:08 AM
|
0
|
6
|
1301
|
|
POST
|
If a parameter wants the MXD you need to create an MXD object with the "CURRENT" path so that the print functions know that you want to use the MXD that is open at the moment. The print could be sent to either a printer or to PDF depending on what you want to happen. I havnt written anything like this for a service but it isnt complicated to do from the desktop environment. Do you see any problems with my below code?? import sys, arcpy
arcpy.env.overWriteOutput = True
mxdTemplate = "CURRENT" #or a different mxd
outWs = "D:\\GIS Data\\arcgisserver\\arcgisoutput" #can really be any directory
outFileName = "print_service_output.pdf"
ext = arcpy.Extent(-96.597, 34.742, -96.225, 35.055)
outFilePath = outWs + "\\" + outFileName
mxdTemplateObject = arcpy.mapping.MapDocument(mxdTemplate)
df = arcpy.mapping.ListDataFrames(mxdTemplateObject)[0]
df.extent = ext
arcpy.mapping.ExportToPDF(mxdTemplateObject, outFilePath)
... View more
12-16-2010
06:57 AM
|
0
|
0
|
533
|
|
POST
|
I saw the blog post below suggesting that a Geoprocessing Service could be created to utilize ArcPy and the Printer Settings but I still have many questions. Is a PDF produced or is the print sent straight to the printer? Some of the parameters seem to want to point to the actual MXD and actual printer so could I use a URL to the MXD and printer? What would help me the most is if anyone has one complete sample of what this script should look like? I would just need one print size in the example code not all of them for simplisity sake. http://blogs.esri.com/Dev/blogs/arcgisdesktop/archive/2010/02/01/ArcPy-and-Geoprocessing_2620_-it_1920_s-for-Developers-too.aspx
... View more
12-16-2010
03:11 AM
|
0
|
2
|
729
|
|
POST
|
I have setup a basic Web App that allows for Editing a Parcel Layer and saving Edits. My question is how can I differintiate between users so that different versioning of the data can occur? Does anyone have any suggestions or links? Many Thanks..
... View more
11-17-2010
10:06 AM
|
0
|
2
|
749
|
|
POST
|
We all forgot the final single quote
spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND TDIR = '" + TDIR + "' AND TWP = '" + TWP + "'";
Thanks Ken and Vincent
... View more
11-02-2010
07:30 AM
|
0
|
0
|
674
|
|
POST
|
It looks like you're missing a few "AND"s
spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND TDIR = '" + TDIR + "' AND TWP = '" + TWP;
Thanks Ken and Vincent. Is the single quotes and double quotes correct as well?
... View more
11-02-2010
07:00 AM
|
0
|
0
|
674
|
|
POST
|
I'm pretty sure my syntax is not correct here. Can someone verify and let me know? SECT, RDIR, RNG, TDIR, and TWP are all string values. spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' TDIR = '" + TDIR + "' TWP = '" + TWP; thank you..
... View more
11-02-2010
06:36 AM
|
0
|
5
|
917
|
|
POST
|
The editing is not available with version 9.3.1. I am afraid you would have to use 10 and API version 2.0 for it. Thanks Kiran
... View more
10-25-2010
07:06 AM
|
0
|
0
|
381
|
|
POST
|
Is multi-user editing available for ArcGIS Server version 9.3.1 with Silverlight? I know it's available in version 10 but I'm wondering if anyone has any info for me on 9.3.1. I have a feature class (polygons) that I need to allow users the ability to update the geometry of. Many thanks
... View more
10-25-2010
05:17 AM
|
0
|
2
|
741
|
|
POST
|
I know, I had trouble finding resource too. After asking the experts, this for sure is what you need: http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//009300000021000000.htm Thanks Jennifer, that helps a lot.
... View more
10-21-2010
09:57 AM
|
0
|
0
|
714
|
|
POST
|
Maybe this? http://help.arcgis.com/en/arcims/10.0/mainhelp/topics/admin_publishing.htm I have not created a any service on my own, sorry I can't help there. This might help too http://help.arcgis.com/EN/arcgisserver/10.0/apis/rest/index.html Hi Jennifer- I took your suggestion and looked at the REST URL for the FeatureLayer used in that example you posted and can see is in a "FeatureServer Service" and the Evacuation Perimeter layer is of type "Feature Layer" and has operation properties of "Add Features, Update Features, Delete Features, and Apply Edits" So do you happen to know how I can create a service like that? I assume I could publish a service like this from ArcCatalog? I'm having a difficult time tracking documentation on this for some reason.
... View more
10-21-2010
08:14 AM
|
0
|
0
|
714
|
|
POST
|
Does anyone know the correct procedures for Editing a FeatureClass in Silverlight? I'm familiar with publishing a MXD as a Map Service and adding its REST URL to a Silverlight template as a DynamicMapService but am not familiar with the steps to make any particular layer "Editable". Do I need to publish the MXD as Geodata Access? Do I decalre a FeatureLayer in the XAML and point to the REST URL of my Map Service? From what I read on FeatureLayers, they seem to be only meant for Graphic Layers. I need to actually Edit the FeatureClass using multi-user editing. Please advise. Many thanks everyone..
... View more
10-21-2010
06:58 AM
|
0
|
1
|
724
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-15-2023 01:27 PM | |
| 1 | 05-02-2017 11:40 AM | |
| 1 | 06-16-2010 08:09 AM | |
| 1 | 05-02-2017 10:04 AM |
| Online Status |
Offline
|
| Date Last Visited |
10-16-2025
02:03 PM
|