{ "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.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InstitutionName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "length": 38, "domain": null }, { "name": "FeatureID", "type": "esriFieldTypeGUID", "alias": "Feature ID", "length": 38, "domain": null }, { "name": "InstitutionName", "type": "esriFieldTypeString", "alias": "Institution Name", "length": 100, "domain": null }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street Address", "length": 100, "domain": null }, { "name": "StateOrProvince", "type": "esriFieldTypeString", "alias": "State or Province", "length": 2, "domain": null }, { "name": "PostalCode", "type": "esriFieldTypeString", "alias": "Postal Code", "length": 10, "domain": null }, { "name": "WebsiteURL", "type": "esriFieldTypeString", "alias": "Website URL", "length": 100, "domain": null }, { "name": "DirectorName", "type": "esriFieldTypeString", "alias": "Director Name", "length": 50, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Elevation", "type": "esriFieldTypeDouble", "alias": "Elevation (m)", "domain": null }, { "name": "AverageRainfall", "type": "esriFieldTypeDouble", "alias": "Rainfall (cm)", "domain": null }, { "name": "AverageSnowfall", "type": "esriFieldTypeDouble", "alias": "Snowfall (cm)", "domain": null }, { "name": "AverageLowTemperature", "type": "esriFieldTypeDouble", "alias": "Average Low Temperature (C)", "domain": null }, { "name": "AverageHighTemperature", "type": "esriFieldTypeDouble", "alias": "Average High Temperature (C)", "domain": null }, { "name": "HistoricLowTemperature", "type": "esriFieldTypeDouble", "alias": "Historic Low Temperature (C)", "domain": null }, { "name": "HistoricHighTemperature", "type": "esriFieldTypeDouble", "alias": "Historic High Temperature (C)", "domain": null }, { "name": "GrowingSeasonLength", "type": "esriFieldTypeSmallInteger", "alias": "Growing Season Length (days)", "domain": null }, { "name": "USDAZone", "type": "esriFieldTypeString", "alias": "USDA Zone", "length": 20, "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" } }, { "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" } }, { "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" } }, { "name": "NumberOfPlantTaxa", "type": "esriFieldTypeSmallInteger", "alias": "Number of Plant Taxa", "domain": null }, { "name": "NumberOfPlants", "type": "esriFieldTypeInteger", "alias": "Number of Plants", "domain": null }, { "name": "NumberOfAnimalTaxa", "type": "esriFieldTypeSmallInteger", "alias": "Number of Animal Taxa", "domain": null }, { "name": "NumberOfAnimals", "type": "esriFieldTypeInteger", "alias": "Number of Animals", "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "Creation Date", "length": 8, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Edit Date", "length": 8, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "Country", "type": "esriFieldTypeString", "alias": "Country", "length": 50, "domain": null }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "length": 20, "domain": null }, { "name": "Fax", "type": "esriFieldTypeString", "alias": "Fax", "length": 20, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 50, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1024, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Area of Interest", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FeatureID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{98CFCA88-73F1-4C0C-98D0-743A906E4308}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "4239c3ceec1e4cf2bcf5480252f8eb9e" }