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

Convert JSON into FeatureCollection

JamesCrandall

I've been provided a JSON output in the sample below and tasked with getting this into a point feature class somehow.

<SPAN class="punctuation token">[</SPAN>
 <SPAN class="punctuation token">{</SPAN>
&nbsp; <SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"w1"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"-60.44"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"21.60"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"table"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"G310-P:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"84 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"G251-P:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"0 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>
&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"315"</SPAN>
 <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">{</SPAN>
&nbsp; <SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"w2"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"-60.32"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"21.63"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"table"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"S362-P:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"136 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>
&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"0"</SPAN>
 <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">{</SPAN>
&nbsp; <SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"w2"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"-60.35"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"21.37"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"table"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"S10A-C:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"0 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"S10C-C:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"0 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"S10D-C:"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"0 cfs; Mar 2, 17"</SPAN>
&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>
&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp; <SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"20"</SPAN>
 <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>

I have some existing processes that get close but hoped to run it by the community to see if someone spots the obvious solution before I dillydally down the wrong path for too long. In the JSON sample above, I have Lat/Lon attributes that I would need to get into an array in order to use this def() to convert it to something closer to what I need. My first thought is to create a new attribute called 'rings' so that it would just work with my geo_convert() def:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">geo_convert</SPAN><SPAN class="punctuation token">(</SPAN>ring_string<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">from</SPAN> json <SPAN class="keyword token">import</SPAN> loads<SPAN class="punctuation token">,</SPAN> dumps&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; rings <SPAN class="operator token">=</SPAN> loads<SPAN class="punctuation token">(</SPAN>ring_string<SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp; feat_coll <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'type'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'FeatureCollection'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> ring <SPAN class="keyword token">in</SPAN> rings<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; feat_coll<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'type'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Feature'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'type'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Point'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'coordinates'</SPAN><SPAN class="punctuation token">:</SPAN> ring<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'rings'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> dumps<SPAN class="punctuation token">(</SPAN>feat_coll<SPAN class="punctuation token">)</SPAN>&nbsp; <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>

Any ideas on what I could do?

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

Accepted answers

RandyBurton

My thoughts on your code is to replace lines 14 and 15

jData <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>dumps<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">,</SPAN> jsonfile<SPAN class="punctuation token">,</SPAN> indent<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> sort_keys<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

with this:

<SPAN class="comment token"># create a dictionary of features</SPAN>
jData <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None <SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># output is a list of dictionaries, in this case features</SPAN>
<SPAN class="comment token"># insert the list into the jData dictionary</SPAN>
jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> output

<SPAN class="comment token"># save the jData dictionary to a json file</SPAN>
json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>jData<SPAN class="punctuation token">,</SPAN> jsonfile<SPAN class="punctuation token">,</SPAN> indent<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> sort_keys<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</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>

You could combine the scripts, basically starting with the first 12 lines of your script (with the includes, etc.), then the six lines above, and finally including my script starting with line 12. You would end up with something like this:

<SPAN class="keyword token">import</SPAN> csv
<SPAN class="keyword token">import</SPAN> json

csvfile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'MyFile.csv'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'r'</SPAN><SPAN class="punctuation token">)</SPAN>
reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>DictReader<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">)</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Name'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Flow'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Arrow Size'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Long'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Heading'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Color'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Desciption'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'table'</SPAN><SPAN class="punctuation token">)</SPAN>

output <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> each <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Coords'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> each<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; 
&nbsp; output<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

jData <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None <SPAN class="punctuation token">}</SPAN>
jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> output

<SPAN class="comment token"># start the geojson file</SPAN>
geo <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"FeatureCollection"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"crs"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"name"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"EPSG:4326"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>

feature_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># loop through json</SPAN>
fCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> feature <SPAN class="keyword token">in</SPAN> jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fCount <SPAN class="operator token">+=</SPAN><SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; features <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"id"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"geometry"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Point"</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; <SPAN class="string token">"coordinates"</SPAN> <SPAN class="punctuation token">:</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; float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"OBJECTID"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<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; <SPAN class="string token">"Name"</SPAN> <SPAN class="punctuation token">:</SPAN> feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="string token">"Lat"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Long"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Heading"</SPAN> <SPAN class="punctuation token">:</SPAN> int<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; feature_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>features<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># this part would be exported to tab/csv file</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># for k, v in feature['table']:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; print str(fCount)+ '\t' + k + '\t' + v</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

geo<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> feature_list

<SPAN class="comment token"># to write to a file</SPAN>
<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'result2.json'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'w'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> fp<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>geo<SPAN class="punctuation token">,</SPAN> fp<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>

All comments

RandyBurton

My thoughts on your code is to replace lines 14 and 15

jData <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>dumps<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">,</SPAN> jsonfile<SPAN class="punctuation token">,</SPAN> indent<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> sort_keys<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

with this:

<SPAN class="comment token"># create a dictionary of features</SPAN>
jData <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None <SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># output is a list of dictionaries, in this case features</SPAN>
<SPAN class="comment token"># insert the list into the jData dictionary</SPAN>
jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> output

<SPAN class="comment token"># save the jData dictionary to a json file</SPAN>
json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>jData<SPAN class="punctuation token">,</SPAN> jsonfile<SPAN class="punctuation token">,</SPAN> indent<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> sort_keys<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</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 class="keyword token">import</SPAN> csv
<SPAN class="keyword token">import</SPAN> json

csvfile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'MyFile.csv'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'r'</SPAN><SPAN class="punctuation token">)</SPAN>
reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>DictReader<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">)</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Name'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Flow'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Arrow Size'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Long'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Heading'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Color'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Desciption'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'table'</SPAN><SPAN class="punctuation token">)</SPAN>

