I was wondering if it is possible to split a polyline on polygon boundaries (regions) in PostGIS, the picture below is of what we have at the moment and showing where I need the polylines split:
Lets call the regions
road_blocks and the lines
If you can copy the data from the
road_block under the newly created polyline to the new polyline that would be a real bonus.