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
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
|
# osm2pgsql
https://osm2pgsql.org
osm2pgsql is a tool for loading OpenStreetMap data into a PostgreSQL / PostGIS
database suitable for applications like rendering into a map, geocoding with
Nominatim, or general analysis.
See the [documentation](https://osm2pgsql.org/doc/) for instructions on how
to install and run osm2pgsql.
[](https://ci.appveyor.com/project/openstreetmap/osm2pgsql/branch/master)
[](https://github.com/openstreetmap/osm2pgsql/actions)
[](https://repology.org/project/osm2pgsql/versions)
## Features
* Converts OSM files to a PostgreSQL DB
* Conversion of tags to columns is configurable in the style file
* Able to read .gz, .bz2, .pbf and .o5m files directly
* Can apply diffs to keep the database up to date
* Support the choice of output projection
* Configurable table names
* Gazetteer back-end for [Nominatim](https://wiki.openstreetmap.org/wiki/Nominatim)
* Support for hstore field type to store the complete set of tags in one database
field if desired
## Installing
Most Linux distributions include osm2pgsql. It is available on macOS with
[Homebrew](https://brew.sh/) and Windows builds are also available. See
https://osm2pgsql.org/doc/install.html for details.
## Building
The latest source code is available in the osm2pgsql git repository on GitHub
and can be downloaded as follows:
```sh
git clone git://github.com/openstreetmap/osm2pgsql.git
```
Osm2pgsql uses the cross-platform [CMake build system](https://cmake.org/)
to configure and build itself.
Required libraries are
* [expat](https://libexpat.github.io/)
* [proj](https://proj.org/)
* [bzip2](http://www.bzip.org/)
* [zlib](https://www.zlib.net/)
* [Boost libraries](https://www.boost.org/), including system and filesystem
* [PostgreSQL](https://www.postgresql.org/) client libraries
* [Lua](https://www.lua.org/) (Optional, used for Lua tag transforms
and the flex output)
* [Python](https://python.org/) (only for running tests)
* [Psycopg](http://initd.org/psycopg/) (only for running tests)
It also requires access to a database server running
[PostgreSQL](https://www.postgresql.org/) 9.3+ and
[PostGIS](http://www.postgis.net/) 2.2+.
Make sure you have installed the development packages for the libraries
mentioned in the requirements section and a C++ compiler which supports C++11.
GCC 5 and later and Clang 3.5 and later are known to work.
To rebuild the included man page you'll need the [pandoc](https://pandoc.org/)
tool.
First install the dependencies.
On a Debian or Ubuntu system, this can be done with:
```sh
sudo apt-get install make cmake g++ libboost-dev libboost-system-dev \
libboost-filesystem-dev libexpat1-dev zlib1g-dev \
libbz2-dev libpq-dev libproj-dev lua5.3 liblua5.3-dev pandoc
```
On a Fedora system, use
```sh
sudo dnf install cmake make gcc-c++ boost-devel expat-devel zlib-devel \
bzip2-devel postgresql-devel proj-devel proj-epsg lua-devel pandoc
```
On RedHat / CentOS first run `sudo yum install epel-release` then install
dependencies with:
```sh
sudo yum install cmake make gcc-c++ boost-devel expat-devel zlib-devel \
bzip2-devel postgresql-devel proj-devel proj-epsg lua-devel pandoc
```
On a FreeBSD system, use
```sh
pkg install devel/cmake devel/boost-libs textproc/expat2 \
databases/postgresql94-client graphics/proj lang/lua52
```
On Alpine, use
```sh
apk --update-cache add cmake make g++ boost-dev expat-dev \
bzip2-dev zlib-dev libpq proj-dev lua5.3-dev
```
Once dependencies are installed, use CMake to build the Makefiles in a separate
folder:
```sh
mkdir build && cd build
cmake ..
```
If some installed dependencies are not found by CMake, more options may need
to be set. Typically, setting `CMAKE_PREFIX_PATH` to a list of appropriate
paths is sufficient.
When the Makefiles have been successfully built, compile with
```sh
make
```
The man page can be rebuilt with:
```sh
make man
```
The compiled files can be installed with
```sh
sudo make install
```
By default, the Release build with debug info is created and no tests are
compiled. You can change that behavior by using additional options like
following:
```sh
cmake .. -G "Unix Makefiles" -DCMAKE_BUILD_TYPE=Debug -DBUILD_TESTS=ON
```
### Using the PROJ library
Osm2pgsql has builtin support for the Latlong (WGS84, EPSG:4326) and the
WebMercator (EPSG:3857) projection. If you need other projections you have to
compile with the PROJ library.
Both the older API (PROJ version 4) and the newer API (PROJ version 6.1 and
above) are supported. Usually the CMake configuration will find a suitable
version and use it automatically, but you can set the `USE_PROJ_LIB` CMake
cache variable to choose between the following behaviours:
* `4`: Look for PROJ library with API version 4. If it is not found, stop with
error.
* `6`: Look for PROJ library with API version 6. If it is not found, stop with
error.
* `off`: Build without PROJ library.
* `auto`: Choose API 4 if available, otherwise API 6. If both are not available
build without PROJ library. (This is the default.)
## Using LuaJIT
To speed up Lua tag transformations, [LuaJIT](https://luajit.org/) can be
optionally enabled on supported platforms. This can speed up processing
considerably.
On a Debian or Ubuntu system install the LuaJIT library:
```sh
sudo apt-get install libluajit-5.1-dev
```
Configuration parameter `WITH_LUAJIT=ON` needs to be added to enable LuaJIT.
Otherwise make and installation steps are identical to the description above.
```sh
cmake -D WITH_LUAJIT=ON ..
```
Use `osm2pgsql --version` to verify that the build includes LuaJIT support.
The output should show something like
```
Lua 5.1.4 (LuaJIT 2.1.0-beta3)
```
## Help/Support
If you have problems with osm2pgsql or want to report a bug, go to
https://osm2pgsql.org/support/ .
## License
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
## Contributing
We welcome contributions to osm2pgsql. See [CONTRIBUTING.md](CONTRIBUTING.md)
and https://osm2pgsql.org/contribute/ for information on how to contribute.
|
