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

creating a polygon (footprint) with 4 coordinates from excel file

NikolaiKirch

So i got ArcMap Basic and i want to bring my 100000 rows thick excel table to GIS.

In overall 8 columns are my 4 coordinates: coordinate 1 lat, coordinate 1 long, coordinate 2 lat ....

would be easy to average the 4 coordinates and just show for every row one point.

But i need to present every row as a polygon. A polygon square with 4 vertex (one for every coordinate). Like a footprint.

Does anyone have an idea?

Encontre mais publicações marcadas com

Accepted answers

FC_Basson

Here's a basic version of a script that might work for you:

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> csv<SPAN class="punctuation token">,</SPAN> numpy <SPAN class="keyword token">as</SPAN> np
csvfile <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\GIS\Scripts\points.csv'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\GIS\ArcGIS\scratch.gdb'</SPAN>
polygons <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>Layer<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'D:\GIS\ArcGIS\scratch.gdb\csv_points_poly'</SPAN><SPAN class="punctuation token">)</SPAN>
csv <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>genfromtxt<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">,</SPAN> delimiter<SPAN class="operator token">=</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN>
srWGS <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># from second line of array</SPAN>
cur <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>polygons<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHAPE@"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> coord <SPAN class="keyword token">in</SPAN> csv<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="keyword token">print</SPAN> coord
 array <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 1</SPAN>
 pnt1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt1<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 2</SPAN>
 pnt2 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt2<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 3</SPAN>
 pnt3 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt3<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 4</SPAN>
 pnt4 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt4<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 polygon <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Polygon<SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">,</SPAN>srWGS<SPAN class="punctuation token">)</SPAN>
 cur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>polygon<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>

First I created the output polygon feature class "csv_points_poly" in my scratch GDB with an additional "ID" field.

Then assuming your XLS/CSV file looks something like this:

ID<SPAN class="punctuation token">,</SPAN>LAT1<SPAN class="punctuation token">,</SPAN>LON1<SPAN class="punctuation token">,</SPAN>LAT2<SPAN class="punctuation token">,</SPAN>LON2<SPAN class="punctuation token">,</SPAN>LAT3<SPAN class="punctuation token">,</SPAN>LON3<SPAN class="punctuation token">,</SPAN>LAT4<SPAN class="punctuation token">,</SPAN>LON4
<SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17</SPAN>
<SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18</SPAN>
<SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19</SPAN>
<SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20</SPAN>
<SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21</SPAN>
<SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22</SPAN>
<SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23</SPAN>
<SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24</SPAN>
<SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25</SPAN>
<SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26</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>

You can use numpy to make an array of your data, which you can iterate to build a polygon for each row.

All comments

NikolaiKirch

it works fine, but it seems to me that lat and long are reversed?

NikolaiKirch

i changed the paths for my directories, created the feature class with an additional ID field and saved my xls as csv just like your table. My (german) csv seems to be seperated trough ";", i changed

 to ";"csv <SPAN class="">=</SPAN> np<SPAN class="">.</SPAN>genfromtxt<SPAN class="">(</SPAN>csvfile<SPAN class="">,</SPAN> delimiter<SPAN class="">=</SPAN><SPAN class="">","</SPAN><SPAN class="">)</SPAN>

otherwise the script wont work.

Unfortunately the whole result is like:

[ 7899.    nan    nan    nan    nan    nan    nan    nan    nan]
[ 7900.    nan    nan    nan    nan    nan    nan    nan    nan]
[ 7901.    nan    nan    nan    nan    nan    nan    nan    nan]

with some:

[ 26710.     nan     nan     nan     nan     nan     nan     nan     nan]
[ 2.67110000e+04   4.70000000e+01   7.00000000e+00   4.60000000e+01
   7.00000000e+00   4.60000000e+01   8.00000000e+00   4.70000000e+01
   8.00000000e+00]
[ 26712.     nan     nan     nan     nan     nan     nan     nan     nan]

is it possible that my my lat or lon coordinates are too big for "double"?

they look like that:

54,2506883777232

FC_Basson

Here's a basic version of a script that might work for you:

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> csv<SPAN class="punctuation token">,</SPAN> numpy <SPAN class="keyword token">as</SPAN> np
csvfile <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\GIS\Scripts\points.csv'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\GIS\ArcGIS\scratch.gdb'</SPAN>
polygons <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>Layer<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'D:\GIS\ArcGIS\scratch.gdb\csv_points_poly'</SPAN><SPAN class="punctuation token">)</SPAN>
csv <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>genfromtxt<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">,</SPAN> delimiter<SPAN class="operator token">=</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN>
srWGS <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># from second line of array</SPAN>
cur <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>polygons<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHAPE@"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> coord <SPAN class="keyword token">in</SPAN> csv<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="keyword token">print</SPAN> coord
 array <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 1</SPAN>
 pnt1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt1<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 2</SPAN>
 pnt2 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt2<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 3</SPAN>
 pnt3 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt3<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 <SPAN class="comment token"># point 4</SPAN>
 pnt4 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>coord<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>srWGS<SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
 array<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pnt4<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">)</SPAN>
 polygon <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Polygon<SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">,</SPAN>srWGS<SPAN class="punctuation token">)</SPAN>
 cur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>coord<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>polygon<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>

First I created the output polygon feature class "csv_points_poly" in my scratch GDB with an additional "ID" field.

Then assuming your XLS/CSV file looks something like this:

ID<SPAN class="punctuation token">,</SPAN>LAT1<SPAN class="punctuation token">,</SPAN>LON1<SPAN class="punctuation token">,</SPAN>LAT2<SPAN class="punctuation token">,</SPAN>LON2<SPAN class="punctuation token">,</SPAN>LAT3<SPAN class="punctuation token">,</SPAN>LON3<SPAN class="punctuation token">,</SPAN>LAT4<SPAN class="punctuation token">,</SPAN>LON4
<SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">17</SPAN>
<SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">18</SPAN>
<SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">19</SPAN>
<SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">33</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">20</SPAN>
<SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">21</SPAN>
<SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">22</SPAN>
<SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">30.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">23</SPAN>
<SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">29.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">24</SPAN>
<SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">28.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">25</SPAN>
<SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">27.5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">26</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>

You can use numpy to make an array of your data, which you can iterate to build a polygon for each row.

NeilAyres

Well the best way is to write some python to ingest this and create a polygon featureclass from the file.

Its not too difficult.

I imagine that this is actually a text file, rather than xls or something.

Is that your decimal separator ","?

If you can post a portion of the file here, I am sure someone can take a look.

NikolaiKirch

Its not regular.

for example these are the coordinates from one row for one polygon:

coordinate 1 lat coordinate 1 long coordinate 2 lat

50,48508401

6,98761143

49,67204584

6,788479888

49,62808362

7,198308726

50,44104231

7,404422742

i need to create a heatmap with these polygons.

My python skills are quite rudimentary.

DanPatterson_Retired

The obvious choice is Create Fishnet—Help | ArcGIS for Desktop if your polygon pattern is regular and just a bunch of sequential rectangles.

If not, they you might have to provide some more information and give some sense on your familiarity with python

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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