Reputation
1,511
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 18
Impact
~80k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Jul
27
comment CartoDB - feature appears only on some scales
@iriberri i think its the refresh time. I added refreshTime: 2000 and it seems to really help. Going to implement a security definer - blog.cartodb.com/…
Jul
17
comment WGS84 to OSGB, using VB script
If you would like a more accurate conversion you will need to use OSTN02 transformation rather than Helmert. Not sure if this exists in VB though but you can download the info from the OS website - ordnancesurvey.co.uk/business-and-government/help-and-support/…
Jun
3
comment ogr2ogr failing to open/convert GML
Just to let you know you can convert MasterMap GML with plain OGR2OGR, you do not need a GML reader. Something like this should work ogr2ogr -f GeoJSON output.json /vsigzip/mastermap.gz This will read straight from the GZip file rather than extracting to GML first
Sep
3
comment Find nearest distinct features to a point
looks like I got your SQL working. ST_Distance did not seem to like have a st_makepoint, so I saved the point into its own table and then was able to do ST_Distance(table.geom, point.geom) Whizzed through 40mill records in 37mins!! Thanks
Sep
3
comment Find nearest distinct features to a point
Unfortunately this does not work. It wants ST_Distance to have st_distance(geometry, geometry, integer), that final integer I do not know.
Jun
26
comment MapInfo 12 problems with PostGIS database
Myself and all the team I work with are using PostGIS 2.1 so I guess it will have to wait to fully implement. However, I will try and test your answer on a different machine just to check it works. Thanks
Jun
25
comment MapInfo 12 problems with PostGIS database
@Mapperz I successfully did that, its point 7) in my list, and the schema and table was successfully created. But it seems it is empty until i make the tables mappable. Have you managed to get it to work? thanks
Jun
12
comment TIFF to MBTILES conversion on a mac
not sure i understand what you mean? whn you loaded the new tiff file to tilemill did you see it in tilemill project? if not i dont think you are using tilemill correctly
Jun
11
comment TIFF to MBTILES conversion on a mac
can you give me more details on which rasters you are trying to reproject? The problem with batch converting each tile seperately is that you will get a black NO DATA are around each and when you come to put them side to side it will look terrible. So your method of creating a VRT is the best route. If it does not work in QGIS download and install the GDAL Complete binary (if on windows) and open the command prompt and run the command from there
Jun
10
comment Postgres SSL SYSCALL error: EOF detected with python and psycopg
check does this query run in pgadminIII? If it does then it may be how the python code is intepreting your query. You may have to wrap it like """ query """
Apr
30
comment gdalwarp increase resolution
@kyle thanks for the tip about NUM_THREADS very useful. I was using --config GDAl_CACHEMAX 1024 and -wm 1024 which also help
Feb
3
comment Import CSV file into Postgis DB with Location-field formatting?
can you edit your post and put a sample of your csv up, say first 5 rows
Jan
28
comment Batch merge large numbers of.asc grid files
Did you want a .asc file as the output or a geotiff or a hillshade?
Dec
3
comment Map background and style
yes you will need an SLD for your points, lines and polygons.
Dec
3
comment Map background and style
In order to create a map as detailed as Google Maps you need all the points, lines and polygons that make up a map. In your image you are only showing points. If you have this data then you need to create an SLD for each geometry type and style individual features, for example style rivers blue while roads are red. I would recommend looking at the SLD Cookbook and maybe this workshop workshops.boundlessgeo.com/geoserver-intro/styling/…
Nov
26
comment Ordnance Survey 1 km Grid
@Vesanto totally understand but will need to check internally how Ordnance Survey can best do this for other users rather than keep it where it is.
Nov
26
comment Loading / georeferencing OS rasters in QGIS
Glad I could help. Can you accept the answer so that other people can find it useful in the future
Nov
21
comment postgis: difference with && operator and st_intersects
When I have tested && and ST_Intersects before, the && version just compares bounding boxes. So it is very quick but in a way not that accurate. Where as the ST_Intersect does a bounding box to reduce the number of features to check against, and then does a full geometry check feature against feature.
Nov
18
comment Using OS Mastermap SLDs in QGIS
Hi Chris - I often start small and build up. For example, for cartographic text drop the OSMM style and see if the points show on the map. Then use the label and use the textstring, does the label show? Then use the data derived options and shift the position of text and the orientation using the new columns you have added. see what I mean? Here is a link to one I have used successfully - dropbox.com/s/udon2b1dv40l4vy/…
Nov
16
comment Using OS Mastermap SLDs in QGIS
you might be intersted in looking here for styles - github.com/QGIS-UK/Styles.