异隆的可视化

Question

我是与SQL编码的新手，特别是与PGADMIN一起编码，现在我下载了数据表格OpenStreetMap，并且我试图在道路网络中构建用于创建和可视化等速官的问卷，间隔为：2,5,10,15分钟，，，2,10,15分钟，如果驾驶的速度为40 km/h。在互联网上查看后，我找到了一些教程，这是我的代码，但是我有一些问题，如果有人已经完成了这样的编码或可以帮助我，那将很高兴。

    CREATE TABLE dd_caserne AS

SELECT di.seq As id,
di.node , di.edge ,

di.agg_cost As time_access
, v.the_geom As geom
FROM pgr_drivingDistance('select gid as id, source, target,cost_s as cost, reverse_cost_s as reverse_cost from osmpgr.ways', 36, 32, true

) AS di INNER JOIN osmpgr.ways_vertices_pgr
AS v ON di.node = v.id;
select * from dd_caserne

    SELECT 1 As id, ST_SetSRID (pgr_pointsAsPolygon(
SELECT di.seq AS id, ST_X
(v.the_geom) AS x, ST_Y (v.the_geom) As y
FROM pgr_drivingDistance(SELECT gid As id, source, target,
cost_s AS cost,reverse_cost_s AS reverse_cost
FROM osmpgr.ways », 36, 300, true
) AS di INNER JOIN osmpgr.ways_vertices_pgr AS v ON di.node= v.id $$
), 4326) As geom;

    SELECT i As time_access,
ST_SetSRID(pgr_pointsAsPolygon(
‘SELECT id::integer,ST_X(geom)::float AS x,ST_Y(geom)::float As y
FROM dd_caserne 
WHERE access_time <= ‘|| i :: text), 4326) As geom
FROM generate_series(60,300)
As i
ORDER BY i DESC;