Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Duplicate results from analysers #560

Closed
frodrigo opened this issue Jul 13, 2019 · 1 comment
Closed

Duplicate results from analysers #560

frodrigo opened this issue Jul 13, 2019 · 1 comment
Labels
bug

Comments

@frodrigo
Copy link
Member

frodrigo commented Jul 13, 2019 •
edited
Loading 

create temp table dup as select item, class, count(*) from (select item, class from marker group by source, class, subclass, elems, item having count(*)> 1) as t group by item, class;
select source, class, subclass, elems, count(*), array_agg(id), array_agg(lat), array_agg(lon) from marker where item= 1060 and class=1 group by source, item, class, subclass, elems having count(*)> 1;

 item | class | count | sources                                                                                       ------+-------+-------+---------
 1170 |     2 |     3 |       1
 2060 |    17 |   144 |      10 -- https://github.com/osm-fr/osmose-frontend/issues/157
 8042 |     1 |     4 |       2 -- Noémie
@frodrigo frodrigo added the bug label Jul 13, 2019
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Base subclass on node location in analyser_osmosis_way_approximate os…
2599580 
…m-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Use off fields in subclass on Analyser_Merge osm-fr#560
f651983
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate error id from TagFix_BadKey osm-fr#560
307f799
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate error id from TagFix_DuplicateValue osm-fr#560
35fe64e
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Only one marker per building intersection in analyser_osmosis_buildin…
3cec357 
…g_overlaps osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicat result on highway vs waterway in analyser_osmosis_high…
494d3ee 
…way_vs_building osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate in analyser_osmosis_relation_public_transport osm-fr#560
dc508ab
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate in analyser_osmosis_relation_public_transport osm-fr#560
3d0199b
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate on analyser_osmosis_node_like_way osm-fr#560
575036e
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate error from analyser_osmosis_boundary_intersect osm-fr…
3f1706d 
…#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 14, 2019
@frodrigo
Avoid duplicate issues from analyser_osmosis_roundabout_level osm-fr#560
67d2b81
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Base subclass on node location in analyser_osmosis_way_approximate os…
439bb21 
…m-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Use off fields in subclass on Analyser_Merge osm-fr#560
2f9182d
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate error id from TagFix_BadKey osm-fr#560
de271c1
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate error id from TagFix_DuplicateValue osm-fr#560
8f7577f
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Only one marker per building intersection in analyser_osmosis_buildin…
1042afc 
…g_overlaps osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicat result on highway vs waterway in analyser_osmosis_high…
511e243 
…way_vs_building osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate in analyser_osmosis_relation_public_transport osm-fr#560
2a72428
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate in analyser_osmosis_relation_public_transport osm-fr#560
26c4714
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate on analyser_osmosis_node_like_way osm-fr#560
f0e1d57
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate error from analyser_osmosis_boundary_intersect osm-fr…
9417fbc 
…#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 15, 2019
@frodrigo
Avoid duplicate issues from analyser_osmosis_roundabout_level osm-fr#560
1857616
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Base subclass on node location in analyser_osmosis_way_approximate os…
858791e 
…m-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Use off fields in subclass on Analyser_Merge osm-fr#560
b08b6e7
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Avoid duplicate error id from TagFix_BadKey osm-fr#560
68d5cea
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Avoid duplicate error id from TagFix_DuplicateValue osm-fr#560
988088b
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Only one marker per building intersection in analyser_osmosis_buildin…
272da71 
…g_overlaps osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Avoid duplicat result on highway vs waterway in analyser_osmosis_high…
1523bb4 
…way_vs_building osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jul 17, 2019
@frodrigo
Avoid duplicate in analyser_osmosis_relation_public_transport osm-fr#560
f3180ce
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 1, 2019
@frodrigo
Avoid duplicate issues in Analyser_Merge osm-fr#560
8565940
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 2, 2019
@frodrigo
Avoid duplicate issues in analyser_osmosis_building_overlaps osm-fr#560
9772045
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 2, 2019
@frodrigo
Avoid duplicate in analyser_merge_geodesie osm-fr#560
e4040a4
jocelynj added a commit that referenced this issue Sep 4, 2019
@jocelynj
Merge remote-tracking branch 'frodrigo/master'
29f5019 
* frodrigo/master:
  Fix fallback coord on geocoding fails #591
  Contains in place of Intersects in analyser_osmosis_double_tagging #598
  Avoid duplicate in analyser_merge_geodesie #560
  Avoid duplicate issues in analyser_osmosis_building_overlaps #560
  Avoid duplicate issues in Analyser_Merge #560
  Avoid duplicate issues in Highway_Lanes #360
  Avoid duplicated issues in analyser_osmosis_relation_associatedStreet #560
  Avoid duplicate issues in analyser_osmosis_relation_public_transport #560
  Base subclass on node index #560
  Avoid duplicate error from analyser_osmosis_boundary_intersect #560
  Avoid duplicate issues in analyser_osmosis_powerline #560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 9, 2019
