Skip to content

Instantly share code, notes, and snippets.

@jpadilla
Created August 11, 2010 19:40
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jpadilla/519594 to your computer and use it in GitHub Desktop.
Save jpadilla/519594 to your computer and use it in GitHub Desktop.
--
-- Table structure for table `municipalities`
--
CREATE TABLE `municipalities` (
`id` int(2) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`lat` float(8,6) default NULL,
`lng` float(9,6) default NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
--
-- Dumping data for table `municipalities`
--
INSERT INTO `municipalities` (`id`, `name`, `lat`, `lng`) VALUES
(1, 'Adjuntas', 18.162737, -66.722122),
(2, 'Aguada', 18.379391, -67.188232),
(3, 'Aguadilla', 18.379391, -67.188232),
(4, 'Aguas Buenas', 18.256899, -66.102943),
(5, 'Aibonito', 18.139959, -66.265999),
(6, 'Añasco', 18.139959, -66.265999),
(7, 'Arecibo', 18.472445, -66.715729),
(8, 'Arroyo', 17.965799, -66.061279),
(9, 'Barceloneta', 18.450502, -66.538506),
(10, 'Barranquitas', 18.186625, -66.306282),
(11, 'Bayam', 18.177736, -66.113220),
(12, 'Cabo Rojo', 18.086626, -67.145737),
(13, 'Caguas', 18.234121, -66.048500),
(14, 'Camuy', 18.483833, -66.844902),
(15, 'Canovanas', 18.377728, -65.906273),
(16, 'Carolina', 18.380781, -65.957390),
(17, 'Cataño', 18.445414, -66.139427),
(18, 'Cayey', 18.111904, -66.166000),
(19, 'Ceiba', 18.264124, -65.648499),
(20, 'Ciales', 18.336061, -66.468781),
(21, 'Cidra', 18.336061, -66.468781),
(22, 'Coamo', 18.079962, -66.357948),
(23, 'Comerio', 18.219723, -66.224998),
(24, 'Corozal', 18.341063, -66.316833),
(25, 'Culebra', 18.303013, -65.300987),
(26, 'Dorado', 18.458836, -66.267670),
(27, 'Fajardo', 18.325787, -65.652382),
(28, 'Florida', 18.236624, -65.782104),
(29, 'Guánica', 17.953585, -66.927322),
(30, 'Guayama', 17.984133, -66.113777),
(31, 'Guayanilla', 18.019131, -66.791840),
(32, 'Guaynabo', 18.357450, -66.111000),
(33, 'Gurabo', 18.254398, -65.972939),
(34, 'Hatillo', 18.486334, -66.825455),
(35, 'Hormigueros', 18.139681, -67.127403),
(36, 'Humacao', 18.149683, -65.827385),
(37, 'Isabela', 18.500776, -67.024345),
(38, 'Jayuya', 18.218567, -66.591560),
(39, 'Juana Díaz', 18.052500, -66.504440),
(40, 'Juncos', 18.227455, -65.920998),
(41, 'Lajas', 18.049961, -67.059341),
(42, 'Lares', 18.294676, -66.877121),
(43, 'Las Marías', 18.255760, -66.986244),
(44, 'Las Piedras', 18.183014, -65.866272),
(45, 'Loiza', 18.431335, -65.880165),
(46, 'Luquillo', 18.372452, -65.716553),
(47, 'Manati', 18.430958, -66.484245),
(48, 'Maricao', 18.180790, -66.979897),
(49, 'Maunabo', 18.007189, -65.899330),
(50, 'Mayaguez', 18.201389, -67.142776),
(51, 'Moca', 18.394669, -67.113235),
(52, 'Morovis', 18.325785, -66.406563),
(53, 'Naguabo', 18.211624, -65.734886),
(54, 'Naranjito', 18.300785, -66.244888),
(55, 'Orocovis', 18.226900, -66.391006),
(56, 'Patillas', 18.006353, -66.015717),
(57, 'Peñuelas', 18.058332, -66.721107),
(58, 'Ponce', 18.011078, -66.614059),
(59, 'Quebradillas', 18.473833, -66.938515),
(60, 'Rincón', 18.340279, -67.251663),
(61, 'Rio Grande', 18.380278, -65.831390),
(62, 'Sabana Grande', 18.077593, -66.939232),
(63, 'Salinas', 17.977467, -66.297943),
(64, 'San Germán', 18.081627, -67.044899),
(65, 'San Juan', 18.466333, -66.105721),
(66, 'San Lorenzo', 18.189402, -65.960999),
(67, 'San Sebastián', 18.336617, -66.990181),
(68, 'Santa Isabel', 17.966078, -66.404892),
(69, 'Toa Alta', 18.388283, -66.248222),
(70, 'Toa Baja', 18.444344, -66.254814),
(71, 'Trujillo Alto', 18.354671, -66.007385),
(72, 'Utuado', 18.272675, -66.708580),
(73, 'Vega Alta', 18.412170, -66.331284),
(74, 'Vega Baja', 18.444391, -66.387672),
(75, 'Vieques', 18.147463, -65.444878),
(76, 'Villalba', 18.127182, -66.492119),
(77, 'Yabucoa', 18.050520, -65.879326),
(78, 'Yauco', 18.034964, -66.849899);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment