Assessment of Existing Information for Atlantic Coastal Fish Habitat Partnership (ACFHP)

The ACFHP database consist of three primary data tables, joined within SQL Server, a relational DBMS: 1. The Bibliographic table provides information on over 500 selected documents and data sources on Atlantic coastal fish species and habitats. 2. The Assessment table provides information on habitat condition indicators, threats, and conservation actions. 3. The Geospatial table provides location references for information recorded in the Bibliography and Assessment tables. In addition, a separate table enables the many-to-many relationship between bibliographic entries and locations.

Data and Resources

Additional Info

Field Value
Last Updated September 18, 2017, 19:08
Created June 7, 2017, 22:54
access_constraints ["Access Constraints: None | Use Constraints: None | Distribution Liability: These data were prepared by an agency of the United States Government. Neither the United States Government nor any agency thereof, nor any of their employees, make any warranty, expressed or implied, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any information, apparatus, product, or process disclosed in this report, or represents that its use would not infringe privately owned rights. Reference therein to any specific commercial product, process, or service by trade name, trademark, manufacturer, or otherwise does not necessarily constitute or imply its endorsement, recommendation, or favoring by the United States Government or any agency thereof. Any views and opinions of authors expressed herein do not necessarily state or reflect those of the United States Government or any agency thereof. Although all data have been used by NOAA, no warranty, expressed or implied, is made by NOAA as to the accuracy of the data and/or related materials. The act of distribution shall not constitute any such warranty, and no responsibility is assumed by NOAA in the use of these data or related materials."]
bbox-east-long -67
bbox-north-lat 46
bbox-south-lat 24
bbox-west-long -83
coupled-resource []
dataset-reference-date [{"type": "publication", "value": "2009"}]
frequency-of-update asNeeded
graphic-preview-description NFHAP_ACFHP_browse_graphic.jpg (125kb) provides an illustration of the ACFHP database design. The Assessment table is linked to the Bibliographic Table by the bibID field. The two are also linked by a many-to-many relationship of Waterbody Number (uniqueid). The AssessmentTable is also linked to the Geospatial Table by the uniqueid (Waterbody Number) field.
graphic-preview-type JPEG
guid gov.noaa.nmfs.inport:38725
licence []
metadata-date 2017-09-13T13:18:26
metadata-language eng
progress completed
resource-type dataset
responsible-party [{"name": "National Centers for Coastal Ocean Science", "roles": ["pointOfContact", "custodian"]}]
spatial {"type": "Polygon", "coordinates": [[[-83.0, 24.0], [-67.0, 24.0], [-67.0, 46.0], [-83.0, 46.0], [-83.0, 24.0]]]}
spatial_harvester true