Paris Metropolitan, an evolution: Difference between revisions
Echervonenko (talk | contribs) |
Echervonenko (talk | contribs) |
||
Line 88: | Line 88: | ||
If new entries are added to the databases, then they must take into account the following rules: | If new entries are added to the databases, then they must take into account the following rules: | ||
#If the station is completely new, then a new entry is created with a new '''stop_id''' and '''stop_name'''. The '''start_map''' corresponds to the map from which the information is retrieved. The '''end_map''' corresponds to the last map from which the information is retrieved. This field should be updated to the other existing entires if the stations with the same lines still appear on the last map. | #If the station is completely new, then a new entry is created with a new '''stop_id''' and '''stop_name'''. The '''start_map''' corresponds to the map from which the information is retrieved. The '''end_map''' corresponds to the last map from which the information is retrieved. This field should be updated to the other existing entires if the stations with the same lines still appear on the last map. | ||
#If a station is still in operation today, a '''ratp_id''' is created to the station. If the station is a ghost station - not in operation anymore - the '''ratp_id''' entry would be | #If a station is still in operation today, a '''ratp_id''' is created to the station. If the station is a ghost station - not in operation anymore - the '''ratp_id''' entry would be empty. | ||
#If the name of a station is changed, then the existing entry is duplicated. The '''stop_id''' remains, the '''stop_name''' is changed, the '''start_map''' is set to the current map from which the information is retrieved and '''end_map''' to the last map in which the information appears. | #If the name of a station is changed, then the existing entry is duplicated. The '''stop_id''' remains, the '''stop_name''' is changed, the '''start_map''' is set to the current map from which the information is retrieved and '''end_map''' to the last map in which the information appears. | ||
#If the name of the metro line is changed, then same apply as above, except that it is the '''stop_line''' that changes. | #If the name of the metro line is changed, then same apply as above, except that it is the '''stop_line''' that changes. |
Revision as of 21:41, 3 December 2018
Definition of the project
The group first selected a range of different maps showing the Paris Metropolitan at different years. In total, we collected from Gallica a set of two maps of the planning of the metro, from the definition of the routes to the addition of stations, a first map from 1908 of the actual metro after its construction in 1990, a second map from 1915, with already visible impacts of the first war, and a third map from 1950, a more contemporain look at the metro as we know it today. Our first idea was to analyse these maps in order to understand the evolution of the Paris Metropolitan, how different areas of major cultural attractions evolved around or hand in hand with the metro stations and how it was impacted by catastrophic events such as wars. However, as the goal of the project is to produce a working interface within a short amount of time, we decided to reduce the work of extraction of data to one map, which is the first map from 1908. Based on this map, we thus intend to build a superposition of a current map from Paris and the metro network extracted from the old map. From this visual display, will be able to see the evolution of the Paris Metropolitan from 1908 until nowadays and important historical explanations will be linked to corresponding stations. The result should take the form of a website page that displays the interactive map. The users would have the possibility to display the different layers, namely the layer of the old map, its metro network, with stations and lines, and this on top of a current map of Paris. Popup windows on each stations would display specific historical information about the station, which would be linked to the sources.
It is based on this prototype that the possibility to conduct similar data extractions on the other maps selected will be considered.
Main steps
- Download in high resolution the different maps
- Create a list of all stations from the first map of 1908
- Determine the main cultural attractions around these stations
- Georeferencing the map from 1908
- Create maps alignment with a contemporain map of Paris
- Extract paths and stations from the map
- Determine or extract coordinates of the different stations
- Create a Database with all the information gathered for each station from 1908
- Compare the first path and stations from 1908 with later representations of the Paris Metropolitan
- Create a website in order to display the maps in an interactive way
- pop up windows on specific points, such as stations with strong historical backgrounds
- an overlay of maps in order to better see the evolution from 1908 to more recent years
Milestones
Week 9 (14.11 - 16.11):
- Georeference, alignment with contemporain map and extraction of the paths and stations
- Preparation of the structure of a GeoJSON database
- Preparation of the midterm presentation
- Finalisation of milestones
Week 10 (21.11 - 23.11):
- Analyse of the evolution of the Paris Metropolitan based on the information gathered
- Finish Database in GeoJSON
- Finish writing the description of the extraction methods
- Planning for the creation of a website
Week 11 (28.11 - 30.11):
- Creation of the website to display the data
- Implementation of an interactive map
Week 12 (5.12 - 7.12):
- Finalization of the project
- Finish writing the report (historical introduction to the map, analysis of the performance of extraction, motivation and description of the services)
Historical introduction to the map
The maps used for the project were all published by A. Taride. The publishing house was founded by Alphonse Taride in 1852 [1] in Paris and was one of the first to create road, tourist and school maps. The group grew in 1895 when, helped by the "Union vélocipédique de France" and engineers from "Les ponts et chaussées", they printed their first maps at the scale of 1/25 000 000 [2]. These maps were considered as a reference in Europe and North Africa until 1930 [3]. Among their collection of vélocipédiques maps, they also proposed a range of Paris metropolitan maps and touristic guide, translated in different languages [4] .
Unfortunatelly, the firm is on a wane after the second World War and reduce his work to Paris maps and globes. The firm is later redeemed by the last french producer of globes.
Based on the maps, we can see that the publishing house was first located at 18 and 20 Boulevard Saint Denis (described on the 1908 and 1915 maps) and then moved to 154 Boulevard Saint Germain, as we can see on the 1950 map. They are all printed in color and display the city of Paris overlaid by the metropolitan network. They all provide a legend with the definition of the different paths and stations. The map from 1908 is at a scale of 1/8000, the map from 1915 of 1/21 000 and the one from 1950, at a scale of 1/33 000.
All the maps chosen represent the path of the Metropolitan of Paris overlaid on the city map. The first line of the Metropolitan of Paris was built in 1900 for the Paris Exposition Universelle. However, the race to build a network of railway transports started way before, around 1845, as many capital cities were considering the possibility to develop such transport systems, such as London, who built the world's first underground railway in 1890. Unfortunately, the project remained a subject of discussions during several years as the city of Paris wanted to build his own network for its inhabitants and the national railway services wanted to extend existing transports for people around the big metropole. The upcoming Exposition Universelle and the developments of such innovative means of transports in big capitals finally weighted on the balance to create an underground railway network specifically for the city of Paris [5]. The construction of the network was given to the engineer Fulgence Bienvenüe, the "Père Métro", who almost devoted his entire career to the project. The first planifications of the Metropolitan provided a total of six lines, labelled from A to F, and 18 stations[6]. The construction of the first line, from Porte de Vincennes to Porte Dauphine and which was called line A at the time of the planification, started in November 1898 [7]. According to the law from March 1898 enabling the construction of the Metropolitan[8], the tracks had to cross one above the other, the total length of the trains was set to a maximum of 72 meters and the platforms to 75 meters. The city transformed into a big construction site and first trains were tested in December 1899. However, it is only the year after, on July 19th 1900, and after the first months of the Exposition Universelle that the inauguration of the first line discreetly took place. Despite its official introduction away from the crowds, the press craze the morning after enabled the Metropolitan to benefit from a successful start. At rush hours, the underground network had a frequency of one train every 10 minutes with a constant speed of 25km per hours, whereas other means of transport at the surface could not go faster than 10 km per hours[9] ! The construction of the following lines from B-1, B-2 to line C, actual line 3 who was passing through different business districts, and the remaining stations of the first plans took place in the following years and finished before the first World War. Unfortunately, due to the latter, further improvements of the network were slowed down and constructions only restarted from 1925[10]. Another big upheaval, is the creation of the Régie Autonomie des Transports Parisiens (RATP) on January 1st 1949[11]. The creation of the famous control office that is still in charge of the network nowadays is due to important political and social changes that occurred at the end of World War II.
Detailed description of the extraction methods
In order to extract information from the map, we decided to work with the open source software QGIS3.
This software is a powerful GIS platform which enables to georeference maps, draw points, lines and polygones in order to create new and interactive maps or to enhance and analyse existing ones. It benefits from a good community of users, with even a specific associative platform for Switzerland.
The extraction of the information from the Paris map of 1908 required different steps, from the georeferencing to the extraction of the metropolitan network itself.
Georeferencing
The first step of the work with the 1908 map consists of georeferencing it, namely register it with a coordinate system in order to map it with a location on the surface of the earth [12]. Indeed, the basic map of the Metropolitan of Paris is just an image file that does not contain any geographic information such as coordinates. In order to create these coordinates, we had to work with a shapefile of the buildings of the city of Paris. These ressources are easily found "online", as their are freely made available by the city of Paris [13]. This shapefile is first imported in the new project created in QGIS. Then, the CRS (Coordonate Reference System) we are working with in the context of the project has to be correctly set to the french CRS, called RGF93. After having synchronized the layers with this CRS, the plugin Géoréférenceur GDAL[14] is used. It consists of a window, from which our image, the Paris map of 1908, is imported as a raster and displayed. A raster is an image file to which is added georeferencing information [15]. In order to determine the right coordinates on the image of 1908, a tool from the plugin enables to find matching points from the image to the shapefile of the city of Paris. The work consists of selecting a point on the image and to then find its visual correspondance on the shapefile of the buildings of Paris. We chose these points according to recognizable buildings which exists on both maps. In the end, a total of 6 coordinate points in order to launch the georeferencing. The transformation we then performed was generated with a Polynomiale 1 and a .tiff file was created. This .tiff file contains both the image and the coordinate information of the raster and can be used as a foundation for the following steps of the project.
Overlaying the old map on a contemporain basemap
Now that we have our old map as a raster, its image can be easily placed on top of a contemporain map with the help of its coordinates. QGIS3 proposes a feature called XYZ Tiles and which enables to easily overlay the raster on a tile layer, a corresponding basemap, from the "openstreetmap website".
Extracting information
Based on the raster created, the extraction of information can be performed. In order to extract the different stations, a Shapefile has to be created. A Shapefile, already introduced previously for the georeferencing, is a set of different files, .shp, .dbf, .shx, .prj, which all contains information that enables to create a map, with a coordinate system and a visual display via points, vectors or polygons. When creating a new layer Shapefile with QGIS, the name has to specified as well as the type of geometry aforesaid that can either be points, lines or polygons. Then, a list of fields can be define. This list of field is later filled for each point created and can constitute a database.
Railway stations
For the layer containing information about the stations, the type of geometry used is the point. We also added different fields of information for a future database discussed below. Among others, a first string field called stop_name, in order to store the name of the station, and a second string field called stop_line, in order to store the name of the line the station belongs to. Then, each station visible on the old Metropolitan map from Paris was selected with a point and given a Name and a Ligne accordingly.
Railway lines
We then created a second layer of Shapefile for the lines of the metro. The geometry used for this purpose is the line and the string field name was created. In order to map the vectors of the line with the exact coordinate of the stations previously set and create a coherent path, the snapping feature of QGIS3 [16] was enabled. The snapping enables to select a perimeter of anchor of a point on a layer. When drawing a line, existing points are then working as magnets and attract the line in order to make it pass through it. Thus, the 6 different lines of the Metropolitan of Paris from 1908, namely line 1, 2 Nord and 2 Sud, 3, 4, 5, 6, were created and passing through the exact coordinates of the stations previously established.
Implementing a process for further maps
As the extraction method presented above is not an expensive process in terms of time, mainly due to the scale of the data, the information from the last two maps from 1915 and 1950 presented in Selected maps were also extracted. In order to create a coherent database and a reusable process for later maps, as discussed below, the new stations and lines of both maps were extracted in a chronological way. We thus first started with the map from 1915 and determined the new stations that were created in-between 1908 and 1915 thanks to the georeference of the map and the possibility to overlay the previous data extracted. The process consists of three steps :
- Create a new shapefile layer for the stations of the map (here we started with 1915)
- Look for the name changes or station mergers. Add the points of the new stations as well as the different fields of information already used for the first extractions. Same applies with new lines.
- Then, for each station which name changed in-between the current map and the previous georeferenced one (here in-between 1908 and 1915), a new point is added to the current shapefile layer with the information change in the corresponding fields of information.
Thus, each shapefile layer corresponding to each different map (and consequently to different years) contains both the geolocalisation of the newly built stations and the stations whose name changed compared to the last georeferenced map. Layer after layer, we can thus see the metropolitan network growing.
Creation of a database
A significant aspect of this project is to create a database in order to further work with the data extracted, such as creating interactive maps, and to set the foundation of a reusable tool for later maps and contemporain changes of the Paris Metropolitan. In order to create this database, we used the information added manually for each point entries in QGIS. It was therefore important to create from the beginning the required fields of information in preparation of the database. In order to create a coherent database that can handle the adding of new stations, name or line changes and stations merging, the following fields were created:
- stop_id <int>: this corresponds to the identification number of each platform of a station. Indeed, when a station is affiliated to multiple metro lines, a new entry is created for each line, decomposing the station in different platforms. When a station point is created on a metro line, a stop_id is given with the following format : YYYYE, YYYY being the year of the map, E the unique number of entry of the specific point in the shapefile. When the name of the station is changed, the platform keeps its identification number.
- stop_name <string>: this corresponds to the name of the station as written on the map the station was extracted from. When the name changes on a new map, the entry corresponding to the station is duplicated, the stop_id remains the same and the stop_name field is changed to the corresponding information
- stop_line <string>: this corresponds to the name of the line to which the station is affiliated. If there are multiple lines passing through a station, then an entry is created for each platform within the station, as explained above, with a unique stop_id for each of them.
- stop_info <string>: historical information about the station
- start_map <int>: this number is under the form YYYY and corresponds to the year of creation of the map from which the station was retrieved. If the station changed name, this field corresponds to the year of the map where the name changed occurred.
- end_map <int>: this number is under the form YYYY and corresponds to the year of the map where the station name disappears, either because of a merged or because of a name or a line change.
- open_date <date_format>: this is the actual date of opening of the station, independently from the map it was retrieved. It is under the format YYYY-MM-DD.
- close_date <date_format>: this is the actual date of closure of the station, if it occurred, and this independently from the map it was retrieved. It is under the format YYYY-MM-DD or NaN, if the station is still in use.
- ratp_id <int>: this id corresponds to the identification number of the station according to the database provided by the RATP. By adding this identification, we enable the project to be used in varied contexts and to be affiliated to the RATP itself.
Thanks to the software QGIS, we were able to store the data for each station when creating its correspondant geolocated point on the shapefile. The whole can be then exported in various format, such as GeoJSON and csv, two formats widely used in the case of databases containing geographic references. We thus decided to export the database of each shapefile in both GeoJSON and csv formats in order to enable various use of the data collected. As we had a set of three different databases, each corresponding to one of the three maps from which the data was extracted, we decided to manually group them in one single file and operate a few changes either manually or with the help of a short program created with Python. Indeed, there were important name changes for a few lines that occurred from 1908 to 1950, for example the line 2 Sud, which became line 5 in-between 1908 and 1915 and line 6 before 1950. As we did not want to manually recreate a point at each location of the stations on the line for each map, the entries corresponding to that line were duplicated and the corresponding start_map and end_map were corrected with a few lines of code in Python.
As a result, we obtain two databases, one for the stations and one for the lines, which is implemented in the same way, and which exist in either a GeoJSON or a csv format. The database works as following: Each station was given a stop_id when first appearing on a map. The start_map corresponds to the year of the map where the information was retrieved and the end_map, the year of the last map where the information was seen. Each station is affiliated to a unique line which name is stored under stop_line. If multiple lines pass through a station, then there is a new entry for each lines, thus decomposing the station in different platforms. This is why it is said that the "stop_id" corresponds to a platform for a specific metro line within a station.
Adding new entries to the database
If new entries are added to the databases, then they must take into account the following rules:
- If the station is completely new, then a new entry is created with a new stop_id and stop_name. The start_map corresponds to the map from which the information is retrieved. The end_map corresponds to the last map from which the information is retrieved. This field should be updated to the other existing entires if the stations with the same lines still appear on the last map.
- If a station is still in operation today, a ratp_id is created to the station. If the station is a ghost station - not in operation anymore - the ratp_id entry would be empty.
- If the name of a station is changed, then the existing entry is duplicated. The stop_id remains, the stop_name is changed, the start_map is set to the current map from which the information is retrieved and end_map to the last map in which the information appears.
- If the name of the metro line is changed, then same apply as above, except that it is the stop_line that changes.
- If a station was merged, then the end_map of the station remains as the year of the last map from which the information was seen. The end_map of the main station which absorbed the other is changed to the last map from which the information was retrieved.
- If a station was renamed or merged with another station, then there is an entry in close_date with the date on which the station was renamed or merged. The close_date would only apply to the original stop_name and not to the renamed stop_name, which would have an open_date on which the station was renamed.
Quantative analysis of the performances of extraction
In order to determine the accuracy of the information retrieved from the three maps, two contemporain databases containing geolocation information of RATP stations were used. The first one is a database from the open data of the département Ile-de-France which is lead by the communication du Conseil régional d'Île-de-France. The second set of data was retrieved from the RATP open data, managed by the RATP. We decided to use two sets of data because both contains different geolocations for the stations of the Metropolitan. Furthermore, it seems that the database from the RATP also contains bus stops and all entrances of each Metropolitan station. In order to better determine the accuracy of our results, we compared with both sources.
The comparison was made with the help of the software QGIS. Both data set are under the form of geojson files and can be imported as shapefiles. Then, based on these shapefiles, a new layer made of buffers was generated for each of them with the MMQGIS plugin. These buffers are in fact circles that are created for each point on the source layer. The radius of these circles was set to 50 meters in order to have a margin of error, as geolocation points already differ from one source to another. Then, the comparison was made manually with the help of a excel file to store the results. If the station extracted from the old maps is located inside the perimeter of 50 meters generated around the station location from the official database, then the extraction is considered as successful. Otherwise, the extraction is incorrect. From this information gathered for each official dataset, the two below sector charts were generated. As we can see from these chart, there is a great difference between the comparison with both sets. The idf file is exclusively related to the Metropolitan stations and the extraction from the old maps cannot be considered as successful. On the other hand, the RATP file provides many different positions for each station. Thanks to these many locations, the data extracted from the maps seem more successful, with a total of 67% correct entries.
In a general way, we can say that either the way we extracted the data by georeferencing the maps in QGIS was not accurate enough, or that the maps themselves were not very precise. But as we checked the accuracy of the different entries, it seemed that there was proportionally no fewer mistakes with the map of 1950 (52 incorrect entries) than with the oldest one from 1908 (40 incorrect entries). We can thereby not conclude that the maps were not accurate, as one could consider the map from 1950 as being more precise than the first one. However, we saw that the greater mistakes, namely stations that were located way much more away than the official sources, were all peripheral stations and that the center of the maps generally benefited from a better accuracy.
Motivation and description of the demonstration of the data collected
The service provided with this extraction of data and the creation of a database are two interactive maps, available on a website, that enable the user to see the evolution of the Metropolitan of Paris based on the three key dates that are 1908, 1915 and 1950. Indeed, as we have seen on the three maps, there is a quick evolution of the Metropolitan in-between 1908 and 1915, as these years correspond to the period before the first World War and already reflects the first changes due to it, such as the name change of the Jean-Jaurès station. The last year studied, 1950, is interesting as it shows how the network evolved and grew after undergoing two World Wars and the german occupation during the last one. Names of stations changed in honor of soldiers or because of the aftereffects of political dissatisfactions. The Metropolitan of Paris is moreover a reflection of the evolution of the city itself and the rest of the information provided by the maps has to be taken into account as well, hence the possibility to have a side-by-side synchronized visualisation of the actual map of Paris and the three old maps.
Creation of interactive maps
The creation of interactive maps is made possible thanks to the structure of the database, which emphasize on storing the year of the maps from which each information was retrieved. Both maps were generated in Python with the Folium library, supported by leaflet, and later edited in Javascript for the html integration. Indeed, the final goal is to display the maps on an html page and Javascript code had to be generated in order to display the interactive information on a web browser.
As explained above, the first leaflet map generated enables to overlay the three networks retrieved from each historical document over an openstreet map. The user can thus select a specific network from either 1908, 1915 and 1950, and also superimpose them in order to compare the growing networks, determine which stations closed or if a path changed. In order to differentiate them, each network has a specific color. Green for the network of 1908, blue for 1915 and red for 1950. These colors were randomly given and simply help a better visual separation of the three sets of data. In order to display the information, each station is represented as a marker on the map and has a popup window that becomes visible when the user clicks on it. The information displayed on the popup window is the name of the station, the name of the line it is attached to, its official opening date, which does not correspond to the map date, the historical information of the station if it exists and the corresponding ratp identification number.
The second map is built based on the first map. It is in fact perpendicularly split in two, with, on the left side, the integration of the overlay of networks and, on the right side, the possibility to display one of the three historical map. Both windows work as one in term of interactions as the zooming on one of the map will affect both, as well as the movements of exploration within a map. With this map, the user can thus explore an old map and compare in real time the data it contains with the contemporain map of the left window and the different information retrieved from all other maps. In the specific case of the maps chosen, this feature is really interesting, as the old maps contain a city plan of Paris. In addition to the possibility to see the evolution of the Paris Metropolitan, the user can as well explore the evolutions that occurred within the buildings of the city.
Creation of a website
Thanks to the creation of a website, anyone can access the data extracted and, as a further possible development of the project, immerse himself in the history of the paris Metropolitan. The website is thus articulated around three pages. The index page has a direct link to this wikipage, describing in depth the project. A second page, called 'an evolution' displays the first map, which shows the three networks as overlays or separately. The third page, 'navigation through time', proposes on a full page the second map that is divided in two synchronized windows, with, on the right, the possibility to see one of the old map. Thanks to the possible comparison with the contemporain map of Paris that is displayed on the left window, the visitor can easily determine the changes that occurred through time with a Metropolitan perspective, but also with other urban changes, such as buildings, as the old maps also contain this information.
Selected maps
The different maps selected for the project are the following:
References
- ↑ Babelio, Taride Babelio, last accessed on 2018-11-13
- ↑ Corpus Cartographique Etampois, Alphonde Taride, Carte routière de l'Etampois en 1914, last accessed on 2018-11-13
- ↑ Corpus Cartographique Etampois, Alphonde Taride, Carte routière de l'Etampois en 1914, last accessed on 2018-11-13
- ↑ Babelio, Taride Babelio, last accessed on 2018-11-13
- ↑ Peter Hall, Underground as City Maker: London Versus Paris, 1863–2013, 2013, pp. 177-183, last accessed on 2018-11-13
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, p. 23
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, pp. 23-24
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, p. 23
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, p. 28
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, p. 54
- ↑ Michel Dansel, Paris-Metro, Editions du Dauphin, 1975, pp. 57-58
- ↑ GIS Ressources, What is Georeferencing?, last accessed on 2018-11-05
- ↑ Open Data "Open Data | Volumes bâtis - Données géographiques", last accessed on 2018-11-05
- ↑ QGIS 2.14 documentation "Extension de géoréférencement", last accessed on 2018-11-05
- ↑ EMSE "Glossaire des SIG - Raster (Format)", last accessed on 2018-11-05
- ↑ QGIS 2.18 Documentation "Editing", last accessed on 2018-11-05