{ "currentVersion": 10.41, "id": 16, "name": "BMPInspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BMP_INSP_ID", "typeIdField": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BMP_INSP_ID", "type": "esriFieldTypeString", "alias": "BMP Inspections ID", "length": 13, "domain": null }, { "name": "BMP_ID", "type": "esriFieldTypeString", "alias": "BMP ID", "length": 13, "domain": null }, { "name": "BMP_STATUS", "type": "esriFieldTypeString", "alias": "BMP Status", "length": 1, "domain": { "type": "codedValue", "name": "dPassFail", "codedValues": [ { "name": "Fail", "code": "F" }, { "name": "Pass", "code": "P" } ] } }, { "name": "LAST_INSP_DATE", "type": "esriFieldTypeDate", "alias": "Last Inspection", "length": 8, "domain": null }, { "name": "MAIN_DATE", "type": "esriFieldTypeDate", "alias": "Last Maintenance", "length": 8, "domain": null }, { "name": "REINSP_STATUS", "type": "esriFieldTypeString", "alias": "Re-inspection Status", "length": 1, "domain": { "type": "codedValue", "name": "dPassFail", "codedValues": [ { "name": "Fail", "code": "F" }, { "name": "Pass", "code": "P" } ] } }, { "name": "REINSP_DATE", "type": "esriFieldTypeDate", "alias": "Re-inspection Date", "length": 8, "domain": null }, { "name": "REPORTING_YEAR", "type": "esriFieldTypeString", "alias": "Reporting Year", "length": 4, "domain": null }, { "name": "PERMIT_NUM", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 11, "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "General Comments", "length": 255, "domain": null } ], "indexes": [ { "name": "R2161_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G9318BMP_ID", "fields": "BMP_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G9318PERMIT_NUM", "fields": "PERMIT_NUM", "isAscending": true, "isUnique": false, "description": "" } ], "relationships": [ { "id": 33, "name": "BMP", "relatedTableId": 34, "role": "esriRelRoleDestination", "keyField": "BMP_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 34, "name": "PermitInfo", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "PERMIT_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true }, "dateFieldsTimeReference": null }