9,209 reputation
1530
bio website cleverelephant.ca
location Victoria, Canada
age 44
visits member for 4 years, 9 months
seen 2 hours ago

merge keep


2d
answered Postgis 4D Range Query
May
15
answered Database queries using GeoServer?
May
5
answered How to concatenate values from postgis table which have the same id into a new column?
Apr
29
comment Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
It's probably not reading the special config option from the environment, which leaves you entirely out of luck until I update it to accept config options (similar problems would hurt the actual FDW connection)
Apr
23
comment Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
Looks like you need to apply the OGR config option "MSSQLSPATIAL_USE_GEOMETRY_COLUMNS" to "NO", or it will try and create a spatial_ref_sys table for you, which you don't have permissions to do.
Apr
23
answered Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
Apr
20
answered I can't understand this ewkb type mask
Apr
13
awarded  Nice Answer
Apr
13
answered ST_MakeLine within CartoDB.js
Apr
9
comment How to query a PostGIS database through Geoserver and OpenLayers
For those queries that are too complicated (using joins, or obscure database functions) to be expressed in WFS, you can use the "SQL Views" feature of GeoServer to access any SQL query.
Mar
30
comment PostGIS: Ordering by the sum of two distances
Ditch the subquery, it's doing nothing for you.
Mar
23
revised PostGIS - ST_Within or ST_Disjoint performance issues
added 1 character in body
Mar
22
answered PostGIS - ST_Within or ST_Disjoint performance issues
Mar
21
comment GeoServer: Get styles from PostgreSQL/PostGIS table
The main trick I think would be ensuring that the SLD does in fact work, unchanged, in GeoServer. If it does, then you could combine an "on insert" trigger and the GeoServer REST configuration API to ensure that changes made in QGIS are automatically push new SLDs up to GeoServer.
Mar
19
revised Cartodb: How can I prevent edge-spanning polygons from wrapping in the wrong direction?
added 1 character in body
Mar
19
answered Cartodb: How can I prevent edge-spanning polygons from wrapping in the wrong direction?
Mar
18
answered How to merge polygons with ST_union
Mar
18
comment Create links between points on CartoDB
Let us continue this discussion in chat.
Mar
18
revised Create links between points on CartoDB
added 404 characters in body
Mar
17
comment Create links between points on CartoDB
Is it possible you built your geometry with the lat and long reversed? That might confuse things a bit...