Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Action Items & Notes
| ID                                   | Type   | Project Name   | Entry Date              | Description                                                                                                                                                                                                                                              | Task Owner   | Status    | Status Description   | Due Date                | Related BDC Task   |
|:-------------------------------------|:-------|:---------------|:------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:----------|:---------------------|:------------------------|:-------------------|
| 3d6bc67b-aedf-411d-982b-93ca54ab8f5d | Note   | Airtrain       | 2019-05-28 00:00:00.000 | - Next BIM Submission: Penultimate Hotel Station Model Submission (6/3/2019) (will connect with Javier this week to understand if this is slipping)                                                                                                      | RM           | Completed | Legacy               | 2019-05-28 00:00:00.000 |                    |
|                                      |        |                |                         | - Zach is providing additional screenshots for Pset Tutorial based on feedback from Javier                                                                                                                                                               |              |           |                      |                         |                    |
| 94a935d3-1415-449c-b0e0-eae4b24324e5 | Note   | Airtrain       | 2019-05-28 00:00:00.000 | - Next BIM Submission: Penultimate Hotel Station Model Submission (6/3/2019) (will connect with Javier this week to understand if this is slipping)                                                                                                      | RM           | Completed | Legacy               | 2019-05-28 00:00:00.000 |                    |
|                                      |        |                |                         | - Zach is providing additional screenshots for Pset Tutorial based on feedback from Javier                                                                                                                                                               |              |           |                      |                         |                    |
| 6b4157f7-7fbf-4259-b759-7d31aded5da8 | Note   | Airtrain       | 2019-05-20 00:00:00.000 | Javier took care of request for Contractual Documents.                                                                                                                                                                                                   | RM           | Completed | Legacy               | 2019-05-20 00:00:00.000 |                    |
|                                      |        |                |                         | CZ provided response RE: Commissioning Maps (Submission expected on 5/17 to BIT based on AVSEC-provided schedule)                                                                                                                                        |              |           |                      |                         |                    |
|                                      |        |                |                         | Will continue to provide support re: AutoCAD files (psets & ACIS elements)                                                                                                                                                                               |              |           |                      |                         |                    |
| 31b6db65-b62c-4ca0-963a-700c08cb1b17 | Note   | Airtrain       | 2019-05-20 00:00:00.000 | Javier took care of request for Contractual Documents.                                                                                                                                                                                                   | RM           | Completed | Legacy               | 2019-05-20 00:00:00.000 |                    |
|                                      |        |                |                         | CZ provided response RE: Commissioning Maps (Submission expected on 5/17 to BIT based on AVSEC-provided schedule)                                                                                                                                        |              |           |                      |                         |                    |
|                                      |        |                |                         | Will continue to provide support re: AutoCAD files (psets & ACIS elements)                                                                                                                                                                               |              |           |                      |                         |                    |
| 42ec17a5-77f7-4d91-9a8d-d6f0f52eac61 | Note   | Airtrain       | 2019-05-13 00:00:00.000 | RM & HB met with Javier on Thursday.                                                                                                                                                                                                                     | RM           | Completed | Legacy               | 2019-05-13 00:00:00.000 |                    |
|                                      |        |                |                         | Re-iterated our requirements - RM will review ACAD models with ACIS elements this week. HB creating tutorial for adding property sets to ACAD models (Zach is testing the method).                                                                       |              |           |                      |                         |                    |
|                                      |        |                |                         | Mohammad (Arch) requested airport standards and BIMx - directed him back to team.                                                                                                                                                                        |              |           |                      |                         |                    |
| 19d58ea7-dd38-4231-8372-4b9d0bbbb941 | Note   | Airtrain       | 2019-05-13 00:00:00.000 | RM & HB met with Javier on Thursday.                                                                                                                                                                                                                     | RM           | Completed | Legacy               | 2019-05-13 00:00:00.000 |                    |
|                                      |        |                |                         | Re-iterated our requirements - RM will review ACAD models with ACIS elements this week. HB creating tutorial for adding property sets to ACAD models (Zach is testing the method).                                                                       |              |           |                      |                         |                    |
|                                      |        |                |                         | Mohammad (Arch) requested airport standards and BIMx - directed him back to team.                                                                                                                                                                        |              |           |                      |                         |                    |
| 71c4aa63-bbf7-4027-b258-b053ecf50696 | Note   | Airtrain       | 2019-05-06 00:00:00.000 | Received IFC test model from Javier EOD Friday. Reviewed model fidelity with RM & AR - currently composing feedback and best practices. Meeting with Javier w/ RM Thursday morning to walk through AutoCAD models and develop process for Revit-ization. | RM           | Completed | Legacy               | 2019-05-06 00:00:00.000 |                    |
| ad15cf25-5dc7-4727-b77b-4ccaf2decb87 | Note   | Airtrain       | 2019-05-06 00:00:00.000 | Received IFC test model from Javier EOD Friday. Reviewed model fidelity with RM & AR - currently composing feedback and best practices. Meeting with Javier w/ RM Thursday morning to walk through AutoCAD models and develop process for Revit-ization. | RM           | Completed | Legacy               | 2019-05-06 00:00:00.000 |                    |
| cac615d7-df13-42c3-a7e4-dc72e75a6fb4 | Note   | Airtrain       | 2019-04-29 00:00:00.000 | Zach is MVR-ing the AirTrain Hotel Model.                                                                                                                                                                                                                | RM           | Completed | Legacy               | 2019-04-29 00:00:00.000 |                    |
| 8b1323e7-1297-413c-ab9e-01f9eb3f9bc9 | Note   | Airtrain       | 2019-04-29 00:00:00.000 | Zach is MVR-ing the AirTrain Hotel Model.                                                                                                                                                                                                                | RM           | Completed | Legacy               | 2019-04-29 00:00:00.000 |                    |


Table: ALL BDC
| Phase #   | Project Name   | Owner   | Type   | Description   | Concat   | Start Date   | Duration   | Due Date   | Status   | Logic   | Project Acronym   | Engagement Phase   | Project Phase #   | Project Phase   |
|:----------|:---------------|:--------|:-------|:--------------|:---------|:-------------|:-----------|:-----------|:---------|:--------|:------------------|:-------------------|:------------------|:----------------|
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |
|           |                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |


Table: ALL Notes
| Project Name   | Type   | Entry Date              | Description                                                                                                                                                                                                                                              | Task Owner   | Status    | Status Description   | Due Date                | Related BDC Task   | ID                                   |
|:---------------|:-------|:------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:----------|:---------------------|:------------------------|:-------------------|:-------------------------------------|
| Airtrain       | Note   | 2019-05-28 00:00:00.000 | - Next BIM Submission: Penultimate Hotel Station Model Submission (6/3/2019) (will connect with Javier this week to understand if this is slipping)                                                                                                      | RM           | Completed | Legacy               | 2019-05-28 00:00:00.000 |                    | 3d6bc67b-aedf-411d-982b-93ca54ab8f5d |
|                |        |                         | - Zach is providing additional screenshots for Pset Tutorial based on feedback from Javier                                                                                                                                                               |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-28 00:00:00.000 | - Next BIM Submission: Penultimate Hotel Station Model Submission (6/3/2019) (will connect with Javier this week to understand if this is slipping)                                                                                                      | RM           | Completed | Legacy               | 2019-05-28 00:00:00.000 |                    | 94a935d3-1415-449c-b0e0-eae4b24324e5 |
|                |        |                         | - Zach is providing additional screenshots for Pset Tutorial based on feedback from Javier                                                                                                                                                               |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-20 00:00:00.000 | Javier took care of request for Contractual Documents.                                                                                                                                                                                                   | RM           | Completed | Legacy               | 2019-05-20 00:00:00.000 |                    | 6b4157f7-7fbf-4259-b759-7d31aded5da8 |
|                |        |                         | CZ provided response RE: Commissioning Maps (Submission expected on 5/17 to BIT based on AVSEC-provided schedule)                                                                                                                                        |              |           |                      |                         |                    |                                      |
|                |        |                         | Will continue to provide support re: AutoCAD files (psets & ACIS elements)                                                                                                                                                                               |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-20 00:00:00.000 | Javier took care of request for Contractual Documents.                                                                                                                                                                                                   | RM           | Completed | Legacy               | 2019-05-20 00:00:00.000 |                    | 31b6db65-b62c-4ca0-963a-700c08cb1b17 |
|                |        |                         | CZ provided response RE: Commissioning Maps (Submission expected on 5/17 to BIT based on AVSEC-provided schedule)                                                                                                                                        |              |           |                      |                         |                    |                                      |
|                |        |                         | Will continue to provide support re: AutoCAD files (psets & ACIS elements)                                                                                                                                                                               |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-13 00:00:00.000 | RM & HB met with Javier on Thursday.                                                                                                                                                                                                                     | RM           | Completed | Legacy               | 2019-05-13 00:00:00.000 |                    | 42ec17a5-77f7-4d91-9a8d-d6f0f52eac61 |
|                |        |                         | Re-iterated our requirements - RM will review ACAD models with ACIS elements this week. HB creating tutorial for adding property sets to ACAD models (Zach is testing the method).                                                                       |              |           |                      |                         |                    |                                      |
|                |        |                         | Mohammad (Arch) requested airport standards and BIMx - directed him back to team.                                                                                                                                                                        |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-13 00:00:00.000 | RM & HB met with Javier on Thursday.                                                                                                                                                                                                                     | RM           | Completed | Legacy               | 2019-05-13 00:00:00.000 |                    | 19d58ea7-dd38-4231-8372-4b9d0bbbb941 |
|                |        |                         | Re-iterated our requirements - RM will review ACAD models with ACIS elements this week. HB creating tutorial for adding property sets to ACAD models (Zach is testing the method).                                                                       |              |           |                      |                         |                    |                                      |
|                |        |                         | Mohammad (Arch) requested airport standards and BIMx - directed him back to team.                                                                                                                                                                        |              |           |                      |                         |                    |                                      |
| Airtrain       | Note   | 2019-05-06 00:00:00.000 | Received IFC test model from Javier EOD Friday. Reviewed model fidelity with RM & AR - currently composing feedback and best practices. Meeting with Javier w/ RM Thursday morning to walk through AutoCAD models and develop process for Revit-ization. | RM           | Completed | Legacy               | 2019-05-06 00:00:00.000 |                    | 71c4aa63-bbf7-4027-b258-b053ecf50696 |
| Airtrain       | Note   | 2019-05-06 00:00:00.000 | Received IFC test model from Javier EOD Friday. Reviewed model fidelity with RM & AR - currently composing feedback and best practices. Meeting with Javier w/ RM Thursday morning to walk through AutoCAD models and develop process for Revit-ization. | RM           | Completed | Legacy               | 2019-05-06 00:00:00.000 |                    | ad15cf25-5dc7-4727-b77b-4ccaf2decb87 |
| Airtrain       | Note   | 2019-04-29 00:00:00.000 | Zach is MVR-ing the AirTrain Hotel Model.                                                                                                                                                                                                                | RM           | Completed | Legacy               | 2019-04-29 00:00:00.000 |                    | cac615d7-df13-42c3-a7e4-dc72e75a6fb4 |
| Airtrain       | Note   | 2019-04-29 00:00:00.000 | Zach is MVR-ing the AirTrain Hotel Model.                                                                                                                                                                                                                | RM           | Completed | Legacy               | 2019-04-29 00:00:00.000 |                    | 8b1323e7-1297-413c-ab9e-01f9eb3f9bc9 |


Table: Append1
| Project Name   | Owner   | Type   | Description   | Concat   | Start Date   | Duration   | Due Date   | Status   | Logic   | Project Acronym   | Engagement Phase   | Project Phase #   | Project Phase   | Entry Date   | Task Owner   | Status Description   | Related BDC Task   | ID   |
|:---------------|:--------|:-------|:--------------|:---------|:-------------|:-----------|:-----------|:---------|:--------|:------------------|:-------------------|:------------------|:----------------|:-------------|:-------------|:---------------------|:-------------------|:-----|
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |
|                |         |        |               |          |              |            |            |          |         |                   |                    |                   |                 |              |              |                      |                    |      |


Table: AssetAttributes
| Asset                 | Attribute                  | Value   |
|:----------------------|:---------------------------|:--------|
| Other (non-specified) | Type Mark and Mark (Revit) | X       |
| Other (non-specified) | SFO_Manufacturer           | X       |
| Other (non-specified) | SFO_ModelNumber            | X       |
| Other (non-specified) | OmniClass Number (Revit)   | X       |
| Door                  | SFO_TypeDescription        | X       |
| Door                  | Type Mark and Mark (Revit) | X       |
| Door                  | SFO_Manufacturer           | X       |
| Door                  | SFO_ModelNumber            | X       |
| Door                  | OmniClass Number (Revit)   | X       |
| Door                  | SFO_MasterFormat           | X       |


Table: BDC Master
| Name                   | Item                   | Kind   | Hidden   |
|:-----------------------|:-----------------------|:-------|:---------|
| Action Items & Notes   | Action Items & Notes   | Sheet  | False    |
| Notes Found            | Notes Found            | Sheet  | False    |
| ProjectInfo            | ProjectInfo            | Sheet  | False    |
| ProjectInfoPivot       | ProjectInfoPivot       | Sheet  | False    |
| BDC                    | BDC                    | Sheet  | False    |
| Contacts               | Contacts               | Sheet  | False    |
| Phases                 | Phases                 | Sheet  | False    |
| ProcessPhase           | ProcessPhase           | Sheet  | False    |
| SheetMappings          | SheetMappings          | Sheet  | False    |
| Data Validation Values | Data Validation Values | Sheet  | False    |


Table: BDC
| ID   | Owner   | Type   | Start Date   | Duration   | Due Date   | Status   | Logic   | Engagement Phase   | Project Phase #   | Project Phase   | Project Name   | Description   | Project Acronym   |
|:-----|:--------|:-------|:-------------|:-----------|:-----------|:---------|:--------|:-------------------|:------------------|:----------------|:---------------|:--------------|:------------------|
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |
|      |         |        |              |            |            |          |         |                    |                   |                 |                |               |                   |


Table: BIMx Background
| Name              | Item              | Kind   | Hidden   |
|:------------------|:------------------|:-------|:---------|
| Glossary          | Glossary          | Sheet  | False    |
| TutorialVideos    | TutorialVideos    | Sheet  | False    |
| Element Classes   | Element Classes   | Sheet  | False    |
| Elements          | Elements          | Sheet  | False    |
| ElementDesigner   | ElementDesigner   | Sheet  | False    |
| ElementTrade      | ElementTrade      | Sheet  | False    |
| ProcessLOD        | ProcessLOD        | Sheet  | False    |
| Process Steps     | Process Steps     | Sheet  | False    |
| DropDowns         | DropDowns         | Sheet  | False    |
| StandardsVersions | StandardsVersions | Sheet  | False    |


Table: BIMx Master
| Name         | Item         | Kind   | Hidden   |
|:-------------|:-------------|:-------|:---------|
| BDC          | BDC          | Sheet  | False    |
| Contacts     | Contacts     | Sheet  | False    |
| Project Info | Project Info | Sheet  | False    |
| Phases       | Phases       | Sheet  | False    |
| ProcessPhase | ProcessPhase | Sheet  | False    |


Table: Contacts
| Project Name   | SortID   | Team   | Role   | Organization   | Acronym   | Contact Name   | E-Mail   | Phone   | Parent   |
|:---------------|:---------|:-------|:-------|:---------------|:----------|:---------------|:---------|:--------|:---------|
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |
|                |          |        |        |                |           |                |          |         |          |


