Exhibit_C-LinkoPipe_EDD_Specification_2011_Format.pdf

PDF 557 KB Posted Jul 7, 2023

Attached to: Analytical Lab Services
Solicitation number: IFB23-0336
Issued by: Orange County, Orlando City, Florida

About this file

Written by GovTribe AI · Jun 27, 2025

This document is a LinkoPipe Electronic Data Import (EDD) LIMS Export File Specification created by Linko Technology Inc. for standardizing laboratory data import processes, specifically designed for the City of Orlando, Florida. The specification provides a comprehensive template for laboratories to export analytical testing results in a consistent, structured format across 23 distinct data fields, including project identification, sample details, collection methods, analyte results, and metadata. The document outlines precise requirements for file formatting, acceptable data types, and field sizes, with an emphasis on capturing essential information such as sample identification, date and time of sampling, analytical methods, results, reporting limits, and detection limits.

The specification supports multiple file formats including MS Excel, CSV, and Microsoft Access, with strict guidelines for data entry and presentation. Key technical details include valid result value formats (numeric, non-detect, not analyzed), differences between reporting limits and method detection limits, and specific examples of data import using sample laboratory test results for metals, chemical oxygen demand, and mercury testing. The document is copyright 2004 by Linko Data Systems, Inc., and provides a standardized approach to electronically transferring laboratory analytical data, ensuring consistency and clarity in environmental monitoring and reporting processes.

View the file

Other files

File	Type	Posted
Analytical_Lab_Services_(Addendum_#3_Revision).pdf	PDF	Aug 28, 2023
Exhibit_E-NELAP_(National_Environmental_Laboratory_Accreditation_Program).pdf	PDF	Jul 13, 2023
Exhibit_D-State_of_Florida_Department_of_Health,_Bureau_of_Public_Health_Laboratories.pdf	PDF	Jul 13, 2023
Exhibit_A-_WIN_Requirement.pdf	PDF	Jul 7, 2023
Exhibit_B-_Laboratory_Report_File_Specification_LabSync_2.0_(flat_file_).pdf	PDF	Jul 7, 2023

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

EXHIBIT “C”

LinkoPipe-EDD-Specification-2011-Format

LinkoPipe - Electronic Data Import LIMS Export File Specification (Example Provided for LinkoPipe Admin Import Spec Lab: "StandardFormat_2011")

Field Name Description Example Data Type Field Size

1) * LabProjID Industry Name and Monitoring Point OR Sampling Assistant COC# ^ Linko Industries - MP001 Text 250

2) * SampleID Sample name or COC reference, this could refere to one or more Lab Sample IDs 1st QTR Text 50

3) * DateTimeSampled ^ Date and time sample collection was started (time is optional) 12/5/2003 15:10 Date/Time

4) StopDateTimeSampled Date and time sample collection was completed (time is optional) 12/6/2003 15:00 Date/Time

5) * SampleType ^ Sample Collection Method "Grab" Text 30

6) Sampler ^ Person or Entity who collected the sample "MLC" Text 50

7) AnaDate Date sample was analyzed. 12/11/2003 Date/Time

8) * MethodID EPA analysis method name (required fields, if none, then enter 'none' or 'n/a') EPA200.7 Text 50

9) MethodDesc EPA analytical method description "Metals by ICP" Text 50

10) * Analyte Pollutant compound name "Copper" Text 50

11) * Result Analytical Result (includes "ND", "NA", "<200") See Validation Result Values below 100 Text 50

12) ResultFlag Lab flag which qualifies Result field "J", "<", etc. Text 50

13) * Units Units of measure for Result, RepLim & MDL "mg/L" Text 30

14) RepLim Reporting Limit for analyte - see discussion below 5.0 Text 50

15) MDL Method Detection Limit - see discussion below 1.0 Text 50

16) Flow ^ Measured Flow in mgd or gpd of Sample (may also import as an analyte with a result) 0.05 Text 50

17) FlowUnits ^ Indicate as gpd (gallons per day) or mgd (million gallons per day) mgd Text 50

18) LabSampID Lab Sample Name - typically the SampleID from LIMS 9612001-02 Text 50

19) LabName Lab name that produced the result "Best Analytical" Text 50

20) Analyst Lab personnel who signed for the accuracy of the result "MLC" Text 50

