| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| locazione | None | FLOAT | ||||
| quotazione | None | INT | ||||
| data_storico | None | DATETIME | ||||
| 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 |
| Table Name | Untitled Query 4-WMRVqr6zR |
|---|---|
| Sql | SELECT AVG(a.loc_max) as locazione, AVG(a.compr_max) as quotazione, a.data_storico, nf.name, nf.linkzona, nf.codcom, nf.codzona, a.zona, nf.name00, nf.comune, nf.shape_area, nf.shape_leng FROM public."v_agid_omi_ss_js" nf Left Join (select * from public."Agid_VALORI_ss" where descr_tipologia in ('Abitazioni civili','Abitazioni di tipo economico')) 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, a.data_storico |
| 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].[Untitled Query 4-WMRVqr6zR](id:13) |
| Associated Charts | [TimeLine: Valore Medio di Compravendita Locali Residenziali(€/mq)] |