Table: EAD 3
| Name                   | Item                                     | Kind        | Hidden   |
|:-----------------------|:-----------------------------------------|:------------|:---------|
| SFOAssetOmniClass      | SFOAssetOmniClass                        | Sheet       | False    |
| AssetAttributes        | AssetAttributes                          | Sheet       | False    |
| SFOAssemblies          | SFOAssemblies                            | Sheet       | False    |
| EAD Attributes         | EAD Attributes                           | Sheet       | False    |
| ElementFamilyNames     | ElementFamilyNames                       | Sheet       | False    |
| _xlnm._FilterDatabase  | SFOAssemblies!_xlnm._FilterDatabase      | DefinedName | True     |
| _xlnm._FilterDatabase1 | SFOAssetOmniClass!_xlnm._FilterDatabase  | DefinedName | True     |
| _xlnm._FilterDatabase2 | EAD Attributes!_xlnm._FilterDatabase     | DefinedName | True     |
| _xlnm._FilterDatabase3 | AssetAttributes!_xlnm._FilterDatabase    | DefinedName | True     |
| _xlnm._FilterDatabase4 | ElementFamilyNames!_xlnm._FilterDatabase | DefinedName | True     |


Table: EAD Attributes
| Attribute Category       | ATTRIBUTE SET    | ATTRIBUTE READABLE NAME    | DESCRIPTION                                                                               | DATA FORMAT   | EXAMPLE                             | Sort   |   DVD # | NOTES                                                                                                                                                                                                    | Column10   |
|:-------------------------|:-----------------|:---------------------------|:------------------------------------------------------------------------------------------|:--------------|:------------------------------------|:-------|--------:|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-----------|
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_BuildingCode           | Unique Building Number Code (BNC) assigned by SFO. Ref. SFO Building Numbering Guidelines | Numeric       | 200                                 | PA1    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_ContractTitle          | Name of contract                                                                          | Alphanumeric  | Terminal 1                          | PA2    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_ContractNumber         | Number of contract                                                                        | Alphanumeric  | 1011.66.T1C                         | PA3    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_ProjectManager         | Name of SFO Project Manager                                                               | Alphanumeric  | Jane Doe                            | PA4    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_GeneralContractor      | Name of Design-Builder or General Contractor                                              | Alphanumeric  | General Contractor                  | PA5    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_DataAuthor             | Name of Contractor responsible for Data                                                   | Alphanumeric  | Mechanical Trade ABC                | PA6    |       1 |                                                                                                                                                                                                          |            |
| (PA) PROJECT ATTRIBUTES  | PROJECT CONTACTS | SFO_ModelAuthor            | Name of Contractor responsible for Model Authoring                                        | Alphanumeric  | Mechanical Engineer XYZ             | PA7    |       1 |                                                                                                                                                                                                          |            |
| (CA) COMMON ATTRIBUTES 1 | IDENTITY         | SFO_TypeDescription        | Description of type, can use Omniclass Table 23 Name if applicable                        | Alphanumeric  | Air Conditioning Unit, Split System | CA1    |       2 | (CA) Common Attributes include information that several SFO stakeholders are interested in. Project teams must deliver this information digitally for all facility assets identified in EAD Appendix A.3 |            |
| (CA) COMMON ATTRIBUTES 1 | IDENTITY         | Type Mark and Mark (Revit) | Equipment/Drawing Tag. Ref. SFO EAD Naming Conventions                                    | Alphanumeric  | AC-T1FC510                          | CA2    |       1 |                                                                                                                                                                                                          |            |
| (CA) COMMON ATTRIBUTES 1 | IDENTITY         | SFO_Manufacturer           | Name of Manufacturer per approved Submittal                                               | Alphanumeric  | Daikin                              | CA3    |       2 | Minimum Common Attributes recommended for ALL assets in BIM.                                                                                                                                             |            |


Table: Element Classes
| Element Class       | Description   |
|:--------------------|:--------------|
| Accessories         | TBD           |
| Diffusers?          | TBD           |
| Doors - Complex     | TBD           |
| Drains              | TBD           |
| Duct Accessories    | TBD           |
| Equipment - Basic?  | TBD           |
| Equipment - Complex | TBD           |
| Fencing             | TBD           |
| Filter              | TBD           |
| Finishes            | TBD           |


Table: ElementClassProcess
| Element Class        | Process         | Value   |
|:---------------------|:----------------|:--------|
| Access               | Trade Detailing | Yes     |
| Appliances - Basic   | Trade Detailing | Yes     |
| AV Equipment         | Trade Detailing | Yes     |
| Bathroom Accessories | Trade Detailing | Yes     |
| Ceiling              | Trade Detailing | Yes     |
| Connection - Basic   | Trade Detailing | Yes     |
| Connection - Complex | Trade Detailing | Yes     |
| Device - Basic       | Trade Detailing | Yes     |
| Diffusers?           | Trade Detailing | Yes     |
| Doors                | Trade Detailing | Yes     |


Table: ElementDesigner
| OmniClass Number   | Discipline   | Value   |
|:-------------------|:-------------|:--------|
| 23-10 00 00        | Architecture | Yes     |
| 23-10 00 00 11     | Architecture | Yes     |
| 23-10 00 00 15     | Architecture | Yes     |
| 23-11 11 00        | Architecture | Yes     |
| 23-11 11 11        | Architecture | Yes     |
| 23-11 11 11 11     | Architecture | Yes     |
| 23-11 11 11 11 11  | Architecture | Yes     |
| 23-11 11 11 11 13  | Architecture | Yes     |
| 23-11 11 11 13     | Architecture | Yes     |
| 23-11 11 11 15     | Architecture | Yes     |


Table: ElementFamilyNames
| Discipline   | OmniClass   | Asset             |   Sort | Descriptor Type   | Descriptor Value   | Required?   | Family Type   | Tag Schema   | Assembly?   | Requires Data   | Notes   |
|:-------------|:------------|:------------------|-------:|:------------------|:-------------------|:------------|:--------------|:-------------|:------------|:----------------|:--------|
| D30 HVAC     | 23-27 21 00 | Air Compressor    |      2 | Type              | Rotary             | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-27 21 00 | Air Compressor    |      2 | Type              | Oil-Less           | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-27 21 00 | Air Compressor    |      2 | Type              | Reciprocating      | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Compact            | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Modular            | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Custom             | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Semi-Custom        | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Built-Up           | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 25 00 | Air Handling Unit |      3 | Type              | Packaged           | Required    | Loadable      | N/A          |             | Yes             |         |
| D30 HVAC     | 23-33 11 00 | Boiler            |      3 | Type              | Fire-Tube          | Required    | Loadable      | N/A          |             | Yes             |         |


Table: Elements
| OmniClass Number   | Level   |   ID | OmniClass Title               | Definitions   | Airport Uses?   | Modeled?   | Facility Data?   | AssetLevel   | Element Class     |
|:-------------------|:--------|-----:|:------------------------------|:--------------|:----------------|:-----------|:-----------------|:-------------|:------------------|
| 23-17 23 15 11     | L3      | 1772 | Ladder Component Products     |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-17 23 15 13     | L3      | 1775 | Vertical Ladders              |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-17 23 15 15     | L3      | 1776 | Ship Ladders                  |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 11 11     | L3      | 2114 | Commercial Hot Cabinets       |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 11 13     | L3      | 2115 | Commercial Cold Cabinets      |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 11 19     | L3      | 2118 | Commercial Warming Cabinets   |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 11 21     | L3      | 2119 | Commercial Snack Cabinets     |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 13 11     | L3      | 2121 | Commercial Bain Maries        |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 13 13     | L3      | 2122 | Commercial Beverage Equipment |               | Yes             | Yes        |                  |              | Equipment - Basic |
| 23-21 21 13 15     | L3      | 2126 | Commercial Broilers           |               | Yes             | Yes        |                  |              | Equipment - Basic |


