{
"currentVersion": 11.5,
"cimVersion": "3.5.0",
"id": 1,
"name": "SignUp",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "Created",
"editDateField": "Updated",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"timeZoneIANA": "Etc/UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 0,
"name": "BBA2.DBO.BlocksWeb",
"relatedTableId": 0,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "BlockNameLng",
"composite": false,
"catalogID": "{88CFBE99-53C9-4C80-BAC7-F2E9905F97F3}"
}
],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"hasContingentValuesDefinition": false,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsFullTextSearch": true,
"fullTextSearchCapabilities": {
"supportsSearchOperator": true,
"supportsOperator": false,
"supportsSqlExpressionInFullText": true
},
"fullTextSearchableFields": [],
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsReturningGeometryEnvelope": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true,
"supportsQueryWithCacheHint": false
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": true,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON,PBF"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "BlockNameLng",
"typeIdField": "Assigned",
"subtypeField": "Assigned",
"defaultSubtypeCode": 0,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "BlockNameLng",
"type": "esriFieldTypeString",
"alias": "BlockNameLng",
"domain": null,
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "BlockNameLng"
},
{
"name": "UserFirstName",
"type": "esriFieldTypeString",
"alias": "UserFirstName",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "UserFirstName"
},
{
"name": "UserLastName",
"type": "esriFieldTypeString",
"alias": "UserLastName",
"domain": null,
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "UserLastName"
},
{
"name": "UserEmail",
"type": "esriFieldTypeString",
"alias": "UserEmail",
"domain": null,
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "UserEmail"
},
{
"name": "MentorProgram",
"type": "esriFieldTypeSmallInteger",
"alias": "MentorProgram",
"domain": {
"type": "codedValue",
"name": "MentorInterest",
"description": "None, Mentor, Mentee",
"codedValues": [
{
"name": "None",
"code": 0
},
{
"name": "Mentor - Will Mentor",
"code": 1
},
{
"name": "Mentor - Small Group Leader",
"code": 2
},
{
"name": "Mentee",
"code": 3
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": 0,
"modelName": "MentorProgram"
},
{
"name": "Created",
"type": "esriFieldTypeDate",
"alias": "CreatedDate",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "Created"
},
{
"name": "Updated",
"type": "esriFieldTypeDate",
"alias": "Updated",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "Updated"
},
{
"name": "Assigned",
"type": "esriFieldTypeSmallInteger",
"alias": "Assigned",
"domain": {
"type": "codedValue",
"name": "Approval",
"description": "Approved, Denied, Unassigned",
"codedValues": [
{
"name": "Unassigned",
"code": 0
},
{
"name": "Primary",
"code": 1
},
{
"name": "Alternate",
"code": 2
},
{
"name": "Denied",
"code": 3
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"defaultValue": 0,
"modelName": "Assigned"
},
{
"name": "UserComments",
"type": "esriFieldTypeString",
"alias": "UserComments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500,
"defaultValue": null,
"modelName": "UserComments"
},
{
"name": "Phone",
"type": "esriFieldTypeString",
"alias": "Phone",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "Phone"
},
{
"name": "ZipCode",
"type": "esriFieldTypeString",
"alias": "ZipCode",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "ZipCode"
},
{
"name": "User_Experience",
"type": "esriFieldTypeSmallInteger",
"alias": "User_Experience",
"domain": {
"type": "codedValue",
"name": "Birding Experience",
"description": "Novice, Basic, Intermediate, Advanced",
"codedValues": [
{
"name": "Novice",
"code": 0
},
{
"name": "Basic",
"code": 1
},
{
"name": "Intermediate",
"code": 2
},
{
"name": "Advanced",
"code": 3
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "User_Experience"
},
{
"name": "userEbird",
"type": "esriFieldTypeString",
"alias": "userEbird",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "userEbird"
}
],
"indexes": [
{
"name": "R9_SDE_ROWID_UK",
"isAscending": true,
"isUnique": true,
"description": "",
"fields": "OBJECTID"
},
{
"name": "GDB_5_BlockNameL",
"isAscending": true,
"isUnique": false,
"description": "",
"fields": "BlockNameLng"
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"timeZoneIANA": "America/New_York",
"respectsDaylightSaving": true
},
"preferredTimeReference": {
"timeZone": "Eastern Standard Time",
"timeZoneIANA": "America/New_York",
"respectsDaylightSaving": true
},
"types": [
{
"id": 0,
"name": "Unassigned",
"domains": {
"MentorProgram": {"type": "inherited"}
},
"templates": [
{
"name": "Unassigned",
"description": "",
"prototype": {
"attributes": {
"User_Experience": null,
"userEbird": null,
"BlockNameLng": " ",
"UserFirstName": null,
"UserLastName": " ",
"UserEmail": " ",
"MentorProgram": 0,
"ZipCode": null,
"Phone": null,
"Assigned": 0,
"UserComments": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
]
},
{
"id": 1,
"name": "Assigned",
"domains": {
"MentorProgram": {"type": "inherited"}
},
"templates": [
{
"name": "Assigned",
"description": "",
"prototype": {
"attributes": {
"User_Experience": null,
"userEbird": null,
"BlockNameLng": " ",
"UserFirstName": null,
"UserLastName": " ",
"UserEmail": " ",
"MentorProgram": 0,
"ZipCode": null,
"Phone": null,
"Assigned": 1,
"UserComments": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
]
},
{
"id": 2,
"name": "Alternate",
"domains": {
"MentorProgram": {"type": "inherited"}
},
"templates": [
{
"name": "Alternate",
"description": "",
"prototype": {
"attributes": {
"User_Experience": null,
"userEbird": null,
"BlockNameLng": " ",
"UserFirstName": null,
"UserLastName": " ",
"UserEmail": " ",
"MentorProgram": 0,
"ZipCode": null,
"Phone": null,
"Assigned": 2,
"UserComments": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
]
},
{
"id": 3,
"name": "Denied",
"domains": {
"MentorProgram": {"type": "inherited"}
},
"templates": [
{
"name": "Denied",
"description": "",
"prototype": {
"attributes": {
"User_Experience": null,
"userEbird": null,
"BlockNameLng": " ",
"UserFirstName": null,
"UserLastName": " ",
"UserEmail": " ",
"MentorProgram": 0,
"ZipCode": null,
"Phone": null,
"Assigned": 3,
"UserComments": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
]
}
],
"templates": [],
"subtypes": [
{
"code": 0,
"name": "Unassigned",
"defaultValues": {
"BlockNameLng": null,
"UserFirstName": null,
"UserLastName": null,
"UserEmail": null,
"MentorProgram": 0,
"Created": null,
"Updated": null,
"Assigned": 0,
"UserComments": null,
"Phone": null,
"ZipCode": null,
"User_Experience": null,
"userEbird": null
},
"domains": {
"MentorProgram": {"type": "inherited"}
}
},
{
"code": 1,
"name": "Assigned",
"defaultValues": {
"BlockNameLng": null,
"UserFirstName": null,
"UserLastName": null,
"UserEmail": null,
"MentorProgram": 0,
"Created": null,
"Updated": null,
"Assigned": 1,
"UserComments": null,
"Phone": null,
"ZipCode": null,
"User_Experience": null,
"userEbird": null
},
"domains": {
"MentorProgram": {"type": "inherited"}
}
},
{
"code": 2,
"name": "Alternate",
"defaultValues": {
"BlockNameLng": null,
"UserFirstName": null,
"UserLastName": null,
"UserEmail": null,
"MentorProgram": 0,
"Created": null,
"Updated": null,
"Assigned": 2,
"UserComments": null,
"Phone": null,
"ZipCode": null,
"User_Experience": null,
"userEbird": null
},
"domains": {
"MentorProgram": {"type": "inherited"}
}
},
{
"code": 3,
"name": "Denied",
"defaultValues": {
"BlockNameLng": null,
"UserFirstName": null,
"UserLastName": null,
"UserEmail": null,
"MentorProgram": 0,
"Created": null,
"Updated": null,
"Assigned": 3,
"UserComments": null,
"Phone": null,
"ZipCode": null,
"User_Experience": null,
"userEbird": null
},
"domains": {
"MentorProgram": {"type": "inherited"}
}
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"supportsAppend": true,
"supportedAppendFormats": "FILEGDB,PBF",
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 2000,
"maxRecordCountFactor": 1
}