Table Columns

If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

  Sort columns ordinally
  Sort columns alphabetically

Columns in table "ih"




Column Data Type Null Description Values
url_old text YES
state_province_verbatim text YES Verbatim state/province, as submitted.
state_province text YES Standard state/province name from geonames database (GNRS)
specimen_duplicate_institutions character varying NO
sourceType text NO
poldiv_full text YES [internal use]
observationGranularity text NO
latlong_verbatim text YES Verbatim latitude and longitude
lat_text text YES Verbatim latitude
lat numeric YES
fk_gnrs_id bigint YES Foreign key to table gnrs
country_verbatim text YES Verbatim country, as submitted
country text YES Standard country name from geonames database (GNRS)
acronym text YES Standard Index Herbaiorum herbarium acronym
*url text YES
*NotNotes text YES
*NamSection text YES
*NamOrganisation text YES
*NamFax text YES
*NamDepartment text YES
*NamBranch text YES
*IhhTotal text YES
*IhhStatus text YES
*IhhInstitutionType text YES
*IhhGeography text YES
*IhhExchange text YES
*IhhCites text YES
*IhhAssociatedHerbaria text YES
*HisCommenced text YES
*eparties_key integer YES
*AdmTimeModified text YES
*AdmDateModified text YES
*AddWeb text YES
*AddPostStreet text YES
*AddPostState text YES
*AddPostPost text YES
*AddPostCity text YES
*AddPhysStreet text YES
*AddPhysState text YES
*AddPhysPost text YES
*irn text YES
*AddEmail text YES
*AddPhysCountry text YES
*AddPhysCity text YES
*AddEmuUserId text YES
long_text text YES Verbatim longitude
long numeric YES