First of all, sorry for my english langage, I'm trying to make the best translation <br />
I can of the Data native langage wich is french into english one.<br />
Well, what I need to do is a crossTab like the one in the attached picture.<br />
<br />
<br />
Some explanations about the content of the table : <br />
<br />
? In column : groups of species = "groupes d'esp?ces"(flore,invert?br?,oiseaux,amphibiens et reptiles,mamif?res chriopt?res, autres mamif?res) and natural habitats "habitats naturels". <br />
<br />
( groups of species : is a column in a Table in my Database)<br />
<br />
? In ligne : "menace" (nb species threatened or almost threatened ) / "protection" (nb of species protected nationally et regionally) / directives<br />
<br />
? In the cells : number of species or number of naturel Habitat.<br />
<br />
? Total<br />
<br />
Queries:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>"protection":
- number of taxa protected at national and regional taxonomic group for selected common:
select count(*) as nb_especes_protegees, gta_id_groupe_taxonomique
from tv_taxon_observe_commune, t_taxon_observe
where tv_taxon_observe_commune.tao_id_taxon in
(select tao_id_taxon from tv_taxons_proteges_region_et_nation_groupe)
and gez_id_geom_zonage = 217609
>(common code)
and tv_taxon_observe_commune.tao_id_taxon = t_taxon_observe.tao_id_taxon
group by gta_id_groupe_taxonomique
"Menace":
- number of species threatened or almost threatened with taxonomic groupe for selected common:
select count(*) as nb_especes_menacees, gta_id_groupe_taxonomique
from tv_taxon_observe_commune, t_taxon_observe
where tv_taxon_observe_commune.tao_id_taxon in
(select tao_id_taxon from tv_taxons_menaces_quasi_menaces_groupe)
and gez_id_geom_zonage = 217609
and tv_taxon_observe_commune.tao_id_taxon = t_taxon_observe.tao_id_taxon
group by gta_id_groupe_taxonomique
"Directives":
- Directive number of species with taxonomic group for selected common
select count(*) as nb_especes_directive, gta_id_groupe_taxonomique
from tv_taxon_observe_commune, t_taxon_observe
where tv_taxon_observe_commune.tao_id_taxon in
(select tao_id_taxon from tv_taxons_directive_groupe)
and gez_id_geom_zonage = 217609
>(common code)
and tv_taxon_observe_commune.tao_id_taxon = t_taxon_observe.tao_id_taxon
group by gta_id_groupe_taxonomique</pre>
