Convert Spatial Weights Matrix to Table (Spatial Statistics)

Summary

Converts a binary spatial weights matrix file (.swm) to a table.

Illustration

Swm files may be converted to .dbf tables and edited.

Usage

• This tool allows you to edit a spatial weights matrix file, if necessary:

  • Create a spatial weights matrix file using the Generate Spatial Weights Matrix tool.
  • Convert the resultant spatial weights matrix file to a table using this tool.
  • Edit the table and modify the spatial relationships as desired.
  • Use the Generate Spatial Weights Matrix tool to convert the modified table back to the binary spatial weights matrix file format.

Parameters

Dialog

Label	Explanation	Data Type
Input Spatial Weights Matrix File	The full pathname for the spatial weights matrix file (.swm) you want to convert.	File
Output Table	A full pathname to the table you want to create.	Table

Python

arcpy.stats.ConvertSpatialWeightsMatrixtoTable(Input_Spatial_Weights_Matrix_File, Output_Table)

Name	Explanation	Data Type
Input_Spatial_Weights_Matrix_File	The full pathname for the spatial weights matrix file (.swm) you want to convert.	File
Output_Table	A full pathname to the table you want to create.	Table

Code sample

ConvertSpatialWeightsMatrixtoTable example 1 (Python window)

The following Python Window script demonstrates how to use the ConvertSpatialWeightsMatrixtoTable function.

import arcpy
arcpy.env.workspace = "c:/data"
arcpy.ConvertSpatialWeightsMatrixtoTable_stats("euclidean6Neighs.swm", "euclidean6Neighs.dbf")

ConvertSpatialWeightsMatrixtoTable example 2 (stand-alone script)

The following stand-alone Python script demonstrates how to use the ConvertSpatialWeightsMatrixtoTable function.

# Create a Spatial Weights Matrix based on Network Data 

# Import system modules
import arcpy

# Set property to overwrite existing output
arcpy.env.overwriteOutput = True

# Local variables...
workspace = r"C:\Data\USCounties\US"

# Set the current workspace (to avoid having to specify the full path to the 
# feature classes each time)
arcpy.env.workspace = workspace

# Create Spatial Weights Matrix 
# Process: Generate Spatial Weights Matrix... 
swm = arcpy.stats.GenerateSpatialWeightsMatrix("USCounties.shp", "MYID",
                                               "euclidean6Neighs.swm",
                                               "K_NEAREST_NEIGHBORS",
                                               "#", "#", "#", 6) 

# Dump Spatial Weights to Database Table
# Process: Convert Spatial Weights Matrix to Table...       
dbf = arcpy.stats.ConvertSpatialWeightsMatrixtoTable("euclidean6Neighs.swm",
                                                     "euclidean6Neighs.dbf")

# Now you can edit the spatial weights (add, subtract and alter
# neighbors and weights)

# Read weights from table back into Spatial Weights Matrix format
# Process: Generate Spatial Weights Matrix... 
swm = arcpy.stats.GenerateSpatialWeightsMatrix("USCounties.shp", "MYID",
                                               "euclidean6Neighs.swm",
                                               "CONVERT_TABLE",
                                               "#", "#", "#", "#", "#", "#",
                                               "euclidean6Neighs.dbf")

Environments

Current Workspace, Scratch Workspace