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

merge keep


8h
answered Plotting Geo Points with “by arc centered at” Instructions
2d
comment Plotting Geo Points with “by arc centered at” Instructions
Interestingly, the lawyers didn't actually fully specify the arcs! Doh! There's two interpretations of that kind of instruction, one which goes the "short" way around the circle from beginning to end, and one which goes the "long" way around. And they thought they were being so precise.
2d
comment Plotting Geo Points with “by arc centered at” Instructions
Unfortunately the circular string constructors in postgis don't expose the internals, which do have support for center-based calculations.
2d
answered ST_MakeEnvelope vs casting BOX as box2d
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 arcgis-javascript-api tag wiki excerpt
Sep
9
reviewed Approve TypeError: L.Proj is undefined in leaflet
Sep
9
reviewed Approve Run a large model by calling it in a python script?
Sep
8
answered Copy tables from one server to another in PostgreSQL