21) DateExported Date & Time this record was exported from the LIMS 1/15/2004 9:45 Date/Time

22) SampleComments Free form comments that show in the Sample Comments field in Linko Comments about the sample Text 1000

23) ResultComments Free form comments that show in the Result Comments field in Linko Comments about the results Text 1000

File format specification - These fields must all be included in the file, even if they are not populated by the lab. Files should be in a single MS Excel Sheet or submitted as an text file with either comma quote delimited text files (also called CSV files) or as a table in Microsoft Access. Access files should use a single table with the name: tblLinkoPipe. All files should use the column labeled "Field Name" as outlined above for the data field names and the data field names should be included in the data file's first line with every EDD. When creating an Access EDD, please note the Field Size limitations as outlined. Samples for one or more industries or samples for one or more dates may be imported at the same time. Please contact Linko for further information .

* Indicates required fields. It is strongly recommended that if data is available for the other fields it be included.

Reporting Limit (RL) and Method Detection Limit (MDL) - What is the difference between Reporting Limit (RL) and Method Detection Limit (MDL)?

The RL is the lowest concentration standard in the calibration range of each compound analyzed. This value is also the low limit for unqualified quantitative data. The MDL is determined via experimentation and verified through additional testing. This value represents the lowest concentration of each compound that can be qualitatively identified by the method in use.

Valid Result Values LinkoPipe will accept the following values for the Result field: 0.098 (any numeric value), ND (for non detect), NA (for not analyzed), >0.035 (where > is immediately followed by any numeric value - no spaces), <0.045 (where < is immediately followed by any numeric value - no spaces)

Lakewood, CO 80215 303.275.9968 Oct. 21, 2004

LinkoPipe - Electronic Data Import LIMS Export File Specification

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) 13) 14) 15) 16) 17) 18) 19) 20) 21) 22) 23)

LabProjID SampleID DateTimeSampled StopDateTimeSam pled SampleType Sampler AnaDate MethodID MethodDesc Analyte Result ResultFl ag Units RepLim MDL Flow FlowU nits LabSampID LabName Analyst DateExpor ted SampleCom ments ResultCom ments MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Lead Tot <50 mg/ll 50 1 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 Hach 8000 COD

Demand 263 mg/l 5 1 500 MGD 020315-01 Linko Lab MLC 1-Apr-03

MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 245.2

Vapor Mercury Tot 0.27 J mg/l 0.2 0.1 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Arsenic Tot <100 D mg/l 100 5 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Cadmium Tot <6 mg/l 6 0.5 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Copper Tot 50 mg/l 10 1 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 12:10 03/05/2002 16:10 Composite TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Nickel Tot <40 mg/l 40 0.5 500 MGD 020315-01 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 13:00 03/05/2002 13:00 Grab TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Silver Tot <15 mg/l 15 0.3 020315-02 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 13:00 03/05/2002 13:00 Grab TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Chromium Tot <10 mg/l 10 0.5 020315-02 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 13:00 03/05/2002 13:00 Grab TAD 27-Mar-02 EPA 200.7.9.4 ICP-AES Tot Zinc Tot 86 mg/l 5 1 020315-02 Linko Lab MLC 1-Apr-03 MP001 1st QTR 03/05/2002 13:00 03/05/2002 13:00 Flow Meter TAD 27-Mar-02 SM Standard Method Flow 0.05 mgd 020315-02 Linko Lab MLC 1-Apr-03

LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 13:30 Grab LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Lead Tot <50 mg/ll 50 1 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/07/2002 13:30 03/07/2002 13:30 Grab LL 28-Mar-02 Hach 8000 COD

Demand 257 mg/l 5 1 020315-03 Linko Lab CGW 1-Apr-03

LexLinko Inc. - MP002 1st QTR 03/07/2002 13:30 03/07/2002 13:30 Grab LL 28-Mar-02 EPA 245.2

