yummy goop wrote:
> 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.
This ST_length_spheroid() cal
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'l
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 wrote:
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
84",6378137,298.257223563,AUTHORITY["EPSG","
Stephan Knauss wrote:
> So could you specify a better projection that would be equidistant? The
> data here uses 900913.
> Would 4326 be equidistant?
>
>
I wouldn't use 4326 to determine a distance. You may want to use a tool
to calculate an UTM zone for each streets you are measuring to have a
Lennard wrote:
> 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.
So could you specify a better
2009/9/17 yummy goop :
> 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 turning circles ta
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
__
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
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
10 matches
Mail list logo
