{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "attachmentProperties": [ { "fieldName": "ATTACHMENTID", "isEnabled": true, "name": "id" }, { "fieldName": "GLOBALID", "isEnabled": true, "name": "globalid" }, { "fieldName": "KEYWORDS", "isEnabled": false, "name": "keywords" }, { "fieldName": "ATT_NAME", "isEnabled": true, "name": "name" }, { "fieldName": "CONTENT_TYPE", "isEnabled": true, "name": "contentType" }, { "fieldName": "DATA_SIZE", "isEnabled": true, "name": "size" }, { "fieldName": "EXIFINFO", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "domain": null, "name": "ATTACHMENTID", "length": 4, "alias": "ATTACHMENTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "domain": null, "name": "GLOBALID", "length": 38, "alias": "GLOBALID", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": true, "domain": null, "name": "ATT_NAME", "length": 250, "alias": "ATT_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "CONTENT_TYPE", "length": 150, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "DATA_SIZE", "length": 4, "alias": "DATA_SIZE", "type": "esriFieldTypeInteger" } ], "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [ { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{B3899016-6838-432A-9AC9-66257918F108}", "composite": false, "name": "ssInlet_POINT", "relatedTableId": 108, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{B3899016-6838-432A-9AC9-66257918F108}", "composite": false, "name": "ssInlet_POINT", "relatedTableId": 104, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{B6069007-C271-4919-BC96-7907969A499A}", "composite": false, "name": "ssChannel", "relatedTableId": 105, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{0CB01DC4-8193-4B3C-99A7-E781318E390C}", "composite": false, "name": "ssJunctionBox", "relatedTableId": 107, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{0CB01DC4-8193-4B3C-99A7-E781318E390C}", "composite": false, "name": "ssJunctionBox", "relatedTableId": 106, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "MaximoID", "role": "esriRelRoleDestination", "catalogID": "{F81900AC-9521-4106-9EEE-F04F7D803CD6}", "composite": false, "name": "ssOutfall", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "indexes": [ { "name": "R60_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_60", "isUnique": false, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "GDB_2513_MaximoI", "isUnique": false, "description": "", "fields": "MaximoID", "isAscending": true }, { "name": "UUID_OID_60", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 93, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithCacheHint": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsStatistics": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsQueryAttachmentOrderByFields": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Map,Query,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Stormwater Inspections", "displayField": "MaximoID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "MaximoID", "length": 20, "alias": "MaximoID:", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CondtnStat", "description": "", "type": "codedValue", "codedValues": [ { "code": "A: New/Good", "name": "A: New/Good" }, { "code": "B: Fair", "name": "B: Fair" }, { "code": "C: Poor (Replace)", "name": "C: Poor (Replace)" }, { "code": "N/A", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "StructuralCondition", "length": 20, "alias": "Structural Condition:", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YorN_1", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RequiresRepairs", "length": 5, "alias": "Requires Repairs?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YorN_1", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RequiresCleaning", "length": 5, "alias": "Requires Cleaning?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ObservedDebrisAccumulation", "alias": "Observed Debris Accumulation (Inches):", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DebrisType", "description": "", "type": "codedValue", "codedValues": [ { "code": "Sediment", "name": "Sediment" }, { "code": "Floatables", "name": "Floatables" }, { "code": "Yard Waste", "name": "Yard Waste" }, { "code": "Oils", "name": "Oils" }, { "code": "Construction Debris", "name": "Construction Debris" }, { "code": "None", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TypeOfDebris", "length": 50, "alias": "Type of Debris:", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YorN_1", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "InletMarkerPresent", "length": 5, "alias": "Inlet Marker Present?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "InspectDate", "length": 8, "alias": "Inspection Date:", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "Comments", "length": 200, "alias": "Inspection Comments:", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YorN_1", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "MapError", "length": 50, "alias": "Map change needed?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MapErrorCmnts", "length": 200, "alias": "Map Error Comments:", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WorkOrder", "length": 50, "alias": "Work Order Number:", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YorN_1", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "HasBeenCleaned", "length": 10, "alias": "Has been cleaned?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CleanDate", "length": 8, "alias": "Clean Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "CleanComments", "length": 200, "alias": "CleanComments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "yesNo", "description": "General purpose \"yes\" or \"no\" values", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "IsProblemArea", "length": 10, "alias": "Is Problem Area?", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "InspectionActivity", "description": "Describe the reason for the visit to the asset", "type": "codedValue", "codedValues": [ { "code": "Operational Inspection", "name": "Operational Inspection" }, { "code": "Marker Inspection", "name": "Marker Inspection" }, { "code": "Marker Install", "name": "Marker Install" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Activity", "length": 255, "alias": "Activity", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null }