{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Events", "type": "Table", "description": "Events", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Areas_Flat", "relatedTableId": 1, "cardinality": "esriRelCardinalityManyToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{96ACD867-5080-41E2-8C67-C6BF4E3B6A02}", "relationshipTableId": 3, "keyFieldInRelationshipTable": "event_oid" }, { "id": 0, "name": "Areas", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{42F304D9-8A21-4D31-A03B-8FE73B39C2BE}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "layer_title", "typeIdField": "category", "subtypeField": "category", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "category", "type": "esriFieldTypeSmallInteger", "alias": "category", "domain": { "type": "codedValue", "name": "TrackingEventCategory", "description": "", "codedValues": [ { "name": "Goal 1", "code": 1 }, { "name": "Goal 2", "code": 2 }, { "name": "Goal 3", "code": 3 }, { "name": "Goal 4", "code": 4 }, { "name": "Goal 5", "code": 5 }, { "name": "Goal 6", "code": 6 }, { "name": "Goal 7", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "category" }, { "name": "code", "type": "esriFieldTypeSmallInteger", "alias": "code", "domain": { "type": "codedValue", "name": "TrackingCode", "description": "", "codedValues": [ { "name": "Habitat Assessment", "code": 101 }, { "name": "Ongoing Management", "code": 102 }, { "name": "Wildlife Observations", "code": 103 }, { "name": "Floristic Quality", "code": 104 }, { "name": "Habitat connectivity", "code": 105 }, { "name": "Sustainable Practices", "code": 201 }, { "name": "Regenerative Program", "code": 202 }, { "name": "Onsite Habitat", "code": 203 }, { "name": "Farmland Protection", "code": 204 }, { "name": "Ag Conservation Plan", "code": 205 }, { "name": "Habitat Areas", "code": 301 }, { "name": "Stormwater Management", "code": 302 }, { "name": "Conservation Planning", "code": 303 }, { "name": "Municipal Conservation Program", "code": 304 }, { "name": "Conservation Policies and Practices", "code": 305 }, { "name": "Acquired Land", "code": 401 }, { "name": "High-level Protection", "code": 402 }, { "name": "Conservation Ordinance", "code": 403 }, { "name": "Access to Nature", "code": 501 }, { "name": "Community Engagement", "code": 502 }, { "name": "Environmental Education", "code": 503 }, { "name": "Tree Canopy", "code": 504 }, { "name": "Onsite Renewable Energy", "code": 601 }, { "name": "Greenhouse Gas Reduction", "code": 602 }, { "name": "LEED Certified", "code": 603 }, { "name": "Carbon Neutral", "code": 604 }, { "name": "Clean Water Projects", "code": 701 }, { "name": "Biotic Integrity", "code": 702 }, { "name": "Watershed Plan", "code": 703 }, { "name": "Healthy Watershed", "code": 704 }, { "name": "Connectivity", "code": 705 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "code" }, { "name": "event_year", "type": "esriFieldTypeSmallInteger", "alias": "event_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "event_year" }, { "name": "submitter", "type": "esriFieldTypeString", "alias": "submitter", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "submitter" }, { "name": "org", "type": "esriFieldTypeString", "alias": "org", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "org" }, { "name": "layer_title", "type": "esriFieldTypeString", "alias": "layer_title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "layer_title" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "description" }, { "name": "import_guid", "type": "esriFieldTypeGUID", "alias": "import_guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "import_guid" }, { "name": "import_oid", "type": "esriFieldTypeInteger", "alias": "import_oid", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "import_oid" } ], "indexes": [ { "name": "R404_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": 1, "name": "Goal 1", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_1", "description": "", "codedValues": [ { "name": "Habitat Assessment", "code": 101 }, { "name": "Ongoing Management", "code": 102 }, { "name": "Wildlife Observations", "code": 103 }, { "name": "Floristic Quality", "code": 104 }, { "name": "Habitat connectivity", "code": 105 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 1", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 1, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 3, "name": "Goal 3", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_3", "description": "", "codedValues": [ { "name": "Habitat Areas", "code": 301 }, { "name": "Stormwater Management", "code": 302 }, { "name": "Conservation Planning", "code": 303 }, { "name": "Municipal Conservation Program", "code": 304 }, { "name": "Conservation Policies and Practices", "code": 305 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 3", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 3, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 4, "name": "Goal 4", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_4", "description": "", "codedValues": [ { "name": "Acquired Land", "code": 401 }, { "name": "High-level Protection", "code": 402 }, { "name": "Conservation Ordinance", "code": 403 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 4", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 4, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 5, "name": "Goal 5", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_5", "description": "", "codedValues": [ { "name": "Access to Nature", "code": 501 }, { "name": "Community Engagement", "code": 502 }, { "name": "Environmental Education", "code": 503 }, { "name": "Tree Canopy", "code": 504 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 5", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 5, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 7, "name": "Goal 7", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_7", "description": "", "codedValues": [ { "name": "Clean Water Projects", "code": 701 }, { "name": "Biotic Integrity", "code": 702 }, { "name": "Watershed Plan", "code": 703 }, { "name": "Healthy Watershed", "code": 704 }, { "name": "Connectivity", "code": 705 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 7", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 7, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 2, "name": "Goal 2", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_2", "description": "", "codedValues": [ { "name": "Sustainable Practices", "code": 201 }, { "name": "Regenerative Program", "code": 202 }, { "name": "Onsite Habitat", "code": 203 }, { "name": "Farmland Protection", "code": 204 }, { "name": "Ag Conservation Plan", "code": 205 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 2", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 2, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 6, "name": "Goal 6", "domains": { "code": { "type": "codedValue", "name": "TrackingCode_6", "description": "", "codedValues": [ { "name": "Onsite Renewable Energy", "code": 601 }, { "name": "Greenhouse Gas Reduction", "code": 602 }, { "name": "LEED Certified", "code": 603 }, { "name": "Carbon Neutral", "code": 604 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Goal 6", "description": "", "prototype": { "attributes": { "import_guid": null, "import_oid": null, "category": 6, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null } }, "drawingTool": "esriFeatureEditToolNone" } ] } ], "templates": [], "subtypes": [ { "code": 1, "name": "Goal 1", "defaultValues": { "category": 1, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_1", "description": "", "codedValues": [ { "name": "Habitat Assessment", "code": 101 }, { "name": "Ongoing Management", "code": 102 }, { "name": "Wildlife Observations", "code": 103 }, { "name": "Floristic Quality", "code": 104 }, { "name": "Habitat connectivity", "code": 105 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 3, "name": "Goal 3", "defaultValues": { "category": 3, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_3", "description": "", "codedValues": [ { "name": "Habitat Areas", "code": 301 }, { "name": "Stormwater Management", "code": 302 }, { "name": "Conservation Planning", "code": 303 }, { "name": "Municipal Conservation Program", "code": 304 }, { "name": "Conservation Policies and Practices", "code": 305 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 4, "name": "Goal 4", "defaultValues": { "category": 4, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_4", "description": "", "codedValues": [ { "name": "Acquired Land", "code": 401 }, { "name": "High-level Protection", "code": 402 }, { "name": "Conservation Ordinance", "code": 403 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 5, "name": "Goal 5", "defaultValues": { "category": 5, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_5", "description": "", "codedValues": [ { "name": "Access to Nature", "code": 501 }, { "name": "Community Engagement", "code": 502 }, { "name": "Environmental Education", "code": 503 }, { "name": "Tree Canopy", "code": 504 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 7, "name": "Goal 7", "defaultValues": { "category": 7, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_7", "description": "", "codedValues": [ { "name": "Clean Water Projects", "code": 701 }, { "name": "Biotic Integrity", "code": 702 }, { "name": "Watershed Plan", "code": 703 }, { "name": "Healthy Watershed", "code": 704 }, { "name": "Connectivity", "code": 705 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 2, "name": "Goal 2", "defaultValues": { "category": 2, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_2", "description": "", "codedValues": [ { "name": "Sustainable Practices", "code": 201 }, { "name": "Regenerative Program", "code": 202 }, { "name": "Onsite Habitat", "code": 203 }, { "name": "Farmland Protection", "code": 204 }, { "name": "Ag Conservation Plan", "code": 205 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 6, "name": "Goal 6", "defaultValues": { "category": 6, "code": null, "event_year": null, "submitter": null, "org": null, "layer_title": null, "description": null, "import_guid": null, "import_oid": null }, "domains": { "code": { "type": "codedValue", "name": "TrackingCode_6", "description": "", "codedValues": [ { "name": "Onsite Renewable Energy", "code": 601 }, { "name": "Greenhouse Gas Reduction", "code": 602 }, { "name": "LEED Certified", "code": 603 }, { "name": "Carbon Neutral", "code": 604 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }