-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathgaz_opennames.sql
More file actions
90 lines (79 loc) · 4.56 KB
/
gaz_opennames.sql
File metadata and controls
90 lines (79 loc) · 4.56 KB
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
-- phpMyAdmin SQL Dump
-- version 4.2.6deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 13, 2015 at 12:14 PM
-- Server version: 10.0.19-MariaDB-1~utopic-log
-- PHP Version: 5.5.12-2ubuntu4.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `mesh`
--
-- --------------------------------------------------------
--
-- Table structure for table `gaz_opennames`
--
CREATE TABLE IF NOT EXISTS `gaz_opennames` (
`ID` int(11) NOT NULL,
`OS_ID` varchar(39) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`NAMES_URI` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`NAME1` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`NAME1_LANG` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`NAME2` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`NAME2_LANG` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`TYPE` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`LOCAL_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`GEOMETRY_X` float DEFAULT NULL,
`GEOMETRY_Y` float DEFAULT NULL,
`GEOMETRY` point NOT NULL,
`MOST_DETAIL_VIEW_RES` int(11) DEFAULT NULL,
`LEAST_DETAIL_VIEW_RES` int(11) DEFAULT NULL,
`MBR_XMIN` int(11) DEFAULT NULL,
`MBR_YMIN` int(11) DEFAULT NULL,
`MBR_XMAX` int(11) DEFAULT NULL,
`MBR_YMAX` int(11) DEFAULT NULL,
`MBR` polygon NOT NULL,
`POSTCODE_DISTRICT` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`POSTCODE_DISTRICT_URI` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`POPULATED_PLACE` varchar(103) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`POPULATED_PLACE_URI` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`POPULATED_PLACE_TYPE` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`DISTRICT_BOROUGH` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`DISTRICT_BOROUGH_URI` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`DISTRICT_BOROUGH_TYPE` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`COUNTY_UNITARY` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`COUNTY_UNITARY_URI` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`COUNTY_UNITARY_TYPE` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`REGION` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`REGION_URI` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`COUNTRY` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`COUNTRY_URI` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`RELATED_SPATIAL_OBJECT` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`SAME_AS_DBPEDIA` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`SAME_AS_GEONAMES` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2585974 ;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `gaz_opennames`
--
ALTER TABLE `gaz_opennames`
ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `OS_ID` (`OS_ID`), ADD SPATIAL KEY `GEOMETRY` (`GEOMETRY`), ADD SPATIAL KEY `MBR` (`MBR`), ADD KEY `NAME1` (`NAME1`), ADD KEY `NAME2` (`NAME2`), ADD KEY `TYPE` (`TYPE`), ADD KEY `LOCAL_TYPE` (`LOCAL_TYPE`), ADD KEY `GEOMETRY_X` (`GEOMETRY_X`), ADD KEY `GEOMETRY_Y` (`GEOMETRY_Y`), ADD KEY `MBR_XMIN` (`MBR_XMIN`), ADD KEY `MBR_YMIN` (`MBR_YMIN`), ADD KEY `MBR_XMAX` (`MBR_XMAX`), ADD KEY `MBR_YMAX` (`MBR_YMAX`), ADD KEY `POSTCODE_DISTRICT` (`POSTCODE_DISTRICT`), ADD KEY `POPULATED_PLACE` (`POPULATED_PLACE`), ADD KEY `DISTRICT_BOROUGH` (`DISTRICT_BOROUGH`), ADD KEY `COUNTY_UNITARY` (`COUNTY_UNITARY`), ADD KEY `REGION` (`REGION`), ADD KEY `COUNTRY` (`COUNTRY`), ADD KEY `RELATED_SPATIAL_OBJECT` (`RELATED_SPATIAL_OBJECT`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `gaz_opennames`
--
ALTER TABLE `gaz_opennames`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2585974;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;