Latest Contributions by DonovanCameron

Is your CSV/Spreadsheet a publicly available data set? If you are allowed to share where that is, it would help someone offer a relevant solution as they work through the process you are looking for themselves. EDIT: Forgot to ask, do you have the Spatial or 3D Analyst extension available? ... View more

Have you tried opening the two MXDs located at C:\Program Files (x86)\ArcGIS\Desktop10.1\plotters. Thanks! Those were them. The one I normally use for calibration is CMY_PlotterCalibrate.mxd ... View more

Does one of the layers in the data-frame have a transparency or a graphic inserted? Any layers that have a transparency enabled will cause that "white" background effect and also, exporting to a vector based format will cause the white background to show up. See: http://forums.arcgis.com/threads/21701-inserting-a-png-or-image The workaround was to export the map to a raster like a jpeg, png, tiff... I also found recently that if I used ArcMap's export to PDF (from File pulldown) it would show the white background. I had to "print" the map using a PDF printer driver like "Adobe PDF" which would print the layout to a pdf file and that did not show the white background. ... View more

The second method you cite is keeping the size and font EXACTLY what I need, HOWEVER, when I insert the excel spreadsheet, it's adding on extra rows (blank ones). I'm wondering how to just insert the rows I need. I assume it has something to do with the excel formatting in the file I'm insert? I've never had that happen. My only issues were the opposite with not all records being displayed because there were too many. Sounds like there could be a suspect character (like a space) or some type of formatting (border lines applied, cell format -number or text is explicitly defined) in a cell somewhere down there. I would open a new excel spreadsheet, and copy and paste from the old file to the new file, then insert that new file into the layout. ... View more

Two ways to do this. 1st, format the table in excel how you need it to look. Highlight the cells you need and Copy (Ctrl+C) then Paste (Ctrl+V) into the arcmap layout. That leads to a more static type of table. A better way is to use the import tool. From arcmap, select the "Insert" pulldown menu and select "Object...". Click the radio button beside "Create from File" and "Browse..." to your file and once found, press OK. This table that gets inserted can then be formatted on the fly. Simply double click it, which will open up the table in excel where you can apply your required formatting and see it in the layout in real-time. No need to save the excel file, just format and close it to see the changes in the layout. I've found only one small drawback for using the "Insert" method and that is that there seems to be a limit to the amount of records that will be brought in. I can't remember what the row limit was or if it was a bug that got patched for 10.1.... ... View more

But how do I set it that it would only label the "Lake A", the "Lake B", and the "Lake C" ? I don't think I can use wildcard like the '%' in my case, as sometime the names of the water features goes like this "Lake A", or "B Lake"; "B River", or "River B". If you have a small set of records you want to label, try using OR. [LEFT]Function FindLabel ( [NAME] )   if ( [NAME] = "Lake A" ) OR ( [NAME] = "Lake B" )  then     FindLabel = [NAME]   end if End Function[/LEFT] If your OR statement is getting large, try to incorporate the IN operator instead of OR. [NAME] IN ('LAKE A', 'LAKE B', 'C LAKE') Although I always have trouble including IN inside a vbscript label expression, mostly because the syntax is different depending on the data storage format (shapefiles vs geodatabase, etc...). ... View more

You can apply a similar type of query that applies only to the labels. Open the properties for that layer and go to the Label tab. Select the field to label by (ie, [FEAT_NAME]) and press the "Expression" button. Place a checkmark beside "advanced" and read over this recent thread on how to do just that. http://forums.arcgis.com/threads/63054-Labels-again.-Sorry Let the forum know if you have any issues. In your case, you may need to incorporate a wildcard like the '%' operator, inStr function, or a regular expression. ... View more

I think it's just a small syntax error. [LEFT]Function FindLabel ( [FCODE], [ELEVATION] )   if ( [FCODE] = "HA90000000" ) then     FindLabel = [ELEVATION]   end if End Function[/LEFT] Because the value of [FCODE] is a string, it needs to be enclosed in double quotes. ... View more

Yes, you can do this with dynamic text placed in the layout. See: http://gis.stackexchange.com/questions/7458/labeling-coordinate-value-at-4-corners-of-graticule-in-arcgis ... View more

Great suggestions so far, especially the reference to the arcscripts available. If you can't get any of those to work, try GDALs gdaltindex function: gdaltindex output.shp input.tif For batch processing: gdaltindex output.shp folder/*.tif You can open the shapefile in arcgis when finished. ... View more

I think because the annotation is stored as a "feature class" you have to actually start an edit session with the annotation as your target layer before you are able to re-position the anno. You can freely move annotation in data view (or a focused data frame in layout view) when it is saved in the map as an "annotation group". ... View more

FYI. I am experiencing some strange results as the moment using the Clip tool... Can you verify what projection your datasets are in? Check to see that they are using the same projection and coordinate system before running the clip. I've had suspect results when trying to do analysis on datasets that are in different projections. If you are still getting problems try some of the other suggestions like Extract by Mask. ... View more