コード例 #1
0
ファイル: Program.cs プロジェクト: ataoge/DciTools
        static int Main(string[] args)
        {
            var services = new ServiceCollection();

            ConfigureServices(services);
            var sp = services.BuildServiceProvider();

            var app = new CommandLineApplication <AtaogeCommand>();

            app.Conventions
            .UseDefaultConventions()
            .UseConstructorInjection(sp);
            //app.HelpOption(inherited: true);

            app.FullName = $"城信所数据处理工具集";

            app.Command("shape", shpCmd => {
                shpCmd.Description = "Shape文件处理";
                var operate        = shpCmd.Option("-o|--operate", "操作:describe或compress", CommandOptionType.SingleValue)
                                     .IsRequired().Accepts(v => v.Values("describe", "compress"));
                var filePath = shpCmd.Option("-f|--file", "Input Shapefile", CommandOptionType.SingleValue)
                               .IsRequired().Accepts(v => v.ExistingFile());
                var index = shpCmd.Option <int>("-i|--index", "Grid Code Index", CommandOptionType.SingleValue)
                            .Accepts(o => o.Range(0, 30));
                var output   = shpCmd.Option("-t|--output", "output shapefile name", CommandOptionType.SingleValue);
                var encoding = shpCmd.Option("-e|--encoding", "dbf file encoding", CommandOptionType.SingleValue);


                shpCmd.OnExecute(() => {
                    if (operate.Value() == "describe")
                    {
                        ShapeFileHelper.Describe(filePath.Value(), encoding.Value());
                        return(1);
                    }
                    else if (operate.Value() == "compress")
                    {
                        ShapeFileHelper.Compress(filePath.Value(), index.ParsedValue, encoding.Value(), output.Value());
                        return(1);
                    }
                    shpCmd.ShowHelp();
                    return(1);
                });
            });

            var transfomrcmd = app.Commands.Find(c => c.Name == "transform");

            transfomrcmd?.Option <int>("--outSrid", "要转换成的srid", CommandOptionType.SingleValue);



            app.Command <StatsCommand>("stats", cmd => {
                //cmd.Options.Find(opt => opt.LongName == "xy").IsRequired();
            });

            app.Command <DescribeCommand>("describe", cmd => {
                cmd.Description = "Describe shape file or database";
            });

            return(app.Execute(args));
        }
コード例 #2
0
        public bool HandleFile(string filePath, string fileName = null)
        {
            if (Directory.Exists(filePath))
            {
                if (string.IsNullOrEmpty(fileName) || fileName.StartsWith("."))
                {
                    var count = 0;
                    foreach (var theFileName in Directory.GetFiles(filePath))
                    {
                        if (string.IsNullOrEmpty(fileName))
                        {
                            count++;
                            Console.WriteLine($"{count} {Path.GetFileName(theFileName)}");
                        }
                        else
                        {
                            if (Path.GetExtension(theFileName).Equals(fileName, StringComparison.InvariantCultureIgnoreCase))
                            {
                                count++;
                                Console.WriteLine($"{count} {Path.GetFileName(theFileName)}");
                            }
                            else
                            {
                                continue;
                            }
                        }
                    }
                    return(true);
                }
            }

            var fileFullPath = filePath;

            if (!string.IsNullOrEmpty(fileName))
            {
                fileFullPath = Path.Combine(filePath, fileName);
            }
            if (File.Exists(fileFullPath))
            {
                var ext = Path.GetExtension(fileFullPath);
                if (ext.Equals(".shp", StringComparison.InvariantCultureIgnoreCase))
                {
                    ShapeFileHelper.Describe(fileFullPath);
                }
            }
            return(true);
        }
