mapbox / postgis-vt-util Goto Github PK

( SELECT disctinct on(labelgrid(geom, 128, !pixel_width!)) some, other, attributes FROM your_table ) AS data

Should read distinct on and !pixel_width!)), (note the comma), yeah?

describe at least:

• how to load functions
• what each does (can probably rip from comments)

Hello.
There is a way to calc housenumber points from buildings x5 faster.
Duscussion: openmaptiles/openmaptiles#209
Would you like to have a fast building_to_point function?

for each function

not ok 30 - ST_AsText(OrientedEnvelope(ST_GeomFromText('LINESTRING(0 0, 10 10, 8 12)')))
    expected: 'POLYGON((8 12,10 10,0 0,-2 2,8 12))'
    actual: 'POLYGON((2.30769230769231 -1.53846153846154,1.77635683940025e-15 -8.88178419700125e-16,8 12,10.3076923076923 10.4615384615385,2.30769230769231 -1.53846153846154))'

PostGIS full version is POSTGIS="2.1.7 r13414" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 1.11.2, released 2015/02/10" LIBXML="2.9.2" LIBJSON="UNKNOWN" RASTER, PostgreSQL is 9.4.4 server and client

https://github.com/mapbox/postgis-vt-util/blob/master/lib.sql#L26

ERROR: parse error - invalid geometry
HINT: "nu" <-- parse error at position 2 within geometry

I know the solution for my problem,
but any good reason return string 'null' ?