PhotoUpload

public

wetlands

(default)

7

0

0

NERI-derived field used to capture images from the project

FORM: "Project Area Photos"

geometry_columns

public

wetlands

(default)

7

8

1

PostGIS table to be populated with each project, linked to said projects geography, which will serve as the base against which GIS operations are performed (eg shapfile/geodatabase creation)

gl_110th_congressional_districts

public

wetlands

(default)

8

125

2

gl_counties

public

glosdb

(default)

11

674

39

gl_hucs

public

glosdb

(default)

12

382

9

gl_state_boundaries

public

glosdb

(default)

10

29

2

last_update

public

wetlands

(default)

3

324

3

A table for displaying last updates

spatial_ref_sys

public

wetlands

(default)

5

2671

248

PostGIS table holding project projection information

submit_data

public

wetlands

(default)

93

83

21

submit_data3

public

wetlands

(default)

93

74

188

submit_status

public

wetlands

(default)

6

79

4

tblAccessConstraintsLU

public

wetlands

(default)

3

3

1

Table holding the access restrictions for a project which prescribes a level of approved dissemination

tblCongressionalDistrict

public

wetlands

(default)

6

0

0

Table to hold automatically populated congressional district data for project area. Table uses standard Census Bureau naming conventions for field names.

FORM: AUTOMATICALLY POPULATED

tblCongressionalDistrict0yyqjj

pg_temp_14

wetlands

(default)

6

0

0

tblContactsAdmin

public

wetlands

(default)

3

102

2

A table defining whether a user is an account holder within the system and if so is there a password

tblContactsLU

public

wetlands

(default)

24

103

5

A pretty basic table used to store user information for point of contact information, user administration, etc

tblCountyLU

public

wetlands

(default)

3

0

0

County FIPS are NOT primary key

tblCurrentLandUse

public

wetlands

(default)

3

14

1

Lookup table to hold MIRIS-derived land use categories for project area.

FORM: CURRENT LAND USE

tblFragmentationLU

public

wetlands

(default)

3

4

1

USCOE-supplied habitat fragmentation breaks

tblFunding

public

wetlands

(default)

16

0

0

NERI-like table containing those fields relating particularly to project's funding sources.

FORM: "Funding Breakdown"

tblGoalLU

public

wetlands

(default)

5

41

2

Lookup table containing different ecological outcomes

tblHabTypeLU

public

wetlands

(default)

4

26

2

Lookup table to store NERI (et al) derived habitat types

tblHabitat

public

wetlands

(default)

12

0

0

Table to hold NERI (et al) derived habitat types for project areas. Table can be extended to support individual habitat tracking using acres/miles places.

FORM: "HABITAT TYPE"

tblHucs

public

wetlands

(default)

7

0

0

Table to hold automatically populated hydrologic unit code (HUC) data for project area. Table uses standard USGS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED

tblLandOwnership

public

wetlands

(default)

3

0

0

Table containing land ownership information, keyed to the project and organization type tables.

tblLimitingFactor

public

wetlands

(default)

3

0

0

Table containing limiting factors for the project, with keys back to the Project_ID and limitingfactor lookup table

tblLimitingFactorLU

public

wetlands

(default)

3

22

1

Project area stressors lookup table

tblModGoalLU

public

wetlands

(default)

2

19

1

tblMonitoring

public

wetlands

(default)

7

0

0

A table containing those fields relating particularly to project's monitoring activities

tblMonitoringActivities

public

wetlands

(default)

4

0

0

A table containing a monitoring activity for a given project. Is setup to support multiple types for each project.

FORM: "Monitoring Categories, Categories requring monitoring."

tblMonitoringFrequencyLU

public

wetlands

(default)

2

7

1

A table to hold the frequency of monitoring activities at a project site.

tblMonitoringLU

public

wetlands

(default)

3

0

0

NERI-derived monitoring LU items

tblOrgTypeLU

public

wetlands

(default)

2

11

1

Lookup table describing the different organizational entities to be encountered in this project (ie federal, state, etc)

tblOrganizationLU

public

wetlands

(default)

5

119

4

Look up table containing organization information (abbrev,name,id) for the different entities throughout the region. Support for user-definied orgs forthcoming.

tblProjGoal

public

wetlands

(default)

6

0

0

Table containing a projects anticipated ecological outcomes

FORM: "Anticipated Ecological Outcomes"

tblProjReport

public

wetlands

(default)

8

0

0

Placeholder table for project report information

tblProject

public

wetlands

(default)

29

0

0

Main table for the GLHRI, all other tables are linked in some fashion to this in order to fully describe a project.

tblProjectCompletenessLU

public

wetlands

(default)

2

5

1

A lookup table containing breaks defining different levels of project completeness

tblProjectFundingSources

public

wetlands

(default)

3

0

0

Table describing the funding source/sponsorship for a particular project.

