Νομοί και πόλεις τις Ελλάδας + συντεταγμένες

Συζητήσεις για την βάση δεδομένων MySQL και το phpMyAdmin

Συντονιστές: WebDev Moderators, Super-Moderators

Απάντηση
Άβαταρ μέλους
nirvana
Δημοσιεύσεις: 241
Εγγραφή: 01 Σεπ 2005 18:28
Τοποθεσία: Αγ. Παρασκευή

Νομοί και πόλεις τις Ελλάδας + συντεταγμένες

Δημοσίευση από nirvana » 23 Απρ 2014 01:52

Επειδή δεν βρήκα πουθενά μία λιστα με τους νομούς και τις κύριες πόλεις της Ελλάδας με συντεταγμένες, είπα να την προσθέσω εδώ μπας και την χρειαστεί κανένας. Τις περισσότερες συντεταγμένες τις προσέθεσα με το χέρι, οπότε μπορεί να υπάρχει κάποιο λάθος (διπλοτσεκάρετε πριν το χρησιμοποιήσετε). Επίσης υπάρχει περίπτωση να έχω ξεχάσει κάποια πόλη, οπότε προσθέστε την μόνοι σας.

2 σημειώσεις: α) Το zoom είναι σχετικό. Αν έχετε μεγαλύτερο ή μιρότερο "καμβά" ίσως πρέπει να το αλλάξετε. β) Η επιλογή των περιοχών δεν είναι ακριβώς οι νομοί της Ελλάδος αλλά περιοχές αφαιρετικά. Αν θέλετε μια official λιστα, πιθανών να μην σας καλύπτει αυτός ο κώδικας.

Κώδικας: Επιλογή όλων

