Reputation
1,778
Next privilege 2,000 Rep.
Edit questions and answers
Badges
13 42
Newest
 Yearling
Impact
~101k people reached

  • 0 posts edited
  • 0 helpful flags
  • 76 votes cast
Apr
26
awarded  Yearling
Apr
14
awarded  Notable Question
Apr
12
comment How to configure GeoServer WMS with no internet connectivity?
can you include the GeoServer version?
Apr
5
comment A patch of water that is part of a shapefile is painted as land
if you're using "a shapefile that I found somewhere on the internet" I think your next step should be to find a different shapefile. Unless you know or can verify the source of the data you have no guarantees that it meets your needs
Mar
1
comment Can LiDAR differentiate between rock and soil?
Is there a clear difference between the two? At what point does rock and dirt become soil with rocks in it?
Feb
26
comment osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
@AdamBaranyai I just added an answer with the only approach that worked for me
Feb
26
accepted osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
Feb
26
answered osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
Feb
25
asked Race condition when setting OpenLayers 3 map view and then panning popup into view
Dec
16
answered PointStacker - Random locations at different zoom level
Oct
17
awarded  Popular Question
Sep
24
comment Alternative approach for loading osm2pgsql data
my import is finally crawling through its relations so I think it might make it but I'm not celebrating just yet. I've never previously read of the way cache but I'm glad this explains my memory errors. The VM is hosted on a SAN with very fast disks but I'm limited to a single CPU which isn't helping. I think downloading a new PBF might be the most important change I made in this import as all the suggestions above have been tried in different iterations.
Sep
22
comment Alternative approach for loading osm2pgsql data
@RustProofLabs I have been looking for an updated RAM estimation - according to wiki.openstreetmap.org/wiki/Stats there are now ~3bn nodes and there is no indication of whether memory requirements scale linearly. So far I have tested both slim mode with a high cache value and non-slim mode with a lot of memory. Both failed for different reasons
Sep
22
comment Alternative approach for loading osm2pgsql data
@RustProofLabs osm2pgsql documentation states -C or --cache option is "Only for slim mode". Do you know if this is a mistake? osm2pgsql in verbose mode doesn't complain when this option is provided in non-slim mode.
Sep
22
asked Alternative approach for loading osm2pgsql data
Sep
17
comment osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
I re-tested with the .osm format file and it's also running slow. Since the last time I imported the .osm I have updated to the latest version of osm2pgsql from a previous 0.82. I found this mailing list entry lists.openstreetmap.org/pipermail/dev/2011-November/023841.html that suggests dramatic changes in ways import performance at a certain revision. I'm now testing with the --cache option set at 2000 to see if it helps. If now I plan to downgrade osm2pgsql and re-test the pbf
Sep
16
comment osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
memory is an obvious go-to but it doesn't explain why the .pbf is soooo much slower than the .osm - I'm going to rerun with the .osm today and see what it reports for the speed
Sep
15
asked osm2pgsql Ways importing very slowly in .pbf, much slower than .osm
Sep
11
comment osm2pgsql import fails with parse error
@JesseCrocker thanks for the tip, it seems pretty obvious now you mention it... I'm not sure why the process I'm following uses .osm instead of .pbf but it was created several years ago and maybe things were different then.
Sep
10
asked osm2pgsql import fails with parse error