243 reputation
316
bio website goran12.rajce.idnes.cz
location Czech Republic
age 28
visits member for 1 year, 10 months
seen yesterday

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.


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
Aug
12
awarded  Caucus
Aug
11
awarded  Custodian
Aug
11
reviewed Approve suggested edit on raster2pgsql does nothing
Aug
11
asked raster2pgsql does nothing
Jul
2
awarded  Curious
Jun
28
awarded  Self-Learner
Jun
27
comment Is there any random data generator supporting geometry in PostGIS?
If you know some minor optimization, don't be afraid to edit and improve my code (and add a note starting with "EDIT by XYZ:" explaining why and how it is better). For major optimization (or if it is better only under some conditions), post your own answer. I won't accept my own answer until question of complex line generation is properly answered, at least for sake of completeness.
Jun
27
answered Is there any random data generator supporting geometry in PostGIS?
Jun
24
revised Is there any random data generator supporting geometry in PostGIS?
added 852 characters in body
Jun
19
awarded  Yearling
Jun
19
comment Is there any random data generator supporting geometry in PostGIS?
@martinf: point generation would be easy anyway, and I know of ways to generate them like the one you linked. Making random polygons means most of the problem.
Jun
18
asked Is there any random data generator supporting geometry in PostGIS?
May
8
awarded  Quorum
Apr
15
comment How to load and view .gri and .grd files in QGIS
I have just answered this question here.