ArcGIS Desktop – Creating Summary Table of Symbology for Multiple MXDs

arcgis-desktoparcpycartography

This is related to the following Retain ESRI symbology in Mapinfo TAB . As an initial step (in arcpy) I want to access the symbology of all the datasets and create a document which has the details of the symbology as per the graphic below.
enter image description here

Is this possible (should I invest the time to work it out) or if it isn't possible I will just have to get cracking on doing it manually on hundreds of MXD's (:-

To break down the steps -hopefully I can automate at least part of the process.

scrolling through mxd's and getting the datasets that are on is no problem

lyrFile = arcpy.mapping.Layer
if lyrFile.visible == True:
as it finds a dataset it should create a .lyr file (as most are just shp/gdb files) and then AttribXXX=lyrFile.xxx

where XXX and xxx are

BRIGHTNESS = lyrFile.brightness

(above format to following)

CONTRAST —contrast
DATASETNAME —datasetName
DATASOURCE —dataSource
DESCRIPTION —description
LABELCLASSES —labelClasses
LONGNAME —longName
NAME —name
SHOWLABELS —showLabels
TRANSPARENCY —transparency
WORKSPACEPATH —A layer's workspace or connection file path

The issue is I can't find anything that gets the RGB, line/point/polygon type, line weights, font etc. If these can be found then the next step

write each of the values above to a CSV (easy)…for example (this has to be expanded)

                f = open(origPath+'\\LayerAtrributes_LOG.txt', 'a')
                f.write(str(DATASETNAME)+","+str(DATASOURCE)+","+str(DESCRIPTION)+","+str(MXDName)+"\n")
                f.close()

If possible a jpg of the symbology should be produced as in the example and the link to it added to the csv.

Am is asking to much of arcpy?

Best Answer

I solved a similar problem by converting an MXD document to a MSD (which is just a zip file) so if you change the extension to ".zip" and open it you will find some .xml documents that contain alot of information about how each layer within the mxd is displayed. arcpy.ConvertToMSD There might be some work involed in getting the information you want but it should be in there somewhere. Hope that helps!

Related Solutions

ArcGIS Clipping Raster – How to Clip Raster by Multiple Datasets or Polygons?

One thing I notice is that your third parameter is a hard coded output (C:/data/lidar). The way it's written now will loop through each of your features and overwrite the output every time, but since you may not have allowed the automatic overwriting of files, this could potentially be the hang-up. Try creating a unique output name for each iteration:

#creating a workspace and a list of feature classes
arcpy.env.workspace = "C:/data/lidar/lidar.gdb"
fcs = arcpy.ListFeatureClasses()

#looping through each feature class and creating a raster based on the extent of   
#feature class

i=0
for fc in fcs:
    outputPath = "C:/data/lidar" + str(i)
    i+=1
    arcpy.Clip_management("perth", "#", outputPath, fc, "", "ClippingGeometry")

Also, I'm not certain that you intended to place the outputs in the C:/data folder named lidar... note that the third parameter in clip is the full path of your output raster, not a folder that it will be placed in. If you don't specify an extension in your output path name and place them in a standard folder, it will be a grid, so right now your program is attempting to create a new grid dataset named 'lidar' in the C:/data folder.

[GIS] Creating summary table using ArcMap 10.2 Report Wizard

It seems that it only provides this functionality if you group by a field, so you need at least 2 fields in your data. So in short, the answer is no. Not the way you want to do it. The main function of the reporting tools is to allow you to summarise data by groups.

Below I've tried to outline the process of creating the summary you want using a group.

I've created a single point feature class with 2 fields. One called "Type" as text. The other called "Number" as short field (this 2nd field could be whatever you want - could even be blank).

enter image description here

I will summarise this by the "Type" field.

Start the Report Wizard (View > Reports > Create Report)
Select both the "Type" and "Number" fields for the report and click "Next".
Now create a group for the report based on the "Type" field. To do this double click on "Type" under "Report Fields:"

enter image description here

It should look like this.

enter image description here

Keep clicking on "Next" and select your style, layout, orientation etc... -I've left everything as the default.
On the last screen select to "Modify the report's design" and then click "Finish".

enter image description here

The "Report Designer" will now open.
From the left hand "Design Elements" menu, select the "Text Box" and draw one anywhere on your report (you will move this later)
Now that you've drawn a box, you can drag it into the header called "gfType" on the report. This is the field that we grouped by.

enter image description here

It should look like this
Now make sure this new text box is selected, you will see an "Element Properties" window in the right hand side. Under "Data", set the "Data Field" to "Type" - This is the field we want to summarise by. Now inder Under "Summary":
Set the "Distinct Field" to "Type"
Set the "Summary Function" to "Count"
Set the "Summary group" to "ghType" (or whatever your group is called).
Set the "Summary Running" to "Group"
Set the "Summary Type" to "Sub Total"

enter image description here

Now click on the "Run Report" button (Top left)

You will see that the data has been grouped by "Type" and underneath each group there is a count of the total number of items in that group

enter image description here

Best Answer

Related Solutions

ArcGIS Clipping Raster – How to Clip Raster by Multiple Datasets or Polygons?

[GIS] Creating summary table using ArcMap 10.2 Report Wizard

Related Question