{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Bird Observation", "type" : "Feature Layer", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1677698582190, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 1, "name" : "BirdObservationComment", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -20037507.067161843, "ymin" : -11066907.697872387, "xmax" : 20037507.067161843, "ymax" : 30240971.958386149, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"transparency":0,"renderer":{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAz5JREFUSIm1ls9r22YYxz+SpSq/Vo1ZPUwj6S2l4GlNzKCmf0GCdWiWZWWX5WQfutN226UKlNx27CE++TQCZhlMxvcNUhtWecHxDjGDjQQcGDE0XRfXjm3toEi1YzkOg30vkqVX38/zvHqeR5b4nyVdY41sGsQnJAwB9E4P2YW6JFLKlXH+M2D5LrcVhaQokJqUMUQRIgKIAvRcaHVgdYETKcLO9gu+BM6vDVhbxOy6PJ1WMCZlkCPDa6YV6LlozTap1QVW2h0++XGfn8cCVj7iMynCtqqAMmYDRcED3ZDQXp7x0+cfk/7uFzIjAWuLmFKE7XenvIfH6UEyxWHN4ajmEJ2Bxmu2TIOKXaE0BFi+y+2uy1NVub75o6+3ADiqORSyG/x54PD7H3UbuDUEUBSS0wrGuG0BmJ2Ps7RuBb9vRnXm7sSpFm2mFLSH93j8wx7P+gHyRbWMVSxhsrz+BDX6fnBt+9s01aINwIwCZy0s6AOYBvFJGSOsWgDUqE4skeSBmWJ2Pj50/7RRD85FwXvppsF9u0JJApiQvDofZby0bg1EPGh+zFFtsN+kCLyjYMAFQAA9Irw1VDXvGBbtZV02B68h33TR4WKLOj1kUXib6tIXT8YaXwUQBc8zALhQ77nezd18ht18hvSmTSyRvNL8tHHM/nN76HrPBUmkHgAkkVKr43Wlr61vTJbXrdBsThvHVIs2u3YmNINWB1y8ZpMAcmWctUVOei5af5MVshaFrEV602Z2Ps7zfIZYIkm1mKeQtUKzOu9Cq0Pl+1+9SRu0lQs7zTap/ix8+VEWshY3R1STr+Y5iELIqMiVSa8usHJDQhvVDwBHBw6qpo+MvtnGyZX5aggA0OpivjyjGJ0ZnEenJ/Ug8sOaw4chgPMu/P0GBNgA/gkF2BVKny6Sbrxmy4eoUR1V05mbj6NGvWMskeTwwAnGg2/+qsmjfJWBshoabbkyGdOg0n2FPaWgffCeF3m1mA+asFrMM3cnTuOvOge/OTTbOAJsXDYPBfiZALce3uOx88Kx9vccTYoMfzJbHSquS35nj83+bRkL8HUxcp+ZBvcnJIxOD1kA3f/o+6V4la7zr8LPqDR2YYj+BXfvMnuT/js1AAAAAElFTkSuQmCC","height":18,"yoffset":0,"contentType":"image/png","angle":0,"xoffset":0,"width":18,"url":"15ced640-36e3-4934-9c6c-7f1d2485afba","type":"esriPMS"},"type":"simple"}}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "observtype", "type" : "esriFieldTypeString", "alias" : "Type of Observation", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BirdObservationType", "codedValues" : [ { "name" : "American Bittern", "code" : "American Bittern" }, { "name" : "Black-crowned Night-Heron", "code" : "Black-crowned Night-Heron" }, { "name" : "Little Blue Heron", "code" : "Little Blue Heron" }, { "name" : "Snowy Egret", "code" : "Snowy Egret" }, { "name" : "Yellow-crowned Night-Heron", "code" : "Yellow-crowned Night-Heron" }, { "name" : "Barn Owl", "code" : "Barn Owl" }, { "name" : "Eastern Screech-owl", "code" : "Eastern Screech-owl" }, { "name" : "Great Horned Owl", "code" : "Great Horned Owl" }, { "name" : "Snowy Owl", "code" : "Snowy Owl" }, { "name" : "Burrowing Owl", "code" : "Burrowing Owl" }, { "name" : "Bewick's Wren", "code" : "Bewick's Wren" }, { "name" : "Black Rail", "code" : "Black Rail" }, { "name" : "Common Moorhen", "code" : "Common Moorhen" }, { "name" : "Black Tern", "code" : "Black Tern" }, { "name" : "Common Tern", "code" : "Common Tern" }, { "name" : "Forster's Tern", "code" : "Forster's Tern" }, { "name" : "King Rail", "code" : "King Rail" }, { "name" : "Least Tern", "code" : "Least Tern" }, { "name" : "Loggerhead Shrike", "code" : "Loggerhead Shrike" }, { "name" : "Northern Harrier", "code" : "Northern Harrier" }, { "name" : "Osprey", "code" : "Osprey" }, { "name" : "Swainson's Hawk", "code" : "Swainson's Hawk" }, { "name" : "American Kestrel", "code" : "American Kestrel" }, { "name" : "Merlin", "code" : "Merlin" }, { "name" : "Peregrine Falcon", "code" : "Peregrine Falcon" }, { "name" : "Bald Eagle", "code" : "Bald Eagle" }, { "name" : "Piping Plover", "code" : "Piping Plover" }, { "name" : "Swainson's Warbler", "code" : "Swainson's Warbler" }, { "name" : "Upland Sandpiper", "code" : "Upland Sandpiper" }, { "name" : "Wilson's Phalarope", "code" : "Wilson's Phalarope" }, { "name" : "Yellow-headed Blackbird", "code" : "Yellow-headed Blackbird" }, { "name" : "Northern Cardinal", "code" : "Northern Cardinal" }, { "name" : "Tree Swallow", "code" : "Tree Swallow" }, { "name" : "Cliff Swallow", "code" : "Cliff Swallow" }, { "name" : "Purple Martin", "code" : "Purple Martin" }, { "name" : "Black-capped Chickadee", "code" : "Black-capped Chickadee" }, { "name" : "White-breasted Nuthatch", "code" : "White-breasted Nuthatch" }, { "name" : "Pileated Woodpecker", "code" : "Pileated Woodpecker" }, { "name" : "Downy Woodpecker", "code" : "Downy Woodpecker" }, { "name" : "American Avocet", "code" : "American Avocet" }, { "name" : "Sandhill Crane", "code" : "Sandhill Crane" }, { "name" : "Hooded Merganser", "code" : "Hooded Merganser" }, { "name" : "Canada Goose", "code" : "Canada Goose" }, { "name" : "Horned Grebe", "code" : "Horned Grebe" }, { "name" : "Common Loon", "code" : "Common Loon" }, { "name" : "Northern Bobwhite Quail", "code" : "Northern Bobwhite Quail" } ] }, "defaultValue" : "Barn Owl" }, { "name" : "details", "type" : "esriFieldTypeString", "alias" : "Details", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "numvotes", "type" : "esriFieldTypeInteger", "alias" : "Number of Votes", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "publicview", "type" : "esriFieldTypeString", "alias" : "Public View", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : "Yes" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "userid", "type" : "esriFieldTypeString", "alias" : "User Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone", "type" : "esriFieldTypeString", "alias" : "Phone", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "email", "type" : "esriFieldTypeString", "alias" : "Email", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ObservationStatus", "codedValues" : [ { "name" : "Submitted", "code" : "Submitted" }, { "name" : "Field Validated", "code" : "Field Validated" } ] }, "defaultValue" : "Submitted" }, { "name" : "breedcode", "type" : "esriFieldTypeString", "alias" : "Breeding Code", "sqlType" : "sqlTypeOther", "length" : 75, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BirdBreedingCode", "codedValues" : [ { "name" : "Confirmed Nest with Young", "code" : "NY Confirmed" }, { "name" : "Confirmed Nest with Eggs", "code" : "NE Confirmed" }, { "name" : "Confirmed Carrying Fecal Sac", "code" : "FS Confirmed" }, { "name" : "Confirmed Feeding Young", "code" : "FY Confirmed" }, { "name" : "Confirmed Carrying Food", "code" : "CF Confirmed" }, { "name" : "Confirmed Recently Fledged Young", "code" : "FL Confirmed" }, { "name" : "Confirmed Occupied Nest", "code" : "ON Confirmed" }, { "name" : "Confirmed Used Nest (if no birds seen enter 0)", "code" : "UN Confirmed" }, { "name" : "Confirmed Distraction Display", "code" : "DD Confirmed" }, { "name" : "Confirmed Nest Building", "code" : "NB Confirmed" }, { "name" : "Confirmed Carrying Nest Material", "code" : "CN Confirmed" }, { "name" : "Confirmed Physiological Evidence", "code" : "PE Confirmed" }, { "name" : "Woodpecker/Wren Nest Building", "code" : "B Probable" }, { "name" : "Agitated Behavior", "code" : "A Probable" }, { "name" : "Visiting Probable Nest Site", "code" : "N Probable" }, { "name" : "Courtship, Display or Copulation", "code" : "C Probable" }, { "name" : "Territorial Defense", "code" : "T Probable" }, { "name" : "Pair in Suitable Habitat", "code" : "P Probable" }, { "name" : "Multiple Singing Males (7+)", "code" : "M Probable" }, { "name" : "Singing Male Present 7+ days", "code" : "S7 Probable" }, { "name" : "Singing Male", "code" : "S Possible" }, { "name" : "In appropriate Habitat", "code" : "H Possible" }, { "name" : "Flyover", "code" : "Flyover" } ] }, "defaultValue" : "Flyover" }, { "name" : "agesex", "type" : "esriFieldTypeString", "alias" : "Age and Sex", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BirdAgeSexType", "codedValues" : [ { "name" : "Juvenile Female", "code" : "Juvenile Female" }, { "name" : "Juvenile Male", "code" : "Juvenile Male" }, { "name" : "Immature Female", "code" : "Immature Female" }, { "name" : "Immature Male", "code" : "Immature Male" }, { "name" : "Adult Female", "code" : "Adult Female" }, { "name" : "Adult Male", "code" : "Adult Male" }, { "name" : "Female Age Unknown", "code" : "Female Age Unknown" }, { "name" : "Male Age Unknown", "code" : "Male Age Unknown" }, { "name" : "Juvenile Sex Unknown", "code" : "Juvenile Sex Unknown" }, { "name" : "Immature Sex Unknown", "code" : "Immature Sex Unknown" }, { "name" : "Adult Sex Unknown", "code" : "Adult Sex Unknown" }, { "name" : "Age and Sex Unknown", "code" : "Age and Sex Unknown" } ] }, "defaultValue" : "Age and Sex Unknown" }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Data_Collection_Editor_CRUD_Demo_BIRD_OBSERVATION_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Data_Col__F4B70D85800E96EB", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Bird Observation", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "observid" : null, "email" : null, "agesex" : "Age and Sex Unknown", "userid" : null, "submitdt" : null, "status" : "Submitted", "phone" : null, "observtype" : "Barn Owl", "details" : null, "name" : null, "publicview" : "Yes", "breedcode" : "Flyover", "numvotes" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 1, "name" : "Mammal Observations", "type" : "Feature Layer", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1708974127054, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 2, "name" : "WildMammalObservationsComment", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -20037507.067161843, "ymin" : -11066907.697872387, "xmax" : 20037507.067161843, "ymax" : 30240971.958386149, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"transparency":0,"renderer":{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA11JREFUSIm1lj1oG2cYx3+nu8v5q1bhlEECN5tLQL3GVgpRTdeCjW6I47qmizNJQzrVdDEFSxA8GDKVDNLkUiguoi74RDKWtrgSNKcaVUtFh4KovFhQuakVWXe6DvqIbCnRpdBnvHvu/3uf//u8z3sS/3NILnJkXSM0JqEJELBayA5UJA+5dB7zPwOWrnNNUYh4BKLjMprHA6IAHgFaDjQsWJnjRBLZ33vCx0DTNWB1Ht12uD+poI3LIIuDOZMKtBx89XOiK3Msn1vcOfiVH0YClt/mQ0lkz6uAMsJAj9AGXZHw/XXG9x+9Q+yrn0m9ELA6jy6J7L0+0f7YbcgiqFNQfUpS1ygYBXIDgKXrXLMd7nuVVxMHCIZ1ilkDdQrsUwzg6gBAUYhMKmj9tixEonh9gaGi06ofrxrAq/qZmQ3x+IsEj3bjTCj4bt/g3rdHPOwHyJ1uAWBmNsTS3TjBcMR1FYvrW9ROKvxopDhrEIc+gK4RGpfRZLFd7tpGEq/qdy3ejbWNJADG1ymfrnHLKJCTAMakdp93k15VvFY9plwyqVUrFLMZJBFeU9CgAxAgIHY29rOVAJ9/57gWP8yk2HsQu/BMFOCZTQA6Flkt5P7OOcykWIhER4oXs5kBcWh3odVC7gEcqLQ6i166G3clXqseDxWH9iiRPFR6AMlDrmHB+3eiLK5v9VbXbcHDTIriTxkA3ngzxOL6Fl7Vz7Tqp1atDAAaFji0D5sEkM5jrs5z8sdvpg+gXDJJbuoEwzqx7QMWIlEe7yY6m2gQDEd6rZzc1C+IN21oWBS++aU9aXvHyoH9UtGMlksm02oArxqgmDUol0xmZkN8mnxCclOnXDJ5tJsgtn1AMBxhbSN5wap6EzzCkFGRzhNbmWP5y52Yb+49vVf6Tuxm70SfVo879hnsxG7y1rs6tZPnFjVtqJ9jpvN8MgAAaNjohSMz++fvJpe76nKUSybl0vP7pmnD389AgATwz1CAUSD3wTyx6lOS6pT7odcVP62zlili9L8bmPjpPCldo2CfYkwo+KZeMl2bdtvz+jmmAInL4kMB3UqAq7dvcO+sQfyKhE8SB6/MhkXBccjsH7FNny0jAd3ojNyHusatMQnNaiELEOhe+t1WfFm4+avoVpQbmTgk/gWkrURAOMzhtQAAAABJRU5ErkJggg==","height":18,"yoffset":0,"contentType":"image/png","angle":0,"xoffset":0,"width":18,"url":"b4c8a642-0415-485f-9004-5f3c66a7688e","type":"esriPMS"},"type":"simple"}}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "observtype", "type" : "esriFieldTypeString", "alias" : "Type of Observation", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "MammalObservationType", "codedValues" : [ { "name" : "Black Bear", "code" : "Black Bear" }, { "name" : "American Bison", "code" : "American Bison" }, { "name" : "Bobcat", "code" : "Bobcat" }, { "name" : "Coyote", "code" : "Coyote" }, { "name" : "Gray Fox", "code" : "Gray Fox" }, { "name" : "Red Fox", "code" : "Red Fox" }, { "name" : "Raccoon", "code" : "Raccoon" }, { "name" : "Striped Skunk", "code" : "Striped Skunk" }, { "name" : "Eastern Spotted Skunk", "code" : "Eastern Spotted Skunk" }, { "name" : "Northern River Otter", "code" : "Northern River Otter" }, { "name" : "American Marten", "code" : "American Marten" }, { "name" : "Fisher", "code" : "Fisher" }, { "name" : "Muskrat", "code" : "Muskrat" }, { "name" : "Nutria", "code" : "Nutria" }, { "name" : "American Beaver", "code" : "American Beaver" }, { "name" : "Porcupine", "code" : "Porcupine" }, { "name" : "Groundhog", "code" : "Groundhog" }, { "name" : "Eastern Chipmunk", "code" : "Eastern Chipmunk" }, { "name" : "Eastern Gray Squirrel", "code" : "Eastern Gray Squirrel" }, { "name" : "Southern Flying Squirrel", "code" : "Southern Flying Squirrel" }, { "name" : "Virginia Opossum", "code" : "Virginia Opossum" }, { "name" : "Eastern Cottontail", "code" : "Eastern Cottontail" }, { "name" : "Appalachian Cottontail", "code" : "Appalachian Cottontail" }, { "name" : "Sika Deer", "code" : "Sika Deer" }, { "name" : "White-tailed Deer", "code" : "White-tailed Deer" }, { "name" : "Feral horse", "code" : "Feral horse" } ] }, "defaultValue" : null }, { "name" : "details", "type" : "esriFieldTypeString", "alias" : "Details", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "numvotes", "type" : "esriFieldTypeInteger", "alias" : "Number of Votes", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "publicview", "type" : "esriFieldTypeString", "alias" : "Public View", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : "Yes" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "userid", "type" : "esriFieldTypeString", "alias" : "User Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone", "type" : "esriFieldTypeString", "alias" : "Phone", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "email", "type" : "esriFieldTypeString", "alias" : "Email", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ObservationStatus", "codedValues" : [ { "name" : "Submitted", "code" : "Submitted" }, { "name" : "Field Validated", "code" : "Field Validated" } ] }, "defaultValue" : "Submitted" }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Data_Col__F4B70D85E36723AD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Data_Collection_Editor_CRUD_Demo_MAMMAL_OBSERVATIONS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Mammal Observations", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "observid" : null, "observtype" : "Elk", "phone" : null, "userid" : null, "details" : null, "name" : null, "publicview" : "Yes", "submitdt" : null, "status" : "Submitted", "email" : null, "numvotes" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 2, "name" : "Reptile Observations", "type" : "Feature Layer", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1677698582190, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 3, "name" : "ReptileObservationComment", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -20037507.067161843, "ymin" : -11066907.697872387, "xmax" : 20037507.067161843, "ymax" : 30240971.958386149, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"transparency":0,"renderer":{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAx9JREFUSIm1ls9rG0cYhp9dzXr9Q7UCqxwsUHMTBMw2tlJIor8gRluI67pJL+lpdUhPDfTQS2wIJRR8zEE6JZdWoMSFrmjObVElaKQGVZfmatDJhsRNrUja1fawWnWblSyl0Pe4M/M+M9983zcr+J8lZpijGDrpeYEuQcIeoLjQFjK1UoP6fwZsnOecqpKVJcwFBV2WISKBLMHAha4NW2scigj7xad8BvRnBmyvYzgud5dU9AUFlEh4zpIKA5d4p4e5tcZmz+bD73/np6mAzff4WEQoxlRQpwRQljzQnCD+4oQfP3mf3De/UpgI2F7HEBGKZxa9xbNKiYAWhaNX5A2dptWkFgJsnOec43I3pr6defA0WhScYyzgbAigqmSXVPQ3wxLTEiRTaQBeHrU5eD45cWQJFlXi1y5w67tn3A8ClGG2jJRMpblxOz8yD+rJw11+eLAzFhJV4aTLDgQAhk56QUH3syWZSvNF/unEnV69eYeXh20q5X/uc/WyQUxboVIuMCeIGzqXrCY1ATAvvDz3deN2fqK5r4xhjgCZrMn1wJonjwq8o6LDECBBIjK82GDMT1MylSamJVjWVsgYJgCtaplKuUBEgtcOCRiGyB6g+Jkzi7kvf9fJVJr8lx/QqlqAd9n2AGUEcKE9cGHj0x2WtZWZAauXswBUyoWROXitRMi0RwAhU+va3oK3OYFvXtzL/etb1wYXr9gEQKlBfXudw3vmxbh+xWD1SpZM1uTgeZ1WtRwyvXrzDgBf5y6G6qLvQNem+fg3r9OOysqF/U4Ps1W1Rpf27V5ubGEtaytksibvptKh8U4fZGlMqyg1yG2tsTkniLd+sahYhYlVW9zLcfBHeKzvQKdHvdTg8xAAoOtgvDih+rNVmNqPgkXmm//5GiTYBf4aC7Ca1D5aJ3f0irwWnb3p+ebHHa6XW1jBsVDHLzUoGDpN5xhrUSUePaW79h0v5p0edQl23zQfC/BPApy9doFbJ1125gRxEQk/mV2bputS3n/GVwTCMhXga9hy7xs6l+YFuj1AkSDhP/p+Kp6mWf4q/BPVpk4co78BYx4ZgC5BNcUAAAAASUVORK5CYII=","height":18,"yoffset":0,"contentType":"image/png","angle":0,"xoffset":0,"width":18,"url":"ec1bf774-958f-4d10-96dd-e52d15fafc34","type":"esriPMS"},"type":"simple"}}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "observtype", "type" : "esriFieldTypeString", "alias" : "Type of Observation", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ReptileObservationType", "codedValues" : [ { "name" : "Eastern Snapping Turtle", "code" : "Eastern Snapping Turtle" }, { "name" : "Bog Turtle", "code" : "Bog Turtle" }, { "name" : "Spotted Turtle", "code" : "Spotted Turtle" }, { "name" : "Wood Turtle", "code" : "Wood Turtle" }, { "name" : "Eastern Box Turtle", "code" : "Eastern Box Turtle" }, { "name" : "Red-eared Slider", "code" : "Red-eared Slider" }, { "name" : "Eastern Painted Turtle", "code" : "Eastern Painted Turtle" }, { "name" : "Midland Painted Turtle", "code" : "Midland Painted Turtle" }, { "name" : "Eastern River Cooter", "code" : "Eastern River Cooter" }, { "name" : "Northern Red-bellied Cooter", "code" : "Northern Red-bellied Cooter" }, { "name" : "Northern Map Turtle", "code" : "Northern Map Turtle" }, { "name" : "Northern Diamond-backed Terrapin", "code" : "Northern Diamond-backed Terrapin" }, { "name" : "Eastern Spiny Softshell", "code" : "Eastern Spiny Softshell" }, { "name" : "Loggerhead Seaturtle", "code" : "Loggerhead Seaturtle" }, { "name" : "Green Seaturtle", "code" : "Green Seaturtle" }, { "name" : "Leatherback Seaturtle", "code" : "Leatherback Seaturtle" }, { "name" : "Atlantic Hawksbill Seaturtle", "code" : "Atlantic Hawksbill Seaturtle" }, { "name" : "Timber Rattlesnake", "code" : "Timber Rattlesnake" }, { "name" : "Queen Snake", "code" : "Queen Snake" }, { "name" : "Mountain Earthsnake", "code" : "Mountain Earthsnake" }, { "name" : "Northern Red-bellied Snake", "code" : "Northern Red-bellied Snake" }, { "name" : "Eastern Gartersnake", "code" : "Eastern Gartersnake" }, { "name" : "Common Ribbon Snake", "code" : "Common Ribbon Snake" }, { "name" : "Eastern Hog-nosed Snake", "code" : "Eastern Hog-nosed Snake" }, { "name" : "Rainbow Snake", "code" : "Rainbow Snake" }, { "name" : "Northern Black Racer", "code" : "Northern Black Racer" }, { "name" : "Red Cornsnake", "code" : "Red Cornsnake" }, { "name" : "Eastern Kingsnake", "code" : "Eastern Kingsnake" }, { "name" : "Milksnake", "code" : "Milksnake" }, { "name" : "Common Five-lined Skink", "code" : "Common Five-lined Skink" }, { "name" : "Northern Coal Skink", "code" : "Northern Coal Skink" }, { "name" : "Eastern Six-lined Racerunner", "code" : "Eastern Six-lined Racerunner" }, { "name" : "Eastern Fence Lizard", "code" : "Eastern Fence Lizard" } ] }, "defaultValue" : null }, { "name" : "details", "type" : "esriFieldTypeString", "alias" : "Details", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "numvotes", "type" : "esriFieldTypeInteger", "alias" : "Number of Votes", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "publicview", "type" : "esriFieldTypeString", "alias" : "Public View", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : "Yes" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "userid", "type" : "esriFieldTypeString", "alias" : "User Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone", "type" : "esriFieldTypeString", "alias" : "Phone", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "email", "type" : "esriFieldTypeString", "alias" : "Email", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ObservationStatus", "codedValues" : [ { "name" : "Submitted", "code" : "Submitted" }, { "name" : "Field Validated", "code" : "Field Validated" } ] }, "defaultValue" : "Submitted" }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Data_Col__F4B70D85D14EB326", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Data_Collection_Editor_CRUD_Demo_REPTILE_OBSERVATIONS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Reptile Observations", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "observid" : null, "observtype" : "Northern Tree Lizard", "phone" : null, "userid" : null, "details" : null, "name" : null, "publicview" : "Yes", "submitdt" : null, "status" : "Submitted", "email" : null, "numvotes" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" } ], "tables" : [ { "currentVersion" : 12, "id" : 3, "name" : "BirdObservationComment", "type" : "Table", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1677698582190, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 1, "name" : "BirdObservation", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "reportid", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "reportid", "type" : "esriFieldTypeGUID", "alias" : "Report ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Data_Col__F4B70D850297E2B3", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "G17reportid", "fields" : "reportid", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "BirdObservationComment", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "observid" : null, "comments" : null, "reportid" : null, "submitdt" : null, "name" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 4, "name" : "ReptileObservationComment", "type" : "Table", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1677698582190, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 3, "name" : "ReptileObservations", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "reportid", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "reportid", "type" : "esriFieldTypeGUID", "alias" : "Report ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Data_Col__F4B70D854A123057", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "G21reportid", "fields" : "reportid", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "ReptileObservationComment", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "observid" : null, "comments" : null, "reportid" : null, "submitdt" : null, "name" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" }, { "currentVersion" : 12, "id" : 5, "name" : "WildMammalObservationsComment", "type" : "Table", "serviceItemId" : "a19d22553e344dd3995c322d2aca7775", "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1712634298731, "schemaLastEditDate" : 1677698582190, "dataLastEditDate" : 1712634298731 }, "relationships" : [ { "id" : 2, "name" : "WildMammalObservations", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "reportid", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "observid", "type" : "esriFieldTypeString", "alias" : "Observation Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "submitdt", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "reportid", "type" : "esriFieldTypeGUID", "alias" : "Report ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Data_Col__F4B70D851B3C8811", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "G11reportid", "fields" : "reportid", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "WildMammalObservationsComment", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "observid" : null, "comments" : null, "reportid" : null, "submitdt" : null, "name" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync" } ] }