{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "SDE.DBO.veDefect", "type": "Table", "description": "This standalone table relates the City ID to a Feature ID which shows the tree defect.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "tree...", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "composite": false, "catalogID": "{4F668411-EA5A-417A-8B56-92A85DEA0399}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "COGID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "TREEDEFECT", "type": "esriFieldTypeString", "alias": "Defect", "domain": { "type": "codedValue", "name": "veDefects", "description": "Defects of the tree.", "codedValues": [ { "name": "Basal Decay", "code": "BasalDecay" }, { "name": "Branch Broken", "code": "BranchBroken" }, { "name": "Branch Tear", "code": "BranchTear" }, { "name": "Broken Top", "code": "BrokenTop" }, { "name": "Crack", "code": "Crack" }, { "name": "Crown Decay", "code": "CrownDecay" }, { "name": "Crown Wound", "code": "CrownWound" }, { "name": "Dead Top", "code": "DeadTop" }, { "name": "Deadwood", "code": "Deadwood" }, { "name": "Dieback Major", "code": "DiebackMajor" }, { "name": "Dieback Minor", "code": "DiebackMinor" }, { "name": "Disease", "code": "Disease" }, { "name": "Included Bark", "code": "IncludedBark" }, { "name": "Lean", "code": "Lean" }, { "name": "Restricted", "code": "Restricted" }, { "name": "Root Collar", "code": "RootCollar" }, { "name": "Storm Damage", "code": "StormDamage" }, { "name": "Topped", "code": "Topped" }, { "name": "Trunk Decay", "code": "TrunkDecay" }, { "name": "Utility", "code": "Utility" }, { "name": "Detached Bark", "code": "DetachedBark" }, { "name": "Basal Damage", "code": "BasalDamage" }, { "name": "Insects", "code": "Insects" }, { "name": "Foreign Object", "code": "ForeignObject" }, { "name": "Girdling", "code": "Girdling" }, { "name": "Hanging Branch", "code": "HangingBranch" }, { "name": "Trunk Damage", "code": "TrunkDamage" }, { "name": "Root Damage", "code": "RootDamage" }, { "name": "Codominant Stem", "code": "CodominantStem" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "One Sided", "code": "OneSided" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TREEDEFECT" }, { "name": "DEFECTDATE", "type": "esriFieldTypeDate", "alias": "Defect Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DEFECTDATE" }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GLOBALID" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "GIS Comment", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "COMMENT" }, { "name": "COGID", "type": "esriFieldTypeString", "alias": "City ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "COGID" }, { "name": "FeatureID", "type": "esriFieldTypeString", "alias": "Feature ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "FeatureID" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "veEditors", "description": "Editor List For Trees", "codedValues": [ { "name": "Wendy Clements", "code": "Wendy" }, { "name": "Micaiah Huff", "code": "Micaiah" }, { "name": "Janie Kuntz", "code": "Janie" }, { "name": "Adan Aguilar", "code": "Adan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" } ], "indexes": [ { "name": "R18481_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_116689_REL_G", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDE.DBO.veDefect", "description": "", "prototype": { "attributes": { "LASTEDITOR": null, "TREEDEFECT": null, "DEFECTDATE": null, "REL_GLOBALID": null, "COMMENT": null, "COGID": null, "FeatureID": null, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "9e5ee9372b6c47bcb952181157ebb9ac" }