FORM: "Project Sponsorship"

tblProjectGeography

public

wetlands

(default)

17

0

0

A table containing those fields relating particularly to project's geography

tblProjectModificationsLU

public

wetlands

(default)

2

7

1

Lookup for table modifications

tblProjectRecordModifications

public

wetlands

(default)

4

0

0

A table holding modifications to the database.

tblProjectSignificance

public

wetlands

(default)

3

0

0

A table describing the project's significance to the Great Lakes Regional Collaboration Strategy

FORM: "Relevancy to Great Lakes Regional Collaboration Strategy"

tblProjectSignificanceLU

public

wetlands

(default)

4

38

2

Lookup table for the Great Lakes Regional Collaboration Strategy goals

tblProjectTypeLU

public

wetlands

(default)

3

4

1

Restoration project type using CEQ definitions

tblRealEstate

public

wetlands

(default)

4

0

0

Table to capture real estate interests within project area.

tblRestoration

public

wetlands

(default)

20

0

0

A table containing those fields relating particularly to project's restoration activities

tblRestoreTreatLU

public

wetlands

(default)

4

33

2

Project area related mitigaiton techniques lookup table

tblRestoreTreatment

public

wetlands

(default)

3

0

0

Table containing mitigation techniques for the project, with keys back to the Project_ID and restoretreatment lookup table

FORM: "Mitigation Techniques and Measures"

tblSoils

public

wetlands

(default)

7

0

0

Table to hold automatically populated SSURGO data for each project area. Table uses standard NRCS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED

tblSoils0vayla

pg_temp_14

wetlands

(default)

7

0

0

tblSoils0vbpkf

pg_temp_14

wetlands

(default)

7

0

0

tblSpatialTypeLU

public

wetlands

(default)

2

6

1

For now, a field to describe the project geography type. Will likely get superceded by a PostGIS description.

tblStateCounty

public

wetlands

(default)

7

0

0

Table to hold automatically populated state and county data for project area. Table uses standard Census Bureau naming conventions for field names.

tblStateLU

public

wetlands

(default)

2

52

1

tblStatusLU

public

wetlands

(default)

4

7

1

tblTableChanges

public

wetlands

(default)

7

0

0

Placeholder table for table changes

tblThreats

public

wetlands

(default)

3

0

0

Table containing threats related to project area. Types derived from IUCN - CMP Threat Definitions.

FORM: "Ecological Stressors/Threats Affecting Area"

tblThreatsGroupsLU

public

wetlands

(default)

3

11

1

Lookup table containing IUCN - CMP Threat Group Definitions.

tblThreatsLU

public

wetlands

(default)

3

25

1

LSC Stressors

tbl_geography_test2

public

glosdb

(default)

6

5

2

test

tblprojectgeography_test

public

wetlands

(default)

24

4

1

A table containing those fields relating particularly to project's geography

test_AAA

public

wetlands

(default)

2

0

0

testing table, can delete any time

test_files

public

wetlands

(default)

3

1

1

test for storing binary files

xxxMonitoring_future_tbl

glhri

wetlands

(default)

1

1

1

xxxProtection_future_tbl

glhri

wetlands

(default)

2

0

0

xxxtblBenefitsListLU_goals

glhri

wetlands

(default)

1

27

1

To be used as a base for ranking, etc

xxxtblEvalPermitLU

glhri

wetlands

(default)

7

2

1

xxxtblExistLandCvrLU

glhri

wetlands

(default)

2

11

1

xxxtblExistLandUseLU

glhri

wetlands

(default)

3

12

1

A lookup table describing different land use classifications

xxxtblHabTypeLU

glhri

wetlands

(default)

4

21

1

xxxtblLimitingFactorLU

glhri

wetlands

(default)

2

17

1

xxxtblLocDataSourceLU

glhri

wetlands

(default)

2

11

1

xxxtblLocation

glhri

wetlands

(default)

17

0

0

xxxtblProjBenefit

glhri

wetlands

(default)

3

0

0

xxxtblProjTargetSpp

glhri

wetlands

(default)

2

0

0

xxxtblProjTypeLU

glhri

wetlands

(default)

5

9

1

xxxtblProjXContact

glhri

wetlands

(default)

4

0

0

xxxtblProjXLimitingFactor

glhri

wetlands

(default)

2

0

0

xxxtblProjXPermit

glhri

wetlands

(default)

3

0

0

xxxtblProjXTreat

glhri

wetlands

(default)

3

0

0

xxxtblRoleLU

glhri

wetlands

(default)

2

11

1

xxxtblStatusLU

glhri

wetlands

(default)

2

9

1

xxxtblThreatsLU

public

wetlands

(default)

5

39

1

Lookup table containing IUCN - CMP Threat Definitions.

xxxtblspeciesLU

glhri

wetlands

(default)

8

566

9