Link to DEM Home Page Link to State of RI web site RIDEM graphical banner, showing land and water scene
Navigation button, HomeNavigation button, ProgramsNavigation button, TopicsNavigation button, MapsNavigation button, PublicationsNavigation button, NewsNavigation button, EventsNavigation button, SearchNavigation button, HelpNavigation button, Contact
Home > Programs > Bureau of Environmental Protection > Office of Water Resources > Wetlands > Woonasquatucket Wetland Restoration > Restoration Database Keys & Examples
 


Wetlands title header

Restoration Database Keys & Examples

Below are definitions or descriptions of all the columns or fields that appear in the wetland and buffer restoration databases, along with actual site examples.

Please choose:

    • Database Key for Potential Wetland Restoration Sites
    • Database Key for Potential Buffer Restoration Sites

     

Database Key for Potential Wetland Restoration Sites
(fill sites)site 248 aerial photo, 1939 vs. 1997, with inset showing location

  
Database Field Example
Definition of Field
SITEID 248 The identification number assigned to a potential wetland restoration site. The SITEID is used in the Watershed Wetland Restoration Plan and can be used to call up the site in map form on this website
TOWN_SITE Smithfield The city or town where a potential wetland restoration site is located.
ACRES_SITE 1.22 The total area of a potential wetland restoration site in acres.
PRIORITY 2 The potential wetland restoration sites are grouped into 3 tiers based on the functional assessment results. The tier 1 sites are the highest priority to restore.
STATUS_SITE Feas Done Restoration planning status of a given site. These data also appear in Tables 3-5 of the Watershed Wetland Restoration Plan.
NEXT_STEP A1 The first in a series of steps to follow to accomplish restoration of an individual site. These steps (A and B) are described in the Implementation section of the Watershed Wetland Restoration Plan.
PHOTO_39 942, 970 The number of the 1939 aerial photograph on which the potential restoration site occurs. The 1939 photographs are available on-line at http://www.edc.uri/rigis-spf/statewide/state.html.
PHOTO_88 8-26, 8-27 The number of the 1988 aerial photograph on which the potential restoration site occurs. Wetlands delineated on 1988 photographs were the basis for the RIGIS wetlands coverage.
PLAT 44 The municipal plat number of a potential wetland restoration site. Sites that cross property boundaries may be located on more than one plat.
LOT 33 The municipal lot number of a potential wetland restoration site. Sites that cross property boundaries may be located on more than one lot.
TOWN_LOT Smithfield The municipality where the aforementioned lot is located.
ACRES_LOT 1.244 The area (acres) of that portion of the site that occurs on the aforementioned plat and lot.
OWNER_SHIP Public Indicates whether the lot is owned by a private or public entity.
DEM_FLAG no "Yes" means the lot was found in the DEM enforcement database.
"No" means the lot was not found in the DEM enforcement database.
DEM_FILE The DEM enforcement file number.
FLOOD_SCORE * 1.35 The final score reflects the capacity of a site, if restored, to perform a flood abatement function and its acreage. Flood abatement scores for potential restoration sites range from 0.60 to 2.20.
FLOOD_RANK 21 A site's rank for the flood abatement function compares its final score to those of all other sites scoring at least 0.6. If final scores were the same for more than one site, the sites were then further ranked by acreage.
WATQUAL_SCORE * 1.5 The final score reflects the capacity of a site, if restored, to perform a water quality improvement function and its acreage. Water quality improvement scores for potential restoration sites range from 0.60 to 2.20.
WATQUAL_RANK 26 A site's rank for the water quality improvement function compares its final score to those of all others scoring at least 0.6. If final scores were the same for more than one site, those sites were then further ranked by acreage.
HABIT_SCOR * 999 The final score reflects the capacity of a site, if restored, to perform a wildlife habitat function and its acreage. Wildlife habitat scores for potential restoration sites range from 0.67 to 1.62.
HABIT_RANK 999 A site's rank for the wildlife habitat function compares its final score to those of all other sites scoring at least 0.6. If final scores were the same for more than one site, those sites were then further ranked by acreage.
FISH_SCORE * 999 The final score reflects the capacity of a site, if restored, to perform a fish habitat function and its acreage. Fish habitat scores for potential restoration sites range from 0.70 to 1.80.
FISH_RANK 999 A site's rank for the fish habitat function compares its final score to those of all other sites scoring at least 0.6. If final scores were the same for more than one site, those sites were then further ranked by acreage.
HERIT_SCORE * 0.9 The final score reflects the capacity of a site, if restored, to perform a heritage function and its acreage. Heritage scores for the potential restoration sites range from 0.6 to 1.70.
HERIT_RANK 34 A site's rank for the heritage function compares its final score to those of all sites scoring at least 0.6. If final scores were the same for more than one site, the sites were then further ranked by acreage.
MULTI_RAW 3 The number of functions a site could perform, if restored.
MULTI_SCORE 4.5 The multi-score reflects the number of functions that a site could perform and its acreage. Multi-scores range from 0 to 10.
MULTI_RANK 31 A site's rank for multiple functions compares its multi-score to those of all other sites. If multi-scores were the same for more than one site, those sites were then further ranked by acreage.
     

Note: A final functional assessment score of 999 indicates that the site was not considered capable of performing the function after restoration. A functional assessment rank of 999 indicates that the site was not ranked because it was not considered capable of performing the function after restoration.

Database for Potential Wetland Restoration Sites

 

Database Key for Potential Buffer Restoration Sites
(Upland Vegetation Removal Sites)

Potential Buffer Restoration Site #171 is used as an example in this database key. As shown in the 1997 aerial photograph below, this site lies between the Woonasquatucket River channel and a large municipal recreation area.

  
Database Field Example Definition of Field
SITEID 171 The identification number assigned to a potential buffer restoration site. The SITEID is used in the Watershed Wetland Restoration Plan and can be used to call up the site in map form on this website
TOWN Smithfield The city or town where a potential buffer restoration site is located.
LENGTH 322 The length of a potential buffer restoration site in feet.
PRIORITY 2 The potential buffer restoration sites are grouped into 3 tiers based on the vulnerability of the site to human impacts and the sensitivity of the contiguous wetland type. The tier 1 sites are the highest priority to restore.
STATUS_SITE Feasibility done Restoration planning status of a given site. These data also appear in Tables 7-9 of the Watershed Wetland Restoration Plan.
NEXT_STEP C1 The first in a series of steps to follow to accomplish restoration of an individual site. These steps (C and D) are described in the Implementation section of the Watershed Wetland Restoration Plan.
PLAT 23.0 The municipal plat number of a potential buffer restoration site. Sites that cross property boundaries may be located on more than one plat.
LOT 70.1 The municipal lot number of a potential buffer restoration site. Sites that cross property boundaries may be located on more than one lot.
OWNER_SHIP Public Indicates whether the lot is owned by a public or private entity.
DEM_FLAG Unknown "Yes" means the lot was found in the DEM enforcement database.
"No" means the lot was not found in the DEM enforcement database.
WET_CODE 1 RIGIS identification code for the wetland adjacent to the potential buffer restoration site.
WET_TYPE River Wetland type adjacent to the potential buffer restoration site.
WET_SENS 1 0 means the potential buffer restoration site is adjacent to a lower sensitivity wetland type.
1 means the potential buffer restoration site is adjacent to a high sensitivity wetland type.

Database for Potential Buffer Restoration Sites


For more information contact Carol Murphy
last updated 02/10/2003
For General Information 222-6800 • After Hours Emergencies 222-3070 • Disclaimer