[GIS] Tables within the Reclassify tool- what is it, where is it

arcgis-10.1arcmapexcelreclassifytable

ArcMap 10.1 here. I have a raster set I'm looking to reclassify. The field I need to re-classify is currently a string of words like "Thing 1" and "Thing 2" and I'm going to set them to be 1 and 2.

I understand that you can create essentially a table within the reclassify tool, save it, and then use it again in another operation. What type of file is this, and where is it found? I can't find it in windows explorer, but it does show up in arc catalog.

Reason is, I have an excel sheet where all of my "Thing 1"s are matched up with the number I want. Let's assume there are thousands of "Thing 1"s and renumbering them within the reclass window would be impractical.

Is there a way to
(A) edit a reclass table within excel
(b) have arcmap reclass tool read in my excel, dbf, csv, or some other kind of file?

Thanks for thoughts, suggestions

Best Answer

The File type of the table is "Info Table" .You can add the table in ArcMap => Right click to the table => Data => Export = > Export your Info table to the Text File. Import the text file to Excel :

Open Microsoft Excel
Select Data tab
Click From Text
Import your Text File then save the Excel. change your reclassify then import the Excel to Arcmap and export to Info Table.

Another option is use of Xtools pro to export the Info table to Excel.It's better than the first method because if it's maintain all of the Languages and Characters from Info Table to xls Format.

Related Solutions

[GIS] Offsetting points perpendicular to line using ArcMap

I found a way! I used a couple of different sources and manipulated the script to fit my needs (mostly from gotanuki on StackExchange). A variation of this is already on the site, but the of data that I was using is different. In case someone else runs into this issue, this is the solution I used:

# Define orientation (start, mid, end) and draw Matchlines function
# This function is defined before it is called
def orientMatchlines(feat,ix,iy):
        # If the line is horizontal or vertical, the slope and
        # negative reciprocal calculations will fail, so do this instead
        if starty==endy or startx==endx:
            if starty == endy:
                y1 = iy + matchDist
                y2 = iy - matchDist
                x1 = ix
                x2 = ix
            if startx == endx:
                y1 = iy
                y2 = iy
                x1 = ix + matchDist
                x2 = ix - matchDist
        else:
            # Get slope of line
            m = float((starty - endy)/(startx - endx))

            # Get negative reciprocal
            negativereciprocal = -1*((startx - endx)/(starty - endy))

            # For all values of slope, calculate perpendicular line
            # with length = matchDist
            if m > 0:
                if m >= 1:
                    y1 = negativereciprocal*(matchDist)+ iy
                    y2 = negativereciprocal*(-matchDist) + iy
                    x1 = ix + matchDist
                    x2 = ix - matchDist
                if m < 1:
                    y1 = iy + matchDist
                    y2 = iy - matchDist
                    x1 = (matchDist/negativereciprocal) + ix
                    x2 = (-matchDist/negativereciprocal)+ ix
            if m < 0:
                if m >= -1:
                    y1 = iy + matchDist
                    y2 = iy - matchDist
                    x1 = (matchDist/negativereciprocal) + ix
                    x2 = (-matchDist/negativereciprocal)+ ix
                if m < -1:
                    y1 = negativereciprocal*(matchDist)+ iy
                    y2 = negativereciprocal*(-matchDist) + iy
                    x1 = ix + matchDist
                    x2 = ix - matchDist
        point1.X = x1
        point1.Y = y1
        point2.X = x2
        point2.Y = y2
        lineArray.add(point1)
        lineArray.add(point2)

        del x1
        del x2
        del y1
        del y2

# Create search cursor in inLine
rows = arcpy.SearchCursor(inLine)

# Get number of records in inLine
numRecords = int(arcpy.GetCount_management(inLine).getOutput(0))

# Create new point files and array to collect values
point1 = arcpy.Point()
point2 = arcpy.Point()
lineArray = arcpy.Array()

# Define counter
counter = 0

# Loop over rows in outLine
for row in rows:
    # Create the geometry object
    feat = row.Shape

    # Get coordinate values as lists
    firstpoint = feat.firstPoint
    lastpoint = feat.lastPoint
    midpoint = feat.centroid

    # Get X and Y values for each point
    startx = firstpoint.X
    starty = firstpoint.Y
    endx = lastpoint.X
    endy = lastpoint.Y
    midx = midpoint.X
    midy = midpoint.Y

    m = ((starty - endy)/(startx - endx+.0001))

    # For all points besides the last one
    if counter < numRecords - 1:
        orientMatchlines(feat,startx,starty)
    # For the last point
    else:
        orientMatchlines(feat,endx,endy)

    #Create insert cursor
    cur = arcpy.InsertCursor(matchlines)

    #Insert new row from array
    feat = cur.newRow()
    #feat.slope = m
    feat.shape = lineArray
    cur.insertRow(feat)
    lineArray.removeAll()

    del cur

    # Increase counter by 1 and start again
    counter = counter + 1

del row
del rows

[GIS] Joining field works in ArcMap but not in ArcPy

The input for AddJoin_management needs to be a feature layer, not a shapefile or feature class.

You can get around this by making a feature layer, and then joining that layer to your table. (You'll still get the "not indexed" warning, but that shouldn't prevent the script from executing.)

arcpy.MakeFeatureLayer_management("merged_lines.shp", "tempLayer")
arcpy.AddJoin_management("tempLayer", "filename", "merged_table.dbf", "filename")

Best Answer

Related Solutions

[GIS] Offsetting points perpendicular to line using ArcMap

[GIS] Joining field works in ArcMap but not in ArcPy

Related Question