output <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> each <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Coords'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> each<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; 
&nbsp; output<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

jData <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None <SPAN class="punctuation token">}</SPAN>
jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> output

<SPAN class="comment token"># start the geojson file</SPAN>
geo <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"FeatureCollection"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"crs"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"name"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"EPSG:4326"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>

feature_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># loop through json</SPAN>
fCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> feature <SPAN class="keyword token">in</SPAN> jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fCount <SPAN class="operator token">+=</SPAN><SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; features <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"id"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"geometry"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Point"</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; <SPAN class="string token">"coordinates"</SPAN> <SPAN class="punctuation token">:</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; float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"OBJECTID"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<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; <SPAN class="string token">"Name"</SPAN> <SPAN class="punctuation token">:</SPAN> feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="string token">"Lat"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Long"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Heading"</SPAN> <SPAN class="punctuation token">:</SPAN> int<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; feature_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>features<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># this part would be exported to tab/csv file</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># for k, v in feature['table']:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; print str(fCount)+ '\t' + k + '\t' + v</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

geo<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> feature_list

<SPAN class="comment token"># to write to a file</SPAN>
<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'result2.json'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'w'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> fp<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>geo<SPAN class="punctuation token">,</SPAN> fp<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>

RandyBurton

I saved the json in your first message as a text file. In my code on line 7, I use json.loads to read the file into the jData variable. But as I am reading it, I appended '{ "features" : ' to the beginning and a closing '}' (with your json in the middle). This makes it a listing of features that one can easily loop through using "for feature in features".

I'll explore the code in your last message when I have some additional time.

I did make a modification on my code that uses dictionaries. It was a chance to do some exploring.

<SPAN class="keyword token">import</SPAN> json

filename <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'input.json'</SPAN>

<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'r'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> fp<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># read json and add "features"</SPAN>
&nbsp;&nbsp;&nbsp; jData <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{ "features" : '</SPAN> <SPAN class="operator token">+</SPAN> fp<SPAN class="punctuation token">.</SPAN>read<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>decode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"utf-8-sig"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"utf-8"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'}'</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># dump the json data</SPAN>
<SPAN class="comment token"># print json.dumps(jData, indent=4, sort_keys=False)</SPAN>

<SPAN class="comment token"># start the geojson file</SPAN>
geo <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"FeatureCollection"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"crs"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"name"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"EPSG:4326"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"features"</SPAN> <SPAN class="punctuation token">:</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>

feature_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># loop through json</SPAN>
fCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> feature <SPAN class="keyword token">in</SPAN> jData<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fCount <SPAN class="operator token">+=</SPAN><SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; features <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"id"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"geometry"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"type"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Point"</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; <SPAN class="string token">"coordinates"</SPAN> <SPAN class="punctuation token">:</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; float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"properties"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">"OBJECTID"</SPAN> <SPAN class="punctuation token">:</SPAN> fCount<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; <SPAN class="string token">"Name"</SPAN> <SPAN class="punctuation token">:</SPAN> feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="string token">"Lat"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Lat"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Long"</SPAN> <SPAN class="punctuation token">:</SPAN> float<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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; <SPAN class="string token">"Heading"</SPAN> <SPAN class="punctuation token">:</SPAN> int<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Heading"</SPAN><SPAN class="punctuation token">]</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; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; feature_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>features<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># this part would be exported to tab/csv file</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># for k, v in feature['table']:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; print str(fCount)+ '\t' + k + '\t' + v</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

geo<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"features"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> feature_list

