-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 21, 2020 at 09:51 AM
-- Server version: 10.3.21-MariaDB
-- PHP Version: 7.2.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `SROC`
--

-- --------------------------------------------------------

--
-- Table structure for table `AREAS`
--

CREATE TABLE `AREAS` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Name` varchar(255) NOT NULL DEFAULT '',
  `Owners` varchar(255) DEFAULT NULL,
  `SymbolSet` varchar(255) DEFAULT NULL,
  `LastUseDate` date DEFAULT '1964-01-01',
  `Standard` int(11) DEFAULT NULL,
  `Easting` int(11) DEFAULT NULL,
  `Northing` int(11) DEFAULT NULL,
  `Latitude` float(10,6) NOT NULL DEFAULT 53.891418,
  `Longitude` float(10,6) NOT NULL DEFAULT -2.831755,
  `PrimaryType` varchar(30) NOT NULL,
  `SecondaryType` varchar(30) NOT NULL,
  `LastSurveyDate` date NOT NULL DEFAULT '1964-01-01',
  `Comments` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AREAS`
--

INSERT INTO `AREAS` (`ID`, `Name`, `Owners`, `SymbolSet`, `LastUseDate`, `Standard`, `Easting`, `Northing`, `Latitude`, `Longitude`, `PrimaryType`, `SecondaryType`, `LastSurveyDate`, `Comments`) VALUES
(1, 'Anglezarke', 'Local Authority', 'ISOM2017', NULL, 4, 364058, 418595, 53.670834, -2.549901, 'Moorland', '', '0000-00-00', ''),
(3, 'Arnside Knott', 'National Trust;Mr Barker', 'ISOM2017', '2019-11-20', 4, 344929, 477351, 54.190163, -2.844815, 'Forest', '', '0000-00-00', ''),
(8, 'Astley Park', NULL, 'ISSprOM 2019', '2019-01-01', 3, 357503, 418421, 53.660534, -2.644562, 'Park', 'Urban', '2020-02-01', ''),
(9, 'Avenham Park', NULL, 'ISSprOM 2019', '2020-11-01', 3, 353891, 428729, 53.752872, -2.700751, 'Park', '', '2020-11-01', ''),
(10, 'Astley Park', NULL, 'ISSprOM 2019', '2019-01-01', 3, 357503, 418421, 53.660534, -2.644562, 'Park', 'Urban', '2020-02-01', ''),
(11, 'Avenham Park', NULL, 'ISSprOM 2019', '2020-11-01', 3, 353891, 428729, 53.752872, -2.700751, 'Park', '', '2020-11-01', ''),
(12, 'Barrowfield Woods', NULL, 'ISOM 2017', '2020-11-02', 4, 348083, 490323, 54.305859, -2.799368, 'Forest', '', '2020-11-01', ''),
(14, 'Helsington Barrows', NULL, 'ISOM 2017', '2020-11-01', NULL, 347930, 491339, 54.314972, -2.801900, 'Moorland', 'Forest', '2020-11-01', ''),
(15, 'Beacon Fell', NULL, 'ISOM 2017', '2020-11-01', 4, 356500, 442599, 53.877754, -2.663152, '', '', '2020-11-01', ''),
(16, 'Blakehome and Gummers How', '', 'ISOM 2017', '1964-01-01', 5, 339429, 490087, 54.302780, -2.932305, 'Forest', '', '1964-01-01', ''),
(17, 'Blawith', NULL, 'ISOM 2017', NULL, 5, 327500, 490500, 54.304935, -3.115684, 'Moorland', '', '1964-01-01', ''),
(18, 'Broughton Forest', NULL, 'ISOM 2000', '1964-01-01', 4, 324641, 493490, 54.331390, -3.160372, '', '', '1964-01-01', 'Extensive Felling\r\nCombined with Torver High Common'),
(19, 'Torver High Common', NULL, 'ISOM 2017', '1964-01-01', 5, 326213, 495124, 54.346302, -3.136597, 'Moorland', '', '1964-01-01', 'Combined with Broughton Forest\r\nBoundary with Caw (LOC)'),
(20, 'Clougha Pike', 'Duke of Westminster', 'BOF', '1964-01-01', 5, 353891, 460528, 54.038651, -2.705555, 'Moorland', '', '1964-01-01', 'No OCAD file. Paper only'),
(21, 'Witcher Clough', NULL, 'ISOM 2000', '1964-01-01', 4, 364892, 452413, 53.966591, -2.536640, 'Forest', '', '1964-01-01', ''),
(22, 'Duxbury Park', NULL, 'ISOM 2017', '1964-01-01', 3, 358500, 415500, 53.634365, -2.629082, 'Park', 'Forest', '1964-01-01', ''),
(23, 'Eaves Wood', 'National Trust;Mr. Holgate', 'ISOM 2017', '1964-01-01', 4, 346519, 476327, 54.179916, -2.820911, 'Forest', '', '1964-01-01', ''),
(24, 'Elnup and Birley', NULL, 'ISOM 2017', '1964-01-01', 4, 355383, 408161, 53.568146, -2.675171, 'Forest', '', '1964-01-01', ''),
(25, 'Farleton Fell', 'National Trust', 'ISOM 2017', '1964-01-01', 5, 354428, 479583, 54.209946, -2.700233, 'Moorland', '', '2019-01-01', 'Connected to Hutton Roof.\r\nNon standard symbols.'),
(26, 'Hutton Roof', NULL, 'ISOM 2017', '1964-01-01', 5, 355822, 477815, 54.194183, -2.678604, 'Moorland', 'Forest', '1964-01-01', 'Includes Dalton Crags.\r\nNon standard symbols'),
(27, 'Gisburn Forest', NULL, 'ISOM 2017', '1964-01-01', 4, 373298, 457073, 54.008980, -2.408924, 'Forest', '', '1964-01-01', 'Potential for larger map when trees mature.'),
(28, 'Great Tower', NULL, 'ISOM 2000', '1964-01-01', 5, 339475, 491752, 54.317749, -2.931933, 'Forest', '', '1964-01-01', 'NWOA area'),
(29, 'Hampsfell', NULL, 'ISOM 2017', '1964-01-01', 4, 340113, 479244, 54.205429, -2.919617, 'Forest', 'Moorland', '1964-01-01', ''),
(30, 'Happy Mount Park', 'Lancaster City Council', 'ISSprOM 2019', '1964-01-01', 2, 345481, 465334, 54.081020, -2.834816, 'Park', '', '1964-01-01', ''),
(31, 'Haslam Park', NULL, NULL, '1964-01-01', 2, 351567, 431123, 53.774181, -2.736368, 'Park', '', '1964-01-01', ''),
(32, 'Healey Nab', NULL, 'ISOM 2017', '1964-01-01', 4, 360574, 418108, 53.657967, -2.598052, 'Forest', 'Moorland', '1964-01-01', ''),
(33, 'Hyning Scout Wood', 'Woodland Trust', 'ISOM 2017', '1964-01-01', 3, 350128, 473574, 54.155548, -2.765164, 'Forest', '', '1964-01-01', 'Small.\r\nClose to Leighton Hall'),
(34, 'Knotts Wood', NULL, 'ISOM 2017', '1964-01-01', 4, 351044, 462483, 54.055962, -2.749329, 'Forest', '', '1964-01-01', ''),
(35, 'Lancaster ', NULL, 'ISSprOM', '1964-01-01', 2, 347405, 461693, 54.048504, -2.804775, 'Urban', '', '1964-01-01', ''),
(36, 'University of Cumbria', NULL, NULL, '1964-01-01', NULL, 348426, 460857, 54.041088, -2.789047, '', '', '1964-01-01', ''),
(37, 'Lancaster University', NULL, 'ISSprOM 2019', '1964-01-01', 3, 348570, 457209, 54.008324, -2.786236, 'Park', 'Urban', '1964-01-01', ''),
(38, 'Leighton Hall Estate', NULL, 'ISOM 2017', '1964-01-01', 4, 349438, 474418, 54.163063, -2.775872, '', '', '1964-01-01', ''),
(39, 'Lords Lot Wood', NULL, 'ISOM 2017', '1964-01-01', 4, 354333, 470605, 54.129253, -2.700319, 'Forest', '', '1964-01-01', ''),
(40, 'Moor Park', NULL, 'ISSprOM 2019', '1964-01-01', 2, 354050, 431029, 53.773560, -2.698688, 'Park', '', '1964-01-01', ''),
(41, 'Myerscough College', NULL, 'ISSprOM 2019', '1964-01-01', 2, 350000, 440000, 53.853809, -2.761589, 'Urban', 'Park', '1964-01-01', ''),
(42, 'Nicky Nook', NULL, 'ISOM 2017', '1964-01-01', 4, 351813, 448792, 53.932999, -2.735424, 'Moorland', 'Forest', '1964-01-01', ''),
(43, 'Preston Sports Arena', NULL, 'ISSprOM 2019', '1964-01-01', 2, 350143, 431436, 53.776855, -2.758019, 'Park', '', '1964-01-01', ''),
(44, 'Roeburndale', NULL, 'ISOM 2017', '1964-01-01', 4, 360848, 465601, 54.084820, -2.599983, 'Forest', 'Moorland', '1964-01-01', ''),
(45, 'Ryelands Park', NULL, 'IIprOM 2019', '1964-01-01', 2, 347326, 462664, 54.057220, -2.806148, 'Park', '', '1964-01-01', ''),
(46, 'Salt Ayre', 'Lancaster City Council', NULL, '1964-01-01', 2, 346311, 462356, 54.054352, -2.821598, 'Park', 'Urban', '1964-01-01', ''),
(47, 'Silverhelme', NULL, 'ISOM 2000', '1964-01-01', 4, 347179, 475304, 54.170799, -2.810612, 'Forest', '', '1964-01-01', ''),
(48, 'Burtom Well', NULL, 'ISOM 2000', '1964-01-01', NULL, 346995, 475235, 54.170158, -2.813423, 'Forest', '', '1964-01-01', ''),
(49, 'Simpson Ground', NULL, 'ISOM 2019', '1964-01-01', 5, 339151, 486469, 54.270237, -2.935839, 'Forest', 'Moorland', '1964-01-01', ''),
(50, 'Sizergh', NULL, 'ISOM 2017', '1964-01-01', 4, 349616, 488227, 54.287174, -2.775464, 'Forest', 'Park', '1964-01-01', ''),
(51, 'Stanley Park', 'Blackpool Council', 'ISSprOM 2019', '1964-01-01', 2, 332656, 435987, 53.815781, -3.024330, 'Park', '', '1964-01-01', ''),
(52, 'Traitors Gill', NULL, 'ISOM 2017', '1964-01-01', 4, 356766, 463816, 54.068455, -2.662125, 'Moorland', 'Forest', '1964-01-01', ''),
(53, 'Sharoe Brook', NULL, 'ISOM 2000', '1964-01-01', 3, 351885, 432632, 53.787773, -2.731776, 'Park', '', '1964-01-01', ''),
(54, 'Ulpha Fell', NULL, 'ISOM 2017', '1964-01-01', 4, 345018, 482045, 54.231148, -2.844944, 'Forest', '', '1964-01-01', ''),
(55, 'Wellington Wood', NULL, 'ISOM 2017', '1964-01-01', 4, 351174, 454536, 53.984558, -2.746067, 'Forest', '', '1964-01-01', ''),
(56, 'Whitbarrow Scar', NULL, 'ISOM 2000', '1964-01-01', 5, 344600, 487248, 54.277855, -2.852325, 'Forest', 'Moorland', '1964-01-01', 'To be remapped by Martin Bagness 2021'),
(57, 'White Coppice', NULL, 'ISOM 2017', '1964-01-01', 4, 362803, 420525, 53.679855, -2.564621, 'Forest', 'Moorland', '1964-01-01', ''),
(58, 'Williamson Park', NULL, 'ISSprOM 2019', '1964-01-01', 3, 348899, 461353, 54.045593, -2.781901, 'Park', '', '1964-01-01', ''),
(59, 'Witherslack', NULL, 'ISOM 2017', '1964-01-01', 5, 343231, 486411, 54.270187, -2.873182, 'Forest', 'Moorland', '1964-01-01', ''),
(60, 'Worden Park', NULL, 'ISSprOM 2019', '1964-01-01', 2, 353623, 421051, 53.683849, -2.703667, 'Park', '', '1964-01-01', ''),
(61, 'Yarrow Valley', NULL, 'ISOM 2017', '1964-01-01', 3, 357000, 414900, 53.628853, -2.651682, 'Park', 'Forest', '1964-01-01', ''),
(62, 'Low Park Wood', NULL, 'ISOM 2017', '2019-01-01', 4, 350737, 488061, 54.285797, -2.758212, 'Forest', '', '1018-01-01', ''),
(63, 'Clayton le Woods', NULL, NULL, '1964-01-01', 2, 358700, 422200, 53.694599, -2.626951, 'Urban', '', '1964-01-01', ''),
(64, 'Grange Park', NULL, NULL, '1964-01-01', NULL, 357219, 431529, 53.778328, -2.650666, 'Park', '', '1964-01-01', ''),
(65, 'Ashton', NULL, NULL, '1964-01-01', NULL, 351800, 431200, 53.774891, -2.732846, '', '', '1964-01-01', ''),
(66, 'Blackpool North', NULL, NULL, '1964-01-01', 2, 332000, 438100, 53.834686, -3.034763, 'Urban', '', '1964-01-01', ''),
(67, 'Carnforth', NULL, NULL, '1964-01-01', 2, 349889, 470486, 54.127769, -2.768297, 'Urban', '', '1964-01-01', ''),
(68, 'horley', NULL, NULL, '1964-01-01', 2, 358300, 417600, 53.653225, -2.632388, 'Urban', '', '1964-01-01', ''),
(69, 'Clarkes Lot', NULL, 'ISOM 2000', '1964-01-01', 2, 346700, 474700, 54.165321, -2.817845, 'Forest', '', '1964-01-01', ''),
(70, 'Clitheroe', NULL, NULL, '1964-01-01', 2, 374200, 442100, 53.874454, -2.393889, 'Urban', '', '1964-01-01', ''),
(71, 'Cottam', NULL, NULL, '1964-01-01', 2, 350400, 432300, 53.784649, -2.754264, 'Urban', '', '1964-01-01', ''),
(72, 'Freckleton & Warton', NULL, NULL, '1964-01-01', 2, 343100, 429200, 53.756039, -2.864471, '', '', '1964-01-01', ''),
(73, 'Fulwood Wes', NULL, NULL, '1964-01-01', 2, 352100, 430900, 53.772224, -2.728248, 'Urban', '', '1964-01-01', ''),
(74, 'Garstang & Catterall', NULL, NULL, '1964-01-01', 2, 349100, 446700, 53.913933, -2.776385, '', '', '1964-01-01', ''),
(75, 'Helmshore', NULL, NULL, '1964-01-01', 2, 379300, 422000, 53.694031, -2.314965, 'Urban', '', '1964-01-01', ''),
(76, 'Hest Bank & Bolton Le Sands', NULL, NULL, '1964-01-01', 2, 348000, 467500, 54.100750, -2.796693, 'Urban', '', '1964-01-01', ''),
(77, 'Kirkham', NULL, NULL, '1964-01-01', 2, 342300, 432100, 53.782013, -2.877147, 'Urban', '', '1964-01-01', ''),
(78, 'Lancaster Centre & North', NULL, NULL, '1964-01-01', 2, 348800, 463600, 54.065781, -2.783799, 'Urban', '', '1964-01-01', ''),
(79, 'Lancaster South', NULL, NULL, '1964-01-01', 2, 348100, 460900, 54.041447, -2.794031, 'Urban', '', '1964-01-01', ''),
(80, 'Helmshore ', NULL, NULL, '1964-01-01', 2, 379300, 422000, 53.694031, -2.314965, 'Urban', '', '1964-01-01', ''),
(81, 'Hest Bank & Bolton Le Sands', NULL, NULL, '1964-01-01', 2, 348000, 467500, 54.100750, -2.796693, 'Urban', '', '1964-01-01', ''),
(82, 'Kirkham', NULL, NULL, '1964-01-01', 2, 342300, 432100, 53.782013, -2.877147, 'Urban', '', '1964-01-01', ''),
(83, 'Lancaster Wes', NULL, NULL, '1964-01-01', 2, 347200, 462400, 54.054836, -2.808034, 'Urban', '', '1964-01-01', ''),
(84, 'Leyland ', NULL, NULL, '1964-01-01', 2, 352900, 422000, 53.692310, -2.714752, 'Urban', '', '1964-01-01', ''),
(85, 'Longridge', NULL, NULL, '1964-01-01', 2, 361900, 437400, 53.831455, -2.580372, 'Urban', '', '1964-01-01', ''),
(86, 'Longsands with Fulwood', NULL, NULL, '1964-01-01', 2, 355700, 432400, 53.786022, -2.673847, 'Urban', '', '1964-01-01', ''),
(87, 'Lytham', NULL, NULL, '1964-01-01', 2, 334500, 427600, 53.740646, -2.994546, '', '', '1964-01-01', ''),
(88, 'Morecambe', NULL, NULL, '1964-01-01', 2, 344600, 464900, 54.077030, -2.848204, 'Urban', '', '1964-01-01', ''),
(89, 'Penwortham', NULL, NULL, '1964-01-01', 2, 353800, 426500, 53.732834, -2.701797, 'Urban', '', '1964-01-01', ''),
(90, 'Poulton Le Fylde', NULL, NULL, '1964-01-01', 2, 334800, 439000, 53.843132, -2.992415, 'Urban', '', '1964-01-01', ''),
(91, 'Sharpes Lot', NULL, NULL, '1964-01-01', 2, 346500, 474700, 54.165298, -2.820907, 'Urban', '', '1964-01-01', ''),
(92, 'Silverdale Playing Field', NULL, NULL, '1964-01-01', NULL, 346100, 475800, 54.175140, -2.827230, 'Park', '', '1964-01-01', ''),
(93, 'Silverdale Primary School', NULL, NULL, '1964-01-01', 1, 346200, 475500, 54.172455, -2.825645, 'School', '', '1964-01-01', ''),
(94, 'St Annes', NULL, NULL, '1964-01-01', 2, 334600, 427300, 53.737965, -2.992967, 'Urban', '', '1964-01-01', ''),
(95, 'Thornton', NULL, NULL, '1964-01-01', 2, 332800, 442500, 53.874329, -3.023573, 'Urban', '', '1964-01-01', ''),
(96, 'Whalley', NULL, NULL, '1964-01-01', 2, 373300, 436200, 53.821381, -2.407062, 'Urban', '', '1964-01-01', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `AREAS`
--
ALTER TABLE `AREAS`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `AREAS`
--
ALTER TABLE `AREAS`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
