r - postGIS：ST_MakeEnvelope() 为什么只有一个类似的查询有效？

Question

标签： rpostgresqlpostgis

Answer 1

我现在这样做：

res <- DBI::dbExecute(con,
                          paste("INSERT INTO graphs (
                      left_xmin,
                      bottom_ymin,
                      right_xmax,
                      top_ymax,
                      filename,
                      BBOX_Diagonale,
                      file, bbox) VALUES ($1,$2, $3, $4,$5, $6,$7,ST_GeomFromText(ST_AsText(ST_MakeEnvelope(",
                                round(bbox_dimensions[[1]],digits=8),",",
                                round(bbox_dimensions[[2]],digits=8),",",
                                round(bbox_dimensions[[3]],digits=8),",", 
                                round(bbox_dimensions[[3]],digits=8),
                                ", 4326) )));"),
                          list(round(bbox_dimensions[[1]],digits=8),
                               round(bbox_dimensions[[2]],digits=8),
                               round(bbox_dimensions[[3]],digits=8),
                               round(bbox_dimensions[[4]],digits=8),
                               filename_save,
                               bbox_diagonale,
                               paste0( "\\x",paste(data, collapse = ""))))