Can someone show me the relevant documentation for relationships between tables?
I'm trying to get the geometry for an entry from the relations table but I'm unable to pick out the right information without this
Details:
schema: pgsnapshot (v0.6)
data-source: http://download.geofabrik.de/europe/great-britain/england/hampshire-latest.osm.pbf
db-load-command: osmosis --read-pbf ./hampshire-latest.osm.pbf --write-pgsql-dump directory=. enableBboxBuilder=yes
As far as I get:
select id, user_id, tags->'name' as name, tags->'admin_level' as level from relations limit 1; id | user_id | name | level --------+---------+----------+------- 108786 | 2089161 | Waverley | 8select * from relation_members where member_id = 108786 limit 1; relation_id | member_id | member_type | member_role | sequence_id -------------+-----------+-------------+-------------+------------- 57582 | 108786 | R | subarea | 4select * from nodes where id = 57582; id | version | user_id | tstamp | changeset_id | tags | geom ----+---------+---------+--------+--------------+------+------(0 rows)select * from ways where id = 57582; id | version | user_id | tstamp | changeset_id | tags | nodes ----+---------+---------+--------+--------------+------+-------(0 rows)
أكثر...
I'm trying to get the geometry for an entry from the relations table but I'm unable to pick out the right information without this
Details:
schema: pgsnapshot (v0.6)
data-source: http://download.geofabrik.de/europe/great-britain/england/hampshire-latest.osm.pbf
db-load-command: osmosis --read-pbf ./hampshire-latest.osm.pbf --write-pgsql-dump directory=. enableBboxBuilder=yes
As far as I get:
select id, user_id, tags->'name' as name, tags->'admin_level' as level from relations limit 1; id | user_id | name | level --------+---------+----------+------- 108786 | 2089161 | Waverley | 8select * from relation_members where member_id = 108786 limit 1; relation_id | member_id | member_type | member_role | sequence_id -------------+-----------+-------------+-------------+------------- 57582 | 108786 | R | subarea | 4select * from nodes where id = 57582; id | version | user_id | tstamp | changeset_id | tags | geom ----+---------+---------+--------+--------------+------+------(0 rows)select * from ways where id = 57582; id | version | user_id | tstamp | changeset_id | tags | nodes ----+---------+---------+--------+--------------+------+-------(0 rows)
أكثر...