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
|
-- This config example file is released into the Public Domain.
-- This config shows how to access the attributes of OSM objects: the version,
-- changeset id, timestamp, user id and user name. For this to work the
-- command line option --extra-attributes/-x must be set, otherwise those
-- fields will be empty. Also note that some OSM files do not contain all
-- of those attributes, so check your input data if you get empty fields.
-- Set this to the projection you want to use
local srid = 4326
local tables = {}
tables.nodes = osm2pgsql.define_node_table('nodes', {
{ column = 'tags', type = 'jsonb' },
{ column = 'geom', type = 'point', projection = srid },
{ column = 'version', type = 'int' },
{ column = 'changeset', type = 'int' },
-- There is no built-in type for timestamps in osm2pgsql. So we use the
-- PostgreSQL type "timestamp" and then have to convert our timestamps
-- to a valid text representation for that type.
--
-- Timestamps in OSM are always in UTC, depending on your use case you
-- might want to store them using "timestamptz" instead.
-- See https://github.com/openstreetmap/osm2pgsql/issues/1785
{ column = 'created', sql_type = 'timestamp' },
{ column = 'uid', type = 'int' },
{ column = 'user', type = 'text' },
})
tables.ways = osm2pgsql.define_way_table('ways', {
{ column = 'tags', type = 'jsonb' },
{ column = 'geom', type = 'linestring', projection = srid },
{ column = 'version', type = 'int' },
{ column = 'changeset', type = 'int' },
{ column = 'created', sql_type = 'timestamp' },
{ column = 'uid', type = 'int' },
{ column = 'user', type = 'text' },
{ column = 'nodes', type = 'text', sql_type = 'bigint[]' },
})
tables.relations = osm2pgsql.define_relation_table('relations', {
{ column = 'tags', type = 'jsonb' },
{ column = 'version', type = 'int' },
{ column = 'changeset', type = 'int' },
{ column = 'created', sql_type = 'timestamp' },
{ column = 'uid', type = 'int' },
{ column = 'user', type = 'text' },
{ column = 'members', type = 'jsonb' },
})
local function format_date(ts)
return os.date('!%Y-%m-%dT%H:%M:%SZ', ts)
end
function osm2pgsql.process_node(object)
if next(object.tags) == nil then
return
end
tables.nodes:insert({
tags = object.tags,
geom = object:as_point(),
version = object.version,
changeset = object.changeset,
created = format_date(object.timestamp),
uid = object.uid,
user = object.user
})
end
function osm2pgsql.process_way(object)
tables.ways:insert({
tags = object.tags,
geom = object:as_linestring(),
version = object.version,
changeset = object.changeset,
created = format_date(object.timestamp),
uid = object.uid,
user = object.user,
nodes = '{' .. table.concat(object.nodes, ',') .. '}'
})
end
function osm2pgsql.process_relation(object)
tables.relations:insert({
tags = object.tags,
version = object.version,
changeset = object.changeset,
created = format_date(object.timestamp),
uid = object.uid,
user = object.user,
members = object.members
})
end
|
