Database Reference
In-Depth Information
There's more...
Now,wearenearlyreadyforrouting.Thecenterlinecalculationwehaveisagood
approximation of a straight skeleton, but still subject to the noisiness of the natural
world. We'd like to eliminate that noisiness by choosing our features and emphas-
izing them through routing. First, we need to prepare the table to allow for routing
calculations, as shown in the following commands:
ALTER TABLE voronoi_intersect ADD COLUMN gid
serial;
ALTER TABLE voronoi_intersect ADD PRIMARY KEY
(gid);
ALTER TABLE voronoi_intersect ADD COLUMN source
integer;
ALTER TABLE voronoi_intersect ADD COLUMN target
integer;
Then,tocreatearoutablenetworkfromourskeleton,enterthefollowingcommands:
