Having 2 linestring tables:
pipelines (id integer, street varchar(50), shape geometry) streets (id integer, name varchar(50), shape geometry)
Each pipeline passes/intersects several streets.
I need to:
- Fill the street field in the pipelines automatically and
- I need to know to which street does the pipeline "belong the most".
I thought about densifiying the vertices of the each pipeline at a maximum 5 meter distance from each other, and do the analysis on them and then statistically find out the answer.
How In Postgis can I create a table that presents the geometry for each point of the pipelines along with their corresponding id?