Drains - surveyed
Data Dictionary:FIELD NAMETYPEDESCRIPTIONDOMAINNOTESSTRUCTURE_IDText, 10Unique ID which will be generated in the field by the Horrocks survey and field crew.STATUSText, 10structure statusSTATUSSTRUCTURE_TYPEText, 30type of structure, pump station, overflow, flow monitorSTRUCTURE_TYPESURFACE_STRUCTUREText, 30the surface structure that is actually surveyed. This is mostly applicable for combo boxes when there is a survey point for both the manhole and the grate, though there is only one actual structure under the ground.SURFACE_STRUCTUREHOODED_OUTLETText, 10hooded outletYES_NO CITYText, 50The geographic area where the storm drain features exist.CITY PLSS_TOWNSHIPText, 30The PLSS Township which corresponds to the location of the storm drain feature. OWNERText, 50authority or owner of structure, this may include “private” alsoSTREET_NAMEText, 50nearest parallel streetAT_CURB_OF_INTERSECTIONText, 10Is the catch basin located at the curb of an intersection?YES_NO STRUCTURE_SHAPEText, 30the shape of the structureSTRUCTURE_SHAPESTRUCTURE_LENGTHDoublethe length (in) of the structureSTRUCTURE_WIDTHDoublethe width (in) of the structureSTRUCTURE_HEIGHTDoublethe height (ft) of the structure (Inlet FL to Box Bottom) in other words distant from the Rim/Grate Elevation to the bottom of the floor. NUMBER_OF_GRATESLongthe number of gratesmanholes will have a value of 999BICYCLE_SAFEText, 10Is the grate safe for a bicycle to ride over it?YES_NO manholes will have a value of N/AGRATE_MATERIALText, 30the grate materialDefault Value: Cast Ironmanholes will have a value of N/AGRATE_LENGTHDoublethe length (inches) of the gratemanholes will have a value of 999GRATE_WIDTHDoublethe width (inches) of the gratemanholes will have a value of 999GRATE_TYPEText, 30the type of the grateGRATE_TYPE manholes will have a value of N/AGRATE_CONDITIONText, 30the condition of the grateCONDITIONmanholes will have a value of N/AGRATE_FRAME_MATERIALText, 30the frame materialDefault Value: Cast Ironmanholes will have a value of N/AGRATE_FRAME_FITText, 30the fit of the frame (tight, loose, etc.)manholes will have a value of N/AGRATE_FRAME_CONDITIONText, 30the condition of the grate frameCONDITION manholes will have a value of N/ACURB_OPENINGText, 10is there a curb openingYES_NO manholes will have a value of N/ACURB_OPENING_LENGTHDoublethe length (in) of the curb openingmanholes will have a value of 999CURB_OPENING_HEIGHTDoublethe height (in) of the curb openingmanholes will have a value of 999PROTECTION_BARSText, 10does the curb opening have protection bars?YES_NO manholes will have a value of 999NUMBER_HORIZONTAL_BARSShortthe number of horizontal barsNUMBER_VERTICAL_BARSShortthe number of vertical barsOPENING_CONDITIONText, 30the condition of the curb openingCONDITION ECCENTRICText, 10is the cone eccentricYES_NOcatch basins will have a value of N/AMH_LID_LABELText, 30the Text imprinted on the manhole catch basins will have a value of N/AMH_LID_MATERIALText, 30the manhole lid material. Default Value: Cast Ironcatch basins will have a value of N/AMH_LID_DIAMETERShortthe manhole lid diameter (inches)catch basins will have a value of 999MH_LID_LENGTHShortthe manhole lid length (in)catch basins will have a value of 999MH_LID_WIDTHShortthe manhole lid width (in)catch basins will have a value of 999MH_LID_TYPEText, 30the manhole lid typecatch basins will have a value of N/AMH_LID_CONDITIONText, 30the condition of the manhole lidCONDITION catch basins will have a value of N/AMH_FRAME_MATERIALText, 30the manhole frame materialcatch basins will have a value of N/AMH_FRAME_FITText, 30the fit of the manhole frame (tight, loose, etc.)catch basins will have a value of N/AMH_FRAME_CONDITIONText, 30the fit condition of the manhole frame (tight, loose, etc.)CONDITION catch basins will have a value of N/AWALL_FLOOR_MATERIALText, 30the material of the wall/floor. Default Value: Formed ConcreteWALL_FLOOR_STEPSText, 30are there steps?YES_NOWALL_FLOOR_STEPS_NUMBERText, 30if steps exist, how many are there?WALL_FLOOR_STEPS_MATERIALText, 30if steps exist, what type of material are they made out ofWALL_FLOOR_STEPS_CONDITIONText, 30if steps exist, what type of condition are they inWALL_FLOOR_STRUCTURAL_DEFECTSText, 255structural defects on the wall and floorWALL_FLOOR_OM_DEFECTSText, 255O & M defects on the wall and floorRIM_GRATE_ELEVATIONDoublemanhole rim elevation, top of concrete box, etc.CHIMNEY_HEIGHTDoubledistance from the rim to the conecatch basins will have a value of 999CONE_HEIGHTDoubledistance from the top of cone to the bottom of cone (or the top of the barrel)catch basins will have a value of 999BARRELL_HEIGHTDoubledistance from the bottom of the cone to the flow linecatch basins will have a value of 999FLOOR_ELEVATIONDoublemanhole invert elevation.Value comes from RIM_GRATE_ELEVATION – STRUCTURE_HEIGHTAT_GRADEText, 10feature gradeAT_GRADECONCRETE_COLLARText, 10does the feature have a concrete collarYES_NO ACCURACYText, 50the accuracy of the field verificationACCURACYX EASTINGDoubleX coordinate in State Plane Coordinates, Utah Central Zone, NAD 83 in US Survey feetY NORTHINGDoubleY coordinate in State Plane Coordinates, Utah Central Zone, NAD 83 in US Survey feetPROJECT_IDText, 50Project ID# PROJECT_NAMEText, 50Project NameSOURCEText, 50Source of dataSOURCE DESIGN_DATEDate, MMDDYYYYdate structure was designedAll have value 9/9/9999CONSTRUCTION_DATEDate, MMDDYYYYdate structure was installedAll have value 9/9/9999INSPECTION_DATEDate, MMDDYYYYdate structure was inspected in the fieldINSPECTION_BYText, 50field personnel who inspected the structureREHABText, 10rehabilitatedYES_NO All have value UnknownREHAB_DATEDate, MMDDYYYYrehabilitation dateAll have value 9/9/9999REHABE_TYPEText, 10rehabilitation typeSTRUCTURE_REHAB_TYPE All have value UnknownREHAB_NOTESText, 255rehabilitation material and other notes describing the rehabAll have value UnknownDRAIN_BASINText, 50drainage basin the pipe is inAll have value UnknownSTRUCTURE_RATINGShort, 1-5Rating of the structureSTRUCTURE_RATING IMPACT_CATEGORYShort, 1-5the rating to show the political/geographical importance of an impactMAINTENANCE_HISTORYText, 255Maintenance history includes date and work performed. link to CartegraphPHOTOSText, 255link to photo files. Link(s) will be found in Cartegraph. Refer to the StructurePhotos tableAll have a value of N/A. Photo links are found in the StructurePhotos table.NOTESText, 255notes related to this structure not covered in other items. Add additional fields as needed from the field sheets.
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'STRUCTURE_ID', 'type': 'esriFieldTypeString', 'alias': 'Structure ID', 'length': 10, 'domain': None}, {'name': 'STATUS', 'type': 'esriFieldTypeString', 'alias': 'Status', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'STATUS_1', 'description': 'STATUS', 'codedValues': [{'name': 'Active', 'code': 'ACT'}, {'name': 'Abandoned', 'code': 'ABN'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'STRUCTURE_TYPE', 'type': 'esriFieldTypeString', 'alias': 'Structure Type', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'STRUCTURE_TYPE', 'description': 'STRUCTURE_TYPE', 'codedValues': [{'name': 'catch basin', 'code': 'CB'}, {'name': 'catch basin double', 'code': 'CBD'}, {'name': 'combo box', 'code': 'CBOX'}, {'name': 'catch basin with hooded inlet', 'code': 'CBH'}, {'name': 'catch basin with double hooded inlet', 'code': 'CBHD'}, {'name': 'control gate', 'code': 'CG'}, {'name': 'chamber', 'code': 'CH'}, {'name': 'combined sewer overflow', 'code': 'CSO'}, {'name': 'debris control, rails, etc.', 'code': 'DEB'}, {'name': 'diversion structure', 'code': 'DS'}, {'name': 'headwall', 'code': 'HDW'}, {'name': 'manhole', 'code': 'MH'}, {'name': 'pump station', 'code': 'PS'}, {'name': 'regulator', 'code': 'REG'}, {'name': 'storm inlet or storm drop', 'code': 'SI'}, {'name': 'discharge point, outfall', 'code': 'ADP'}, {'name': 'end of pipe', 'code': 'AEP'}, {'name': 'junction box', 'code': 'AJB'}, {'name': 'meter, flow monitor', 'code': 'AM'}, {'name': 'special chamber', 'code': 'AOC'}, {'name': 'tee connection', 'code': 'ATC'}, {'name': 'clean out box', 'code': 'CLEAN'}, {'name': 'irrigation', 'code': 'IRRI'}, {'name': 'detention basin (minor)', 'code': 'DETM'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'SURFACE_STRUCTURE', 'type': 'esriFieldTypeString', 'alias': 'Surface Structure', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'SURFACE_STRUCTURE', 'description': 'SURFACE_STRUCTURE', 'codedValues': [{'name': 'grate', 'code': 'grate'}, {'name': 'manhole', 'code': 'manhole'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'HOODED_OUTLET', 'type': 'esriFieldTypeString', 'alias': 'Hooded Outlet', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'CITY', 'type': 'esriFieldTypeString', 'alias': 'City', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'CITY', 'description': 'CITY', 'codedValues': [{'name': 'Alta', 'code': 'Alta'}, {'name': 'Bluffdale', 'code': 'Bluffdale'}, {'name': 'Cottonwood Heights', 'code': 'Cottonwood Heights'}, {'name': 'Draper', 'code': 'Draper'}, {'name': 'Herriman', 'code': 'Herriman'}, {'name': 'Holladay', 'code': 'Holladay'}, {'name': 'Midvale', 'code': 'Midvale'}, {'name': 'Murray', 'code': 'Murray'}, {'name': 'Riverton', 'code': 'Riverton'}, {'name': 'Salt Lake City', 'code': 'Salt Lake City'}, {'name': 'Sandy', 'code': 'Sandy'}, {'name': 'South Jordan', 'code': 'South Jordan'}, {'name': 'Taylorsville', 'code': 'Taylorsville'}, {'name': 'West Jordan', 'code': 'West Jordan'}, {'name': 'West Valley City', 'code': 'West Valley City'}, {'name': 'Copperton - Township', 'code': 'Copperton - Township'}, {'name': 'Emigration Canyon - Township', 'code': 'Emigration Canyon - Township'}, {'name': 'Kearns - Township', 'code': 'Kearns - Township'}, {'name': 'Magna - Township', 'code': 'Magna - Township'}, {'name': 'Millcreek - Township', 'code': 'Millcreek - Township'}, {'name': 'White City - Township', 'code': 'White City - Township'}, {'name': 'Unincorporated', 'code': 'Unincorporated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'PLSS_TOWNSHIP', 'type': 'esriFieldTypeString', 'alias': 'PLSS Township', 'length': 30, 'domain': None}, {'name': 'OWNER', 'type': 'esriFieldTypeString', 'alias': 'Owner', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'OWNER', 'description': 'OWNER', 'codedValues': [{'name': 'Flood Control', 'code': 'Flood Control'}, {'name': 'Municipal', 'code': 'Municipal'}, {'name': 'Private', 'code': 'Private'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'STREET_NAME', 'type': 'esriFieldTypeString', 'alias': 'Street Name', 'length': 50, 'domain': None}, {'name': 'AT_CURB_OF_INTERSECTION', 'type': 'esriFieldTypeString', 'alias': 'At Curb of Intersection', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'STRUCTURE_SHAPE', 'type': 'esriFieldTypeString', 'alias': 'Structure Shape', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'STRUCTURE_SHAPE', 'description': 'STRUCTURE_SHAPE', 'codedValues': [{'name': 'Circle', 'code': 'Circle'}, {'name': 'Rectangle', 'code': 'Rectangle'}, {'name': 'Square', 'code': 'Square'}, {'name': 'Custom', 'code': 'Custom'}, {'name': 'Unknown', 'code': 'Unknown'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'STRUCTURE_LENGTH', 'type': 'esriFieldTypeDouble', 'alias': 'Structure Length', 'domain': None}, {'name': 'STRUCTURE_WIDTH', 'type': 'esriFieldTypeDouble', 'alias': 'Structure Width', 'domain': None}, {'name': 'STRUCTURE_HEIGHT', 'type': 'esriFieldTypeDouble', 'alias': 'Structure Height', 'domain': None}, {'name': 'NUMBER_OF_GRATES', 'type': 'esriFieldTypeInteger', 'alias': 'Number of Grates', 'domain': None}, {'name': 'BICYCLE_SAFE', 'type': 'esriFieldTypeString', 'alias': 'Bicycle Safe', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'GRATE_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'Grate Material', 'length': 30, 'domain': None}, {'name': 'GRATE_LENGTH', 'type': 'esriFieldTypeDouble', 'alias': 'Grate Length', 'domain': None}, {'name': 'GRATE_WIDTH', 'type': 'esriFieldTypeDouble', 'alias': 'Grate Width', 'domain': None}, {'name': 'GRATE_TYPE', 'type': 'esriFieldTypeString', 'alias': 'Grate Type', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'GRATE_TYPE', 'description': 'GRATE_TYPE', 'codedValues': [{'name': 'Slotted', 'code': 'Slotted'}, {'name': 'Welded Rebar', 'code': 'Welded Rebar'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'GRATE_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'Grate Condition', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'CONDITION', 'description': 'CONDITION', 'codedValues': [{'name': 'Sound', 'code': 'Sound'}, {'name': 'Cracked', 'code': 'Cracked'}, {'name': 'Broken', 'code': 'Broken'}, {'name': 'Missing', 'code': 'Missing'}, {'name': 'Corroded/Pitted/Worn', 'code': 'Corroded/Pitted/Worn'}, {'name': 'Coated', 'code': 'Coated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'GRATE_FRAME_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'Grate Frame Material', 'length': 30, 'domain': None}, {'name': 'GRATE_FRAME_FIT', 'type': 'esriFieldTypeString', 'alias': 'Grate Frame Fit', 'length': 30, 'domain': None}, {'name': 'GRATE_FRAME_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'Grate Frame Condition', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'CONDITION', 'description': 'CONDITION', 'codedValues': [{'name': 'Sound', 'code': 'Sound'}, {'name': 'Cracked', 'code': 'Cracked'}, {'name': 'Broken', 'code': 'Broken'}, {'name': 'Missing', 'code': 'Missing'}, {'name': 'Corroded/Pitted/Worn', 'code': 'Corroded/Pitted/Worn'}, {'name': 'Coated', 'code': 'Coated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'CURB_OPENING', 'type': 'esriFieldTypeString', 'alias': 'Curb Opening', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'CURB_OPENING_LENGTH', 'type': 'esriFieldTypeDouble', 'alias': 'Curb Opening Length', 'domain': None}, {'name': 'CURB_OPENING_HEIGHT', 'type': 'esriFieldTypeDouble', 'alias': 'Curb Opening Height', 'domain': None}, {'name': 'PROTECTION_BARS', 'type': 'esriFieldTypeString', 'alias': 'Protection Bars', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'NUMBER_HORIZONTAL_BARS', 'type': 'esriFieldTypeSmallInteger', 'alias': '# Horizontal Bars', 'domain': None}, {'name': 'NUMBER_VERTICAL_BARS', 'type': 'esriFieldTypeSmallInteger', 'alias': '# Veritcal Bars', 'domain': None}, {'name': 'OPENING_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'Opening Condtion', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'CONDITION', 'description': 'CONDITION', 'codedValues': [{'name': 'Sound', 'code': 'Sound'}, {'name': 'Cracked', 'code': 'Cracked'}, {'name': 'Broken', 'code': 'Broken'}, {'name': 'Missing', 'code': 'Missing'}, {'name': 'Corroded/Pitted/Worn', 'code': 'Corroded/Pitted/Worn'}, {'name': 'Coated', 'code': 'Coated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'ECCENTRIC', 'type': 'esriFieldTypeString', 'alias': 'Eccentric', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'MH_LID_LABEL', 'type': 'esriFieldTypeString', 'alias': 'MH Lid Label', 'length': 30, 'domain': None}, {'name': 'MH_LID_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'MH Lid Material', 'length': 30, 'domain': None}, {'name': 'MH_LID_DIAMETER', 'type': 'esriFieldTypeSmallInteger', 'alias': 'MH Lid Diameter', 'domain': None}, {'name': 'MH_LID_LENGTH', 'type': 'esriFieldTypeSmallInteger', 'alias': 'MH Lid Length', 'domain': None}, {'name': 'MH_LID_WIDTH', 'type': 'esriFieldTypeSmallInteger', 'alias': 'MH Lid Width', 'domain': None}, {'name': 'MH_LID_TYPE', 'type': 'esriFieldTypeString', 'alias': 'MH Lid Type', 'length': 30, 'domain': None}, {'name': 'MH_LID_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'MH Lid Condition', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'CONDITION', 'description': 'CONDITION', 'codedValues': [{'name': 'Sound', 'code': 'Sound'}, {'name': 'Cracked', 'code': 'Cracked'}, {'name': 'Broken', 'code': 'Broken'}, {'name': 'Missing', 'code': 'Missing'}, {'name': 'Corroded/Pitted/Worn', 'code': 'Corroded/Pitted/Worn'}, {'name': 'Coated', 'code': 'Coated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'MH_FRAME_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'MH Frame Material', 'length': 30, 'domain': None}, {'name': 'MH_FRAME_FIT', 'type': 'esriFieldTypeString', 'alias': 'MH Frame Fit', 'length': 30, 'domain': None}, {'name': 'MH_FRAME_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'MH Frame Condition', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'CONDITION', 'description': 'CONDITION', 'codedValues': [{'name': 'Sound', 'code': 'Sound'}, {'name': 'Cracked', 'code': 'Cracked'}, {'name': 'Broken', 'code': 'Broken'}, {'name': 'Missing', 'code': 'Missing'}, {'name': 'Corroded/Pitted/Worn', 'code': 'Corroded/Pitted/Worn'}, {'name': 'Coated', 'code': 'Coated'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'WALL_FLOOR_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Material', 'length': 30, 'domain': None}, {'name': 'WALL_FLOOR_STEPS', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Step', 'length': 30, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'WALL_FLOOR_STEPS_NUMBER', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Steps #', 'length': 30, 'domain': None}, {'name': 'WALL_FLOOR_STEPS_MATERIAL', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Material', 'length': 30, 'domain': None}, {'name': 'WALL_FLOOR_STEPS_CONDITION', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Step Condition', 'length': 30, 'domain': None}, {'name': 'WALL_FLOOR_STRUCTURAL_DEFECTS', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor Structural Defects', 'length': 255, 'domain': None}, {'name': 'WALL_FLOOR_OM_DEFECTS', 'type': 'esriFieldTypeString', 'alias': 'Wall Floor OM Defects', 'length': 255, 'domain': None}, {'name': 'RIM_GRATE_ELEVATION', 'type': 'esriFieldTypeDouble', 'alias': 'Rim Grate Elevation', 'domain': None}, {'name': 'CHIMNEY_HEIGHT', 'type': 'esriFieldTypeDouble', 'alias': 'Chimney Height', 'domain': None}, {'name': 'CONE_HEIGHT', 'type': 'esriFieldTypeDouble', 'alias': 'Cone Height', 'domain': None}, {'name': 'BARRELL_HEIGHT', 'type': 'esriFieldTypeDouble', 'alias': 'Barrell Height', 'domain': None}, {'name': 'FLOOR_ELEVATION', 'type': 'esriFieldTypeDouble', 'alias': 'Floor Elevation', 'domain': None}, {'name': 'AT_GRADE', 'type': 'esriFieldTypeString', 'alias': 'At Grade', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'AT_GRADE', 'description': 'AT_GRADE', 'codedValues': [{'name': 'At Grade', 'code': 'At Grade'}, {'name': 'High', 'code': 'High'}, {'name': 'Low', 'code': 'Low'}, {'name': 'Buried', 'code': 'Buried'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'CONCRETE_COLLAR', 'type': 'esriFieldTypeString', 'alias': 'Concrete Collar', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'ACCURACY', 'type': 'esriFieldTypeString', 'alias': 'Accuracy', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'ACCURACY', 'description': 'ACCURACY', 'codedValues': [{'name': 'Survey Grade - A', 'code': 'Survey Grade - A'}, {'name': 'Survey Grade - B', 'code': 'Survey Grade - B'}, {'name': 'Survey Grade - C', 'code': 'Survey Grade - C'}, {'name': 'Mapping Grade - D', 'code': 'Mapping Grade - D'}, {'name': 'Institutional Knowledge - D', 'code': 'Institutional Knowledge - D'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'EASTING', 'type': 'esriFieldTypeDouble', 'alias': 'Easting', 'domain': None}, {'name': 'NORTHING', 'type': 'esriFieldTypeDouble', 'alias': 'Northing', 'domain': None}, {'name': 'PROJECT_ID', 'type': 'esriFieldTypeString', 'alias': 'Project ID', 'length': 50, 'domain': None}, {'name': 'PROJECT_NAME', 'type': 'esriFieldTypeString', 'alias': 'Project Name', 'length': 50, 'domain': None}, {'name': 'SOURCE', 'type': 'esriFieldTypeString', 'alias': 'Source', 'length': 50, 'domain': None}, {'name': 'DESIGN_DATE', 'type': 'esriFieldTypeDate', 'alias': 'Design Date', 'length': 8, 'domain': None}, {'name': 'CONSTRUCTION_DATE', 'type': 'esriFieldTypeDate', 'alias': 'Construction Date', 'length': 8, 'domain': None}, {'name': 'INSPECTION_DATE', 'type': 'esriFieldTypeDate', 'alias': 'Inpsection Date', 'length': 8, 'domain': None}, {'name': 'INSPECTION_BY', 'type': 'esriFieldTypeString', 'alias': 'Inspection By', 'length': 50, 'domain': None}, {'name': 'REHAB', 'type': 'esriFieldTypeString', 'alias': 'Rehab', 'length': 10, 'domain': {'type': 'codedValue', 'name': 'YES_NO', 'description': 'YES_NO', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'REHAB_DATE', 'type': 'esriFieldTypeDate', 'alias': 'Rehab Date', 'length': 8, 'domain': None}, {'name': 'REHAB_TYPE', 'type': 'esriFieldTypeString', 'alias': 'Rehab Type', 'length': 10, 'domain': None}, {'name': 'REHAB_NOTES', 'type': 'esriFieldTypeString', 'alias': 'Rehab Notes', 'length': 255, 'domain': None}, {'name': 'DRAIN_BASIN', 'type': 'esriFieldTypeString', 'alias': 'Drain Basin', 'length': 50, 'domain': None}, {'name': 'STRUCTURE_RATING', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Structure Rating', 'domain': None}, {'name': 'IMPACT_CATEGORY', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Impact Category', 'domain': None}, {'name': 'MAINTENANCE_HISTORY', 'type': 'esriFieldTypeString', 'alias': 'Maintenance History', 'length': 255, 'domain': None}, {'name': 'PHOTOS', 'type': 'esriFieldTypeString', 'alias': 'Photos', 'length': 255, 'domain': None}, {'name': 'NOTES', 'type': 'esriFieldTypeString', 'alias': 'Notes', 'length': 255, 'domain': None}, {'name': 'department', 'type': 'esriFieldTypeString', 'alias': 'Department/Agency', 'length': 25, 'domain': None}, {'name': 'asset_id', 'type': 'esriFieldTypeString', 'alias': 'Asset ID', 'length': 30, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}]
[{'name': 'R840_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S795_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'uniqueValue', 'field1': 'STRUCTURE_TYPE', 'uniqueValueInfos': [{'symbol': {'type': 'esriPMS', 'url': 'd12367a090ce989e8f45f8e3d019710d', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNUlEQVQokWNhIBOwUFujoiCXvNb3fx+//fjx4SQDA8M3Ahp5RPXlPPr0ZUOdBbnlJP/9//v3/usj5y49Xrvk0dvTk3BpZLRWjZthohgbBBNgYmRmVhazN5UWNNTaebme+cGbE/0YGjWl3JMN5SP8sbmbg5WPW1cmJPnBmxMzYc6Ga5QUMHBkZmJlxuFnBgVRC20pAQPXZx8ubETRyMzExo9LE9TZDNwcQkIYTv3+8/1TfBo/fHv8+/Ovt6cwNL7/+XLi84+XQyX5dQWxabz1Yu/xF+8uXsXQePXR6mt8rMJ1DP8Z2yQFdHhh4n///Wa4+Xznxe9/HsYjG4QSj8fvzpjy52/CkTdfblVxsAko/v/359vHb8+PHLsjUcvAsOMfTo0MDAwMpx8suMDAwBCGz79YNRILAK9Wbue4j00MAAAAAElFTkSuQmCC', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'CB', 'label': 'Catch Basin'}, {'symbol': {'type': 'esriPMS', 'url': 'a1f30cc20bbcd6cc6b0548091d575562', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNUlEQVQokWNhIBOwUFujIp+qhNav91++/Xjz5SQDA8M3/Bp5eETV46z6NLI9nXlVpST///n79/GWs+fuzNm95NmuS5NwaWQ0qvKboVXiHwQXYGFmlgswM5Ww1dI6mjiV+emOc/0YGhUjbZM1cr38sbmbTZiHWzXNJfnpjnMzYc6GaxS1VndkYmdlxuFnBmkPA21xWy3Xl4evbUTRyMLJyo9LE9TZDJziAkIYTv3x6vNTfBq/3H3x+9PzD6cwNH568HbimxO3QkUs1ASxaXyw8tjxd0evXcXQeGfm9mvc0nx1DIyMbSLmqrww8b8/fzPcX37k4o8HL+ORDUKJx4t1K6f8qfp55N2F+1UcInyK///+/fb5zqsjFxg0ahkWzPiHUyMDAwPD1bYNFxgYGMLw+RerRmIBANSDbVUjTzEKAAAAAElFTkSuQmCC', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'CBD', 'label': 'Catch Basin Double'}, {'symbol': {'type': 'esriPMS', 'url': '361125d2504ed7cdcb586a9091d82138', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABN0lEQVQokWNhIBOwUFujorQgl9bH7/++ffnx4yQDA8M3vBp5GBhEXU3k+gKN5Jxlhbkl//77//fY7VfnNp97vOT0g7eTcGlkjHJUmxFpoRgEE2BmYmS2VRc31ZcT0mrfcon5xJ03/RgaXbWlkkNM5f2xuZuPk5Xbz0A2+cSdNzNhzoZr1JURcGRlZmLG4WcGM2VRbQNZAdcLjz9sRNHIxsbMj0sT1NkMQrwcQhhOff/l51N8Gp++//b77ZdfpzA0vvjwY+K1px9CtaQFBLFp3H/txfGLj95dxdC48fyja0I8rHUMjAxtWlICvDDx33//Mey5+vzi00+/45ENQonH+YfvTvn59++ROy8+V/Fzsin++f/v24sP347IHLxTu4OB4R9OjQwMDAzLjj24wMDAEIbPv1g1EgsAN5FueQJOLfIAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'CBOX', 'label': 'Combo Box'}, {'symbol': {'type': 'esriPMS', 'url': '35f4c25c31f87060838286e11e7661e2', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNklEQVQokWNhIBOwUFujIpeghNa/71++/fjx5SQDA8M3Ahp5RGWMjPvkjR2duYTEJP//+/f39Z1L556cP7Lk7YNrk3BpZFS1d5mhYOEWBBdgYmIWUzMwFZRV1bqyZQHzm3tX+zE0SmmaJcuZOvljczcrJze3jKFd8pt7V2fCnA3XKCCn4sjEzMKMw88MIkra2gKyKq4fHt/ZiKKRkZmFH5cmqLMZOHj5hDCc+uvrl6f4NH57//r3ry+fTmFo/Pnp9cSPT++H8ksrCmLT+PL6mePvHt25iqHx0fnD11h5BOsYGBna+KUUeWHi//7+YXhx7dTFP59fxyMbhBKPdw9vmvL3r9eRzy+eVLFycSv+///v2/f3r4/cOWxcy8Cw5B9OjQwMDAwPjm27wMDAEIYquhnD6WSnVQChnG6ZtulIXwAAAABJRU5ErkJggg==', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'ADP', 'label': 'Discharge Point, Outfall'}, {'symbol': {'type': 'esriPMS', 'url': 'e0ae04794252c3d6d76c3c0662ff0ffd', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABOklEQVQokWNhIBOwUFujohKfhNanX1++vfnx5SQDA8M3vBp5GHhEo1Ws+jJU3ZzVeCUl//z/+3f703PnZt/ds2TvyyuTcGlkLNf3mVGk7hsEl2RkZvaVMTW1FtXUSj01jXnH84v9GBrD5a2Ts1U9/bG5W4idhztZ2SV5x/OLM2HOhmu0ElFzZGdiYcbhZwY3SX1tK2F112Nvb25E0cjBzMaPSxPU2QziXAJCDG/RnPrm5+en+DTe/fzy96uvn0/BDYIx7rx/OfHkuzuh5kIqgtg0rnl8/PjRd9euYmic/2jvNRl+oTrGfwxtZiIqvDDxn/9+M6x6eOzirS+P41Gcjsxpvrx6yg/Vr0cufnxYJczOq/j3/99v9z+/OsJ4Rat2BcOsfzg1MjAwMHTf3naBgYEhDJ9/sWokFgAAnSlvC1tBM+gAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'DS', 'label': 'Diversion Structure'}, {'symbol': {'type': 'esriPMS', 'url': '60cf9d169475df977d57fdc43268939c', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABN0lEQVQokWNhIBOwUFujorwSn9bHd7++ffjw4yQDA8M3vBp5eBhEvYIU+8LilJ3llXgk//79//fQnufn1i19uOTEkZeTcGlkTMjWnhGfrhoEE2BmZmR2dJcyNTQX0WooPst8dP/LfgyN7v4yyZGJyv7Y3C0gwMYdHKWQfHT/y5kwZ8M1GpmJOLKxMTHj8DODlYOEtoG5sOuFk283omhkZ2Pix6UJ6mwGEWF2IQynvnv78yk+jY8ffvn98fWPUxganz/+PPHy+XehuoZCgtg07tr89Pjp0++uYmhcvfTRNVFJ3joGBoY2XUMhXpj4r1//GHZsfHzxwb3v8cgGocTjtJ6rUxKyVI/cuvaxSkCQXfHP3//fnj76ekSc91rtjg0M/3BqZGBgYFgw7fYFBgaGMHz+xaqRWAAA+61sCnw33ZYAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'AJB', 'label': 'Junction Box'}, {'symbol': {'type': 'esriPMS', 'url': '8bd67762ccb83380a918be632daef25e', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABOUlEQVQokWNhIBOwUFujooSSktaXT5++fXnz5iQDA8M3vBp5eHhEzaKi+pzT050lVFQl//358/fC9u3nDs6ft+TK3r2TcGlk9Cgrm+GZXxAEE2BiYWE28vU1VbOx0ZqXls58cdeOfgyNFuHhya4Zmf7Y3M0jKMhtl5SUfHHXjpkwZ8M1qlpaOrKwszPj8DODnquLtoqVleudY8c2omhk5eDgx6UJ6mwGQXFxIQynfn716ik+ja/u3fv9/tWrUxga392/P/HOyVOhKuZmgtg0nlqz5vido0evYmjcO3/+NV4ZmTpGJsY2ZVNTXpj4n58/GU6sWnnx+d078cgGocTjhubmKb9+/Djy+OKlKm4RYcV/f35/e/PgwRE9Zuba+StW/MOpkYGBgWFbd/cFBgaGMGSxdVicTnZaBQBRuW4Okr5KYQAAAABJRU5ErkJggg==', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'MH', 'label': 'Manhole'}, {'symbol': {'type': 'esriPMS', 'url': 'e4672ee6eefa43801a9f2bb73e3c1f3a', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABN0lEQVQokWNhIBOwUFujIp8In9avL7++/fjx4yQDA8M3/Bp5GETV9BX71G2UnXlFeST///v/9+m15+fuHH245Nntl5NwaWQ0tNeeoemoGgQXYGJkltGRMhVTEtE6vvws89PrL/sxNCoayCSr2yr7Y3M3Gxcbt4qVQvLT6y9nwpwN1yiqLOLIxMLEjMPPDFLqEtriKsKuL++83YiikZmViR+XJqizGTi52YUwnPr968+n+DR+efPl96evP05haPzy6vPENw/ehYooCAli0/jg/NPj7+68u4qh8c7JR9e4BXjrGJkY2oTlhHhh4v/+/GO4f/7xxV8vv8cjG4QSjxd3Xp3y55/qkfdPP1axcbEr/vv3/9uXd1+PXDK/VsuwkuEfTo0MDAwMV3ffvsDAwBCGIrgd0+lkp1UAPDNukb0cDUwAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'value': 'SI', 'label': 'Storm Inlet or Storm Drop'}], 'fieldDelimiter': ',', 'authoringInfo': {'colorRamp': {'type': 'multipart', 'colorRamps': [{'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [46, 52, 133, 255], 'toColor': [46, 52, 133, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [170, 176, 58, 255], 'toColor': [170, 176, 58, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [171, 58, 73, 255], 'toColor': [171, 58, 73, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [51, 156, 158, 255], 'toColor': [51, 156, 158, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [173, 47, 152, 255], 'toColor': [173, 47, 152, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [43, 153, 74, 255], 'toColor': [43, 153, 74, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [133, 88, 37, 255], 'toColor': [133, 88, 37, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [67, 101, 143, 255], 'toColor': [67, 101, 143, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [117, 35, 168, 255], 'toColor': [117, 35, 168, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [176, 58, 37, 255], 'toColor': [176, 58, 37, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [143, 30, 90, 255], 'toColor': [143, 30, 90, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [133, 76, 166, 255], 'toColor': [133, 76, 166, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [91, 128, 61, 255], 'toColor': [91, 128, 61, 255]}]}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
nan
nan