Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from (
- select
- st_setsrid(st_makepoint(ee.startLng, ee.starLat), 4326) as geomstart,
- st_setsrid(st_makepoint(ee.endLng, ee.endLat), 4326) as geomend
- from evt_situations ee
- ) e
- inner join (
- select
- (st_dump(st_linemerge(st_locatebetween(geom,6.1199,59.5117)))).geom
- , route
- from (
- select
- st_makeline(
- st_setsrid(
- st_makepointm(rp.lng,rp.lat,rp.m)
- ,4326
- )
- order by rp.m
- ) as geom
- , max(lr.route) as route
- , max(lr.id) as routeid
- from rpoints rp
- inner join routes lr
- on lr.id = rp.route_id
- where lr.id = 9
- ) m
- ) l
- on st_dwithin(e.geomstart,l.geom, 0.00001) or ST_DWITHIN(e.geomend, l.geom, 0.00001)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement