Name: dbo.botrecs

Display Field: countryname

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e369fb06147749ff9169363df60b9cca

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• id ( type: esriFieldTypeGUID, alias: id, length: 38 )
• checkeddate ( type: esriFieldTypeDateOnly, alias: checkeddate )
• qds ( type: esriFieldTypeString, alias: qds, length: 10 )
• botreccat ( type: esriFieldTypeInteger, alias: botreccat )
• brahmsid ( type: esriFieldTypeBigInteger, alias: brahmsid )
• basisofrecord ( type: esriFieldTypeString, alias: basisofrecord, length: 255 )
• entrydate ( type: esriFieldTypeDateOnly, alias: entrydate )
• enteredby ( type: esriFieldTypeString, alias: enteredby, length: 128 )
• istype ( type: esriFieldTypeString, alias: istype, length: 50 )
• principalcollector ( type: esriFieldTypeString, alias: principalcollector, length: 128 )
• prefix ( type: esriFieldTypeString, alias: prefix, length: 10 )
• collectionnumber ( type: esriFieldTypeString, alias: collectionnumber, length: 15 )
• suffix ( type: esriFieldTypeString, alias: suffix, length: 10 )
• fullnumber ( type: esriFieldTypeString, alias: fullnumber, length: 256 )
• collectionday ( type: esriFieldTypeInteger, alias: collectionday )
• collectionmonth ( type: esriFieldTypeInteger, alias: collectionmonth )
• collectionyear ( type: esriFieldTypeInteger, alias: collectionyear )
• collectiondatetext ( type: esriFieldTypeString, alias: collectiondatetext, length: 50 )
• datecollected ( type: esriFieldTypeString, alias: datecollected, length: 4000 )
• additionalcollectors ( type: esriFieldTypeString, alias: additionalcollectors, length: 1073741822 )
• countryname ( type: esriFieldTypeString, alias: countryname, length: 50 )
• majorregion ( type: esriFieldTypeString, alias: majorregion, length: 50 )
• minorregion ( type: esriFieldTypeString, alias: minorregion, length: 50 )
• localityname ( type: esriFieldTypeString, alias: localityname, length: 50 )
• localitytext ( type: esriFieldTypeString, alias: localitytext, length: 1073741822 )
• latitudedecimal ( type: esriFieldTypeDouble, alias: latitudedecimal )
• longitudedecimal ( type: esriFieldTypeDouble, alias: longitudedecimal )
• latlongaccuracy ( type: esriFieldTypeString, alias: latlongaccuracy, length: 5 )
• latlongchecked ( type: esriFieldTypeDateOnly, alias: latlongchecked )
• altitude ( type: esriFieldTypeInteger, alias: altitude )
• habitatdescription ( type: esriFieldTypeString, alias: habitatdescription, length: 1073741822 )
• plantdescription ( type: esriFieldTypeString, alias: plantdescription, length: 1073741822 )
• taxonomyid ( type: esriFieldTypeGUID, alias: taxonomyid, length: 38 )
• databaseid ( type: esriFieldTypeString, alias: databaseid, length: 50 )
• family ( type: esriFieldTypeString, alias: family, length: 50 )
• genus ( type: esriFieldTypeString, alias: genus, length: 50 )
• sp1 ( type: esriFieldTypeString, alias: sp1, length: 50 )
• author1 ( type: esriFieldTypeString, alias: author1, length: 100 )
• rank1 ( type: esriFieldTypeString, alias: rank1, length: 10 )
• sp2 ( type: esriFieldTypeString, alias: sp2, length: 50 )
• author2 ( type: esriFieldTypeString, alias: author2, length: 100 )
• rank2 ( type: esriFieldTypeString, alias: rank2, length: 10 )
• sp3 ( type: esriFieldTypeString, alias: sp3, length: 50 )
• author3 ( type: esriFieldTypeString, alias: author3, length: 100 )
• homonym ( type: esriFieldTypeSmallInteger, alias: homonym )
• iucn ( type: esriFieldTypeString, alias: iucn, length: 3 )
• criteria ( type: esriFieldTypeString, alias: criteria, length: 1073741822 )
• speciescitation ( type: esriFieldTypeString, alias: speciescitation, length: 180 )
• taxstat ( type: esriFieldTypeString, alias: taxstat, length: 25 )
• syncat ( type: esriFieldTypeString, alias: syncat, length: 30 )
• accepted ( type: esriFieldTypeString, alias: accepted, length: 575 )
• syns ( type: esriFieldTypeString, alias: syns, length: 1073741822 )
• species ( type: esriFieldTypeString, alias: species, length: 101 )
• taxon ( type: esriFieldTypeString, alias: taxon, length: 225 )
• plotid ( type: esriFieldTypeBigInteger, alias: plotid )
• imagecount ( type: esriFieldTypeInteger, alias: imagecount )
• polynomial ( type: esriFieldTypeString, alias: polynomial, length: 1073741822 )
• mapcolour ( type: esriFieldTypeString, alias: mapcolour, length: 20 )
• geometry ( type: esriFieldTypeString, alias: geometry, length: 1073741822 )
• count ( type: esriFieldTypeInteger, alias: count )
• biomass ( type: esriFieldTypeDouble, alias: biomass )
• transect ( type: esriFieldTypeInteger, alias: transect )
• quadrant ( type: esriFieldTypeInteger, alias: quadrant )
• surveytype ( type: esriFieldTypeString, alias: surveytype, length: 50 )
• pccover ( type: esriFieldTypeInteger, alias: pccover )
• present ( type: esriFieldTypeString, alias: present, length: 5 )
• sizeclass ( type: esriFieldTypeString, alias: sizeclass, length: 256 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata