File input templates

Default template

Site name

Any name you like — it just labels the job on your job history page and in downloads. It doesn't need to match anything in your files.

Coordinates

A CSV file (comma-delimited) with one row per boring. Only these columns are read: boring_id, easting_m, northing_m, crs, and, optionally, ground_surface_elev_ft. Extra columns (like total_depth_ft, push_date, and notes in the example below) are ignored.

The ground_surface_elev_ft column is optional, and its values aren't used in any output yet: depths are measured from each boring's own ground surface, and the 3D view, 2D view and volumes treat the ground as flat. If you include it, its values must be numbers or blank.

crs names the coordinate reference system your easting_m/northing_m values are in, as an EPSG code in the form EPSG:#### — it must be a real, projected CRS (not latitude/longitude) whose units are meters, such as a State Plane zone or a UTM zone. Every row in the file must use the same CRS — a job can't mix coordinates from two different systems. Not sure of your survey's EPSG code? Look it up at the official EPSG Geodetic Parameter Dataset registry.

boring_id easting_m northing_m crs ground_surface_elev_ft total_depth_ft push_date notes
SB-01421406.711206859.74EPSG:6396652.824.02026-03-11site perimeter, background (NW)
SB-02421430.481206845.72EPSG:6396651.628.02026-03-11source-area push, LNAPL smear zone expected near water table
SB-03421427.431206825.91EPSG:6396651.020.02026-03-11downgradient push, rod-connection gap ~10-11.5 ft bgs
SB-04421454.251206857.91EPSG:6396653.122.02026-03-11site perimeter, background (NE)
SB-05421402.441206809.14EPSG:6396650.423.02026-03-12site perimeter, background (SW)
SB-06421459.131206814.63EPSG:6396650.921.52026-03-12site perimeter, background (SE)
SB-07421434.141206864.62EPSG:6396652.925.02026-03-12site perimeter, background (N)
SB-08421433.531206803.05EPSG:6396650.622.52026-03-12site perimeter, background (S)
SB-09421435.051206835.97EPSG:6396651.326.02026-03-13interior push, near-source transitional response
SB-10421428.961206815.24EPSG:6396650.724.02026-03-13interior push, far-downgradient trace response near plume edge

Example CSV format. Only the required columns listed above are read, others are ignored.

Boring logs

One CSV file (comma-delimited) per boring. Name each file to match its Boring ID in the coordinates CSV above (e.g. SB-01.txt for boring SB-01), exactly, including upper/lower case. Every log file needs a row in the coordinates CSV, and every row needs a log file; an upload where they don't pair up is rejected with a list of the names that don't match. Only these columns are read: depth_ft, pct_re, ch1_pct, ch2_pct, ch3_pct, ch4_pct. depth_ft is depth below ground surface in feet. pct_re is the total %RE, and ch1_pct to ch4_pct are each channel's own %RE, so the four add up to pct_re. Extra columns (like rate_ft_min, ec_depth_ft, ec_ms_m, and hammer_bpf in the example below) are ignored.

depth_ft pct_re ch1_pct ch2_pct ch3_pct ch4_pct rate_ft_min ec_depth_ft ec_ms_m hammer_bpf
0.03.350.691.890.440.332.360.157.210.6
0.053.820.661.441.550.182.150.218.37.1
0.13.330.761.221.060.282.220.2514.920.5
0.151.70.151.080.250.212.20.35.511.8
0.23.911.062.260.260.322.220.3516.68.7
0.253.450.681.760.740.262.290.45.917.6
0.32.460.820.730.760.161.980.4520.67.9
..............................

Example CSV format. Only the required columns listed above are read, others are ignored.

Site image (optional)

A georeferenced site image (e.g. a satellite photo or site plan), shown as a ground-level reference layer in the 3D view and under the 2D view. Any coordinate reference system is fine, it's reprojected automatically into whichever CRS your coordinates file above declares. Up to 250 MB; large images are downsampled for display. Not required for job submission. Cannot be added to jobs after they have been run.

Either upload a georeferenced TIFF/GeoTIFF on its own, or select a JPG, PNG or TIFF together with the GIS files that come with it: its world file (e.g. site.jgw for site.jpg) and its site.jpg.aux.xml or site.prj, which says which coordinate system it's in. Keep the names your GIS gave them, since they're matched by name. An ArcGIS metadata file (site.jpg.xml) can be included and is ignored.

Dakota OST template

For UVOST logs exported from Dakota Technologies' OST software, choose Dakota OST export in the Template picker and upload each boring's .lif.dat.txt file as it is, with or without its header row. The boring ID is the part of the file name before .lif.dat.txt (e.g. UV-01.lif.dat.txt for boring UV-01), and it must match a row in the coordinates CSV, which uses the same layout as the Default template above.

These exports don't record whether depth is in feet or meters, so the form asks for the depth unit. To have it checked, also select each boring's .lif.raw.bin file along with the logs: its header records the unit the logs were taken in, and an upload where it doesn't match the unit you chose is rejected. The .lif.raw.bin files are only read for that check.

Total %RE comes from the Signal column, and the four channels from Ch1 to Ch4. The EC and hammer columns aren't read, since the export writes zeros in them when no EC probe or hammer was logged.

Custom templates

The Default and Dakota OST templates above cover the standard file layouts for boring logs, coordinates, and a site image. If your organization's own files use a different layout, we can build a custom template matched to your exact format, covering all three file types together. Once set up, it appears as an additional option in the Template picker on the upload form.

Custom templates are available directly from lif-viz — contact us to have one built for your organization.

← Back to upload form