摘要:
把空间表转为geojson WITH cc_c AS ( SELECT name,name_2,name_3,st_transform(st_simplify(st_transform(geom,3857), 7827),4326) from countries_4326_s ), features 阅读全文
摘要:
这个效率比较高的写法 WITH componentTab AS ( SELECT * FROM pgr_connectedComponents ( 'SELECT id,source,target,cost,reverse_cost FROM yh_map_supplypipe' ) ) UPDAT 阅读全文