[Tile-serving] [osm2pgsql-dev/osm2pgsql] Geography datatype (Discussion #2152)

[Jochen Topf]

Just a note here. This can currently be done using something like this:

```
{ column = 'geom', type = 'point', sql_type = 'geography(point)', not_null = true, projection = 4326 }
```

But it would be nice to have "official" support for this. If we restrict the use to 4326 projection we can do this:

```
{ column = 'geom', type = 'point', not_null = true, projection = 'geography'  }
```

If we want to allow all lat/lon projections:

```
{ column = 'geom', type = 'geography_point', not_null = true, projection = 4326 } -- 4326 would be the default
```
or
```
{ column = 'geom', type = 'point', geography = true, not_null = true, projection = 4326 } -- 4326 would be the default
```

Any opinions on this?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2152#discussioncomment-11071979
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2152/comments/11071979 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241028/deb76e94/attachment.htm>