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

Author Exporting latitude longitude data of mines
BPEART

Joined: 26/03/2019

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 26/03/2019 14:39:09
Reply |  Quote
Hi - I am undertaking a project at the moment using GIS, and was wondering if anyone knew how to export the lat/long data of mines onto an excel csv file? IP: 131.111.5.130
John_Smith

Avatar of John_Smith

Joined: 09/07/2017
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 26/03/2019 19:10:13
Reply |  Quote
I dabble in some GIS through work.

Are you asking how to export the lat and long for all of the mines that exist on AditNow?
IP: 86.147.76.33
BPEART

Joined: 26/03/2019

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 26/03/2019 20:19:19
Reply |  Quote
Yes, I’m trying to open the location of coal mines in QGIS through exporting lat and long data. I need this for the South Wales region (Merthyr Tydfil, Rhondda, Cardiff and Vale of Glamorgan). I know each site has a lat and long specified but was wondering if there was a quicker way than copying all of them out? IP: 131.111.5.182
rikj

Avatar of rikj

Joined: 27/12/2008

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 26/03/2019 21:22:39
Reply |  Quote
Can we ask the nature of the project, academic, personal, commercial etc?

I think the forum owner is the only person who could answer your question, certainly with regard to any technical, ownership or copyright issues.

The mine locations have been added by individual members, and I suspect most were entered using a six figure National Grid Reference. I've certainly never used latitude/longitude directly. My uninformed guess is that the latitude/longitude displayed in the database entry will refer to a point on one corner of the 100m square covered by the 6 figure NGR.

As you only want coal mines have you looked at the metadata held by the Coal Authority?

https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/361710/Mine_Entry_Metadata_V4.pdf

Access and use conditions say it is free of charge.




IP: 86.169.13.42 Edited: 26/03/2019 21:24:13 by rikj
BPEART

Joined: 26/03/2019

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 27/03/2019 09:41:35
Reply |  Quote
It is for an academic project - part of my degree. It won't be published. I have been in touch with the Coal Authority but was just wondering if you had available data. No problem though. Thanks for your help
IP: 131.111.5.163
John_Smith

Avatar of John_Smith

Joined: 09/07/2017
Location: North Wales

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 27/03/2019 11:13:32
Reply |  Quote
The Coal Authority are who you want. They have shapefiles of all coal workings in the UK that are much more spatially accurate than the user locations on here. IP: 82.132.229.9
The Fresh Prince of Portreath

Joined: 05/08/2015

View Profile
View Posts
View Personal Album
View Personal Files
View all Photos
Send Private Message
Exporting latitude longitude data of mines
Posted: 29/03/2019 11:33:30
Reply |  Quote
Mindat is more impressive from a database point of view. Jolyon is the chap you need to contact. IP: 194.35.116.94
Safety LED Miners Caplamps 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