EVOLUTION-MANAGER
Edit File: st_write.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>R: Write simple features object to file or database</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="R.css" /> </head><body> <table width="100%" summary="page for st_write {sf}"><tr><td>st_write {sf}</td><td style="text-align: right;">R Documentation</td></tr></table> <h2>Write simple features object to file or database</h2> <h3>Description</h3> <p>Write simple features object to file or database </p> <h3>Usage</h3> <pre> st_write(obj, dsn, layer, ...) ## S3 method for class 'sfc' st_write(obj, dsn, layer, ...) ## S3 method for class 'sf' st_write( obj, dsn, layer = NULL, ..., driver = guess_driver_can_write(dsn), dataset_options = NULL, layer_options = NULL, quiet = FALSE, factorsAsCharacter = TRUE, append = NA, delete_dsn = FALSE, delete_layer = !is.na(append) && !append, fid_column_name = NULL ) ## S3 method for class 'data.frame' st_write(obj, dsn, layer = NULL, ...) write_sf(..., quiet = TRUE, append = FALSE, delete_layer = TRUE) ## S4 method for signature 'PostgreSQLConnection,character,sf' dbWriteTable( conn, name, value, ..., row.names = FALSE, overwrite = FALSE, append = FALSE, field.types = NULL, factorsAsCharacter = TRUE, binary = TRUE ) ## S4 method for signature 'DBIObject,character,sf' dbWriteTable( conn, name, value, ..., row.names = FALSE, overwrite = FALSE, append = FALSE, field.types = NULL, factorsAsCharacter = TRUE, binary = TRUE ) </pre> <h3>Arguments</h3> <table summary="R argblock"> <tr valign="top"><td><code>obj</code></td> <td> <p>object of class <code>sf</code> or <code>sfc</code></p> </td></tr> <tr valign="top"><td><code>dsn</code></td> <td> <p>data source name (interpretation varies by driver - for some drivers, dsn is a file name, but may also be a folder or contain a database name) or a Database Connection (currently official support is for RPostgreSQL connections)</p> </td></tr> <tr valign="top"><td><code>layer</code></td> <td> <p>layer name (varies by driver, may be a file name without extension); if layer is missing, the <a href="../../base/html/basename.html">basename</a> of <code>dsn</code> is taken.</p> </td></tr> <tr valign="top"><td><code>...</code></td> <td> <p>other arguments passed to <a href="../../DBI/html/dbWriteTable.html">dbWriteTable</a> when <code>dsn</code> is a Database Connection</p> </td></tr> <tr valign="top"><td><code>driver</code></td> <td> <p>character; name of driver to be used; if missing and <code>dsn</code> is not a Database Connection, a driver name is guessed from <code>dsn</code>; <code>st_drivers()</code> returns the drivers that are available with their properties; links to full driver documentation are found at <a href="http://www.gdal.org/ogr_formats.html">http://www.gdal.org/ogr_formats.html</a>.</p> </td></tr> <tr valign="top"><td><code>dataset_options</code></td> <td> <p>character; driver dependent dataset creation options; multiple options supported.</p> </td></tr> <tr valign="top"><td><code>layer_options</code></td> <td> <p>character; driver dependent layer creation options; multiple options supported.</p> </td></tr> <tr valign="top"><td><code>quiet</code></td> <td> <p>logical; suppress info on name, driver, size and spatial reference</p> </td></tr> <tr valign="top"><td><code>factorsAsCharacter</code></td> <td> <p>logical; convert <code>factor</code> objects into character strings (default), else into numbers by <code>as.numeric</code>.</p> </td></tr> <tr valign="top"><td><code>append</code></td> <td> <p>Append rows to existing table; default <code>FALSE</code>.</p> </td></tr> <tr valign="top"><td><code>delete_dsn</code></td> <td> <p>logical; delete data source <code>dsn</code> before attempting to write?</p> </td></tr> <tr valign="top"><td><code>delete_layer</code></td> <td> <p>logical; delete layer <code>layer</code> before attempting to write?</p> </td></tr> <tr valign="top"><td><code>fid_column_name</code></td> <td> <p>character, name of column with feature IDs; if specified, this column is no longer written as feature attribute.</p> </td></tr> <tr valign="top"><td><code>conn</code></td> <td> <p>DBIObject</p> </td></tr> <tr valign="top"><td><code>name</code></td> <td> <p>character vector of names (table names, fields, keywords). </p> </td></tr> <tr valign="top"><td><code>value</code></td> <td> <p>a data.frame. </p> </td></tr> <tr valign="top"><td><code>row.names</code></td> <td> <p>Add a <code>row.name</code> column, or a vector of length <code>nrow(obj)</code> containing row.names; default <code>FALSE</code>.</p> </td></tr> <tr valign="top"><td><code>overwrite</code></td> <td> <p>Will try to <code>drop</code> table before writing; default <code>FALSE</code>.</p> </td></tr> <tr valign="top"><td><code>field.types</code></td> <td> <p>default <code>NULL</code>. Allows to override type conversion from R to PostgreSQL. See <code>dbDataType()</code> for details.</p> </td></tr> <tr valign="top"><td><code>binary</code></td> <td> <p>Send geometries serialized as Well-Known Binary (WKB); if <code>FALSE</code>, uses Well-Known Text (WKT). Defaults to <code>TRUE</code> (WKB).</p> </td></tr> </table> <h3>Details</h3> <p>Columns (variables) of a class not supported are dropped with a warning. </p> <p>When updating an existing layer, records are appended to it if the updating object has the right variable names and types. If names don't match an error is raised. If types don't match, behaviour is undefined: GDAL may raise warnings or errors or fail silently. </p> <p>When deleting layers or data sources is not successful, no error is emitted. <code>delete_dsn</code> and <code>delete_layer</code> should be handled with care; the former may erase complete directories or databases. </p> <h3>Value</h3> <p><code>obj</code>, invisibly; in case <code>obj</code> is of class <code>sfc</code>, it is returned as an <code>sf</code> object. </p> <h3>See Also</h3> <p><a href="st_drivers.html">st_drivers</a> </p> <h3>Examples</h3> <pre> nc = st_read(system.file("shape/nc.shp", package="sf")) st_write(nc, paste0(tempdir(), "/", "nc.shp")) st_write(nc, paste0(tempdir(), "/", "nc.shp"), delete_layer = TRUE) # overwrites data(meuse, package = "sp") # loads data.frame from sp meuse_sf = st_as_sf(meuse, coords = c("x", "y"), crs = 28992) # writes X and Y as columns: st_write(meuse_sf, paste0(tempdir(), "/", "meuse.csv"), layer_options = "GEOMETRY=AS_XY") st_write(meuse_sf, paste0(tempdir(), "/", "meuse.csv"), layer_options = "GEOMETRY=AS_WKT", delete_dsn=TRUE) # overwrites ## Not run: library(sp) example(meuse, ask = FALSE, echo = FALSE) try(st_write(st_as_sf(meuse), "PG:dbname=postgis", "meuse_sf", layer_options = c("OVERWRITE=yes", "LAUNDER=true"))) demo(nc, ask = FALSE) try(st_write(nc, "PG:dbname=postgis", "sids", layer_options = "OVERWRITE=true")) ## End(Not run) </pre> <hr /><div style="text-align: center;">[Package <em>sf</em> version 0.9-5 <a href="00Index.html">Index</a>]</div> </body></html>