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; } } }

CSV

JohnMcoy

I am very new to Python programming and have been tasked with writing a program to export a csv file from a file geodatabase feature class. The csv should contain only certain columns with results.

Maybe someone has any suggestions ? Or maybe someone has already done it ?

Thanks for any help !

Najděte více příspěvků označených jako

Accepted answers

RebeccaStrauch__GISP

If it's a one-off task, I wouldn't bother with writing a program for it, but it you need to repeat, then yes.

There are a number of ways that you could do this, but one option is to use

Table To Table—Help | ArcGIS Desktop to filter our just the fields you need, and save as a .csv

There are code samples at the bottom of the help page that should get you started on what you need.

All comments

forestknutsen1

Sure, I edited the code post

Anonymous User

Justinas,

As others have mentioned, there are various ways to accomplish what you're looking for. I have done just what you are wanting to do in a few of the tools that I have created.

You can use the Table To Table—Help | ArcGIS Desktop tool that was already mentioned, use the Delete Field—Data Management toolbox | ArcGIS Desktop tool to get rid of the specific fields, and then the Table To Excel—Help | ArcGIS Desktop tool to export the information out to an excel file.

JohnMcoy

It`s a new task

DanPatterson_Retired

is this related to your other unclosed thread?

https://community.esri.com/thread/193935-python-in-arcgis-need-help

or is it a new task?

JohnMcoy

Could you comment a little bit your code ? Thanks!

forestknutsen1

Rebecca's suggestion is the right way to go. But just FYI you can also build your csv from scratch if you like (or if the out of the box tool does not have the function you need). The bellow code makes a tsv (tab separated values) report for MTRS.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># in feature class or table</SPAN>
in_path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"xyz"</SPAN>
<SPAN class="comment token"># out tsv file</SPAN>
out_path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"xyz"</SPAN>

<SPAN class="comment token"># tsv write function - the input is a list of all elements for one row in the tsv</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">tsv_write</SPAN><SPAN class="punctuation token">(</SPAN>tsv_row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># write each element in list to tsv</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> tsv_row<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>item <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\t"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># end tsv row i.e. new line</SPAN>
&nbsp;&nbsp;&nbsp; tsv<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># create search cursor for input feature class</SPAN>
search_cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_path<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"field_1"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"field_2"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"field_3"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># open/create tsv output file</SPAN>
tsv <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>out_path<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># setup some variables to be used in loop</SPAN>
meridian_last <SPAN class="operator token">=</SPAN> None
township_last <SPAN class="operator token">=</SPAN> None
township_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
first_row_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># loop over input feature class table row by row</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> search_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># read in values from row</SPAN>
&nbsp;&nbsp;&nbsp; meridian <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; township <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; section <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># if it is the first row of the table set township_last to township</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> first_row_flag<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_last <SPAN class="operator token">=</SPAN> township
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; first_row_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># if the township is the same as the last township then "roll up" the sections for it, i.e. the same township but a different section</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> township <SPAN class="operator token">==</SPAN> township_last<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>section<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># sort the sections so that they are in ascending order</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list<SPAN class="punctuation token">.</SPAN>sort<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_str <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># build a string from section list with commas between</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> sec <SPAN class="keyword token">in</SPAN> section_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_str <SPAN class="operator token">=</SPAN> section_str <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>sec<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">", "</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># remove hanging comma and space from sections string</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_str <SPAN class="operator token">=</SPAN> section_str<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN>township_last<SPAN class="punctuation token">,</SPAN> section_str<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># write township and rolled up section string</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>township_last<SPAN class="punctuation token">,</SPAN> section_str<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># restart section list</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>section<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># write headers each time township is in a new meridian</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> meridian <SPAN class="operator token">!=</SPAN> meridian_last<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> meridian
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>meridian<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Township, Range"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Sections"</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Township, Range"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Sections"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># reset meridian_last and township_last</SPAN>
&nbsp;&nbsp;&nbsp; meridian_last <SPAN class="operator token">=</SPAN> meridian
&nbsp;&nbsp;&nbsp; township_last <SPAN class="operator token">=</SPAN> township

<SPAN class="comment token"># output the last township in the table to the tsv</SPAN>
section_list<SPAN class="punctuation token">.</SPAN>sort<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
section_str <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
<SPAN class="keyword token">for</SPAN> sec <SPAN class="keyword token">in</SPAN> section_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; section_str <SPAN class="operator token">=</SPAN> section_str <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>sec<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">", "</SPAN>
section_str <SPAN class="operator token">=</SPAN> section_str<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN>township_last<SPAN class="punctuation token">,</SPAN> section_str<SPAN class="punctuation token">]</SPAN>
tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>township_last<SPAN class="punctuation token">,</SPAN> section_str<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># close the tsv</SPAN>
tsv<SPAN class="punctuation token">.</SPAN>close<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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RebeccaStrauch__GISP

If that worked for you, remember to mark the question as answered so the thread can be closed.

JohnMcoy

Thank you Rebecca !

RebeccaStrauch__GISP

If it's a one-off task, I wouldn't bother with writing a program for it, but it you need to repeat, then yes.

There are a number of ways that you could do this, but one option is to use

Table To Table—Help | ArcGIS Desktop to filter our just the fields you need, and save as a .csv

There are code samples at the bottom of the help page that should get you started on what you need.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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