GLHI Database HTML Dump
Previous topic Chapter index Next topic

Indices

 

Index

Table

Schema

Tablespace

Type

Function

Fields

Primary Key

Unique

Description

PhotoUpload_pkey

PhotoUpload

public

(default)

btree

 

PhotoID

 

geometry_columns_pk

geometry_columns

public

(default)

btree

 

f_table_catalog, f_table_schema, f_table_name, f_geometry_column

 

gl_110th_congressional_districts_pkey

gl_110th_congressional_districts

public

(default)

btree

 

gid

 

gl_110th_congressional_districts_the_geom_gist

gl_110th_congressional_districts

public

(default)

gist

 

the_geom

 

 

 

gl_counties_pkey

gl_counties

public

(default)

btree

 

gid

 

gl_counties_the_geom_gist

gl_counties

public

(default)

gist

 

the_geom

 

 

 

gl_hucs_pkey

gl_hucs

public

(default)

btree

 

gid

 

gl_hucs_the_geom_gist

gl_hucs

public

(default)

gist

 

the_geom

 

 

 

gl_state_boundaries_pkey

gl_state_boundaries

public

(default)

btree

 

gid

 

gl_state_boundaries_the_geom_gist

gl_state_boundaries

public

(default)

gist

 

the_geom

 

 

 

last_update_pkey

last_update

public

(default)

btree

 

update_id

 

spatial_ref_sys_pkey

spatial_ref_sys

public

(default)

btree

 

srid

 

submit_data2_pkey

submit_data

public

(default)

btree

 

id

 

 

submit_data_pkey

submit_data3

public

(default)

btree

 

id

 

 

submit_status_pkey

submit_status

public

(default)

btree

 

submit_status_id

 

 

tblAccessConstraints_pkey

tblAccessConstraintsLU

public

(default)

btree

 

AccessConstraintLUID

 

tblCongressionalDistrict_pkey

tblCongressionalDistrict

public

(default)

btree

 

CongressionalDistrictID

 

tblContactsAdmin_pkey

tblContactsAdmin

public

(default)

btree

 

ContactID

 

tblContactsLU_ContactID

tblContactsLU

public

(default)

btree

 

ContactID

 

 

 

tblContactsLU_OrgCategoryID

tblContactsLU

public

(default)

btree

 

OrgTypeID

 

 

 

tblContactsLU_OrgID

tblContactsLU

public

(default)

btree

 

OrgID

 

 

 

tblContactsLU_Zipcode

tblContactsLU

public

(default)

btree

 

Zipcode

 

 

 

tblContactsLU_pkey

tblContactsLU

public

(default)

btree

 

ContactID

 

tblCountyLU_pkey

tblCountyLU

public

(default)

btree

 

CountyLUID

 

tblCurrentLandUse_pkey

tblCurrentLandUse

public

(default)

btree

 

LandUseID

 

tblFragmentationLU_pkey

tblFragmentationLU

public

(default)

btree

 

FragLUID

 

tblFunding_ProjID

tblFunding

public

(default)

btree

 

PROJECT_ID

 

 

 

tblFunding_pkey

tblFunding

public

(default)

btree

 

FundingID

 

tblGoalLU_ProjGoalID

tblGoalLU

public

(default)

btree

 

GoalLUID

 

 

 

tblGoalLU_SortKey

tblGoalLU

public

(default)

btree

 

SortKey

 

 

 

tblGoalLU_pkey

tblGoalLU

public

(default)

btree

 

GoalLUID

 

tblHabTypeLU2_pkey

tblHabTypeLU

public

(default)

btree

 

HabitatLUID

 

tblHabitat_pkey

tblHabitat

public

(default)

btree

 

HabitatID

 

tblHucs_pkey

tblHucs

public

(default)

btree

 

tblHucsID

 

tblLandOwnership_pkey

tblLandOwnership

public

(default)

btree

 

LandOwnershipID

 

tblLimitingFactor_pkey

tblLimitingFactor

public

(default)

btree

 

LimitingFactorID

 

tblLimitingFactorLU2_LmtFctID

tblLimitingFactorLU

public

(default)

btree

 

LimitingFactorLUID

 

 

 

tblLimitingFactorLU2_pkey

tblLimitingFactorLU

public

(default)

btree

 

LimitingFactorLUID

 

tblModGoalLU_ModGoalsID

tblModGoalLU

public

(default)

btree

 

ModGoalsID

 

 

 

tblModGoalLU_pkey

tblModGoalLU

public

(default)

btree

 

ModGoalsID

 

Monitoring_pkey

