Stephan Knauss wrote:
So could you specify a better projection that would be equidistant? The
data here uses 900913.
Would 4326 be equidistant?
FWIW, this is what I'm using on my cycle map:
ST_length_spheroid(transform(way,4326),'SPHEROID[WGS
Thank you for your thoughtful suggestions. I'm a n00b, so I'm not sure if I
have to setup my own instance of the database to run this query or, if not,
where I should go next. Any additional suggestions or direction would be
appreciated.
--Yumi
On Thu, Sep 17, 2009 at 4:54 AM, Lennard
yummy goop schrieb:
Thank you for your thoughtful suggestions. I'm a n00b, so I'm not sure
if I have to setup my own instance of the database to run this query or,
if not, where I should go next. Any additional suggestions or direction
would be appreciated.
To run such queries you'll
Hi,
I've been given a project to look at dead-end streets, specifically short
ones under the assumption that these may represent incomplete development.
How can I search OSM for:
- the shortest streets in my city/country/planet
- streets which are long but have many short, discontinuous segments
yummy goop wrote:
How can I search OSM for:
- the shortest streets in my city/country/planet
something like this?
select osm_id, st_length(way) as length from planet_osm_roads order by
length asc limit 10
31970890;0.00747434498740587
32782134;0.01093132
29014067;0.019995529652
Stephan Knauss wrote:
something like this?
select osm_id, st_length(way) as length from planet_osm_roads order by
length asc limit 10
Something, but not exactly that. ST_Length(way) is in projected meters,
which varies with latitude.
--
Lennard
2009/9/17 yummy goop yummyg...@gmail.com:
Hi,
I've been given a project to look at dead-end streets, specifically short
ones under the assumption that these may represent incomplete development.
That may be too simplistic assumption, recent developments I've been
mapping out basically have
7 matches
Mail list logo