PROSAGA码农传奇-数据融合-从CSV文件中提取数据（融合表和kml变通方法）

从CSV文件中提取数据（融合表和kml变通方法）

作者: 撩心
发布时间: 2025-02-06 04:22:42 (1月前)
转自：

<div class =“post-text”itemprop =“text”>
   <pre>
    <code>
      using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Xml.Linq;

namespace ConsoleApplication35
{
    public class LatLng
    {
        public LatLng(double lat, double lng)
        {
        }
    }

class Program
    {
        private static IEnumerable<LatLng> GetCoordinates(string polygon)
        {
            var xElement = XElement.Parse(polygon);
            //var innerBoundaryCoordinates = xElement.Elements("innerBoundaryIs").FirstOrDefault()?.Value ?? "";
            var outerBoundaryCoordinates = xElement.Elements("outerBoundaryIs").Single()?.Value ?? "";
            return outerBoundaryCoordinates
                .Split(' ')
                .Select(latLng =>
                {
                    var splits = latLng.Split(',');
                    var lat = double.Parse(splits[0], CultureInfo.InvariantCulture);
                    var lng = double.Parse(splits[1], CultureInfo.InvariantCulture);
                    return new LatLng(lat, lng);
                });
        }

static void Main()
        {
            const string header = "description,name,label,geometry";
            var latLngs = File.ReadLines("file.csv")
                              .SelectMany(x => x.Split(new[] { header }, StringSplitOptions.RemoveEmptyEntries)) //all geometry`s in one array
                              .Select(x => x.Split('"'))
                              .SelectMany(x => GetCoordinates(x[1]))
                              .ToArray();
        }
    }
}

</code>
  </pre>
</DIV>