tblMonitoring

public

(default)

btree

 

MonitoringID

 

MonitoringActivities_pkey

tblMonitoringActivities

public

(default)

btree

 

MonitoringActivitiesID

 

tblMonitoringFrequencyLU_pkey

tblMonitoringFrequencyLU

public

(default)

btree

 

MonitoringFreqID

 

tblMonitoringLU_pkey

tblMonitoringLU

public

(default)

btree

 

MonitoringLUID

 

tblOrgTypeLU_number

tblOrgTypeLU

public

(default)

btree

 

OrgTypeID

 

 

 

tblOrgTypeLU_pkey

tblOrgTypeLU

public

(default)

btree

 

OrgTypeID

 

tblOrganizationLU_pkey

tblOrganizationLU

public

(default)

btree

 

OrgID

 

tblProjGoal_ModGoalID

tblProjGoal

public

(default)

btree

 

ModGoalID

 

 

 

tblProjGoal_pkey

tblProjGoal

public

(default)

btree

 

ProjGoalID

 

tblProjReport_pkey

tblProjReport

public

(default)

btree

 

ProjReportID

 

tblProject_pkey

tblProject

public

(default)

btree

 

PROJECT_ID

 

tblProjectCompletionLU_pkey

tblProjectCompletenessLU

public

(default)

btree

 

ProjCompletenessID

 

ProjectFundingSources_pkey

tblProjectFundingSources

public

(default)

btree

 

ProjectFundingSource

 

tblProjectGeography_pkey

tblProjectGeography

public

(default)

btree

 

GeographyID

 

tblProjectModificationsLU_pkey

tblProjectModificationsLU

public

(default)

btree

 

ProjModLUID

 

 

ProjectSignificance_pkey

tblProjectSignificance

public

(default)

btree

 

ProjectSignificanceID

 

tblProjectSignificance_pkey

tblProjectSignificanceLU

public

(default)

btree

 

ProjectSignificanceLUID

 

tblProjectType_pkey

tblProjectTypeLU

public

(default)

btree

 

ProjectTypeLUID

 

tblRealEstate_pkey

tblRealEstate

public

(default)

btree

 

RealEstateID

 

tblRestoration_ProjGoal_key

tblRestoration

public

(default)

btree

 

ProjGoalID

 

 

tblRestoration_ProjLimitingFactor_key

tblRestoration

public

(default)

btree

 

ProjLimitingFactorID

 

 

tblRestoration_pkey

tblRestoration

public

(default)

btree

 

RestorationID

 

tblRestoreTreatLU_SortKeyCode

tblRestoreTreatLU

public

(default)

btree

 

SortKeyID

 

 

 

tblRestoreTreatLU_TreatmentID1

tblRestoreTreatLU

public

(default)

btree

 

TreatmentLUID

 

 

 

tblRestoreTreatLU_pkey

tblRestoreTreatLU

public

(default)

btree

 

TreatmentLUID

 

tblRestoreTreatment_pkey

tblRestoreTreatment

public

(default)

btree

 

RstrFctrID

 

tblSoils_pkey

tblSoils

public

(default)

btree

 

SoilsID

 

tblSpatialTypeLU_SpatialTypeID

tblSpatialTypeLU

public

(default)

btree

 

SpatialTypeID

 

 

 

tblSpatialTypeLU_pkey

tblSpatialTypeLU

public

(default)

btree

 

SpatialTypeID

 

tblStateCounty_pkey

tblStateCounty

public

(default)

btree

 

tblStateCountyID

 

tblStateLU_StateCode

tblStateLU

public

(default)

btree

 

StateID

 

 

 

tblStateLU_pkey

tblStateLU

public

(default)

btree

 

StateID

 

tblStateLU_tblStateLUState

tblStateLU

public

(default)

btree

 

State

 

 

 

tblStatusLU2_StatusID1

tblStatusLU

public

(default)

btree

 

StatusLUID

 

 

 

tblStatusLU2_pkey

tblStatusLU

public

(default)

btree

 

StatusLUID

 

tblTableChanges_pkey

tblTableChanges

public

(default)

btree

 

SeqID, TableName, ProjID

 

tblThreats_ThreatTypeID_key

tblThreats

public

(default)

btree

 

ThreatTypeID

 

 

tblThreats_pkey1

tblThreats

public

(default)

btree

 

ThreatID

 

tblThreatsGroupsLU_pkey

tblThreatsGroupsLU

public

(default)

btree

 

ThreatGroupID

 

tblThreatsLU2_pkey

tblThreatsLU

public

(default)

btree

 

