{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 33, "name": "Septic Tank Info", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TANK_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FFID", "type": "esriFieldTypeInteger", "alias": "FFID", "domain": null }, { "name": "TANK_NUM", "type": "esriFieldTypeString", "alias": "TANK_NUM", "length": 30, "domain": null }, { "name": "Maintenance_Strategy", "type": "esriFieldTypeString", "alias": "Maintenance Strategy", "length": 30, "domain": { "type": "codedValue", "name": "BUO_Maintenance_Strategy", "description": "Maintenance strategies defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Run To Failure", "code": "Run To Failure" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" }, { "name": "Predictive Maintenance", "code": "Predictive Maintenance" }, { "name": "Risk", "code": "Risk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Install_Year", "type": "esriFieldTypeSmallInteger", "alias": "Install Year", "domain": null }, { "name": "WarrantyStartDate", "type": "esriFieldTypeDate", "alias": "Warranty Start Date", "length": 8, "domain": null }, { "name": "WarrantyEndDate", "type": "esriFieldTypeDate", "alias": "Warranty End Date", "length": 8, "domain": null }, { "name": "Depth_of_Stack", "type": "esriFieldTypeSingle", "alias": "Depth of Stack", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "BUO_MFG_Tank", "description": "Tank manufacturers as specified by the Bureau of Utility Operations", "codedValues": [ { "name": "A.O. SMith", "code": "A.O. SMith" }, { "name": "Acrison", "code": "Acrison" }, { "name": "Amtrol", "code": "Amtrol" }, { "name": "Assmann Corporation of America", "code": "Assmann Corporation of America" }, { "name": "Augusta Fiberglass", "code": "Augusta Fiberglass" }, { "name": "Biaair Solutions", "code": "Biaair Solutions" }, { "name": "Biorem Technologies Inc.", "code": "Biorem Technologies Inc." }, { "name": "Bradford White Corporation", "code": "Bradford White Corporation" }, { "name": "Bucher Hydraulics", "code": "Bucher Hydraulics" }, { "name": "Caldwell Tanks Inc.", "code": "Caldwell Tanks Inc." }, { "name": "Core - Engineered Solutions", "code": "Core - Engineered Solutions" }, { "name": "CST Industries, Inc.", "code": "CST Industries, Inc." }, { "name": "Dutchland Inc.", "code": "Dutchland Inc." }, { "name": "ECS Environmental Solutions", "code": "ECS Environmental Solutions" }, { "name": "Enduro Odor Control", "code": "Enduro Odor Control" }, { "name": "Engine Compressor Accessories", "code": "Engine Compressor Accessories" }, { "name": "Envirodyne Systems", "code": "Envirodyne Systems" }, { "name": "Eutek Systems", "code": "Eutek Systems" }, { "name": "Gardner Denver", "code": "Gardner Denver" }, { "name": "Granby Industries", "code": "Granby Industries" }, { "name": "Highland Tank and Mfg. Co.", "code": "Highland Tank and Mfg. Co." }, { "name": "Horton", "code": "Horton" }, { "name": "Imperial Industries", "code": "Imperial Industries" }, { "name": "Ingersoll Rand", "code": "Ingersoll Rand" }, { "name": "Justin Tank", "code": "Justin Tank" }, { "name": "Kaeser Controls", "code": "Kaeser Controls" }, { "name": "Merrick Industries", "code": "Merrick Industries" }, { "name": "Nalco Tanks", "code": "Nalco Tanks" }, { "name": "Nalgene Plastics", "code": "Nalgene Plastics" }, { "name": "Polyprocessing Company", "code": "Polyprocessing Company" }, { "name": "Portec Chemical Processing", "code": "Portec Chemical Processing" }, { "name": "Prominent Pump", "code": "Prominent Pump" }, { "name": "Pryco, Inc.", "code": "Pryco, Inc." }, { "name": "Quincy Air Compress", "code": "Quincy Air Compress" }, { "name": "Rheem Heating And Cooling", "code": "Rheem Heating And Cooling" }, { "name": "Rinker Materials", "code": "Rinker Materials" }, { "name": "RJ Environmental", "code": "RJ Environmental" }, { "name": "Siemens", "code": "Siemens" }, { "name": "Silvan Industries", "code": "Silvan Industries" }, { "name": "Simplex Inc.", "code": "Simplex Inc." }, { "name": "Snyder Industries (SII)", "code": "Snyder Industries (SII)" }, { "name": "Speedaire - Grainger", "code": "Speedaire - Grainger" }, { "name": "SST Enviro Corp", "code": "SST Enviro Corp" }, { "name": "Steel Tank Institute", "code": "Steel Tank Institute" }, { "name": "Viatec", "code": "Viatec" }, { "name": "Weesels Company", "code": "Weesels Company" }, { "name": "Xerxes Corporation", "code": "Xerxes Corporation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pumpout_Basin", "type": "esriFieldTypeString", "alias": "Pumpout Basin", "length": 6, "domain": null }, { "name": "Tank_Material", "type": "esriFieldTypeString", "alias": "Tank Material", "length": 20, "domain": { "type": "codedValue", "name": "BUO_TankMaterial", "description": "Tank materials defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Fiber Glass", "code": "Fiber Glass" }, { "name": "Fiber Reinforced Plastic", "code": "Fiber Reinforced Plastic" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tank_Capacity", "type": "esriFieldTypeInteger", "alias": "Tank Capacity", "domain": null }, { "name": "Service_Type", "type": "esriFieldTypeString", "alias": "Service Type", "length": 30, "domain": { "type": "codedValue", "name": "BUO_Septic_Service_Type", "description": "Septic and Step Tank Type", "codedValues": [ { "name": "Gravity Tank", "code": "Gravity Tank" }, { "name": "Step - 1/2 HP We05hh", "code": "Step - 1/2 HP We05hh" }, { "name": "Step - 1/2 HP We05", "code": "Step - 1/2 HP We05" }, { "name": "Step - 1/3 HP We03", "code": "Step - 1/3 HP We03" }, { "name": "Step - 1 HP", "code": "Step - 1 HP" }, { "name": "Step - Pump Unknown HP", "code": "Step - Pump Unknown HP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pump_Out_Sub_Basin", "type": "esriFieldTypeString", "alias": "Pump Out Sub Basin", "length": 6, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "BUO_Status", "description": "Asset status as defined by the Bureau of Utilitity Operations", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null } ], "indexes": [ { "name": "R63_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Utilities.SDELOADER.Septic_TankPROD", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "TANK_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }