Description: Address points (Layers.GISUSER.address_pts) - are a MANDATORY OSSI LAYER. With each update to centerlines based on development address points must be updated, given a city code (only if within the Missouri City City Limits geographical boundary), x/y coordinates and exported as a shapefile to Public Safety.Mandatory Field Population:RF_ADDR - right from address - lowest even numeric addressLF_ADDR - left from address - lowest odd numeric addressRT_ADDR - right to address - highest even numeric addressLT_ADDR - left to address - highest odd numeric addressPREFIX - usually a direction (S, W, N, E) or a type of street (HWY, FM, etc.)ESN_L - based on the ESN (emergency service number) polygon K:\GIS\Data\External Data\911 - esn number to the left of the centerlineESN_R - based on the ESN (emergency service number) polygon K:\GIS\Data\External Data\911 - esn number to the right of the centerlineKEYMAP - grid for Key Map - Not Missouri City map book - ->Feature Dataset: Layers.GISUSER.Key Map--> Feature Class: Layers.GISUSER.Key_Map_Grid NAME - street name with no suffix or prefix (N. Kathy Ln = Kathy) ST_TYPE - Suffix designation (LN, RD, DR.) DO NOT POPULATE SUFFIX FIELD FULL_NAME - Capitalize only first letter of each word - this is the complete name of the street.CITY: Based on the Zip Code Postal City designation UNLESS the centerline runs along the boundary of the city limits or etj and Missouri City addresses are connected to that centerline. The CODE will be MISS for these cases. OSSI/Public Safety generated codes as follows: if not listed - contact Public SafetyALVI - AlvinARC - ArcolaFBCO - Fort Bend CountyFRES - FresnoHOU - Houston IOWA - Iowa ColonyMAN - ManvelMISS - Missouri CityNEE - NeedvillePEA - PearlandRSH - RosharonRICH - RichmondROS - RosenbergSTA - StaffordSUG - Sugar Land
Description: FireHydrants_2015 ATTRIBUTE INFORMATION- DATA ITEMS:ID:Identification number given for each fire hydrant collected.Color:Color of the fire hydrant bonnet and caps. Each color is based upon mainline size.Yellow, water main diameter with 6” and less;White, 8” water main diameter;Green, 10” to 20” water main diameter;Orange, 24” to 60” water main diameter;Red, it does not indicate any size. That may happen in a few private fire hydrants and some other fire hydrants with no paint where red is the orginal color from the manufacturer;Position:Positon where the fire hydrant outlet cap is pointed to.GeoIndex:Cell_IDin the GeoIndex feature class (MapTile dataset).Location:City or ETJ where the fire hydrant is located.Date:Date when the fire hydrant was collected.Status:Status of the fire hydrant on the collection date.Access:Indicates if the fire hydrant was accessible for data collection on the collection date. The ones not accessible were collected through an Orthoimagery of the area.X_CordX cordinate of the fire hydrant (NAD 1983 StatePlane Texas South Central FIPS 4204 Feet).Y_CordY cordinate of the fire hydrant (NAD 1983 StatePlane Texas South Central FIPS 4204 Feet).
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
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
Description: Schema Key (Tatum Lauten - Began 12/2018 - Last Edited 1/2019)MAP_PAGE: This is a reference to the grids used in the City MapBook that the parcel falls within. Do not use the Key Map numbersEvery entry should have a four-character codestarting with a LETTER (A through Q) - These refer to the rows of the MapBook Gridfollowed by a TWO-DIGIT NUMBER (08 through 14) - These refer to the column of the MapBook Gridending with another LETTER (A, B, C or D) - These refer to the Quadrant of the MapBook Gridexample: P12AThe combination of the first Letter and Number correspond to the MapBook Page Label (not the page number).(use MapBook page of Address Point if parcel spans multiple map page grids)-> Feature Dataset: Layers.GISUSER.MapTile--> Feature Class: Layers.GISUSER.geoindex----> Field: CELL_IDCITY_V: This is a reference to the City Voting Precincts found in the following location:-> Feature Dataset: Layers.GISUSER.Voting_Precincts--> Feature Class: Layers.GISUSER.City_Precincts---->Field: PRECINTCOUNTY_V: This is a reference to County Commissioner Precincts-> Feature Dataset: Layers.GISUSER.Voting_Precincts--> Feature Class: Layers.GISUSER.FBC_Voting_Precincts_2018---->Field: NAMECNTY_PREC: This is a reference to the County Commissioner's Precinct (NOT VOTING PRECINCT!!!!)-> Feature Dataset: Layers.GISUSER.Council_Districts--> Feature Class: Layers.GISUSER.FBC_Precincts---->Field: PCTBNDRYS