How Do I?

  1. How do I connect to the City of Tucson GIS Geodatabase in 10.2 (VECTORSDE or EDITSDE)?
  2. How do I connect if I still have a version lower than ArcGIS 10.2?
  3. How do I access the City's orthophotos (RASTERSDE)?
  4. How do I change my license level (software product) in ArcGIS?
  5. How can I find out the installed version and service pack?
  6. How do I create a SQL Server alias?
  7. ArcMap randomly crashes.
  8. When I open ArcMap, it tells me that all licenses are currently in use.
  9. How do I install the Tucson Water font?
  10. When I open an MXD, I see a bunch of smiley faces for valves and other odd symbols.
  11. How do I get rid of the red exclamation marks next to the layer name in ArcMap?
  12. How do I get access to the PCLIS data on MARS?
  13. How do I edit an non-versioned feature class/table?
  14. Why does ArcMap take a LONG time to open or HANGS/CRASHES on startup?
  15. Why does ArcCatalog take a LONG time to open or close?
  16. What is the minimum required metadata?
  17. How do I use the ArcCatalog Set Data Source(s) tool?
  18. How do I connect to an ArcGIS Server map service?
  19. How do I fix a corrupted MXD?
  20. How do I quickly search for data layers?
  21. How do I change layer connection properties?
  22. ArcMap is SLOW.  How can I improve performance?
  23. How do I export layers to a new MXD?
  24. Where can I find the City's Access and Use Constraints?
  25. Error appears when trying to save edits in ArcMap?
  26. For More Information

 


How do I connect to the City of Tucson GIS Geodatabase in 10.2 (VECTORSDE OR EDITSDE)?

Solution: Follow the directions below to create a connection in ArcCatalog

  1. Open ArcCatalog
  2. Double-click on 'Add Database Connection' under the Database Connections folder
     
     
  3. Enter the following connection parameters
    • Database Platform=SQL Server
    • Instance=gisdb1\geo1
    • Authentication Type: Database authentication
    • Username=your novell login
    • Password=As assigned by the GIS database administrator or contact the Help Desk ***Please note this is only available to City of Tucson Employees***
    • Databases: vectorsde or editsde
    • Cick OK
  4. This connection can be used to drag 'n' drop data into ArcMap or it can be accessed from the 'Add Data' button in ArcMap.

Discussion: This above directions will connect the user to a geodatabase with polygon, line and point data from the City and external sources such as Pima County.

 Back to Top

 

How do I connect if I still have a version lower than ArcGIS 10.2?

Solution: 

1. In ArcCatalog click on 'Add Database Connection'

 2. Enter the following connection parameters:

service:  sde:sqlserver:gisdb1\geo1 AND database: vectorsde or editsde

service:  sde:sqlserver:gisdb2\geo2 AND database: rastersde

3. Click "Test Connection" and OK if "connection has succeded"

 Back to Top

 

How do I access the City's orthophotos (RASTERSDE)?

Solution: Follow the directions below to create a connection in ArcCatalog

  1. Open ArcCatalog

  2. Double-click on 'Add Database Connection' under the Database Connections folder 

  3. Enter the following connection parameters

    • Database Platform=SQL Server
    • Instance=gisdb2\geo2
    • Authentication Type: Database authentication
    • Username=your Novell login
    • Password=As assigned by the GIS database administrator or contact the Help Desk ***Please note this is only available to City of Tucson Employees***
    • Database=rastersde
  4. Cick OK
  5. This connection can be used to drag 'n' drop orthophotos into ArcMap or it can be accessed from the 'Add Data' button in ArcMap.

Discussion: This above directions will connect the user to a geodatabase with several years worth of orthophotos, DEMS and Hillshades.

Back to Top

 

How do I change my license level (software product) in ArcGIS?

Solution:

***Please note this requires administrator privileges on your PC if you're running Windows 7, and you may or may not need administrator privileges if running Windows XP***.

