Retrouvez le syndicat le plus proche de chez vous en Aquitaine
Cliquez sur le département de votre choix sur la carte ci-dessous pour obtenir les coordonnées des syndicats de forestiers privés.
Coordonnées
Erreur de la base de données WordPress : [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 42]
SELECT
DEP.NomDepartement,
DEP.NomRegion AS Region,
SYNDICAT.IDStructure AS IDSyndicat,
SYNDICAT.NomStructure AS NomSyndicat,
SYNDICAT.URLSyndicat AS URLSyndicat,
SYNDICAT.EST_ExclusionRegion AS SuppRegion,
SYNDICAT.Adresse1 AS Adresse2,
SYNDICAT.Adresse2 AS Adresse1,
SYNDICAT.CodePostal AS CodePostal,
SYNDICAT.Ville AS Ville,
SYNDICAT.Telephone AS Telephone,
REGION.NomStructure AS NomRegion,
REGION.IDStructure AS IDRegion,
REGION.URLSyndicat AS URLRegion,
REGION.Adresse1 AS URAdresse1,
REGION.Adresse2 AS URAdresse2,
REGION.CodePostal AS URCodePostal,
REGION.Ville AS URVille,
REGION.Telephone AS URTelephone
FROM
DEPARTEMENTS AS DEP
JOIN Carte AS SYNDICAT ON DEP.ID_StructureSyndicat = SYNDICAT.IDStructure
LEFT JOIN Carte AS REGION ON REGION.IDStructure = SYNDICAT.IDParent
WHERE
DEP.IDCode =