1,381 reputation
515
bio website locationsolve.com
location Geelong, Australia
age 33
visits member for 4 years, 3 months
seen Dec 2 at 0:29

Sep
24
awarded  Popular Question
Sep
5
awarded  Yearling
Sep
5
awarded  Yearling
Mar
26
answered Leaflet: maximum number of layers?
Mar
7
revised How to overwrite a Shapefile
edited tags
Mar
7
revised How to overwrite a Shapefile
edited tags
Feb
4
answered How to create shaded relief from xyz file?
Jan
23
comment Problems on startup with GeoServer
what version of Geoserver?
Jan
23
revised Problems on startup with GeoServer
edited tags
Jan
23
revised Problems on startup with GeoServer
edited tags
Jan
23
comment Having issues getting Leaflet “L.tileLayer.wms” to display Geoserver WMS data
have you added the layer to the map? map.addLayer(test);
Jan
14
comment GeoJSON too bulky - what to do?
MessagePack is not related to BSON (it's actually better in many cases according to stackoverflow.com/questions/6355497/…. More interesting info about messagepack and specifically geojson can be found at nelsonslog.wordpress.com/2012/06/22/checking-out-msgpack.
Jan
14
answered GeoJSON too bulky - what to do?
Dec
16
suggested rejected edit on How to clip from a point layer using postgis?
Dec
14
comment How to clip from a point layer using postgis?
Are the SRIDs still identical? Are you sure there are actually overlapping points with the polygons? How are you importing this data? Is it projecting the data correctly? Your polygon layer isn't a GEOMETRYCOLLECTION is it?
Dec
13
awarded  Analytical
Dec
13
revised How to clip from a point layer using postgis?
matched up with table definitions supplied in question
Dec
13
comment How to clip from a point layer using postgis?
I created empty tables based on your queries above (except I didn't create as 3d geometry), no issues with your query running. I did notice that user postgres created the tblcloud, user tom created the tblpoly, are you running under user tom, and if so, does that user have read rights to the tblcloud table?
Dec
13
answered Fast data representation on the vector layers
Dec
13
answered How to clip from a point layer using postgis?