Close ArcMap and ArcCatalog. In the bottom right corner of the desktop right click on the green box with the key  or the blue circle with white trim and choose "Set ArcGIS License Level."  If you do not see the icon, click on the double arrows << to expand the icon tray.  If you still do not see the icon, try Start...All Programs...OpenLM...Agent...Start OpenLM Agent.  Select the desired license level and click the "Set" button and then the "Save" button.  This method of selecting the license level replaces the ArcGIS Desktop administrator method.

Discussion: The City of Tucson has several licenses at various levels: ArcView, ArcEditor, and ArcInfo (Professional). ArcView provides data visualization, query, analysis, and integration capabilities along with the ability to create and edit simple geographic features. ArcEditor includes all the functionality of ArcView and adds a comprehensive set of tools to create, edit, and ensure the quality of your data. ArcInfo includes all the functionality of ArcEditor and adds advanced spatial analysis, data manipulation, and high-end cartography tools.

At a minimum, the geodatabase editors require ArcEditor. While we have an unlimited number of licenses available to us, please use only when the  functionality your task requires - our next license agreement with ESRI will be based on how many and what kind of licenses we have used - we don't want to pay for more than we need.

Back to Top

 

How can I find out the installed version and service pack?

Solution: Close ArcMap and ArcCatalog.  Go to Start...Programs...ArcGIS...ArcGIS Administrator.  On the right hand side, you will find the version listed next to the label Product Version and the service pack listed under the header Service Pack Information.

Discussion: Do not use the build number found on the "About" window.

Back to Top

 

ArcMap randomly crashes.

Summary: ArcMap randomly crashes and Windows returns one of the error messages shown below

  1. The instruction 0x0000000 referenced memory at 0x0000000 which could not be read
  2. ArcMap.exe has generated errors and will be closed by Windows
  3. ArcMap has encountered a problem and needs to be closed

Solution: Try one or any combination of the following

  1. Uncheck any extensions that are not needed.
  2. Start ArcMap from the icon on the desktop or Start...All Programs...ArcGIS...ArcMap.  If ArcMap opens normally, then try the MXD.  If it crashed when opening the MXD, you could have a corrupted MXD.  Try these suggestions to fix the MXD.
  3. Backup and delete the Normal.mxt file located under C:\Users\YOURUSERNAME\AppData\Roaming\ESRI\Desktop10.2\ArcMap\Templates.  The next time you open ArcMap, this file will automatically be re-created.  If you do not see the Application Data folder, from the Tools menu in Windows Explorer, select Folder options.  Click on the View tab.  Under Hidden files and folders, select the option to "Show hidden files and folders."
  4. Start ArcCatalog first, then ArcMap.
  5. Reboot the computer.
  6. Try some of the suggestions on the ESRI Knowledge Base
  7. Reinstall or upgrade the video drivers
  8. Reinstall ArcGIS or apply the latest service pack

Discussion: Some of the above suggestions will require administrator privileges. For assistance, email the Help Desk or call 791-4370. Please screen capture any error messages.

Back to Top

 

When I open ArcMap, it tells me that all licenses are currently in use.

Solution:  Try a different license level. Follow the instructions for How do I change my license level (software product) in ArcGIS?. If you are unsuccessful, email the Help Desk or call 791-4370. Please screen capture any error messages.

Discussion: The City of Tucson uses a floating license architecture which means the software can be installed on any number of machines, but only finite number of licenses are available. If all the licenses are checked out, the software will not function.

Back to Top

 

How do I install the Tucson Water font?

Solution: Click here to download the font to some temporary location on your hard drive.  Most users will not have the ability to install the font on their PCs unless they have administrator privileges on their machine.  If you DO have admin privileges, go to the folder where you saved the font file, double-click the font file, and click the "Install" button/icon.  If at that point you receive errors, or you do not have admin privileges, email the Help Desk or call 791-4370. Please screen capture any error messages.

