View original (French)

Data on bridges in France

Magouel Posted messages 30 Status Member -  
Raymond PENTIER Posted messages 58231 Registration date   Status Contributor 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 answers

  1.
    brucine Posted messages 25338 Registration date   Status Member Last intervention   4 196
     
    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
    1. Magouel Posted messages 30 Status Member
       
      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
      1. brucine Posted messages 25338 Registration date   Status Member Last intervention   4 196 > Magouel Posted messages 30 Status Member
         
        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
      2. Magouel Posted messages 30 Status Member > brucine Posted messages 25338 Registration date   Status Member 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
  2. Raymond PENTIER Posted messages 58231 Registration date   Status Contributor Last intervention   17 499
     
    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
  4. YvanM-34 Posted messages 753 Registration date   Status Member 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
    1. Magouel Posted messages 30 Status Member
       
      Hello,

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

      Best regards
      0
  6. YvanM-34 Posted messages 753 Registration date   Status Member 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
    1. brucine Posted messages 25338 Registration date   Status Member Last intervention   4 196
       
      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
  8. YvanM-34 Posted messages 753 Registration date   Status Member 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