| soil_change_element_id |
int8 |
19 |
|
|
null |
|
|
System generated sequence number to uniquely identify a SOIL CHANGE PARTICULAR |
| alr_appl_component_id |
int8 |
19 |
|
|
null |
|
|
System generated sequence number to uniquely identify an ALR APPL COMPONENT |
| soil_change_code |
varchar |
10 |
|
|
null |
|
|
User supplied value to uniquely identify a SOIL CHANGE CODE |
| volume |
float8 |
17,17 |
|
|
null |
|
|
The volume in cubic meters of soil removed, or fill added |
| depth |
float8 |
17,17 |
|
|
null |
|
|
The depth in meters to which fill will be placed or soil removed |
| material_desc |
varchar |
4000 |
√ |
|
null |
|
|
Description of the soil being removed, or the fill being placed |
| material_origin_desc |
varchar |
4000 |
√ |
|
null |
|
|
Description of the origin ofthe fill being placed |
| alternative_measures_desc |
varchar |
4000 |
√ |
|
null |
|
|
Description of any alternative measure that have been considored. |
| project_duration |
int2 |
5 |
√ |
|
null |
|
|
The duration of the project. |
| project_area |
float8 |
17,17 |
√ |
|
null |
|
|
The area effected by the project. |
