3 第二天：建模中Material_ID说明

新版改变了，毕竟ID用起来不直观嘛。
下一步研究Material_ID——Subtype是如何对应这些ID的。根据北京田经理提供的视频，导入excel数据的内容，似乎不用设置material为id模式了，直接用材料名称也可以了？

Material_ID	Subtype
3	2
2	1
2	3
1	1

Subtypes

Note: Shapefiles can be converted into Geodatabase Feature Classes if you would like to make use of Subtypes. See your ArcGIS documentation for more information.

If multiple types of HAMMER V8i elements have their data stored in a single geodatabase table, then each element must be a separate ArcGIS subtype. For example, in a valve table PRVs may be subtype 1, PSVs may be subtype 2, FCVs may be subtype 3, and so on. With subtypes, it is not necessary to follow the rule that each GIS/database feature type must be associated with a single type of GEMS model element. Note that the subtype field must be of the integer type (e.g., 1, 2) and not an alphanumeric field (e.g., PRV). For more information about subtypes, see ArcGIS Help.

ModelBuilder has built in support for subtypes. After selecting your data source, feature classes will automatically be categorized by subtype. This gives you the ability to assign mappings at the subtype level. For example, ModelBuilder allows you to exclude a particular subtype within a feature class, or associate each subtype with a different element type.

根据以上解释，subtype似乎与arcgis 有关。
那么material id终于查到，打开C:\Documents and Settings\All Users\Application Data\Bentley\WaterCAD\8\Libraries\MaterialLibrary.xml。同理，可打开流体介质的编号等
就可以知道管材对应的id了。
主要为玻璃纤维夹砂管27，PVC40，PE，钢管50，砼15，砼管（钢模）17，球墨铸铁管26，镀锌管30。

  - <MaterialLibrary>
<Id>17</Id> 
  <Guid>c994cf74-4cf9-4679-b50a-cd94ee7390aa</Guid> 
  <DateModified>2003-11-11T13:00:00+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Concrete (steel forms)</Label> 
  <Notes>Concrete (steel forms) notes</Notes> 
  <MaterialLibraryManningsCoefficient>0.011</MaterialLibraryManningsCoefficient> 
  <MaterialLibraryRoughnessHeight>0.006</MaterialLibraryRoughnessHeight> 
  <MaterialLibraryKuttersNCoefficient>0.011</MaterialLibraryKuttersNCoefficient> 
  <MaterialLibraryHazenWilliamsCCoefficient>140</MaterialLibraryHazenWilliamsCCoefficient> 
  </MaterialLibrary>

  <Id>26</Id> 
  <Guid>8b50b7ba-c842-42e3-89c4-b421a75b87b3</Guid> 
  <DateModified>2007-09-19T16:50:10.03125+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Ductile Iron</Label> 难道是球墨铸铁管？
  <Notes>Young's Modulus, Poisson's Ratio: Haestad, Walski, Chase, Savic, Grayman, Beckwith and Koelle, "Advanced Water Distribution Modeling and Management", Haestad Press, Waterbury CT USA, 2003.</Notes> 
  <MaterialLibraryManningsCoefficient>0.012</MaterialLibraryManningsCoefficient> 
  <MaterialLibraryRoughnessHeight>0.00085</MaterialLibraryRoughnessHeight> 
  <MaterialLibraryKuttersNCoefficient>0.012</MaterialLibraryKuttersNCoefficient> 
  <MaterialLibraryHazenWilliamsCCoefficient>130</MaterialLibraryHazenWilliamsCCoefficient> 
  <MaterialLibraryYoungsModulus>3592288800</MaterialLibraryYoungsModulus> 
  <MaterialLibraryPoissonsRatio>0.28</MaterialLibraryPoissonsRatio> 
  </MaterialLibrary>
- <MaterialLibrary>
  <Id>27</Id> 
  <Guid>f1fad5aa-c0f6-467a-b1d8-74f57ea159c4</Guid> 
  <DateModified>2003-11-11T13:00:00+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Fiberglass roving</Label> 玻璃纤维夹砂管
  <Notes>Fiberglass roving notes</Notes> 
 - <MaterialLibrary>
  <Id>40</Id> 
  <Guid>09620f57-afe6-4c3d-beda-63f944bbc80c</Guid> 
  <DateModified>2007-09-19T16:51:24.125+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>PVC</Label> PVC塑料管
  <Notes>Young's Modulus, Poisson's Ratio: Haestad, Walski, Chase, Savic, Grayman, Beckwith and Koelle, "Advanced Water Distribution Modeling and Management", Haestad Press, Waterbury CT USA, 2003.</Notes> 
  <MaterialLibraryManningsCoefficient>0.01</MaterialLibraryManningsCoefficient> 
  <MaterialLibraryRoughnessHeight>5E-06</MaterialLibraryRoughnessHeight> 
  <MaterialLibraryKuttersNCoefficient>0.01</MaterialLibraryKuttersNCoefficient> 
  <MaterialLibraryHazenWilliamsCCoefficient>150</MaterialLibraryHazenWilliamsCCoefficient> 
  <MaterialLibraryYoungsModulus>68921820</MaterialLibraryYoungsModulus> 
  <MaterialLibraryPoissonsRatio>0.45</MaterialLibraryPoissonsRatio> 
  </MaterialLibrary>
  <Id>50</Id> 
  <Guid>6148d8a9-6289-4070-bfda-e5bfced0c6e1</Guid> 
  <DateModified>2007-09-19T16:49:36.296875+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Steel</Label> 钢管
  <Notes>Young's Modulus, Poisson's Ratio: Haestad, Walski, Chase, Savic, Grayman, Beckwith and Koelle, "Advanced Water Distribution Modeling and Management", Haestad Press, Waterbury CT USA, 2003.</Notes> 
  <MaterialLibraryManningsCoefficient>0.013</MaterialLibraryManningsCoefficient> 
  <MaterialLibraryRoughnessHeight>0.00015</MaterialLibraryRoughnessHeight> 
  <MaterialLibraryKuttersNCoefficient>0.013</MaterialLibraryKuttersNCoefficient> 
  <MaterialLibraryHazenWilliamsCCoefficient>100</MaterialLibraryHazenWilliamsCCoefficient> 
  <MaterialLibraryYoungsModulus>4323277800</MaterialLibraryYoungsModulus> 
  <MaterialLibraryPoissonsRatio>0.3</MaterialLibraryPoissonsRatio> 
  </MaterialLibrary>

Note:

The data for each engineering library is stored in an XML file in your Bentley WaterCAD V8i program directory. We strongly recommend that you edit these files only using the built-in tools available by selecting Tools > Engineering Libraries.

- <LiquidLibrary>
  <Id>29</Id> 
  <Guid>6cb7a92a-76af-42f2-9058-2f5d968dd3e9</Guid> 
  <DateModified>2007-04-03T04:31:02.6212256+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Water at 20C(68F)</Label> 
  <Notes /> 
  <KinematicViscosity>1.08037365E-05</KinematicViscosity> 
  <SpecificGravity>0.998</SpecificGravity> 
  <Temperature>68</Temperature> 
  <VaporPressure>-10.09</VaporPressure> 
  <BulkModulusOfElasticity>45699927.924894176</BulkModulusOfElasticity> 
  </LiquidLibrary>
- <LiquidLibrary>
  <Id>30</Id> 
  <Guid>1070138e-e859-404f-aa0a-4f7acde12193</Guid> 
  <DateModified>2007-04-03T04:35:56.6689082+08:00</DateModified> 
  <ElementID>0</ElementID> 
  <Label>Water at 4C(39F)</Label> 
  <Notes /> 
  <KinematicViscosity>1.68519775E-05</KinematicViscosity> 
  <SpecificGravity>1</SpecificGravity> 
  <Temperature>39.2</Temperature> 
  <VaporPressure>-10.25</VaporPressure> 
  <BulkModulusOfElasticity>45699927.924894176</BulkModulusOfElasticity> 
  </LiquidLibrary>
  <HMIMetaData Guid="7eeb030a-44ba-4e3c-97cc-d68998496925" DateModified="2007-04-03T04:35:56.6689082+08:00" SchemaVersion="4.0.1.20" EngineeringLibraryType="LiquidLibrary" /> 
  </NewDataSet>