개정판 652e5de0
issue #663: fix scene attach and remove and save
Change-Id: Ia4d44c7cf46b8f84130269e79730fc23269791a5
| DTI_PID/DTI_PID/RecognitionDialog.py | ||
|---|---|---|
| 85 | 85 |
self.mutex = mutex |
| 86 | 86 |
self.cond = cond |
| 87 | 87 |
|
| 88 |
self.pre_data = {'Equipment Package':[], 'Text':[]}
|
|
| 89 |
|
|
| 88 | 90 |
''' |
| 89 | 91 |
@history 2018.05.25 Jeongwoo Add if-statements by isSymbolTextChecked and isLineChecked variable |
| 90 | 92 |
2018.05.28 Jeongwoo Add Parameter 'xmlPath[0]' |
| ... | ... | |
| 142 | 144 |
cv2.drawContours(image, selectedContours, -1, (255, 255, 255), -1) |
| 143 | 145 |
except Exception as ex: |
| 144 | 146 |
from App import App |
| 145 |
|
|
| 146 | 147 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 147 | 148 |
sys.exc_info()[-1].tb_lineno) |
| 148 | 149 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 200 | 201 |
# up to here |
| 201 | 202 |
except Exception as ex: |
| 202 | 203 |
from App import App |
| 203 |
|
|
| 204 | 204 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 205 | 205 |
sys.exc_info()[-1].tb_lineno) |
| 206 | 206 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 330 | 330 |
item.area = 'Drawing' |
| 331 | 331 |
#item.transfer.onRemoved.connect(self.itemRemoved) |
| 332 | 332 |
# self.addTextItemToScene(item) |
| 333 |
# appDocData.texts.append(item)
|
|
| 333 |
app_doc_data.texts.append(item)
|
|
| 334 | 334 |
app_doc_data.allItems.append(item) |
| 335 | 335 |
except Exception as ex: |
| 336 | 336 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| ... | ... | |
| 369 | 369 |
item.angle = angle |
| 370 | 370 |
item.area = textInfoMap[0] |
| 371 | 371 |
#item.transfer.onRemoved.connect(self.itemRemoved) |
| 372 |
# appDocData.texts.append(item)
|
|
| 372 |
app_doc_data.texts.append(item)
|
|
| 373 | 373 |
app_doc_data.allItems.append(item) |
| 374 | 374 |
except Exception as ex: |
| 375 | 375 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| ... | ... | |
| 405 | 405 |
item.angle = angle |
| 406 | 406 |
item.area = textInfos[0] |
| 407 | 407 |
# self.addTextItemToScene(item) |
| 408 |
# appDocData.texts.append(item)
|
|
| 408 |
app_doc_data.texts.append(item)
|
|
| 409 | 409 |
app_doc_data.allItems.append(item) |
| 410 | 410 |
except Exception as ex: |
| 411 | 411 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| ... | ... | |
| 761 | 761 |
# cv2.destroyAllWindows() |
| 762 | 762 |
return (True, mergedOtherLine) |
| 763 | 763 |
|
| 764 |
def load_recognition_data_from_xml(self): |
|
| 764 |
def load_recognition_data_from_xml(self, xmlPath):
|
|
| 765 | 765 |
from xml.etree.ElementTree import Element, SubElement, dump, ElementTree, parse |
| 766 | 766 |
from EngineeringVendorItem import QEngineeringVendorItem |
| 767 | 767 |
|
| 768 |
pass |
|
| 768 |
try: |
|
| 769 |
xml = parse(xmlPath) |
|
| 770 |
root = xml.getroot() |
|
| 771 |
|
|
| 772 |
# load equipment package |
|
| 773 |
if root.find('VENDORS') is not None:
|
|
| 774 |
for vendor in root.find('VENDORS').iter('VENDOR'):
|
|
| 775 |
item = QEngineeringVendorItem.fromXml(vendor) |
|
| 776 |
if item and item.pack_type =='Equipment Package': |
|
| 777 |
self.pre_data['Equipment Package'].append(item) |
|
| 769 | 778 |
|
| 770 |
def load_recognition_data_from_db(self): |
|
| 779 |
except Exception as ex: |
|
| 780 |
from App import App |
|
| 781 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
|
| 782 |
sys.exc_info()[-1].tb_lineno) |
|
| 783 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
|
| 784 |
|
|
| 785 |
def load_recognition_data_from_db(self, drawing): |
|
| 771 | 786 |
from EngineeringVendorItem import QEngineeringVendorItem |
| 772 | 787 |
|
| 773 |
pass |
|
| 788 |
try: |
|
| 789 |
app_doc_data = AppDocData.instance() |
|
| 790 |
|
|
| 791 |
components = app_doc_data.get_components(drawing.UID) |
|
| 792 |
|
|
| 793 |
# load equipment package |
|
| 794 |
for component in [component for component in components if |
|
| 795 |
component['Name'] == 'VendorPackage' and component['SymbolType_UID'] == -1]: |
|
| 796 |
item = QEngineeringVendorItem.from_database(component) |
|
| 797 |
if item and item.pack_type =='Equipment Package': |
|
| 798 |
self.pre_data['Equipment Package'].append(item) |
|
| 799 |
|
|
| 800 |
except Exception as ex: |
|
| 801 |
from App import App |
|
| 802 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
|
| 803 |
sys.exc_info()[-1].tb_lineno) |
|
| 804 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
|
| 774 | 805 |
|
| 775 | 806 |
@staticmethod |
| 776 | 807 |
def executeRecognition(path, listWidget, isLineChecked, worker): |
| ... | ... | |
| 1984 | 2015 |
searchedSymbolList.append(newSym) |
| 1985 | 2016 |
except Exception as ex: |
| 1986 | 2017 |
from App import App |
| 1987 |
|
|
| 1988 | 2018 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 1989 | 2019 |
sys.exc_info()[-1].tb_lineno) |
| 1990 | 2020 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 2059 | 2089 |
matchCount = count |
| 2060 | 2090 |
except Exception as ex: |
| 2061 | 2091 |
from App import App |
| 2062 |
|
|
| 2063 | 2092 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 2064 | 2093 |
sys.exc_info()[-1].tb_lineno) |
| 2065 | 2094 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 2157 | 2186 |
cv2.imwrite(os.path.join(project.getTempPath(), "FOUND_" + os.path.basename(drawingPath)), canvas) |
| 2158 | 2187 |
except Exception as ex: |
| 2159 | 2188 |
from App import App |
| 2160 |
|
|
| 2161 | 2189 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 2162 | 2190 |
sys.exc_info()[-1].tb_lineno) |
| 2163 | 2191 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 2320 | 2348 |
""" |
| 2321 | 2349 |
except Exception as ex: |
| 2322 | 2350 |
from App import App |
| 2323 |
|
|
| 2324 | 2351 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 2325 | 2352 |
sys.exc_info()[-1].tb_lineno) |
| 2326 | 2353 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 2555 | 2582 |
self.ui.progressBar.setValue(self.ui.progressBar.maximum()) |
| 2556 | 2583 |
except Exception as ex: |
| 2557 | 2584 |
from App import App |
| 2558 |
|
|
| 2559 | 2585 |
message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,
|
| 2560 | 2586 |
sys.exc_info()[-1].tb_lineno) |
| 2561 | 2587 |
App.mainWnd().addMessage.emit(MessageType.Error, message) |
| ... | ... | |
| 2608 | 2634 |
def add_detected_items_to_scene(self, scene) -> None: |
| 2609 | 2635 |
"""add detected items to scene""" |
| 2610 | 2636 |
from SaveWorkCommand import SaveWorkCommand |
| 2637 |
from EngineeringVendorItem import QEngineeringVendorItem |
|
| 2611 | 2638 |
|
| 2612 | 2639 |
app_doc_data = AppDocData.instance() |
| 2613 | 2640 |
|
| 2614 | 2641 |
try: |
| 2642 |
for key, items in self.obj.pre_data.items(): |
|
| 2643 |
for item in items: |
|
| 2644 |
if issubclass(type(item), QEngineeringVendorItem): |
|
| 2645 |
app_doc_data.symbols.append(item) |
|
| 2646 |
app_doc_data.allItems.append(item) |
|
| 2647 |
|
|
| 2648 |
# symbol need to be attached for scene position |
|
| 2615 | 2649 |
for symbol in app_doc_data.symbols: |
| 2616 | 2650 |
if issubclass(type(symbol), SymbolSvgItem): |
| 2617 | 2651 |
symbol.addSvgItemToScene(scene) |
| 2618 | 2652 |
else: |
| 2619 | 2653 |
scene.addItem(symbol) |
| 2620 | 2654 |
|
| 2655 |
# text no need to be attached |
|
| 2656 |
''' |
|
| 2621 | 2657 |
for text in app_doc_data.texts: |
| 2622 | 2658 |
text.addTextItemToScene(scene) |
| 2623 | 2659 |
|
| 2624 | 2660 |
for lineNo in app_doc_data.tracerLineNos: |
| 2625 | 2661 |
lineNo.addTextItemToScene(scene) |
| 2662 |
''' |
|
| 2626 | 2663 |
|
| 2627 | 2664 |
# remove lines which is located inside symbol |
| 2628 | 2665 |
for symbol in app_doc_data.symbols: |
| 2629 | 2666 |
rect = symbol.sceneBoundingRect() |
| 2630 | 2667 |
rect.adjust(-10, -10, 10, 10) |
| 2631 | 2668 |
matches = [line for line in app_doc_data.lines if rect.contains(line.line().p1()) and |
| 2632 |
rect.contains(line.line().p2()) and |
|
| 2633 |
not line.has_connection] |
|
| 2634 |
app_doc_data.lines = [line for line in app_doc_data.lines if line not in matches] |
|
| 2669 |
rect.contains(line.line().p2()) and not line.has_connection] |
|
| 2670 |
for line in matches: |
|
| 2671 |
app_doc_data.allItems.remove(line) |
|
| 2672 |
app_doc_data.lines.remove(line) |
|
| 2635 | 2673 |
# up to here |
| 2636 | 2674 |
|
| 2637 | 2675 |
for line in app_doc_data.lines: |
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 2040 | 2040 |
MetricStr VARCHAR(32), |
| 2041 | 2041 |
AllowableMetricStr TEXT |
| 2042 | 2042 |
); |
| 2043 |
|
|
| 2044 |
INSERT INTO NominalDiameter |
|
| 2045 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2046 |
VALUES('07e609cc-0bb3-49fb-958a-cfb9a8230021', 'a', 950, 38, '38"', '38'',38II', '950', '');
|
|
| 2047 |
INSERT INTO NominalDiameter |
|
| 2048 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2049 |
VALUES('4d5ad658-58d0-4f0a-a939-50bf8a996356', '9', 900, 36, '36"', '36'',36II', '900', '');
|
|
| 2050 |
INSERT INTO NominalDiameter |
|
| 2051 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2052 |
VALUES('b2b4d9ab-b7b0-4256-995c-b601f878fb96', 'M', 90, 3.5, '3-1/2"', '3-1/2'',3-1/2II,31/2",31/2'',31/2II', '90', '');
|
|
| 2053 |
INSERT INTO NominalDiameter |
|
| 2054 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2055 |
VALUES('8e8cc07d-594b-473d-bd4f-337bcbc218f3', '8', 850, 34, '34"', '34'',34II', '850', '');
|
|
| 2056 |
INSERT INTO NominalDiameter |
|
| 2057 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2058 |
VALUES('044d4b82-892d-4135-a1d0-efa8efc42a2a', '7', 800, 32, '32"', '32'',32II', '800', '');
|
|
| 2059 |
INSERT INTO NominalDiameter |
|
| 2060 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2061 |
VALUES('fa9f1caf-e632-43d8-a7c9-af8adc32694d', 'L', 80, 3, '3"', '3'',3II', '80', '');
|
|
| 2062 |
INSERT INTO NominalDiameter |
|
| 2063 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2064 |
VALUES('33729f84-32f1-40b0-a50c-7bbd5c4cb1f2', 'B', 8, 0.25, '1/4"', '1/4'',1/4II', '8', '');
|
|
| 2065 |
INSERT INTO NominalDiameter |
|
| 2066 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2067 |
VALUES('31af672c-892a-483c-9c0e-9c61076ae46c', '6', 750, 30, '30"', '30'',30II', '750', '');
|
|
| 2068 |
INSERT INTO NominalDiameter |
|
| 2069 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2070 |
VALUES('6b97bc58-7b34-4800-98c6-340a76ccf746', '5', 700, 28, '28"', '28'',28II', '700', '');
|
|
| 2071 |
INSERT INTO NominalDiameter |
|
| 2072 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2073 |
VALUES('05aadcd8-1f60-451b-9b68-133c52cfac8e', '4', 650, 26, '26"', '26'',26II', '650', '');
|
|
| 2074 |
INSERT INTO NominalDiameter |
|
| 2075 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2076 |
VALUES('a96c1723-1013-4c54-8fc5-330006a26bfb', 'K', 65, 2.5, '2-1/2"', '2-1/2'',2-1/2II,21/2",21/2'',21/2II', '65', '');
|
|
| 2077 |
INSERT INTO NominalDiameter |
|
| 2078 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2079 |
VALUES('90b4fb10-a7d8-4c7d-987d-24ca3e8525d4', '3', 600, 24, '24"', '24'',24II', '600', '');
|
|
| 2080 |
INSERT INTO NominalDiameter |
|
| 2081 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2082 |
VALUES('cfba13af-12bc-4564-9b90-b6a9660f19a2', 'A', 6, 0.125, '1/8"', '1/8'',1/8II', '6', '');
|
|
| 2083 |
INSERT INTO NominalDiameter |
|
| 2084 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2085 |
VALUES('ba659bb2-7fbc-4d52-9231-b9e5aaed62d3', '2', 550, 22, '22"', '22'',22II', '550', '');
|
|
| 2086 |
INSERT INTO NominalDiameter |
|
| 2087 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2088 |
VALUES('eec21178-d1b8-408b-a099-2e854d1136e3', '1', 500, 20, '20"', '20'',20II', '500', '');
|
|
| 2089 |
INSERT INTO NominalDiameter |
|
| 2090 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2091 |
VALUES('b281af61-3b3f-422d-ace3-1daf84480114', 'J', 50, 2, '2"', '2'',2II', '50', '');
|
|
| 2092 |
INSERT INTO NominalDiameter |
|
| 2093 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2094 |
VALUES('c00c8044-028d-4e32-a265-47bd94775229', 'Z', 450, 18, '18"', '18'',18II', '450', '');
|
|
| 2095 |
INSERT INTO NominalDiameter |
|
| 2096 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2097 |
VALUES('be76eae4-9a84-4564-aed7-23e3593d7bac', 'Y', 400, 16, '16"', '16'',16II', '400', '');
|
|
| 2098 |
INSERT INTO NominalDiameter |
|
| 2099 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2100 |
VALUES('34d19b37-8996-4205-a553-cbfefc4c1e4d', 'H', 40, 1.5, '1-1/2"', '1-1/2'',1-1/2II,11/2",11/2'',11/2II', '40', '');
|
|
| 2101 |
INSERT INTO NominalDiameter |
|
| 2102 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2103 |
VALUES('c6dfa499-1bae-4405-96f1-b0b322ff639c', 'X', 350, 14, '14"', '14'',14II', '350', '');
|
|
| 2104 |
INSERT INTO NominalDiameter |
|
| 2105 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2106 |
VALUES('8a807f26-6792-4858-9d29-8b6a40ebfebd', 'G', 32, 1.25, '1-1/4"', '1-1/4'',1-1/4II,11/4",11/4'',11/4II', '32', '');
|
|
| 2107 |
INSERT INTO NominalDiameter |
|
| 2108 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2109 |
VALUES('6749f3fc-5fd3-4395-ab4d-579f0f3aab46', 'W', 300, 12, '12"', '12'',12II', '300', '');
|
|
| 2110 |
INSERT INTO NominalDiameter |
|
| 2111 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2112 |
VALUES('ca151b57-7f48-46ee-b952-35047cadb01c', '1I', 2500, 100, '100"', '100'',100II', '2500', '');
|
|
| 2113 |
INSERT INTO NominalDiameter |
|
| 2114 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2115 |
VALUES('d341f28e-81bc-451f-a869-a305784e7a90', 'V', 250, 10, '10"', '10'',10II', '250', '');
|
|
| 2116 |
INSERT INTO NominalDiameter |
|
| 2117 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2118 |
VALUES('fd114262-95e6-403e-9578-f33a521ee530', 'F', 25, 1, '1"', '1'',1II', '25', '');
|
|
| 2119 |
INSERT INTO NominalDiameter |
|
| 2120 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2121 |
VALUES('c2aa3e4a-5791-4555-bf99-b6a5ac9224e0', '1H', 2450, 98, '98"', '98'',98II', '2450', '');
|
|
| 2122 |
INSERT INTO NominalDiameter |
|
| 2123 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2124 |
VALUES('ef853d1b-6714-4aa3-8eda-6861ecc431db', '1G', 2400, 96, '96"', '96'',96II', '2400', '');
|
|
| 2125 |
INSERT INTO NominalDiameter |
|
| 2126 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2127 |
VALUES('5888336a-ad22-4564-a678-15a90910cab2', '1F', 2350, 94, '94"', '94'',94II', '2350', '');
|
|
| 2128 |
INSERT INTO NominalDiameter |
|
| 2129 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2130 |
VALUES('561b7ee6-432f-45d7-98bb-88bd5aac46bd', '1D', 2300, 92, '92"', '92'',92II', '2300', '');
|
|
| 2131 |
INSERT INTO NominalDiameter |
|
| 2132 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2133 |
VALUES('9fbfc2d4-0f99-4574-8922-3e7c976635b5', '1C', 2250, 90, '90"', '90'',90II', '2250', '');
|
|
| 2134 |
INSERT INTO NominalDiameter |
|
| 2135 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2136 |
VALUES('03354522-4d43-486a-bbc3-b2122e2b53b1', '1B', 2200, 88, '88"', '88'',88II', '2200', '');
|
|
| 2137 |
INSERT INTO NominalDiameter |
|
| 2138 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2139 |
VALUES('f0163842-3bcd-467f-b418-b0618c91ca07', '1A', 2150, 86, '86"', '86'',86II', '2150', '');
|
|
| 2140 |
INSERT INTO NominalDiameter |
|
| 2141 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2142 |
VALUES('45a5e030-ca82-4982-9bf2-45596692f5dd', 'z', 2100, 84, '84"', '84'',84II', '2100', '');
|
|
| 2143 |
INSERT INTO NominalDiameter |
|
| 2144 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2145 |
VALUES('8e3b1b8a-36ff-491f-9283-296adbc872de', 'y', 2050, 82, '82"', '82'',82II', '2050', '');
|
|
| 2146 |
INSERT INTO NominalDiameter |
|
| 2147 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2148 |
VALUES('3ea84356-2491-43e4-a414-7ec94454d0b9', 'x', 2000, 80, '80"', '80'',80II', '2000', '');
|
|
| 2149 |
INSERT INTO NominalDiameter |
|
| 2150 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2151 |
VALUES('ac03e003-918f-4c53-82bd-eea3ec1b8f7a', 'T', 200, 8, '8"', '8'',8II', '200', '');
|
|
| 2152 |
INSERT INTO NominalDiameter |
|
| 2153 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2154 |
VALUES('076c3483-78e8-4737-bdb7-c0e98db749ca', 'E', 20, 0.75, '3/4"', '3/4'',3/4II', '20', '');
|
|
| 2155 |
INSERT INTO NominalDiameter |
|
| 2156 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2157 |
VALUES('548f2d92-2410-4c28-b374-b9ae0999df21', 'w', 1950, 78, '78"', '78'',78II', '1950', '');
|
|
| 2158 |
INSERT INTO NominalDiameter |
|
| 2159 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2160 |
VALUES('2b42782c-5ece-4e6f-a6c1-dbbe9947e484', 'v', 1900, 76, '76"', '76'',76II', '1900', '');
|
|
| 2161 |
INSERT INTO NominalDiameter |
|
| 2162 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2163 |
VALUES('c71a1240-4a6c-4a7c-ad58-89e30092926e', 'u', 1850, 74, '74"', '74'',74II', '1850', '');
|
|
| 2164 |
INSERT INTO NominalDiameter |
|
| 2165 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2166 |
VALUES('0ddeeb03-2f56-42aa-9be1-0aad2f3c0fa2', 't', 1800, 72, '72"', '72'',72II', '1800', '');
|
|
| 2167 |
INSERT INTO NominalDiameter |
|
| 2168 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2169 |
VALUES('3c2dbcef-4882-49d9-923c-51c39b0929d0', 's', 1750, 70, '70"', '70'',70II', '1750', '');
|
|
| 2170 |
INSERT INTO NominalDiameter |
|
| 2171 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2172 |
VALUES('9bba575b-4561-46a9-9970-d57eef2ee45b', 'r', 1700, 68, '68"', '68'',68II', '1700', '');
|
|
| 2173 |
INSERT INTO NominalDiameter |
|
| 2174 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2175 |
VALUES('8fe5d311-eacd-4192-8be0-14aa47268066', 'q', 1650, 66, '66"', '66'',66II', '1650', '');
|
|
| 2176 |
INSERT INTO NominalDiameter |
|
| 2177 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2178 |
VALUES('ba7d6531-6782-4d7f-ae53-5d41bfe96c65', 'p', 1600, 64, '64"', '64'',64II', '1600', '');
|
|
| 2179 |
INSERT INTO NominalDiameter |
|
| 2180 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2181 |
VALUES('9c6fe456-9c6f-406e-8768-b57fda8faa2d', 'o', 1550, 62, '62"', '62'',62II', '1550', '');
|
|
| 2182 |
INSERT INTO NominalDiameter |
|
| 2183 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2184 |
VALUES('2db02c6e-c176-498a-97fc-342e0fc44fdd', 'n', 1500, 60, '60"', '60'',60II', '1500', '');
|
|
| 2185 |
INSERT INTO NominalDiameter |
|
| 2186 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2187 |
VALUES('6a072228-8fdf-41b7-b39a-9a2e316bbf0a', 'R', 150, 6, '6"', '6'',6II', '150', '');
|
|
| 2188 |
INSERT INTO NominalDiameter |
|
| 2189 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2190 |
VALUES('91b27aed-fcd1-4320-bccd-dc3975ad759b', 'D', 15, 0.5, '1/2"', '1/2'',1/2II', '15', '');
|
|
| 2191 |
INSERT INTO NominalDiameter |
|
| 2192 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2193 |
VALUES('fa44d471-33d7-4287-b925-14708a1b6456', 'm', 1450, 58, '58"', '58'',58II', '1450', '');
|
|
| 2194 |
INSERT INTO NominalDiameter |
|
| 2195 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2196 |
VALUES('47a70994-fa8e-4ac5-9a7e-4a749d0175ad', 'k', 1400, 56, '56"', '56'',56II', '1400', '');
|
|
| 2197 |
INSERT INTO NominalDiameter |
|
| 2198 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2199 |
VALUES('6d04371a-e750-48fe-a78b-3bab983dfe53', 'j', 1350, 54, '54"', '54'',54II', '1350', '');
|
|
| 2200 |
INSERT INTO NominalDiameter |
|
| 2201 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2202 |
VALUES('e9146c71-14e7-4d12-b789-2960180dc60a', 'h', 1300, 52, '52"', '52'',52II', '1300', '');
|
|
| 2203 |
INSERT INTO NominalDiameter |
|
| 2204 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2205 |
VALUES('4f2647ab-7943-42e7-be9b-058d97750a6c', 'g', 1250, 50, '50"', '50'',50II', '1250', '');
|
|
| 2206 |
INSERT INTO NominalDiameter |
|
| 2207 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2208 |
VALUES('a06f8fe5-9d2e-406e-97bc-97a5d76cd139', 'P', 125, 5, '5"', '5'',5II', '125', '');
|
|
| 2209 |
INSERT INTO NominalDiameter |
|
| 2210 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2211 |
VALUES('f0b0f215-bfa2-47f6-a26d-3c98de94dc9c', 'f', 1200, 48, '48"', '48'',48II', '1200', '');
|
|
| 2212 |
INSERT INTO NominalDiameter |
|
| 2213 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2214 |
VALUES('65d82403-8526-4005-8b6c-09f46269b5a8', 'd', 1100, 44, '44"', '44'',44II', '1100', '');
|
|
| 2215 |
INSERT INTO NominalDiameter |
|
| 2216 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2217 |
VALUES('f254b950-c297-4ecd-b5ec-17756b832fb2', 'c', 1050, 42, '42"', '42'',42II', '1050', '');
|
|
| 2218 |
INSERT INTO NominalDiameter |
|
| 2219 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2220 |
VALUES('5342dd64-b75f-48a0-bfbc-ae3ec17a3c1d', 'b', 1000, 40, '40"', '40'',40II', '1000', '');
|
|
| 2221 |
INSERT INTO NominalDiameter |
|
| 2222 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2223 |
VALUES('51613bfd-fbc0-4ec5-9cc8-ef4e599d246c', 'N', 100, 4, '4"', '4'',4II', '100', '');
|
|
| 2224 |
INSERT INTO NominalDiameter |
|
| 2225 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2226 |
VALUES('2c204f86-4361-45c9-ad77-460f129e4f89', 'C', 10, 0.375, '3/8"', '3/8'',3/8II', '10', '');
|
|
| 2227 |
INSERT INTO NominalDiameter |
|
| 2228 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2229 |
VALUES('f927ea9e-79d2-487e-a433-cf5e3899d207', 'Q', '', '', '', '', '', '');
|
|
| 2230 |
INSERT INTO NominalDiameter |
|
| 2231 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2232 |
VALUES('90cf2271-ce3c-4850-8110-b44308d4613d', '0', 1, 1, '', '', '', '');
|
|
| 2233 |
INSERT INTO NominalDiameter |
|
| 2234 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2235 |
VALUES('50c85e7c-b908-4395-9e50-87f7a3d2668e', 'S', '', '', '', '', '', '');
|
|
| 2236 |
INSERT INTO NominalDiameter |
|
| 2237 |
(UID, Code, Metric, Inch, InchStr, AllowableInchStr, MetricStr, AllowableMetricStr) |
|
| 2238 |
VALUES('a54d2033-42cb-4aa4-8990-41ebb0a09dd9', 'U', '', '', '', '', '', '');
|
|
| 2239 |
|
|
| 2043 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2044 |
'07e609cc-0bb3-49fb-958a-cfb9a8230021','a',950,38,'38"','38'',38II,38','950',''); |
|
| 2045 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2046 |
'4d5ad658-58d0-4f0a-a939-50bf8a996356','9',900,36,'36"','36'',36II,36','900',''); |
|
| 2047 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2048 |
'b2b4d9ab-b7b0-4256-995c-b601f878fb96','M',90,3.5,'3-1/2"','3-1/2'',3-1/2II,31/2",31/2'',31/2II,31/2,3-1/2','90',''); |
|
| 2049 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2050 |
'8e8cc07d-594b-473d-bd4f-337bcbc218f3','8',850,34,'34"','34'',34II,34','850',''); |
|
| 2051 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2052 |
'044d4b82-892d-4135-a1d0-efa8efc42a2a','7',800,32,'32"','32'',32II,32','800',''); |
|
| 2053 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2054 |
'fa9f1caf-e632-43d8-a7c9-af8adc32694d','L',80,3,'3"','3'',3II,3','80',''); |
|
| 2055 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2056 |
'33729f84-32f1-40b0-a50c-7bbd5c4cb1f2','B',8,0.25,'1/4"','1/4'',1/4II,1/4','8',''); |
|
| 2057 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2058 |
'31af672c-892a-483c-9c0e-9c61076ae46c','6',750,30,'30"','30'',30II,30','750',''); |
|
| 2059 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2060 |
'6b97bc58-7b34-4800-98c6-340a76ccf746','5',700,28,'28"','28'',28II,28','700',''); |
|
| 2061 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2062 |
'05aadcd8-1f60-451b-9b68-133c52cfac8e','4',650,26,'26"','26'',26II,26','650',''); |
|
| 2063 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2064 |
'a96c1723-1013-4c54-8fc5-330006a26bfb','K',65,2.5,'2-1/2"','2-1/2'',2-1/2II,21/2",21/2'',21/2II,21/2,2-1/2','65',''); |
|
| 2065 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2066 |
'90b4fb10-a7d8-4c7d-987d-24ca3e8525d4','3',600,24,'24"','24'',24II,24','600',''); |
|
| 2067 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2068 |
'cfba13af-12bc-4564-9b90-b6a9660f19a2','A',6,0.125,'1/8"','1/8'',1/8II,1/8','6',''); |
|
| 2069 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2070 |
'ba659bb2-7fbc-4d52-9231-b9e5aaed62d3','2',550,22,'22"','22'',22II,22','550',''); |
|
| 2071 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2072 |
'eec21178-d1b8-408b-a099-2e854d1136e3','1',500,20,'20"','20'',20II,20','500',''); |
|
| 2073 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2074 |
'b281af61-3b3f-422d-ace3-1daf84480114','J',50,2,'2"','2'',2II,2','50',''); |
|
| 2075 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2076 |
'c00c8044-028d-4e32-a265-47bd94775229','Z',450,18,'18"','18'',18II,18','450',''); |
|
| 2077 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2078 |
'be76eae4-9a84-4564-aed7-23e3593d7bac','Y',400,16,'16"','16'',16II,16','400',''); |
|
| 2079 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2080 |
'34d19b37-8996-4205-a553-cbfefc4c1e4d','H',40,1.5,'1-1/2"','1-1/2'',1-1/2II,11/2",11/2'',11/2II,11/2,1-1/2','40',''); |
|
| 2081 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2082 |
'c6dfa499-1bae-4405-96f1-b0b322ff639c','X',350,14,'14"','14'',14II,14','350',''); |
|
| 2083 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2084 |
'8a807f26-6792-4858-9d29-8b6a40ebfebd','G',32,1.25,'1-1/4"','1-1/4'',1-1/4II,11/4",11/4'',11/4II,11/4,1-1/4','32',''); |
|
| 2085 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2086 |
'6749f3fc-5fd3-4395-ab4d-579f0f3aab46','W',300,12,'12"','12'',12II,12','300',''); |
|
| 2087 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2088 |
'ca151b57-7f48-46ee-b952-35047cadb01c','1I',2500,100,'100"','100'',100II,100','2500',''); |
|
| 2089 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2090 |
'd341f28e-81bc-451f-a869-a305784e7a90','V',250,10,'10"','10'',10II,10','250',''); |
|
| 2091 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2092 |
'fd114262-95e6-403e-9578-f33a521ee530','F',25,1,'1"','1'',1II,1','25',''); |
|
| 2093 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2094 |
'c2aa3e4a-5791-4555-bf99-b6a5ac9224e0','1H',2450,98,'98"','98'',98II,98','2450',''); |
|
| 2095 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2096 |
'ef853d1b-6714-4aa3-8eda-6861ecc431db','1G',2400,96,'96"','96'',96II,96','2400',''); |
|
| 2097 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2098 |
'5888336a-ad22-4564-a678-15a90910cab2','1F',2350,94,'94"','94'',94II,94','2350',''); |
|
| 2099 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2100 |
'561b7ee6-432f-45d7-98bb-88bd5aac46bd','1D',2300,92,'92"','92'',92II,92','2300',''); |
|
| 2101 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2102 |
'9fbfc2d4-0f99-4574-8922-3e7c976635b5','1C',2250,90,'90"','90'',90II,90','2250',''); |
|
| 2103 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2104 |
'03354522-4d43-486a-bbc3-b2122e2b53b1','1B',2200,88,'88"','88'',88II,88','2200',''); |
|
| 2105 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2106 |
'f0163842-3bcd-467f-b418-b0618c91ca07','1A',2150,86,'86"','86'',86II,86','2150',''); |
|
| 2107 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2108 |
'45a5e030-ca82-4982-9bf2-45596692f5dd','z',2100,84,'84"','84'',84II,84','2100',''); |
|
| 2109 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2110 |
'8e3b1b8a-36ff-491f-9283-296adbc872de','y',2050,82,'82"','82'',82II,82','2050',''); |
|
| 2111 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2112 |
'3ea84356-2491-43e4-a414-7ec94454d0b9','x',2000,80,'80"','80'',80II,80','2000',''); |
|
| 2113 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2114 |
'ac03e003-918f-4c53-82bd-eea3ec1b8f7a','T',200,8,'8"','8'',8II,8','200',''); |
|
| 2115 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2116 |
'076c3483-78e8-4737-bdb7-c0e98db749ca','E',20,0.75,'3/4"','3/4'',3/4II,3/4','20',''); |
|
| 2117 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2118 |
'548f2d92-2410-4c28-b374-b9ae0999df21','w',1950,78,'78"','78'',78II,78','1950',''); |
|
| 2119 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2120 |
'2b42782c-5ece-4e6f-a6c1-dbbe9947e484','v',1900,76,'76"','76'',76II,76','1900',''); |
|
| 2121 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2122 |
'c71a1240-4a6c-4a7c-ad58-89e30092926e','u',1850,74,'74"','74'',74II,74','1850',''); |
|
| 2123 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2124 |
'0ddeeb03-2f56-42aa-9be1-0aad2f3c0fa2','t',1800,72,'72"','72'',72II,72','1800',''); |
|
| 2125 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2126 |
'3c2dbcef-4882-49d9-923c-51c39b0929d0','s',1750,70,'70"','70'',70II,70','1750',''); |
|
| 2127 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2128 |
'9bba575b-4561-46a9-9970-d57eef2ee45b','r',1700,68,'68"','68'',68II,68','1700',''); |
|
| 2129 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2130 |
'8fe5d311-eacd-4192-8be0-14aa47268066','q',1650,66,'66"','66'',66II,66','1650',''); |
|
| 2131 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2132 |
'ba7d6531-6782-4d7f-ae53-5d41bfe96c65','p',1600,64,'64"','64'',64II,64','1600',''); |
|
| 2133 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2134 |
'9c6fe456-9c6f-406e-8768-b57fda8faa2d','o',1550,62,'62"','62'',62II,62','1550',''); |
|
| 2135 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2136 |
'2db02c6e-c176-498a-97fc-342e0fc44fdd','n',1500,60,'60"','60'',60II,60','1500',''); |
|
| 2137 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2138 |
'6a072228-8fdf-41b7-b39a-9a2e316bbf0a','R',150,6,'6"','6'',6II,6','150',''); |
|
| 2139 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2140 |
'91b27aed-fcd1-4320-bccd-dc3975ad759b','D',15,0.5,'1/2"','1/2'',1/2II,1/2','15',''); |
|
| 2141 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2142 |
'fa44d471-33d7-4287-b925-14708a1b6456','m',1450,58,'58"','58'',58II,58','1450',''); |
|
| 2143 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2144 |
'47a70994-fa8e-4ac5-9a7e-4a749d0175ad','k',1400,56,'56"','56'',56II,56','1400',''); |
|
| 2145 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2146 |
'6d04371a-e750-48fe-a78b-3bab983dfe53','j',1350,54,'54"','54'',54II,54','1350',''); |
|
| 2147 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2148 |
'e9146c71-14e7-4d12-b789-2960180dc60a','h',1300,52,'52"','52'',52II,52','1300',''); |
|
| 2149 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2150 |
'4f2647ab-7943-42e7-be9b-058d97750a6c','g',1250,50,'50"','50'',50II,50','1250',''); |
|
| 2151 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2152 |
'a06f8fe5-9d2e-406e-97bc-97a5d76cd139','P',125,5,'5"','5'',5II,5','125',''); |
|
| 2153 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2154 |
'f0b0f215-bfa2-47f6-a26d-3c98de94dc9c','f',1200,48,'48"','48'',48II,48','1200',''); |
|
| 2155 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2156 |
'65d82403-8526-4005-8b6c-09f46269b5a8','d',1100,44,'44"','44'',44II,44','1100',''); |
|
| 2157 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2158 |
'f254b950-c297-4ecd-b5ec-17756b832fb2','c',1050,42,'42"','42'',42II,42','1050',''); |
|
| 2159 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2160 |
'5342dd64-b75f-48a0-bfbc-ae3ec17a3c1d','b',1000,40,'40"','40'',40II,40','1000',''); |
|
| 2161 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2162 |
'51613bfd-fbc0-4ec5-9cc8-ef4e599d246c','N',100,4,'4"','4'',4II,4','100',''); |
|
| 2163 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2164 |
'2c204f86-4361-45c9-ad77-460f129e4f89','C',10,0.375,'3/8"','3/8'',3/8II,3/8','10',''); |
|
| 2165 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2166 |
'f927ea9e-79d2-487e-a433-cf5e3899d207','Q','','','','','',''); |
|
| 2167 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2168 |
'90cf2271-ce3c-4850-8110-b44308d4613d','0',1,1,'','','',''); |
|
| 2169 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2170 |
'50c85e7c-b908-4395-9e50-87f7a3d2668e','S','','','','','',''); |
|
| 2171 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
|
| 2172 |
'a54d2033-42cb-4aa4-8990-41ebb0a09dd9','U','','','','','',''); |
|
| 2240 | 2173 |
|
| 2241 | 2174 |
CREATE TABLE NOTE_DATA_LIST ( |
| 2242 | 2175 |
UID VARCHAR (37), |
내보내기 Unified diff
