Why not ask your question on the new OpenStreetMap Community Forum?

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's gravatar image

accept rate: 0%

edited 12 Apr '15, 13:31

aseerel4c26's gravatar image

aseerel4c26 ♦

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%20Ramm's gravatar image

Frederik Ramm ♦
accept rate: 23%

Your answer
toggle preview

Follow this question

By Email:

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



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

Question tags:


question asked: 12 Apr '15, 03:21

question was seen: 2,918 times

last updated: 12 Apr '15, 17:51

powered by OSQA