CREATE TABLE `area` (
	`id` INT(10) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

INSERT INTO `area` (`id`, `name`) VALUES (1, 'Αττική');
INSERT INTO `area` (`id`, `name`) VALUES (2, 'Θεσσαλονίκη');
INSERT INTO `area` (`id`, `name`) VALUES (3, 'Αργολίδα');
INSERT INTO `area` (`id`, `name`) VALUES (4, 'Αρκαδία');
INSERT INTO `area` (`id`, `name`) VALUES (5, 'Άρτα');
INSERT INTO `area` (`id`, `name`) VALUES (6, 'Αιτωλοακαρνανία');
INSERT INTO `area` (`id`, `name`) VALUES (7, 'Αχαία');
INSERT INTO `area` (`id`, `name`) VALUES (8, 'Βοιωτία');
INSERT INTO `area` (`id`, `name`) VALUES (9, 'Γρεβενά');
INSERT INTO `area` (`id`, `name`) VALUES (10, 'Δράμα');
INSERT INTO `area` (`id`, `name`) VALUES (11, 'Δωδεκάνησα');
INSERT INTO `area` (`id`, `name`) VALUES (12, 'Εύρος');
INSERT INTO `area` (`id`, `name`) VALUES (13, 'Εύβοια');
INSERT INTO `area` (`id`, `name`) VALUES (14, 'Ζάκυνθος');
INSERT INTO `area` (`id`, `name`) VALUES (15, 'Ηλεία');
INSERT INTO `area` (`id`, `name`) VALUES (16, 'Ημαθία');
INSERT INTO `area` (`id`, `name`) VALUES (17, 'Ηράκλειο');
INSERT INTO `area` (`id`, `name`) VALUES (18, 'Θεσπρωτία');
INSERT INTO `area` (`id`, `name`) VALUES (19, 'Ιωάννινα');
INSERT INTO `area` (`id`, `name`) VALUES (20, 'Καβάλα');
INSERT INTO `area` (`id`, `name`) VALUES (21, 'Καρδίτσα');
INSERT INTO `area` (`id`, `name`) VALUES (22, 'Καστοριά');
INSERT INTO `area` (`id`, `name`) VALUES (23, 'Κέρκυρα');
INSERT INTO `area` (`id`, `name`) VALUES (24, 'Κεφαλλονιά');
INSERT INTO `area` (`id`, `name`) VALUES (25, 'Κιλκίς');
INSERT INTO `area` (`id`, `name`) VALUES (26, 'Κοζάνη');
INSERT INTO `area` (`id`, `name`) VALUES (27, 'Κορινθία');
INSERT INTO `area` (`id`, `name`) VALUES (28, 'Κυκλάδες');
INSERT INTO `area` (`id`, `name`) VALUES (29, 'Λακωνία');
INSERT INTO `area` (`id`, `name`) VALUES (30, 'Λάρισα');
INSERT INTO `area` (`id`, `name`) VALUES (31, 'Λέσβος');
INSERT INTO `area` (`id`, `name`) VALUES (32, 'Λευκάδα');
INSERT INTO `area` (`id`, `name`) VALUES (33, 'Μαγνησία');
INSERT INTO `area` (`id`, `name`) VALUES (34, 'Μεσσηνία');
INSERT INTO `area` (`id`, `name`) VALUES (35, 'Ξάνθη');
INSERT INTO `area` (`id`, `name`) VALUES (36, 'Πέλλα');
INSERT INTO `area` (`id`, `name`) VALUES (37, 'Πιερία');
INSERT INTO `area` (`id`, `name`) VALUES (38, 'Πρέβεζα');
INSERT INTO `area` (`id`, `name`) VALUES (39, 'Ρέθυμνο');
INSERT INTO `area` (`id`, `name`) VALUES (40, 'Ροδόπη');
INSERT INTO `area` (`id`, `name`) VALUES (41, 'Σάμος');
INSERT INTO `area` (`id`, `name`) VALUES (42, 'Σέρρες');
INSERT INTO `area` (`id`, `name`) VALUES (43, 'Τρίκαλα');
INSERT INTO `area` (`id`, `name`) VALUES (44, 'Χανιά');
INSERT INTO `area` (`id`, `name`) VALUES (45, 'Φθιώτιδα');

CREATE TABLE `city` (
	`id` INT(10) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255) NULL DEFAULT NULL,
	`area_id` VARCHAR(255) NULL DEFAULT NULL,
	`center_latitude` DECIMAL(9,6) NULL DEFAULT NULL,
	`center_longitude` DECIMAL(9,6) NULL DEFAULT NULL,
	`zoom` INT(2) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (1, 'Αγία Βαρβάρα', '1', 37.990379, 23.658371, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (2, 'Αγία Παρασκευή', '1', 38.008201, 23.817801, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (3, 'Άγιοι Ανάργυροι', '1', 38.025850, 23.722658, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (4, 'Άγιος Δημήτριος', '1', 37.935601, 23.729954, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (5, 'Άγιος Ιωάννης Ρέντης', '1', 37.966734, 23.670001, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (6, 'Άγιος Στέφανος', '1', 38.141172, 23.862391, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (7, 'Αθήνα', '1', 37.983581, 23.729267, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (8, 'Αιάντειο', '1', 37.921993, 23.455210, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (9, 'Αιγάλεω', '1', 37.988654, 23.682489, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (10, 'Αίγινα', '1', 37.748322, 23.451347, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (11, 'Άλιμος', '1', 37.913123, 23.723602, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (12, 'Αμπελάκια', '1', 37.951237, 23.529131, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (13, 'Ανάβυσσος', '1', 37.735155, 23.942471, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (14, 'Ανθούσα', '1', 38.025580, 23.874407, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (15, 'Άνοιξη', '1', 38.124092, 23.852177, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (16, 'Άνω Λιόσια', '1', 38.081068, 23.699398, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (17, 'Αργυρούπολη', '1', 37.906351, 23.752785, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (18, 'Άρτεμις', '1', 37.968019, 24.005470, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (19, 'Ασπρόπυργος', '1', 38.064581, 23.590393, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (20, 'Αυλώνα', '1', 38.251089, 23.695965, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (21, 'Αχαρνές', '1', 38.091877, 23.749523, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (22, 'Βάρη', '1', 37.830057, 23.804197, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (23, 'Βίλια', '1', 38.167157, 23.338437, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (24, 'Βούλα', '1', 37.844359, 23.769264, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (25, 'Βουλιαγμένη', '1', 37.820023, 23.776646, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (26, 'Βριλήσσια', '1', 38.037208, 23.835611, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (27, 'Βύρωνας', '1', 37.957598, 23.758192, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (28, 'Γαλάτσι', '1', 38.018818, 23.757935, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (29, 'Γέρακας', '1', 38.015775, 23.857498, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (31, 'Γλυκά Νερά', '1', 37.990481, 23.848057, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (32, 'Γλυφάδα', '1', 37.875260, 23.761711, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (33, 'Δάφνη', '1', 37.951203, 23.731585, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (34, 'Διόνυσος', '1', 38.100591, 23.881102, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (35, 'Δραπετσώνα', '1', 37.948800, 23.627172, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (36, 'Δροσιά', '1', 38.113220, 23.863249, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (37, 'Εκάλη', '1', 38.107615, 23.842564, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (38, 'Ελευσίνα', '1', 38.045928, 23.542328, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (39, 'Ελληνικό', '1', 37.894160, 23.740597, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (40, 'Ερυθρές', '1', 38.217413, 23.322773, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (41, 'Ζωγράφος', '1', 37.974819, 23.774242, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (42, 'Ηλιούπολη', '1', 37.931200, 23.751926, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (43, 'Ηράκλειο', '1', 38.049646, 23.774242, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (44, 'Θρακομακεδόνες', '1', 38.133679, 23.759651, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (45, 'Ίλιον', '1', 38.032138, 23.702917, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (46, 'Καισαριανή', '1', 37.966700, 23.761196, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (47, 'Καλλιθέα', '1', 37.951846, 23.700342, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (48, 'Καλύβια Θορικού', '1', 37.823074, 23.908310, 12);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (49, 'Καματερό', '1', 38.056810, 23.712959, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (50, 'Καπανδρίτι', '1', 38.213097, 23.887024, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (51, 'Κερατέα', '1', 37.807038, 23.977060, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (52, 'Κερατσίνι', '1', 37.962674, 23.619318, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (53, 'Κηφισιά', '1', 38.087959, 23.824711, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (54, 'Κορυδαλλός', '1', 37.983581, 23.649445, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (55, 'Κορωπί', '1', 37.902965, 23.873978, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (56, 'Κρυονέρι', '1', 38.136649, 23.830462, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (57, 'Κύθηρα', '1', 36.255902, 22.984085, 11);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (58, 'Λαύριο', '1', 37.706504, 24.052591, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (59, 'Λυκόβρυση', '1', 38.067690, 23.782225, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (60, 'Μάνδρα', '1', 38.074041, 23.499026, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (61, 'Μαραθώνας', '1', 38.168034, 23.987274, 11);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (62, 'Μαρκόπουλο', '1', 37.884067, 23.934574, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (63, 'Μαρούσι', '1', 38.046063, 23.804798, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (64, 'Μέγαρα', '1', 37.993457, 23.344059, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (65, 'Μέθανα', '1', 37.581623, 23.389978, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (66, 'Μελίσσια', '1', 38.057756, 23.840590, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (67, 'Μεταμόρφωση', '1', 38.064244, 23.763342, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (68, 'Μοσχάτο', '1', 37.953944, 23.683004, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (69, 'Νέα Ερυθραία', '1', 38.095052, 23.822651, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (70, 'Νέα Ιωνία', '1', 38.038628, 23.759737, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (71, 'Νέα Μάκρη', '1', 38.072825, 23.981953, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (72, 'Νέα Παλάτια', '1', 38.319269, 23.796515, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (73, 'Νέα Πεντέλη', '1', 38.059310, 23.857241, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (74, 'Νέα Πέραμος', '1', 38.016587, 23.444824, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (75, 'Νέα Σμύρνη', '1', 37.943927, 23.713989, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (76, 'Νέα Φιλαδέλφεια', '1', 38.042886, 23.740683, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (77, 'Νέα Χαλκιδόνα', '1', 38.028149, 23.730211, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (78, 'Νέο Ψυχικό', '1', 38.005226, 23.781710, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (79, 'Νίκαια', '1', 37.971538, 23.644123, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (80, 'Παιανία', '1', 37.958952, 23.852692, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (81, 'Παλαιό Φάληρο', '1', 37.927545, 23.704205, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (82, 'Παλλήνη', '1', 38.002926, 23.892517, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (83, 'Παλούκια', '1', 37.965008, 23.515506, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (84, 'Παπάγου', '1', 37.988451, 23.793640, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (85, 'Πειραιάς', '1', 37.945687, 23.650131, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (86, 'Πεντέλη', '1', 38.046469, 23.867970, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (87, 'Πέραμα', '1', 37.962335, 23.581381, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (88, 'Περιστέρι', '1', 38.011853, 23.692703, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (89, 'Πετρούπολη', '1', 38.040115, 23.684120, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (90, 'Πεύκη', '1', 38.059783, 23.793468, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (91, 'Πολιτεία', '1', 38.087283, 23.831148, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (92, 'Πόρος Τροιζήνας', '1', 37.502372, 23.455210, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (94, 'Ραφήνα', '1', 38.022808, 23.997231, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (95, 'Ροδόπολη', '1', 38.116225, 23.876982, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (96, 'Σαλαμίνα', '1', 37.941761, 23.505592, 12);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (97, 'Σπάτα', '1', 37.962708, 23.913803, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (98, 'Σπέτσες', '1', 37.262987, 23.157635, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (99, 'Σταμάτα', '1', 38.128885, 23.877239, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (100, 'Ταύρος', '1', 37.969779, 23.694334, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (101, 'Ύδρα', '1', 37.347576, 23.466711, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (102, 'Υμηττός', '1', 37.951270, 23.748879, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (103, 'Φιλοθέη', '1', 38.023484, 23.782310, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (104, 'Χαϊδάρι', '1', 38.010974, 23.656998, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (105, 'Χαλάνδρι', '1', 38.021083, 23.799090, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (106, 'Χολαργός', '1', 37.999071, 23.799562, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (107, 'Ψυχικό', '1', 38.010230, 23.773642, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (108, 'Άγιος Αθανάσιος', '2', 40.716526, 22.728524, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (109, 'Άγιος Παύλος', '2', 40.639423, 22.962885, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (110, 'Αμπελόκηποι', '2', 40.653881, 22.924390, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (111, 'Ασβεστοχώρι', '2', 40.641312, 23.025541, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (112, 'Ασκός', '2', 40.749630, 23.387189, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (113, 'Ασπροβάλτα', '2', 40.723356, 23.705921, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (114, 'Βασιλικά', '2', 40.479598, 23.136950, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (115, 'ΒΙ.ΠΕ.Θ.', '2', 40.688774, 22.796888, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (116, 'Γέφυρα Θεσσαλονίκης', '2', 40.732104, 22.694192, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (117, 'Ελευθέριο - Κορδελιό', '2', 40.670906, 22.893062, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (118, 'Επανομή', '2', 40.426238, 22.927737, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (119, 'Ευκαρπία', '2', 40.685715, 22.950826, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (120, 'Εύοσμος', '2', 40.665926, 22.910185, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (121, 'Ζαγκλιβέρι', '2', 40.572142, 23.289127, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (122, 'Θέρμη', '2', 40.548635, 23.019962, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (123, 'Θεσσαλονίκη', '2', 40.629588, 22.945461, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (125, 'Καλαμαριά', '2', 40.579933, 22.956018, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (126, 'Καλοχώρι', '2', 40.641605, 22.858086, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (127, 'Κουφάλια', '2', 40.780021, 22.578964, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (128, 'Λαγκαδάς', '2', 40.751809, 23.069229, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (129, 'Λαγκαδίκια', '2', 40.636525, 23.246405, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (130, 'Μελισσοχώρι', '2', 40.768679, 22.929497, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (131, 'Μενεμένη', '2', 40.655443, 22.909155, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (132, 'Νέα Απολλωνία', '2', 40.640140, 23.486967, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (133, 'Νέα Μηχανιώνα', '2', 40.464189, 22.861948, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (134, 'Νεάπολη', '2', 40.653132, 22.941813, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (135, 'Νέοι Επιβάτες', '2', 40.500911, 22.908125, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (136, 'Ξυλόπολη', '2', 40.928137, 23.178234, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (137, 'Πανόραμα', '2', 40.584757, 23.023310, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (138, 'Πολίχνη', '2', 40.660066, 22.954130, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (139, 'Πυλαία', '2', 40.602940, 22.990351, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (140, 'Σίνδος', '2', 40.670744, 22.804742, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (141, 'Σοχός', '2', 40.817885, 23.356698, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (143, 'Σταυρούπολη', '2', 40.668205, 22.935076, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (144, 'Συκιές', '2', 40.648476, 22.956104, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (145, 'Τριανδρία', '2', 40.622455, 22.972691, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (146, 'Χαλάστρα', '2', 40.626950, 22.733502, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (147, 'Χαλκηδόνα', '2', 40.731389, 22.600422, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (148, 'Ωραιόκαστρο', '2', 40.728072, 22.911773, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (149, 'Ναύπλιο', '3', 37.570025, 22.803326, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (150, 'Τρίπολη', '4', 37.511700, 22.372885, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (151, 'Άρτα', '5', 39.159116, 20.987921, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (152, 'Αγρίνιο', '6', 38.624783, 21.408405, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (153, 'Αιτωλικό', '6', 38.436245, 21.353731, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (154, 'Αμφιλοχία', '6', 38.864372, 21.166277, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (155, 'Αντίρριο', '6', 38.331490, 21.763980, 16);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (156, 'Βόνιτσα', '6', 38.916982, 20.889945, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (157, 'Μεσολόγγι', '6', 38.370732, 21.431751, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (158, 'Ναύπακτος', '6', 38.393036, 21.831465, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (159, 'Αίγιο', '7', 38.250988, 22.085695, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (160, 'Πάτρα', '7', 38.246809, 21.737823, 12);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (161, 'Θήβα', '8', 38.322670, 23.319769, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (162, 'Λειβαδιά', '8', 38.438632, 22.876067, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (163, 'Γρεβενά', '9', 40.083457, 21.427460, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (164, 'Δράμα', '10', 41.149125, 24.147863, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (165, 'Ρόδος', '11', 36.436475, 28.223534, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (166, 'Αλεξανδρούπολη', '12', 40.847904, 25.875549, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (167, 'Ορεστιάδα', '12', 41.504142, 26.530008, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (168, 'Χαλκίδα', '13', 38.465552, 23.602753, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (169, 'Ζάκυνθος', '14', 37.780077, 20.897198, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (170, 'Πύργος', '15', 37.672476, 21.443725, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (171, 'Βέροια', '16', 40.522477, 22.204657, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (172, 'Νάουσα', '16', 40.629751, 22.068400, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (173, 'Ηράκλειο', '17', 35.334873, 25.138779, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (174, 'Ηγουμενίτσα', '18', 39.505233, 20.265055, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (175, 'Ιωάννινα', '19', 39.664517, 20.854626, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (176, 'Καβάλα', '20', 40.938156, 24.410934, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (177, 'Καρδίτσα', '21', 39.365094, 21.920471, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (178, 'Καστοριά', '22', 40.519378, 21.267643, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (179, 'Κέρκυρα', '23', 39.623474, 19.912891, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (180, 'Αργοστόλι', '24', 38.172488, 20.490704, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (181, 'Ληξούρι', '24', 38.202070, 20.437360, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (182, 'Κιλκίς', '25', 40.993860, 22.876110, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (183, 'Κοζάνη', '26', 40.301032, 21.791039, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (184, 'Πτολαιμαΐδα', '26', 40.514321, 21.679802, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (185, 'Κόρινθος', '27', 37.937564, 22.932587, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (186, 'Λουτράκι', '27', 37.974786, 22.982669, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (187, 'Σαντορίνη', '28', 36.400836, 25.449142, 12);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (188, 'Μήλος', '28', 36.693750, 24.415054, 12);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (189, 'Μύκονος', '28', 37.446925, 25.338593, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (190, 'Νάξος', '28', 37.104206, 25.404682, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (191, 'Πάρος', '28', 37.103932, 25.211906, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (192, 'Σέριφος', '28', 37.142735, 24.514275, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (193, 'Σίφνος', '28', 36.967175, 24.705849, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (194, 'Σύρος', '28', 37.440519, 24.938879, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (195, 'Τήνος', '28', 37.544169, 25.173111, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (196, 'Σπάρτη', '29', 37.074902, 22.431121, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (197, 'Λάρισα', '30', 39.632267, 22.422752, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (198, 'Μυτιλήνη', '31', 39.098361, 26.555672, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (199, 'Λευκάδα', '32', 38.831818, 20.706482, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (200, 'Βόλος', '33', 39.364895, 22.943916, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (201, 'Καλαμάτα', '34', 37.036818, 22.112989, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (202, 'Ξάνθη', '35', 41.137555, 24.890728, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (203, 'Γιαννιτσά', '36', 40.794123, 22.414427, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (204, 'Έδεσσα', '36', 40.801726, 22.045183, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (205, 'Κατερίνη', '37', 40.271995, 22.512531, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (207, 'Πρέβεζα', '38', 38.958875, 20.752230, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (208, 'Ρέθυμνο', '39', 35.364836, 24.478655, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (209, 'Κομοτηνή', '40', 41.120228, 25.405884, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (210, 'Βαθύ', '41', 37.752428, 26.978517, 15);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (211, 'Σέρρες', '42', 41.087826, 23.548679, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (212, 'Τρίκαλα', '43', 39.555545, 21.769753, 13);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (213, 'Χανιά', '44', 35.511549, 24.022036, 14);
INSERT INTO `city` (`id`, `name`, `area_id`, `center_latitude`, `center_longitude`, `zoom`) VALUES (214, 'Λαμία', '45', 38.896377, 22.437344, 13);

Άβαταρ μέλους
korgr
Honorary Member
Δημοσιεύσεις: 5067
Εγγραφή: 07 Οκτ 2008 18:30
Τοποθεσία: Corinth
Επικοινωνία:

Νομοί και πόλεις τις Ελλάδας + συντεταγμένες

Δημοσίευση από korgr » 23 Απρ 2014 12:12

Δεν με ρώταγες; :)
Έχω στο δικό μου CMS τους νομούς (και 527 καταχωρημένες πόλεις και χωριά) σε ελληνική και αγγλική γλώσσα. Οι συντεταγμένες είναι ακριβείς γιατί έχουν παραχθεί από την εφαρμογή Google Maps του Odyssey CMS.

Άβαταρ μέλους
nirvana
Δημοσιεύσεις: 241
Εγγραφή: 01 Σεπ 2005 18:28
Τοποθεσία: Αγ. Παρασκευή

Νομοί και πόλεις τις Ελλάδας + συντεταγμένες

Δημοσίευση από nirvana » 23 Απρ 2014 12:29

Κριμα. :( Οντως επρεπε να ρωτησω πρωτα..

Ενταξει δεν πειραζει, αν δεν εχεις προβλημα, ανεβασε και την λιστα του cms σου να υπαρχει, μιας και μαλλον ειναι πιο professional η δικη σου λυση :)

Άβαταρ μέλους
korgr
Honorary Member
Δημοσιεύσεις: 5067
Εγγραφή: 07 Οκτ 2008 18:30
Τοποθεσία: Corinth
Επικοινωνία:

Νομοί και πόλεις τις Ελλάδας + συντεταγμένες

Δημοσίευση από korgr » 23 Απρ 2014 12:50

Επειδή είναι πολυγλωσσική η αντιμετώπιση, έχω δύο πίνακες για τους Νομούς και δύο για τις πόλεις, σύνολο 4 πίνακες δηλαδή.
Επειδή θέλουν καθάρισμα από κάποια system mysql fields (active, private, sort, alias), όποιος ενδιαφερθεί μπορεί να κατεβάσει το cms και από phpMyAdmin να πάρει τους 4 πίνακες:
  • cities
    content_cities
    counties
    content_counties
Οι πίνακες με πρόθεμα [ content_ ] περιέχουν τα πολυγλωσσικά περιεχόμενα

Απάντηση

Επιστροφή στο “MySQL”

Μέλη σε σύνδεση

Μέλη σε αυτήν τη Δ. Συζήτηση: Δεν υπάρχουν εγγεγραμμένα μέλη και 0 επισκέπτες