3,656 reputation
1828
bio website stackoverflow.com
location Barcelona, Catalunya
age 95
visits member for 4 years, 10 months
seen 33 mins ago

Mapping geek who somehow got into databases. Currently loving D3.js. Running and cycling keep me sane.


3h
reviewed Leave Closed different results for area calculations
3h
reviewed Reviewed How do I center a custom control in Openlayers 3 horizontally?
3h
comment How do I center a custom control in Openlayers 3 horizontally?
Welcome to GIS.SE. Perhaps you could show some relevant code/CSS markup?
17h
reviewed Edit Using well survey data to pinpoint wells from BLM section division
17h
revised Using well survey data to pinpoint wells from BLM section division
Added tag for clarity
23h
reviewed Edit Converting LiDAR waveform file to ASCII or LAS file
23h
revised Converting LiDAR waveform file to ASCII or LAS file
Explained about the nature of the input data
23h
reviewed Reviewed How does a GPS satellite knows which gps receiver asked for it's location?
23h
reviewed Close How to link polygon features in one layer to polygon features in another, using largest overlap in QGIS or GRASS
23h
comment Raster and Geometry ST_Intersects slows when add buffer in PostGIS
Try rewritting your query like this: SELECT ST_UNION(rast) INTO elevationdata FROM uk_rasters e, (SELECT ST_Buffer(ST_Makeline(CAST(startloc AS GEOMETRY), CAST(endloc AS GEOMETRY)), 75) as geom) AS buff WHERE ST_Intersects(rast, buff.geom ); It isn't testing, so I might have a couple of parenthesis in wrong place, but the general idea is that spatial indices work better when you arrange it this way, rather than having a sub-query inside ST_Intersects with an operation like Buffer
1d
reviewed No Action Needed Create fishnet with row Iterator: fishnet extent does not update to reflect each row feature
1d
reviewed Leave Closed What Makes a Map Beautiful?
1d
reviewed Reopen What Makes a Map be classed as Badly Designed?
1d
comment Is there any method to retrieve SQL queries into a GeoJSON file using JSP?
Using ST_AsGeoJSON perhaps?
1d
comment Settings for GeoServer: large WMS png request failing
@AndreaAime. Thanks, but as I said, it is a dev box and I am the only user and this the only request, so parallel requests unlikely cause. As soon as this goes above 2305 x 2305 pixels it blows up and I have already doubled settings listed above. There must be another setting we are missing.
1d
comment Notepad++ syntax highlighting support for .mapfiles?
You have a point in this case, but, yes, explain what it does, so if link disappears, people can recreate themselves.
1d
reviewed Reopen spatialite : spatial index on geometries
1d
comment Problems installing QGIS 2.8 Wien on Windows 7
Welcome to GIS.SE. Please do not post questions/comments as answers.
1d
reviewed Close Plugin c++ - QGIS
1d
comment Notepad++ syntax highlighting support for .mapfiles?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.