Table: ElementTrade
| OmniClass Number   | Trade   | Value   |
|:-------------------|:--------|:--------|
| 23-10 00 00        | Arch    | Yes     |
| 23-10 00 00 11     | Arch    | Yes     |
| 23-10 00 00 15     | Arch    | Yes     |
| 23-11 25 00        | Arch    | Yes     |
| 23-11 25 11        | Arch    | Yes     |
| 23-11 25 11 11     | Arch    | Yes     |
| 23-11 25 13        | Arch    | Yes     |
| 23-11 25 13 11     | Arch    | Yes     |
| 23-11 25 13 13     | Arch    | Yes     |
| 23-11 25 15        | Arch    | Yes     |


Table: Glossary
| Sort   | Term                           | Definition                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Column4   |
|:-------|:-------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------|
|        | Airfield                       | The area of land designated for takeoff, landing and maintenance of aircraft.                                                                                                                                                                                                                                                                                                                                                                                |           |
|        | As-Built Model                 | A 3D Model prepared by the builder and field-verified, accurate representation of the infrastructure.                                                                                                                                                                                                                                                                                                                                                        |           |
|        | As-Managed Model               | A Conformed Design Model is transferred from the builder to the Airport and converted into an As-Managed Model during project closeout. The As-Managed Model functions as the updated and verified virtual representation of the Airport’s facilities and fixed assets. Whenever any changes are made to the infrastructure during maintenance and operations, they are also captured in this model to represent the central verified source of information. |           |
|        | Attribute                      | Also known as parameters, these store and communicate information about all elements in a model. They can be used to define and modify elements, as well as to communicate model information in tags and schedules.                                                                                                                                                                                                                                          |           |
|        | BIM Execution Plan (BIMx Plan) | A comprehensive document, which outlines the protocols and procedures that the design and construction team must follow to ensure successful utilization of BIM and VDC practices.                                                                                                                                                                                                                                                                           |           |
|        | BIM Integration Team (BIT)     | A multi-disciplinary group of SFO personnel to enable the central management of BIM deliverables, BIM-related data and other digital assets across the enterprise. The primary function and role of this “task force” is to serve SFO stakeholders and AEC project teams to develop standards and processes for data collection and validation and maintain the virtual representation of SFO buildings and assets.                                          |           |
|        | BIM Use                        | The process of using the embedded information and parametric capabilities of a Building Information Model during an infrastructure’s life cycle to achieve one or more specific objectives.                                                                                                                                                                                                                                                                  |           |
|        | Builder                        | An individual or an organization that builds, develops and constructs buildings and infrastructure. The Airport considers everyone involved in the construction team, including the General Contractor and Trade Partner as a builder.                                                                                                                                                                                                                       |           |
|        | Building Components            | The smallest subset of a building system is a building component, which can be an object (e.g., doors, windows, mechanical or electrical fixtures) or an assembly of objects (e.g., walls, roofs, air handling units) and is installed with consideration to site conditions and its relationship with other building components and systems.                                                                                                                |           |
|        | Building Envelope              | The physical separator between the conditioned and unconditioned environment of a building, including resistance to air, water, heat, light and noise transfer.                                                                                                                                                                                                                                                                                              |           |


Table: MPS Master
| Name                | Item                | Kind   | Hidden   |
|:--------------------|:--------------------|:-------|:---------|
| MPS_Plumb           | MPS_Plumb           | Sheet  | False    |
| PlumbProcessesPhase | PlumbProcessesPhase | Sheet  | False    |
| Table 23 FLAT       | Table 23 FLAT       | Sheet  | False    |
| Element Classes     | Element Classes     | Sheet  | False    |
| ECReqLOD_Pro        | ECReqLOD_Pro        | Sheet  | False    |
| ECResLOD_Pro        | ECResLOD_Pro        | Sheet  | False    |
| ECReqLOD_SD         | ECReqLOD_SD         | Sheet  | False    |
| ECResLOD_SD         | ECResLOD_SD         | Sheet  | False    |
| ECReqLOD_DD         | ECReqLOD_DD         | Sheet  | False    |
| ECResLOD_DD         | ECResLOD_DD         | Sheet  | False    |


Table: MPS_Magic
| ProcessPhase_Phase          |   Required LOD |   Resulting LOD |
|:----------------------------|---------------:|----------------:|
| Model Setup and Programming |            200 |             275 |
| Schematic Design            |            200 |             295 |
| Design Development          |            200 |             295 |
| Construction Documentation  |            300 |             300 |
| Coordination / Submittals   |            300 |             350 |
| Handover                    |            200 |             475 |
| Execution                   |            350 |             475 |


Table: Navigation
| Tab                 |   Size |
|:--------------------|-------:|
| Project Information |      1 |
| BDC - Overview      |      1 |
| BDC - Specific      |      1 |
| BIM Uses            |      1 |
| MPS                 |      1 |
| EAD                 |      1 |
| MVR                 |      1 |


Table: New Engagements
| Name                   | Item                                       | Kind        | Hidden   |
|:-----------------------|:-------------------------------------------|:------------|:---------|
| DocumentIntro          | DocumentIntro                              | Sheet       | False    |
| Action Items & Notes   | Action Items & Notes                       | Sheet       | False    |
| BDC                    | BDC                                        | Sheet       | False    |
| Data Validation Values | Data Validation Values                     | Sheet       | False    |
| _xlnm._FilterDatabase  | Action Items & Notes!_xlnm._FilterDatabase | DefinedName | True     |
| _xlnm._FilterDatabase1 | BDC!_xlnm._FilterDatabase                  | DefinedName | True     |


Table: NewEngagementBDC
|   Phase # | Project Name   | Owner   | Type    | Description     | Concat                     | Start Date   |   Duration | Due Date   | Status   | Logic   |
|----------:|:---------------|:--------|:--------|:----------------|:---------------------------|:-------------|-----------:|:-----------|:---------|:--------|
|      0.01 | Superbay       | SFO BIT | Meeting | PMS Orientation | Superbay - PMS Orientation | 7/19/2019    |          0 | 7/19/2019  | Upcoming |         |