Discussion: The MXD layer stores the symbology.  If you open an MXD and it cannot find the Tucson Water fonts, it will substitute some other font file.  Do not save the MXD or the layer will save the substituted font.  Immediately close the MXD and install the Tucson Water fonts.

Back to Top

 

When I open an MXD, I see a bunch of smiley faces for valves and other odd symbols.

Solution: Close ArcMap without saving the MXD.  Follow the instructions for How do I install the Tucson Water font?  If you are unsuccessful, email the Help Desk or call 791-4370.  Please screen capture any error messages.

Discussion: The layers in the MXD store a pointer to the Tucson Water font file with the valve map symbols. If this font file is missing, ArcMap uses a default Windows font file such as Windings.

Back to Top

 

How do I get rid of the red exclamation marks next to the layer name in ArcMap?

Solution:

  1. Make sure you have a valid account and the correct connection properties by creating a connection in ArcCatalog.
  2. Find the name of the feature class from the layer properties:  right-click on the layer and open the layer's Properties. Select the Source tab to see the feature class name and location. Close the Properties box and proceed to the next step.
  3. Click on the red exclamation point to open the Data Source dialog box.
  4. Navigate to the location of the datasource.  If it is a shapefile, it will be a folder.  If it is a database, it will be under Database Connections.
  5. Scroll through the list of feature class, click to highlight, and click the Add button. This step will automatically reconnect any other data sources in the same workspaces, so you may notice some of the other red exclamation points are gone.
  6. Repeat the above steps for the remaining red exclamation points.
  7. Alternative to the above steps: try using the try using the ArcCatalog Datasource(s) tool

Discussion: The red exclamation points are indications of connection problems: database is down, data source missing, moved or renamed, invalid login/pwd.

Back to Top

 

How do I get access to the PCLIS data on MARS?

Solution: The folder location is \\MARS\STORAGE\MARS1.  Please email the Help Desk or call 791-4370 to have them grant access to your user account for this location.

Note: As of Aug. 18, 2014 - this location will be changing in the next few weeks, so you may need to call again.  This entry will be updated once the location has been changed.

Discussion: The PCLIS data is stored in the \az\counties\pima\shapes folder on the MARS server. The most commonly used data from MARS such as parcels and streets has been loaded for convenience into the GIS Database VECTORSDE.

 Back to Top

 

How do I edit an non-versioned feature class/table.

Solution:  Change to the edit mode in ArcMap by clicking Editor on the editing toolbar. Click "More Editing Tools". Click "Versioning". Uncheck Edit a version of the database with the ability to undo and redo.

Steps:

  1. If the Editor toolbar is not already open, click Customize on the main menu, point to Toolbars, and click Editor.
  2. Click the Editor drop-down menu on the Editor toolbar.
  3. Click Options
  4. Click the Versioning tab.
  5. Uncheck Edit a version of the database with the ability to undo and redo.
  6. Click OK.

Discussion: In this mode, you will no longer have the UNDO option. If you later need to perform versioned edits, you'll need to turn this option back on. More information can be found in the online help topics Configuring an ArcMap edit session to perform nonversioned edits and A quick tour of working with nonversioned data.

Back to Top 

 

Why does ArcMap take a LONG time to open or HANGS/CRASHES on startup?

Solution: First, determine if the problem is ArcMap or the MXD. Start ArcMap without opening an existing map. You can start ArcMap by clicking the Launch ArcMap button in ArcCatalog or from Start...All Programs...ArcGIS...ArcMap 10.x. 

If ArcMap hangs or crashes on startup, try some of these suggestions to fix ArcMap.

If ArcMap opens without problems, then the MXD is the most likely culprit. Try these suggestions to fix the MXD.

Back to Top

 

Why does ArcCatalog take a long time to open or close?

Solution: If you do a lot of geoprocessing, clear out the results by clicking "Geoprocessing" on the menu, then clicking "Results".  In the Results window right-click one of the session labels (Current, Previous, etc.) and click "Delete All".

 

