Get streets distance in osm?

Hey, I'm kinda new at this so bare with me. I downloaded my country osm data and put it in postgres. I would like to make a research on the data so I can for example have all the streets in a radius of 5 miles from a location (ultimately I would like to work directly with the data and not go through external api's. I looked at the data in the roads table and ,in there, there is that column "way" (900913). Can I use the data in that column to reach my goal ? What does the data in that column really represent ? I know it's something related to projection but it's vague.

asked 12 Apr '15, 03:21

activee
1●1●1●2
accept rate: 0%

edited 12 Apr '15, 13:31

aseerel4c26 ♦
32.6k●18●248●554

One Answer:

active answers oldest answers newest answers popular answers

The way column contains the geometry of the street (for those objects where the highway column is not null). Your problem can likely be solved using the PostGIS function st_dwithin; for further information, check the PostGIS manual or generic PostGIS resources - this is not an OSM specific question.

permanent link

answered 12 Apr '15, 09:46

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

postgresql ×165
postgis ×134
way ×91
radius ×12

question asked: 12 Apr '15, 03:21

question was seen: 3,178 times

last updated: 12 Apr '15, 17:51

Get streets distance in osm?

Follow this question

Related questions