<SPAN class="keyword token">print</SPAN> json<SPAN class="punctuation token">.</SPAN>dumps<SPAN class="punctuation token">(</SPAN>geo<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># to write to a file</SPAN>
<SPAN class="comment token"># with open('result.json', 'w') as fp:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; json.dump(geo, fp)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>

input.json.zip

JamesCrandall

I appreciate it. However, I don't see where you are starting your input.json file from. In my OP above, that's what I'm starting with and I need to get it into the geoJSON format that you show!

Interestingly, I cannot seem to access individual attributes like you are showing either. I get this error when I try to access the "Name" attribute: TypeError: string indices must be integers, not str

But it validates in a JSON formatter tool. This is what I have so far that will convert a csv file into the JSON output I posted in my OP:

csvfile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'H:\MyFile.csv'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'r'</SPAN><SPAN class="punctuation token">)</SPAN>
reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>DictReader<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">)</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Name'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Flow'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Arrow Size'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Long'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Heading'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Color'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Desciption'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'table'</SPAN><SPAN class="punctuation token">)</SPAN>

output <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> each <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Coords'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> each<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; 
&nbsp; output<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

jData <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>dumps<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
json<SPAN class="punctuation token">.</SPAN>dump<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">,</SPAN> jsonfile<SPAN class="punctuation token">,</SPAN> indent<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> sort_keys<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</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>

RandyBurton

Here is some very rough code to give you an idea.

import json

filename = r'input.json'

with open(filename, 'r') as fp:
&nbsp;&nbsp;&nbsp; # read json and add "features"
&nbsp;&nbsp;&nbsp; jData = json.loads('{ "features" : ' + fp.read().decode("utf-8-sig").encode("utf-8") + '}') 

# print len(jData['features'])

# start the geojson file
print '{'
print '&nbsp; "type" : "FeatureCollection",'
print '&nbsp; "crs" :'
print '&nbsp; {'
print '&nbsp;&nbsp;&nbsp; "type" : "name",'
print '&nbsp;&nbsp;&nbsp; "properties" :'
print '&nbsp;&nbsp;&nbsp; {'
print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name" : "EPSG:4326"'
print '&nbsp;&nbsp;&nbsp; }'
print '&nbsp;&nbsp; },'
print '&nbsp;&nbsp; "features" : ['

# loop through json
fCount = 0
for feature in jData['features']:
&nbsp;&nbsp;&nbsp; fCount +=1
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp; {'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; "type" : "Feature",'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; "id" : '+str(fCount)+','
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; "geometry" :'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; {'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type" : "Point",'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "coodinates" : ['
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '+feature["Lat"]+', '+feature["Long"]
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; },'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; "properties" : {'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "OBJECTID" : '+str(fCount)+','
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Name" : "'+feature["Name"]+'",'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Lat" : "'+feature["Lat"]+'",'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Long" : "'+feature["Long"]+'",'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Heading" : "'+feature["Heading"]+'"'
&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp;&nbsp;&nbsp; }'
&nbsp;&nbsp;&nbsp; if fCount != len(jData['features']):
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp; },'
&nbsp;&nbsp;&nbsp; else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print '&nbsp;&nbsp; }'

&nbsp;&nbsp;&nbsp; # this part would be exported to tab/csv file
&nbsp;&nbsp;&nbsp; for k, v in feature['table']:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print str(fCount)+ '\t' + k + '\t' + v
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

# close geojson
print '&nbsp; ]'
print '}'
<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>

bixb0012

I agree with rvburton‌. I think trying to parse out the "table" and make them new attributes will get messy. Logically, the data set appears to be two tables, one with locations and one with events.

RandyBurton

I think you can loop through the json and create a well-formed geojson file. While doing the loop, you could pull out the table information and send it to a tab/csv file so it could be imported into your project as a related table.

JamesCrandall

What do you think would be the best plan of attack on this one?

1. Attempt to churn the supplied JSON into a well-formatted esri-JSON object, minus that table column.

2. Just parse out the table column into new columns, effectively just making them new attribute fields.

I'm thinking for now I should just go with the #2 option to manipulate the csv and just convert that to a feature class. Open to suggestions.

JamesCrandall

That "tables" originally comes in as a string (really it's an html table stored in that column of the csv file) and I had converted it to a list like that. If it's a problem then I can revert it back to its original string value and deal with it later (as you suggested, make it it's own table).

bixb0012

How do you plan on handling the "tables?" Using Esri speak, the provided JSON is embedding a record set within each element of a feature set. Unless you plan on storing the record set portion as a string, I see this is two separate tables, one representing the basic properties (including location) of whatever, and the second representing events that are happening at whatever.

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.