Vapor Mercury Tot 0.21 mg/l 0.2 0.1 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 13:30 Grab LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Arsenic Tot <15 mg/l 100 5 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 13:30 Grab LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Cadmium Tot <.05 mg/l 6 0.5 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 17:30 Composite LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Copper Tot 45.6 mg/l 10 1 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 17:30 Composite LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Nickel Tot 30 mg/l 40 0.5 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 17:30 Composite LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Silver Tot <11 mg/l 15 0.3 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 17:30 Composite LL 28-Mar-02 EPA 200.7.9.4 ICP-AES Tot Chromium Tot ND mg/l 10 0.5 020315-02 Linko Lab CGW 1-Apr-03 LexLinko Inc. - MP002 1st QTR 03/06/2002 13:30 03/07/2002 17:30 Meter LL 28-Mar-02 Meter Flow 500 MGD 020315-02 Linko Lab CGW 1-Apr-03

Example LIMS Export File Requirements

This example shows what an export file might look like after exported from your LIMS. If an export file is being created as a .csv, .txt or .xls file, the first row of the file must contain the field names exactly as they appear here. Each subsequent row must contain the actual lab data. If an .xls file is being created, only one worksheet can exist in the .xls file.

If an export file is being created as a .dbf or .mdb file, only one table should exist in the database file and the table name must be tblLinkoPipe

Ideally, each export file created by the LIMS will be given a unique name, such as the date and/or time, this is not a requirement however.

9485 W. Colfax Ave, # 201

Lakewood, CO 80215 303.275.9968 Oct. 21, 2004

LabProjID SampleIDDateTimeSampStopDateTimeSa SampleType SampleAnaDate MethodID MethodDesc Analyte Result ResultUnits RepLim MDL Flow FlowUnitsLabSampID LabName Analyst DateExport SampleCommentsResultComments

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Lead Tot <50 mg/ll 50 1 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 Hach 8000 COD Chemical Oxyg 263 mg/l 5 1 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 245.2 Mercury Cold Vapor Mercury Tot 0.27 J mg/l 0.2 0.1 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Arsenic Tot <100 D mg/l 100 5 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Cadmium Tot <6 mg/l 6 0.5 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Copper Tot 50 mg/l 10 1 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 12:10 3/5/02 16:10 Composite TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Nickel Tot <40 mg/l 40 0.5 500 MGD 020315-01 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 13:00 3/5/02 13:00 Grab TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Silver Tot <15 mg/l 15 0.3 020315-02 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 13:00 3/5/02 13:00 Grab TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Chromium Tot <10 mg/l 10 0.5 020315-02 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 13:00 3/5/02 13:00 Grab TAD 3/27/2002 EPA 200.7.9.4 ICP-AES Tot Zinc Tot 86 mg/l 5 1 020315-02 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

Linko Industries - MP001 1st QTR 3/5/02 13:00 3/5/02 13:00 Flow Meter TAD 3/27/2002 SM Standard Method Flow 0.05 mgd 020315-02 Linko Lab MLC 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 13:30 Grab LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Lead Tot <50 mg/ll 50 1 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/7/02 13:30 3/7/02 13:30 Grab LL 3/28/2002 Hach 8000 COD Chemical Oxyg 257 mg/l 5 1 020315-03 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/7/02 13:30 3/7/02 13:30 Grab LL 3/28/2002 EPA 245.2 Mercury Cold Vapor Mercury Tot 0.21 mg/l 0.2 0.1 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 13:30 Grab LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Arsenic Tot <15 mg/l 100 5 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 13:30 Grab LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Cadmium Tot <.05 mg/l 6 0.5 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 17:30 Composite LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Copper Tot 45.6 mg/l 10 1 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 17:30 Composite LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Nickel Tot 30 mg/l 40 0.5 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 17:30 Composite LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Silver Tot <11 mg/l 15 0.3 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 17:30 Composite LL 3/28/2002 EPA 200.7.9.4 ICP-AES Tot Chromium Tot ND mg/l 10 0.5 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

LexLinko Inc. - MP002 1st QTR 3/6/02 13:30 3/7/02 17:30 Meter LL 3/28/2002 Flow 500 MGD 020315-02 Linko Lab CGW 4/1/2003 Comments about the sample

Comments about the result

Attachment C-LinkoPipe_EDD_Specification_2011_Format

EDD Field Definition

Example Overview

Example DataSet

Binder1.pdf

Attachment C-LinkoPipe_EDD_Specification_2011_Format

EDD Field Definition

Example Overview

Example DataSet

File details come from the government source that posted it. Updated Jun 27, 2025.