308 lines
33 KiB
JavaScript
308 lines
33 KiB
JavaScript
// add_north_florida.js
|
|
// Agrega directorio marino de Florida Norte al Excel existente
|
|
const xlsx = require('xlsx');
|
|
const path = require('path');
|
|
|
|
const EXCEL_PATH = path.resolve(__dirname, 'Directorio_Marino_FL_Acumulativo_4.xlsx');
|
|
|
|
// Encabezados de columnas
|
|
const HEADERS = ['#', 'NOMBRE', 'DIRECCION', 'TELEFONO', 'EMAIL', 'CIUDAD', 'CONDADO', 'WEBSITE'];
|
|
|
|
// ══════════════════════════════════════════════════════════
|
|
// MARINAS — FLORIDA NORTE
|
|
// ══════════════════════════════════════════════════════════
|
|
const MARINAS = [
|
|
// VOLUSIA
|
|
['Halifax Harbor Marina','450 Basin St, Daytona Beach, FL 32114','(386) 671-3601','halifaxharbormarina@gmail.com','halifaxharbormarina.com','Daytona Beach','Volusia'],
|
|
['Loggerhead Daytona Beach Marina','721 Ballough Rd, Daytona Beach, FL 32114','(386) 523-3100','daytona@equitylifestyle.com','loggerheadmarinas.com','Daytona Beach','Volusia'],
|
|
['Coquina Marina Daytona Beach','841 Ballough Rd, Daytona Beach, FL 32114','(386) 317-0555','coquinamarinas@gmail.com','coquinamarinadaytona.com','Daytona Beach','Volusia'],
|
|
['Halifax River Yacht Club','331 S Beach St, Daytona Beach, FL 32114','(386) 255-7459','hryc@hryc.com','hryc.com','Daytona Beach','Volusia'],
|
|
['Daytona Marina & Boat Works','645 S Beach St, Daytona Beach, FL 32114','(386) 252-6421','dawn645@thedaytonamarina.com','thedaytonamarina.com','Daytona Beach','Volusia'],
|
|
['Loggerhead Inlet Harbor Marina','133 Inlet Harbor Rd, Ponce Inlet, FL 32127','(386) 767-3266','','loggerheadmarinas.com','Ponce Inlet','Volusia'],
|
|
['Sea Love Boat Works & Marina','4877 Front St, Ponce Inlet, FL 32127','(386) 761-5434','sealoveboatworks@gmail.com','sealoveboatworks.com','Ponce Inlet','Volusia'],
|
|
['Lighthouse Boatyard & Marina','4958 S Peninsula Dr, Ponce Inlet, FL 32127','(386) 767-0683','','','Ponce Inlet','Volusia'],
|
|
['Seven Seas Marina & Boatyard','3300 S Peninsula Dr, Port Orange, FL 32127','(386) 761-3221','sevenseasmarina@bellsouth.net','sevenseasmarina.com','Port Orange','Volusia'],
|
|
['Adventure Yacht Harbor','3948 S Peninsula Dr, Port Orange, FL 32127','(386) 756-2180','','adventureyachtharbor.com','Port Orange','Volusia'],
|
|
['New Smyrna Marina','200 Boatyard St, New Smyrna Beach, FL 32169','(386) 427-4514','','newsmyrnamarina.com','New Smyrna Beach','Volusia'],
|
|
['City Marina New Smyrna Beach','201 N Riverside Dr, New Smyrna Beach, FL 32168','(386) 409-2042','','cityofnsb.com','New Smyrna Beach','Volusia'],
|
|
['River Deck Marina','111 N Riverside Dr, New Smyrna Beach, FL 32168','(386) 428-7827','','riverdeckmarina.com','New Smyrna Beach','Volusia'],
|
|
["Gerry's Marina",'179 N Causeway, New Smyrna Beach, FL 32169','(386) 428-2341','','gerrysmarina.net','New Smyrna Beach','Volusia'],
|
|
['Smyrna Yacht Club','1201 S Riverside Dr, New Smyrna Beach, FL 32168','(386) 427-4040','','smyrnayachtclub.com','New Smyrna Beach','Volusia'],
|
|
["Cameron's Marina",'2001 S Riverside Dr, Edgewater, FL 32132','(904) 428-3063','','','Edgewater','Volusia'],
|
|
// FLAGLER
|
|
['Palm Coast Marina','15 Palm Coast Resort Blvd, Palm Coast, FL 32137','(386) 446-6370','','palmcoastmarina.net','Palm Coast','Flagler'],
|
|
['Hammock Beach Marina','102 Yacht Harbor Dr, Palm Coast, FL 32137','(386) 348-3114','info@hammockbeachmarina.com','hammockbeachmarina.com','Palm Coast','Flagler'],
|
|
// INDIAN RIVER
|
|
['Loggerhead Marina Vero Beach','1221 Marina Village Cir, Vero Beach, FL 32967','(772) 770-4470','','loggerheadmarinas.com','Vero Beach','Indian River'],
|
|
['Vero Beach City Marina','3611 Rio Vista Blvd, Vero Beach, FL 32963','(772) 978-4960','','covb.org','Vero Beach','Indian River'],
|
|
['Vero Marine Center','12 Royal Palm Pointe, Vero Beach, FL 32960','(772) 562-7922','','veromarine.com','Vero Beach','Indian River'],
|
|
['Fins Marina','1660 Indian River Dr, Sebastian, FL 32958','(772) 589-4843','info@finsmarina.com','finsmarina.com','Sebastian','Indian River'],
|
|
['Sebastian River Marina & Boatyard','8525 US Hwy 1, Sebastian, FL 32976','(772) 664-3029','d.hillman@sebastian-river-marina.com','marinaharborinmiccofl.com','Sebastian','Indian River'],
|
|
['Sebastian Inlet Marina','8685 US-1, Micco, FL 32976','(772) 664-8500','SIMoffice@mywindward.com','sebastianinletmarina.com','Micco','Indian River'],
|
|
['Treasure Coast Marina','5185 S US-1, Grant, FL 32949','','','','Grant','Indian River'],
|
|
['Vero Beach Yacht Club','3601 Rio Vista Blvd, Vero Beach, FL 32963','','','','Vero Beach','Indian River'],
|
|
// BREVARD - NORTE
|
|
['Titusville Municipal Marina','451 Marina Rd, Titusville, FL 32796','(321) 383-5600','tlawson@f3marina.com','titusvillemarina.com','Titusville','Brevard'],
|
|
['Westland Boatyard and Marina','419 N Washington Ave, Titusville, FL 32796','(321) 267-1667','','westlandmarina.com','Titusville','Brevard'],
|
|
['Kennedy Point Marina & Yacht Club','4749 S Washington Ave, Titusville, FL 32780','(321) 383-0280','','kennedypointmarina.com','Titusville','Brevard'],
|
|
// BREVARD - CENTRO
|
|
['Cape Marina','800 Scallop Dr, Cape Canaveral, FL 32920','(321) 783-8410','dockmaster@capemarina.com','capemarina.com','Cape Canaveral','Brevard'],
|
|
['Sunrise Marina','505 Glen Cheek Dr, Cape Canaveral, FL 32920','(321) 783-9535','','sunrisemarina.com','Cape Canaveral','Brevard'],
|
|
['Ocean Club Marina at Port Canaveral','930 Mullet Rd, Cape Canaveral, FL 32920','(321) 783-9001','info@oceanclubmarina-pc.com','oceanclubmarina-pc.com','Cape Canaveral','Brevard'],
|
|
['Harbortown Marina Canaveral','2700 Harbortown Dr, Merritt Island, FL 32952','(321) 453-0160','info@harbortownmarina.com','harbortownmarina.com','Merritt Island','Brevard'],
|
|
['Marker 24 Marina','1360 S Banana River Dr, Merritt Island, FL 32952','(321) 453-7888','','marker24marina.com','Merritt Island','Brevard'],
|
|
['Cape Crossing Resort & Marina','201 Ivory Coral Ln, Merritt Island, FL 32953','(321) 576-4967','info@capecrossing.com','capecrossing.com','Merritt Island','Brevard'],
|
|
['Cocoa Village Marina','90 Delannoy Ave, Cocoa, FL 32922','(321) 632-5445','cvmarina@cfl.rr.com','cocoavillagemarina.com','Cocoa','Brevard'],
|
|
['Island Time Marina','400 W Cocoa Beach Cswy, Cocoa Beach, FL 32931','(321) 613-4852','','islandtimemarina.com','Cocoa Beach','Brevard'],
|
|
// BREVARD - SUR
|
|
['Anchorage Yacht Basin','96 E Eau Gallie Cswy, Melbourne, FL 32937','(321) 773-3620','','anchorageyachtbasin.com','Melbourne','Brevard'],
|
|
['Melbourne Harbor Marina','2210 Front St #101, Melbourne, FL 32901','(321) 725-9054','info@melbourneharbor.com','melbourneharbor.com','Melbourne','Brevard'],
|
|
['Palm Bay Marina','4350 Dixie Hwy NE, Palm Bay, FL 32905','(321) 723-0851','','palmbaymarina.com','Palm Bay','Brevard'],
|
|
// CITRUS
|
|
['Twin Rivers Marina','2880 N Seabreeze Pt, Crystal River, FL 34429','(352) 795-3552','','twinriversmarina.com','Crystal River','Citrus'],
|
|
["Pete's Pier Marina",'1 SW 1st Pl, Crystal River, FL 34429','(352) 795-3302','','petespier.com','Crystal River','Citrus'],
|
|
['Ozello Keys Marina','2355 S Ripple Path, Crystal River, FL 34429','(352) 228-8095','','ozellokeysmarina.com','Crystal River','Citrus'],
|
|
['Riverhaven Marina','5296 S Riverview Cir, Homosassa, FL 34448','(352) 628-5545','','riverhavenmarina.com','Homosassa','Citrus'],
|
|
['Homosassa Springs Marina','10806 W Halls River Rd, Homosassa, FL 34448','(352) 628-7334','','homosassaspringsmarina.com','Homosassa','Citrus'],
|
|
// LEVY
|
|
['Cedar Key Marina II','12780 State Route 24, Cedar Key, FL 32625','(352) 543-6148','','cedarkeymarina.net','Cedar Key','Levy'],
|
|
['Cedar Key City Marina','Dock St, Cedar Key, FL 32625','(352) 543-5132','cityhall@cedarkeyfl.us','','Cedar Key','Levy'],
|
|
// DIXIE
|
|
['Horseshoe Beach Marina','262 E 3rd St, Horseshoe Beach, FL 32648','(352) 498-5405','','horseshoebeachmarina.com','Horseshoe Beach','Dixie'],
|
|
// TAYLOR
|
|
['Sea Hag Marina','322 S Riverside Dr, Steinhatchee, FL 32359','(352) 498-3008','','seahag.com','Steinhatchee','Taylor'],
|
|
['Steinhatchee River Inn & Marina','1111 Riverside Dr SE, Steinhatchee, FL 32359','(352) 498-4049','','riverinnandmarina.com','Steinhatchee','Taylor'],
|
|
['Steinhatchee River Haven Marina','1110 Riverside Drive, Steinhatchee, FL 32359','(352) 498-0709','riverhaven@bellsouth.net','riverhavenmarinaandmotel.com','Steinhatchee','Taylor'],
|
|
['Shelter Cove Marina','412 S Riverside Dr, Steinhatchee, FL 32359','(352) 210-1781','','sheltercovemarina.net','Steinhatchee','Taylor'],
|
|
['Good Times Motel and Marina','7022 SW Hwy 358, Steinhatchee, FL 32359','(352) 498-8088','','goodtimesmotelandmarina.com','Steinhatchee','Taylor'],
|
|
['Steinhatchee Landing Resort','203 Ryland Circle, Steinhatchee, FL 32359','(352) 498-0696','','steinhatcheelanding.com','Steinhatchee','Taylor'],
|
|
['Keaton Beach Marina & Motel','20650 Keaton Beach Dr, Perry, FL 32348','(850) 578-2897','','','Perry','Taylor'],
|
|
['Steinhatchee Marina at Deadman Bay','104 First Ave SW, Steinhatchee, FL 32359','(352) 578-1900','','shrmarina.com','Steinhatchee','Taylor'],
|
|
// WAKULLA
|
|
['Shell Point Harbor Marina','85 Harbour Point Dr, Crawfordville, FL 32327','(850) 544-5658','Accounting@shellpointharbormarina.com','shellpointharbormarina.com','Crawfordville','Wakulla'],
|
|
['Shields Marina','95 Riverside Dr, St. Marks, FL 32355','(850) 925-6158','info@shieldsmarina.com','shieldsmarina.com','St. Marks','Wakulla'],
|
|
['Rock Landing Marina','91 Rock Landing Rd, Panacea, FL 32346','(850) 984-5844','','rocklandingmarina.com','Panacea','Wakulla'],
|
|
// FRANKLIN
|
|
['Scipio Creek Marina','301 Market St, Apalachicola, FL 32320','(850) 653-8030','','scipiocreekmarina.com','Apalachicola','Franklin'],
|
|
['Water Street Hotel & Marina','329 Water St, Apalachicola, FL 32320','(850) 502-5134','','waterstreethotel.com','Apalachicola','Franklin'],
|
|
['Battery Park Marina','1 Bay Avenue, Apalachicola, FL 32320','(850) 653-9319','','','Apalachicola','Franklin'],
|
|
['Deep Water Marina','329 Water St, Apalachicola, FL 32320','(850) 653-8801','','','Apalachicola','Franklin'],
|
|
['Rainbow Inn & Marina','123 Water Street, Apalachicola, FL 32320','(850) 653-8139','','','Apalachicola','Franklin'],
|
|
['Sportsmans Lodge Marina','99 North Bayshore Dr, Eastpoint, FL 32328','(850) 670-8423','','','Eastpoint','Franklin'],
|
|
['The Moorings of Carrabelle','1000 Avenue A North, Carrabelle, FL 32322','','','themooringsofcarrabelle.com','Carrabelle','Franklin'],
|
|
['C-Quarters Marina','501 St James Ave Hwy 98, Carrabelle, FL 32322','(850) 697-8400','','c-quartersmarina.com','Carrabelle','Franklin'],
|
|
["Johnson's Carrabelle Marina",'803 NW Avenue A, Carrabelle, FL 32322','(850) 510-4196','','carrabelle-marina.com','Carrabelle','Franklin'],
|
|
['Carrabelle Boat Club','1570 Hwy 98 W, Carrabelle, FL 32322','(850) 697-5500','info@carrabelleboatclub.com','carrabelleboatclub.com','Carrabelle','Franklin'],
|
|
["Pirate's Cove Carrabelle Marina",'275 Timber Island Rd, Carrabelle, FL 32322','(850) 756-8144','','','Carrabelle','Franklin'],
|
|
['MS Dockside Marina & Boatyard','292 Graham Dr, Carrabelle, FL 32322','(850) 697-3337','msdocksidemarina@gmail.com','msdockside.com','Carrabelle','Franklin'],
|
|
// GULF
|
|
['Point South Marina - Port St. Joe','340 Marina Drive, Port St Joe, FL 32456','(850) 460-9780','info.portstjoe@pointsouthmarina.com','pointsouthmarinaportstjoe.com','Port St. Joe','Gulf'],
|
|
["Captain's Cove Marina",'1646 Captain Carl Raffield Way, Port St Joe, FL 32456','(850) 227-3357','captaincove@yahoo.com','captainscovefl.com','Port St. Joe','Gulf'],
|
|
// BAY
|
|
['Point South Marina - Bay Point','3824 Hatteras Ln, Panama City Beach, FL 32408','(850) 235-6911','BayPointMarina@StJoe.com','pointsouthmarinabaypoint.com','Panama City Beach','Bay'],
|
|
['Bayside Marina','6325 Big Daddy Drive, Panama City Beach, FL 32407','(850) 234-7650','','bluegatemarinas.com','Panama City Beach','Bay'],
|
|
['MarineMax Panama City Beach','3605 Thomas Dr, Panama City Beach, FL 32408','(850) 708-1317','','marinemax.com','Panama City Beach','Bay'],
|
|
["Capt. Anderson's Marina",'5550 N Lagoon Dr, Panama City, FL 32408','(850) 234-3435','captandersonsmktg@aol.com','captandersonsmarina.com','Panama City','Bay'],
|
|
['Treasure Island Marina','3605 Thomas Dr, Panama City Beach, FL 32408','(850) 234-6533','','treasureislandmarina.net','Panama City Beach','Bay'],
|
|
['St. Andrews Marina','3151 W 10th St, Panama City, FL 32401','(850) 872-7240','','','Panama City','Bay'],
|
|
["Pirate's Cove Marina PCB",'3901 Thomas Dr, Panama City Beach, FL 32408','(850) 234-3939','','piratescovemarinapcb.com','Panama City Beach','Bay'],
|
|
// WALTON
|
|
["Tom's Landing Marina",'78 Ricker Ave, Santa Rosa Beach, FL','(850) 496-2741','tomslanding@gmail.com','tomslandingsrb.com','Santa Rosa Beach','Walton'],
|
|
['Shipyard Marina Freeport','116 Shipyard Rd, Freeport, FL','(850) 880-2324','info@shipyardmarinafreeport.com','shipyardmarinafreeport.com','Freeport','Walton'],
|
|
// OKALOOSA
|
|
['HarborWalk Marina','66 Harbor Blvd, Destin, FL','(850) 650-2400','','harborwalkmarina.net','Destin','Okaloosa'],
|
|
['Fort Walton Beach Yacht Basin','104 Miracle Strip Pkwy SW, Fort Walton Beach, FL','(850) 244-5725','info@fwbyachtbasin.com','fwbyachtbasin.com','Fort Walton Beach','Okaloosa'],
|
|
['Adventure Marina','1201-B Miracle Strip Pkwy SE, Fort Walton Beach, FL','(850) 581-2628','','adventuremarina.com','Fort Walton Beach','Okaloosa'],
|
|
['Sunset Isle Yacht Club','1350 Miracle Strip Pkwy SE, Fort Walton Beach, FL','(850) 500-2628','','sunsetisle.com','Fort Walton Beach','Okaloosa'],
|
|
// SANTA ROSA
|
|
['Santa Rosa Yacht & Boat Club','300 Pensacola Beach Rd, Gulf Breeze, FL','(850) 934-1005','','santarosayachtclub.com','Gulf Breeze','Santa Rosa'],
|
|
['Milton Marina','Quinn Street, Milton, FL 32570','(850) 983-5466','parksandrec@miltonfl.org','miltonfl.org','Milton','Santa Rosa'],
|
|
['Marquis Bayou Marina','7001 Old Spanish Trail, Milton, FL 32583','(850) 266-7728','','marquisbayou.com','Milton','Santa Rosa'],
|
|
['East River Smokehouse Marina','8491 Navarre Pkwy, Navarre, FL 32566','(850) 939-2802','','eastriversmokehouse.com','Navarre','Santa Rosa'],
|
|
['Bluewater Bay Marina','290 Yacht Club Drive, Niceville, FL 32578','','','bluewaterbaymarina.com','Niceville','Santa Rosa'],
|
|
// ESCAMBIA
|
|
['Southwind Marina','10121 Sinton Dr, Pensacola, FL 32502','(850) 619-6348','gmsouthwind@gmail.com','southwindmarina.com','Pensacola','Escambia'],
|
|
['Palafox Pier Yacht Harbor Marina','997 S Palafox St, Pensacola, FL 32502','(850) 432-9620','','','Pensacola','Escambia'],
|
|
['Day Break Marina','811 South R Street, Pensacola, FL 32502','(850) 434-9022','','daybreakmarina.com','Pensacola','Escambia'],
|
|
['Chico Marina','3009 Barrancas Ave, Pensacola, FL 32507','(850) 453-8863','','','Pensacola','Escambia'],
|
|
["Mac's Marina",'31 Newman Avenue, Pensacola, FL 32507','(850) 453-3775','','macsmarinafl.com','Pensacola','Escambia'],
|
|
['MarineMax Pensacola','1901 Cypress St, Pensacola, FL 32502','(850) 477-1112','','marinemax.com','Pensacola','Escambia'],
|
|
['Island Cove Marina','806 Lakewood Rd, Pensacola, FL 32507','(850) 455-4552','office@segersmarine.com','segersmarine.com','Pensacola','Escambia'],
|
|
['Rod & Reel Marina','10045 Sinton Dr, Pensacola, FL 32502','(850) 492-0100','','','Pensacola','Escambia'],
|
|
['Pensacola Beach Marina','655 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 932-8466','','pensacolabeachmarina.com','Pensacola Beach','Escambia'],
|
|
['Sabine Marina','715 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 932-1904','','sabinemarina.com','Pensacola Beach','Escambia'],
|
|
['Pier One Marina','655 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 781-4180','','pieronemarina.com','Pensacola Beach','Escambia'],
|
|
['Holiday Harbor Marina','14050 Canal-A-Way, Pensacola, FL 32507','(850) 492-0555','office@myholidayharbor.com','myholidayharbor.com','Pensacola','Escambia'],
|
|
// DUVAL
|
|
['Port 32 Jacksonville','4234 Lakeside Dr, Jacksonville, FL 32210','(904) 387-5538','','port32marinas.com','Jacksonville','Duval'],
|
|
['Ortega River Marina','4585 Lakeside Dr, Jacksonville, FL 32210','(904) 389-1199','ortegarivermarina@gmail.com','ortegarivermarinajax.com','Jacksonville','Duval'],
|
|
['Sadler Point Marina','4599 Lakeside Dr, Jacksonville, FL 32210','(904) 384-1383','brooks@sadlerpoint.com','sadlerpointmarina.com','Jacksonville','Duval'],
|
|
['Lakeshore Marine Center','3326 Lakeshore Blvd, Jacksonville, FL 32210','(904) 384-6447','info@lakeshoremarinecenter.com','lakeshoremarinecenter.com','Jacksonville','Duval'],
|
|
['Arlington Marina','5137 Arlington Rd, Jacksonville, FL 32211','(904) 743-2628','info@arlingtonmarina.com','arlingtonmarina.com','Jacksonville','Duval'],
|
|
['Seafarers Marina','455 Trout River Dr, Jacksonville, FL 32208','(904) 765-8152','seafarersmarina@aol.com','seafarersmarina.com','Jacksonville','Duval'],
|
|
['HarborTown Marina Jacksonville','13846 Atlantic Blvd, Jacksonville, FL 32225','(904) 220-3600','','jaxharbortownmarina.com','Jacksonville','Duval'],
|
|
['Julington Creek Marina','12807 San Jose Blvd, Jacksonville, FL 32223','(904) 268-5117','julingtoncreekmarina@outlook.com','marinaatjulingtoncreek.com','Jacksonville','Duval'],
|
|
['Palm Cove Marina','14603 Beach Blvd Ste 100, Jacksonville, FL 32250','(904) 223-4757','','palmcovemarina.com','Jacksonville','Duval'],
|
|
['Fort George Island Marina','9954 Heckscher Dr, Jacksonville, FL 32226','(904) 251-0050','','fortgeorgeislandmarina.com','Jacksonville','Duval'],
|
|
["Lamb's Yacht Center",'3376 Lake Shore Blvd, Jacksonville, FL 32210','(904) 327-2285','','lambsyachtcenter.com','Jacksonville','Duval'],
|
|
['Beach Marine','2315 Beach Blvd, Jacksonville Beach, FL 32250','(904) 249-8200','','jaxbeachmarine.com','Jacksonville Beach','Duval'],
|
|
['Morningstar Marinas Mayport','4852 Ocean St, Atlantic Beach, FL 32233','(904) 236-6210','','morningstarmarinas.com','Atlantic Beach','Duval'],
|
|
// ST. JOHNS
|
|
['St. Augustine Municipal Marina','111 Avenida Menendez, St. Augustine, FL 32084','(904) 825-1026','marina@citystaug.com','citystaug.com','St. Augustine','St. Johns'],
|
|
['Camachee Cove Yacht Harbor','3070 Harbor Dr, St. Augustine, FL 32084','(904) 829-5676','CCYHoffice@MyWindward.com','camacheeisland.com','St. Augustine','St. Johns'],
|
|
['The Conch House Marina Resort','57 Comares Ave, St. Augustine, FL 32080','(904) 824-4347','info@conchhousemarinaresort.com','conchhousemarinaresort.com','St. Augustine','St. Johns'],
|
|
['English Landing Marina','509 S Ponce de Leon Blvd, St. Augustine, FL 32084','(904) 669-7363','info@englishlandingmarina.com','englishlandingmarina.com','St. Augustine','St. Johns'],
|
|
["Cat's Paw Marina",'220 Nix Boat Yard Rd, St. Augustine, FL 32084','(904) 829-8040','Info@CatsPawMarina.com','catspawmarina.com','St. Augustine','St. Johns'],
|
|
['Oasis Boatyard & Marina','256 Riberia St, St. Augustine, FL 32084','(904) 824-2520','','oasisboatyardandmarina.com','St. Augustine','St. Johns'],
|
|
// NASSAU
|
|
['Fernandina Harbor Marina','3 S Front St, Fernandina Beach, FL 32034','(904) 310-3300','fernandinaharbor@alliancemarine.co','fernandinaharbormarina.com','Fernandina Beach','Nassau'],
|
|
['Amelia Island Marina','251 Creekside Dr, Fernandina Beach, FL 32034','(904) 277-4615','ameliaisland@suntex.com','ameliaislandmarina.com','Fernandina Beach','Nassau'],
|
|
['Olde Towne Marina','1420 N 14th St, Fernandina Beach, FL 32034','(904) 277-8511','oldetownemarina@bellsouth.net','oldetownemarina.com','Fernandina Beach','Nassau'],
|
|
];
|
|
|
|
// ══════════════════════════════════════════════════════════
|
|
// ASTILLEROS — FLORIDA NORTE
|
|
// ══════════════════════════════════════════════════════════
|
|
const ASTILLEROS = [
|
|
['Daytona Marina & Boat Works','645 S Beach St, Daytona Beach, FL 32114','(386) 252-6421','dawn645@thedaytonamarina.com','thedaytonamarina.com','Daytona Beach','Volusia'],
|
|
['Sea Love Boat Works','4877 Front St, Ponce Inlet, FL 32127','(386) 761-5434','sealoveboatworks@gmail.com','sealoveboatworks.com','Ponce Inlet','Volusia'],
|
|
['Lighthouse Boatyard','4958 S Peninsula Dr, Ponce Inlet, FL 32127','(386) 767-0683','','','Ponce Inlet','Volusia'],
|
|
['Seven Seas Marina & Boatyard','3300 S Peninsula Dr, Port Orange, FL 32127','(386) 761-3221','sevenseasmarina@bellsouth.net','sevenseasmarina.com','Port Orange','Volusia'],
|
|
['Westland Boatyard and Marina','419 N Washington Ave, Titusville, FL 32796','(321) 267-1667','','westlandmarina.com','Titusville','Brevard'],
|
|
['Port Canaveral Marine','960 Mullet Rd, Cape Canaveral, FL 32920','(321) 799-9444','','portcanaveralmarine.com','Cape Canaveral','Brevard'],
|
|
['Anchorage Yacht Basin','96 E Eau Gallie Cswy, Melbourne, FL 32937','(321) 773-3620','','anchorageyachtbasin.com','Melbourne','Brevard'],
|
|
['Sebastian River Marina & Boatyard','8525 US Hwy 1, Sebastian, FL 32976','(772) 664-3029','d.hillman@sebastian-river-marina.com','','Sebastian','Indian River'],
|
|
['Crystal River Marine Inc.','990 N Suncoast Blvd, Crystal River, FL 34429','(352) 795-2597','','crystalrivermarine.com','Crystal River','Citrus'],
|
|
['Three Rivers Marine','1038 N Suncoast Blvd, Crystal River, FL 34429','(352) 563-5510','sales@threeriversmarineinc.com','threeriversmarineinc.com','Crystal River','Citrus'],
|
|
['MS Dockside Marina & Boatyard','292 Graham Dr, Carrabelle, FL 32322','(850) 697-3337','msdocksidemarina@gmail.com','msdockside.com','Carrabelle','Franklin'],
|
|
['Eastern Shipbuilding Group','432 Howard Road, Port St. Joe, FL 32456','(850) 763-1900','','easternshipbuilding.com','Port St. Joe','Gulf'],
|
|
['Bay County Boatyard','101 N Church Ave, Panama City, FL 32401','(850) 215-9283','','baycountyboatyard.com','Panama City','Bay'],
|
|
['Panhandle Marina & Boatyard','101 N Church Ave, Panama City, FL 32401','(850) 481-0556','info@panboatyard.com','panboatyard.com','Panama City','Bay'],
|
|
['Marker 21 Boatyard & Marina','36 Miracle Strip Pkwy SW, Fort Walton Beach, FL','(850) 244-2722','markertwentyonemarina@gmail.com','marker21boatyardandmarina.com','Fort Walton Beach','Okaloosa'],
|
|
['Coastal Marine Works','2816 Gulf Breeze Pkwy, Gulf Breeze, FL','(850) 637-9585','','coastalmarineworks.com','Gulf Breeze','Santa Rosa'],
|
|
['Pensacola Marine Center','700 S Myrick St, Pensacola, FL 32501','(850) 439-1451','bob@pensacolamarinecenter.com','pensacolamarinecenter.com','Pensacola','Escambia'],
|
|
["Pelican's Perch Marina and Boatyard",'40 Audusson Ave, Pensacola, FL 32507','(850) 453-3471','','pelicansperchmarina.com','Pensacola','Escambia'],
|
|
['Huckins Yacht Corporation','3482 Lake Shore Blvd, Jacksonville, FL 32210','(904) 389-1125','service@huckinsyacht.com','huckinsyacht.com','Jacksonville','Duval'],
|
|
['Sadler Point Marine Center','4599 Lakeside Dr, Jacksonville, FL 32210','(904) 384-1383','brooks@sadlerpoint.com','sadlerpointmarina.com','Jacksonville','Duval'],
|
|
['Atlantic Coast Marine','13748 Atlantic Blvd, Jacksonville, FL 32225','(904) 221-0793','','atlanticcoastmarine.com','Jacksonville','Duval'],
|
|
['St. Augustine Marine Center','404 S Riberia St, St. Augustine, FL 32084','(904) 824-4394','','staugustinemarine.com','St. Augustine','St. Johns'],
|
|
['St. Augustine Shipyard','117 Dockside Dr, St. Augustine, FL 32084','','','camacheeyachtyard.com','St. Augustine','St. Johns'],
|
|
['Tiger Point Marina & Boat Works','997 Egans Creek Ln, Fernandina Beach, FL 32034','(904) 277-2720','tigerpointmarina@comcast.net','tigerpointmarina.biz','Fernandina Beach','Nassau'],
|
|
];
|
|
|
|
// ══════════════════════════════════════════════════════════
|
|
// ALMACENAMIENTO — FLORIDA NORTE
|
|
// ══════════════════════════════════════════════════════════
|
|
const ALMACENAMIENTO = [
|
|
['All Aboard Storage - Ormond Beach','305 W Granada Blvd, Ormond Beach, FL','(386) 333-6801','','allaboardstorage.com','Ormond Beach','Volusia'],
|
|
['Stor-It Boat & RV - Ormond Beach','99 Portland St, Ormond Beach, FL','(386) 676-5018','','storitboatandrv.com','Ormond Beach','Volusia'],
|
|
['Barracuda Boat & RV Storage','412 W Park Ave, Edgewater, FL','(386) 847-8112','info@boatrvstorage.com','boatrvstorage.com','Edgewater','Volusia'],
|
|
['RecNation RV & Boat Storage - Edgewater','403 Timaquan Trail, Edgewater, FL','(386) 433-8698','','recnationstorage.com','Edgewater','Volusia'],
|
|
['All Aboard Storage - Daytona Beach','1325 S Nova Road, Daytona Beach, FL','(386) 200-9442','','allaboardstorage.com','Daytona Beach','Volusia'],
|
|
['All Aboard Storage - Palm Coast','6372 SR 100 East, Palm Coast, FL','(386) 388-7739','','allaboardstorage.com','Palm Coast','Flagler'],
|
|
['Stor-It of Flagler County','3700 E Moody Blvd, Bunnell, FL','(386) 263-3067','','storitofflaglercounty.com','Bunnell','Flagler'],
|
|
['Sebastian Inlet Marina Dry Storage','8685 US-1, Micco, FL 32976','(772) 664-8500','SIMoffice@mywindward.com','sebastianinletmarina.com','Micco','Indian River'],
|
|
['Mr. Stor-It Merritt Island','500 Cone Rd, Merritt Island, FL 32952','(321) 453-3400','','mrstorit.com','Merritt Island','Brevard'],
|
|
['Crystal River Boat and RV Storage','S Suncoast Blvd, Crystal River, FL','','','crystalriverboatrvstorage.com','Crystal River','Citrus'],
|
|
['Wakulla Station RV & Boat Storage','Crawfordville, FL','','','wakullastationrvandboatstorage.com','Crawfordville','Wakulla'],
|
|
['Storage by the Sea','Navarre, FL','(850) 374-1648','','','Navarre','Santa Rosa'],
|
|
['East Bay Boat & RV Storage','Navarre, FL','(850) 939-9040','','','Navarre','Santa Rosa'],
|
|
['Old River Boat Storage','4837 Ocean St, Atlantic Beach, FL 32233','(904) 874-4132','oldriverboatstorage@gmail.com','oldriverboatstorage.com','Atlantic Beach','Duval'],
|
|
["Solomon's RV & Boat Storage",'14255 Beach Blvd, Jacksonville, FL 32250','(904) 223-0888','','solomons.net','Jacksonville','Duval'],
|
|
["Captain's Cove Dry Stack Storage",'1646 Captain Carl Raffield Way, Port St Joe, FL','(850) 227-3357','info@captainscovefl.com','captainscovefl.com','Port St. Joe','Gulf'],
|
|
];
|
|
|
|
// ══════════════════════════════════════════════════════════
|
|
// SUMINISTROS — FLORIDA NORTE
|
|
// ══════════════════════════════════════════════════════════
|
|
const SUMINISTROS = [
|
|
['West Marine - Daytona Beach','1300 W International Speedway Blvd, Daytona Beach, FL','(386) 255-2013','','westmarine.com','Daytona Beach','Volusia'],
|
|
['Aloha Marine Center','1700 N Nova Rd, Holly Hill, FL','(386) 255-2345','','alohamarine.com','Holly Hill','Volusia'],
|
|
['Bluewater Marine Daytona','730 Ridgewood Ave, Holly Hill, FL','(386) 255-7790','','bluewatermarine.com','Holly Hill','Volusia'],
|
|
['Atlantic Marine Port Orange','520 Dunlawton Ave, Port Orange, FL','(386) 788-1644','robert@atlanticmarinefl.com','atlanticmarinefl.com','Port Orange','Volusia'],
|
|
['North Causeway Marine','4 N Causeway, New Smyrna Beach, FL','(386) 427-5267','','northcausewaymarine.com','New Smyrna Beach','Volusia'],
|
|
['West Marine Palm Coast','250 Palm Coast Pkwy NE, Palm Coast, FL','(386) 276-7001','','westmarine.com','Palm Coast','Flagler'],
|
|
['Carp Coastal Marine & RV','4550 S US Hwy 1, Grant, FL','(321) 952-1303','carpcoastalmarine@carpindustries.com','carpcoastalmarine.com','Grant','Indian River'],
|
|
['Vero Marine Center','12 Royal Palm Pointe, Vero Beach, FL','(772) 562-7922','','veromarine.com','Vero Beach','Indian River'],
|
|
['West Marine West Melbourne','1001 W New Haven Ave, West Melbourne, FL','(321) 837-1113','','westmarine.com','West Melbourne','Brevard'],
|
|
['MarineMax Cocoa','1410 King St, Cocoa, FL 32922','(321) 636-3142','','marinemax.com','Cocoa','Brevard'],
|
|
['Boaters Exchange','2145 US-1, Rockledge, FL','(321) 638-0090','','boatersexchange.com','Rockledge','Brevard'],
|
|
['West Marine Crystal River','160 SE Hwy 19, Crystal River, FL','(352) 563-0003','','westmarine.com','Crystal River','Citrus'],
|
|
["Nobles' Marine Crystal River",'1931 NW Highway 19, Crystal River, FL','(352) 329-3739','','noblesmarine.com','Crystal River','Citrus'],
|
|
['Homosassa Marine','3120 S Suncoast Blvd, Homosassa, FL 34448','(352) 628-2991','','homosassamarine.com','Homosassa','Citrus'],
|
|
['Marina Hardware at Cedar Key','409 1st St, Cedar Key, FL','(352) 543-5804','','marinahardwarecedarkey.com','Cedar Key','Levy'],
|
|
['RMS Marine Supply','3026 Coastal Hwy, Crawfordville, FL','(850) 926-3114','','rmsmarinesupply.com','Crawfordville','Wakulla'],
|
|
['West Marine Panama City','427 E 23rd St, Panama City, FL','(850) 763-6104','','westmarine.com','Panama City','Bay'],
|
|
['West Marine Panama City Beach','2225 Thomas Dr, Panama City Beach, FL','(850) 234-7699','','westmarine.com','Panama City Beach','Bay'],
|
|
['Miller Marine Inc','7141 Grassy Point Rd, Panama City, FL','(850) 265-6768','','millermarineinc.net','Panama City','Bay'],
|
|
["Howell Marine & Tackle Supply",'3100 W Highway 98, Panama City, FL','(850) 785-8548','','howelltacklesupply.com','Panama City','Bay'],
|
|
['West Marine Destin','862-B Hwy 98 East, Destin, FL','','','westmarine.com','Destin','Okaloosa'],
|
|
['The Ships Chandler - Destin','646 Harbor Blvd, Destin, FL','(850) 837-2262','','theshipschandler.com','Destin','Okaloosa'],
|
|
['The Ships Chandler - Freeport','17309 Highway 331, Freeport, FL','(850) 880-6259','','theshipschandler.com','Freeport','Walton'],
|
|
['Emerald Coast Marine Group','115 W John Sims Pkwy, Niceville, FL','(850) 389-8318','','emeraldcoastmarine.com','Niceville','Okaloosa'],
|
|
['Gulf Breeze Marine','2933 Gulf Breeze Pkwy, Gulf Breeze, FL','(850) 932-1556','gbmarineshop@outlook.com','gulfbreezemarine.com','Gulf Breeze','Santa Rosa'],
|
|
['West Marine Pensacola','5303 N Davis Hwy, Pensacola, FL','(850) 483-5523','','westmarine.com','Pensacola','Escambia'],
|
|
['BGS Marine Sales & Service','3910 W Navy Blvd, Pensacola, FL','(850) 438-5934','sales@bgsmarinesales.com','bgsmarinesales.com','Pensacola','Escambia'],
|
|
['Perdido Marine Supply','12490 Gulf Beach Hwy, Pensacola, FL','(850) 361-1191','','perdidotradingcompany.com','Pensacola','Escambia'],
|
|
['Gulf Coast Marine Supply','7885 Pensacola Blvd, Pensacola, FL','(850) 476-4910','','gulfcoastmarine.com','Pensacola','Escambia'],
|
|
['West Marine Jacksonville','4874 Big Island Dr, Jacksonville, FL','(904) 520-4650','','westmarine.com','Jacksonville','Duval'],
|
|
['West Marine Jacksonville Beach','14180 Beach Blvd, Jacksonville, FL','(904) 821-5033','','westmarine.com','Jacksonville Beach','Duval'],
|
|
['Specialty Marine & Industrial Supplies','1420 Mayport Rd, Atlantic Beach, FL','(904) 247-3303','','specialtymarinefl.com','Atlantic Beach','Duval'],
|
|
['Main Street Marine','9211 N Main St, Jacksonville, FL','(904) 757-3100','','mainstmarine.com','Jacksonville','Duval'],
|
|
['MarineMax Jacksonville','2079 Beach Blvd, Jacksonville Beach, FL','(904) 338-9970','','marinemax.com','Jacksonville Beach','Duval'],
|
|
['Ocean Outboard Marine','1619 N 14th St, Fernandina Beach, FL','(904) 321-1422','','oceanoutboardmarine.com','Fernandina Beach','Nassau'],
|
|
['Chelsea Boat Center','96114 David Hallman Pkwy, Yulee, FL','(904) 261-8884','','chelseamarinesupply.com','Yulee','Nassau'],
|
|
];
|
|
|
|
function buildSheet(data, sheetTitle) {
|
|
const rows = [[sheetTitle]];
|
|
rows.push(HEADERS);
|
|
data.forEach((row, i) => {
|
|
rows.push([i + 1, ...row]);
|
|
});
|
|
return xlsx.utils.aoa_to_sheet(rows);
|
|
}
|
|
|
|
function main() {
|
|
console.log('Leyendo Excel...');
|
|
const wb = xlsx.readFile(EXCEL_PATH);
|
|
|
|
// Crear hojas nuevas para Florida Norte
|
|
const sheets = [
|
|
{ name: 'MARINAS_NORTE', data: MARINAS, title: 'Marinas — Florida Norte (Sesión 6)' },
|
|
{ name: 'ASTILLEROS_NORTE', data: ASTILLEROS, title: 'Astilleros — Florida Norte (Sesión 6)' },
|
|
{ name: 'ALMACENAMIENTO_NORTE', data: ALMACENAMIENTO, title: 'Almacenamiento — Florida Norte (Sesión 6)' },
|
|
{ name: 'SUMINISTROS_NORTE', data: SUMINISTROS, title: 'Suministros — Florida Norte (Sesión 6)' },
|
|
];
|
|
|
|
for (const s of sheets) {
|
|
if (wb.SheetNames.includes(s.name)) {
|
|
wb.SheetNames.splice(wb.SheetNames.indexOf(s.name), 1);
|
|
}
|
|
wb.Sheets[s.name] = buildSheet(s.data, s.title);
|
|
wb.SheetNames.push(s.name);
|
|
console.log(` ✅ ${s.name}: ${s.data.length} registros`);
|
|
}
|
|
|
|
// Actualizar RESUMEN
|
|
const resWs = wb.Sheets['RESUMEN'];
|
|
const resData = xlsx.utils.sheet_to_json(resWs, { header: 1 });
|
|
// Agregar fila de totales norte FL
|
|
resData.push(['Florida Norte', MARINAS.length, '-', '-', '-', '-', MARINAS.length, 'MARINAS_NORTE']);
|
|
resData.push(['FL Norte Astilleros', '-', '-', '-', '-', '-', ASTILLEROS.length, 'ASTILLEROS_NORTE']);
|
|
resData.push(['FL Norte Almacenamiento', '-', '-', '-', '-', '-', ALMACENAMIENTO.length, 'ALMACENAMIENTO_NORTE']);
|
|
resData.push(['FL Norte Suministros', '-', '-', '-', '-', '-', SUMINISTROS.length, 'SUMINISTROS_NORTE']);
|
|
wb.Sheets['RESUMEN'] = xlsx.utils.aoa_to_sheet(resData);
|
|
|
|
xlsx.writeFile(wb, EXCEL_PATH);
|
|
console.log(`\n🎉 Guardado exitosamente en: ${EXCEL_PATH}`);
|
|
console.log(`\n📊 RESUMEN TOTAL:`);
|
|
console.log(` Marinas Norte FL: ${MARINAS.length}`);
|
|
console.log(` Astilleros Norte FL: ${ASTILLEROS.length}`);
|
|
console.log(` Almacenamiento Norte FL: ${ALMACENAMIENTO.length}`);
|
|
console.log(` Suministros Norte FL: ${SUMINISTROS.length}`);
|
|
console.log(` TOTAL NORTE FL: ${MARINAS.length + ASTILLEROS.length + ALMACENAMIENTO.length + SUMINISTROS.length}`);
|
|
}
|
|
|
|
main();
|