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
|
CREATE TABLE itn.ferrylink
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
directednode_ref character varying[],
directednode_orientation integer[],
fid text,
filename text,
CONSTRAINT ferrylink_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = (-1))
)
WITH (
OIDS=FALSE
);
CREATE TABLE itn.ferrynode
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
fid text,
filename text,
CONSTRAINT ferrynode_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'POINT'::text OR wkb_geometry IS NULL),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = 27700)
)
WITH (
OIDS=FALSE
);
CREATE TABLE itn.informationpoint
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
junctionname text,
fid text,
filename text,
CONSTRAINT informationpoint_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'POINT'::text OR wkb_geometry IS NULL),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = 27700)
)
WITH (
OIDS=FALSE
);
CREATE TABLE itn.road
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
roadname character varying[],
networkmember_ref character varying[],
fid text,
filename text,
descriptiveterm text,
CONSTRAINT road_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = (-1))
)
WITH (
OIDS=FALSE
);
CREATE TABLE itn.roadlinkinformation
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
classification text,
referencetoroadlink_ref text,
distancefromstart double precision,
fid text,
filename text,
feet integer,
inches integer,
maxheight double precision,
type text,
use character varying[],
instruction text,
starttime text,
endtime text,
CONSTRAINT roadlinkinformation_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'POINT'::text OR wkb_geometry IS NULL),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = 27700)
)
WITH (
OIDS=FALSE
);
CREATE TABLE itn.roadrouteinformation
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
version integer,
versiondate text,
theme text,
changedate character varying[],
reasonforchange character varying[],
descriptivegroup text,
classification text,
directedlink_ref character varying[],
directedlink_orientation integer[],
fid text,
filename text,
type character varying[],
instruction text,
distancefromstart double precision,
use character varying[],
day character varying[],
starttime character varying[],
endtime character varying[],
load character varying[],
namedtime text,
startdate text,
enddate text,
nameddate character varying[],
CONSTRAINT roadrouteinformation_pk PRIMARY KEY (ogc_fid ),
CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 2),
CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = 27700)
)
WITH (
OIDS=FALSE
);
|
