All tables that make up maakuntakaava plan data.
These tables represent all geometries in the plan.
| Name | Columns | Comment | Type |
|---|---|---|---|
| hame.plan | 18 | BASE TABLE | |
| hame.land_use_area | 15 | BASE TABLE | |
| hame.land_use_point | 15 | BASE TABLE | |
| hame.line | 15 | BASE TABLE | |
| hame.other_area | 15 | BASE TABLE | |
| hame.other_point | 15 | BASE TABLE |
These tables represent all regulations in the plan.
| Name | Columns | Comment | Type |
|---|---|---|---|
| hame.plan_regulation_group | 6 | BASE TABLE | |
| hame.plan_regulation | 23 | BASE TABLE | |
| hame.plan_proposition | 10 | BASE TABLE |
These tables contain all metadata, documents and other linked information.
| Name | Columns | Comment | Type |
|---|---|---|---|
| hame.source_data | 8 | BASE TABLE | |
| hame.organisation | 6 | BASE TABLE | |
| hame.document | 12 | BASE TABLE | |
| hame.lifecycle_date | 14 | BASE TABLE |
These tables contain all national (koodistot.suomi.fi) and local codes used for classifying plan data.
| Name | Columns | Comment | Type |
|---|---|---|---|
| codes.lifecycle_status | 10 | BASE TABLE | |
| codes.plan_type | 10 | BASE TABLE | |
| codes.type_of_additional_information | 10 | BASE TABLE | |
| codes.type_of_plan_regulation | 10 | BASE TABLE | |
| codes.type_of_source_data | 10 | BASE TABLE | |
| codes.type_of_underground | 10 | BASE TABLE | |
| codes.type_of_verbal_plan_regulation | 10 | BASE TABLE | |
| codes.type_of_document | 10 | BASE TABLE | |
| codes.administrative_region | 10 | BASE TABLE | |
| codes.type_of_plan_regulation_group | 10 | BASE TABLE | |
| codes.plan_theme | 10 | BASE TABLE |
Generated by tbls