Parent Layer: Utility Access

Name: Water_Arc

Display Field: ABND

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: DATA DICTIONARYCONTENTSI. GENERAL A. PATs & AATs B. METADATAII. WATER A. POINT DATA (DATs) B. POINT RELATES (LNXs) C. LINE DATA (DATs) D. LINE RELATES (LNXs)III. STORM SEWER A. POINT DATA (DATs) B. POINT RELATES (LNXs) C. LINE DATA (DATs) D. LINE RELATES (LNXs)IV. SANITARY SEWER A. POINT DATA (DATs) B. POINT RELATES (LNXs) C. LINE DATA (DATs) D. LINE RELATES (LNXs)(GENERAL .PAT AND .AAT)Coverage Primary KeyWater water_pkStorm Sewer stmsewer_pkSanitary Sewer sansewer_pk(METADATA FOR STMSEWER, SANSEWER, AND WATER)meta_data_fk is the linking item for the stmsewer_point.dat.dolr date on asbuiltsheetof sheet number x of yhscale horizontal scale on asbuiltvscale vertical scale on asbuilteng_firm engineering firmreg_engineer registered engineerasbuilt-no asbuilt numberdig_tech digitizing techniquedig_by digitized bydate_dig date digitizeddata_source data sourcemap_title map title(WATER POINT DATA)About the Items in water_point.datwater_fk is the linking item for the water.pat table.v_type_pk is the linking item to the v_type.lnx relate table.v_size valve size in inches ** N/A or UNKNOWN records for this item are denoted with -9v_manufctr_pk is the linking item to the v_manufacturer.lnx relate table.h_manufctr_pk is the linking item to the h_manufacturer.lnx relate table.h_lsize hydrant line size in inches ** N/A or UNKNOWN records for this item are denoted with -9h_rsize hydrant riser size in inches ** N/A or UNKNOWN records for this item are denoted with -9m_type_pk is the linking item to the m_type.lnx relate table.m_size meter size in inches ** N/A or UNKNOWN records for this item are denoted with -9abnd indicates whether feature is abandoned. Y = abandoned, N = not abandoned.meta_data_pk is the linking item to the water_md.lnx relate table.(WATER POINT RELATES)Itmes in v_type.lnxRecord V_TYPE_FK V_TYPE 1 1 TAPPING SLEEVE & VALVE 2 2 BLOW OFF 3 3 CONTROL 4 4 GATE 5 5 UNKNOWN 6 6 N/A 7 7 FLUSH 8 8 COUPLER 9 9 CHECK 10 10 GLOBE Items in v_manufacturer.lnxRecord V_MANUFCTR_FK V_MANUFACTURE 1 1 AWWA 2 2 WALWARTH 3 3 MUELLER 4 4 RAINBIRD 5 5 N/A 6 6 UNKNOWN 7 7 BALL Items in h_manufacturer.lnxRecord H_MANUFCTR_FK H_MANUFACTURER 1 6 N/A 2 7 UNKNOWN 3 1 MUELLER Items in m_type.lnxRecord M_TYPE_FK M_TYPE 1 5 UNKNOWN 2 6 N/A 3 1 FLOW 4 2 TURBINE 5 4 2-WAY 6 3 DOUBLE (WATER LINE DATA)About Items in water_arc.datwater_fk is the linking item for the water.aat table.p_mat_pk is the linking item to the p_mat.lnx relate table.p_size pipe diameter in inches ** N/A records for this item are denoted with -9p_depth pipe depth in feet ** N/A records for this item are denoted with -9abnd indicates whether feature is abandoned. Y = abandoned, N = not abandoned.meta_data_pk is the linking item to the water_md.lnx.(WATER LINE RELATE)Items in p_mat.lnxRecord P_MAT_FK PIPE_MATERIAL 1 1 VETRIFIED CLAY PIPE 2 2 CLASS 150 ASBESTOS-CEMENT 3 3 RANCHO 4 4 CORRUGATED GALVANIZED METAL PIPE 5 5 CORRUGATED METAL 6 6 CONCRETE 7 7 FULL COATED CORRUGATED METAL 8 8 UNKNOWN 9 9 PVC C-900 CLASS 150 10 10 PVC C-900 CLASS 200 11 11 PVC SDR-18 12 12 PVC 13 13 DUCTILE IRON PIPE 14 14 REINFORCED CONCRETE PIPE 15 15 OPEN DITCH 16 16 CCMP 17 17 STEEL 18 18 ASBESTOS-CEMENT 19 19 WROUGHT IRON 20 20 PVC C-900 SDR 21 21 21 PRECAST CONCRETE BOX 22 22 PVC C-900 DR-18 23 23 PVC C-900 24 24 CAST IRON 25 25 SERVICE CONNECTION 26 26 CAST IRON CLASS 150 27 27 REINFORCED PLASTIC MORTOR 28 28 PROFILE REINFORCED HOPE 29 29 DUCTILE IRON PIPE CLASS 52 30 30 C-900 31 31 PVC SDR-26 32 32 PVC SDR-14 33 33 ABS TRUSS 34 34 C-900 CLASS 150 35 35 C-900 CLASS 200 36 36 PVC D-1784 37 37 TRIPLE BOX CULVERT 38 38 CLASS 200 39 39 CLASS 150 40 40 CLASS 200 ASBESTOS-CEMENT 41 41 BORE & JACK 42 42 PVC SDR 26 CLASS 160 43 43 PVC DR 18 C-900 CLASS 150 44 44 PVC DR 18 45 45 PVC DR 26 46 46 DUCTILE IRON PIPE CLASS 50 47 47 WELDED STEEL PIPE 48 48 A.B.S. COMPOSITE 49 49 CPP 50 50 PVC SDR-41 51 51 PVC DR 18 C-900 52 52 DUCTILE IRON PIPE CLASS 2 53 53 CAST IRON PIPE CLASS 22 54 54 ACP 55 55 BOX CULVERT 56 56 PVC CLASS 160 57 57 CLAY 58 58 CAST IRON PIPE CLASS 22 150 PSI 59 59 SWALE 60 60 CSP 61 61 C.C. 62 62 COPPER 63 63 ASPHALT COATED METAL PIPE 64 64 WIER 65 65 PVC SDR-18 150 PSI 66 66 PVC SDR-26 150 PSI 67 67 PVC SDR-18 C-900 68 68 CAST IRON PIPE CLASS 24 69 69 CAST IRON PIPE CLASS 26 70 70 ARMCO TRUSS 71 71 PVC DR 14 C-900 CLASS 200 72 72 CONCRETE C-14 EXTRA STRENGTH 73 73 PVC SDR-35 74 74 C-900 DR-18 75 75 DUCTILE IRON PIPE CLASS 150(STORM SEWER POINT DATA)About the Items in stmsewer_point.dat*the stmsewer_point.dat table holds both attribute data and primary keys for relate tablesstmsewer_fk is the linking item for the stmsewer.pat table.mh_material_pk is the linking item to the mh_material.lnx relate table.mh_flowline manhole floor feet above mean sea level **where more than one elevation is given the lowest value is used. ** N/A records for this item are denoted with -9mh_ringsize manhlole ringsize in inches ** N/A records for this item are denoted with -9inlet_type_pk is the linking item to the inlet_type.lnx relate table.inlet_size inlet width and height in inches ** N/A records for this item are denoted with -9outfall_type_pk is the linking item to the outfall_type.lnx relate table.outfall_mat_pk is the linking item to the outfall_material.lnx relate table.outfall_size pipe size in inches at the outfall point. ** N/A records for this item are denoted with -9outfall_dest_pk is the linking item to the outfall_dest.lnx relate table.pump_cap lift station gallons per minute ** N/A records for this item are denoted with -9meta_data_pk is the linking item to the stmsewer_md.lnx relate table.(STORM SEWER POINT RELATES)Items in inlet_type.lnxRecord INLET_TYPE_FK INLET_TYPE 1 1 H-2 2 2 D 3 3 C-1 4 4 B-B 5 5 UNKNOWN 6 -9 N/A 7 7 E 8 8 A 9 9 STRAW BALE DROP 10 10 STRAW BALE DROP W/GUARDRAIL 11 11 S 12 12 SIDEWALK 13 13 B 14 14 CATCH BASIN 15 15 C 16 16 C-3 17 17 F 18 18 GRATE 19 19 D1 20 20 DROP 21 21 GRATE 22 22 CURB 23 23 C-5 24 24 C-9 25 25 C-8 26 26 C-7 27 27 C-2Items in mh_material.lnxRecord MH_MATERIAL_FK MANHOLE_MATERIAL 1 -9 N/A 2 1 STEEL 3 2 CONCRETE 4 3 CAST IRON 5 4 BRICK 6 5 FIBERGLASS OR CONCRETE 7 6 UNKNOWN 8 7 TYPE I 9 8 TYPE C 10 10 8IN BRICK 11 11 REINFORCED CONCRETE PIPE 12 12 STANDARD TYPE 1 13 13 MISSOURI CITY STANDARDItems in outfall_type.lnxRecord OUTFALL_TYPE_FK OUTFALL_TYPE 1 -9 N/A 2 4 STORM WATER Items in outfall_material.lnxRecord OUTFALL_MAT_FK OUTFALL_MATERIAL 1 -9 N/A 2 1 REINFORCED CONCRETE 3 4 CORRUTGATED METAL 4 2 UNKNOWN 5 5 PVC Items in outfall_dest.lnxRecord OUTFALL_DEST_FK OUTFALL_DESTINAT 1 3 STREAM 2 -9 N/A 3 4 DITCH 4 6 DRAINAGE FIELD 5 7 DETENTION POND 6 8 LAKE 7 9 WETLANDS 8 1 unknown(STORM SEWER LINE DATA)About the Items in stmsewer_arc.datstmsewer_fk is the linking item for the stmsewer.aat table.p_mat_pk is the linking item to the p_mat.lnx relate table.p_size pipe diameter in inchesp_depth pipe depth in feetp_grade pipe gradexsec_size pipe width and height in feet ** N/A records for this item are denoted with -9xsec_pk is the linking item to the xsec.lnx relate table.abnd indicates whether feature is abandoned. Y = abandoned, N = not abandoned.meta_data_pk is the linking item to the stmsewer_md.lnx relate table.(STORM SEWER LINE RELATES)Items in p_mat.lnxRecord P_MAT_FK PIPE_MATERIAL 1 1 VETRIFIED CLAY PIPE 2 2 CLASS 150 ASBESTOS-CEMENT 3 3 RANCHO 4 4 CORRUGATED GALVANIZED METAL PIPE 5 5 CORRUGATED METAL 6 6 CONCRETE 7 7 FULL COATED CORRUGATED METAL 8 8 UNKNOWN 9 9 PVC C-900 CLASS 150 10 10 PVC C-900 CLASS 200 11 11 PVC SDR-18 12 12 PVC 13 13 DUCTILE IRON PIPE 14 14 REINFORCED CONCRETE PIPE 15 15 OPEN DITCH 16 16 CCMP 17 17 STEEL 18 18 ASBESTOS-CEMENT 19 19 WROUGHT IRON 20 20 PVC C-900 SDR 21 21 21 PRECAST CONCRETE BOX 22 22 PVC C-900 DR-18 23 23 PVC C-900 24 24 CAST IRON 25 25 SERVICE CONNECTION 26 26 CAST IRON CLASS 150 27 27 REINFORCED PLASTIC MORTOR 28 28 PROFILE REINFORCED HOPE 29 29 DUCTILE IRON PIPE CLASS 52 30 30 C-900 31 31 PVC SDR-26 32 32 PVC SDR-14 33 33 ABS TRUSS 34 34 C-900 CLASS 150 35 35 C-900 CLASS 200 36 36 PVC D-1784 37 37 TRIPLE BOX CULVERT 38 38 CLASS 200 39 39 CLASS 150 40 40 CLASS 200 ASBESTOS-CEMENT 41 41 BORE & JACK 42 42 PVC SDR 26 CLASS 160 43 43 PVC DR 18 C-900 CLASS 150 44 44 PVC DR 18 45 45 PVC DR 26 46 46 DUCTILE IRON PIPE CLASS 50 47 47 WELDED STEEL PIPE 48 48 A.B.S. COMPOSITE 49 49 CPP 50 50 PVC SDR-41 51 51 PVC DR 18 C-900 52 52 DUCTILE IRON PIPE CLASS 2 53 53 CAST IRON PIPE CLASS 22 54 54 ACP 55 55 BOX CULVERT 56 56 PVC CLASS 160 57 57 CLAY 58 58 CAST IRON PIPE CLASS 22 150 PSI 59 59 SWALE 60 60 CSP 61 61 C.C. 62 62 COPPER 63 63 ASPHALT COATED METAL PIPE 64 64 WIER 65 65 PVC SDR-18 150 PSI 66 66 PVC SDR-26 150 PSI 67 67 PVC SDR-18 C-900 68 68 CAST IRON PIPE CLASS 24 69 69 CAST IRON PIPE CLASS 26 70 70 ARMCO TRUSS 71 71 PVC DR 14 C-900 CLASS 200 72 72 CONCRETE C-14 EXTRA STRENGTH 73 73 PVC SDR-35 74 74 C-900 DR-18 75 75 DUCTILE IRON PIPE CLASS 150 Items in xsec.lnxRecord XSEC_FK CROSS_SECTION 1 1 DIAMETER 2 2 ARCH 3 3 RECTANGLE 4 4 ELLIPTICAL 5 6 OPEN DITCH 6 9 UNKNOWN 7 10 WIER(SANITARY SEWER POINT DATA)About the Items in sansewer_point.datsnasewer_fk is the linking to the sansewer.pat tablemh_material_pk is the linking item to the mh_material.lnx relate table.mh_flowline manhole floor feet above mean sea level. *where more than one elevation is given the lowest value is used. ** N/A records for this item are denoted with -9mh_ringsize manhlole ringsize in inches. ** N/A records for this item are denoted with -9.mh_coated indicates whether manhole is coated or not. ** Y = coated, N = not coated, U = unknownls_gpm lift station gallons per minute. ** N/A records for this item are denoted with -9.gp_gpm grider pump gallons per minute. ** N/A records for this item are denoted with -9.meta_data_pk is the linking item to the stmsewer_md.lnx relate table.(SANITARY SEWER POINT RELATES)Items in mh_material.lnxRecord MH_MATERIAL_FK MANHOLE_MATERIAL 1 -9 N/A 2 1 STEEL 3 2 CONCRETE 4 3 CAST IRON 5 4 BRICK 6 5 FIBERGLASS OR CONCRETE 7 6 UNKNOWN 8 7 TYPE I 9 8 TYPE C 10 10 8IN BRICK 11 11 REINFORCED CONCRETE PIPE 12 12 STANDARD TYPE 1 13 13 MISSOURI CITY STANDARD (SANITARY SEWER LINE DATA)About the Items in sansewer_arc.datsansewer_fk is the linking to the sansewer.aat table.p_size pipe diameter in inchesp_depth pipe depth in feetp_grade pipe gradef_main indicates whether manhole is force main or not. Y = force main, N = not force main, U = unknownmeta_data_pk is the linking item to the sansewer_md.lnx relate table.abnd indicates whether feature is abandoned. Y = abandoned, N = not abandoned.p_mat_pk is the linking item to the p_mat.lnx relate table.(SANITARY SEWER LINE RELATES)Items in p_mat.lnxRecord P_MAT_FK PIPE_MATERIAL 1 1 VETRIFIED CLAY PIPE 2 2 CLASS 150 ASBESTOS-CEMENT 3 3 RANCHO 4 4 CORRUGATED GALVANIZED METAL PIPE 5 5 CORRUGATED METAL 6 6 CONCRETE 7 7 FULL COATED CORRUGATED METAL 8 8 UNKNOWN 9 9 PVC C-900 CLASS 150 10 10 PVC C-900 CLASS 200 11 11 PVC SDR-18 12 12 PVC 13 13 DUCTILE IRON PIPE 14 14 REINFORCED CONCRETE PIPE 15 15 OPEN DITCH 16 16 CCMP 17 17 STEEL 18 18 ASBESTOS-CEMENT 19 19 WROUGHT IRON 20 20 PVC C-900 SDR 21 21 21 PRECAST CONCRETE BOX 22 22 PVC C-900 DR-18 23 23 PVC C-900 24 24 CAST IRON 25 25 SERVICE CONNECTION 26 26 CAST IRON CLASS 150 27 27 REINFORCED PLASTIC MORTOR 28 28 PROFILE REINFORCED HOPE 29 29 DUCTILE IRON PIPE CLASS 52 30 30 C-900 31 31 PVC SDR-26 32 32 PVC SDR-14 33 33 ABS TRUSS 34 34 C-900 CLASS 150 35 35 C-900 CLASS 200 36 36 PVC D-1784 37 37 TRIPLE BOX CULVERT 38 38 CLASS 200 39 39 CLASS 150 40 40 CLASS 200 ASBESTOS-CEMENT 41 41 BORE & JACK 42 42 PVC SDR 26 CLASS 160 43 43 PVC DR 18 C-900 CLASS 150 44 44 PVC DR 18 45 45 PVC DR 26 46 46 DUCTILE IRON PIPE CLASS 50 47 47 WELDED STEEL PIPE 48 48 A.B.S. COMPOSITE 49 49 CPP 50 50 PVC SDR-41 51 51 PVC DR 18 C-900 52 52 DUCTILE IRON PIPE CLASS 2 53 53 CAST IRON PIPE CLASS 22 54 54 ACP 55 55 BOX CULVERT 56 56 PVC CLASS 160 57 57 CLAY 58 58 CAST IRON PIPE CLASS 22 150 PSI 59 59 SWALE 60 60 CSP 61 61 C.C. 62 62 COPPER 63 63 ASPHALT COATED METAL PIPE 64 64 WIER 65 65 PVC SDR-18 150 PSI 66 66 PVC SDR-26 150 PSI 67 67 PVC SDR-18 C-900 68 68 CAST IRON PIPE CLASS 24 69 69 CAST IRON PIPE CLASS 26 70 70 ARMCO TRUSS 71 71 PVC DR 14 C-900 CLASS 200 72 72 CONCRETE C-14 EXTRA STRENGTH 73 73 PVC SDR-35 74 74 C-900 DR-18 75 75 DUCTILE IRON PIPE CLASS 150 Items in xsec.lnxRecord XSEC_FK CROSS_SECTION 1 1 DIAMETER 2 2 ARCH 3 3 RECTANGLE 4 4 ELLIPTICAL 5 6 OPEN DITCH 6 9 UNKNOWN 7 10 WIER

Service Item Id: 185a48ef6ff24201af524b5a99a1c2b4

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 11097.381712391973
YMin: 6103.800330847502
XMax: 3143692.5498138517
YMax: 1.3798551840824068E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 0
Label: Water
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• P_MAT_PK ( type: esriFieldTypeInteger, alias: P_MAT_PK )
• P_SIZE ( type: esriFieldTypeDouble, alias: P_SIZE )
• P_DEPTH ( type: esriFieldTypeDouble, alias: P_DEPTH )
• ABND ( type: esriFieldTypeString, alias: ABND, length: 1 )
• ASBUILT_NO ( type: esriFieldTypeDouble, alias: ASBUILT_NO )
• DOLR ( type: esriFieldTypeDate, alias: DOLR, length: 8 )
• ID ( type: esriFieldTypeString, alias: ID, length: 10 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHEET_OF ( type: esriFieldTypeString, alias: SHEET_OF, length: 12 )
• Cartegraph_ID ( type: esriFieldTypeString, alias: Cartegraph_ID, length: 10 )
• SHAPE.len ( type: esriFieldTypeDouble, alias: SHAPE.len )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata