Reputation
19,869
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 52 89
Newest
 Yearling
Impact
~776k people reached

Feb
8
comment ST_MakePoint or ST_PointFromText to generate points
I benchmarked several functions in this answer, including ST_MakePoint. ST_PointFromText uses ST_GeomFromText under the hood (see the function definition).
Feb
6
awarded  Yearling
Feb
2
comment Update area column after changes in QGIS
The code looks correct for your expectations, but your question isn't clear.
Feb
2
revised Spatial clustering with PostGIS
show example of ST_ClusterWithin
Jan
31
revised Connectivity of Streams
edited tags
Jan
28
answered Why does psycopg2 “SELECT ST_AsBinary(geom)” return “<read-only buffer…>”?
Jan
28
revised Why does psycopg2 “SELECT ST_AsBinary(geom)” return “<read-only buffer…>”?
edited tags
Jan
28
answered How to extract POINT from a [LINE|MULTILINE]STRING
Jan
26
revised Spatial joining syntax
remove extra relation
Jan
26
comment Spatial joining syntax
@MartinBurch similar to your question, you can just use p.* to show all of the fields from the joined points
Jan
22
comment Transforming from SRID 900913 to 4326 with PostGis
@TylerVeinot see stackoverflow.com/q/21796446/327026
Jan
22
awarded  arcgis-desktop
Jan
21
revised gBuffer(rGEOS) causing R to crash
edited tags
Jan
20
awarded  Revival
Jan
19
answered How to interpret a WKB (Well-known-binary)?
Jan
12
awarded  Revival
Jan
10
comment How to pull a shapefile into R from PostGIS database (in Windows)?
rdal is normally the best way to read from database sources, but the optional driver for PostgreSQL is often not compiled (e.g. in Windows); see ogrDrivers() if it is listed, or not. You could write shapefiles from the database, which can be read with rgdal.
Dec
18
awarded  Guru
Dec
15
awarded  Popular Question
Dec
11
awarded  Famous Question