nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to convert a feature class attribute table to csv using arcpy?

JustinBridwell2

Is there an arcpy method/mod that allows for the exporting of a feature class's attribute table to a csv file? I see arcpy.ConvertTableToCsvFile_roads, but that requires a special license. I am currently trying an `ogr2ogr` solution, but I am working within an ArcMap 10.5/Python 2.7 env and thought there would be something I could use.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

irfanlatif

Wow dan, very nice.

Here are my way to export table to csv in case I dont want to use arcpy.TableToTable_conversion.

First iterrat over data set for fields and data.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">header_and_iterator</SPAN><SPAN class="punctuation token">(</SPAN>dataset_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
       <SPAN class="string token">"""Returns a list of column names and an iterator over the same columns
       Please see export_to_csv and export to excel for more details """</SPAN>

       data_description <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>dataset_name<SPAN class="punctuation token">)</SPAN>
       fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> data_description<SPAN class="punctuation token">.</SPAN>fields <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Geometry"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Raster"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Blob"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
       <SPAN class="keyword token">if</SPAN>  <SPAN class="string token">'Shape_Length'</SPAN> <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
           fieldnames<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Shape_Length'</SPAN><SPAN class="punctuation token">)</SPAN>
       <SPAN class="keyword token">if</SPAN>  <SPAN class="string token">'Shape_Area'</SPAN> <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
           fieldnames<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Shape_Area'</SPAN><SPAN class="punctuation token">)</SPAN>
       <SPAN class="keyword token">if</SPAN>  <SPAN class="string token">'FID'</SPAN> <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
           fieldnames<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'FID'</SPAN><SPAN class="punctuation token">)</SPAN>
       <SPAN class="keyword token">if</SPAN>  <SPAN class="string token">'OBJECTID'</SPAN> <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
           fieldnames<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">)</SPAN> 
           
    

       <SPAN class="keyword token">def</SPAN> <SPAN class="token function">iterator_for_feature</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
           cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>dataset_name<SPAN class="punctuation token">)</SPAN>
           row <SPAN class="operator token">=</SPAN> cursor<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
           <SPAN class="keyword token">while</SPAN> row<SPAN class="punctuation token">:</SPAN>
               <SPAN class="keyword token">yield</SPAN> <SPAN class="punctuation token">[</SPAN>getattr<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN> col<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> col <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">]</SPAN>
               row <SPAN class="operator token">=</SPAN> cursor<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
           <SPAN class="keyword token">del</SPAN> row<SPAN class="punctuation token">,</SPAN> cursor
       <SPAN class="keyword token">return</SPAN> fieldnames<SPAN class="punctuation token">,</SPAN> iterator_for_feature<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

then just export it to csv.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">export_to_unicode_csv</SPAN><SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> out_Path<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        
        <SPAN class="string token">"""<datasets, output> Export a feature class to a csv file.
        INPUTS:
        fc: path with name of feature class.
        output(required): Out put path.
        Notes:
        - Unicode data in CSV file is encoded in UTF-8.
               
        """</SPAN>
                
        header_row<SPAN class="punctuation token">,</SPAN> rows <SPAN class="operator token">=</SPAN> header_and_iterator<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
        
        output_csv <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>out_Path<SPAN class="punctuation token">,</SPAN> get_BasenamePrefix<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">".csv"</SPAN><SPAN class="punctuation token">)</SPAN>
        f <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>output_csv<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN> 
        <SPAN class="comment token">#f.write(codecs.BOM_UTF8) # Write Byte Order Mark character so Excelknows this is a UTF-8 file        </SPAN>
        csv_writer <SPAN class="operator token">=</SPAN> UnicodeWriter<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">,</SPAN> dialect<SPAN class="operator token">=</SPAN><SPAN class="string token">'excel'</SPAN><SPAN class="punctuation token">,</SPAN> encoding<SPAN class="operator token">=</SPAN><SPAN class="string token">'utf-8-sig'</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">if</SPAN> header_row<SPAN class="punctuation token">:</SPAN>
            csv_writer<SPAN class="punctuation token">.</SPAN>writerow<SPAN class="punctuation token">(</SPAN>header_row<SPAN class="punctuation token">)</SPAN>
        csv_writer<SPAN class="punctuation token">.</SPAN>writerows<SPAN class="punctuation token">(</SPAN>rows<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In the same way I have function to export to xls and xlsx.

DanPatterson_Retired

I did mention nulls...

OID_<SPAN class="punctuation token">,</SPAN> Int_nulls<SPAN class="punctuation token">,</SPAN> Float_nulls<SPAN class="punctuation token">,</SPAN> Text_nulls
 <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>    <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    a
 <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6.1</SPAN><SPAN class="punctuation token">,</SPAN> None
 <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">2.1</SPAN><SPAN class="punctuation token">,</SPAN> None
 <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8.1</SPAN><SPAN class="punctuation token">,</SPAN> None
 <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">12.1</SPAN><SPAN class="punctuation token">,</SPAN> None
 <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4.1</SPAN><SPAN class="punctuation token">,</SPAN> None
 <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN>    <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    b
 <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN>    <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    d
 <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10.1</SPAN><SPAN class="punctuation token">,</SPAN> None
<SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN>    <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    c
<SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN>    <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    f
<SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN>   <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN>  nan<SPAN class="punctuation token">,</SPAN>    e<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In the _make_nulls_ script, integer nulls were assigned a value of -999, floating point numbers are assigned 'nan' (not a number, and test fields a text representation of None... not None itself, but None in text form... got it

DanPatterson_Retired

In the beginning, there was a table

The desire was to produce a csv file... there are lots of ways... here is one

<SPAN class="comment token"># ---- convert a table or featureclass table to a numpy array</SPAN>

t <SPAN class="operator token">=</SPAN> tbl_data<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">)</SPAN>

t

array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.9</SPAN> <SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.93</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">5</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.74</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.06</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.87</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.88</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.96</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.98</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">9</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.47</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.06</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
       <SPAN class="punctuation token">(</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.04</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
      dtype<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OID_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'X_cent'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
             <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Y_cent'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Curves'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
             <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'A0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U5'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'A1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U5'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
             <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Value_0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Area_perim'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<f8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
             <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'srt_a0a1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># ---- amazing things can be done with arrays</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Now on to simple things.

save_txt<SPAN class="punctuation token">(</SPAN>t<SPAN class="punctuation token">,</SPAN> name<SPAN class="operator token">=</SPAN><SPAN class="string token">"c:/Temp/arr.csv"</SPAN><SPAN class="punctuation token">,</SPAN> sep<SPAN class="operator token">=</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">,</SPAN> dt_hdr<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

File saved<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>

<SPAN class="comment token"># ---- </SPAN>
OID_<SPAN class="punctuation token">,</SPAN> X_cent<SPAN class="punctuation token">,</SPAN> Y_cent<SPAN class="punctuation token">,</SPAN> Curves<SPAN class="punctuation token">,</SPAN> A0<SPAN class="punctuation token">,</SPAN> A1<SPAN class="punctuation token">,</SPAN> Value_0<SPAN class="punctuation token">,</SPAN> Area_perim<SPAN class="punctuation token">,</SPAN> srt_a0a1
 <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> A<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.9020246711679641</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">0</SPAN>
 <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> B<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.9285714285714286</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">5</SPAN>
 <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> A<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.7443162540690755</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">1</SPAN>
 <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> B<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.0606601717798239</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN>
 <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> C<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.1538461538461537</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN>
 <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> A<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN>   <SPAN class="number token">0.86944295103144</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN>
 <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> A<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">0.883142045739337</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN>
 <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> B<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.9561553109261145</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN>
 <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> C<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.9750407519379175</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">9</SPAN>
<SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> A<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.4661397467216941</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">2</SPAN>
<SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> B<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.0570527149133586</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">8</SPAN>
<SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> C<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="number token">1.036191067705632</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Now the code for posterity.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">tbl_data</SPAN><SPAN class="punctuation token">(</SPAN>in_tbl<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""Pull all editable attributes from a featureclass tables.  During the
    process, <null> values are changed to an appropriate type.

    Parameters
    ----------
    in_tbl : text
        Path to the input featureclass.

    Notes
    -----
    The output objectid and geometry fields are renamed to
    `OID_`, `X_cent`, `Y_cent`, where the latter two are the centroid values.
    """</SPAN>
    flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">]</SPAN>
    null_dict<SPAN class="punctuation token">,</SPAN> fld_names <SPAN class="operator token">=</SPAN> _make_nulls_<SPAN class="punctuation token">(</SPAN>in_tbl<SPAN class="punctuation token">,</SPAN> include_oid<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN>
                                        int_null<SPAN class="operator token">=</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> flds <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> fld_names<SPAN class="punctuation token">:</SPAN>
        new_names <SPAN class="operator token">=</SPAN> out_flds <SPAN class="operator token">=</SPAN> fld_names
    <SPAN class="keyword token">if</SPAN> fld_names<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">:</SPAN>
        out_flds <SPAN class="operator token">=</SPAN> flds <SPAN class="operator token">+</SPAN> fld_names<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
        new_names <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OID_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'X_cent'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Y_cent'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> out_flds<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
    a <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>
            in_tbl<SPAN class="punctuation token">,</SPAN> out_flds<SPAN class="punctuation token">,</SPAN> skip_nulls<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> null_value<SPAN class="operator token">=</SPAN>null_dict
            <SPAN class="punctuation token">)</SPAN>
    a<SPAN class="punctuation token">.</SPAN>dtype<SPAN class="punctuation token">.</SPAN>names <SPAN class="operator token">=</SPAN> new_names
    <SPAN class="keyword token">return</SPAN> np<SPAN class="punctuation token">.</SPAN>asarray<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">save_txt</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> name<SPAN class="operator token">=</SPAN><SPAN class="string token">"arr.txt"</SPAN><SPAN class="punctuation token">,</SPAN> sep<SPAN class="operator token">=</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">,</SPAN> dt_hdr<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""Save a NumPy structured, recarray to text.

    Parameters
    ----------
    a : array
        input array
    fname : filename
        output filename and path otherwise save to script folder
    sep : separator
        column separater, include a space if needed
    dt_hdr : boolean
        if True, add dtype names to the header of the file

    """</SPAN>
    a_names <SPAN class="operator token">=</SPAN> <SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">.</SPAN>dtype<SPAN class="punctuation token">.</SPAN>names<SPAN class="punctuation token">)</SPAN>
    hdr <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> a_names<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>dt_hdr<SPAN class="punctuation token">]</SPAN>  <SPAN class="comment token"># use "" or names from input array</SPAN>
    s <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">.</SPAN>tolist<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> dtype<SPAN class="operator token">=</SPAN>np<SPAN class="punctuation token">.</SPAN>unicode_<SPAN class="punctuation token">)</SPAN>
    widths <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>max<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>len<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> s<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">,</SPAN> j<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
              <SPAN class="keyword token">for</SPAN> j <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>s<SPAN class="punctuation token">.</SPAN>shape<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
    frmt <SPAN class="operator token">=</SPAN> sep<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"%{}s"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> widths<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># vals = ", ".join([i[1] for i in a.dtype.descr])</SPAN>
    np<SPAN class="punctuation token">.</SPAN>savetxt<SPAN class="punctuation token">(</SPAN>name<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN> fmt<SPAN class="operator token">=</SPAN>frmt<SPAN class="punctuation token">,</SPAN> header<SPAN class="operator token">=</SPAN>hdr<SPAN class="punctuation token">,</SPAN> comments<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nFile saved..."</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And if you don't want to deal with those pesky nulls, you can include

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">_make_nulls_</SPAN><SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">,</SPAN> include_oid<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> int_null<SPAN class="operator token">=</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">""</SPAN>"Return null values <SPAN class="keyword token">for</SPAN> a list of fields objects<SPAN class="punctuation token">,</SPAN> excluding objectid
    <SPAN class="operator token">and</SPAN> geometry related fields<SPAN class="punctuation token">.</SPAN>  Throw <SPAN class="keyword token">in</SPAN> whatever <SPAN class="keyword token">else</SPAN> you want<SPAN class="punctuation token">.</SPAN>

    Parameters
    <SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
    in_fc <SPAN class="punctuation token">:</SPAN> featureclass <SPAN class="operator token">or</SPAN> featureclass table
        Uses arcpy<SPAN class="punctuation token">.</SPAN>ListFields to get a list of featureclass<SPAN class="operator token">/</SPAN>table fields<SPAN class="punctuation token">.</SPAN>
    int_null <SPAN class="punctuation token">:</SPAN> integer
        A default to use <SPAN class="keyword token">for</SPAN> integer nulls since there <SPAN class="keyword token">is</SPAN> no ``nan`` equivalent
        Other options include

    <SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> np<SPAN class="punctuation token">.</SPAN>iinfo<SPAN class="punctuation token">(</SPAN>np<SPAN class="punctuation token">.</SPAN>int32<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>min <SPAN class="comment token"># -2147483648</SPAN>
    <SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> np<SPAN class="punctuation token">.</SPAN>iinfo<SPAN class="punctuation token">(</SPAN>np<SPAN class="punctuation token">.</SPAN>int16<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>min <SPAN class="comment token"># -32768</SPAN>
    <SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> np<SPAN class="punctuation token">.</SPAN>iinfo<SPAN class="punctuation token">(</SPAN>np<SPAN class="punctuation token">.</SPAN>int8<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>min  <SPAN class="comment token"># -128</SPAN>

    <SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">.</SPAN>__iter__<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>j <SPAN class="keyword token">if</SPAN> j <SPAN class="keyword token">else</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN> <SPAN class="keyword token">for</SPAN> j <SPAN class="keyword token">in</SPAN> i<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">.</SPAN>__iter__<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">]</SPAN>
    <SPAN class="string token">""</SPAN>"
    nulls <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'Double'</SPAN><SPAN class="punctuation token">:</SPAN> np<SPAN class="punctuation token">.</SPAN>nan<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Single'</SPAN><SPAN class="punctuation token">:</SPAN> np<SPAN class="punctuation token">.</SPAN>nan<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Float'</SPAN><SPAN class="punctuation token">:</SPAN> np<SPAN class="punctuation token">.</SPAN>nan<SPAN class="punctuation token">,</SPAN>
             <SPAN class="string token">'Short'</SPAN><SPAN class="punctuation token">:</SPAN> int_null<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SmallInteger'</SPAN><SPAN class="punctuation token">:</SPAN> int_null<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Long'</SPAN><SPAN class="punctuation token">:</SPAN> int_null<SPAN class="punctuation token">,</SPAN>
             <SPAN class="string token">'Integer'</SPAN><SPAN class="punctuation token">:</SPAN> int_null<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'String'</SPAN><SPAN class="punctuation token">:</SPAN> str<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Text'</SPAN><SPAN class="punctuation token">:</SPAN> str<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
             <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">:</SPAN> np<SPAN class="punctuation token">.</SPAN>datetime64<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'NaT'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Geometry'</SPAN><SPAN class="punctuation token">:</SPAN> np<SPAN class="punctuation token">.</SPAN>nan<SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token">#</SPAN>
    desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> desc<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'dataType'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'FeatureClass'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Table'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Only Featureclasses and tables are supported"</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">return</SPAN> None<SPAN class="punctuation token">,</SPAN> None
    in_flds <SPAN class="operator token">=</SPAN> desc<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'fields'</SPAN><SPAN class="punctuation token">]</SPAN>
    good <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> in_flds <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>editable <SPAN class="operator token">and</SPAN> f<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'Geometry'</SPAN><SPAN class="punctuation token">]</SPAN>
    fld_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">:</SPAN> f<SPAN class="punctuation token">.</SPAN>type <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> good<SPAN class="punctuation token">}</SPAN>
    fld_names <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN>fld_dict<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    null_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">:</SPAN> nulls<SPAN class="punctuation token">[</SPAN>fld_dict<SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fld_names<SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token"># ---- insert the OBJECTID field</SPAN>
    <SPAN class="keyword token">if</SPAN> include_oid <SPAN class="operator token">and</SPAN> desc<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'hasOID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
        oid_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OID@'</SPAN>  <SPAN class="comment token"># desc['OIDFieldName']</SPAN>
        oi <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>oid_name<SPAN class="punctuation token">:</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">999</SPAN><SPAN class="punctuation token">}</SPAN>
        null_dict <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>oi<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> list<SPAN class="punctuation token">(</SPAN>null_dict<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        fld_names<SPAN class="punctuation token">.</SPAN>insert<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> oid_name<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> null_dict<SPAN class="punctuation token">,</SPAN> fld_names<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Failed to mention blindingly fast for very large data sets and you can change the separator, include the field names and blindingly fast.. and no Pandas or Excel and everything is built into Arc. See line 23 in tbl_data … that is one of those arcpy functions!

RobertBorchert

What Ifran writes is the most correct answer. Often I am perplexed that people insist on trying to figure it out the more difficult way.

RobertBorchert

import arcpy

# Local variables:
Points = "C:\\01CAD\\BoardWord\\Boardwork.mdb\\Boards\\Points"
table_csv = Points
BoardWord = "C:\\01CAD\\BoardWord"

# Process: Table to Table
arcpy.TableToTable_conversion(Points, BoardWord, "table.csv", "", "Ratio \"Size\" true true false 50 Text 0 0 ,First,#,C:\\01CAD\\BoardWord\\Boardwork.mdb\\Boards\\Points,Ratio,-1,-1", "")

irfanlatif

Why not use Table To Table—Conversion toolbox | ArcGIS Desktop which can also export csv.

JustinBridwell2

This looks like a viable solution except....my features literally have millions of rows. Using da.SearchCursor() to iterate through each row and write it to a file would probably take a huge amount of time.

 

RandyBurton

Here's one possibility:

import arcpy
import csv

fc = r'C:\Path\to\file.gdb\feature'

# field names into list (you could use arcpy.Describe to get/select field names)
fields = ['Field1','Field2','FieldN'] # list of field names

sheetname = 'csv_test'
with open('{}.csv'.format(sheetname), 'wb') as outf:
    dw = csv.DictWriter(
        outf,
        quotechar='"',
        fieldnames=fields
    )
    dw.writeheader()
    with arcpy.da.SearchCursor(fc, fields) as rows:
        for row in rows:
            dw.writerow(dict(zip(fields, row)))

print "File written: {}".format(sheetname)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You can use Describe to get information on the feature's fields and use that information to create your field list. If you build a tool using the code above, you could allow the user to select fields. You could also modify the DictWriter to output a tab delimited file.

JoeBorgione

What if.... You were to perform a (arcpy) table to excel followed by (straight python) xls to csv ....

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.