{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 41, "name": "Traffice Signs Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NameIDAddr", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 30 }, { "name": "SupportAssetID", "type": "esriFieldTypeString", "alias": "Support Asset ID", "length": 30 }, { "name": "Overhead", "type": "esriFieldTypeString", "alias": "Overhead", "length": 3 }, { "name": "AddressQualifier", "type": "esriFieldTypeString", "alias": "Address Qualifier", "length": 255 }, { "name": "FromStreet", "type": "esriFieldTypeString", "alias": "From Street", "length": 50 }, { "name": "ToStreet", "type": "esriFieldTypeString", "alias": "To Street", "length": 50 }, { "name": "ProjectNumber", "type": "esriFieldTypeString", "alias": "Project Number", "length": 30 }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8 }, { "name": "FacingDirection", "type": "esriFieldTypeString", "alias": "Facing Direction", "length": 30 }, { "name": "SignText", "type": "esriFieldTypeString", "alias": "Sign Text", "length": 255 }, { "name": "SignSize", "type": "esriFieldTypeString", "alias": "Sign Size", "length": 30 }, { "name": "ReflectiveCoating", "type": "esriFieldTypeString", "alias": "Reflective Coating", "length": 30 }, { "name": "SignType", "type": "esriFieldTypeString", "alias": "Sign Type", "length": 30 }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 20 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38 }, { "name": "MaintainedBy", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 20 }, { "name": "Ownership", "type": "esriFieldTypeString", "alias": "Ownership", "length": 20 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8 }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "length": 255 }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "Life Cycle Status", "length": 20 }, { "name": "AbandonedRetiredDate", "type": "esriFieldTypeDate", "alias": "Abandoned/Retired Date", "length": 8 } ], "indexes": [ { "name": "R470_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_470", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1743SupportAsse", "fields": "SupportAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }