Latest Contributions by RichardFairhurst

I'm trying to create a tool that works just like the "Identify Route Locations" tool within ArcMap except I want to get the measure value so I can pass it to an external program. Is there any ESRI code (C# preferred) example to accomplish something like this? I don't write code in C# and I have not tried replicating the Identify Route Location" tool itself, but I did create a UITool that could split a Linear Route Event based on a mouse click on a Route in this thread.  Many of the interfaces used in the code would apply to replicating the tool and capturing the measure event location to pass to another tool. ... View more

We are encountering a geocoding issue with a client's road centerline data. They are using NENA standard road name fields, but some of the value in the STREET_NAME field are "2095", "1875", "1560", etc. The problem is 1) while the fields are NENA standard these values are not, and 2) the geocoder is interpreting these values as numbers and thus barfing all over itself. So...and I'm not holding my breath...is there a way to query the STREET_NAME field, which is defined as text, for "numeric" values, or numbers stored as text, WITHOUT writing a script? Any help would be greatly appreciated. Using ArcEditor 10.0 SP 2, Windows XP Pro SP3. You did not say what kind of database you are using, and solving your problem may be SQL specific.  In a file geodatabase I tried this expression on a string field and it seemed to work properly.  See if something like this works for you (perhaps export to a fgdb if your native source does not support the cast operation). CAST("STREET_NAME" AS FLOAT) < 9999 ... View more

Hi I have a list of over 500 bridges for which i need to create a point for each. The bridges lie along a railway for which i have a polyline layer and they are described by their distance from the start point of the railway line.. Is there a quicker way to do this rather  than having to plot each point manually with the construct points tool? Any help would be greatly appreciated Thanks Kate Use Linear Referencing.  All you need to do is use the Create Route tool oriented to the beginning of the rail line to assign measures (stationing) to the line.  Make sure one of the fields of the rail line matches a value in the table of 500 points and that the offsets are in another field.  Use the Make Route Layer tool or right click on the point table and choose make Route layer to position all of the points in a single action.  You can then export the points to a permanent point feature class (events are only in memory in relatiive positions).  That should be it. ... View more

Thanks - that worked great! Please mark the thread answered for the benefit of others looking for solutions to similar problems.  I assume you used the SummaryStatistics approach given the speed of your respoinse.  Thanks. ... View more

I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group.  Is there a way to build a query for that? Thanks! Rebecca No, not within a single table/feature class.  There is a way to do it if there are two tables/feature classes.  See the discussion on Subqueries here.  I normally use the SummaryStatistics tool in the Analysis group to get a Min value and join it to the ID to select the lowest record or make other adjustments relative to the minimum value. ... View more

I am developing an alternate urban scenario using modeling and I calculated my developable land and created GIS parcel data for vacant land, also deleted all sensitive lands, including PUDs . Now I have zdata for the counties with TAZ's boundaries, In order to allocate land, need the exact vacant parcels in each TAZ, therefore  I wanted to calculate the vacant parcels in each taz, How can I do that? Thanks You should use the Spatial Join tool if there is no common field between the parcels and the TAZs.  If the TAZ is the target you can use the One-to-One option and do summarys of fields from the parcels.  You could alternatively do the One-To-Many option to generate a complete list of all matches and summarize that result, if you needed the full set of records for some other purpose. ... View more

Use the SummaryStatistics tool: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00080000001z000000.htm It does everything that Frequecy does and more... I agree that it does everything that Frequency does and more, but it still does not add a case item field to the source if the output has more than one case field.  That functionality would be a good enhancement so that Relationship Classes can be established for correlating many fields to a single join field.  So I still recommend voting for the idea I mentioned to request that enhancement. ... View more

