Latest Contributions by RobertBorchert

Because it is looking for the excel table on your computer. i.e say you put it in c:\exceltables\  and you put the mxd on your network and your network is the s:\ drive it does not have c:\exceltables\ You need to put the spreadsheet on the network and re-path your mxd to point to that directory. I am using an excel spreadsheet, joining it to some data in my map. I have been able to join if i put the spreadsheet on my computer, but if I try to access it over the network, it will not connect. I get "failed to connect to database. General function failure. External table is not in the expected format. Can someone tell me why it will connect from my computer but not thru the nextwork?  Is there a limit to the number of characters in the path? ... View more

Geodatabases contain Info Tables.  you can export to a .dbf ... View more

Did you run the analysis before attempting to upload? In the service editor window there is a button for Analyze.  Click that and it will Analyze your data for errors that you will need to resolve before uploading. . Hi, I tried publishing a 30-million-point feature class (585 MB) to AGOL yesterday. I was using Desktop 10.2 and the feature class only had a couple of text attributes. After spinning for five hours, I got an unknown error message (probably related to the size of the dataset!) and the publishing process failed. Has anyone tried something similar and are there any known limits to the capacity of hosted feature services? In the past, I have seen an AGOL hosted feature service with half a million polygons, which must have had several million vertices, but it's quite possible that the feature count is more important than the number of vertices in deciding whether the publishing process succeeds or not. Many thanks, Simon ... View more

You need to determine for sure that your referencing feet and not another unit in your data frame. Try it with the buffer analysis tool instead.  there you can specify which units to use. Well, I thought so too, but not in this instance.  I'm using NAD27, State Plane 4204, US Feet and attempting to put an 8,000' buffer around county abstracts.  When I measure the distance from the edge of the polygon to the edge of the buffer, I'm getting about 6,880'. ... View more

Our field crews haven't complained about it.  We have mounts in the trucks and they are mounted to them.  Normal lcd screens are all going to be difficult to see in direct sunlight. You need a device that is made to work anywhere such as a SOL 10" Windows Tablet How did you overcome the sunlight issue? We have a hard time seeing anything on the screen, even with the brightness on 10 (it won't go to 11, trust me). ... View more

iPads work good for us.  We enclosed them in some pretty good cases. ... View more

I was just going to suggest exporting it to a Geodatabase.  I export to an MS Access database and then go in and edit the domain attributes. [SUB][/SUB] ... View more

For situations like this I would have detail levels based on each floor.  And like someone else eluded to I then add each layer form each floor and group them and then use definition queries to distinguish between floors.  I would then manually turn each floor off or on.  We did this for a main office building once and had to stack the floors because we also wanted to draw in the wire conduits and make a 3D representation. We printed in 2D. However, IF you don't need them to be spatially correct the idea of offsetting them is a very good idea. our main office building has 4 floors and it does not need to be spatially correct so we offset the floors by 200 feet and base the data driving pages off each floors polygon. We did not need the conduit for this as it was being used as basically a seating chart. ... View more

enter the definition query dialog for the features Layer Properties Click on Query Builder. Build your definition query here just as you would a search query.  Essentially the definition query is the same as search. ... View more

Be advised if you have a large amount of data over a wide area and you use tiled mapping it will chew up  LOT of credits. Another option is to create annotation. Then use Feature Outline Mask on the annotation.  It will create a new feature class from the annotation that you can then upload.  You will have to play around with it a few times to get the clearest result. What I did for one of my  clients.  They needed to have the last 1, 2 or 3 digits of their customers id visible on ArcGIS online.  so I created symbols based on that.  Yes I had to manually make a lot of number, most of them were 1 or 2 digit. I also created section centers as points and symbolized them as numbers. Don, when uploading your feature services with labels you also need to check Tiled Mapping. This will consume credits but you will have labels. I should have clarified that. Tim ... View more

The system is buffering is based on the units in the projection. search for   buffer analysis and use that tool instead.  There you can specify the units you want and will buffer in those units. Or if you can figure out the conversion simply do that.  One of my clients systems is in Meters and I need to do a 500 foot buffer around underground power lines every now and then.  I simply select the lines and put in 152.40 which is in meters. ... View more

Unfortunately I do not have a copy of 10.0 anymore to explore options. I believe what I described was added in 10.1 ... View more

You should not be able to determine a lake depth based on surrounding topology.   Lakes are formed in different ways and that is a significant factor in how deep it is. Typically very round lakes are often meteor impacts.  They will be very shallow and have raised edges.  This is not always true.  We have a large lake near where I live that is very round and has raised edges but is exceptionally deep and is fed by a spring at 106 feet. Thin very deep lakes are often formed by glaciers or erosion etc... what state are you in?  Some states DNR's provide bathymetric A DEM will typically show the elevation of the lake surface at the time it was made.  Bathymetrics used to be made by throwing a weighted rope into the water and marking how deep it goes.  modern technology uses sonar.  The technology used to generate modern DEM cannot penetrate water surface. You are right the DEM does not have bathymetry, the lakes just show up flat. Ist there I way to calculate the depth by using the elevation of the surrounding areas? Thank you so much for the help ... View more

if you only need to do it once don't over complicate it. just create the new attribute with the name you want and then populate it with the attributes from the old attribute. Or if your careful simply rename it in Access. Hi, Can I rename a feature class attribute with ArcObjects (FGDB, SDE) ? I'm using IClassSchemaEdit4.AlterFieldName and it seem to work in a FGDB. I'm asking the question because I have often read that I can't rename a feature class attribute with ArcObjects... Thanks ... View more

After you create your legend right click on it and select properties.  Click on the Items Tab. Select the feature you want to only show items when visible. Under Map Extent Options check the box for Only show classes that are visible in the current map extent and check Use Current index feature as the map extent (data driven pages) if you want the legend to ONLY display what is on that Data Driven Page If that does not work I would say  your page definition is interfering. Try hitting refresh data driving pages button after you customize your legend. ... View more