| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| locazione | None | FLOAT | ||||
| quotazione | None | INT | ||||
| name | None | STRING | ||||
| linkzona | None | None | ||||
| codcom | None | STRING | ||||
| codzona | None | STRING | ||||
| zona | None | STRING | ||||
| name00 | None | None | ||||
| comune | None | STRING | ||||
| shape_area | None | FLOAT | ||||
| shape_leng | None | FLOAT | ||||
| geomjs | None | STRING |
| Table Name | Geometrie_Zone_quotazioni-RzpTfoiGO |
|---|---|
| Sql | SELECT sum(a.loc_max) as locazione, sum(a.compr_max) as quotazione, nf.name, nf.linkzona, nf.codcom, nf.codzona, a.zona, nf.name00, nf.comune, nf.shape_area, nf.shape_leng, nf.geomjs FROM public."v_agid_omi_ss_js" nf Left Join (select * from public."Agid_VALORI_ss" where storico='20192') a ON a.zona=nf.codzona group by nf.codzona, a.zona,nf.name, nf.linkzona, nf.codcom, nf.codzona, nf.name00, nf.comune, nf.shape_area, nf.shape_leng, nf.geomjs |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | nemea_alley |
| Schema | public |
| Description | None |
| Owners | [] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | False |
| Template parameters | None |
| Perm | [nemea_alley].[Geometrie_Zone_quotazioni-RzpTfoiGO](id:11) |
| Associated Charts | [Estensione Aree Omi (km²)] |