search

davidramos010 / adminkey

adminkey
BSD 3-Clause "New" or "Revised" License
2 stars 0 forks source link

Actualizar codigos de comunidades #18

Closed davidramos010 closed 1 year ago

davidramos010 commented 2 years ago

Actualizar codigos de comunidades segun el doc de Fernando

davidramos010 commented 1 year ago

INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (10,1,'H17277468','BELLAVISTA V','17230','PALAMOS','C. MOSSEN GASPAR BOSCH, 36',NULL,NULL,NULL,'C1',NULL,1,'2022-09-11 22:52:04'), (11,1,'H17904509','CAL CARRETER','17230','PALAMOS','C. LOPEZ PUIGCERVER 154',NULL,NULL,NULL,'C2',NULL,1,'2022-09-11 22:52:04'), (12,1,'H17302944','DORADA','17251','CALONGE I SANT ANTONI','C. LLEVANTINA DE MAR',NULL,NULL,NULL,'C3',NULL,1,'2022-09-11 22:52:04'), (13,1,'H17299223','LEONARDO DA VINCI','17252','CALONGE I SANT ANTONI','AV DE LA CERDANYA, 8',NULL,NULL,NULL,'C4',NULL,1,'2022-09-11 22:52:04'), (14,1,'H17254103','ISABEL','17230','PALAMOS','C. ROSELLÓ 3',NULL,NULL,NULL,'C5',NULL,1,'2022-09-11 22:52:04'), (15,1,'H17277385','MIRALTA','17248','S-AGARÓ','URB. LA GRAMOIA D-EN PUIG',NULL,NULL,NULL,'C6',NULL,1,'2022-09-11 22:52:04'), (16,1,'H17302894','ATENEA','17230','PALAMOS','C. INDUSTRIA, 27-29-31',NULL,NULL,NULL,'C7',NULL,1,'2022-09-11 22:52:04'), (17,1,'H17273400','BELLAVISTA IV','17230','PALAMOS','C. MOSSEN G. BOSCH, 40',NULL,NULL,NULL,'C8',NULL,1,'2022-09-11 22:52:04'), (18,1,'H17690579','VALENTINA PARK','17252','CALONGE I SANT ANTONI','c. CONRAD VILAR, 9',NULL,NULL,NULL,'C9',NULL,1,'2022-09-11 22:52:04'), (19,1,'H17321084','RAFAELLO','17252','CALONGE I SANT ANTONI','AV. DE LA CERDANYA, 10',NULL,NULL,NULL,'C10',NULL,1,'2022-09-11 22:52:04'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (20,1,'E17125683','PORT BLAU','17230','PALAMOS','c. Ametlla de Mar, 16',NULL,NULL,NULL,'C11',NULL,1,'2022-09-11 22:52:04'), (21,1,'E58703919','JESUS 3-5','8012','BARCELONA','C. JESUS 3-5',NULL,NULL,NULL,'C12',NULL,1,'2022-09-11 22:52:04'), (22,1,'H17277393','VELL RECER','17230','PALAMOS','C. ADRIÀ ALVAREZ, 2-4',NULL,NULL,NULL,'C13',NULL,1,'2022-09-11 22:52:04'), (23,1,'H17277518','ALLADA 29-31','17230','PALAMOS','C. ALLADA, 29 - 31',NULL,NULL,NULL,'C14',NULL,1,'2022-09-11 22:52:04'), (24,1,'H17391046','CAN BOADA','17252','CALONGE I SANT ANTONI','C. GARBÍ, 9',NULL,NULL,NULL,'C15',NULL,1,'2022-09-11 22:52:04'), (25,1,'H17862152','AV. LLUIS COMPANYS 58','17230','PALAMOS','AV. LLUIS COMPANYS, 58',NULL,NULL,NULL,'C16',NULL,1,'2022-09-11 22:52:04'), (26,1,'H17277559','ROTONDA','17230','PALAMOS','C. DEL MAR 4',NULL,NULL,NULL,'C1012',NULL,1,'2022-09-11 22:52:04'), (27,1,'H55082606','AV. CATALUNYA 20 SAC','17252','CALONGE I SANT ANTONI','AV. CATALUNYA, 20',NULL,NULL,NULL,'C18',NULL,1,'2022-09-11 22:52:04'), (28,1,'H17485822','LLUNA LLEVANT II','17230','PALAMOS','C. NAPOLS, 33',NULL,NULL,NULL,'C19',NULL,1,'2022-09-11 22:52:04'), (29,1,'H17277500','FAR','17230','PALAMOS','C. AMETLLA DE MAR, 37',NULL,NULL,NULL,'C20',NULL,1,'2022-09-11 22:52:04'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (30,1,'H17211699','SANT ANTONI','17252','CALONGE I SANT ANTONI','C. PONENT 1',NULL,NULL,NULL,'C1015',NULL,1,'2022-09-11 22:52:04'), (31,1,'H17277435','MAR BLAU','17248','S-AGARÓ','CTRA. VELLA S. FELIU, 652',NULL,NULL,NULL,'C22',NULL,1,'2022-09-11 22:52:04'), (32,1,'H17711326','CASBHI','17252','CALONGE I SANT ANTONI','C. SANT ANTONI, 144',NULL,NULL,NULL,'C23',NULL,1,'2022-09-11 22:52:04'), (33,1,'H17117813','SA RIERA IV','17251','CALONGE I SANT ANTONI','C. DR. VILASECA, 50 B.',NULL,NULL,NULL,'C24',NULL,1,'2022-09-11 22:52:04'), (34,1,'H17385006','TURO DE LA FOSCA','17230','PALAMOS','CTRA DE LA FOSCA, 25',NULL,NULL,NULL,'C25',NULL,1,'2022-09-11 22:52:04'), (35,1,'H17420084','LLUNA LLEVANT I','17230','PALAMOS','AV. CATALUNYA, 91',NULL,NULL,NULL,'C27',NULL,1,'2022-09-11 22:52:04'), (36,1,'H17507682','D-ARO PARK','17245','SANTA CRISTINA D-ARO','URB. SANT MIQUEL D-ARO',NULL,NULL,NULL,'C28',NULL,1,'2022-09-11 22:52:04'), (37,1,'H17720129','MAR OBERT','17252','CALONGE I SANT ANTONI','PASS. J.MUNDET, 49',NULL,NULL,NULL,'C29',NULL,1,'2022-09-11 22:52:04'), (38,1,'H17616228','BANC CENTRAL','17230','PALAMOS','AV. PRESIDENT MACIÁ, 1',NULL,NULL,NULL,'C30',NULL,1,'2022-09-11 22:52:04'), (39,1,'H17484213','PINEDA CALA MASET','17220','SANT FELIU DE GUIXOLS','ST FELIU DE G A ST POL 655-663',NULL,NULL,NULL,'C31',NULL,1,'2022-09-11 22:52:04'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (40,1,'H17282823','PERE DEL RACO','17252','CALONGE I SANT ANTONI','C. JOSEP PLA, Nº6',NULL,NULL,NULL,'C32',NULL,1,'2022-09-11 22:52:04'), (41,1,'H17932377','MARIA','17251','CALONGE I SANT ANTONI','C. Balmes 16 / Dr.Vilaseca 51',NULL,NULL,NULL,'C33',NULL,1,'2022-09-11 22:52:04'), (42,1,'H17820044','RESIDENCIAL AUMELL','17252','CALONGE I SANT ANTONI','C. SARD, 1-3',NULL,NULL,NULL,'C34',NULL,1,'2022-09-11 22:52:04'), (43,1,'H17495557','JOSEP TARRADELLAS 2','17251','CALONGE I SANT ANTONI','C. JOSEP TARRADELLAS, 2',NULL,NULL,NULL,'C1006',NULL,1,'2022-09-11 22:52:04'), (44,1,'H17882341','RIDAURA','17250','PLATJA D-ARO','C.QUERALBS, 10-12',NULL,NULL,NULL,'C37',NULL,1,'2022-09-11 22:52:04'), (45,1,'H17724253','AV. CATALUNYA 64 SAC','17252','CALONGE I SANT ANTONI','AV. CATALUNYA, 64',NULL,NULL,NULL,'C39',NULL,1,'2022-09-11 22:52:04'), (46,1,'H17694910','CAP DE PLANES','17230','PALAMOS','CAMÍ CAP DE PLANES, S/N',NULL,NULL,NULL,'C40',NULL,1,'2022-09-11 22:52:04'), (47,1,'H17729229','FRAGATA','17252','CALONGE I SANT ANTONI','PÇA. DE LA LIBERTAT, 15',NULL,NULL,NULL,'C41',NULL,1,'2022-09-11 22:52:04'), (48,1,'H17383720','MERCE','17230','PALAMOS','c. Santa Marta, 21',NULL,NULL,NULL,'C42',NULL,1,'2022-09-11 22:52:04'), (49,1,'H55014245','RESIDENC. PALAMOS MAR','17230','PALAMOS','AV. PRESIDENT MACIA, 94',NULL,NULL,NULL,'C43',NULL,1,'2022-09-11 22:52:04'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (50,1,'H17412792','TORRE TRAMONTANA','17250','PLATJA D-ARO','C. HORTENSIA, 2 URB. POLITUR',NULL,NULL,NULL,'C44',NULL,1,'2022-09-11 22:52:04'), (51,1,'H17292467','VORAMAR PALAMOS','17230','PALAMOS','C/ROGER DE FLOR,Nº2-4','','','','C45','',0,'2022-09-11 22:52:04'), (52,1,'H17783499','ROURES','17248','S-AGARÓ','CTRA. DE CASTELL D-ARO, 29-41',NULL,NULL,NULL,'C46',NULL,1,'2022-09-11 22:52:04'), (53,1,'H17680901','GASPAR BOSCH 45-47','17230','PALAMOS','C. MOSSEN G.BOSCH, 45-47',NULL,NULL,NULL,'C47',NULL,1,'2022-09-11 22:52:04'), (54,1,'H17811464','JORDI VERRIE FAGET 7','17246','SANTA CRISTINA D-ARO','C. JORDI VERRIÉ FAGET, 7',NULL,NULL,NULL,'C48',NULL,1,'2022-09-11 22:52:04'), (55,1,'H17808072','PARADIS PLATJA','17230','PALAMOS','PASSEIG DEL MAR, 24-26',NULL,NULL,NULL,'C49',NULL,1,'2022-09-11 22:52:04'), (56,1,'H17329111','TORRE COLOMINA 2','17252','CALONGE I SANT ANTONI','C. PONENT',NULL,NULL,NULL,'C50',NULL,1,'2022-09-11 22:52:04'), (57,1,'H17687518','ROGER LLURIA 3','17230','PALAMOS','C. ROGER DE LLURIA, 3',NULL,NULL,NULL,'C52',NULL,1,'2022-09-11 22:52:04'), (58,1,'H55135842','MAREA12 RIUS I CALVET','17220','SANT FELIU DE GUIXOLS','PASSEIG RIUS I CALVET, 4',NULL,NULL,NULL,'C53',NULL,1,'2022-09-11 22:52:04'), (59,1,'H17638248','MONTSENY','17250','PLATJA D-ARO','AV. DE MADRID, 51-53-55-57',NULL,NULL,NULL,'C54',NULL,1,'2022-09-11 22:52:04'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (60,1,'H17420308','COMTES PALAMÓS','17230','PALAMOS','PLAÇA COMTES DE PALAMÓS, 3-5',NULL,NULL,NULL,'C55',NULL,1,'2022-09-11 22:52:04'), (61,1,'H17877796','ARTUR MUNDET 95-101','17252','CALONGE I SANT ANTONI','C. ARTUR MUNDET, 97',NULL,NULL,NULL,'C57',NULL,1,'2022-09-11 22:52:05'), (62,1,'H17211681','AUBI 37 / MAR 10','17230','PALAMOS','C. AUBI, 37 - C. DEL MAR, 10',NULL,NULL,NULL,'C58',NULL,1,'2022-09-11 22:52:05'), (63,1,'H55010912','JOSEP JOAN 21-23','17230','PALAMOS','C/ JOSEP JOAN, 21-23',NULL,NULL,NULL,'C59',NULL,1,'2022-09-11 22:52:05'), (64,1,'H17343021','CAMÈLIES','17250','PLATJA D-ARO','URB. POLITUR, C.CAMELIAS,3 B-C',NULL,NULL,NULL,'C60',NULL,1,'2022-09-11 22:52:05'), (65,1,'H17822453','CARRILET 1','17240','LLAGOSTERA','C. CARRILET, 32',NULL,NULL,NULL,'C61',NULL,1,'2022-09-11 22:52:05'), (66,1,'H55030126','BATLLE','17230','PALAMOS','AVGDA.DEL MEDITERRANI,17',NULL,NULL,NULL,'C62',NULL,1,'2022-09-11 22:52:05'), (67,1,'H17896028','JOAN MARAGALL 12','17230','PALAMOS','C. JOAN MARAGALL 12',NULL,NULL,NULL,'C63',NULL,1,'2022-09-11 22:52:05'), (68,1,'H17270836','ANSELM CLAVÉ 5','17230','PALAMOS','C. ANSELM CLAVE, 5',NULL,NULL,NULL,'C64',NULL,1,'2022-09-11 22:52:05'), (69,1,'H17910654','PINELL DE MAR','17257','TORROELLA DE MONTGRI','C. MARTINET - URB. MAS PINELL',NULL,NULL,NULL,'C65',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (70,1,'H17923426','PALMERA','17252','CALONGE I SANT ANTONI','C. PALMERA, 6 / ST. ANTONI 100',NULL,NULL,NULL,'C67',NULL,1,'2022-09-11 22:52:05'), (71,1,'H17923400','PLAÇA LLIBERTAT','17252','CALONGE I SANT ANTONI','PLAÇA DE LA LLIBERTAT, 10',NULL,NULL,NULL,'C68',NULL,1,'2022-09-11 22:52:05'), (72,1,'H17773490','ROBLES','17252','CALONGE I SANT ANTONI','C. ROGER, 1-3-5',NULL,NULL,NULL,'C69',NULL,1,'2022-09-11 22:52:05'), (73,1,'H17942822','BONANÇA','17252','CALONGE I SANT ANTONI','C. LLUIS MORENO PALLI, 3',NULL,NULL,NULL,'C70',NULL,1,'2022-09-11 22:52:05'), (74,1,'H17828856','VORAMAR - SAC.','17251','CALONGE I SANT ANTONI','C. JOSEP MERCADER, 2',NULL,NULL,NULL,'C71',NULL,1,'2022-09-11 22:52:05'), (75,1,'H17928144','AV. LLIBERTAT 50','17230','PALAMOS','AV. LLIBERTAT, 50',NULL,NULL,NULL,'C72',NULL,1,'2022-09-11 22:52:05'), (76,1,'H17872805','COPAMARINA','17252','CALONGE I SANT ANTONI','C. SANT ANTONI, 193',NULL,NULL,NULL,'C73',NULL,1,'2022-09-11 22:52:05'), (77,1,'H17950981','EMILI JOAN 16','17230','PALAMOS','C. EMILI JOAN, 16',NULL,NULL,NULL,'C74',NULL,1,'2022-09-11 22:52:05'), (78,1,'H55081145','BELLAVISTA GARATGES','17230','PALAMOS','C. MOSSEN GASPAR BOSCH, 40',NULL,NULL,NULL,'C75',NULL,1,'2022-09-11 22:52:05'), (79,1,'H55081137','QUINTA JOFRA ESCALA C','17251','CALONGE I SANT ANTONI','AVDA. SANT JORDI, 1 C',NULL,NULL,NULL,'C77',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (80,1,'H55218069','QUINTA JOFRA PARKING','17251','CALONGE I SANT ANTONI','AVDA. SANT JORDI, 1',NULL,NULL,NULL,'C78',NULL,1,'2022-09-11 22:52:05'), (81,1,'H17491408','APARTAMENTS LA FOSCA','17230','PALAMOS','C. JOSEP PLA, 47',NULL,NULL,NULL,'C79',NULL,1,'2022-09-11 22:52:05'), (82,1,'G17387556','FONT DEL LLEO','17251','CALONGE I SANT ANTONI','Urb. Font del Lleó',NULL,NULL,NULL,'C1003',NULL,1,'2022-09-11 22:52:05'), (83,1,'H17966276','MOLI','17251','CALONGE I SANT ANTONI','AV. VERGE DE NURIA, 29',NULL,NULL,NULL,'C1009',NULL,1,'2022-09-11 22:52:05'), (84,1,'H55237671','MOLI 49-61','17244','CASSÀ DE LA SELVA','C. MOLI 49-61/AVALL, 54',NULL,NULL,NULL,'C83',NULL,1,'2022-09-11 22:52:05'), (85,1,'H17538950','UNIO 8','17230','PALAMOS','C. UNIO 8',NULL,NULL,NULL,'C85',NULL,1,'2022-09-11 22:52:05'), (86,1,'H17323015','MARINA BLANCA','17230','PALAMOS','C. JOSEP PLA, 49',NULL,NULL,NULL,'C86',NULL,1,'2022-09-11 22:52:05'), (87,1,'H55077390','CERDANYA','17252','CALONGE I SANT ANTONI','C. A.MUNDET 80 / S.ANTONI 105',NULL,NULL,NULL,'C87',NULL,1,'2022-09-11 22:52:05'), (88,1,'H59918789','ENAMORATS 46','8013','BARCELONA','C. ENAMORATS 46',NULL,NULL,NULL,'C88',NULL,1,'2022-09-11 22:52:05'), (89,1,'H58949207','MALLORCA 237','8008','BARCELONA','C. MALLORCA 237',NULL,NULL,NULL,'C1007',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (90,1,'H55011191','VELADA','17252','CALONGE I SANT ANTONI','AVINGUDA CATALUNYA 54 / C. ARTUR MUNDET, 67',NULL,NULL,NULL,'C1016',NULL,1,'2022-09-11 22:52:05'), (91,1,'H17801358','JOSEP M VILASECA FASE II','17251','CALONGE','C. JOSEP MARIA VILASECA, 61',NULL,NULL,NULL,'C1005',NULL,1,'2022-09-11 22:52:05'), (92,1,'H17843244','PUIG D-ARQUES','17252','CALONGE I SANT ANTONI','C. VERMELL 17 / C. CNRAD VILAR 14',NULL,NULL,NULL,'C1011',NULL,1,'2022-09-11 22:52:05'), (93,1,'','ESPERANZA','17248','S-AGARO','C. LA GRAMOIA D-EN PUIG 5',NULL,NULL,NULL,'C1002',NULL,1,'2022-09-11 22:52:05'), (94,1,'H66342049','CAVALLERS 52','8292','ESPARRAGUERA','C. CAVALLERS, 52',NULL,NULL,NULL,'C201',NULL,1,'2022-09-11 22:52:05'), (95,1,'H66354838','CAMI RAL 198-200','8490','TORDERA','CAMI RAL, 198-200',NULL,NULL,NULL,'C203',NULL,1,'2022-09-11 22:52:05'), (96,1,'H17145723','RESIDENCIAL MIG-JORN','17248','S-AGARÓ','LA SELVA, 13',NULL,NULL,NULL,'C301',NULL,1,'2022-09-11 22:52:05'), (97,1,'H17128885','SANT LLUÍS','17250','PLATJA D-ARO','PLAÇA D-EUROPA 18, 19 I 20',NULL,NULL,NULL,'C302',NULL,1,'2022-09-11 22:52:05'), (98,1,'E17123282','ESPLAI PLATJA','17250','PLATJA D-ARO','C/ CIUTAT DE GIRONA, 16',NULL,NULL,NULL,'C303',NULL,1,'2022-09-11 22:52:05'), (99,1,'H17304379','ALBA','17248','S-AGARÓ','CTRA.TRAMUNTANA S/N',NULL,NULL,NULL,'C304',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (100,1,'H17475690','DALIES','17250','PLATJA D-ARO','POLITUR. C. DALIES',NULL,NULL,NULL,'C306',NULL,1,'2022-09-11 22:52:05'), (101,1,'H17269739','BELL CIM I','17220','SANT FELIU DE GUIXOLS','C. GRUMET 18',NULL,NULL,NULL,'C307',NULL,1,'2022-09-11 22:52:05'), (102,1,'H17410705','PETUNIES','17250','PLATJA D-ARO','CARRER ROURA 5',NULL,NULL,NULL,'C1010',NULL,1,'2022-09-11 22:52:05'), (103,1,'H17071937','ORIOL CENTER','17250','PLATJA D-ARO','AVENIDA MEDITERRANEO, 1',NULL,NULL,NULL,'C309',NULL,1,'2022-09-11 22:52:05'), (104,1,'H17263153','MAGNÒLIES','17250','PLATJA D-ARO','URB.POLITUR, P-16',NULL,NULL,NULL,'C310',NULL,1,'2022-09-11 22:52:05'), (105,1,'E17104738','MAR BLAU - P.ARO','17250','PLATJA D-ARO','C. EMPORDA 25',NULL,NULL,NULL,'C1008',NULL,1,'2022-09-11 22:52:05'), (106,1,'H17564147','S-AGARO BEACH','17220','SANT FELIU DE GUIXOLS','C/VERBANIA,18-20',NULL,NULL,NULL,'C313',NULL,1,'2022-09-11 22:52:05'), (107,1,'H17603366','S-AGARO PLATJA II','17220','SANT FELIU DE GUIXOLS','AVDA.JAUME I, 60-62',NULL,NULL,NULL,'C314',NULL,1,'2022-09-11 22:52:05'), (108,1,'H17218645','ESPLAI S-AGARÓ','17250','PLATJA D-ARO','C/TRAMUNTANA S/N',NULL,NULL,NULL,'C305',NULL,1,'2022-09-11 22:52:05'), (109,1,'H17251398','CAVALL BERNAT 1','17250','PLATJA D-ARO','C. PUNTA ROCOSA, 12',NULL,NULL,NULL,'C1000',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (110,1,'H17603382','FRONT DE MAR','17220','SANT FELIU DE GUIXOLS','C. VERBANIA, 60-68',NULL,NULL,NULL,'C1004',NULL,1,'2022-09-11 22:52:05'), (111,1,'H17394040','SANT POL PLATJA','17220','SANT FELIU DE GUIXOLS','AVGDA. VALL D-ARO, S/N.',NULL,NULL,NULL,'C319',NULL,1,'2022-09-11 22:52:05'), (112,1,'H17300708','S-AGARO RESIDENCIAL','17250','PLATJA D-ARO','C. SALVAT PAPASSEIT, 20',NULL,NULL,NULL,'C1013',NULL,1,'2022-09-11 22:52:05'), (113,1,'H17522988','SA CONCA I i II','17250','PLATJA D-ARO','C/ MAR I LLUM, 6-8',NULL,NULL,NULL,'C1014',NULL,1,'2022-09-11 22:52:05'), (114,1,'H17270471','CARLEMAGNE','17250','PLATJA D-ARO','C. LLEVANT, 11',NULL,NULL,NULL,'C322',NULL,1,'2022-09-11 22:52:05'), (115,1,'H17414269','BILBAO 4','17250','PLATJA D-ARO','C/ BILBAO,4',NULL,NULL,NULL,'C323',NULL,1,'2022-09-11 22:52:05'), (116,1,'H17270497','BELL LLOCH ','17250','PLATJA D-ARO','C/ PEP VENTURA 3',NULL,NULL,NULL,'C324',NULL,1,'2022-09-11 22:52:05'), (117,1,'H17254350','SANT MARTI','17250','PLATJA D-ARO','C/ MIRAMAR, 9',NULL,NULL,NULL,'C325',NULL,1,'2022-09-11 22:52:05'), (118,1,'H17424276','BITACORA','17250','PLATJA D-ARO','C/ GREVOL 4',NULL,NULL,NULL,'C328',NULL,1,'2022-09-11 22:52:05'), (119,1,'E17104894','SANT MARC','17250','PLATJA D-ARO','AVDA. S-AGARÓ, 62',NULL,NULL,NULL,'C329',NULL,1,'2022-09-11 22:52:05'); INSERT INTO admin_key.comunidad (id,id_tipo_documento,documento,nombre,cod_postal,poblacion,direccion,telefono1,telefono2,contacto,nomenclatura,email,estado,created) VALUES (120,1,'H17060732','CAVALL BERNAT 2','17250','PLATJA D-ARO','C. SA PUBIATANA 13',NULL,NULL,NULL,'C1001',NULL,1,'2022-09-11 22:52:05');