Tablename: locations
This is a utility table. It contains a list of geographic locations for animal sightings. One row per location.
| Field name | Field type | Field length | Field description |
|---|---|---|---|
| location_id | character varying | 4 | Unique 4-character code for the location, e.g. “ANNU” for Ano Nuevo, TEIS for Tern Island. | location_name | character varying | 50 | Full name of the location. | country | character varying | 50 | Country of the location. | state | character varying | 50 | State/province/region of the location within the country. | time_zone | smallint | None | Tome zone of the location as hour offset from GMT not during DST. | time_zone_dst | smallint | None | Time zone of the location as hour offset from GMT during daylight savings time. | lat_dec | double precision | None | Latitude (degrees with decimal fraction) of this location. | lon_dec | double precision | None | Longitude (degrees with decimal fraction) of this location. |