Tuesday, April 24, 2012


Export Map with location & attribute information in PDF using ArcGIS 9.3 or Later

This tutorial will explain how to export ArcGIS Map with Location and Attribute information Portable Document Format (PDF).
PDF can contain layers so users can control the visibility of in Adobe Acrobat or Reader 6.0 or later.
So in addition to layers, the PDF can contain feature information from ArcMap Attribute Table that users can identify using the Object Data tool in Adobe Acrobat Reader and Adobe Acrobat
Export Map as PDF

1)      Click on File, then select Export Map
 2)      Select Save as type “PDF”
 3)      Click on Advanced tab
4)      Click on check box mentioning Export Map Georefrence Information
 
5)      If you want to Export Layers as well as theirs feature attributes then select the Export PDF Layers and Feature Attributes.
 
 Layers in ADOBE READER:
1)      Open Adobe Reader
2)      Click LAYERS tab on the left:
3)      Select or deselect EYE symbol to turn layers on and off.
  

4)      To see the attributes of features click on Model Tree Tab
5)      To see the Location information.
Click on Tools from menu bar select Analysis and select Geospatial Location Tool to see the Location Information.
if you are not able to find Advance tab under Map export window,
then might be you need to add Map Export Patch in ArcGIS 9.3.
To get this Export Map Patch click here.

Exporting ArcGIS Labels to AutoCAD Text

To exporting Labels you need a Geodatabase
1)    Right click on Layer from the Table of Content.
2)   Add Your layer in to the Map
3)   Select Label feature to make label visible in Map view.
4)   Right click again on layer from the table of content.

5)   Select Convert Labels to Annotation
6)   Convert Labels to Annotation window will open.
7)   For storing Annotation, Select store in Data base.
8)   Select the type for which feature you want to create annotation.
9)   And select the destination (select your database path, where annotation feature will be stored)
10) At the last before converting make sure you have click on the box of Convert unplaced labels to unplaced annotation.(this will help you to get each labels from Dense area)
11)  Then last click on Convert.
Now another main task
Open the ArcCatalog
1)    Go to the path where you have stored your Annotation features.
2)   Right click on annotation feature class and select export and then to cad…
3)   Select Export to CAD window will open select Output type and then select Output destination
4)   Click OK.
Now you can open the exported CAD features in AutoCAD.
Enjoy!!!!!!!!………

Connecting to an Excel Table for use in ArcCatalog and ArcMap (read only access) for pre-9.2

To connect to an Excel table so you can use it in ArcCatalog and ArcMap, follow these instructions:
  1. Close ArcCatalog before starting any of this.
  2. In your Excel table highlight the rows/columns you want in your table, including the field names. This is done so you can possibly have more than one table within an Excel document.
  3. From Worksheet Menu Bar, choose Insert > Name > Define. Give it a name.
  4. Click OK and Save your document.
  1. Open your system Control Panel and choose Administrative Tools > Data Sources (ODBC)
  2. On User DSN tab, click Add…
  3. Highlight Driver do Microsoft Excel Driver (*.xls) and click Finish.
  4. Fill in the Data Source Name with any name you wish. It doesn’t have to be the name of the xls file you are working with.
  5. Click Select Workbook…
  6. Browse and select your Excel document.
  7. In ODBC Microsoft Excel Setup window, click OK.
  8. In ODBC Data Source Administrator, click OK.
  9. Start ArcCatalog.
  10. In the catalog tree, click Database Connections.
  11. Double-click Add OLE DB Connection.
  12. Highlight Microsoft OLE DB Provider for ODBC Drivers. Click Next >>
  13. In Use data source name click the down arrow. You should find the name you set in step 8. Choose it.
  14. Click Test Connection to see if things are working OK.
  15. Click OK. A new entry under Database Connections should be listed by the name of OLE DB Connection.
  16. Open OLE DB Connection (or you may rename it first).
  17. There should be a table listed by the name you assigned in Step 3 above.


How to Add X- Y coordinates to a Point Shapefile’s attribute Table

Within a point shapefile, each point’s coordinates are stored with the shapefile under the
“shape” field. However, those coordinates are not directly readable. You can extract the
coordinates and save them into X (or longitude) and Y (or latitude) fields within the
shapefile’s attribute table. Here’s it how to do it.
1) In ArcMap open the attribute table for the point shapefile.
2) Click Options > Add Field… then add a field with the following characteristics:
Name: X_coord
Type: Double
Precision: 12
Scale: 5
Click OK and the X_coord field will be added to the attribute table.
3) Right-click on the name X_coord in the attribute table, select Calculate Values… then
click Yes to the message that appears about editing outside an edit session. The Field
Calculator window will appear.
X Y
4) In the Field Calculator window check the Advanced checkbox then type the following
code into the text box under Pre-Logic VBA Script Code:
Dim dblX as double
Dim pPoint as IPoint
Set pPoint = [Shape]
dblX = pPoint.X
5) In the window under X_coord simply type dblX then click OK. The X-coordinate value
for the points will be written into each cell within the X_coord field.
6) Repeat the procedure for the Y-coordinate by creating a Y_coord field and using the
following VBA script code:
Dim dblY as double
Dim pPoint as IPoint
Set pPoint = [Shape]
dblY = pPoint.Y
Be sure to type dblY in the window under Y_coord within the Field Calculator then click
OK. The Y-coordinate value for the points will be written into each cell within the
Y_coord field.