source: subversion/applications/utils/import/airport_import/db.sql @ 5763

Last change on this file since 5763 was 2669, checked in by hakan, 13 years ago

Import runways, store unicode place names

File size: 914 bytes
Line 
1
2drop table airport_place_node;
3
4create table airport_place_node (id SERIAL,
5        osm_id integer,
6        name varchar,
7        icao varchar,
8        lat double precision, lon double precision,
9        min_lat double precision, min_lon double precision,
10        max_lat double precision, max_lon double precision
11        );
12
13\d airport_place_node;
14
15
16
17drop table airport_ways;
18
19create table airport_ways (id SERIAL,
20        parent_id integer,
21        osm_id integer,
22        runway_number varchar,
23        heading double precision,
24        length double precision,
25        width double precision,
26        center_lat double precision, center_lon double precision
27        );
28
29\d airport_ways;
30
31
32
33
34drop table airport_tags;
35
36create table airport_tags (id SERIAL,
37        parent_id integer,
38        type char,
39        key varchar,
40        value varchar
41        );
42
43\d airport_tags;
44
45
46
47
48drop table airport_nodes;
49
50create table airport_nodes (id SERIAL,
51        parent_id integer,
52        type char,
53        lat double precision,
54        lon double precision
55        );
56
57\d airport_tags;
58
59
60\d;
Note: See TracBrowser for help on using the repository browser.