{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 39, "name": "Sewer Pressure Main Info", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME_NUMBER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FFID", "type": "esriFieldTypeInteger", "alias": "FFID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FFID" }, { "name": "NAME_NUMBER", "type": "esriFieldTypeString", "alias": "NAME_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "NAME_NUMBER" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Status" }, { "name": "Maintenance_Strategy", "type": "esriFieldTypeString", "alias": "Maintenance Strategy", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Maintenance_Strategy" }, { "name": "Install_Year", "type": "esriFieldTypeSmallInteger", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Install_Year" }, { "name": "WarrantyStartDate", "type": "esriFieldTypeDate", "alias": "Warranty Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyStartDate" }, { "name": "WarrantyEndDate", "type": "esriFieldTypeDate", "alias": "Warranty End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyEndDate" }, { "name": "Inside_Diameter", "type": "esriFieldTypeDouble", "alias": "Inside Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Inside_Diameter" }, { "name": "Outside_Diameter", "type": "esriFieldTypeDouble", "alias": "Outside Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Outside_Diameter" }, { "name": "Cathodic_Protection", "type": "esriFieldTypeString", "alias": "Cathodic Protection", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Cathodic_Protection" }, { "name": "Lining_Method", "type": "esriFieldTypeString", "alias": "Lining Method", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Lining_Method" }, { "name": "Date_Lined", "type": "esriFieldTypeDate", "alias": "Date Lined", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Lined" }, { "name": "Lined_Material", "type": "esriFieldTypeString", "alias": "Lined Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Lined_Material" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "Pipe_Schedule", "type": "esriFieldTypeString", "alias": "Pipe Schedule", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Pipe_Schedule" }, { "name": "SDR_Rating", "type": "esriFieldTypeString", "alias": "SDR Rating", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SDR_Rating" } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sewer Pressure Main Info", "description": "", "prototype": { "attributes": { "Pipe_Schedule": null, "SDR_Rating": null, "FFID": null, "NAME_NUMBER": null, "Status": null, "Maintenance_Strategy": null, "Install_Year": null, "WarrantyStartDate": null, "WarrantyEndDate": null, "Inside_Diameter": null, "Outside_Diameter": null, "Cathodic_Protection": null, "Lining_Method": null, "Date_Lined": null, "Lined_Material": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }