{ "currentVersion": 10.71, "id": 18, "name": "Stormwater.DBO.PROJECTINFO", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJ_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJECTID", "type": "esriFieldTypeString", "alias": "Project ID", "length": 50, "domain": null }, { "name": "PROJ_NAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "WATERSHED", "type": "esriFieldTypeString", "alias": "Watershed", "length": 50, "domain": { "type": "codedValue", "name": "WATERSHED", "description": "Watershed Name", "codedValues": [ { "name": "Beaver Creek 1", "code": "BV1" }, { "name": "Beaver Creek 2", "code": "BV2" }, { "name": "Beaver Creek 3", "code": "BV3" }, { "name": "Blounts Creek", "code": "BLN" }, { "name": "Bones Creek", "code": "BON" }, { "name": "Buckhead Creek", "code": "BKH" }, { "name": "Cape Fear 1", "code": "CF1" }, { "name": "Cape Fear 2", "code": "CF2" }, { "name": "Carvers Creek", "code": "CRV" }, { "name": "Cross Creek", "code": "CRO" }, { "name": "Little Cross Creek", "code": "LCR" }, { "name": "Little Rockfish Creek 1", "code": "LR1" }, { "name": "Little Rockfish Creek 2", "code": "LR2" }, { "name": "Rockfish Creek", "code": "RFC" }, { "name": "Stewarts Creek", "code": "STW" }, { "name": "Outside", "code": "OUT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSULTANT", "type": "esriFieldTypeString", "alias": "Consultant", "length": 50, "domain": null }, { "name": "COMPLT_DATE", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "ADD_CMNTS", "type": "esriFieldTypeString", "alias": "Additional Comments", "length": 120, "domain": null } ], "indexes": [ { "name": "R510_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }