Opened 3 years ago

#569 new enhancement

[analyser] analyser_osmosis_orphan_nodes_cluster

Reported by: frodrigo Owned by:
Priority: major Component: osmose-backend
Keywords: Cc: didier2020@…

Description

=> Prise en compte des nodes qui ne sont pas en version 1
=> "Oublier" les nodes trop recents (travail non terminé, ou par nature
qui prend beaucoup de temps a uploader comme canvec) : ici 5 jours par
exemple

sql100 = """

SELECT

ST_AsText(ST_Centroid(geom))

FROM
(

SELECT

(ST_Dump(ST_MemUnion(ST_Buffer(geom, 0.001,

'quad_segs=2')))).geom AS geom

FROM
(

SELECT

geom

FROM

nodes

LEFT JOIN way_nodes ON

nodes.id = way_nodes.node_id

LEFT JOIN relation_members ON

nodes.id = relation_members.member_id and
relation_members.member_type = 'N'

WHERE

(DATE(nodes.tstamp) < (CURRENT_DATE - 5)) AND

array_length(akeys(delete(delete(nodes.tags,'source'),'create_by')),1) =
0 AND

way_nodes.node_id IS NULL AND
relation_members.member_id IS NULL

LIMIT 3000

) AS n

) AS t
WHERE

ST_Area(geom) > 1e-5

;
"""

Change History (0)

Note: See TracTickets for help on using tickets.