Fishbone Analysis README @John Ehlen | 2020 Purpose: The purpose of this document is to assist the user in setting up and running the small python script which will generate the fishbone connection lines. It will describe what a fishbone is, how it can be used, and the steps the user will take to create a the fishbone lines. What is a ‘Fishbone Analysis’? A fishbone analysis is a structured process which can be useful for determining the underlying causes behind certain problems by visually evaluating cause and effect. In terms of GIS and attribution, this analysis will allow you to visualize attribution errors between road centerlines and address points. this is done by comparing the original address location to the geocoded address locations position along a street centerline. Some of the attribution errors that can be visualized are: • Addresses or road address ranges are out of numerical order • Addresses or road address ranges are on the wrong side of the street • Addresses or road address ranges are on the wrong block • Addresses or centerlines with missing or invalid street pre-directional, post-directional, street name, incorporated municipality, ESN, etc. Files contained within the downloaded ZIP along with this README: -ConnectionLines.py -these is the small python script that you will run to create the lines. -FishboneAnalysis.mpkx -ArcGIS PRO Map with data included. -Data.gdb -An ESRI file geodatabase containing the same data as the ArcGIS PRO Project. This database is for people to use with ArcMAP if they do not have access to ArcGIS PRO. ----------------------------- ArcMAP Process: To generate the fishbone connection lines with ArcMAP follow these steps: 1. Open a new blank session of ArcMAP 2. Connect to the file geodatabase(Data.gdb) included in the downloaded folder with this file 3. Add all files inside file geodatabase(Data.gdb) to ArcMAP Table of Contents 4. Access Python Window in ArcMAP 5. Copy contents of file "ConnectionLines.py" into ArcMAP Python Window 6. Run Python Optional: 7. Delete all connection lines from the connection lines feature class by using: arcpy.management.TruncateTable('Connection_Lines') 8. Repeat steps 4-6 ----------------------------- ArcGIS PRO Process: To generate the fishbone connection lines with ArcMAP follow these steps: 1. If you have ArcGIS PRO Installed, Double Click on the file "FishboneAnalysis.mpkx" included in the download. This will automatically launch a new session of ArcGIS PRO with the data, labels, and symbology contained in the project. 2. Access Python Window in ArcGIS PRO 3. Copy contents of file "ConnectionsLines.py" into ArcMAP Python Window 4. Run Python Optional: 5. Delete all connection lines from the connection lines feature class by using: arcpy.management.TruncateTable('Connection_Lines') 6. Repeat steps 2-4 ----------------------------- Connection Lines You should now have a set of connection lines linking the original address point to the geocoded address point. If you do not see them, you may need to refresh your map using the button in the bottom right corner of the map in ArcGIS PRO. You may also need to zoom in, depending on how far you zoomed out when exploring the map.