{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Institution", "type": "Table", "description": "The Institution table is used to store information about the institutions of interest for use in data sharing efforts.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Area of Interest", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FeatureID", "composite": false, "catalogID": "{98CFCA88-73F1-4C0C-98D0-743A906E4308}" } ], "isDataVersioned": true, "isDataArchived": false, "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "InstitutionName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FeatureID", "type": "esriFieldTypeGUID", "alias": "Feature ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "FeatureID" }, { "name": "InstitutionName", "type": "esriFieldTypeString", "alias": "Institution Name", "domain": null, "editable": true, "nullable": false, "length": 100, "defaultValue": null, "modelName": "InstitutionName" }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street Address", "domain": null, "editable": true, "nullable": false, "length": 100, "defaultValue": null, "modelName": "StreetAddress" }, { "name": "StateOrProvince", "type": "esriFieldTypeString", "alias": "State or Province", "domain": null, "editable": true, "nullable": false, "length": 2, "defaultValue": null, "modelName": "StateOrProvince" }, { "name": "PostalCode", "type": "esriFieldTypeString", "alias": "Postal Code", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "PostalCode" }, { "name": "WebsiteURL", "type": "esriFieldTypeString", "alias": "Website URL", "domain": null, "editable": true, "nullable": false, "length": 100, "defaultValue": null, "modelName": "WebsiteURL" }, { "name": "DirectorName", "type": "esriFieldTypeString", "alias": "Director Name", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "DirectorName" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Longitude" }, { "name": "Elevation", "type": "esriFieldTypeDouble", "alias": "Elevation (m)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Elevation" }, { "name": "AverageRainfall", "type": "esriFieldTypeDouble", "alias": "Rainfall (cm)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AverageRainfall" }, { "name": "AverageSnowfall", "type": "esriFieldTypeDouble", "alias": "Snowfall (cm)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AverageSnowfall" }, { "name": "AverageLowTemperature", "type": "esriFieldTypeDouble", "alias": "Average Low Temperature (C)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AverageLowTemperature" }, { "name": "AverageHighTemperature", "type": "esriFieldTypeDouble", "alias": "Average High Temperature (C)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AverageHighTemperature" }, { "name": "HistoricLowTemperature", "type": "esriFieldTypeDouble", "alias": "Historic Low Temperature (C)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "HistoricLowTemperature" }, { "name": "HistoricHighTemperature", "type": "esriFieldTypeDouble", "alias": "Historic High Temperature (C)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "HistoricHighTemperature" }, { "name": "GrowingSeasonLength", "type": "esriFieldTypeSmallInteger", "alias": "Growing Season Length (days)", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "GrowingSeasonLength" }, { "name": "USDAZone", "type": "esriFieldTypeString", "alias": "USDA Zone", "domain": { "type": "codedValue", "name": "USDAZone", "description": "Valid values for Institution:USDAZone.", "codedValues": [ { "name": "1 (Below -50 F)", "code": "1 (Below -50 F)" }, { "name": "2a (-50 to -45 F)", "code": "2a (-50 to -45 F)" }, { "name": "2b (-45 to -40 F)", "code": "2b (-45 to -40 F)" }, { "name": "3a (-40 to -35 F)", "code": "3a (-40 to -35 F)" }, { "name": "3b (-35 to -30 F)", "code": "3b (-35 to -30 F)" }, { "name": "4a (-30 to -25 F)", "code": "4a (-30 to -25 F)" }, { "name": "4b (-25 to -20 F)", "code": "4b (-25 to -20 F)" }, { "name": "5a (-20 to -15 F)", "code": "5a (-20 to -15 F)" }, { "name": "5b (-15 to -10 F)", "code": "5b (-15 to -10 F)" }, { "name": "6a (-10 to -5 F)", "code": "6a (-10 to -5 F)" }, { "name": "6b (-5 to 0 F)", "code": "6b (-5 to 0 F)" }, { "name": "7a (0 to 5 F)", "code": "7a (0 to 5 F)" }, { "name": "7b (5 to 10 F)", "code": "7b (5 to 10 F)" }, { "name": "8a (10 to 15 F)", "code": "8a (10 to 15 F)" }, { "name": "8b (15 to 20 F)", "code": "8b (15 to 20 F)" }, { "name": "9a (20 to 25 F)", "code": "9a (20 to 25 F)" }, { "name": "9b (25 to 30 F)", "code": "9b (25 to 30 F)" }, { "name": "10a (30 to 35 F)", "code": "10a (30 to 35 F)" }, { "name": "10b (35 to 40 F)", "code": "10b (35 to 40 F)" }, { "name": "11 (above 40 F)", "code": "11 (above 40 F)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "USDAZone" }, { "name": "SunsetCode", "type": "esriFieldTypeSmallInteger", "alias": "Sunset Code", "domain": { "type": "range", "name": "SunsetCode", "description": "Valid values for Institution:SunsetCode.", "range": [ 1, 24 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "SunsetCode" }, { "name": "AHSHeatCode", "type": "esriFieldTypeSmallInteger", "alias": "AHS Heat Code", "domain": { "type": "range", "name": "AHSHeatCode", "description": "Valid values for Institution:AHSHeatCode.", "range": [ 1, 12 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AHSHeatCode" }, { "name": "NumberOfPlantTaxa", "type": "esriFieldTypeSmallInteger", "alias": "Number of Plant Taxa", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NumberOfPlantTaxa" }, { "name": "NumberOfPlants", "type": "esriFieldTypeInteger", "alias": "Number of Plants", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NumberOfPlants" }, { "name": "NumberOfAnimalTaxa", "type": "esriFieldTypeSmallInteger", "alias": "Number of Animal Taxa", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NumberOfAnimalTaxa" }, { "name": "NumberOfAnimals", "type": "esriFieldTypeInteger", "alias": "Number of Animals", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NumberOfAnimals" }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "Creation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Edit Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "City" }, { "name": "Country", "type": "esriFieldTypeString", "alias": "Country", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "Country" }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "Telephone" }, { "name": "Fax", "type": "esriFieldTypeString", "alias": "Fax", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "Fax" }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Creator" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Editor" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": false, "length": 1024, "defaultValue": null, "modelName": "Comments" } ], "indexes": [ { "name": "R86_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_86", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_281_FeatureI", "fields": "FeatureID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_86", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Institution", "description": "", "prototype": { "attributes": { "Editor": null, "Creator": null, "Comments": " ", "FeatureID": null, "InstitutionName": " ", "StreetAddress": " ", "StateOrProvince": " ", "PostalCode": " ", "WebsiteURL": " ", "DirectorName": " ", "Latitude": 0, "Longitude": 0, "Elevation": 0, "AverageRainfall": 0, "AverageSnowfall": 0, "AverageLowTemperature": 0, "AverageHighTemperature": 0, "HistoricLowTemperature": 0, "HistoricHighTemperature": 0, "GrowingSeasonLength": 0, "USDAZone": " ", "SunsetCode": 0, "AHSHeatCode": 0, "NumberOfPlantTaxa": 0, "NumberOfPlants": 0, "NumberOfAnimalTaxa": 0, "NumberOfAnimals": 0, "CreationDate": null, "EditDate": null, "City": " ", "Country": " ", "Telephone": " ", "Fax": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "77e79bd5f46645b8ae840e8f37827b0c" }