What is the minimum required metadata?

Solution: Using the ArcGIS 10.x metadata editor, populate the required fields shown in red.  The blue fields are optional, but recommended. Click here for a PDF version.

 

 

Discussion: Here is a sample of completed metadata.

 

Back to Top

 

How do I use the Arc Catalog Set Data Source(s) tool?

Solution:

  1. In ArcCatalog, click/expand Folder Connections in the Catalog Tree.  Expand one of the folders, and browse to the desired MXD file.  Right-click the MXD a file and select Set Data Source(s).

  2. Select the first layer, highlight it and click the Replace All... button

  3. In the replace with box, manually type in the new database connection name you created in ArcCatalog and add .sde file extension. The default connection name is shown in the example, but if you’ve renamed it, just type it in exactly as you see it in arc catalog (plus the .sde suffix).

  4. Click Replace All.

  5. Click Ok and the new connection will be saved to the Output File listed at the top 

Discussion: This tools makes a copy of the original MXD. Only the layers are exported. Customizations (VBA code, UI Controls, custom toolbars), graphs, and table window appearance properties are removed from the MXD.

Back to Top 

 

 How do I connect to an ArcGIS Server map service?

Solution: Follow the directions below to create a connection in ArcCatalog

  1. Open ArcCatalog

  2. Double click GIS Servers on the left hand table of contents to expand

  3. Double click Add ArcGIS Server

  4. Select "Use GIS Services" and click Next.

  5. Enter the following server URL: http://www.tucsonaz.gov/arcgis/services

  6. Click Finish

Discussion: These maps service were designed for web applications, so you will see a drop in performance when used in ArcMap.  Some of the services are cached and will not be as current as the raw data in vectorsde or rastersde.

Back to Top 
 

 

How Do I Fix A Corrupted MXD?

Solution:

  1. If you have not already done so, make sure ArcGIS Desktop is operating normally by opening a blank MXD and then opening the MXD in question.  If ArcMap hangs or crashes on startup, try some of these suggestions to fix ArcMap.
  2. Try opening the MXD on a different machine.
  3. Remove and Bing, Google or ArcGIS online layers to see if this makes any improvements to performance.
  4. Open the MXD, clear the geoprocessing results from ArcToolbox.  Save the MXD.
  5. The MXD could have broken layers.  Try using the ArcCatalog Datasource(s) tool;or wait to see if the MXD eventually opens.  When it does, look for red exclamation points and fix using these instructions.
  6. Try using theMXDDoctor.
  7. Try using the MXD Degragmenter.
  8. Export the layers to a new blank MXD
  9. Delete the MXD and start with a new empty MXD, thereby having to recreate the properties for layers from scratch.
  10. The MXD may have connections to a SQL Server database instance that was moved or no longer exists. With direct connect, the instance name is stored in the connection string. Click here for directions on creating an alias to redirect the connections to the new instance.
  11. The MXD may have connections to an Oracle database that was moved or no longer exists. With direct connect, the TNSNAME is stored in the connections string. Update the TNSNAMES.ORA file. MAKE A BACKUP BEFORE EDITING!!
  12. The MXD may have connections to a server that was moved or no longer exists. Edit the c:\windows\system32\drivers\etc\hosts file by typing in the old server name next to the new IP. MAKE A BACKUP BEFORE EDITING!!
  13. Look to see if the mxd has a picture inserted that no longer has the same path. Delete the picture then re-insert it.

Back to Top

 

How do I quickly search for data layers?

Solution:

  1. Set up a Search Index for your connection to vectorsde.  Specific directions can be found on the ESRI desktop help page: Using Search in ArcGIS

Back to Top

 

How do I change layer connection properties?

