DIC_COUNTY_COORDS_SC
Dictionary table containing coordinates of County series geological maps for Scotland (all logical sheets).
No. |
Column name |
Data type |
Notes |
1 |
ROWNO |
Numeric(22) |
Primary key
|
2 |
SERIES |
Varchar(1) |
|
3 |
SHEET |
Varchar(3) |
|
4 |
SHEETNUM |
Varchar(3) |
|
5 |
SUFFIX |
Varchar(1) |
|
6 |
QUARTER |
Varchar(2) |
|
7 |
SWE |
Numeric(22) |
|
8 |
SWN |
Numeric(22) |
|
9 |
SEE |
Numeric(22) |
|
10 |
SEN |
Numeric(22) |
|
11 |
NEE |
Numeric(22) |
|
12 |
NEN |
Numeric(22) |
|
13 |
NWE |
Numeric(22) |
|
14 |
NWN |
Numeric(22) |
|
15 |
LINK |
Numeric(22) |
|
16 |
DATE_ENTERED |
Date |
|
17 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 20 of 2315)
ROWNO |
SERIES |
SHEET |
SHEETNUM |
SUFFIX |
QUARTER |
SWE |
SWN |
SEE |
SEN |
NEE |
NEN |
NWE |
NWN |
LINK |
DATE_ENTERED |
DATE_UPDATED |
65 |
M |
ODO |
23 |
. |
NE |
249529 |
672688 |
254355 |
672564 |
254437 |
675781 |
249611 |
675905 |
|
|
|
66 |
M |
ODO |
23 |
. |
SW |
244620 |
669565 |
249446 |
669471 |
249529 |
672688 |
244703 |
672811 |
|
|
|
55 |
M |
ODO |
18 |
. |
NE |
240042 |
679369 |
244868 |
679245 |
244950 |
682462 |
240124 |
682587 |
|
|
|
56 |
M |
ODO |
18 |
. |
SW |
235133 |
676276 |
239959 |
676152 |
240042 |
679369 |
235216 |
679493 |
|
|
|
57 |
M |
ODO |
18 |
. |
SE |
239959 |
676152 |
244785 |
676029 |
244868 |
679245 |
240042 |
679369 |
|
|
|
58 |
M |
ODO |
19 |
. |
NW |
244868 |
679245 |
249694 |
679121 |
249776 |
682339 |
244950 |
682462 |
|
|
|
59 |
M |
ODO |
19 |
. |
SW |
244785 |
676029 |
249611 |
675905 |
249694 |
679121 |
244868 |
679245 |
|
|
|
60 |
M |
ODO |
19 |
. |
SE |
249611 |
675905 |
254437 |
675781 |
254520 |
678998 |
249694 |
679121 |
|
|
|
61 |
M |
ODO |
20 |
. |
SW |
254437 |
675781 |
259263 |
675657 |
259346 |
678874 |
254520 |
678998 |
|
|
|
62 |
M |
ODO |
22 |
. |
NW |
235051 |
673059 |
239877 |
672935 |
239959 |
676152 |
235133 |
676276 |
|
|
|
63 |
M |
ODO |
22 |
. |
NE |
239877 |
672935 |
244703 |
672811 |
244785 |
676029 |
239959 |
676152 |
|
|
|
64 |
M |
ODO |
23 |
. |
NW |
244703 |
672811 |
249529 |
672688 |
249611 |
675905 |
244785 |
676029 |
|
|
|
1 |
M |
OWN |
11 |
. |
NW |
292770 |
665115 |
297585 |
664987 |
297672 |
668213 |
292840 |
668342 |
|
|
|
2 |
M |
OWN |
11 |
. |
SW |
292697 |
661923 |
297550 |
661806 |
297643 |
665020 |
292777 |
665138 |
|
|
|
3 |
M |
OWN |
13 |
. |
NE |
287781 |
658770 |
292595 |
658661 |
292675 |
661875 |
287861 |
661997 |
|
|
|
4 |
M |
OWN |
14 |
. |
NW |
292595 |
658661 |
297435 |
658589 |
297500 |
661760 |
292675 |
661875 |
|
|
|
5 |
M |
OSI |
30 |
. |
SE |
288216 |
674915 |
293041 |
674792 |
293124 |
678009 |
288298 |
678132 |
|
|
|
6 |
M |
OSI |
32 |
. |
NW |
254356 |
672564 |
259181 |
672441 |
259264 |
675658 |
254438 |
675781 |
|
|
|
7 |
M |
OSI |
32 |
. |
NE |
259181 |
672441 |
264006 |
672317 |
264089 |
675534 |
259264 |
675658 |
|
|
|
8 |
M |
OSI |
33 |
. |
NW |
264006 |
672317 |
268832 |
672193 |
268914 |
675410 |
264089 |
675534 |
|
|
|