This table contains location data for all commercial groundfish regulations. It joins on LOCATION_ID in other tables.
| name | value |
|---|---|
| name | [dbo].[REG_ALL_LOCATIONS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 70 |
| Size of data | 16 kb |
| Size of indexes | 32 kb |
| Maximum size of a single row | 2,172 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| location_pk | int identity (1,1) | 10 | 4 | no | yes | no | ||||
| location_id | nvarchar | 200 | 800 | yes | no | This column is used to link regulation tables to identify regulations by various types of location. | ||||
| North_lat_old | real | 7 | 4 | yes | no | |||||
| South_lat_old | real | 7 | 4 | yes | no | |||||
| States | nvarchar | 200 | 800 | yes | no | the state(s) encompassed by the location_id | ||||
| INPFCs | nvarchar | 100 | 400 | yes | no | the INPFC area(s) encompassed by the location_id | ||||
| North_lat | nvarchar | 20 | 80 | yes | no | the northern latitude boundary encompassed by the location_id | ||||
| South_lat | nvarchar | 20 | 80 | yes | no | the southern latitude boundary encompassed by the location_id |
| name | object type | level |
|---|