Table: NewEngagementNotes
| Project Name            | Type        | Entry Date              | Description                                                                                                                                                                        | Task Owner   | Status    | Status Description   | Due Date                | Related BDC Task   |
|:------------------------|:------------|:------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:----------|:---------------------|:------------------------|:-------------------|
| Field Lighting Building | Note        | 2019-07-26 00:00:00.000 | Contacted Jonathan Husband for an ideal time to meet.  Waiting on response                                                                                                         | RM           | Completed |                      | 2019-07-26 00:00:00.000 |                    |
| BAG and Rwy 28L         | Note        | 2019-07-26 00:00:00.000 | RM to called/emailed Fred Sabour.  Waiting on response.                                                                                                                            | RM           | Completed |                      | 2019-07-26 00:00:00.000 |                    |
| Superbay                | Action Item | 2019-07-22 00:00:00.000 | Review models and prepare MVR                                                                                                                                                      | ZF           | Upcoming  |                      | 2019-07-29 00:00:00.000 |                    |
| Superbay                | Note        | 2019-07-22 00:00:00.000 | RM met with Jenna to review project.  Notes are as follows:                                                                                                                        | HB           | Completed |                      | 2019-07-22 00:00:00.000 |                    |
|                         |             |                         | •  Project Scope                                                                                                                                                                   |              |           |                      |                         |                    |
|                         |             |                         |   o Upgrading Fire Suppression System                                                                                                                                              |              |           |                      |                         |                    |
|                         |             |                         |   o New Pump Building                                                                                                                                                              |              |           |                      |                         |                    |
|                         |             |                         | •   Current Status                                                                                                                                                                 |              |           |                      |                         |                    |
|                         |             |                         |   o 2 years in                                                                                                                                                                     |              |           |                      |                         |                    |
|                         |             |                         |   o 4 Months left                                                                                                                                                                  |              |           |                      |                         |                    |
|                         |             |                         |   o 5 weeks behind                                                                                                                                                                 |              |           |                      |                         |                    |
|                         |             |                         | •  Models Created                                                                                                                                                                  |              |           |                      |                         |                    |
|                         |             |                         |   o Fire Suppression Model in Revit built from laser scan                                                                                                                          |              |           |                      |                         |                    |
|                         |             |                         |   o Rough Architectural Model                                                                                                                                                      |              |           |                      |                         |                    |
|                         |             |                         | •  General Notes                                                                                                                                                                   |              |           |                      |                         |                    |
|                         |             |                         |   o Building has been poorly managed by American Airlines and has poor as-builts                                                                                                   |              |           |                      |                         |                    |
|                         |             |                         |   o 3 Data Collection options to choose from                                                                                                                                       |              |           |                      |                         |                    |
|                         |             |                         |       Project Team applies attributes to model and collects data via spreadsheets (ideal option)                                                                                  |              |           |                      |                         |                    |
|                         |             |                         |       SFO BIM Integration Team (BIT) applies attributes and assists in creation of Equipment Inventory Spreadsheets (EIS) (BIT may not have capacity to accommodate this request) |              |           |                      |                         |                    |
|                         |             |                         |       Project Team fills out blank spreadsheets provided by BIT (last resort)                                                                                                     |              |           |                      |                         |                    |
|                         |             |                         |   o Project Specs are not the latest so option 1 may result in a change order if you’re unable to slip that requirement in                                                         |              |           |                      |                         |                    |
|                         |             |                         | • Action Items                                                                                                                                                                     |              |           |                      |                         |                    |
|                         |             |                         |   o Please send us the link to the latest models                                                                                                                                   |              |           |                      |                         |                    |
|                         |             |                         |   o Send times that you are available in the next 2 weeks (Understand Mondays and Fridays to be best)                                                                              |              |           |                      |                         |                    |
|                         |             |                         |   o I will then schedule a mid-project BIM Closeout Meeting                                                                                                                        |              |           |                      |                         |                    |
|                         |             |                         |   o Prior to this meeting, we will review the models and meet as a team to discuss viable options                                                                                  |              |           |                      |                         |                    |
|                         |             |                         |   o Following the meeting we will plan next steps.                                                                                                                                 |              |           |                      |                         |                    |
|                         |             |                         | If you have any questions, comments, or concerns, please let us know.  Thanks!                                                                                                     |              |           |                      |                         |                    |
| Superbay                | Note        | 2019-07-15 00:00:00.000 | RM sent email to Jenna Castro.  Meeting scheduled for this Friday.                                                                                                                 | HB           | Completed |                      | 2019-07-15 00:00:00.000 |                    |


Table: Phases
| Project Name   | Sort   | Facility #   | Project Phase   | Start Date   | Comments   | Concat              |
|:---------------|:-------|:-------------|:----------------|:-------------|:-----------|:--------------------|
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |
|                |        |              | 1 - Model Setup |              |            | 1 - 1 - Model Setup |


Table: PictureMatrix
| Project Name   | Image Link                                                                                                           |
|:---------------|:---------------------------------------------------------------------------------------------------------------------|
| Airtrain       | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/Airtrain_Render.jpg?raw=true |
| BAB            | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/BAB_Render.jpg?raw=true      |
| BMF            | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/BMF_Render.jpg?raw=true      |
| C3C            | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/C3C_Render.jpg?raw=true      |
| CAC            | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/CAC_Render.jpg?raw=true      |
| Cargo 900944   | https://lh3.googleusercontent.com/-1lHsthAP6B4/UMmucH6xaZI/AAAAAAAAKvk/xp8uGqvdCE0/w530-h419-n/grumpyCat404.jpg      |
| EMCS           | https://lh3.googleusercontent.com/-1lHsthAP6B4/UMmucH6xaZI/AAAAAAAAKvk/xp8uGqvdCE0/w530-h419-n/grumpyCat404.jpg      |
| FH3            | https://lh3.googleusercontent.com/-1lHsthAP6B4/UMmucH6xaZI/AAAAAAAAKvk/xp8uGqvdCE0/w530-h419-n/grumpyCat404.jpg      |
| GTU            | https://lh3.googleusercontent.com/-1lHsthAP6B4/UMmucH6xaZI/AAAAAAAAKvk/xp8uGqvdCE0/w530-h419-n/grumpyCat404.jpg      |
| Hotel          | https://github.com/SFO-BIT/BIMxGallery/blob/master/Dashboard%20Assets/ProjectRenderings/Hotel_Render.jpg?raw=true    |


Table: Process Steps
| Process Category   | Process   | Process Step   | Responsible   | Software/Tools   | Tutorial Link   | Notes   |
|:-------------------|:----------|:---------------|:--------------|:-----------------|:----------------|:--------|
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |
|                    |           |                |               |                  |                 |         |


Table: ProcessLOD
|   Sort | Process                                       | Description                                                                                |   Required LOD | Resulting LOD   | Image                                                                                                                                                       | Colors   | Column8   | Image Found   |
|-------:|:----------------------------------------------|:-------------------------------------------------------------------------------------------|---------------:|:----------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------|:----------|:--------------|
|      1 | Coordinate System Setup                       |                                                                                            |              0 | 0               | http://www.dirsig.org/docs/new/images/coordinates/geo_coords.png                                                                                            | #0097A9  |           |               |
|      2 | Create Template File                          |                                                                                            |              0 | 0               | https://damassets.autodesk.net/content/dam/autodesk/www/products/autodesk-revit-lt/fy18/features/images/exchange-designs-with-revit-users-thumb-252x150.jpg | #0097A9  |           |               |
|      3 | Block Creation                                |                                                                                            |              0 | 0               | https://thumb.bibliocad.com/images/content/00030000/1000/31089.gif                                                                                          | #0097A9  |           |               |
|      4 | Family Creation                               |                                                                                            |              0 | 0               | https://img2.cgtrader.com/items/907411/8192a6241a/large/34-gym-models-revit-family-2015-3d-model-rfa-rvt.jpg                                                | #0097A9  |           |               |
|      5 | Attribute Setup                               |                                                                                            |              0 | 0               |                                                                                                                                                             | #0097A9  |           |               |
|      6 | Template Model Review                         |                                                                                            |              0 | 0               |                                                                                                                                                             | #0097A9  |           |               |
|      7 | Existing Conditions Modeling - Laser Scanning | The process of modeling an existing structure for the means of coordinating future design. |              0 | 150             |                                                                                                                                                             | #0097A9  | Y         | Yes           |
|      8 | Site Analysis                                 | Utilizing a 3D model to analyze a site for both design and construction constraints.       |            100 | 150             |                                                                                                                                                             | #0097A9  | M         |               |
|      9 | Programming                                   | Using a model to develop a building's program                                              |            100 |                 |                                                                                                                                                             | #64A70B  | M         |               |
|     10 | 2D Design Authoring                           |                                                                                            |            100 | 100             | https://cdn.lynda.com/course/122434/122434-636534410884357689-16x9.jpg                                                                                      | #64A70B  | M         |               |


Table: ProcessPhase
| Project Name   | Sort   | Process Category   | Process             | Phase                       | Value   |   ProcessLOD.Required LOD |   ProcessLOD.Resulting LOD |
|:---------------|:-------|:-------------------|:--------------------|:----------------------------|:--------|--------------------------:|---------------------------:|
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |
|                |        |                    | Structural Analysis | Model Setup and Programming | Maybe   |                       200 |                        275 |


Table: ProcessPhasePivotRequiredLOD
| Project Name   | Sort   | Process Category   | Process                     | Value   | Model Setup and Programming   | Schematic Design   | Design Development   | Construction Documentation   | Coordination / Submittals   | Execution   | Handover   |
|:---------------|:-------|:-------------------|:----------------------------|:--------|:------------------------------|:-------------------|:---------------------|:-----------------------------|:----------------------------|:------------|:-----------|
|                |        |                    |                             | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    |                             | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 2D Design Authoring         | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 3D Control and Planning     | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 3D Design Authoring         | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 4D Scheduling               | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 5D Estimating               | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Attribute Setup             | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Block Creation              | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Clash Coordination - Design | Yes     |                               |                    |                      |                              |                             |             |            |


