BeginBinaryImportAsync doesn't import Altitude

[smolesen]

I'm trying to import points and lines, with altitude, using BeginBinaryImportAsync, however the altitude doesn't seem to get imported.

The easiest way to verify this, is to change the TestData in GeoJSONTests to look like this:

        new()
        {
            Geometry = new Point(
                    new Position(longitude: 1d, latitude: 2d, altitude:3d))
                { BoundingBoxes = [1d, 2d, 1d, 2d] },
            CommandText = "st_makepoint(1,2)"
        },

and run the 'Import_geometry' test..... It'll fail
also if you check the db, you see a point with only longitude and latitude:

POINT (1 2)

TIA

/Søren

[smolesen]

Playing around with 'NpgsqlNetTopologySuite' instead, it turns out that the column has to be defined as 'POINTZ', however if I change the above mentioned test to use POINTZ

var table = await CreateTempTable(conn, "field geometry(POINTZ, 4326)");

I get this error:

22023: Column has Z dimension but geometry does not

Not quite sure what that means... or how to move on from here, except use 'NpgsqlNetTopologySuite' instead

[vonzshik]

Well, geometry explicitly documented as two-dimensional spatial object, so yeah, no z coord.

[xfischer]

@smolesen, adding to @vonzshik. There is maybe a confusion between builtin postgres geometry (2 dimensions only) and the PostGIS ones.
Using PostGIS, when you open Npgsql connection you should ask to handle Z coordinates this way:
await using var conn = await OpenConnectionAsync(handleOrdinates: Ordinates.XYZ);