Mine exploration, photographs and mining history for mine explorers, industrial archaeologists, researchers and historians Mine explorer and mining history videos on YouTube Connect with other mine explorers on Facebook
Tip: do not include 'mine' or 'quarry', search by name e.g. 'cwmorthin', use 'Sounds like search' if unsure of spelling

Advanced Search
'Sounds like search'
Quick a b c d e f g h i j k l m n o p q r s t u v w x y z
Tip: narrow down your search by typing more than one word and selecting 'Search for all words' or 'Exact search'

Search for any word
Search for all words
Exact search
Tip: narrow down your search by typing more than one word and selecting 'Search for all words' or 'Exact search'

Search for any word
Search for all words
Exact search

Mine Exploration Forum

Jump to page << < 1 2 > >>
Author Quiet
LeeW

Avatar of LeeW

Joined: 28/07/2007
Location: Somewhere

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 03/08/2007 22:17:53
Reply |  Quote
Barney wrote:

im banging my head against a brick wall reading about midlands mines!

Did you know there are/were 3,024 coal mines in this country? zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz


I think there are a few 0's missing of the end of that figure

--

' Ask no questions, get no lies'
IP: 81.103.184.106
LeeW

Avatar of LeeW

Joined: 28/07/2007
Location: Somewhere

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 03/08/2007 22:24:03
Reply |  Quote
simonrl wrote:

That's a lot of coal mines Barney!

If you wanted to upload a lot (not that I'm suggesting anybody would ever want to upload 3000+ mines) I can easily write a batch import script from a spreadsheet.


What info would you want on the spreadsheet? I already have some lists at work and could easily get a list of loads of other coal mines

--

' Ask no questions, get no lies'
IP: 81.103.184.106
SimonRL

Avatar of SimonRL

Joined: 27/11/2005
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 04/08/2007 00:28:25
Reply |  Quote
Hi LeeW

The basic data for a mine is simply:

1) Name of mine

2) ID of mineral - although if a batch import of mines of a specific type was being done could be left blank and the import script modified to insert the appropriate value on the basis they were all the same mineral type

3) ID or UK region (as per this page [web link] and again I can correct/map the data at import time)

4) (optional) Landranger grid reference, however mines can be imported without this information

That's the base information required, and the import scripts create the mines, credit them automatically to the person who provided the data, and create the User and Archive photograph albums automatically.

I can provide a standard spreadhseet to anybody as required, and modify provided data to work with the import process Smile The mine is then ready to take photograph and document submissions.

Once a mine is in place, any regional editor can edit the description if required and tag the mine to a forum area.

--

Next time look where you're going (Miles)
IP: 83.148.135.213
LeeW

Avatar of LeeW

Joined: 28/07/2007
Location: Somewhere

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 04/08/2007 08:51:16
Reply |  Quote
Thanks for that, luckily the database at work includes region and NGR, I assume you'll need sheet letters and 6 fig reference seperately.
If I get time, i'll dig out various spreadsheets next week at work, then add some others I know about

--

' Ask no questions, get no lies'
IP: 81.103.184.106
SimonRL

Avatar of SimonRL

Joined: 27/11/2005
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 04/08/2007 20:08:15
Reply |  Quote
That's brilliant, thanks.

Regarding the NGR, it can either be sheet and 6 figures separately or combined, I can tell the script to handle it either way.

Cheers,
Simon

--

Next time look where you're going (Miles)
IP: 83.148.135.213
Barney

Avatar of Barney

Joined: 01/12/2005
Location: Warwickshire

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 07/08/2007 05:57:49
Reply |  Quote
Simon, can you e mail me said spreadsheet pleeez? cheers.

--

Can i have a fag in here?
IP: 212.137.45.109
SimonRL

Avatar of SimonRL

Joined: 27/11/2005
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/08/2007 16:16:53
Reply |  Quote
Will do good sir Smile

Will some time next week be OK? I want to do some thorough tests with it, and checking for duplicates (i.e. already in the database) before running it against the live site in case I break anything Shocked

--

Next time look where you're going (Miles)
IP: 83.148.135.213
SimonRL