Table: ProcessPhasePivotResultingLOD
| Project Name   | Sort   | Process Category   | Process                     | Value   | Model Setup and Programming   | Schematic Design   | Design Development   | Construction Documentation   | Coordination / Submittals   | Execution   | Handover   |
|:---------------|:-------|:-------------------|:----------------------------|:--------|:------------------------------|:-------------------|:---------------------|:-----------------------------|:----------------------------|:------------|:-----------|
|                |        |                    |                             | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    |                             | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 2D Design Authoring         | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 3D Control and Planning     | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 3D Design Authoring         | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 4D Scheduling               | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    | 5D Estimating               | Maybe   |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Attribute Setup             | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Block Creation              | Yes     |                               |                    |                      |                              |                             |             |            |
|                |        |                    | Clash Coordination - Design | Yes     |                               |                    |                      |                              |                             |             |            |


Table: ProcessSort
|   Order | Phase                       | Column3   | Merged                          |
|--------:|:----------------------------|:----------|:--------------------------------|
|       1 | Model Setup and Programming |           | 1 - Model Setup and Programming |
|       2 | Schematic Design            |           | 2 - Schematic Design            |
|       3 | Design Development          |           | 3 - Design Development          |
|       4 | Construction Documentation  |           | 4 - Construction Documentation  |
|       5 | Coordination / Submittals   |           | 5 - Coordination / Submittals   |
|       6 | Execution                   |           | 6 - Execution                   |
|       7 | Handover                    |           | 7 - Handover                    |


Table: Project Info Pivot
| Project Name   | Contract Owner                   | Contract Number    | Contract Title                                                                                                  | Contract Acronym   | Building Number                                    | Street Name                                  | City              | State   | ZIP       | Latitude 1        | Longitude 1        | Latitude 2   | Longitude 2   | Latitude 3   | Longitude 3   | Contract Type     | Estimated Cost   | Other Information                             | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Model Link   | BIM Guide           | Revit Standard   | GIS Standard   | CAD Standard   | Building Level & Space Numbering Guidelines   | Sheet Numbering Guidelines   | Revit Template Files   | __PowerAppsId__                  |
|:---------------|:---------------------------------|:-------------------|:----------------------------------------------------------------------------------------------------------------|:-------------------|:---------------------------------------------------|:---------------------------------------------|:------------------|:--------|:----------|:------------------|:-------------------|:-------------|:--------------|:-------------|:--------------|:------------------|:-----------------|:----------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:--------------------|:-----------------|:---------------|:---------------|:----------------------------------------------|:-----------------------------|:-----------------------|:---------------------------------|
| Airtrain       | San Francisco Airport Commission | 10504.66           | AirTrain  Extension  and  Improvements  Program                                                                 | Airtrain           | 59  =  Hotel  Station;  797  =  Long  Term Parking | N McDonnell Road                             | San Francisco     | CA      | 94128     | 37.613844         | -122.393413        | 37.635493    | -122.40049    |              |               | Design-Build      | 750000000        |                                               | Two AirTrain Passenger stations, Guideway, and train systems (by others).  SFO requires incremental FM data collection throughout the project delivery and employs periodic verification of that data.The  Hotel  Station  will  be  constructed  concurrently  to  the  construction  of  the  new  Hotel  making  the  two  active construction sites a concern. Access between the Hotel and the station shall be coordinated. The  Long-term  Parking  (LTP)  Station  will  be  constructed  concurrently  with  the  construction  of  new  Parking Structure  and  should  take  into  account  future  master  plan  developments  proposed  on  the  site  adjacent  to  the station.  Access  between  parking  structures  and  the  station  will  be  done  using  pedestrian  bridge  and  access  to the  future  Car  Rental  facility  will  require  a  separate  future  platform  to  be  located  on  the  west  side  of  the station.This will have to be closely coordinated. |              | 12/31/1899 16:48:00 | 1                | V2015          | V2010          | V1.1                                          | V1                           |                        | 4692f921fab142deba8680d5f3cc31ae |
| ATCT           | San Francisco Airport Commission | 9034               | Terminal 2 Demolition and Buildback                                                                             | ATCT               | T2                                                 | Terminal 2, San Francisco, CA 94128          | San Francisco, CA | CA      | 94128     |                   |                    |              |               |              |               | Design-Build      | 42000000         |                                               | This project will include the demolition of the existing Air Traffic Control Tower above Terminal 2. This project will also provide improvements to the Terminal 2 building envelope, third‐floor mezzanine improvements, and concession additions.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |              | 0.7                 | V1.0 / June 2016 | V2015          | V2010          | V1.1                                          | V1                           |                        | 5d3c03665b734431a71d7cd641cdd3cd |
| BAB            | San Francisco Airport Commission | 10010.66           | New Boarding Area B Reconstruction (BAB) Project                                                                | BAB                |                                                    |                                              |                   |         |           | 37.612921         | -122.38479         |              |               |              |               | Design-Build (DB) | 477M             |                                               | he New Boarding Area B Reconstruction Project will include: passenger boarding areas, airline gates, concession and amenities areas, baggage handling system, a new mezzanine, airline lounges, and a sterile corridor with connection to the International Terminal. Refer to RFQ Section 10010.66 page 6-10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |              | 0.2                 | N/A              | N/A            | N/A            |                                               |                              |                        | 6565673a91734489899868fc9be27e92 |
| BMF            | San Francisco Airport Commission | 9405.71            | Bus Maintenance Facility                                                                                        | BMF                | 949                                                | North Field Road                             | San Francisco, CA | CA      | 94128     | 37.636525         | -122.390614        | #N/A         | #N/A          | #N/A         | #N/A          | CMGC              | 14000000         |                                               | The Bus Maintenance Facility (BMF) Project will replace the existing Bus Maintenance Facility which is in disrepair and has surpassed its useful life. The BMF will relocate its operations from the current site at North McDonnell Road and San Bruno Avenue to the North Field Plot 700 site, adjacent to the Ground Transportation Unit (GTU) facility.  The new BMF will be a one-story building, approximately 8,000 square feet in size, and will feature a 2-bay vehicle service/maintenance facility, administration offices, maintenance and bus crew facilities, as well as onsite parking for the bus fleet, driver pool and staff.                                                                                                                                                                                                                                                                                                                                                       |              | 4/16/2018           | 4/17/2018        | 7/7/1905       | 7/9/1905       | 4/17/2018                                     | #N/A                         | #N/A                   | f35a7491138144c6962041e45f246625 |
| C3C            | San Francisco Airport Commission | 10072              | Courtyard 3 Connector Project                                                                                   | C3C                | TBD                                                | Courtyard 3 San Francisco, CA 94128          | San Francisco, CA | CA      | 94128     | 37.617551         | -122.384477        |              |               |              |               | Design-Build      | 145000000        |                                               | The Courtyard 3 Connector Project scope will include design and construction of a new pre-security and post-security connector between Terminal 2 and Terminal 3, as well as an approximately 100,000 square foot adjacent building for office space, tenant lease space, passenger amenities and lounges or other Airport and tenant needs. The Project will provide systems connectors and a baggage handling system right of way for future modifications.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |              | 4/16/2018           | 4/17/2018        | 2015           | 2017           | 4/17/2018                                     | 4/18/2018                    |                        | a1521e9aaa7244678ce9a452651f7a5b |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | The Project will also perform as needed make-ready activities in anticipation of the new building. These may include, but are not limited to, additional shell spaces in T2 as needed to maintain operations and systems relocation of critical Airport facilities such as the Emergency Operations Center, and Security Operations Center and/or any associated special systems, security, communications, and utilities infrastructure.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |              |                     |                  |                |                |                                               |                              |                        |                                  |
| CAC            | San Francisco Airport Commission | 5/31/1955          | Consolidated Administration Campus Project Phase I                                                              | CAC                | 674                                                | West Field Road                              | San Francisco     | CA      | 94128     | 37.622846         | 8/30/1899 09:34:03 |              |               |              |               |                   |                  |                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              | 0.4                 | N/A              | V2015          | V2010          | 8/15/2018                                     |                              |                        | 4d867598e31f43b787f7b05a17c15a19 |
| Cargo 900944   | San Francisco Airport Commission | 9322.66            | Renovation of Cargo Buildings 900 and 944                                                                       | Cargo 900944       | 900 944                                            | N Access Road / N Field Road                 | San Francisco, CA | CA      | 94128     | 37.637518         | -122.387831        |              |               |              |               | Design-Build      | 7807500          | 2 separate buildings combined into one BIMx   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              | 1/1/1900            | V1.1             | V2015          | V2017          | V1.1                                          | V1                           |                        | d15fcf0f92474ba39614d5797ffc707f |
| EMCS           | San Francisco Airport Commission | 4/20/1930 15:50:24 |                                                                                                                 | EMCS               |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              |                     |                  |                |                |                                               |                              |                        | 00bbd66adc214937a5fc066d3f8b4b41 |
| FH3            | San Francisco Airport Commission | 10050.71           | SFO- Construction Manager/General Contractor for Fire House No. 3 and South Field Checkpoint Relocation Project | FH3                | 12                                                 | South McDonnell Road                         | San Francisco, CA | CA      | 9/16/2157 | #N/A              | #N/A               | #N/A         | #N/A          | #N/A         | #N/A          | Design-Build      | 20000000         |                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              | 12/31/1899 14:24:00 | V.1 / March 2016 | V2015          | V2010          | 8/15/2018                                     | N/A                          |                        | 3d33e1b4632b4831a6a303b929db63e1 |
| GTU            | San Francisco Airport Commission | 10060              | Ground Transportation Unit Relocation Project                                                                   | GTU                |                                                    | Plot 70 North Access Road & North Field Road | San Francisco     | CA      | 9/16/2157 | 2/6/1900 15:17:41 | -122.391261        |              |               |              |               |                   |                  | PROJECT AREA: 13,750 SF                       | THE GROUND TRANSPORTATION UNIT RELOCATION PROJECT (GTU) PROVIDES THE DESIGN AND CONSTRUCTION RESOURCES TO RELOCATE THE EXISTING GTU LOCATED AT THE SOUTH END OF THE AIRPORT, TO PLOT 700 IN THE NORTH FIELD. THE PROJECT CONSISTS OF A NEW GTU FACILITY, CCSF VEHICLE FUEL STATION, AND A 2-BAY VEHICLE WASH STATION FOR USE BY AIRPORT COMMISSION VEHICLES. PROJECT SCOPE INCLUDES DEVELOPMENT OF A MASTERPLAN FOR PLOT 700 TO IDENTIFY THE OPTIMAL SITING, VEHICULAR CIRCULATION, AND PARKING CONFIGURATION FOR THE PLANNED NEW FACILITIES, INCLUDING THE FUTURE BUS MAINTENANCE FACILITY (BMF) AND COMPRESSED NATURAL GAS (CNG) FUELING STATION, WHICH ARE BEING DELIVERED UNDER A DIFFERENT CONTRACT.                                                                                                                                                                                                                                                                                             |              | 12/31/1899 14:24:00 | V.1 / March 2016 | V2015          | V2010          | 8/15/2018                                     |                              |                        | f713a2d19ecc41b29b885ad6d776fc01 |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  | CONSTRUCTION TYPE: IIB                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  | BUILDING OCCUPANCY: B (BUSINESS); S-1 STORAGE | PHASE II CONSISTS OF THE DESIGN AND CONSTRUCTION OF THE PERMANENT GTU FACILITY: A ONE-STORY, APPROXIMATELY 13,500 SQUARE FOOT, 2-BAY INSPECTION FACILITY, 2-BAY RADIO SHOP, RADIO WORKSHOP, ADMINISTRATIVE OFFICES, AND A CUSTOMER SERVICE CENTER. VEHICULAR CIRCULATION AND PARKING REQUIREMENTS FOR THE PROJECT WILL INCLUDE ACCOMMODATION FOR TAXIS, LIMOUSINES, SHUTTLE BUSES, BUSES, AND AIRPORT COMMISSION VEHICLES BASED ON PEAK RENEWAL SEASON BY VEHICLE TYPE. A LANDSCAPED COURTYARD WILL BE INCORPORATED INTO THE PUBLIC ENTRY SEQUENCE OF THE FACILITY.                                                                                                                                                                                                                                                                                                                                                                                                                                   |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  | SEISMIC DESIGN CATEGORY: E                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | THE GTU FUNCTIONS AS THE PERMITTING AND INSPECTION AGENCY FOR ALL PASSENGER-CARRYING COMMERCIAL VEHICLES                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | OPERATING AT SFO. THE GTU VERIFIES THAT ALL VEHICLES AND DRIVERS ARE IN COMPLIANCE WITH AIRPORT AND STATE REQUIREMENTS.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | THE FACILITY IS COMPRISED OF THREE PRIMARY COMPONENTS: GTU OPERATIONS, CUSTOMER SERVICE (PROCESSING & PERMITTING), AND                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | VEHICULAR INSPECTION. PROJECTED STAFFING IS 25-30 EMPLOYEES AND TECHNICIANS. THE RADIO SHOP FUNCTIONS FOR THE REPAIR AND                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | MAINTENANCE OF RADIOS, TRANSPONDERS, AND ANTENNAS FOR ALL AIRPORT OPERATED VEHICLES INCLUDING THE AIRPORT SF FIRE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |              |                     |                  |                |                |                                               |                              |                        |                                  |
|                |                                  |                    |                                                                                                                 |                    |                                                    |                                              |                   |         |           |                   |                    |              |               |              |               |                   |                  |                                               | DEPARTMENT AND AIRPORT SF POLICE DEPARTMENT.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |              |                     |                  |                |                |                                               |                              |                        |                                  |


