Grid-ref parser (bulk)

<!DOCTYPE html> <html lang="en"> <head> <title>Grid-ref parser (bulk)</title> <meta name="viewport" content="width=device-width, user-scalable=no"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><META name="description" content=""> <link rel="STYLESHEET" type="text/css" href="https://staticdatabase.bsbi.org/yui/build.2.9.0/reset/reset-min.css"><link rel="STYLESHEET" type="text/css" href="https://staticdatabase.bsbi.org/yui/build.2.9.0/fonts/fonts-min.css"><link rel="STYLESHEET" type="text/css" href="/css/autocomplete.css"><link rel="STYLESHEET" type="text/css" href="https://staticdatabase.bsbi.org/css/yuicss/menu.css"><link rel="STYLESHEET" type="text/css" href="https://staticdatabase.bsbi.org/css/bsbidb.034.css"><link rel="STYLESHEET" type="text/css" href="/css/fontawesome.css"><link rel="STYLESHEET" type="text/css" href="/css/solid.css"><link rel="STYLESHEET" type="text/css" href="/css/regular.css"><script type="text/javascript" src="https://staticdatabase.bsbi.org/yui/build.2.9.0/yahoo-dom-event/yahoo-dom-event.js"></script><script type="text/javascript" src="https://staticdatabase.bsbi.org/yui/build.2.9.0/datasource/datasource-min.js"></script><script type="text/javascript" src="https://staticdatabase.bsbi.org/yui/build.2.9.0/autocomplete/autocomplete-min.js"></script><script type="text/javascript" src="/js/container_patched-min.js"></script><script type="text/javascript" src="https://staticdatabase.bsbi.org/yui/build.2.9.0/menu/menu-min.js"></script><script type="text/javascript" src="https://staticdatabase.bsbi.org/js/bsbidb_common.098b.js"></script><script type="text/javascript" src="/js/gridrefparserform.005.js"></script><script type="text/javascript">try { //YAHOO.util.Event.onDOMReady(function () { document.addEventListener("DOMContentLoaded", (event) => { try { var oMenuBar = new YAHOO.widget.MenuBar("topmenubar"); oMenuBar.render(); document.getElementById("topmenubar").style.position="relative"; } catch (e) { e.message += " while initialising menu bar (inner)"; throw e; } }, {once: true}); } catch (e) { e.message += " while initialising menu bar (outer)"; throw e; } var scriptUrl = window.location.protocol + "//database.bsbi.org/";var uid = BsbiDb.uid = null;</script>  <script async src="https://www.googletagmanager.com/gtag/js?id=UA-46443495-1"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-46443495-1'); gtag('config', 'G-893ZP3CW9G'); </script> </head> <body class="yui-skin-sam"> <div id="bodycontent">  <div id="headerbarwidget"> <div> <div class="headerbarright" id="loginpanel"><UL class="headerlinks headerrhslinks"><LI><a href='/help.php'>help</a> </LI><LI><a href='/gridrefparser.php?login'>login</a> </LI><LI><a href='/createuser.php'>register</a></LI></UL></div><a href="https://bsbi.org/" title="Botanical Society of Britain and Ireland" style="position: absolute; top: 0px; left: 4px;"><img src="https://staticdatabase.bsbi.org/img/icons/BSBI_long.svg" alt="BSBI" width="189" height="64"/></a> <span style="position: relative; left: 212px; top: -8px;"><a class="headerwidgettitle" href="/">Distribution Database</a> > Grid-ref parser (bulk)</span> </div> <div id="topmenubar" class="yuimenubar yuimenubarnav" style="position: relative; display: none; z-index: 5; margin-left: 212px;"> <div class="bd"> <ul class="first-of-type"> <li class="yuimenubaritem first-of-type"><a class="yuimenubaritemlabel" href="#toolsmenu">Tools</a> <div id="toolsmenu" class="yuimenu"> <div class="bd"> <ul class="first-of-type"> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/checklists.php">Checklists</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/gridref.php">Grid reference lookup</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/reports/sitetaxa.php">Taxon list for a grid-square</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/datavalidation.php">Data validation</a> <div id="datavalidationmenu" class="yuimenu"> <div class="bd"> <ul class="first-of-type"> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/taxonnameparser.php">Taxon name lookup and validation</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/partynameparser.php">Name formatting (people and organisations)</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/gridrefparser.php">Grid-reference validation</a> </li> <li class="yuimenuitem"> <a class="yuimenuitemlabel" href="/dateparser.php">Date validation</a> </li><li class="yuimenuitem"><a class="yuimenuitemlabel" href="/taxondistributionchecker.php">Taxon distribution validator</a></li> </ul> </div> </div> </li> </ul> </div> </div> </li> <li style="display: none"><a class="yuimenubaritemlabel" href="#newmenu">New</a> <div id="newmenu" class="yuimenu"> <div class="bd"> <ul class="first-of-type"><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=PartyInstance' title=''>Party (recorder/collector/author etc.)</a></li><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=RecordInstance' title=''>Record (observation or specimen)</a></li><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=LocalityInstance' title=''>Locality (named site)</a></li><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=DataSetInstance' title=''>Data set (herbarium, collection or other collation)</a></li><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=JournalInstance' title=''>Publication (book, periodical etc.)</a></li><li class='yuimenuitem'><a class='yuimenuitemlabel' href='/editor.php?class=ReferenceInstance' title=''>Reference (a reference to a publicaton or other source)</a></li></ul> <ul>  <li class='yuimenuitem'> <a class='yuimenuitemlabel' href='/createchecklist.php' title=''> Checklist or attribute set</a> </li> </ul> </div> </div> </li> <li><a href="/maps/" title="Taxon distribution maps drawn using data from the BSBI Atlas or the DDb">maps</a></li> <li><a href="/search.php" title="">search</a></li> <li style="display: none"><a href="/myrecords.php" title="">my records</a></li> <li style="display: none"><a href="/searchhistory.php">search history</a></li> <li><a href="/forum/" title="">message board</a></li> <li style="display: none"><span style="border-bottom: none; border-top: none; display: none;" id="versionwidget"> <a href="/workspace.php" class="linknovisit">workspace</a>: </span></li> </ul> </div> </div> </div> <script type="text/javascript">document.addEventListener("DOMContentLoaded", (event) => {try {workspaceVersion.build_version_widget("versionwidget", "0.1", "c");workspaceVersion.version_conflict_banner("headerbarwidget");} catch (e) {e.message += " while initialising workspace"; throw e;}}, {once: true});</script> <h3>Gridref parser</h3> <p>Upload a delimited file containing a column of grid-references. Output consists of the uploaded file with additional columns showing the formatted gridref and corresponding vice-county and highlighting problems.</p> <br /> <form action="/gridrefparserCSV.php" method="POST" enctype="multipart/form-data" target="_blank"> <table> <tr><th style="text-align: right; padding-right: 1em;"><label for="recordsfile">file</label></th><td><input type="file" id="recordsfile" name="recordsfile" /></td><td>required, comma or tab-delimited text file</td></tr> <tr><th style="text-align: right; padding-right: 1em;"><label for="grformat">format of references</label></th><td> <select name="grformat" id="grformat"> <option value="gr" selected='selected'>grid-reference (square)</option> <option value="grcentroid">grid-reference (centroid)</option> <option value="gbcoords">Easting/Northing co-ordinates (GB)</option> <option value="sqrelcoords">Easting/Northing co-ordinates relative to 100km square</option> <option value="latlng">Lat/Lng centroid (WGS84 projection)</option> <option value="itm">Irish Transverse Mercator (ITM)</option> </select> </td><td></td></tr> <tr id="grcolrow"><th style="text-align: right; padding-right: 1em;"><label for="grcol">column number for grid-refs</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="grcol" name="grcol" value="0" required="required" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="sqcolrow"><th style="text-align: right; padding-right: 1em;"><label for="sqcol">column number for 100km square</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="sqcol" name="sqcol" value="" required="required" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="ecolrow"><th style="text-align: right; padding-right: 1em;"><label for="ecol">column number for eastings</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="ecol" name="ecol" value="" required="required" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="ncolrow"><th style="text-align: right; padding-right: 1em;"><label for="ncol">column number for northings</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="ncol" name="ncol" value="" required="required" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="latdcolrow"><th style="text-align: right; padding-right: 1em;"><label for="latdcol">column number for latitude (degrees)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="latdcol" name="latdcol" value="" required="required" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="latmcolrow"><th style="text-align: right; padding-right: 1em;"><label for="latmcol">column number for latitude (minutes)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="latmcol" name="latmcol" value="" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>0 or A is left-most column</td></tr> <tr id="latscolrow"><th style="text-align: right; padding-right: 1em;"><label for="latscol">column number for latitude (seconds)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="latscol" name="latscol" value="" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>0 or A is left-most column</td></tr> <tr id="lngdcolrow"><th style="text-align: right; padding-right: 1em;"><label for="lngdcol">column number for longitude (degrees)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="lngdcol" name="lngdcol" value="" required="required" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="lngmcolrow"><th style="text-align: right; padding-right: 1em;"><label for="lngmcol">column number for longitude (minutes)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="lngmcol" name="lngmcol" value="" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>0 or A is left-most column</td></tr> <tr id="lngscolrow"><th style="text-align: right; padding-right: 1em;"><label for="lngscol">column number for longitude (seconds)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="lngscol" name="lngscol" value="" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>0 or A is left-most column</td></tr> <tr id="lngorientationcolrow"><th style="text-align: right; padding-right: 1em;"><label for="lngorientationcol">column number for longitude orientation (E|W)</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="lngorientationcol" name="lngorientationcol" value="" placeholder="column letter or number (0 or A is left-most)"/></td><td>0 or A is left-most column</td></tr> <tr id="countrycolrow"><th style="text-align: right; padding-right: 1em;"><label for="countrycol">column number for country</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="countrycol" name="countrycol" value="" required="required" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr id="diametercolrow"><th style="text-align: right; padding-right: 1em;"><label for="diametercol">column number for centroid diameter</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="diametercol" name="diametercol" value="" required="required" min="0" placeholder="column letter or number (0 or A is left-most)"/></td><td>required, 0 or A is left-most column</td></tr> <tr><th style="text-align: right; padding-right: 1em;"><label for="vcbias">vice-county bias</label></th><td><input type="text" id="vcbias" name="vcbias" value="" placeholder="expected vc code (optional)"/></td><td></td></tr> <tr id="vccolrow"><th style="text-align: right; padding-right: 1em;"><label for="vccol">column number for VC bias</label></th><td><input type="text" pattern="([A-Za-z]+|\d+)?" id="vccol" name="vcbiascol" value="" placeholder="column letter or number (0 is left-most)"/></td><td></td></tr> <tr><th style="text-align: right; padding-right: 1em;"><label for="insep">input file delimiter</label></th><td> <select id="insep" name="insep"> <option value="tab">tab-delimited (TSV)</option> <option value="comma">comma-delimited (CSV)</option> </select></td><td></td></tr> <tr><th style="text-align: right; padding-right: 1em;"><label for="outputformat">output file-format</label></th><td><select id="outputformat" name="format"><option value='csv' selected>tab or comma-separated-variables (.csv)</option><option value='xlsx'>Microsoft Excel spreadsheet (.xlsx)</option><option value='ods'>Open document spreadsheet, for LibreOffice etc. (.ods)</option><option value='html'>HTML table (.html)</option></select></td><td></td></tr> <tr style="padding-top: 1em"><th style="text-align: right; padding-right: 1em;" rowspan="3">optional output columns</th> <td><label><input type="checkbox" name="showquadrant" value='1'/> include quadrant column (<em>only if co-ordinates are exact multiple of 5km</em>)</label></td><td></td></tr> <td><label><input type="checkbox" name="coordssw" value='1'/> easting/northing (metre co-ordinates) of grid-square SW corner</label></td><td></td></tr> <td><label><input type="checkbox" name="coordscentroid" value='1'/> easting/northing (metre co-ordinates) of grid-square centre point</label></td><td></td></tr> <tr> </table> <br /> <input type="submit" id="submit" value="send"/> </form> <br /> <p>Processing of large files may take a few minutes, if this causes problems with your connection then please contact <a href="mailto:tom.humphrey@bsbi.org">Tom</a>, who can run the command-line version of this page</p> <script> (function () { var bulkParserForm = BsbiDb.GridrefParserForm.initialise(); })(); </script> </div> <div id='browserversion' style="display: none;"></div> </body>  </html>

CINXE.COM

Grid-ref parser (bulk)