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: 246bd262440d47fdb84b67f7c8492e4a

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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 ( nullable: false, editable: false, defaultValue: null, length: 4, alias: OBJECTID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
• featureid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Feature ID, type: esriFieldTypeGUID )
• institutionname ( nullable: false, editable: true, defaultValue: null, length: 100, alias: Institution Name, type: esriFieldTypeString )
• streetaddress ( nullable: false, editable: true, defaultValue: null, length: 100, alias: Street Address, type: esriFieldTypeString )
• city ( nullable: false, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• stateorprovince ( nullable: false, editable: true, defaultValue: null, length: 2, alias: State or Province, type: esriFieldTypeString )
• postalcode ( nullable: false, editable: true, defaultValue: null, length: 10, alias: Postal Code, type: esriFieldTypeString )
• country ( nullable: false, editable: true, defaultValue: null, length: 50, alias: Country, type: esriFieldTypeString )
• telephone ( nullable: false, editable: true, defaultValue: null, length: 20, alias: Telephone, type: esriFieldTypeString )
• fax ( nullable: false, editable: true, defaultValue: null, length: 20, alias: Fax, type: esriFieldTypeString )
• websiteurl ( nullable: false, editable: true, defaultValue: null, length: 100, alias: Website URL, type: esriFieldTypeString )
• directorname ( nullable: false, editable: true, defaultValue: null, length: 50, alias: Director Name, type: esriFieldTypeString )
• latitude ( nullable: false, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: false, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• elevation ( nullable: false, editable: true, defaultValue: null, alias: Elevation (m), type: esriFieldTypeDouble )
• averagerainfall ( nullable: false, editable: true, defaultValue: null, alias: Rainfall (cm), type: esriFieldTypeDouble )
• averagesnowfall ( nullable: false, editable: true, defaultValue: null, alias: Snowfall (cm), type: esriFieldTypeDouble )
• averagelowtemperature ( nullable: false, editable: true, defaultValue: null, alias: Average Low Temperature (C), type: esriFieldTypeDouble )
• averagehightemperature ( nullable: false, editable: true, defaultValue: null, alias: Average High Temperature (C), type: esriFieldTypeDouble )
• historiclowtemperature ( nullable: false, editable: true, defaultValue: null, alias: Historic Low Temperature (C), type: esriFieldTypeDouble )
• historichightemperature ( nullable: false, editable: true, defaultValue: null, alias: Historic High Temperature (C), type: esriFieldTypeDouble )
• growingseasonlength ( nullable: false, editable: true, defaultValue: null, alias: Growing Season Length (days), type: esriFieldTypeSmallInteger )
• usdazone ( nullable: false, editable: true, defaultValue: null, length: 20, alias: USDA Zone, type: esriFieldTypeString , 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 ( nullable: false, editable: true, defaultValue: null, alias: Sunset Code, type: esriFieldTypeSmallInteger , Range: [1, 24] )
• ahsheatcode ( nullable: false, editable: true, defaultValue: null, alias: AHS Heat Code, type: esriFieldTypeSmallInteger , Range: [1, 12] )
• numberofplanttaxa ( nullable: false, editable: true, defaultValue: null, alias: Number of Plant Taxa, type: esriFieldTypeSmallInteger )
• numberofplants ( nullable: false, editable: true, defaultValue: null, alias: Number of Plants, type: esriFieldTypeInteger )
• numberofanimaltaxa ( nullable: false, editable: true, defaultValue: null, alias: Number of Animal Taxa, type: esriFieldTypeSmallInteger )
• numberofanimals ( nullable: false, editable: true, defaultValue: null, alias: Number of Animals, type: esriFieldTypeInteger )
• creationdate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Creation Date, type: esriFieldTypeDate )
• creator ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Creator, type: esriFieldTypeString )
• editdate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Edit Date, type: esriFieldTypeDate )
• editor ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Editor, type: esriFieldTypeString )
• comments ( nullable: false, editable: true, defaultValue: null, length: 1024, alias: Comments, type: esriFieldTypeString )

Templates:

• Name: Institution
  Description:
  Prototype:
  stateorprovince:
  country:
  averagesnowfall: 0
  averagelowtemperature: 0
  creationdate: null
  city:
  numberofanimaltaxa: 0
  latitude: 0
  growingseasonlength: 0
  usdazone:
  numberofplanttaxa: 0
  historiclowtemperature: 0
  postalcode:
  streetaddress:
  fax:
  sunsetcode: 0
  longitude: 0
  institutionname:
  elevation: 0
  averagerainfall: 0
  editor: null
  creator: null
  comments:
  directorname:
  numberofplants: 0
  telephone:
  ahsheatcode: 0
  averagehightemperature: 0
  historichightemperature: 0
  websiteurl:
  numberofanimals: 0
  editdate: null
  featureid: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata