<= CREATE TABLE types (class CHAR(1), tcd TINYINT(4), stcd TINYINT(4), tdesc VARCHAR(255), PRIMARY KEY (class, tcd, stcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'types' already exists ) <= CREATE TABLE countries (cid INTEGER PRIMARY KEY, ecc CHAR(2), ccd CHAR(1), cname VARCHAR(100)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'countries' already exists ) <= CREATE TABLE locationdatasets (cid INTEGER, tabcd INTEGER, dcomment VARCHAR(100), version VARCHAR(8), versiondescription VARCHAR(100), PRIMARY KEY (cid, tabcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'locationdatasets' already exists ) <= CREATE TABLE languages (cid INTEGER, lid INTEGER, language VARCHAR(100), PRIMARY KEY (cid, lid)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'languages' already exists ) <= CREATE TABLE locationcodes (cid INTEGER, tabcd INTEGER, lcd INTEGER, allocated BOOLEAN, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'locationcodes' already exists ) <= CREATE TABLE names (cid INTEGER, lid INTEGER, nid INTEGER, name VARCHAR(255), ncomment VARCHAR(255), KEY cnid (cid, nid), PRIMARY KEY (cid, lid, nid)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'names' already exists ) <= CREATE TABLE administrativearea (cid INTEGER, tabcd INTEGER, lcd INTEGER, class CHAR, tcd TINYINT, stcd TINYINT, nid INTEGER, pol_lcd INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'administrativearea' already exists ) <= CREATE TABLE otherareas (cid INTEGER, tabcd INTEGER, lcd INTEGER, class CHAR, tcd TINYINT, stcd TINYINT, nid INTEGER, pol_lcd INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'otherareas' already exists ) <= CREATE TABLE roads (cid INTEGER, tabcd INTEGER, lcd INTEGER, class CHAR, tcd TINYINT, stcd TINYINT, roadnumber VARCHAR(16), rnid INTEGER, n1id INTEGER, n2id INTEGER, pol_lcd INTEGER, pes_lev INTEGER, rdid INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'roads' already exists ) <= CREATE TABLE segments (cid INTEGER, tabcd INTEGER, lcd INTEGER, class CHAR, tcd TINYINT, stcd TINYINT, roadnumber VARCHAR(16), rnid INTEGER, n1id INTEGER, n2id INTEGER, roa_lcd INTEGER, seg_lcd INTEGER, pol_lcd INTEGER, rdid INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'segments' already exists ) <= CREATE TABLE soffsets (cid INTEGER, tabcd INTEGER, lcd INTEGER, neg_off_lcd INTEGER, pos_off_lcd INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'soffsets' already exists ) <= CREATE TABLE points (cid INTEGER, tabcd INTEGER, lcd INTEGER, class CHAR, tcd TINYINT, stcd TINYINT, junctionnumber VARCHAR(16), rnid INTEGER, n1id INTEGER, n2id INTEGER, pol_lcd INTEGER, oth_lcd INTEGER, seg_lcd INTEGER, roa_lcd INTEGER, inpos BOOLEAN, inneg BOOLEAN, outpos BOOLEAN, outneg BOOLEAN, presentpos BOOLEAN, presentneg BOOLEAN, diversionpos BOOLEAN, diversionneg BOOLEAN, xcoord REAL, ycoord REAL, interruptsroad INTEGER, urban BOOLEAN, jnid INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'points' already exists ) <= CREATE TABLE poffsets (cid INTEGER, tabcd INTEGER, lcd INTEGER, neg_off_lcd INTEGER, pos_off_lcd INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'poffsets' already exists ) <= CREATE TABLE intersections (cid INTEGER, tabcd INTEGER, lcd INTEGER, int_cid INTEGER, int_tabcd INTEGER, int_lcd INTEGER, PRIMARY KEY (cid, tabcd, lcd)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Array ( [0] => 42S01 [1] => 1050 [2] => Table 'intersections' already exists ) Array ( [CLASS] => A [TCD] => 1 [STCD] => 0 [TDESC] => continent ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 2 [STCD] => 0 [TDESC] => country group ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 3 [STCD] => 0 [TDESC] => country ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 5 [STCD] => 0 [TDESC] => water area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 5 [STCD] => 1 [TDESC] => sea ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 5 [STCD] => 2 [TDESC] => lake ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 0 [TDESC] => fuzzy area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 1 [TDESC] => tourist area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 2 [TDESC] => metropolitan area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 3 [TDESC] => industrial area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 4 [TDESC] => traffic area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 5 [TDESC] => meteorological area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 6 [TDESC] => carpool area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 7 [TDESC] => park and ride area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 6 [STCD] => 8 [TDESC] => car park area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 7 [STCD] => 0 [TDESC] => order 1 area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 8 [STCD] => 0 [TDESC] => order 2 area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 9 [STCD] => 0 [TDESC] => order 3 area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 9 [STCD] => 1 [TDESC] => rural county ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 9 [STCD] => 2 [TDESC] => urban county ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 10 [STCD] => 0 [TDESC] => order 4 area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 11 [STCD] => 0 [TDESC] => order 5 area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => A [TCD] => 12 [STCD] => 0 [TDESC] => application region ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 1 [STCD] => 0 [TDESC] => road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 1 [STCD] => 1 [TDESC] => motorway ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 1 [STCD] => 2 [TDESC] => 1st class road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 1 [STCD] => 3 [TDESC] => 2nd class road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 1 [STCD] => 4 [TDESC] => 3rd class road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 2 [STCD] => 0 [TDESC] => ring road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 2 [STCD] => 1 [TDESC] => ring motorway ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 2 [STCD] => 2 [TDESC] => other ring road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 3 [STCD] => 0 [TDESC] => order 1 segment ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 4 [STCD] => 0 [TDESC] => order 2 segment ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 5 [STCD] => 0 [TDESC] => urban street ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 6 [STCD] => 0 [TDESC] => vehicular link ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 6 [STCD] => 1 [TDESC] => ferry ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 6 [STCD] => 2 [TDESC] => vehicular rail link ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => L [TCD] => 7 [STCD] => 0 [TDESC] => link road ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 0 [TDESC] => junction ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 1 [TDESC] => motorway intersection ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 2 [TDESC] => motorway triangle ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 3 [TDESC] => motorway junction ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 4 [TDESC] => motorway exit ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 5 [TDESC] => motorway entrance ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 6 [TDESC] => flyover ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 7 [TDESC] => underpass ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 8 [TDESC] => roundabout ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 9 [TDESC] => gyratory ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 10 [TDESC] => traffic lights ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 11 [TDESC] => cross-roads ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 12 [TDESC] => T-junction ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 13 [TDESC] => intermediate node ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 14 [TDESC] => connection ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 1 [STCD] => 15 [TDESC] => exit ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 2 [STCD] => 0 [TDESC] => intermediate point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 2 [STCD] => 1 [TDESC] => distance marker ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 2 [STCD] => 2 [TDESC] => traffic monitoring station ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 0 [TDESC] => other landmark point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 1 [TDESC] => tunnel ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 2 [TDESC] => bridge ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 3 [TDESC] => service area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 4 [TDESC] => rest area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 5 [TDESC] => view point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 6 [TDESC] => carpool point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 7 [TDESC] => park and ride site ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 8 [TDESC] => car park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 9 [TDESC] => kiosk ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 10 [TDESC] => kiosk with WC ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 11 [TDESC] => petrol station ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 12 [TDESC] => petrol station with kiosk ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 13 [TDESC] => motel ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 14 [TDESC] => border/frontier ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 15 [TDESC] => customs post ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 16 [TDESC] => toll plaza ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 17 [TDESC] => ferry terminal ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 18 [TDESC] => harbour ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 19 [TDESC] => square ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 20 [TDESC] => fair ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 21 [TDESC] => garage ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 22 [TDESC] => underground garage ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 23 [TDESC] => retail park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 24 [TDESC] => theme park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 25 [TDESC] => tourist attraction ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 26 [TDESC] => university ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 27 [TDESC] => airport ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 28 [TDESC] => station ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 29 [TDESC] => hospital ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 30 [TDESC] => church ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 31 [TDESC] => stadium ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 32 [TDESC] => palace ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 33 [TDESC] => castle ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 34 [TDESC] => town hall ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 35 [TDESC] => exhibition/convention centre ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 36 [TDESC] => community ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 37 [TDESC] => place name ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 38 [TDESC] => dam ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 39 [TDESC] => dike ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 40 [TDESC] => aqueduct ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 41 [TDESC] => lock ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 42 [TDESC] => mountain crossing/pass ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 43 [TDESC] => railroad crossing ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 44 [TDESC] => wade ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 45 [TDESC] => ferry ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 46 [TDESC] => industrial area ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 3 [STCD] => 47 [TDESC] => viaduct ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 4 [STCD] => 0 [TDESC] => link road point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 0 [TDESC] => parking POI ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 1 [TDESC] => underground parking garage ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 2 [TDESC] => car park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 3 [TDESC] => parking garage ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 4 [TDESC] => carpool point ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 5 [TDESC] => park and ride site ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 6 [TDESC] => rest area parking ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 5 [STCD] => 7 [TDESC] => campground ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 0 [TDESC] => other isolated POI ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 1 [TDESC] => airport ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 2 [TDESC] => station ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 3 [TDESC] => harbour ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 4 [TDESC] => tunnel ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 5 [TDESC] => bridge ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 6 [TDESC] => ferry ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 7 [TDESC] => square ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 8 [TDESC] => fair ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 9 [TDESC] => retail park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 10 [TDESC] => theme park ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 11 [TDESC] => tourist attraction ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 12 [TDESC] => stadium ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 13 [TDESC] => exhibition/convention centre ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' ) Array ( [CLASS] => P [TCD] => 6 [STCD] => 14 [TDESC] => place name ) Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tdesc' in 'field list' )