DIC_50K_COORD
Dictionary of 1:50,000 geological map sheets for England, Wales and Scotland (identified by sheet number) and their 8 spatial coordinates (SWN, SWE, SEE, SEN etc.).
| No. |
Column name |
Data type |
Notes |
| 1 |
SHEET |
Varchar(3) |
Primary key
|
| 2 |
SWE |
Numeric(22) |
|
| 3 |
SWN |
Numeric(22) |
|
| 4 |
SEE |
Numeric(22) |
|
| 5 |
SEN |
Numeric(22) |
|
| 6 |
NEE |
Numeric(22) |
|
| 7 |
NEN |
Numeric(22) |
|
| 8 |
NWE |
Numeric(22) |
|
| 9 |
NWN |
Numeric(22) |
|
| 10 |
ROWNO |
Numeric(22) |
|
| 11 |
DATE_ENTERED |
Date |
|
| 12 |
DATE_UPDATED |
Date |
|
| 13 |
PART |
Varchar(2) |
|
| 14 |
SERIES |
Varchar(1) |
|
Sample data (rows 1 to 20 of 754)
| SHEET |
SWE |
SWN |
SEE |
SEN |
NEE |
NEN |
NWE |
NWN |
ROWNO |
DATE_ENTERED |
DATE_UPDATED |
PART |
SERIES |
| 101 |
209974.5 |
891116 |
229281 |
890543 |
230137 |
919497 |
210831 |
920073 |
448 |
|
|
E |
S |
| 104 |
94968 |
923538 |
114283 |
922959 |
115145 |
951932 |
95830 |
952515 |
449 |
|
|
E |
S |
| 1 |
199051.5 |
514660.5 |
218358 |
514122 |
219185 |
543079 |
199878 |
543620 |
438 |
|
|
E |
S |
| 2 |
237661 |
513578 |
256964 |
513034 |
257789 |
541985 |
238487 |
542532 |
439 |
|
|
E |
S |
| 3 |
199878 |
543620 |
219185 |
543079 |
220011 |
572035 |
200704 |
572578.5 |
440 |
|
|
E |
S |
| 4 |
238487 |
542532 |
257789 |
541985 |
258614 |
570935 |
239312.5 |
571485 |
441 |
|
|
E |
S |
| 5 |
277088.5 |
541431.5 |
296388 |
540878 |
297216 |
569832 |
277915 |
570383.5 |
442 |
|
|
E |
S |
| 6 |
315687 |
540324.5 |
334986 |
539771 |
335811 |
568713 |
316513.5 |
569272.5 |
443 |
|
|
E |
S |
| 7 |
200704 |
572578.5 |
220011 |
572035 |
220842 |
600991 |
201533.5 |
601536.5 |
444 |
|
|
E |
S |
| 8 |
239312.5 |
571485 |
258614 |
570935 |
259445 |
599887 |
240143.5 |
600439 |
445 |
|
|
E |
S |
| 9 |
277915 |
570383.5 |
297216 |
569832 |
298047 |
598781 |
278746 |
599334 |
446 |
|
|
E |
S |
| 99 |
132740 |
893410 |
152055 |
892835 |
152912 |
921801 |
133597.5 |
922380 |
447 |
|
|
E |
S |
| 95 |
324923 |
858742.5 |
344220 |
858174 |
345076 |
887119 |
325779 |
887689 |
386 |
|
|
E |
S |
| 96 |
363517 |
857605.5 |
382814 |
857037 |
383669 |
885982 |
364372.5 |
886550.5 |
387 |
|
|
E |
S |
| 97 |
402110 |
856469 |
421406 |
855901 |
422261 |
884845 |
402965 |
885413.5 |
388 |
|
|
E |
S |
| 100 |
171361.5 |
892262 |
190668 |
891689 |
191525 |
920649 |
172218.5 |
921225 |
389 |
|
|
E |
S |
| 102 |
248581.5 |
889972 |
267882 |
889401 |
268738 |
918352 |
249437.5 |
918924.5 |
390 |
|
|
E |
S |
| 103 |
287182 |
888830 |
306482 |
888259 |
307338 |
917206 |
288038 |
917779 |
391 |
|
|
E |
S |
| 105 |
133597.5 |
922380 |
152912 |
921801 |
153775 |
950767 |
134460 |
951349.5 |
392 |
|
|
E |
S |
| 106 |
172218.5 |
921225 |
191525 |
920649 |
192387 |
949610 |
173081 |
950188.5 |
393 |
|
|
E |
S |
