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

merge keep


2d
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.
2d
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...
Mar
17
revised Create links between points on CartoDB
added 23 characters in body
Mar
17
comment Create links between points on CartoDB
Not really sure. The result should only have as many records as your links table, which presumably isn't very big. I changed the id, since I realized that if you imported your links table into cartodb it would have a cartodb_id too, which would be unique.
Mar
17
revised Create links between points on CartoDB
added 8 characters in body
Mar
17
comment Create links between points on CartoDB
Ah, right two required columns for any tabel you want to map: a the_geom_webmercator and a cartodb_id. I've created a synthetic one by summing the inputs... might not be unique though, hm. Maybe multiply a.cartodb_id by 1000 first.