how to calculate the position of new light pole along a freeway starting on each milestone +100 mete
Good morning,
I must calculate the position of new light pole along a freeway starting on each milestone.
The positions of light pole will are at +100 meter, +200 meter, +300 meter after each milestones of a freeway
The result of light pole will be stored in a table LIGHTPOLE(l_id, geom[sdo_gtype=3001]).
The database have 3 tables.
FREEWAY(f_id, name, geom_lrs), it is the table of freeways with a geomtry LRS (sdo_gtype=4402)
MILESTONE (m_id, name, geom), it is the table of the positions of each milestone (sdo_gtype=3001)
MIL_BY_FRW (idem, m_id, f_id), it is the interrelation entity who link a each milestone to a freeway.
I must calculate the position of new light pole along a freeway starting on each milestone.
The positions of light pole will are at +100 meter, +200 meter, +300 meter after each milestones of a freeway
The result of light pole will be stored in a table LIGHTPOLE(l_id, geom[sdo_gtype=3001]).
The database have 3 tables.
FREEWAY(f_id, name, geom_lrs), it is the table of freeways with a geomtry LRS (sdo_gtype=4402)
MILESTONE (m_id, name, geom), it is the table of the positions of each milestone (sdo_gtype=3001)
MIL_BY_FRW (idem, m_id, f_id), it is the interrelation entity who link a each milestone to a freeway.
0