我试图使用PostGIS函数执行一个dblink,但是线串(linestring)给了我很多麻烦。
SELECT
DV3."XXX",
s."QQQID",s."X",s."Y",a."PPP"
FROM
"QQQ" s INNER JOIN "AAA" a ON a."QQQID" = s."QQQID",
dblink('dbname=ZZZ',
'SELECT XXX,the_geom
FROM "geometry", "QQQ" s
WHERE box2d(geomfromtext(''LINESTRING('|| s."X" ||' '||s."Y" ||','|| s."X" || ' '||s."Y" || ')'',2309))
&& the_geom'
)
DV3("XXX" INTEGER,"the_geom" geometry)
WHERE
contains(DV3.the_geom,geomfromtext('POINT('|| s."X" ||' '|| s."Y" ||')',2309))--21
AND "GGG" IS NOT NULL
错误
注:此处为计算机程序代码,可能需要进一步上下文来进行翻译和理解。第9行:... WHERE box2d(geomfromtext(''LINESTRING('|| s .“X”+ 0 ....
geomfromtext
后面有两个单引号而不是双引号,这是复制粘贴时的笔误吗? - Tanzeeb Khalili