{ "tables": [ { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "basis_of_record", "displayField": "code", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basis_id", "alias": "basis_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "code", "length": 255, "alias": "code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "label", "length": 255, "alias": "label", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r511_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "biological_groups", "displayField": "group_code", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "group_id", "alias": "group_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "group_code", "length": 32, "alias": "group_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "label", "length": 80, "alias": "label", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r512_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "coc_assignment_rules", "displayField": "assignment_region_code", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignment_region_code", "length": 64, "alias": "assignment_region_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "length": 80, "alias": "source_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priority", "alias": "priority", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_available", "length": 8, "alias": "source_available", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_layer", "length": 80, "alias": "match_layer", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_field", "length": 80, "alias": "match_field", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_value", "length": 80, "alias": "match_value", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "note", "length": 512, "alias": "note", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r513_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "coc_source_catalog", "displayField": "source_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "length": 80, "alias": "source_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_type", "length": 32, "alias": "source_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_name", "length": 255, "alias": "source_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_database_id", "alias": "source_database_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_code", "length": 64, "alias": "region_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_name", "length": 128, "alias": "region_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_year", "alias": "source_year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_priority_group", "length": 64, "alias": "source_priority_group", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_path", "length": 512, "alias": "source_path", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_url", "length": 512, "alias": "source_url", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 32, "alias": "status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "note", "length": 512, "alias": "note", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r514_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "coc_taxon_match_summary", "displayField": "total_rows", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "alias": "source_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_rows", "length": 255, "alias": "total_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_rows", "length": 255, "alias": "matched_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unmatched_rows", "length": 255, "alias": "unmatched_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_rate", "alias": "match_rate", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_exact", "length": 255, "alias": "species_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_exact", "length": 255, "alias": "accepted_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_exact", "length": 255, "alias": "scientific_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_canonical", "length": 255, "alias": "species_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_canonical", "length": 255, "alias": "accepted_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_canonical", "length": 255, "alias": "scientific_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "no_match", "length": 255, "alias": "no_match", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "no_name", "length": 255, "alias": "no_name", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r515_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "coc_taxon_values", "displayField": "scientific_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name", "length": 255, "alias": "scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name_key", "length": 255, "alias": "scientific_name_key", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "coc_value", "alias": "coc_value", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "length": 80, "alias": "source_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_code", "length": 64, "alias": "region_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_name", "length": 128, "alias": "region_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignment_method", "length": 64, "alias": "assignment_method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "native_status", "length": 64, "alias": "native_status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wetland_indicator", "length": 32, "alias": "wetland_indicator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "growth_form", "length": 64, "alias": "growth_form", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "duration", "length": 64, "alias": "duration", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "common_name", "length": 255, "alias": "common_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_method", "length": 64, "alias": "match_method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_taxon_key", "alias": "matched_taxon_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_accepted_key", "alias": "matched_accepted_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_species_key", "alias": "matched_species_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_rank", "length": 32, "alias": "matched_rank", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_species", "length": 255, "alias": "matched_species", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_scientific_name", "length": 255, "alias": "matched_scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_accepted_name", "length": 255, "alias": "matched_accepted_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_family", "length": 128, "alias": "matched_family", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r516_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "datasets", "displayField": "dataset_key", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dataset_id", "alias": "dataset_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dataset_key", "length": 64, "alias": "dataset_key", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dataset_name", "length": 512, "alias": "dataset_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "publisher", "length": 512, "alias": "publisher", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r517_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "licenses", "displayField": "code", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "license_id", "alias": "license_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "code", "length": 255, "alias": "code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "label", "length": 255, "alias": "label", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r518_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "nwpl_source_catalog", "displayField": "source_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "length": 80, "alias": "source_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_version", "length": 80, "alias": "source_version", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_workbook", "length": 255, "alias": "source_workbook", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_system", "length": 255, "alias": "region_system", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indicator_field", "length": 255, "alias": "indicator_field", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r519_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "nwpl_taxon_match_summary", "displayField": "total_rows", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_id", "alias": "source_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_rows", "length": 255, "alias": "total_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_rows", "length": 255, "alias": "matched_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unmatched_rows", "length": 255, "alias": "unmatched_rows", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_rate", "alias": "match_rate", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_exact", "length": 255, "alias": "species_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_exact", "length": 255, "alias": "accepted_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_exact", "length": 255, "alias": "scientific_exact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_canonical", "length": 255, "alias": "species_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_canonical", "length": 255, "alias": "accepted_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_canonical", "length": 255, "alias": "scientific_canonical", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "no_match", "length": 255, "alias": "no_match", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "no_name", "length": 255, "alias": "no_name", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r520_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "nwpl_taxon_region_values", "displayField": "scientific_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name", "length": 255, "alias": "scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name_key", "length": 255, "alias": "scientific_name_key", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "common_name", "length": 255, "alias": "common_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region_code", "length": 16, "alias": "region_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indicator_status", "length": 8, "alias": "indicator_status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_version", "length": 80, "alias": "source_version", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_method", "length": 64, "alias": "match_method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_taxon_key", "alias": "matched_taxon_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_accepted_key", "alias": "matched_accepted_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_species_key", "alias": "matched_species_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_rank", "length": 32, "alias": "matched_rank", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_species", "length": 255, "alias": "matched_species", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_scientific_name", "length": 255, "alias": "matched_scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matched_accepted_name", "length": 255, "alias": "matched_accepted_name", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r521_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 11, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "states", "displayField": "state_abbr", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_id", "alias": "state_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_abbr", "length": 4, "alias": "state_abbr", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_name", "length": 64, "alias": "state_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "download_key", "length": 64, "alias": "download_key", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "doi", "length": 128, "alias": "doi", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_rows", "alias": "source_rows", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hosted_rows", "alias": "hosted_rows", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "excluded_birds", "alias": "excluded_birds", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bird_hosted_rows", "alias": "bird_hosted_rows", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bird_pct", "alias": "bird_pct", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gdb_path", "length": 512, "alias": "gdb_path", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feature_class", "length": 128, "alias": "feature_class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bird_feature_class", "length": 128, "alias": "bird_feature_class", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r522_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 12, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "statuses", "displayField": "code", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_id", "alias": "status_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "code", "length": 255, "alias": "code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "label", "length": 255, "alias": "label", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r523_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 13, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "taxa", "displayField": "kingdom", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxon_key", "alias": "taxon_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_key", "alias": "accepted_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_key", "alias": "species_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "kingdom_key", "alias": "kingdom_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phylum_key", "alias": "phylum_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "class_key", "alias": "class_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "order_key", "alias": "order_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "family_key", "alias": "family_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "genus_key", "alias": "genus_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "kingdom", "length": 80, "alias": "kingdom", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phylum", "length": 80, "alias": "phylum", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "class", "length": 80, "alias": "class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "order_name", "length": 80, "alias": "order_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "family", "length": 128, "alias": "family", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "genus", "length": 128, "alias": "genus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "group_id", "alias": "group_id", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bio_group", "length": 80, "alias": "bio_group", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "display_group", "length": 80, "alias": "display_group", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inat_group", "length": 80, "alias": "inat_group", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inat_iconic_taxon", "length": 80, "alias": "inat_iconic_taxon", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxon_group_confidence", "length": 32, "alias": "taxon_group_confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxon_group_version", "length": 64, "alias": "taxon_group_version", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name", "length": 512, "alias": "scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted_name", "length": 512, "alias": "accepted_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species", "length": 512, "alias": "species", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rank", "length": 32, "alias": "rank", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iucn", "length": 16, "alias": "iucn", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inat_taxon_id", "alias": "inat_taxon_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "common_name", "length": 255, "alias": "common_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_url", "length": 1000, "alias": "photo_url", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_attribution", "length": 1000, "alias": "photo_attribution", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_license_code", "length": 32, "alias": "photo_license_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_source", "length": 32, "alias": "photo_source", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_match_status", "length": 32, "alias": "photo_match_status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_queried_at", "length": 64, "alias": "photo_queried_at", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r524_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "id": 14, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "taxon_state_status", "displayField": "state_abbr", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "taxon_key", "alias": "taxon_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species_key", "alias": "species_key", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inat_taxon_id", "alias": "inat_taxon_id", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_abbr", "length": 4, "alias": "state_abbr", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scientific_name", "length": 512, "alias": "scientific_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "auto_obscured_in_state", "length": 32, "alias": "auto_obscured_in_state", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_authority", "length": 255, "alias": "status_authority", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 64, "alias": "status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_name", "length": 255, "alias": "status_name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_place", "length": 255, "alias": "status_place", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iucn_code", "length": 16, "alias": "iucn_code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_status", "length": 32, "alias": "match_status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 255, "alias": "source", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "updated_at", "length": 64, "alias": "updated_at", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": null, "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r525_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "supportsLayerOverrides": true } ], "layers": [] }