readOgrSql: Read an PostgreSQL data source into Spatial objects.
In seifer08ms/RPostGIS: a package for manipulating data with PostGIS
Usage
Arguments
Value
References
Examples
Usage
1
readOgrSql(dsn, sql, gdal = T, ...)
Arguments
dsn
PostgreSQL DSNs
sql
a character vector of length 1 containing SQL
...
Other parameters passed on to methods.
Value
Spatial DataFrame
References
https://geospatial.commons.gc.cuny.edu/2013/12/31/subsetting-in-readogr/
https://geospatial.commons.gc.cuny.edu/2014/01/14/load-postgis-geometries-in-r-without-rgdal/
Examples
1
2
3
4
5
6
## Not run: strSQL = "
SELECT gid, name,
ST_Transform(geom, 4326)::geometry(MultiPolygon, 4326) AS geom
FROM geo_states"
spdfStates = readOgrSql(dsn, strSQL, stringsAsFactors=FALSE)
## End(Not run)
seifer08ms/RPostGIS documentation built on May 29, 2019, 5:53 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Usage Arguments Value References Examples
Usage
1 | readOgrSql(dsn, sql, gdal = T, ...)
|
Arguments
dsn |
PostgreSQL DSNs |
sql |
a character vector of length 1 containing SQL |
... |
Other parameters passed on to methods. |
Value
Spatial DataFrame
References
https://geospatial.commons.gc.cuny.edu/2013/12/31/subsetting-in-readogr/
https://geospatial.commons.gc.cuny.edu/2014/01/14/load-postgis-geometries-in-r-without-rgdal/
Examples
1 2 3 4 5 6 | ## Not run: strSQL = "
SELECT gid, name,
ST_Transform(geom, 4326)::geometry(MultiPolygon, 4326) AS geom
FROM geo_states"
spdfStates = readOgrSql(dsn, strSQL, stringsAsFactors=FALSE)
## End(Not run)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.