Solution: For SDE database feature classes or tables

  1. Open the MXD.
  2. From the GeoProcessing menu, select Python to open the Python window.
  3. Execute the following commands and be aware the objects and methods are case-sensitive and MyConnection.sde is the name of the Target database connection as you see it in ArcCatalog.
  • mxd=arcpy.mapping.MapDocument("CURRENT")
  • mxd.replaceWorkspaces("","NONE","Database Connections\\MyConnection.sde","SDE_WORKSPACE",True)

 

Discussion: As long as the feature class name is the same, this method can switch the database, dataowner or login.  If it cannot find the feature class in the Target database, it skips that layer.  With some slight modification to the code, it can be used to switch workspace types, such as SDE to File Geodatabase. 

mxd.replaceWorkspaces("","NONE","c:\\gis\\roads.gdb","FILEGDB_WORKSPACE",True)

See ArcGIS Help for more information on updating and fixing data sources with the arcpy.mapping module.

 Back to Top

 

ArcMap is SLOW.  How can I improve performance?

Solution: Try one or more of the following.

  1. Use the feature cache.

  2. Remove or turn off Bing, Google or ArcGIS online layers to see if this makes any improvements to perfomance.

  3. Turn off layers you do not need.

  4. Turn off unnecessary labels and maptips.

  5. Pause labeling or drawing (F9).  These actions can be found under the View... menu.

  6. Remove unnecessary joins or relates.

  7. Avoid using transparency on layers and halos on labels.

  8. Avoid using complex symbology.

  9. If you do a lot of geoprocessing, clean out the results history.

  10. Close ArcMap and delete the Normal.mxt from the folder C:\Documents and Settings\Login Name\Application Data\ESRI\ArcMap\Templates

  11. If you are having performance issues while editing

    • Open a blank MXD and add only the data layers that will be modified. 

    • Do some test editing. 

    • If you see a noticeable increase in performance, the issue could be a problem in the layer properties such as it's been corrupted, or the definition query is bad, or the symbology is overly complex. 

    • Go back to the MXD where you experienced the problems and check the layer properties for bad connections or definition queryies or complex symbology.  If there is nothing wrong with the layer properties, it could be corrupted so export the layers to a new MXD.

  12. The problem could be a corrupt MXD.  This has been know to happen to MXDs that were originally created in a previous version.  Export the layers to a new blank MXD or try these suggestions to fix the MXD.

Back to Top

 

How do I export layers to a new MXD

Solution: There are several ways, here are a few:

  1. Using drag and drop
    • Open a second instance of ArcMap with a blank MXD.
    • Drag and drop layer from the original MXD to the new blank MXD.
    • Save the new MXD.
  2. Using layer files
    • Right click a layer and select "Save as layer file"
    • Open blank MXD and add the layer that was save to disk in the previous step.
  3. Using group layer files
    • Select several layers usings Shift-Click
    • Right click and select "Group"
    • Right click on the newly created group layer and select "save as layer file"
    • Open blank MXD and add the layer that was save to disk in the previous step.

Back to Top

 

Error appears when trying to save edits in ArcMap

Error Message #1:

Your edits could not be saved because the target version has been updated since you started editing.  These edits have been merged into your edit session.  Review the change and save again.

Solution: As instructed in the error message, try the save again.

Discussion:  This message appears because there are other editors are in the geodatabase workspace.  You can prevent this message from appearing.  From the editor toolbar in ArcMap, select Options.  click on the versioning tab.  Choose the option to "Automatically save changes only if there are no conflicts"

Error Message #2:

Unable to save edits.  Unable to reconcile : the target version is currently being reconciled against. [sde.DEFAULT] The versions has been redefined to reference a new database state. [sde.DEFAULT]

Solution: Wait a minute or two and try the save again.

Discussion:  This error appears when you are attempting to save edits at the same time as another editor in the geodatabase workspace.

Back to Top

 

For More Information?

  1. The ESRI web site has on-line resources: Desktop Help 10.x
  2. On-line trainings are also available, some are free: Training Catalog
  3. ArcGIS 10 Tips and Shortcuts brochure: brochure

Back to Top