ThreatLUID

 

tbl_geography_test2_pkey

tbl_geography_test2

public

(default)

btree

 

row_id

 

ProjectGeography_test_pkey

tblprojectgeography_test

public

(default)

btree

 

PROJECT_ID

 

 

 

test_files_pkey

test_files

public

(default)

btree

 

fid

 

Monitoring_future_tbl_ProjID

xxxMonitoring_future_tbl

glhri

(default)

btree

 

ProjID

 

 

 

Protection_future_tbl_ProjID

xxxProtection_future_tbl

glhri

(default)

btree

 

ProjID

 

 

 

Protection_future_tbl_pkey

xxxProtection_future_tbl

glhri

(default)

btree

 

ID

 

tblEvalPermitLU_EvalPermitID1

xxxtblEvalPermitLU

glhri

(default)

btree

 

EvalPermitID

 

 

 

tblEvalPermitLU_OrgID

xxxtblEvalPermitLU

glhri

(default)

btree

 

OrgID

 

 

 

tblEvalPermitLU_pkey

xxxtblEvalPermitLU

glhri

(default)

btree

 

EvalPermitID

 

tblExistLandCvrLU_LandCvrID1

xxxtblExistLandCvrLU

glhri

(default)

btree

 

LandCvrID

 

 

 

tblExistLandCvrLU_pkey

xxxtblExistLandCvrLU

glhri

(default)

btree

 

LandCvrID

 

tblExistLandCvrLU2_pkey

xxxtblExistLandUseLU

glhri

(default)

btree

 

LandUseID

 

xxxtblHabTypeLU_HABTYPEID1

xxxtblHabTypeLU

glhri

(default)

btree

 

HABTYPEID

 

 

 

xxxtblHabTypeLU_pkey

xxxtblHabTypeLU

glhri

(default)

btree

 

HABTYPEID

 

tblLimitingFactorLU_LmtFctID

xxxtblLimitingFactorLU

glhri

(default)

btree

 

LmtFctrID

 

 

 

xxxtblLocDataSourceLU_LocDataID

xxxtblLocDataSourceLU

glhri

(default)

btree

 

LocDataID

 

 

 

xxxtblLocDataSourceLU_pkey

xxxtblLocDataSourceLU

glhri

(default)

btree

 

LocDataID

 

tblLocation_StateID

xxxtblLocation

glhri

(default)

btree

 

StateAbr

 

 

 

tblLocation_pkey

xxxtblLocation

glhri

(default)

btree

 

ProjID

 

tblProjTypeLU_ProjTypeID1

xxxtblProjTypeLU

glhri

(default)

btree

 

ProjTypeID

 

 

 

tblProjTypeLU_SortKey

xxxtblProjTypeLU

glhri

(default)

btree

 

SortKey

 

 

 

tblProjTypeLU_pkey

xxxtblProjTypeLU

glhri

(default)

btree

 

ProjTypeID

 

tblProjXContact_ContactID

xxxtblProjXContact

glhri

(default)

btree

 

ContactID

 

 

 

tblProjXContact_OrgID

xxxtblProjXContact

glhri

(default)

btree

 

OrgID

 

 

 

tblProjXContact_ProjID

xxxtblProjXContact

glhri

(default)

btree

 

ProjID

 

 

 

tblProjXContact_RoleID

xxxtblProjXContact

glhri

(default)

btree

 

RoleID

 

 

 

tblProjXPermit_TreatmentID

xxxtblProjXPermit

glhri

(default)

btree

 

EvalPermitID

 

 

 

tblProjXTreat_TreatmentID

xxxtblProjXTreat

glhri

(default)

btree

 

TreatmentID

 

 

 

tblRoleLU_RoleID

xxxtblRoleLU

glhri

(default)

btree

 

RoleID

 

 

 

tblRoleLU_pkey

xxxtblRoleLU

glhri

(default)

btree

 

RoleID

 

tblStatusLU_StatusID1

xxxtblStatusLU

glhri

(default)

btree

 

StatusID

 

 

 

tblThreats_pkey

xxxtblThreatsLU

public

(default)

btree

 

ThreatID

 

tblspeciesLU_SPP

xxxtblspeciesLU

glhri

(default)

btree

 

SPP

 

 

 

tblspeciesLU_SPPID

xxxtblspeciesLU

glhri

(default)

btree

 

SPPID

 

 

 

tblspeciesLU_pkey

xxxtblspeciesLU

glhri

(default)

btree

 

SPPID

 

Pete Giencke
pgiencke@glc.org
Previous topic Chapter index Next topic