{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "criteria_species", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date_et", "creatorField": "created_user_et", "editDateField": "last_edited_date_et", "editorField": "last_edited_user_et" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 8, "name": "iba_polygons", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "guid", "composite": false, "catalogID": "{D8E51EBD-5BF4-4A2A-8649-FF2D8FA91F9A}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1664396754000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid_1", "displayField": "sci_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "site_id", "type": "esriFieldTypeInteger", "alias": "site_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "site_id" }, { "name": "species_id", "type": "esriFieldTypeInteger", "alias": "species_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "species_id" }, { "name": "criteria_id", "type": "esriFieldTypeSmallInteger", "alias": "criteria_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "criteria_id" }, { "name": "criteria_type_id", "type": "esriFieldTypeSmallInteger", "alias": "criteria_type_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "criteria_type_id" }, { "name": "assessment_dt", "type": "esriFieldTypeDate", "alias": "assessment_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "assessment_dt" }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "id" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": { "type": "codedValue", "name": "criteria", "description": "criteria", "codedValues": [ { "name": "NULL", "code": "NULL" }, { "name": "IBA-A1-Global Species of Conservation Concern", "code": "IBA-A1-Global Species of Conservation Concern" }, { "name": "IBA-A2-Assemblage of Restricted-range species", "code": "IBA-A2-Assemblage of Restricted-range species" }, { "name": "IBA-A3-Assemblage of Biome-restricted species", "code": "IBA-A3-Assemblage of Biome-restricted species" }, { "name": "IBA-A4i->1% N.A waterbird pop. simultaneously; 5% over season", "code": "IBA-A4i->1% N.A waterbird pop. simultaneously; 5% over season" }, { "name": "IBA-A4ii->1% global pop. seabirds/terrestrial sp. simultaneously; 5% over season", "code": "IBA-A4ii->1% global pop. seabirds/terrestrial sp. simultaneously; 5% over season" }, { "name": "IBA-A4iii->20,000 waterbirds/ >10,000 seabirds", "code": "IBA-A4iii->20,000 waterbirds/ >10,000 seabirds" }, { "name": "IBA-A4iv->5% NA pop migr waterbrds; >5% globl pop migr seabrds/terrstral sp in season", "code": "IBA-A4iv->5% NA pop migr waterbrds; >5% globl pop migr seabrds/terrstral sp in season" }, { "name": "IBA-B1-Continental Species of Conservation Concern", "code": "IBA-B1-Continental Species of Conservation Concern" }, { "name": "IBA-B3-Assemblage of Bird Conservation Region-restricted Species", "code": "IBA-B3-Assemblage of Bird Conservation Region-restricted Species" }, { "name": "IBA-B4i->1% flyway/subsp. waterbird pop. simultaneously; 5% over season", "code": "IBA-B4i->1% flyway/subsp. waterbird pop. simultaneously; 5% over season" }, { "name": "IBA-B4ii-> 1% N.A. pop. seabirds/terrestrial sp. simultaneously; 5% over season", "code": "IBA-B4ii-> 1% N.A. pop. seabirds/terrestrial sp. simultaneously; 5% over season" }, { "name": "IBA-B4iv->5%flywy/subsp pop migr wterbrds;>5%NA pop migr seabrds/terrstral sp in season", "code": "IBA-B4iv->5%flywy/subsp pop migr wterbrds;>5%NA pop migr seabrds/terrstral sp in season" }, { "name": "IBA-D1-State Species of Conservation Concern", "code": "IBA-D1-State Species of Conservation Concern" }, { "name": "IBA-D3-Species in rare/unique habitat", "code": "IBA-D3-Species in rare/unique habitat" }, { "name": "IBA-D4i->1% State population", "code": "IBA-D4i->1% State population" }, { "name": "IBA-D4ii-waterfowl (State defined)", "code": "IBA-D4ii-waterfowl (State defined)" }, { "name": "IBA-D4iii-wading birds (State defined)", "code": "IBA-D4iii-wading birds (State defined)" }, { "name": "IBA-D4iv-seabirds/other colonial waterbirds (State defined)", "code": "IBA-D4iv-seabirds/other colonial waterbirds (State defined)" }, { "name": "IBA-D4v-shorebirds (State defined)", "code": "IBA-D4v-shorebirds (State defined)" }, { "name": "IBA-D4vi-raptors/season (State defined)", "code": "IBA-D4vi-raptors/season (State defined)" }, { "name": "IBA-D4vii-US State: outstanding landbird stopover", "code": "IBA-D4vii-US State: outstanding landbird stopover" }, { "name": "IBA-D5-Research site", "code": "IBA-D5-Research site" }, { "name": "KBA-A1-Sites qualifying as KBAs under criterion A1 hold a significant proportion of the global population size of a species facing a high risk of extinction and so contribute to the global persistence of biodiversity at genetic and species levels.", "code": "KBA-A1-Sites qualifying as KBAs under criterion A1 hold a significant proportion of the global population size of a species facing a high risk of extinction and so contribute to the global persistence of biodiversity at genetic and species levels." }, { "name": "KBA-A2-Threatened ecosystem types", "code": "KBA-A2-Threatened ecosystem types" }, { "name": "KBA-B1-Individual geographically restricted species", "code": "KBA-B1-Individual geographically restricted species" }, { "name": "KBA-B2-Co-occurring geographically restricted species", "code": "KBA-B2-Co-occurring geographically restricted species" }, { "name": "KBA-B3-Geographically restricted assemblages", "code": "KBA-B3-Geographically restricted assemblages" }, { "name": "KBA-B4-Geographically restricted ecosystem types", "code": "KBA-B4-Geographically restricted ecosystem types" }, { "name": "KBA-C-Ecological integrity", "code": "KBA-C-Ecological integrity" }, { "name": "KBA-D1-Demographic aggregations", "code": "KBA-D1-Demographic aggregations" }, { "name": "KBA-D2-Ecological refugia", "code": "KBA-D2-Ecological refugia" }, { "name": "KBA-D3-Recruitment sources", "code": "KBA-D3-Recruitment sources" }, { "name": "KBA-E-Irreplaceability through quantitative analysis", "code": "KBA-E-Irreplaceability through quantitative analysis" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "description" }, { "name": "code", "type": "esriFieldTypeString", "alias": "code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "code" }, { "name": "created_dt", "type": "esriFieldTypeDate", "alias": "created_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_dt" }, { "name": "modified_dt", "type": "esriFieldTypeDate", "alias": "modified_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "modified_dt" }, { "name": "priority_id", "type": "esriFieldTypeSmallInteger", "alias": "priority_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "priority_id" }, { "name": "site_criteria_id", "type": "esriFieldTypeInteger", "alias": "site_criteria_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "site_criteria_id" }, { "name": "criteria_id_1", "type": "esriFieldTypeSmallInteger", "alias": "criteria_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "criteria_id_1" }, { "name": "criteria_type_id_1", "type": "esriFieldTypeSmallInteger", "alias": "criteria_type_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "criteria_type_id_1" }, { "name": "assessment_dt_1", "type": "esriFieldTypeDate", "alias": "assessment_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "assessment_dt_1" }, { "name": "modified_by", "type": "esriFieldTypeString", "alias": "modified_by", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "modified_by" }, { "name": "site_species_id", "type": "esriFieldTypeInteger", "alias": "site_species_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "site_species_id" }, { "name": "site_id_12", "type": "esriFieldTypeInteger", "alias": "site_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "site_id_12" }, { "name": "species_id_1", "type": "esriFieldTypeInteger", "alias": "species_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "species_id_1" }, { "name": "modified_by_1", "type": "esriFieldTypeString", "alias": "modified_by", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "modified_by_1" }, { "name": "id_1", "type": "esriFieldTypeInteger", "alias": "id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "id_1" }, { "name": "genus_id", "type": "esriFieldTypeInteger", "alias": "genus_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "genus_id" }, { "name": "species_code", "type": "esriFieldTypeString", "alias": "species_code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "species_code" }, { "name": "sci_name", "type": "esriFieldTypeString", "alias": "sci_name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "sci_name" }, { "name": "common_name", "type": "esriFieldTypeString", "alias": "common_name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "common_name" }, { "name": "taxonomic_sort_code", "type": "esriFieldTypeDouble", "alias": "taxonomic_sort_code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "taxonomic_sort_code" }, { "name": "aou_checklist_fl", "type": "esriFieldTypeSmallInteger", "alias": "aou_checklist_fl", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "aou_checklist_fl" }, { "name": "category_2000", "type": "esriFieldTypeString", "alias": "category_2000", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "category_2000" }, { "name": "category_2002", "type": "esriFieldTypeString", "alias": "category_2002", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "category_2002" }, { "name": "sibley_fl", "type": "esriFieldTypeInteger", "alias": "sibley_fl", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sibley_fl" }, { "name": "active_fl", "type": "esriFieldTypeSmallInteger", "alias": "active_fl", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "active_fl" }, { "name": "created_dt_1", "type": "esriFieldTypeDate", "alias": "created_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_dt_1" }, { "name": "modified_dt_1", "type": "esriFieldTypeDate", "alias": "modified_dt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "modified_dt_1" }, { "name": "globalid", "type": "esriFieldTypeString", "alias": "globalid", "domain": null, "editable": true, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "domain": { "type": "codedValue", "name": "CriteriaType", "description": "CriteriaType", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Confirmed", "code": "Confirmed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "status" }, { "name": "assessment_dt_strg", "type": "esriFieldTypeString", "alias": "assessment_dt_strg", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "assessment_dt_strg" }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "guid" }, { "name": "globalid_1", "type": "esriFieldTypeGlobalID", "alias": "globalid_1", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid_1" }, { "name": "created_user_et", "type": "esriFieldTypeString", "alias": "created_user_et", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user_et", "required": true }, { "name": "created_date_et", "type": "esriFieldTypeDate", "alias": "created_date_et", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date_et", "required": true }, { "name": "last_edited_user_et", "type": "esriFieldTypeString", "alias": "last_edited_user_et", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user_et", "required": true }, { "name": "last_edited_date_et", "type": "esriFieldTypeDate", "alias": "last_edited_date_et", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date_et", "required": true } ], "indexes": [ { "name": "gdb_93_guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r43_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "uuid_43", "fields": "globalid_1", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "criteria_species", "description": "", "prototype": { "attributes": { "guid": null, "site_id": null, "species_id": null, "criteria_id": null, "criteria_type_id": null, "assessment_dt": null, "id": null, "description": null, "code": null, "created_dt": null, "modified_dt": null, "priority_id": null, "site_criteria_id": null, "criteria_id_1": null, "criteria_type_id_1": null, "assessment_dt_1": null, "modified_by": null, "site_species_id": null, "site_id_12": null, "species_id_1": null, "modified_by_1": null, "id_1": null, "genus_id": null, "species_code": null, "sci_name": null, "common_name": null, "taxonomic_sort_code": null, "aou_checklist_fl": null, "category_2000": null, "category_2002": null, "sibley_fl": null, "active_fl": null, "created_dt_1": null, "modified_dt_1": null, "globalid": " ", "status": null, "assessment_dt_strg": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Sync,Extract,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "userTypeExtensions": [ "advancedEditing" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "087b591fd12d4dc482a4d9a3e2b60246" }