Avatar of SimonRL

Joined: 27/11/2005
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 21:10:54
Reply |  Quote
Terribly quiet over the past few days, feel like I've been talking to myself Crying

Guess everybody is down holes in the ground.

--

'It may have been an adit once, but it is not an adit... now'
IP: 62.136.227.28
Captain Scarlet

Avatar of Captain Scarlet

Joined: 07/03/2007
Location: The Cumbrian Underground

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 21:15:54
Reply |  Quote
Quite the opposite for me actually.. I finally got to go up in the glider !!!

--

' ...they passed therein with fear and trembling for the rocks were high above their heads and great stones lay around... '
IP: 81.153.33.145 Edited: 08/09/2007 21:19:51 by Captain Scarlet
Wenders

Avatar of Wenders

Joined: 30/06/2007
Location: On the computer

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 21:22:19
Reply |  Quote
Nimrod dragged me up a mountain today Roll Eyes IP: 81.153.33.145 Edited: 08/09/2007 21:23:20 by Wenders
Captain Scarlet

Avatar of Captain Scarlet

Joined: 07/03/2007
Location: The Cumbrian Underground

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 21:22:54
Reply |  Quote
Wenders wrote:

Nimrod dragged me up a mountain today Roll Eyes


And back down again.. Laugh Laugh

--

' ...they passed therein with fear and trembling for the rocks were high above their heads and great stones lay around... '
IP: 81.153.33.145
Wenders

Avatar of Wenders

Joined: 30/06/2007
Location: On the computer

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 21:27:20
Reply |  Quote
Nimrod wrote:

Quite the opposite for me actually.. I finally got to go up in the glider !!!


The instructor pilot with Nimrod said he would push him out if I paid him £5.00.........I said if he did that I would give him £50.00 Laugh
IP: 81.153.33.145
Clunk

Avatar of Clunk

Joined: 20/01/2007
Location: Cornwall

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 08/09/2007 22:15:36
Reply |  Quote
Wenders wrote:

Nimrod wrote:

Quite the opposite for me actually.. I finally got to go up in the glider !!!


The instructor pilot with Nimrod said he would push him out if I paid him £5.00.........I said if he did that I would give him £50.00 Laugh
Thats not nice....
I would post more, but I don't want to get told off for going off topic on another forum.


--

I like the darkness, the timewarp and the solitude of exploring underground. Seeing the tools that were left as if the workman has just clocked off. Knowing that I am one of a few that will ever see the history, stagnant and untouched. The history in a crane, the skill of cutting the rock. The awe of huge man made caverns. It is a lost world and I am walking through it.
IP: 80.42.208.152 Edited: 08/09/2007 22:17:38 by Clunk
Wormster

Avatar of Wormster

Joined: 15/08/2006
Location: Top of the Mendip Hills

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 09/09/2007 20:01:23
Reply |  Quote
Been down in deepest darkest kent, playing with chainsaws, lighting bonfires in the dark and learning how to reverse a tractor mower and trailer..........all bloddy good fun Shocked Shocked

--

Better to regret something you have done - than to regret something you have not done.
IP: 86.142.255.190
Barney

Avatar of Barney

Joined: 01/12/2005
Location: Warwickshire

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 10/09/2007 10:51:43
Reply |  Quote
On the surface Wormster??? Shocked IP: 86.129.245.169
Wormster

Avatar of Wormster

Joined: 15/08/2006
Location: Top of the Mendip Hills

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Quiet
Posted: 10/09/2007 18:08:02
Reply |  Quote
All surface working unfunortunatly Barney,

Tho next time I'm in Kent underground exploration WILL happen. Thumb Up

--

Better to regret something you have done - than to regret something you have not done.
IP: 81.132.98.201
Jump to page << < 1 2 > >>
Moore Books: Specialist Books I.A. Recordings: Mining and Industrial History DVDs Starless River - Caving Store Explore a Disused Welsh Slate Mine
Disclaimer: Mine exploring can be quite dangerous, but then again it can be alright, it all depends on the weather. Please read the proper disclaimer.
© 2005 to 2015 AditNow.co.uk
Top of Page