topic Re: Distance Calculation Python output Error in ArcGIS Pro Questions

Distance Calculation Python output Error

ParyaZareie — Mon, 09 Dec 2024 20:15:08 GMT

Hello everyone,

Our team is currently working on a distance calculation project in ArcGIS Pro to evaluate driving times between patients and a facility, with a 10-minute cutoff. We are developing a Python script for this task using the built-in notebook in ArcGIS Pro.

The final step of our process involves converting the resulting .gdb or .lyrx file into a CSV for further analysis. While we have successfully saved the solved OD Cost Matrix layer as a layer file on disk, we’ve encountered challenges in converting these files into a CSV or Excel format.

When attempting to convert the file into a pandas DataFrame or CSV to make it readable by a database, we encounter the error:
Error 999999: Something unexpected caused the tool to fail.

Any assistance or guidance would be greatly appreciated!

Any help greatly appreciated.

Re: Distance Calculation Python output Error

DanPatterson — Mon, 09 Dec 2024 20:24:06 GMT

If it is the table you are trying to export, see

Export Table (Conversion)—ArcGIS Pro | Documentation

Re: Distance Calculation Python output Error

ParyaZareie — Tue, 10 Dec 2024 18:14:35 GMT

We don't have a table yet to export. The output that we saved on disk is the .gdb file. We need to convert it into either CSV or Panda dataframe.

Re: Distance Calculation Python output Error

DanPatterson — Tue, 10 Dec 2024 19:57:42 GMT

you can't convert a gdb

you can convert a table in a gdb, once you have opened the table in Pro and tried the tool that is suggested