Name: Tree Species Table

Display Field: LATINNAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2979aab0b65f475c8623e17c0e5b3598

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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: OBJECTID )
• SPECIESCODE ( type: esriFieldTypeString, alias: SPECIESCODE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SPECIESCODE )
• FULLNAME ( type: esriFieldTypeString, alias: FULLNAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULLNAME )
• LATINNAME ( type: esriFieldTypeString, alias: LATINNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LATINNAME )
• GENUS ( type: esriFieldTypeString, alias: GENUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GENUS )
• SPECIES ( type: esriFieldTypeString, alias: SPECIES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPECIES )
• CULTIVAR ( type: esriFieldTypeString, alias: CULTIVAR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CULTIVAR )
• COMMONNAME ( type: esriFieldTypeString, alias: COMMONNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMONNAME )
• SPECIESNAME ( type: esriFieldTypeString, alias: SPECIESNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SPECIESNAME )
• ALTCOMMON ( type: esriFieldTypeString, alias: ALTCOMMON, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ALTCOMMON )
• GENUSCOM ( type: esriFieldTypeString, alias: GENUSCOM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GENUSCOM )
• LEAFCYCLE ( type: esriFieldTypeString, alias: LEAFCYCLE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEAFCYCLE )
• LEAFTYPE ( type: esriFieldTypeString, alias: LEAFTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEAFTYPE )
• PHOTOURL ( type: esriFieldTypeString, alias: PHOTOURL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTOURL )
• SPECIESURL ( type: esriFieldTypeString, alias: SPECIESURL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SPECIESURL )
• VALUERATE ( type: esriFieldTypeInteger, alias: VALUERATE, editable: true, nullable: true, defaultValue: null, modelName: VALUERATE )
• SPECIESID ( type: esriFieldTypeSmallInteger, alias: SPECIESID, editable: true, nullable: true, defaultValue: null, modelName: SPECIESID )
• MATHEIGHT ( type: esriFieldTypeString, alias: MATHEIGHT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MATHEIGHT )
• MATWIDTH ( type: esriFieldTypeString, alias: MATWIDTH, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MATWIDTH )
• FORM ( type: esriFieldTypeString, alias: FORM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FORM )
• FALLCOLOR ( type: esriFieldTypeString, alias: FALLCOLOR, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FALLCOLOR )
• FLOWER ( type: esriFieldTypeString, alias: FLOWER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOWER )
• FRUIT ( type: esriFieldTypeString, alias: FRUIT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FRUIT )
• WATERNEED ( type: esriFieldTypeString, alias: WATERNEED, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WATERNEED )
• RECOMMEND ( type: esriFieldTypeString, alias: RECOMMEND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RECOMMEND )
• BOULDERNUM ( type: esriFieldTypeInteger, alias: BOULDERNUM, editable: true, nullable: true, defaultValue: null, modelName: BOULDERNUM )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Tree Species Table
  Description:
  Prototype:
  BOULDERNUM: null
  RECOMMEND: null
  SPECIESCODE: null
  FULLNAME: null
  LATINNAME: null
  GENUS: null
  SPECIES: null
  CULTIVAR: null
  COMMONNAME: null
  SPECIESNAME: null
  ALTCOMMON: null
  GENUSCOM: null
  LEAFCYCLE: null
  LEAFTYPE: null
  PHOTOURL: null
  SPECIESURL: null
  VALUERATE: null
  SPECIESID: null
  MATHEIGHT: null
  MATWIDTH: null
  FORM: null
  FALLCOLOR: null
  FLOWER: null
  FRUIT: null
  WATERNEED: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata