POST
|
I am applying an index directly to the table (not using table view).
... View more
08-30-2012
11:34 AM
|
0
|
0
|
242
|
POST
|
I have a python script that creates a table from a text file then creates an index on one of the attribute fields. The purpose is to speed up searches on that field. In 10.1 I've noticed that the tables that are indexed through python are not as efficient as the table if indexed through ArcCatalog. The table indexed through the python script takes about 5 to 6 seconds to select a record while the same table if indexed through ArcCatalog\properties is instantaneous. This is the line that is used in the script to index.... arcpy.AddIndex_management(geoTable, "ASSESSOR_N", "TaxLots", "NON_UNIQUE", "ASCENDING") (The table is in a geodatabase). Thanks
... View more
08-30-2012
07:23 AM
|
0
|
2
|
797
|
POST
|
It is working now. I needed to remove spaces around the '=', and then make sure that all column headings matched both in name and type. Thanks
... View more
08-20-2012
07:20 AM
|
0
|
0
|
1143
|
POST
|
I've had this python program working for a while where it pulls in a tab delimited text file and creates a file geodatabase table, using arcpy.CopyRows_management tool. The schema.ini file was used to set up the fields. When we upgraded to 10.1 I now get the error that the text file is not available or not the right type. I renamed the schema.ini file to something else and ran it again and there were no errors, but the table created did not have the right schema. The Help files state that although the schema.ini file is not needed it will still honor them. Is this a bug or do I need to do this another way?
... View more
08-17-2012
10:38 AM
|
1
|
4
|
5317
|
POST
|
It worked! Thanks for the direction. So simple, but it would have taken me awhile before I would have got there. So again, thanks. DD
... View more
10-20-2011
11:39 AM
|
0
|
0
|
207
|
POST
|
I am trying with the following code to use an xy generated from a mouse click to get the polygon's item value "Assessor number" and put that into a variable that I can use later in the code. Currently the code works with no errors, but I'm not having any success in getting any features selected by the filter. I tried to expand the filter by using an envelope, but still I have no features being placed into my cursor. I have noticed that the xy generated by the mouse click is in page units and maybe these need to be in map units to get it to work? If so how do I convert the xy? Here is the code.. ILayer layer = gxLayer.Layer; string layerDirectory = @"M:\taxlots"; string layerFile = "parcels"; string tableDirectory = @"M:\informix"; string tableFile = "prty_nfo"; IWorkspaceFactory workspaceFactory = new ShapefileWorkspaceFactoryClass(); IWorkspace workspace = workspaceFactory.OpenFromFile(layerDirectory, 0); IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)workspace; IFeatureClass featureClass = featureWorkspace.OpenFeatureClass(layerFile); ITable parcelTable = featureWorkspace.OpenTable(layerFile); IWorkspaceFactory workspaceFactory2 = new ShapefileWorkspaceFactoryClass(); IWorkspace workspace2 = workspaceFactory2.OpenFromFile(tableDirectory, 0); IFeatureWorkspace featureWorkspace2 = (IFeatureWorkspace)workspace2; ITable prtyTable = featureWorkspace2.OpenTable(tableFile); double searchTolerance = 25; IPoint pPoint = new PointClass(); pPoint.X = x; pPoint.Y = y; IEnvelope envelope = pPoint.Envelope; envelope.Expand(searchTolerance, searchTolerance, false); ISpatialFilter pSFilter = new SpatialFilterClass(); pSFilter.Geometry = envelope; pSFilter.GeometryField = featureClass.ShapeFieldName; pSFilter.SpatialRel = esriSpatialRelEnum.esriSpatialRelIntersects; pSFilter.SubFields = "ASSESSOR_N"; int nameFieldPos = featureClass.FindField("ASSESSOR_N"); IFeatureCursor featureCursor = featureClass.Search(pSFilter, false); IFeature parcNumFeature = null; while ((parcNumFeature = featureCursor.NextFeature()) != null) { [INDENT] string parcNum = Convert.ToString(parcNumFeature.get_Value(nameFieldPos)); MessageBox.Show(parcNum + ", Assessor Number");[/INDENT] } Any help or comments are greatly appreciated by this newbie to C#/ArcObjects programming! Thanks
... View more
10-20-2011
08:25 AM
|
0
|
2
|
308
|
Title | Kudos | Posted |
---|---|---|
1 | 08-17-2012 10:38 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|