User talk:Techstrom/JapanData

From OpenStreetMap Wiki
Jump to: navigation, search

最近のPostGISは select sum(st_length(st_transform(way,4326)::geography)) from planet_osm_line where highway is not null;

で実行の必要が有りそうです。Hiroshi Miura 13:23, 19 June 2014 (UTC)

各カウントの出し方

select relname, reltuples from pg_class where relname = 'planet_osm_nodes'or relname = 'planet_osm_ways' or relname = 'planet_osm_rels';

完璧に正確ではないが、ほどほど正確な数値を出してくれる。Hiroshi Miura 13:23, 19 June 2014 (UTC)