SmartPiant 3D Programming I

SmartPiant 3D Programming I

Student Workbook

Process,Power & Marine

Version 2009.1 March 2010 N/A

Copyright

Copyright © 2004-2008 Intergraph Corporation. All Rights Reserved.

Including software, file formats, and audiovisual displays; may be used pursuant to applicable software license agreement; contains confidential and proprietary information of Intergraph and/or third parties which is protected by copyright law, trade secret law, and international treaty, and may not be provided or otherwise made available without proper authorization.

Portions of this software are owned by Spatial Corp. © 1986-2008. All Rights Reserved.

Restricted Rights Legend

Use, duplication, or disclosure by the government is subject to restrictions as set forth below. For civilian agencies: This was developed at private expense and is “restricted computer software” submitted with restricted rights in accordance with subparagraphs (a) through (d) of the Commercial Computer Software - Restricted Rights clause at

52.227-19 of the Federal Acquisition Regulations (“FAR”) and its successors, and is unpublished and all rights are reserved under the copyright laws of the United States. For units of the Department of Defense (“DoD”): This is “commercial computer software” as defined at DFARS 252.227-7014 and the rights of the Government are as specified at DFARS 227.7202-3.

Unpublished – rights reserved under the copyright laws of the United States. Intergraph Corporation

Huntsville, Alabama 35894-0001

Warranties and Liabilities

All warranties given by Intergraph Corporation about equipment or software are set forth in your purchase contract, and nothing stated in, or implied by, this document or its contents shall be considered or deemed a modification or amendment of such warranties. Intergraph believes the information in this publication is accurate as of its publication date.

The information and the software discussed in this document are subject to change without notice and are subject to applicable technical product descriptions. Intergraph Corporation is not responsible for any error that may appear in this document.

The software discussed in this document is furnished under a license and may be used or copied only in accordance with the terms of this license.

No responsibility is assumed by Intergraph for the use or reliability of software on equipment that is not supplied by Intergraph or its affiliated companies. THE USER OF THE SOFTWARE IS EXPECTED TO MAKE THE FINAL EVALUATION AS TO THE USEFULNESS OF THE SOFTWARE IN HIS OWN ENVIRONMENT.

Intergraph is not responsible for the accuracy of delivered data including, but not limited to, catalog, reference and symbol data. Users should verify for themselves that the data is accurate and suitable for their project work.

Trademarks

Intergraph, the Intergraph logo, PDS, SmartPlant, FrameWorks, I-Convert, I-Export, I-Sketch, SmartMarine, IntelliShip, INtools, ISOGEN, MARIAN, SmartSketch, SPOOLGEN, SupportManager, and SupportModeler are trademarks or registered trademarks of Intergraph Corporation or its subsidiaries in the United States and other countries. Microsoft and Windows are registered trademarks of Microsoft Corporation. ACIS is a registered trademark of SPATIAL TECHNOLOGY, INC. Infragistics, Presentation Layer Framework, ActiveTreeView Ctrl, ProtoViewCtl, ActiveThreed Ctrl, ActiveListBar Ctrl, ActiveSplitter, ActiveToolbars Ctrl, ActiveToolbars Plus Ctrl, and ProtoView are trademarks of Infragistics, Inc. Portions of 2D DCM, 3D DCM, and HLM from D-Cubed

Limited are incorporated. All rights reserved. Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other brands and product names are trademarks of their respective owners.

Table of Contents

INTRODUCTION ..................................................................................................................................... 5

UNDERSTANDING SMART PLANT 3D DATA MODEL.......................................................................... 6

LAB 1: CREATE A QUERY THAT RETURNS ALL PART CLASSES OF TYPE SHAPESCLASS DEFINED IN THE CATALOG DATABASE............................................................................................ 17

LAB 2: CREATE A QUERY TO FIND OUT THE TOTAL NUMBER OF PART CLASSES IN THE CATALOG DATABASE ........................................................................................................................ 23

LAB 3: CREATE A QUERY TO LIST ALL SMART EQUIPMENT PARTS IN THE CATALOG

DATABASE .......................................................................................................................................... 25

LAB 4: LIST ALL EQUIPMENT SHAPES LOCATED IN THE PALETTE .............................................. 27

LAB 5: LIST ALL EQUIPMENTS LOCATED IN THE MODEL WITH ITS CORRESPONDING PART NAME FROM THE CATALOG DATABASE .......................................................................................... 29

LAB 6: LIST ALL PIPE RUNS AND PIPELINE NAMES LOCATED IN THE MODEL DATABASE ........ 32

LAB 7: LIST ALL OBJECT WITH NOTES IN THE MODEL DATABASE .............................................. 34

LAB 8: LIST ALL PIPE COMPONENT OCCURRENCES IN THE MODEL DATABASE PER PIPERUN38

LAB 9: LIST ALL VALVES OCCURRENCES LOCATED IN THE MODEL PER PIPERUN ................... 42

...