@frodrigo
Fix Avoid duplicate issues in Analyser_Merge osm-fr#560
ad662a9
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 9, 2019
@frodrigo
Fix Avoid duplicate in analyser_merge_geodesie osm-fr#560
adde8ef
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 26, 2019
@frodrigo
Fix Avoid duplicate issues in Analyser_Merge osm-fr#560
4e60c05
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 26, 2019
@frodrigo
Fix Avoid duplicate in analyser_merge_geodesie osm-fr#560
5d5f939
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 29, 2019
@frodrigo
Fix Avoid duplicate issues in Analyser_Merge osm-fr#560
8b36ef7
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Sep 29, 2019
@frodrigo
Fix Avoid duplicate in analyser_merge_geodesie osm-fr#560
84477f5
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 1, 2019
@frodrigo
Fix Avoid duplicate issues in Analyser_Merge osm-fr#560
d570b0b
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 1, 2019
@frodrigo
Fix Avoid duplicate in analyser_merge_geodesie osm-fr#560
dddfc2a
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 1, 2019
@frodrigo
Fix Avoid duplicate issues in Analyser_Merge osm-fr#560
815ac4d
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 1, 2019
@frodrigo
Fix Avoid duplicate in analyser_merge_geodesie osm-fr#560
2d9f121
jocelynj pushed a commit that referenced this issue Oct 1, 2019
@frodrigo @jocelynj
Fix Avoid duplicate in analyser_merge_geodesie #560
d3454c5
jocelynj pushed a commit that referenced this issue Oct 1, 2019
@frodrigo @jocelynj
Fix Avoid duplicate issues in Analyser_Merge #560
7fa17d3
jocelynj added a commit that referenced this issue Oct 1, 2019
@jocelynj
Merge branch 'frodrigo-master'
51b9285 
* frodrigo-master:
  Fix Avoid duplicate issues in Analyser_Merge #560
  Fix Avoid duplicate in analyser_merge_geodesie #560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 4, 2019
@frodrigo
Fix duplicate in analyser_osmosis_relation_public_transport osm-fr#560
1a8c3de
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 4, 2019
@frodrigo
Avoid duplicate in Highway_Lanes osm-fr#560
e5cfe74
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Oct 4, 2019
@frodrigo
Move merge_power_substation_minor_FR to France subpart to avoid hash …
cfcd7cb 
…conflict osm-fr#560
jocelynj added a commit that referenced this issue Oct 5, 2019
@jocelynj
Merge remote-tracking branch 'frodrigo/master'
c1af5cc 
* frodrigo/master:
  Fix analyser_merge_school_FR, add mapping value
  Move merge_power_substation_minor_FR to France subpart to avoid hash conflict #560
  Avoid duplicate in Highway_Lanes #560
  Fix unicode support for py27 in analyser_merge_museum_FR #621
  Fix duplicate in analyser_osmosis_relation_public_transport #560
  Update data source URL in analyser_merge_tmc_point_FR
  Fix item conflict, move analyser_merge_radio_support_FR to 839x #596 #622
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Nov 1, 2019
@frodrigo
Switch subclass hash to 64 bits to avoid hash conflict osm-fr#560
75e6dd8
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Nov 1, 2019
@frodrigo
Switch subclass hash to 64 bits to avoid hash conflict osm-fr#560
e2149a9
@frodrigo frodrigo mentioned this issue Nov 12, 2019
Closed
@frodrigo
Copy link
Member Author

No more duplicate ✌️

@laurentriffard laurentriffard mentioned this issue Dec 11, 2019
Closed
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jan 1, 2020
@frodrigo
Revert Move merge_power_substation_minor_FR to France subpart to avoi…
8e0caf0 
…d hash conflict osm-fr#560
frodrigo added a commit to frodrigo/osmose-backend that referenced this issue Jan 1, 2020
@frodrigo
Revert Move merge_power_substation_minor_FR to France subpart to avoi…
9ac8d79 
…d hash conflict osm-fr#560
jocelynj added a commit that referenced this issue Jan 2, 2020
@jocelynj
Merge remote-tracking branch 'frodrigo/master'
87b133d 
* frodrigo/master:
  mapcss: regenerated after mapcss2osmose fix #725
  mapcss: fix on !:closed #725
  Merge requirements-dev-python3.txt into requirements-dev.txt
  Revert Move merge_power_substation_minor_FR to France subpart to avoid hash conflict #560
  Better 'Already up to date' support
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@frodrigo