Reputation
933
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 27
Impact
~72k people reached

Feb
27
suggested rejected edit on Error on basic usage of osm2pgsql
Feb
27
comment Error on basic usage of osm2pgsql
Thanks, you show a lot more context and steps (!). Well, about the question, the key answer is -C option, that must be compatible with the RAM of the server. The only command that run on my 1Gb RAM was sudo -u postgres osm2pgsql -C 400 --slim --cache-strategy sparse -s -U postgres -d sandbox brazil-latest.osm.pbf
Feb
27
comment Error on basic usage of osm2pgsql
@xunilk, you say "See my answer", do you have a link? ... Well now I found help.openstreetmap.org/5956, help.openstreetmap.org/8322.
Feb
27
comment Error on basic usage of osm2pgsql
Hi @GiacomoCatenazzi your clue about -C option is correct (!), I try with -C 2000 (same error) them -C 200 and it works! It is a 1GB RAM DigitalOcean servelet.
Feb
27
comment Error on basic usage of osm2pgsql
What is "new version of postgresql"? I am using pg9.3.9 (as "select version()" say), so, if it is "new", what the port number?
Feb
27
revised Error on basic usage of osm2pgsql
sql vers
Feb
27
comment Error on basic usage of osm2pgsql
Yes, see "NOTES" I used... The best try with slim was sudo -u postgres osm2pgsql --slim -s -U postgres -d sandbox brazil-latest.osm.pbf that, as error, suggested to use "--cache-strategy sparse"... Adding cache option, sudo -u postgres osm2pgsql --cache-strategy sparse --slim -s -U postgres -d sandbox brazil-latest.osm.pbf, where the error is "Allocating memory for sparse node cache\n Out of memory for sparse node cache, reduce --cache size"
Feb
27
revised Error on basic usage of osm2pgsql
hum...
Feb
27
revised Error on basic usage of osm2pgsql
hum...
Feb
27
asked Error on basic usage of osm2pgsql
Oct
28
answered Get Lon Lat values from a GEOGRAPHY data type in PostGIS
Oct
28
comment Get Lon Lat values from a GEOGRAPHY data type in PostGIS
Even PostGIS 2.2 have no ST_X(geography ), see postgis.net/docs/manual-2.2/ST_X.html
Oct
28
comment Get Lon Lat values from a GEOGRAPHY data type in PostGIS
For geography datatype use valid function, ex. ST_MaxX() and ST_MaxY().
Oct
28
accepted Many mapfiles with few layers, or all layers in one mapfile?
Oct
27
comment Create mosaic like Voronoi Diagram from disjoint polygons
Nice solution (!), and thanks the illustration. Can you enhance it? See the left rectangle below, it was 4 points at Voronoi, and the center of rectangle have no representantion, distorting its region (losting are to the triangle)... Perhaps enhance is possible doing a regular sampling of each polygon... and perhaps also some interior points.
Oct
23
awarded  Nice Question
Oct
13
comment Create mosaic like Voronoi Diagram from disjoint polygons
Thanks @FelixIP, I edited to "well come raster solutions" ;-)
Oct
13
revised Create mosaic like Voronoi Diagram from disjoint polygons
citing more clue-solutions
Oct
13
revised Create mosaic like Voronoi Diagram from disjoint polygons
add "the problem" link and remember that transformed into a disjoint-polygons-problem
Oct
13
revised Create mosaic like Voronoi Diagram from disjoint polygons
obs about vector