Database Reference
In-Depth Information
shp2pgsql -s 3734 -d -i -I -W LATIN1 -g
the_geom lidar_buildings chp04.lidar_buildings
| psql -U me -d postgis_cookbook
How to do it...
Thesimplestwaytoconvertpointdatatopolygondatawouldbetobufferthepoints
by their known separation:
ST_Buffer(the_geom, 5)
We can imagine, however, that such a simplistic approach might look strange:
Assuch,itwouldbegoodtoperformaunionofthesegeometriesinordertodissolve
the internal boundaries.
ST_Union(ST_Buffer(the_geom, 5))
Now, we can see the start ofsome simple building footprints:
