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