Table: Project Info Standards
| Project Name   | Standard                                    | Version             |
|:---------------|:--------------------------------------------|:--------------------|
| Airtrain       | BIM Guide                                   | 12/31/1899 16:48:00 |
| Airtrain       | Revit Standard                              | 1                   |
| Airtrain       | GIS Standard                                | V2015               |
| Airtrain       | CAD Standard                                | V2010               |
| Airtrain       | Building Level & Space Numbering Guidelines | V1.1                |
| Airtrain       | Sheet Numbering Guidelines                  | V1                  |
| Airtrain       | Revit Template Files                        |                     |
| ATCT           | BIM Guide                                   | 0.7                 |
| ATCT           | Revit Standard                              | V1.0 / June 2016    |
| ATCT           | GIS Standard                                | V2015               |


Table: Project Info
| Project Name   | Info Type            | Values   |
|:---------------|:---------------------|:---------|
| Cargo 900944   | Latitude 2           |          |
| Cargo 900944   | Longitude 2          |          |
| Cargo 900944   | Latitude 3           |          |
| Cargo 900944   | Longitude 3          |          |
| Cargo 900944   | Description          |          |
| Cargo 900944   | Model Link           |          |
| Cargo 900944   | Revit Template Files |          |
| MLTP           | Latitude 2           |          |
| MLTP           | Longitude 2          |          |
| MLTP           | Latitude 3           |          |


Table: SFOAssemblies
| Assembly                            | Subcomponent Assets      |
|:------------------------------------|:-------------------------|
| Drainage Pump Station               | Pump                     |
| Drainage Pump Station               | Variable Frequency Drive |
| Drainage Pump Station               | Motor Control Center     |
| Drainage Pump Station               | Valve                    |
| Air Conditioning Unit, Split System | Fan Coil Unit            |
| Air Conditioning Unit, Split System | Condensing Unit          |
| Air Handling Unit                   | Heat Exchanger           |
| Air Handling Unit                   | Supply Fan               |
| Air Handling Unit                   | Exhaust Fan              |
| Air Handling Unit                   | Filter                   |


Table: SFOAssetOmniClass
| OmniClass   | Asset                         | Requires Data   | Requires Tagging?   |
|:------------|:------------------------------|:----------------|:--------------------|
| 23-27 21 00 | Air Compressor                | Yes             | Yes                 |
| 23-33 25 00 | Air Handling Unit             | Yes             | Yes                 |
| 23-33 49 00 | Air Terminals                 | No              | Maybe               |
| 23-33 11 00 | Boiler                        | Yes             | Yes                 |
| 23-33 41 17 | Constant Air Volume Box       | Yes             | Yes                 |
| 23-33 35 11 | Coils                         | Yes             | Yes                 |
| 23-33 21 00 | Chiller                       | Yes             | Yes                 |
| 23-33 39 11 | Computer Room Air Conditioner | No              | Maybe               |
| 23-33 23 00 | Cooling Tower                 | No              | Maybe               |
| 23-33 37 00 | Condensing Unit               | No              | Maybe               |

 


tables: name: Action Items & Notes
data: Action Items & Notes.csv
name: ALL BDC
data: ALL BDC.csv
name: ALL Notes
data: ALL Notes.csv
name: Append1
data: Append1.csv
name: AssetAttributes
data: AssetAttributes.csv
name: BDC Master
data: BDC Master.csv
name: BDC
data: BDC.csv
name: BIMx Background
data: BIMx Background.csv
name: BIMx Master
data: BIMx Master.csv
name: Contacts
data: Contacts.csv
name: EAD 3
data: EAD 3.csv
name: EAD Attributes
data: EAD Attributes.csv
name: Element Classes
data: Element Classes.csv
name: ElementClassProcess
data: ElementClassProcess.csv
name: ElementDesigner
data: ElementDesigner.csv
name: ElementFamilyNames
data: ElementFamilyNames.csv
name: Elements
data: Elements.csv
name: ElementTrade
data: ElementTrade.csv
name: Glossary
data: Glossary.csv
name: MPS Master
data: MPS Master.csv
name: MPS_Magic
data: MPS_Magic.csv
name: Navigation
data: Navigation.csv
name: New Engagements
data: New Engagements.csv
name: NewEngagementBDC
data: NewEngagementBDC.csv
name: NewEngagementNotes
data: NewEngagementNotes.csv
name: Phases
data: Phases.csv
name: PictureMatrix
data: PictureMatrix.csv
name: Process Steps
data: Process Steps.csv
name: ProcessLOD
data: ProcessLOD.csv
name: ProcessPhase
data: ProcessPhase.csv
name: ProcessPhasePivotRequiredLOD
data: ProcessPhasePivotRequiredLOD.csv
name: ProcessPhasePivotResultingLOD
data: ProcessPhasePivotResultingLOD.csv
name: ProcessSort
data: ProcessSort.csv
name: Project Info Pivot
data: Project Info Pivot.csv
name: Project Info Standards
data: Project Info Standards.csv
name: Project Info
data: Project Info.csv
name: SFOAssemblies
data: SFOAssemblies.csv
name: SFOAssetOmniClass
data: SFOAssetOmniClass.csv
label: Process Steps
Process
ProcessLOD
Process
Elements
Element Class
ElementClassProcess
Element Class
Elements
OmniClass Number
ElementTrade
OmniClass Number
Elements
OmniClass Number
ElementDesigner
OmniClass Number
Elements
Element Class
Element Classes
Element Class
EAD Attributes
ATTRIBUTE READABLE NAME
AssetAttributes
Attribute
AssetAttributes
Asset
SFOAssetOmniClass
Asset
SFOAssetOmniClass
OmniClass
Elements
OmniClass Number
ElementFamilyNames
Asset
SFOAssetOmniClass
Asset
SFOAssemblies
Assembly
SFOAssetOmniClass
Asset
ProcessPhase
Phase
ProcessSort
Phase
ProcessPhase
Process
ProcessLOD
Process
ProcessPhasePivotRequiredLOD
Process
ProcessLOD
Process
ProcessPhasePivotResultingLOD
Process
ProcessLOD
Process
Project Info Pivot
Project Name
PictureMatrix
Project Name
Contacts
Project Name
Project Info Pivot
Project Name
Project Info Standards
Project Name
PictureMatrix
Project Name
ALL BDC
Project Name
PictureMatrix
Project Name
Append1
Project Name
PictureMatrix
Project Name
ALL Notes
Project Name
NewEngagementBDC
Project Name
ALL Notes
ID
Action Items & Notes
ID
Append1
ID
Action Items & Notes
ID
output: {
    "joins": [
        {
            "from_table": "Process Steps",
            "from_column": "Process",
            "to_table": "ProcessLOD",
            "to_column": "Process"
        },
        {
            "from_table": "Elements",
            "from_column": "Element Class",
            "to_table": "ElementClassProcess",
            "to_column": "Element Class"
        },
        {
            "from_table": "Elements",
            "from_column": "OmniClass Number",
            "to_table": "ElementTrade",
            "to_column": "OmniClass Number"
        },
        {
            "from_table": "Elements",
            "from_column": "OmniClass Number",
            "to_table": "ElementDesigner",
            "to_column": "OmniClass Number"
        },
        {
            "from_table": "Elements",
            "from_column": "Element Class",
            "to_table": "Element Classes",
            "to_column": "Element Class"
        },
        {
            "from_table": "EAD Attributes",
            "from_column": "ATTRIBUTE READABLE NAME",
            "to_table": "AssetAttributes",
            "to_column": "Attribute"
        },
        {
            "from_table": "AssetAttributes",
            "from_column": "Asset",
            "to_table": "SFOAssetOmniClass",
            "to_column": "Asset"
        },
        {
            "from_table": "SFOAssetOmniClass",
            "from_column": "OmniClass",
            "to_table": "Elements",
            "to_column": "OmniClass Number"
        },
        {
            "from_table": "ElementFamilyNames",
            "from_column": "Asset",
            "to_table": "SFOAssetOmniClass",
            "to_column": "Asset"
        },
        {
            "from_table": "SFOAssemblies",
            "from_column": "Assembly",
            "to_table": "SFOAssetOmniClass",
            "to_column": "Asset"
        },
        {
            "from_table": "ProcessPhase",
            "from_column": "Phase",
            "to_table": "ProcessSort",
            "to_column": "Phase"
        },
        {
            "from_table": "ProcessPhase",
            "from_column": "Process",
            "to_table": "ProcessLOD",
            "to_column": "Process"
        },
        {
            "from_table": "ProcessPhasePivotRequiredLOD",
            "from_column": "Process",
            "to_table": "ProcessLOD",
            "to_column": "Process"
        },
        {
            "from_table": "ProcessPhasePivotResultingLOD",
            "from_column": "Process",
            "to_table": "ProcessLOD",
            "to_column": "Process"
        },
        {
            "from_table": "Project Info Pivot",
            "from_column": "Project Name",
            "to_table": "PictureMatrix",
            "to_column": "Project Name"
        },
        {
            "from_table": "Contacts",
            "from_column": "Project Name",
            "to_table": "Project Info Pivot",
            "to_column": "Project Name"
        },
        {
            "from_table": "Project Info Standards",
            "from_column": "Project Name",
            "to_table": "PictureMatrix",
            "to_column": "Project Name"
        },
        {
            "from_table": "ALL BDC",
            "from_column": "Project Name",
            "to_table": "PictureMatrix",
            "to_column": "Project Name"
        },
        {
            "from_table": "Append1",
            "from_column": "Project Name",
            "to_table": "PictureMatrix",
            "to_column": "Project Name"
        },
        {
            "from_table": "ALL Notes",
            "from_column": "Project Name",
            "to_table": "NewEngagementBDC",
            "to_column": "Project Name"
        },
        {
            "from_table": "ALL Notes",
            "from_column": "ID",
            "to_table": "Action Items & Notes",
            "to_column": "ID"
        },
        {
            "from_table": "Append1",
            "from_column": "ID",
            "to_table": "Action Items & Notes",
            "to_column": "ID"
        }
    ]
}