Borehole Location Plan

Upload your base map and Excel file, enter the two corner coordinates, and generate a PDF map of borehole locations.

1. Base Map Base map (PNG/JPG)

Large images are fine; the PDF will match the image pixel size.

2. Excel File Excel file (.xlsx / .xls) Worksheet name (optional)

If left blank, the app will try Sheet1 and then fall back to the first sheet. You may also input specific sheet name.

Required columns: Easting, Northing, BoreholeID, Remark, CompletionDate, LocationID.

3. Corner Coordinates (Easting, Northing) of the uploaded image

Mapping assumed: (minE, minN) → bottom-left | (maxE, maxN) → top-right

Bottom-left coordinates of the uploaded image

Easting (minE) Northing (minN)

Bottom-right coordinates of the uploaded image

Easting (maxE) Northing (maxN)

4. Symbol & Legend Settings

Symbols

Dot size (points) Label font size (pt) Label colour

Label offset X (px)

Label offset Y (px)

Positive Y moves label downwards (PDF/image pixel space).

Legend

Legend title Legend size (pt)

Red label Orange label Green label Blue label

These labels appear next to coloured dots in the legend.

5. Output Settings Output PDF filename Legend date (for map title)

If left blank, today's date will be used.

Show legend block Show labels next to dots Show latest results only

OpenGTi - Open Geotechnical Intelligence