If you can't read please download the document
Upload
frederic-rodrigo
View
839
Download
3
Embed Size (px)
Citation preview
2.
3. Ajout de colonne gomtrique aux ways 4.
5.
Colonne|Type| Modificateurs --------------+-----------------------------+--------------- id| bigint| non NULL version| integer| non NULL user_id| integer| non NULL tstamp| timestamp without time zone | non NULL changeset_id | bigint| non NULL tags| hstore|geom| geometry| 6.
7.
Colonne|Type| Modificateurs--------------+-----------------------------+--------------- id| bigint| non NULL version| integer| non NULL user_id| integer| non NULL tstamp| timestamp without time zone | non NULL changeset_id | bigint| non NULL tags| hstore|nodes| bigint[]|bbox| geometry|linestring| geometry|Colonne|Type| Modificateurs-------------+---------+--------------- way_id| bigint| non NULL node_id| bigint| non NULL sequence_id | integer | non NULL 8.
9.
Colonne|Type| Modificateurs--------------+-----------------------------+--------------- id| bigint| non NULL version| integer| non NULL user_id| integer| non NULL tstamp| timestamp without time zone | non NULL changeset_id | bigint| non NULL tags| hstore|Colonne|Type| Modificateurs-------------+--------------+--------------- relation_id | bigint| non NULL member_id| bigint| non NULL member_type | character(1) | non NULL member_role | text| non NULL sequence_id | integer| non NULL 10.
11.
13. ST_X, ST_Y 14. ST_Buffer 15. ST_Union 16. ST_Intersects 17. ST_AsText, ST_AsKML, ST_AsGeoJSON 18. 19.
20.
21.
Moins de 25 nodes Moins de 70m de diamtre Plus de 60% d'un cercle 22.
SELECT ways.id FROM ways WHERE -- tags ways.tags?'highway' AND (NOT ways.tags?'junction' OR ways.tags->'junction' != 'roundabout') AND -- geometry ST_NPoints(linestring) < 24AND ST_MaxDistance(linestring,linestring) < 70AND ST_Area(linestring) / ST_Area(ST_MinimumBoundingCircle(linestring)) > 0.6