I have two point layers that one has 2885 and the other has same 2885 plus 1748 more features. The second one is a result of "v.net.centrality" analysis and now I want to join the result spatially into the first point layer in QGIS 3.4 LTR.
2885 of the features have exact same coordinates and reference system so I expect all of intersecting points to join spatially to give analysis' result to first point layer but in QGIS only 335 of them are intersecting. Then I tried to do it by using PostGIS with
SELECT first.id, first.geom, second.result FROM first LEFT JOIN second ON ST_Intersects(first.geom, second.geom)
but the result is same with QGIS "Join attributes by location" tool, only 335 of them intersecting. I also tried "Equals, touches" rules on QGIS and "ST_Equals, first.geom = second.geom conditions on PostGIS but the result didn't change.
Then I pass the data into ArcGIS Pro and do spatial join on it. It gives exactly what I want, all of the attributes (analysis result) from second layer are added to the first layer with "Intersect" rule.
I'm wondering why this happening? What is the reason behind it and how can I resolve in QGIS?