I have an Excel file that contains polygon coordinates for different areas. The spreadsheet has three columns: latitude, longitude and area name. Each coordinate makes of a part of the boundary of a polygonal area.
A sample of the data can be viewed here on google docs.
A subset of that sample is below:
Latitude Longitude AreaName
43.76559098 -79.41218646 Area1
43.76551428 -79.41216573 Area1
43.76516783 -79.41207212 Area1
43.76476698 -79.41196381 Area1
43.73581704 -79.4559399 Area2
43.73327829 -79.45336613 Area2
43.73359084 -79.45189026 Area2
43.73388256 -79.45052026 Area2
How can I turn this data into a shapefile that can be imported into CartoDB as a set of polygons?
Note: CartoDB accepts shapefiles that are in the following format.
Add XY
data option. Take a look at this – Hasan Mustafa Mar 25 '16 at 4:53