8,124 reputation
1428
bio website cleverelephant.ca
location Victoria, Canada
age 43
visits member for 4 years, 2 months
seen 16 hours ago

merge keep


1d
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.
1d
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
17
reviewed Approve suggested edit on Labeling graphic layer using ArcGIS Runtime?
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
Sep
3
reviewed Approve suggested edit on Per-pixel (statistical) calculations on a raster stack using GDAL
Sep
2
reviewed Approve suggested edit on Rename las files with Python
Sep
2
comment PostGIS “Overlay” Style Union, not “Dissolve” Style
Also this one: gis.stackexchange.com/questions/109692/…
Sep
1
answered How to calculate the Azimuth between two points in PostGIS?
Aug
22
answered Merge polygon based on other line shape file PostGIS
Aug
22
comment Merge polygon based on other line shape file PostGIS
Are there no attributes in common between C/D or A/B?