170 reputation
17
bio website martindueren.de
location
age
visits member for 1 year, 10 months
seen Jul 1 at 10:01

Jul
3
comment Split all OSM roads within boundingbox in 20m segments and save to new table
I am calculating statistics from car routes, where i have several sensor readings. I want to calculate stuff like speed, co2 emissions and so on for all the segments. There are a lot of measurements, and calculating those statistics for the whole line segment (street) does not show for example standing time at an intersection. To actually do this the most correct way I would need to split the streets at intersections, or where the speed limit changes....but that is too complicated right now - this serves my purpose for now.
Jul
3
accepted Split all OSM roads within boundingbox in 20m segments and save to new table
Jul
3
comment Split all OSM roads within boundingbox in 20m segments and save to new table
wow thanks this works!
Jul
3
awarded  Editor
Jul
3
revised Split all OSM roads within boundingbox in 20m segments and save to new table
edited title
Jul
3
comment Split all OSM roads within boundingbox in 20m segments and save to new table
ok I think this works, but sorry for being a complete SQL noob. I put it like this: SELECT ST_AsText(ST_MakeLine(start_point,end_point)) as geom FROM ( SELECT ST_Pointn(geom, generate_series(1, ST_NumPoints(geom)-1)) as start_point, ST_Pointn(geom, generate_series(2, ST_NumPoints(geom))) as end_point FROM ( SELECT ST_Segmentize(way,5) as geom FROM planet_osm_line ) as line ) as tmp; SO how can I now have all these segments saved, they should countain the same columns and attributes as the line they came from, of course with a different id
Jul
2
comment Split all OSM roads within boundingbox in 20m segments and save to new table
thanks for the answer, I have not forgotten you, but I ran into some problems with different coordinate systems, as soon as I have resolved those I will test this!
Jul
1
asked Split all OSM roads within boundingbox in 20m segments and save to new table
Apr
28
awarded  Critic
Apr
23
awarded  Constituent
Apr
23
awarded  Caucus
Apr
19
awarded  Scholar
Apr
19
comment Display mouse position from graph on a map
This looks very promising. Thanks for the hint, I will try it this way.
Apr
19
accepted Display mouse position from graph on a map
Apr
18
awarded  Student
Apr
18
asked Display mouse position from graph on a map
Jan
6
awarded  Supporter
Dec
24
comment how can i render geojson format and gml format?
Here is an OpenLayers GeoJSON example: openlayers.org/dev/examples/geojson.html
Nov
25
comment How upload KML from your local disk using Google Maps API?
you can parse the kml yourself. you can use the read method from the OpenLayers KML format to get a list of features (dev.openlayers.org/releases/OpenLayers-2.7/doc/apidocs/files/…) Then you might be able to draw those features onto your map. I have never tried this, but it seems this would be your way to go then This question is maybe related: gis.stackexchange.com/questions/16629/…
Nov
23
awarded  Teacher