I want to create an Excel sheet with all residential streets in France. To do so I want to use QGIS and the QuickOSM tool. By doing so I have been running into an issue. QGIS is giving me 4 different data sets when I download residential streets for an area (one with a square, 2 with a line and one with a dot). I'm not sure which one yields the information I am looking for as all 4 datasets have different amounts of observations when I look into their table. Also, when choosing the right dataset, can I be sure that no streets are being double-counted?
For streets you want the line dataset.
The single part lines, usually just called lines.
OpenStreetMap (OSM) has four types of features. Points, Lines, Polygons, and Multi Lines.
Points are used for point objects, but could be part of a street network, like traffic lights.
Lines are used for the streets themselves.
Polygons are used for areas, for example a square, or car park.
And multi lines are used for features that consist of multiple lines. For example a bus route would be captured this way in OSM.
One proposal using Python
I would definitely suggest that you look at OSMnx for downloading street networks if you are familiar with Python. It is a swiss knife, especially suited for dealing with and manipulating road networks.
It is worth a try.
It would then be possible to export the attribute table as a
*.csv file, e.g. using QGIS:
Exporting attribute table to Excel from QGIS?
I let you explore this way upon your wishes.