コード例 #3
0
        public int OnExecute(CommandLineApplication app)
        {
            if (!string.IsNullOrEmpty(this.Connect))
            {
                var uri = new Uri(this.Connect);
                switch (uri.Scheme)
                {
                case "postgresql":
                    string userName = "";
                    string password = "";
                    if (!string.IsNullOrEmpty(uri.UserInfo))
                    {
                        var ss = uri.UserInfo.Split(":");
                        userName = ss[0];
                        password = ss.Length > 1 ? ss[1] : "";
                    }

                    if (!string.IsNullOrEmpty(this.UserName))
                    {
                        userName = this.UserName;
                    }
                    if (!string.IsNullOrEmpty(this.Password))
                    {
                        password = this.Password;
                    }

                    var port          = uri.Port > 0 ? uri.Port : 5432;
                    var database      = uri.AbsolutePath.Trim('/');
                    var connectString = $"Host={uri.Host};Port={port};Username={userName};Password={password};Database={database}";


                    var sql   = "";
                    int index = 0;
                    if (this.TableName.StartsWith("select", StringComparison.InvariantCultureIgnoreCase))
                    {
                        sql = this.TableName;
                    }
                    else
                    {
                        if (this.Index == null || int.TryParse(this.Index, out index))
                        {
                            sql = $"select * from {this.TableName}";
                        }
                        else
                        {
                            sql = $"select {this.Index} from {this.TableName}";
                        }
                    }


                    var dataSource = new DbDataSource(Npgsql.NpgsqlFactory.Instance, connectString);
                    var data       = dataSource.GetData(sql, index);

                    var stats = new  RunningStatistics(data);
                    Console.WriteLine($"总数:{stats.Count}");
                    Console.WriteLine($"最大值:{stats.Maximum}");
                    Console.WriteLine($"最小值:{stats.Minimum}");
                    Console.WriteLine($"平均值Mean::{stats.Mean}");
                    Console.WriteLine($"均方差StandardDeviation: {stats.StandardDeviation}");
                    Console.WriteLine($"{stats.ToString()}");
                    Console.WriteLine($"中位数: {data.Median()}");
                    Console.WriteLine(@"{0} - 有偏方差", data.PopulationVariance().ToString(" #0.00000;-#0.00000"));
                    Console.WriteLine(@"{0} - 无偏方差", data.Variance().ToString(" #0.00000;-#0.00000"));
                    Console.WriteLine(@"{0} - 标准偏差", data.StandardDeviation().ToString(" #0.00000;-#0.00000"));
                    Console.WriteLine(@"{0} - 标准有偏偏差", data.PopulationStandardDeviation().ToString(" #0.00000;-#0.00000"));
                    Console.WriteLine($"25% 中位数:{data.LowerQuartile()}");
                    Console.WriteLine($"75% 中位数:{data.UpperQuartile()}");


                    return(1);

                case "file":
                    this.FilePath = uri.LocalPath;
                    if (Directory.Exists(this.FilePath) && !string.IsNullOrEmpty(this.TableName))
                    {
                        this.FilePath = Path.Combine(this.FilePath, this.TableName);
                    }

                    break;

                default:
                    return(0);
                }
            }

            if (!string.IsNullOrEmpty(this.FilePath))
            {
                IEnumerable <double> data;
                var ext   = Path.GetExtension(this.FilePath);
                var index = 0;


                if (ext.Equals(".shp", StringComparison.InvariantCultureIgnoreCase))
                {
                    if (!int.TryParse(this.Index, out index))
                    {
                        index = ShapeFileHelper.FindIndex(this.FilePath, this.Index);
                    }
                    var shpDataSource = new ShapeDataSource(this.FilePath, index);
                    data = shpDataSource.GetData();
                }
                else
                {
                    if (!int.TryParse(this.Index, out index))
                    {
                        Console.WriteLine("索引参数不对!");
                        return(1);
                    }
                    var dataSource = new CsvDataSource(this.FilePath, index);
                    data = dataSource.GetData();
                }
                var stats = new  RunningStatistics(data);
                Console.WriteLine($"总数:{stats.Count}");
                Console.WriteLine($"最大值:{stats.Maximum}");
                Console.WriteLine($"最小值:{stats.Minimum}");
                Console.WriteLine($"平均值Mean::{stats.Mean}");
                Console.WriteLine($"均方差StandardDeviation: {stats.StandardDeviation}");
                Console.WriteLine($"{stats.ToString()}");
                Console.WriteLine($"中位数: {data.Median()}");
                Console.WriteLine(@"{0} - 有偏方差", data.PopulationVariance().ToString(" #0.00000;-#0.00000"));
                Console.WriteLine(@"{0} - 无偏方差", data.Variance().ToString(" #0.00000;-#0.00000"));
                Console.WriteLine(@"{0} - 标准偏差", data.StandardDeviation().ToString(" #0.00000;-#0.00000"));
                Console.WriteLine(@"{0} - 标准有偏偏差", data.PopulationStandardDeviation().ToString(" #0.00000;-#0.00000"));
                Console.WriteLine($"25% 中位数:{data.LowerQuartile()}");
                Console.WriteLine($"75% 中位数:{data.UpperQuartile()}");
                //new DescriptiveStatistics()

                var histogram = new Histogram(data, 100, stats.Minimum, stats.Maximum);
                //Console.WriteLine($"{histogram.ToString()}");
                for (var i = 0; i < 100; i++)
                {
                    var bucket = histogram[i];
                    Console.WriteLine($"({bucket.LowerBound}, {bucket.UpperBound}] {bucket.Count}");
                }

                return(1);
            }
            app.ShowHelp();
            return(1);
        }