3,930 reputation
1928
bio website stackoverflow.com
location Barcelona, Catalunya
age 95
visits member for 4 years, 11 months
seen 6 hours ago

Mapping geek who somehow got into databases. Currently loving D3.js. Running and cycling keep me sane. I work for http://www.emapsite.com and http://www.agroptima.com/en/


1d
comment Reprojecting in Postgis
Do you have the srid set for the table. What is in geometry_columns. If you have a mixture of SRIDs, then you can run the above query but add a WHERE ST_SRID(geom) = 4326, which will only reproject those that are lat/lon.
1d
comment Help plotting lat and long coordinates
This will be an iant has said related to coordinate reference system -- almost certainly Web Mercator, which makes all lat/lons appear in sea off West coast of Africa. Make sure you have your project properties set to lat/lon.
1d
comment Help plotting lat and long coordinates
That will not be the reason -- 0 , 51 is off the coast of Somalia. This is to do with projections, and the fact that in web mercator, any lat/lon appears to be just off the coast of Ghana, as this is the point 0, 0.
1d
comment What is the fastest way to select oldest, unique geometry from a table containing duplicates in PostGIS?
Sure. But that would apply to any Postgres query.
1d
comment St_Difference between raster and vector using PostGIS
Hard to know without any metrics on table sizes, polygon complexity, etc. How big, how long. What does explain show?
1d
comment Merge all features in polygon shapefile with gdal
Where do you have a wildcard? SELECT ST_Union(geometry) FROM input I would think.
1d
comment Merge all features in polygon shapefile with gdal
Remove the group by?
1d
reviewed Reviewed Merge all features in polygon shapefile with gdal
1d
revised Merge all features in polygon shapefile with gdal
added 15 characters in body
1d
reviewed No Action Needed How can I create polygons for a 3D map from a DEM in grass/qgis
1d
comment What is the fastest way to select oldest, unique geometry from a table containing duplicates in PostGIS?
Do you have an index on the x_dupes geometry column? Might not make a difference, but worth asking.
2d
reviewed No Action Needed Error in osm.xml while generating the output xml for tile server using generate_xml.py
2d
reviewed Leave Closed need information about openstreetmap (osm)
2d
reviewed No Action Needed Graph/Network building and analysis of linked polygons in ArcGIS 10.2
2d
reviewed No Action Needed Add feature manually to a vector layer in ol3
2d
reviewed Close Finding a substring within a table of data between 2 string positions in PostgreSQL
2d
comment Calculating slope from elevation returns hole when using ST_Slope in PostGIS
I don't know without knowing what area you are looking at. Is there any way you can put a sample of your area as a gist on github or similar. Also, what is the value of ARRAY[1] above?
2d
reviewed Reopen How to select layer of .shp format by attribute using ArcPy?
2d
reviewed Leave Open MS SQL table with geometry field to feature class
2d
reviewed Approve How to select layer of .shp format by attribute using ArcPy?