8,434 reputation
1529
bio website cleverelephant.ca
location Victoria, Canada
age 43
visits member for 4 years, 3 months
seen 12 hours ago

merge keep


Nov
5
answered st_startpoint(the_geom) returning empty values
Oct
31
answered return state of point from postgis / mapnik pgsql db
Oct
25
comment How do you generate WKT from a graphic drawn on a map?
If I'm not mistaken, the default cut'n'copy action in JUMP is to take the feature into the clipboard as WKT. So you can high light a feature, copy, then paste into another app as WKT.
Oct
23
awarded  Good Answer
Oct
21
answered Need Help Converting Shapefile coordinates into lat/lon
Oct
10
awarded  postgresql
Oct
1
answered Is PostGIS-2.x raster in text format (WKT) only?
Sep
29
comment Can PostGIS and QGIS provide dependable multi-user editing?
Do test, but my understanding of QGIS editing is that it's feature by feature, so it will only be saving the particular actions of the user, not the entire state of their view of the data, when they hit save. So in your example A's point will be added and B's deleted, just as you would like.
Sep
28
answered Can PostGIS and QGIS provide dependable multi-user editing?
Sep
18
comment Should geometries be drawn using rhumb-line or great-circle paths?
If they are all in the "geometry" column type, then yes, regardless of SRID the assumption is you're working in a cartesian space with straight-line interpolation.
Sep
17
comment Should geometries be drawn using rhumb-line or great-circle paths?
PostGIS behaviour is basically the same idea as SQL Server implements. Geometry as cartesian, geography as spherical. Oracle Spatial has only one type, sdo_geometry, and invisibly changes strategies based on the CRS.
Sep
17
answered Should geometries be drawn using rhumb-line or great-circle paths?
Sep
13
reviewed Approve suggested edit on arcgis-javascript-api tag wiki excerpt
Sep
9
reviewed Approve suggested edit on TypeError: L.Proj is undefined in leaflet
Sep
9
reviewed Approve suggested edit on Run a large model by calling it in a python script?
Sep
8
answered Copy tables from one server to another in PostgreSQL
Sep
4
comment Different ST_AZIMUTH results for ST_PROJECT points along the same original bearing
That would involve having all the vertices represented w/ infinite precision, which would make all calculations much slower, and all geometries much larger. A "better" approach would be allowing all predicates to work with tolerances, though that's such a huge lift as to be unlikely to ever happen.
Sep
4
answered Different ST_AZIMUTH results for ST_PROJECT points along the same original bearing
Sep
3
comment Different ST_AZIMUTH results for ST_PROJECT points along the same original bearing
You are not doing what you think you are with your repeated use of the initial azimuth. You're treating it like a loxodrome when it's really an orthodrome gis.stackexchange.com/a/112261/457
Sep
3
reviewed Approve suggested edit on Create Raster file in R from Matrix and latlons