PostGIS - C#을 사용하여 PostgreSQL 데이터베이스의 GIS 레이어 작업

PostgreSQL (PostGIS 확장)은 GIS 소프트웨어 중에서 가장 널리 사용되는 데이터베이스 중 하나입니다. Aspose.GIS를 통해 PostgreSQL 데이터베이스 작업을 수행할 수 있습니다.

PostGis 데이터베이스의 레이어 반복

// For complete examples and data files, please go to https://github.com/aspose-gis/Aspose.GIS-for-.NET
// First, we create the connection to the PostgreSQL with Npgsql library (https://www.nuget.org/packages/Npgsql/)
// Then, we pass this connection to Dataset.Open method in order to access tables in the PostgreSQL.
using (var connection = new NpgsqlConnection(postgreSqlConnectionString))
{
    connection.Open();
    using (var ds = Dataset.Open(connection, Drivers.PostGis))
    {
        // Only spatial tables are exported as layers, so the following code will list all tables
        // that have geometry column.
        for (int i = 0; i < ds.LayersCount; ++i)
        {
            Console.WriteLine(ds.GetLayerName(i));
        }
    }
}

PostGis 데이터베이스에 새 레이어 추가

// For complete examples and data files, please go to https://github.com/aspose-gis/Aspose.GIS-for-.NET
// First, we create the connection to the PostgreSQL with Npgsql library (https://www.nuget.org/packages/Npgsql/)
using (var connection = new NpgsqlConnection(postgreSqlConnectionString))
{
    connection.Open();
    // Then, we pass this connection to Dataset.Open method in order to access tables in the PostgreSQL.
    using (var ds = Dataset.Open(connection, Drivers.PostGis))
    {
        // create table with the name "features_table" and fill it with data.
        using (var layer = ds.CreateLayer("features_table"))
        {
            layer.Attributes.Add(new FeatureAttribute("name", AttributeDataType.String) { Width = 50 });

            var feature = layer.ConstructFeature();
            feature.SetValue("name", "Name1");
            feature.Geometry = Geometry.FromText("POINT (10 20 30)");
            layer.Add(feature);

            feature = layer.ConstructFeature();
            feature.SetValue("name", "Name2");
            feature.Geometry = Geometry.FromText("POINT (-10 -20 -30)");
            layer.Add(feature);
        }
    }
}

PostGis 데이터베이스의 레이어를 파일 형식으로 내보내기

// For complete examples and data files, please go to https://github.com/aspose-gis/Aspose.GIS-for-.NET
var outputPath = Path.Combine(RunExamples.GetDataDir(), "postgres_out.shp");

// First, we create the connection to the PostgreSQL with Npgsql library (https://www.nuget.org/packages/Npgsql/)
// Then, we pass this connection to Dataset.Open method in order to access tables in the PostgreSQL.
using (var connection = new NpgsqlConnection(postgreSqlConnectionString))
{
    connection.Open();
    using (var ds = Dataset.Open(connection, Drivers.PostGis))
    {
        // open table with the name "features_table" in Postgres database and save it to the shapefile.
        using (var table = ds.OpenLayer("features_table"))
        {
            table.SaveTo(outputPath, Drivers.Shapefile);
        }
    }
}