Does anyone know why the case_item field was eliminated from the frequency tool in ArcGIS Desktop? In ArcInfo Workstation the option to add a case_item made it very easy to join the frequency table to the feature table. This question was initially asked in 2007 (http://forums.esri.com/thread.asp?c=93&f=1729&t=233587), but did not get a response. That does seem like a useful behavior.  Since not all source feature classes can have their schemas altered (SDE won't allow it without priveleges) the option should be added to the Desktop tool but be greyed out if the user lacks rights to alter the source schema.  I also suppose that locks on the source by other users are hard to detect and would cause that option to fail, so the tools was simplified to allow it to work without much chance of generating errors.  The Make Query Table tool is the only option for doing this kind of join in Desktop, but it has to be in the same geodatabase to work and cannot be edited, so if you can use that tool it has to be exported to create the joinable bridge table.  That is not as elegant of an approach.  Concatenating the fields together in a new field that is in both the source and output is the only other option to create a join. You should vote for this idea and similar ideas on the ideas website. ... View more

I had not realized the "Count" heading is clickable, but doing so does exactly what Richard said it would. I am now working my way through grouping the list of values it revealed for me. There were hundreds! Thank you Richard! Thanks for confiirming that my advice worked.  I believe this is related to issues concerning the fact that ArcGIS 10 does not like to read more than the first 2048 records by default unless it is forced to (similar behavior restictions occur if you do not press the go to last record button in a tableview with more than 2048 records in it).  The Complete List button should force the read of the entire table, so I consider this a bug that it does not.  But at least the Count option forces the full table read. ... View more

Hi All, We have been encountering problems lately while editing (using 10 sp 2). The speed of ArcMap while editing slows to a crawl, and snapping will not work (unless classic snapping is enabled). I was wondering if anyone else has encountered this issue? Thanks, Angela This is always a problem in all version of 10 I have used (SP3 currently) and I find it virtually unusable.  If the spatial index of a layer is not operating correctly it make editing nearly impossible.  Since we went from Oracle to SQL Server our parcel layer's spatial index does not work correctly which makes editing nearly impossible if the new snapping environment is on, since that layer is our biggest.  But the same problem occurs if there are a large number of layers in the map.  The more layers and the larger number of features in the layers has a huge effect on snapping performance with the new snapping environment.  I have not tried experimenting with adjusting snapping tolerances, but that would be one place to start.  Other than that contact Tech Support as suggested above. ... View more

I'm just doing a simple statement to try to fill in a field.  I don't know any coding or scripting languages.  See attachment for an example.  The field I'm filling in is a text field with 12 characters.  The same thing happens (nothing) whether I'm in an edit session or not.  I'm hoping there's just some setting I could change or a box that needs to be checked that didn't exist in Arc9. The calculation you posted should work, so why it doesn't is a mystery.  I agree that the Field Calculator is indespensible and if I had a problem like this I would be on the phone with Tech Support immediately.  I have 10 SP3 on my machine and it would do this calculation without a problem.  About the only buggy behavior I have had is when a Personal Geodatabase is in an edit session I have to save after each Field Calculator operation to get it to do another calculation.  Contact Tech Support. ... View more

Hi, To calculate the values in Field: "Start_time" using those in Field: "Period_Sta", I tried expression below. However it doesn't work. Can anybody help to debug it? Thanks If [Period_Sta] =="01/01" Then [Start_time]= �??1�?� elseif  [Period_Sta] == "01/04" Then [Start_time]= �??91�?� elseif  [Period_Sta] == "30/09" Then [Start_time]= �??273�?� elseif  [Period_Sta] == "31/12" Then [Start_time]= �??365�?� end if Try adding an unqualified Else condition at the end that calculates [Start_time] = [Start_time] if none of the other conditions are met.  Also, if [Period_Sta] has Null values you either need to select non-Null values first or else make the first condition If IsNull([Period_Sta]) Then [Start_time] = [Start_time] ... View more

Thanks James for your reply. I have had no success with this problem. When I do as you suggested with 'Add Values' and 'Complete List' there are no other categories. I believe I tried that before I posted, so no change there. I am not using any definition queries on this layer. I have just found another MXD that has the same layer and it appears to be drawing properly there. I just need to verify it's symbolizing exactly the same, but I think I'm set for now. Thanks again. Prior to attempting to "Add Values" you should first click the "Count" heading in the main Symbology dialog window.  If there are any unsymbolized values they will be counted under the top "all other values" group.  If any value other than 0 appears in that category you have missed some grouping values.  I also find that sometimes after all the records have been read to populate the "Count" values that suddenly "Add Values" will show values in the "Complete List" that it did not show when I used it prior to doing the "Count".  Let us know if this helps. ... View more

Thanks, you help was greatly appreciated.  In my specific case the attribution is the most important part of the data.  Is there anyway to keep the attribution attached to the data throughout the transformation process (from pts. to polyline to polygon)? Thanks Give an example of an "Attribution" from a set of points to a polygon.  Are you talking about one attribute or many attributes?  Do all of the points that make up the Polyline or Polygon have the same attribute value for every point or does this involve a one to many relationship?  If the relationship is one-to-one for all attributes then transferring the attributes should be relatively simple.   But if each attribute has a one-to-many relationship then you must use aggregation tools and you ought to have an ArcInfo license to use the full set of tools that handle that relationship in GIS.  The methods for creating the polyyline and polygon should preserve one value from the points that aggregated them into the polyline or polygon that can should be usable as a join value.  If not then a Spatial Join may be needed, but I would be surprised if that was necessary.  Anyway, you have not given enough information. ... View more