private List <Polygon> readKmzFiles(TableFileRecordUtility fileRecordUtility)
{
List <Polygon> allPolygons = new List <Polygon>();
FileIDNameUtility fileIdUtility = new FileIDNameUtility();
fileIdUtility.ReadInfoFile(Program.DriveFileIDCsvPath);
for (int idx = 0; idx < fileRecordUtility.RegionShapeFileRecords.Count; idx++)
{
RegionShapeFile rsf = fileRecordUtility.RegionShapeFileRecords[idx];
KmzFileToPointCollectionUtility kmzUtility = new KmzFileToPointCollectionUtility();
string fileId = rsf.LinkToFile.Split("id=")[1];
KmzFileInfo fInfo = fileIdUtility.FileInfos.Find(it =>
it.FileID.Equals(fileId));
if (fInfo != null)
{
kmzUtility.GetPolygons(rsf.PlantID, fInfo.FullPath, fileId)
.ForEach(x => allPolygons.Add(x));
}
}
return(allPolygons);
}
public void Start()
{
TableFileRecordUtility fileRecordUtility = new TableFileRecordUtility();
fileRecordUtility.Run();
Console.WriteLine($"Got {fileRecordUtility.PlantRecords.Count} plant records.");
Console.WriteLine($"Got {fileRecordUtility.AttributeRecords.Count} attribute records.");
Console.WriteLine($"Got {fileRecordUtility.RegionShapeFileRecords.Count} regions shape file records.");
fileRecordUtility.AttributeRecords =
fileRecordUtility.AttributeRecords.Select((it, idx) =>
{
it.AttributeID = idx;
return(it);
}).ToList();
fileRecordUtility.RegionShapeFileRecords =
fileRecordUtility.RegionShapeFileRecords.Select((it, idx) =>
{
it.RegionShapeFileID = idx;
return(it);
}).ToList();
List <Polygon> polygons = readKmzFiles(fileRecordUtility);
List <Coordinate> coordinates = new List <Coordinate>();
int coordinateIdx = 0;
polygons = polygons.Select((it, idx) =>
{
it.PolygonID = idx;
it.Coordinates.ForEach(x =>
{
x.PolygonID = idx;
x.CoordinateID = coordinateIdx++;
coordinates.Add(x);
});
return(it);
}).ToList();
Console.WriteLine($"{polygons.Count:N0} polygons contained {coordinates.Count:N0} coordinates");
Console.WriteLine("Writing combined csv files . . . ");
string plantRowsStr = createCsvRowStr(new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>("PlantID", false),
new KeyValuePair <string, bool>("CommonName", true),
new KeyValuePair <string, bool>("ScientificName", true),
new KeyValuePair <string, bool>("PlantDescription", true),
new KeyValuePair <string, bool>("IsEdible", false)
}, fileRecordUtility.PlantRecords.Select(it => new List <string>
{
it.PlantID.ToString(), it.CommonName, it.ScientificName, it.PlantDescription, it.IsEdible ? "1" : "0"
}).ToList());
string attributeRowsStr = createCsvRowStr(new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>("AttributeID", false),
new KeyValuePair <string, bool>("PlantID", false),
new KeyValuePair <string, bool>("AttributeDescription", true)
}, fileRecordUtility.AttributeRecords.Select(it => new List <string>
{
it.AttributeID.ToString(), it.PlantID.ToString(), it.AttributeDescription
}).ToList());
string regionShapeFileRowsStr = createCsvRowStr(new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>("RegionShapeFileID", false),
new KeyValuePair <string, bool>("PlantID", false),
new KeyValuePair <string, bool>("LinkToFile", true)
}, fileRecordUtility.RegionShapeFileRecords.Select(it => new List <string>
{
it.RegionShapeFileID.ToString(), it.PlantID.ToString(), it.LinkToFile
}).ToList());
string polygonRowsStr = createCsvRowStr(new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>("PolygonID", false),
new KeyValuePair <string, bool>("PlantID", false)
}, polygons.Select(it => new List <string>
{
it.PolygonID.ToString(), it.PlantID.ToString()
}).ToList());
string coordinatesRowsStr = createCsvRowStr(new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>("CoordinateID", false),
new KeyValuePair <string, bool>("PolygonID", false),
new KeyValuePair <string, bool>("Latitude", false),
new KeyValuePair <string, bool>("Longitude", false)
}, coordinates.Select(it => new List <string>
{
it.CoordinateID.ToString(), it.PolygonID.ToString(), it.Latitude.ToString(), it.Longitude.ToString()
}).ToList());
Directory.CreateDirectory(Program.OutputDirectory);
File.WriteAllText(Path.Combine(Program.OutputDirectory, "plant.csv"), plantRowsStr);
File.WriteAllText(Path.Combine(Program.OutputDirectory, "attribute.csv"), attributeRowsStr);
File.WriteAllText(Path.Combine(Program.OutputDirectory, "region-shape-file.csv"), regionShapeFileRowsStr);
File.WriteAllText(Path.Combine(Program.OutputDirectory, "polygon.csv"), polygonRowsStr);
File.WriteAllText(Path.Combine(Program.OutputDirectory, "polygon-coordinate.csv"), coordinatesRowsStr);
Console.WriteLine("Wrote csv files.");
}
