Skip to main content
added 4 characters in body
Source Link
Brent Edwards
  • 1.9k
  • 15
  • 22

I ended up solving this problem with the following function:

networkreachpartial

Here is an example which generates a 10 minute (0.166667 hr) isochrone from node 46397, assuming a speed of 5km/h:

CREATE TABLE networkreachpartial_node_46397_walk_5kph
AS
(SELECT 1 as id, ST_ConcaveHull(st_union(t.geom), 1)
FROM
(select *
from networkreachpartial2('at_2po_4pgr', 'cost_walk_5kph', 'geom_way', array[46397], 0.166667)) t)

I ended up solving this problem with following function:

networkreachpartial

Here is an example which generates a 10 minute (0.166667 hr) isochrone from node 46397, assuming a speed of 5km/h:

CREATE TABLE networkreachpartial_node_46397_walk_5kph
AS
(SELECT 1 as id, ST_ConcaveHull(st_union(t.geom), 1)
FROM
(select *
from networkreachpartial2('at_2po_4pgr', 'cost_walk_5kph', 'geom_way', array[46397], 0.166667)) t)

I ended up solving this problem with the following function:

networkreachpartial

Here is an example which generates a 10 minute (0.166667 hr) isochrone from node 46397, assuming a speed of 5km/h:

CREATE TABLE networkreachpartial_node_46397_walk_5kph
AS
(SELECT 1 as id, ST_ConcaveHull(st_union(t.geom), 1)
FROM
(select *
from networkreachpartial2('at_2po_4pgr', 'cost_walk_5kph', 'geom_way', array[46397], 0.166667)) t)
added 374 characters in body
Source Link
Brent Edwards
  • 1.9k
  • 15
  • 22

I ended up solving this problem with following function:

networkreachpartial

Here is an example which generates a 10 minute (0.166667 hr) isochrone from node 46397, assuming a speed of 5km/h:

CREATE TABLE networkreachpartial_node_46397_walk_5kph
AS
(SELECT 1 as id, ST_ConcaveHull(st_union(t.geom), 1)
FROM
(select *
from networkreachpartial2('at_2po_4pgr', 'cost_walk_5kph', 'geom_way', array[46397], 0.166667)) t)

I ended up solving this problem with following function:

networkreachpartial

I ended up solving this problem with following function:

networkreachpartial

Here is an example which generates a 10 minute (0.166667 hr) isochrone from node 46397, assuming a speed of 5km/h:

CREATE TABLE networkreachpartial_node_46397_walk_5kph
AS
(SELECT 1 as id, ST_ConcaveHull(st_union(t.geom), 1)
FROM
(select *
from networkreachpartial2('at_2po_4pgr', 'cost_walk_5kph', 'geom_way', array[46397], 0.166667)) t)
Source Link
Brent Edwards
  • 1.9k
  • 15
  • 22

I ended up solving this problem with following function:

networkreachpartial