Latest Contributions by RichardFairhurst

I digitize my polygon, I can see it, and after saving my edits, the polygon dissapear. I haven't set up the scale. Thanks. If you are editing in versions prior to ArcGIS 10 you probably have a definition query set on the layer that does not match the feature attributes after you have saved your edits.  You may have created the feature just fine, but it filters out of view as soon as you save edits.  If you have no definition query or this is at ArcGIS 10 then I am not sure what is occurring without more information. ... View more

In attempting to display cogo labels we are trying to display radius but only when it is populated in the field via the Create COGO Fields tool in ArcCatalog.  we are trying to get something similar to cad  Function FindLabel ( [Direction], [Distance], [Radius] )  FindLabel = [Direction] & vbNewLine & [Distance] & vbNewLine &   â??R = â?? &[Radius] End Function  With this script it will put an R= on every label. How do we get it to do R= [Radius] only when radius is populated in the attribute table. Function FindLabel ( [Direction], [Distance], [Radius] ) if IsNull([Radius]) Then FindLabel = [Direction] & vbNewLine & [Distance] ElseIf [Radius] = 0 Then FindLabel = [Direction] & vbNewLine & [Distance] Else FindLabel = [Direction] & vbNewLine & [Distance] & vbNewLine & â??R = â?? &[Radius] End If End Function ... View more

it works with paths relative to the mxd location.. but if in the Map Document Properties I've decided a different "Hyperlink base"... why it doesn't use it? I think that only applies to a layer that defines a single field as a Hyperlink in the layer definition.  I do not think it applies to the general setting that enables anything resembling a hyperlink to fire up.  I do not believe that setting should apply to that condition, since all manner of hyperlinks are supposed to work though that setting, not just those from a single base.  I would not want it to be limited. How would distribution transfer the linked information that would cause you these problems?  If the links aren't in relative path configuration, don't you risk a break in the link anyway if the other user does not duplicate your directory conventions locally or have access to your domain?  What UNC are you using in the base? ... View more

I didn't manage to get this working! the "lightning bolt" of the hyperlinks doesn't even light on! I can see the correct field in the identify window but it isn't highlighted and it doesn't work.. the field is text type, I am storing relative path names so I did wrote the hyperlink base in the map document properties, the arcmap options are the same of rfairhur24's images.. what did I do wrong? please help! I don't know if Relative Paths works for hyperlinks.  As far as I know the URL has to make sense to the browser or application apart from any settings in ArcMap.  So you should try pasting the link directly into the application or browser and see if it works.  Adjust it until it does work.  I always put the full URL or File path, although I try to use domain names rather than mapped drive letters to try to keep the link from breaking when servers retire and to make it more universal across computers in my domain. ... View more

At ArcGIS 10 a file geodatabases can have 64K columns, but SDE is limited to 500 columns.  Anyway, I doubt you could get a table with over 8K of columns into any other format.  Also performance may suck as more columns are added to an fgdb based on this thread.  Be prepared for some serious performance issues arising with a process that tries to create over 8K fields.  The Pivot Table would probaly optimize some of the field creation process in memory rather than hitting the disk with each new Add Field geoprocessing operation.  So if you have ArcInfo, give that option some serious consideration. ... View more

so how exactly would I be able to build a point shapefile of all the intersections in an entire city without selecting the cul-d-sacs as points as well? Only using the Real Nodes that is no End Nodes. I use the Collect Events tool (all license levels) to collapse many overlapping points derived from the Featrue Vertices to Points tool with the Both Ends option (ArcInfo license required) into a single point with a Count value.  The Collect Events tool does not preserve links to the original points, so I have to create a field in the origin and output to hold a text representation of the point XY values to join.  I use State Plane points and find that 4 digit precision is more than sufficient, so my field is 28 characters long and encloses the X and Y coordinates in brackets.  My formula for calculating the point value is done in Python and is: Parser:  Python Pre-Logic Code: def Output(FirstPoint):   FPX = round(float(FirstPoint.split() [0]), 4)   FPY = round(float(FirstPoint.split() [1]), 4)   return "{%(FX)012.4f}{%(FY)012.4f}" % {'FX': FPX, 'FY': FPY} Expression:  Output(!SHAPE.FIRSTPOINT!) By summariizing and pivoting (ArcInfor license required) the origin point street names and frequencies and then joining the summaries to the Collected Event points on the field I have calculated I can keep track of nodes that are made up of one point, multiple points but only one road, or multiple points and multiple roads (including how many points make up each road, so I know where T intersections occur and which road is the base of the T).  My true intersection layer is an extraction of all of the points that came from multiple points and that have multiple road names (excluding points where only one of the two roads is a named road). Everything in the Collect Events output with a Count of 1 is either a Cul-de-sac (which I divided into real constructed cul-de-sacs and legal paper road cul-de-sacs), a stub road that has no bulb and that concievably could be extended, or a topological error.  I extract these sets of points out into their own layer and classify them accordingly.  Joined with other jurisdictional maintenance information from my Centerlines this cul-de-sac layer allows me to automate the mapping of all cul-de-sac symbols that my jurisdiction maintains on our maintained road book maps directly from information entered on the Centerlines. Topology and geoprocessing environmental settings helps avoid quantum shifting of the street lines, so I recommend using topology and geoprocessing enviromental settings for feature class extents and XY precision if you want to use stationary road end points that you can track and join by their XY positions. ... View more

Dear ArcObjects Developers, I have to migrate several 9.3 applications from VBA to 10.0 Add-Ins.  Is it easier to migrate to VB.NET first and then to Add-Ins?  Or, should I go straight from VBA to Add-Ins? Thank You, Robert Hanover Ohio Dept. of Natural Resources I am going straight to Add-Ins.  I am checking out whether an Add-In button can be used with stamdard Windows forms.  According to ESRI support I am supposed to be able to do that.  In any case, Add-Ins have some limitations, but they simplify deployment, so they are attractive if you have to distribute your tools. ... View more

I have a set of polygons that have been dissected into sub-polygons to reflect spatial values.  I need to select the spatial value of the largest sub-polygon to use to describe the entire polygon.  I thought Dissolve would work, but it does not always return the spatial value for the largest polygon.  Here is an example of the table:  Name        Acres     Value Loc1          1.0         M Loc1          2.0         N Loc1          0.5         P    I need to be able to assign Value N to the Loc1 polygon (dissolved on 'Name') because the largest sub-poly value is N.  I've tried various Dissolves, Selects, etc. but cannot get a file with the correct values.  I also really can't use grid files because the area of the polygon needs to remain consistent. Do it in more than one step.  Use Summary Statistics to get the Max Acres for each Name.  Join the Summary to the original and select where ABS(Acres - Max_Acres) < .001.  Then export that set of records or resumarize it to get the Value field of the largest polygon.  Join that result to all of your original records and recalculate the Value. ... View more

If this answered your question, please click on the Answered checkmark that is under the rating numbers on my post to change the thread icon to an Answered thread for the benefit of others. ... View more

Yes thats right, one field in many shapefiles. So what i need to do is to extract this field called Leistung from all the shapefiles and put it together in only one file, because i need to do further calculations with another program. The aim is to avoid that i have thousands of shapefiles on my computer. for example: if i do the calculation for one year, and the input values are given hourly i have 8760 output files, so i wanted one file with 8760 colums instead. i hope this is more understandable. I tried to draw a schematic maybe it helps to explain my problem! [ATTACH=CONFIG]11289[/ATTACH] What license level do you have?  If you have an ArcInfo license you could instead Append all of the tables together and use the Pivot Table tool to create the columns.  The appended tables would each need a numeric field with field the name that you want.  The value in the field would be the number of the output column you want for each table (i.e., the first hour table would have a value of 1, the seccond would have a 2, etc.).  The only pain of the Pivot Table tool is that the number value is treated like a string, so 1 is followed by 10, by 100, by 1000, and then 11.  That could be overcome by adding 10000 to all numbers, which would properly sort out as FIELD10001, FIELD10002, etc. I expect you will have problems getting a table to work with 8760 columns.  Shapefiles won't work with that many columns.  I'm not sure what the limit is for the various geodatabases. ... View more

It worked! Thank you so much for your help!!! It is very much appreciated! Please click on the checkmark under the rating number to mark this thread as answered so that the thread will appear to everyone as closed and for the benefit of others. ... View more

Try the code below in the Label Expression field: Function FindLabel ( [PartyName] ) if InStr( [PartyName] , ",") > 0 Then   myArray = Split( [PartyName] , ",")   FindLabel = myArray(0) & ", " & LEFT(Trim(myArray(1)), 1) & "." ElseIf Len( [PartyName] ) > 13 Then   FindLabel = Left([PartyName], 13) Else   FindLabel = [PartyName] End If End Function ... View more

I am needing to label a map with owner names but I would like to trim the name to one character after a comma. I also have owner names that are not divided by a comma so I would like to trim them to a 13 characters. I am having trouble writing the expression for this. Any help would be great. What are the field names involved?  Do all of the names have to fit in 13 characters?  Actual examples of names that are too long in each format and how you want them to be labeled would help for developing the VB Script code.  Most likely you will use the Split or InStr functions, but that is as far as I can say with the information you have given. ... View more