Name: Institution

Display Field: InstitutionName

Type: Table

Geometry Type: N/A

Description: The Institution table is used to store information about the institutions of interest for use in data sharing efforts.

Service Item Id: 77e79bd5f46645b8ae840e8f37827b0c

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FeatureID ( type: esriFieldTypeGUID, alias: Feature ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: FeatureID )
• InstitutionName ( type: esriFieldTypeString, alias: Institution Name, editable: true, nullable: false, length: 100, defaultValue: null, modelName: InstitutionName )
• StreetAddress ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: false, length: 100, defaultValue: null, modelName: StreetAddress )
• StateOrProvince ( type: esriFieldTypeString, alias: State or Province, editable: true, nullable: false, length: 2, defaultValue: null, modelName: StateOrProvince )
• PostalCode ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: false, length: 10, defaultValue: null, modelName: PostalCode )
• WebsiteURL ( type: esriFieldTypeString, alias: Website URL, editable: true, nullable: false, length: 100, defaultValue: null, modelName: WebsiteURL )
• DirectorName ( type: esriFieldTypeString, alias: Director Name, editable: true, nullable: false, length: 50, defaultValue: null, modelName: DirectorName )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: false, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: false, defaultValue: null, modelName: Longitude )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation (m), editable: true, nullable: false, defaultValue: null, modelName: Elevation )
• AverageRainfall ( type: esriFieldTypeDouble, alias: Rainfall (cm), editable: true, nullable: false, defaultValue: null, modelName: AverageRainfall )
• AverageSnowfall ( type: esriFieldTypeDouble, alias: Snowfall (cm), editable: true, nullable: false, defaultValue: null, modelName: AverageSnowfall )
• AverageLowTemperature ( type: esriFieldTypeDouble, alias: Average Low Temperature (C), editable: true, nullable: false, defaultValue: null, modelName: AverageLowTemperature )
• AverageHighTemperature ( type: esriFieldTypeDouble, alias: Average High Temperature (C), editable: true, nullable: false, defaultValue: null, modelName: AverageHighTemperature )
• HistoricLowTemperature ( type: esriFieldTypeDouble, alias: Historic Low Temperature (C), editable: true, nullable: false, defaultValue: null, modelName: HistoricLowTemperature )
• HistoricHighTemperature ( type: esriFieldTypeDouble, alias: Historic High Temperature (C), editable: true, nullable: false, defaultValue: null, modelName: HistoricHighTemperature )
• GrowingSeasonLength ( type: esriFieldTypeSmallInteger, alias: Growing Season Length (days), editable: true, nullable: false, defaultValue: null, modelName: GrowingSeasonLength )
• USDAZone ( type: esriFieldTypeString, alias: USDA Zone, editable: true, nullable: false, length: 20, defaultValue: null, modelName: USDAZone , Coded Values: [1 (Below -50 F): 1 (Below -50 F)] , [2a (-50 to -45 F): 2a (-50 to -45 F)] , [2b (-45 to -40 F): 2b (-45 to -40 F)] , ...17 more... )
• SunsetCode ( type: esriFieldTypeSmallInteger, alias: Sunset Code, editable: true, nullable: false, defaultValue: null, modelName: SunsetCode , Range: [1, 24] )
• AHSHeatCode ( type: esriFieldTypeSmallInteger, alias: AHS Heat Code, editable: true, nullable: false, defaultValue: null, modelName: AHSHeatCode , Range: [1, 12] )
• NumberOfPlantTaxa ( type: esriFieldTypeSmallInteger, alias: Number of Plant Taxa, editable: true, nullable: false, defaultValue: null, modelName: NumberOfPlantTaxa )
• NumberOfPlants ( type: esriFieldTypeInteger, alias: Number of Plants, editable: true, nullable: false, defaultValue: null, modelName: NumberOfPlants )
• NumberOfAnimalTaxa ( type: esriFieldTypeSmallInteger, alias: Number of Animal Taxa, editable: true, nullable: false, defaultValue: null, modelName: NumberOfAnimalTaxa )
• NumberOfAnimals ( type: esriFieldTypeInteger, alias: Number of Animals, editable: true, nullable: false, defaultValue: null, modelName: NumberOfAnimals )
• CreationDate ( type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: false, length: 50, defaultValue: null, modelName: City )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Country )
• Telephone ( type: esriFieldTypeString, alias: Telephone, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Telephone )
• Fax ( type: esriFieldTypeString, alias: Fax, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Fax )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: false, length: 1024, defaultValue: null, modelName: Comments )

Templates:

• Name: Institution
  Description:
  Prototype:
  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:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Area of Interest (0) -- Related To: Area of Interest (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata