50 reputation
6
bio website kdelchev.com
location Bulgaria
age
visits member for 11 months
seen Jan 30 at 9:43
stats profile views 3

Web developer


Mar
11
awarded  Popular Question
Dec
21
comment OpenLayers - redrawing map after container resize
On resizing changing the container's size attributes works for the map, but not for the drawn features. Adding updateSize() ensure that the features are visible.
Nov
9
awarded  Teacher
Oct
10
answered How can I split an osm file into separated files with poly files using osmosis?
Oct
9
comment Get geometry from coordinates
Thanks, this is what i want to know.
Oct
9
accepted Get geometry from coordinates
Oct
9
accepted Using render_list to render only map extract
Oct
9
answered Using render_list to render only map extract
Jul
18
awarded  Tumbleweed
Jul
11
asked Using render_list to render only map extract
Jun
14
awarded  Supporter
Jun
14
accepted Using all dimensions with postgis functions
Jun
14
comment Using all dimensions with postgis functions
Thanks! Tried ST_Force_4D and ST_Force3DM and either are not working as I want. SELECT ST_AsText(ST_Force_4D(point)) from gps_data LIMIT 1 returns "POINT(-122.084091186523 37.422004699707)" with no z and m dimensions, but the point has it (can get with st_z() and st_m()). Will look for other solution...
Jun
14
comment Get geometry from coordinates
To get other information from the table that is not recorded in the point object, but on the same row.
Jun
13
awarded  Student
Jun
13
asked Using all dimensions with postgis functions
Jun
13
awarded  Scholar
Jun
13
comment Get geometry from coordinates
Ok, that is working, but if there a way to do it more precisely? I mean that specifying a bounding box can return 5 points (all points in the box). Is there a way to specify the exact point by its coordinates?
Jun
13
comment Get geometry from coordinates
What I want is the reverse operation by specifying the x and y coordinates to get the geometry (in my case point). There is a difference in the blob (see above) when creating point from text and that already saved in the database. I tried with adding z too (assume this is 0), but it didn't helped.
Jun
13
comment Get geometry from coordinates
Didn't know that. Added tags. The database is version 8.4