topoint function

[pnorman]

housenumber_centroid.sql contains

UPDATE osm_housenumber_point SET geometry=topoint(geometry)
WHERE ST_GeometryType(geometry) <> 'ST_Point';

topoint is not defined anywhere.

[ImreSamu]

topoint is not defined anywhere.

as I know it is used by

• in docker-compose run --rm import-sql step
• source code : [ https://github.com/openmaptiles/import-sql ]

the topoint() = https://github.com/mapbox/postgis-vt-util#topoint
( based on https://github.com/openmaptiles/import-sql/blob/master/Dockerfile )

side note:

• we need to create a good developer documentations ...
• the new quickstart.sh will contain a little information about this, ( not in the master branch yet )

echo "-------------------------------------------------------------------------------------"
echo "====> : Start SQL postprocessing:  ./build/tileset.sql -> PostgreSQL "
echo "      : Source code: https://github.com/openmaptiles/import-sql "
docker-compose run --rm import-sql

probably I can extend with this information ...

[lukasmartinelli]

as I know it is used by

Yes but in this use case it would probably more clear to just use ST_PointOnSurface. Other functions from vt-util are LineLabel and z.