Data on bridges in France

Magouel Posted messages 30 Status Membre -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   -
Hello,

I am looking for data on the bridges of France, more specifically in the western region, regarding their height, width, and location in Excel format.

I have done some research and found that the SNCF bridges do not provide height, width, and location information (https://www.data.gouv.fr/fr/datasets/liste-des-ponts-route/)

Can you help me?

Best regards

7 réponses

brucine Posted messages 24390 Registration date   Status Membre Last intervention   4 098
 
Hello,

Perhaps by searching for heavy goods vehicle points of interest in a GPS file (they are in CSV format).

I think from memory that they can be found in Garmin POIs at Lufop.
1
Magouel Posted messages 30 Status Membre
 
Hello, thank you for your message. Unfortunately, the data found on the Lufop site only provide the radar zones and nothing more, but thank you anyway as it allows me to further my research via GPS which may help me.

Best regards.
0
brucine Posted messages 24390 Registration date   Status Membre Last intervention   4 098 > Magouel Posted messages 30 Status Membre
 
Absolutely, I did indeed check afterwards.

The parameters you want are certainly found in the GPS files for caravans and heavy goods vehicles, the question being whether we can use them outside of a specific GPS and for free.

For example, we find this, I don't know if it is still current, and it is paid:
http://www.alguerin.fr/wp-content/uploads/2011/12/GIRAFE.pdf

They obviously didn't invent it and siphoned off an appropriate file; here is one related to Hauts de Seine, I'm afraid this information depends on the road services of each department, in which case we are not making progress...:

https://www.data.gouv.fr/fr/datasets/gabarits-et-limitation-de-poids-des-ponts/
1
Magouel Posted messages 30 Status Membre > brucine Posted messages 24390 Registration date   Status Membre Last intervention  
 
Indeed, the data from "the giraffe" is interesting but excessively expensive.

As for data.gouv, I conducted an in-depth search on the site without success, which is why I made a request directly to support so they could provide me with this database to see if it is possible to access this data.

If that is the case, I will share it on this forum.

Thank you very much for your research.

Best regards
0
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Hello.

You could try to get some tips by contacting
Routes de France Bretagne
President: Thierry MEYER
Secretary General: Claire ESCULIER
2 rue des Maréchales
35132 VEZIN LE COQUET
Tel: 02 99 63 66 33 – Fax: 02 99 63 56 36
Email: bretagne@routesdefrance.com


--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
1
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
You also have https://fr.wikipedia.org/wiki/Portail:Ponts which can direct you to 4000 articles related to bridges in France!

Don't forget https://ign.fr/institut/ressources-pedagogiques ...

--
Retirement is nice! Especially in the West Indies...
Raymond (INSA, AFPA)
1
YvanM-34 Posted messages 720 Registration date   Status Membre Last intervention   97
 
Hello
Here are the bridges of France (over 200) for which the length, type, date, photo, and link for more details, etc., are provided.
This table is not in Excel format

https://fr.wikipedia.org/wiki/Liste_de_ponts_de_France
0
Magouel Posted messages 30 Status Membre
 
Hello,

thank you for your response. I already looked at this Wiki page but couldn't make anything of it.

Best regards
0
YvanM-34 Posted messages 720 Registration date   Status Membre Last intervention   97
 
Hello
I just tried copying a part of these bridges into Libre Office Calc and was surprised to find that the copy worked well and can be adjusted.
However, I don't know what the tile column is?

I'm putting the xls file on my server, you can check it out:

https://au-bout-du-monde.eu/telechargement/pont.xls

When saving it as.

It seems doable. Good luck.
0
brucine Posted messages 24390 Registration date   Status Membre Last intervention   4 098
 
Hello,

I don't know, it seems there are only listed monuments (but maybe that's what you want), length, location, but neither width nor height, I don't have a "tile column"? And the links are inaccessible.

For example, the link in C2 no longer exists.
0
baladur13 Posted messages 47549 Registration date   Status Modérateur Last intervention   14 372
 
Hello,
There's this too: https://fr.wikipedia.org/wiki/Liste_des_ponts_les_plus_longs_de_France

--
Very hard to catch a black cat in a dark room.
Especially when it's not there...
0
YvanM-34 Posted messages 720 Registration date   Status Membre Last intervention   97
 
Hello Brucine

Magouel had seen this table but didn't know what to do with it. Moreover, he wanted an Excel file.

By proceeding as I did, we can extract an Excel file, but the column of bridge photos poses a problem; the rest can be manipulated normally:



Afterward, it is certainly true that there is missing information on the table, but by clicking on the bridge's name, you get more information.

The structure
The bridge is 80 meters long, 46 meters in span, 6 meters wide (carriageway width 4.20 meters), and 11.50 meters high.

It consists of three semicircular arches, the central arch being higher than those flanking it to the north and south; the intermediate piers are pierced with large arched openings for


I am not a specialist in Excel and maybe we can keep the photos properly placed if they are useful.
0