arc2pgrouting

-- PG_Geometry Line feature class -> PG Routing

-- Add Required Fields
ALTER TABLE way ADD COLUMN "source" integer;
ALTER TABLE way ADD COLUMN "target" integer;

-- Build Topology (3D)
SELECT sde.pgr_createTopology3d('way', 0.01, 'shape', 'objectid')

-- Add Indices
CREATE INDEX ways_source_idx ON way("source");
CREATE INDEX ways_target_idx ON way("target");

-- Add route id to waypoint
ALTER TABLE waypoint ADD COLUMN "routeid" integer;

UPDATE waypoint
SET routeid = way.objectid
FROM way
WHERE ST_3DDWithin(waypoint.shape, way.shape, .5)