1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
|
osm2pgRouting 3.0.0
* cmake >= 3.12
* geometry column name: `geom`
New "ways" table structure
Column | Type | Modifications | Default
-------------------+---------------------------+--------------------+-----------
id | bigint | previously was gid | generated always as identity
osm_id | bigint |
tag_id | integer |
length | double precision |
length_m | double precision |
name | text |
source | bigint |
target | bigint |
source_osm | bigint |
target_osm | bigint |
cost | double precision |
reverse_cost | double precision |
cost_s | double precision |
reverse_cost_s | double precision |
rule | text |
one_way | integer |
oneway | text |
x1 | double precision |
y1 | double precision |
x2 | double precision |
y2 | double precision |
maxspeed_forward | double precision |
maxspeed_backward | double precision |
priority | double precision |
geom | geometry(LineString,4326) | previously was the_geom
New "ways_vertices_pgr" table structure
Column | Type | Default
-----------+----------------------+-------------------------------------------
id | bigint | Default: generated always as identity
in_edges | bigint[] | New column
out_edges | bigint[] | New column
x | numeric(11,8) | Default: generated always as (st_x(geom)) stored
y | numeric(11,8) | Default: generated always as (st_y(geom)) stored
osm_id | bigint |
geom | geometry(Point,4326)
osm2pgRouting 2.3.9
* Homebrew: Add algorithm for std::transform
osm2pgRouting 2.3.8
* Removing travis tests
* Updated FindPQXX to get the version
* Adding github actions for compilation:
* Postgres 9.6 to 13
* libpqxx 6 & 7
* Minimum Version Postgres 9.6 (supported version at this time)
* Minimum Version libpqxx 6
* C++ minimum standard depends on libpqxx
* For version libpqxx 6: C++14
* For version libpqxx 7: C++17
osm2pgRouting 2.3.7
* fix: Way - fixed bug handling oneway false conditions
* fix: fixed CMakeLists
* fix: adjustments to FindPostgreSQL.cmake.
* Improvements on mapconfig XML files.
* New docs: "Code of Conduct" and "Contributing".
* Docs improvements.
osm2pgRouting 2.3.6
* Fix: Incorrect classification of one-ways.
* Fix: command line configuration in print outputs (db password removed).
* Other minor fixes.
osm2pgRouting 2.3.5
* Fix: zero division error when max_speed = 0.
* Fix: fixed osm_ways parsing - OSMDocument.
* Fix: switch to a more inclusive check for nullptr definition (fixes compilation on macOS 10.13 using Xcode 9.3)
* Docs improvements: How to release doc.
osm2pgRouting 2.3.4
* Fix: osm_elements - fixed boolean assignment with boost::lexical_cast.
* Use ${CMAKE_INSTALL_PREFIX} in CMakeLists.txt.
* Readme doc improvements: Tips section and Table of contents.
osm2pgRouting 2.3.3
* Fix: wrong assumption in implied_oneWay() function
* Fix: regression on 2.3.2: fixed hstore refs handling
osm2pgRouting 2.3.2
* Fix: Only on linux: use the wc command to count lines
* Fix: the `osm_<tables>` are created only when addnodes flag is on
* Fix: removed unused flag of the command line
osm2pgRouting 2.3.1
* Fix: When keys have spaces
* Fix: Generating relations
osm2pgRouting 2.3.0
* Cost should not return the same value
* Added a points of Interest table
* Some default one_way values are taken into consideration
* Relations are also condsidered
* New mapconfig_for_pedestrian.xml
osm2pgRouting 2.2.0
* Adding foreign keys to the tables.
* Added a progress bar.
* New mapconfig_for_bicycles.xml
* Improved the C++ code.
* remove the use of pointers to avoid leaks.
* Table `osm_ways_tags` because information is redundant.
osm2pgRouting 2.1.0
New "ways" table structure:
Column | Type | Modifications
-------------------+---------------------------+----------------
gid | bigint |
class_id | integer |
length | double precision |
length_m | double precision | new column
name | text |
source | bigint |
target | bigint |
x1 | double precision |
y1 | double precision |
x2 | double precision |
y2 | double precision |
cost | double precision | name changed from 'to_cost'
reverse_cost | double precision |
cost_s | double precision | new column
reverse_cost_s | double precision | new column
rule | text |
one_way | integer | new column
maxspeed_forward | integer |
maxspeed_backward | integer |
osm_id | bigint |
source_osm | bigint | new column
target_osm | bigint | new column
priority | double precision |
the_geom | geometry(LineString,4326) |
New "ways_vertices_pgr" table structure
Column | Type | Modifications
----------+----------------------+----------------------------------------------------------------
id | bigint |
osm_id | bigint | new column
cnt | integer |
chk | integer |
ein | integer |
eout | integer |
lon | numeric(11,8) | new column
lat | numeric(11,8) | new column
the_geom | geometry(Point,4326) |
Indexes:
"ways_vertices_pgr_pkey" PRIMARY KEY, btree (id)
"vertex_id" UNIQUE CONSTRAINT, btree (osm_id)
"ways_vertices_pgr_gdx" gist (the_geom)
"ways_vertices_pgr_osm_id_idx" btree (osm_id)
|
