{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 39, "name": "Sewer Pressure Main Info", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME_NUMBER", "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": "NAME_NUMBER", "type": "esriFieldTypeString", "alias": "NAME_NUMBER", "length": 30, "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": "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": "Inside_Diameter", "type": "esriFieldTypeDouble", "alias": "Inside Diameter", "domain": null }, { "name": "Outside_Diameter", "type": "esriFieldTypeDouble", "alias": "Outside Diameter", "domain": null }, { "name": "Cathodic_Protection", "type": "esriFieldTypeString", "alias": "Cathodic Protection", "length": 3, "domain": { "type": "codedValue", "name": "Yes/No", "description": "Three character Yes/No values", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lining_Method", "type": "esriFieldTypeString", "alias": "Lining Method", "length": 30, "domain": { "type": "codedValue", "name": "BUO_Lining_Method", "description": "Lining methods defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Cured In Place", "code": "Cured In Place" }, { "name": "Slip Lined", "code": "Slip Lined" }, { "name": "Pipe Bursting", "code": "Pipe Bursting" }, { "name": "Internal Pipe Coating", "code": "Internal Pipe Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Lined", "type": "esriFieldTypeDate", "alias": "Date Lined", "length": 8, "domain": null }, { "name": "Lined_Material", "type": "esriFieldTypeString", "alias": "Lined Material", "length": 20, "domain": { "type": "codedValue", "name": "BUO_Lined_Material", "description": "Lining materials as defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Cementitious", "code": "Cementitious" }, { "name": "CIPP", "code": "CIPP" }, { "name": "PVC", "code": "PVC" }, { "name": "Bituminous", "code": "Bituminous" }, { "name": "HPDE", "code": "HPDE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Pipe_Schedule", "type": "esriFieldTypeString", "alias": "Pipe Schedule", "length": 15, "domain": { "type": "codedValue", "name": "BUO_Pipe_Schedule", "description": "Pipe Schedule", "codedValues": [ { "name": "10", "code": "10" }, { "name": "100", "code": "100" }, { "name": "10S", "code": "10S" }, { "name": "120", "code": "120" }, { "name": "140", "code": "140" }, { "name": "160", "code": "160" }, { "name": "20", "code": "20" }, { "name": "30", "code": "30" }, { "name": "40", "code": "40" }, { "name": "40S", "code": "40S" }, { "name": "5", "code": "5" }, { "name": "5S", "code": "5S" }, { "name": "60", "code": "60" }, { "name": "80", "code": "80" }, { "name": "80S", "code": "80S" }, { "name": "STD", "code": "STD" }, { "name": "XS", "code": "XS" }, { "name": "XXS", "code": "XXS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SDR_Rating", "type": "esriFieldTypeString", "alias": "SDR Rating", "length": 15, "domain": { "type": "codedValue", "name": "BUO_SDR_Rating", "description": "SDR Pipe Rating", "codedValues": [ { "name": "7", "code": "7" }, { "name": "11", "code": "11" }, { "name": "17", "code": "17" }, { "name": "26", "code": "26" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Utilities.SDELOADER.Sewer_Pressure_MainPROD", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "NAME_NUMBER", "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 } }