333 reputation
416
bio website goran12.rajce.idnes.cz
location Czech Republic
age 29
visits member for 2 years, 5 months
seen Apr 22 at 12:47

I'm a beginning expert on computer applications in archaeology - especially GIS (ArcGIS, QGIS) and databases (PostgreSQL, MySQL), but I also dabble in making websites (html/css and I learn php and JavaScript).

He on GIS.SE, I'm sort of a "noob pioneer", asking stupid questions that other noobs wanted to know but are afraid to ask themselves.


Mar
17
asked GRASS_INFO_ERROR(16605,1) while running a GRASS tool
Mar
17
comment G_realloc: unable to allocate 46320000 bytes of memory while managing large .xyz through v.in.ascii
bad news for me - that 45MB limit seems unlikely to be so closely connected with that 2GB limit.
Mar
16
comment G_realloc: unable to allocate 46320000 bytes of memory while managing large .xyz through v.in.ascii
How big files are "large files", needing the GRASS 7's support? Is there some hardcoded limit to prevent executing bigger files in GRASS 6, causing the problem I'm facing?
Mar
16
revised G_realloc: unable to allocate 46320000 bytes of memory while managing large .xyz through v.in.ascii
added 57 characters in body
Mar
13
comment Determine which points are contained inside a given polygon
I have missed few details for the first time. I corrected it, made it little friendlier (and added few details), but kept the Monty Python reference so liked by @JohnBarça.
Mar
13
revised Determine which points are contained inside a given polygon
added 80 characters in body
Mar
13
revised G_realloc: unable to allocate 46320000 bytes of memory while managing large .xyz through v.in.ascii
added 85 characters in body
Mar
13
comment Determine which points are contained inside a given polygon
@nickves: if such a situation occurs, it's easier and faster to change the geometry type than to compute the polygon for every query (I'm not sure about keeping both and using triggers to ensure consistency), unless you need the point-ness very often, or you must change really a lot of code. Perhaps the OP just oversimplified things for the question's sake, but keeping that table architecture reminded me a Monty Python sketch about hunting ants in a tank.
Mar
13
comment Determine which points are contained inside a given polygon
@user30184: answered by an edit.
Mar
13
revised Determine which points are contained inside a given polygon
added 1631 characters in body
Mar
13
answered Determine which points are contained inside a given polygon
Mar
13
comment Determine which points are contained inside a given polygon
Why not to store the region as a polygon? If you need to work with the edge nodes like points, it's easier to extract them than to make the polygon anew for each query. See this question: gis.stackexchange.com/q/59403/12768
Mar
13
asked G_realloc: unable to allocate 46320000 bytes of memory while managing large .xyz through v.in.ascii
Mar
12
awarded  Civic Duty
Aug
27
comment Is there any random data generator supporting geometry in PostGIS?
@jpmc26: no, I haven't considered this. Do you have some special line boundary generation algorithm in mind? For my needs my quasi-centroid algorithm seems ideal (so testing another approach is not a priority now), but you can expand your suggestion to an answer, if it is somehow better than mine, or concerns both lines and polygons.
Aug
19
awarded  Constituent
Aug
15
answered Saving rasters to postgresQL using raster2pgsql, saving forecast time
Aug
13
comment raster2pgsql does nothing
Now it works; I have PGPATH variable containing the path to my PostgreSQL bin directory (it is on drive d on my PC), and then I changed the second-from-end row to: CALL %PGPATH%raster2pgsql...
Aug
12
comment raster2pgsql does nothing
It works for me only if I navigate to the bin folder of my PostgreSQL installation, otherwise it classifies raster2pgsql as an unknown command. Anyway, it works.
Aug
12
accepted raster2pgsql does nothing