Data Download Information

CRAM Download Data Definitions

The information on this page is provided to help end-users better understand the data downloaded from the CRAM website. If you have questions or comments, please contact [email protected].

New assessments will be added as they are made available.

Data are downloaded in .csv file format. This file format can be opened with Microsoft Excel or other spreadsheet software. Each data download file will contain the following columns:

  • geometry: Polygon of AA represented as well-known text, geographic coordinates (WGS84).
  • ecramid: ID given to each individual AA.
  • cramver: Version of CRAM Field Book used to conduct assessment.
  • wetlandclass: Type of wetland assessed (e.g. riverine, depressional).
  • wetlandsubclass: Subclass of wetland (e.g. confined or non-confined for riverine wetlands).
  • wetlandtypedisplay: Combination of wetland class and subclass (e.g. riverine confined).
  • wetlandtyperowid: Numeric ID given to each type of wetland.
  • userid: User ID of the creator of AA in eCRAM.
  • userid_updatedby: User ID of the last person to update AA in eCRAM.
  • aaname: Name given to AA.
  • projectname: Name of project to which AA belongs (can be more than one).
  • assessmentareaid: User defined ID given to each AA within a study.
  • projectid: External ID of project that AA belongs to (e.g. permit number, 401 Cert number).
  • visitdate: Date assessment was conducted.
  • createdate: Date AA was entered into eCRAM.
  • lastupdate: Date of last update to AA in eCRAM.
  • practitioners: People who carried out the assessment. Includes lead and additional practitioners.
  • practitionerother: Other practitioners who conducted assessment. (This is a user-supplied text field for users who weren't in the system at the time an AA was created.)
  • aacategorydesc: Descriptive category of AA (e.g. restoration, mitigation, reference).
  • aacomment: Any comments entered about AA.
  • legacygid: Previous eCRAM ID given to the assessment (for older assessments).
  • centroidlong: Longitude of the centroid of AA. This data is auto-generated by eCRAM.
  • centroidlat: Latitude of the centroid of AA. This data is auto-generated by eCRAM.
  • aasize_ha: Area of AA in hectares. This data is auto-generated by eCRAM.
  • county: County in which AA is located. This data is auto-generated by eCRAM.
  • ecoregion: General eco-region in which AA is located (e.g. Bay/Delta, Sierra, San Joaquin Valley). This data is auto-generated by eCRAM.
  • aageomcomment: Comments on geometry of AA (the shape of the polygon).
  • ispublic: Reflects whether AA is a public record in eCRAM, and thus can be displayed on the website.
  • isnottest: Reflects whether AA is real data, and not test data entered for practice. Test data will be regularly deleted from the database.
  • indexscore: Overall CRAM index score for AA.
  • buffer_landscape_context: Buffer landscape context assessment metric.
  • hydrology: Hydrology assessment metric.
  • physical_structure: Physical structure assessment metric.
  • biotic_structure: Biotic structure assessment metric.
  • bankfulwidth: For Riverine wetlands, the average bankfull width of channel in AA.
  • length: For Riverine wetlands, length of AA in meters.
  • upstreamlatitude: The latitude coordinate of upstream end of AA.
  • upstreamlongitude: The longitude coordinate of upstream end of AA.
  • downstreamlatitude: The latitude coordinate of downstream end of AA.
  • downstreamlongitude: The longitude coordinate of downstream end of AA.
  • datum: Datum used for capturing AA coordinates.
  • flowingwater_riverine: For riverine systems, if stream/river has flowing water in it at time of assessment.
  • hydroregime_riverine: For riverine systems, this field describes hydrologic regime (e.g. perennial, intermittent, ephemeral).
  • tidalstage_riverine: For riverine sites, description of tidal stage at time of assessment (high or low tide).
  • tidalstage_estuarine: For estuarine sites, description of tidal stage at time of assessment (high or low tide).
  • mouthcondition: What is condition of mouth at time of assessment (only Bar-built estuarine)?
  • encompass_estuarine: Does AA encompass whole wetland or a portion of wetland?
  • wetlandorigindesc: For depressional wetlands, description of origin of wetland (natural or artificial).
  • managetypes: Description of management occurring at time of assessment.
  • depressionaltypedesc: Description of type of depressional wetland assessed (e.g. freshwater marsh).
  • encompass_depressional: Does AA encompass whole wetland or a portion of wetland.
  • hydrostate_depressional: Describes hydrologic state of depressional wetland at time of assessment (ponded/inundated, saturated soil, but no surface water, or dry).
  • hydroregime_depressional: Description of hydrologic regime of depressional wetland assessed (perennially flooded, seasonally flooded, temporarily flooded).
  • connectstreamfloodplain: For depressional wetlands, whether wetland is connected to floodplain of a nearby stream.
  • definedoutlet: Whether wetland has a defined outlet.
  • definedinlet: Whether wetland has a defined inlet.
  • inletoutletsamelocation: Whether inlet and outlet are in same location.
  • distincttopobasin: For depressional wetlands, describes whether topographic basin of a wetland is distinct or indistinct. An indistinct topographic basin is one that lacks obvious boundaries between wetland and upland.
  • vpcategorydesc: Description of category of vernal pool (individual vernal pool or system of pools).
  • surfacewater: For slope wetlands, is surface water present during assessment.
  • hydrodescription: For slope wetlands, describe hydrology of AA.
  • peatsoils: Are peat soils present in AA.
  • encompass_slope: Does AA encompass the whole wetland or a portion of wetland.
  • hydrostate_slope: Describes dominant hydrologic state of slope wetland at the time of assessment (ponded/inundated, saturated soil but no surface water, moist, dry).
  • hydroregime_slope: Describes hydrologic regime of slope wetland (perennial, seasonal, temporarily flooded).

Last Updated: 5/30/2013