{ "currentVersion": 10.81, "id": 36, "name": "SW Inflow Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CONDITION_RATING", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "CONDITION_RATING", "type": "esriFieldTypeString", "alias": "Condition Rating", "length": 50, "domain": { "type": "codedValue", "name": "Rating", "description": "", "codedValues": [ { "name": "5 (Best)", "code": "5 (Best)" }, { "name": "4", "code": "4" }, { "name": "3", "code": "3" }, { "name": "2", "code": "2" }, { "name": "1 (Worst)", "code": "1 (Worst)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "WORK_PERFORMED_BY", "type": "esriFieldTypeString", "alias": "Work Performed By", "length": 50, "domain": { "type": "codedValue", "name": "SW_Work_Performed_By", "description": "", "codedValues": [ { "name": "Public Works", "code": "Public Works" }, { "name": "tylerbrooks", "code": "tylerbrooks" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLOW_ID_NUMBER", "type": "esriFieldTypeString", "alias": "Inflow ID#", "length": 50, "domain": null }, { "name": "REPAIR_NEEDED_NOTES", "type": "esriFieldTypeString", "alias": "Repair Needed Notes", "length": 250, "domain": null }, { "name": "MAINTENANCE_NEEDED", "type": "esriFieldTypeString", "alias": "Maintenance Needed?", "length": 50, "domain": { "type": "codedValue", "name": "MaintenanceNeeded", "description": "", "codedValues": [ { "name": "Jetting", "code": "Jetting" }, { "name": "Brush/Tree Removal", "code": "Brush/Tree Removal" }, { "name": "Seal Cracks", "code": "Seal Cracks" }, { "name": "Debris Removal", "code": "Debris Removal" }, { "name": "Other (Put in Maintenance Notes)", "code": "Other (Put in Maintenance Notes)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTENANCE_NEEDED_NOTES", "type": "esriFieldTypeString", "alias": "Maintenance Needed Notes", "length": 250, "domain": null }, { "name": "URGENCY", "type": "esriFieldTypeString", "alias": "Urgency", "length": 50, "domain": { "type": "codedValue", "name": "Urgency", "description": "", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium", "code": "Medium" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PUBLICWORKS", "type": "esriFieldTypeString", "alias": "Public Works to Perform work?", "length": 50, "domain": { "type": "codedValue", "name": "swYesNo", "description": "", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIR_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Repair/Maintenance Needed?", "length": 50, "domain": { "type": "codedValue", "name": "Repair/Maintenance", "description": "", "codedValues": [ { "name": "No Repair/Maintence Needed", "code": "No Repair/Maintenance Needed" }, { "name": "Needs Maintenance", "code": "Needs Maintenance" }, { "name": "Needs to be Repaired", "code": "Needs to be Repaired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelatedGUID", "type": "esriFieldTypeGUID", "alias": "RelatedGUID", "length": 38, "domain": null } ], "indexes": [ { "name": "GDB_2352_INFLOW_", "fields": "INFLOW_ID_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2352_Related", "fields": "RelatedGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "Stormwater_Inflow_Maintenance", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "Stormwater_Inflow_Repair", "relatedTableId": 34, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "swInflow", "relatedTableId": 17, "role": "esriRelRoleDestination", "keyField": "RelatedGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }