GLHI Database HTML Dump
Previous topic Chapter index Next topic

Table: tblProjectGeography

 

 

Schema

public

 

Owner

wetlands

 

Tablespace

(default)

 

Descriptions

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

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

GeographyID

integer

 

nextval('"tblProjectGeography_GeographyID_seq"'::regclass)

 

 

 

PROJECT_ID

integer

 

 

 

key

 

 

ProjectRealEstateID

integer

 

 

 

 

Key to real estate table

 

 

ProjectOwnershipEasementID

integer

 

 

 

 

Key to organization info table

 

 

ProjectLandCoverID

integer

 

 

 

 

key to land cover class table

 

 

ProjectX

double precision

 

 

 

 

Project centroid lat/lon

 

 

ProjectY

double precision

 

 

 

 

Project centroid lat/lon

 

 

ConservationBlueprint

boolean

 

 

 

 

Is contained within TNC's conservation blueprint

 

ProjectFragmentationID

integer

 

 

 

 

key to habitat fragmentation field

FORM: "Habitat Connectivity/Fragmentation"

 

xSpatialTypeID

integer

 

 

 

 

Placeholder to store Spatial Type ID (which would be all type polygon for GLHI data)

 

 

LocalityDescription

text

 

 

 

 

Brief user-supplied overview of project geography

FORM: "Brief Locality Description"

 

 

xUSGS_TOPO_QUAD

varchar(50)

 

 

 

 

Placeholder to store USGS topo quad sheet

 

 

xGIS_Identifier

varchar(80)

 

 

 

 

Reference to name within external geodatabase - overrides shapefile reference

 

ProjectLandUseID

integer

 

 

 

 

key to land use table

 

 

ProjectAcreage

double precision

 

 

 

 

FORM: "Estimated total acreage restored/created, enhanced/improved, or protected."

 

 

the_geom

public.geometry

 

 

 

 

POSTGIS field to store hexidecimal geometry value.

FORM: "Geographic Extent of Project Area"

 

 

RareUniqueSpeciesHabitatPresent

boolean

 

 

 

 

FORM: "Does project area include land and/or water inhabited by rare, unique, or protected habitat/species?"

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

ProjectGeography_fk2

ProjectFragmentationID

public.tblFragmentationLU

FragLUID

No Action

No Action

 

Immediate

 

ProjectGeography_fk6

xSpatialTypeID

public.tblSpatialTypeLU

SpatialTypeID

No Action

No Action

 

Immediate

 

tblProjectGeography_fk1

ProjectLandUseID

public.tblCurrentLandUse

LandUseID

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table tblProjectGeography

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

tblProjectGeography_pkey

btree

 

GeographyID

 

 

Triggers

There are no triggers for table tblProjectGeography

 

Rules

There are no rules for table tblProjectGeography

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tblCongressionalDistrict

public

tblCongressionalDistrict_fk1

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

 

Immediate

 

tblHabitat

public

tblHabitat_fk1

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

 

Immediate

 

tblHucs

public

tblHucs_fk1

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

 

Immediate

 

tblProject

public

tblProject_fk

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

 

Immediate

 

tblRealEstate

public

tblRealEstate_fk

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

 

Immediate

 

tblStateCounty

public

tblStateCounty_fk1

GeographyID

public.tblProjectGeography

GeographyID

No Action

No Action

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition


CREATE TABLE "public"."tblProjectGeography" (
  "GeographyID" SERIAL, 
  "PROJECT_ID" INTEGER NOT NULL, 
  "ProjectRealEstateID" INTEGER, 
  "ProjectOwnershipEasementID" INTEGER, 
  "ProjectLandCoverID" INTEGER, 
  "ProjectX" DOUBLE PRECISION, 
  "ProjectY" DOUBLE PRECISION, 
  "ConservationBlueprint" BOOLEAN, 
  "ProjectFragmentationID" INTEGER, 
  "xSpatialTypeID" INTEGER, 
  "LocalityDescription" TEXT, 
  "xUSGS_TOPO_QUAD" VARCHAR(50), 
  "xGIS_Identifier" VARCHAR(80), 
  "ProjectLandUseID" INTEGER, 
  "ProjectAcreage" DOUBLE PRECISION, 
  "the_geom" "public"."geometry", 
  "RareUniqueSpeciesHabitatPresent" BOOLEAN, 
  CONSTRAINT "tblProjectGeography_pkey" PRIMARY KEY("GeographyID"), 
  CONSTRAINT "ProjectGeography_fk2" FOREIGN KEY ("ProjectFragmentationID")
    REFERENCES "public"."tblFragmentationLU"("FragLUID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "ProjectGeography_fk6" FOREIGN KEY ("xSpatialTypeID")
    REFERENCES "public"."tblSpatialTypeLU"("SpatialTypeID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblProjectGeography_fk1" FOREIGN KEY ("ProjectLandUseID")
    REFERENCES "public"."tblCurrentLandUse"("LandUseID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblProjectGeography"
IS 'A table containing those fields relating particularly to project''s geography';

COMMENT ON COLUMN "public"."tblProjectGeography"."PROJECT_ID"
IS 'key';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectRealEstateID"
IS 'Key to real estate table';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectOwnershipEasementID"
IS 'Key to organization info table';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectLandCoverID"
IS 'key to land cover class table';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectX"
IS 'Project centroid lat/lon';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectY"
IS 'Project centroid lat/lon';

COMMENT ON COLUMN "public"."tblProjectGeography"."ConservationBlueprint"
IS 'Is contained within TNC''s conservation blueprint';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectFragmentationID"
IS 'key to habitat fragmentation field

FORM: "Habitat Connectivity/Fragmentation"';

COMMENT ON COLUMN "public"."tblProjectGeography"."xSpatialTypeID"
IS 'Placeholder to store Spatial Type ID (which would be all type polygon for GLHI data)';

COMMENT ON COLUMN "public"."tblProjectGeography"."LocalityDescription"
IS 'Brief user-supplied overview of project geography

FORM: "Brief Locality Description"';

COMMENT ON COLUMN "public"."tblProjectGeography"."xUSGS_TOPO_QUAD"
IS 'Placeholder to store USGS topo quad sheet';

COMMENT ON COLUMN "public"."tblProjectGeography"."xGIS_Identifier"
IS 'Reference to name within external geodatabase - overrides shapefile reference';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectLandUseID"
IS 'key to land use table';

COMMENT ON COLUMN "public"."tblProjectGeography"."ProjectAcreage"
IS 'FORM: "Estimated total acreage restored/created, enhanced/improved, or protected."';

COMMENT ON COLUMN "public"."tblProjectGeography"."the_geom"
IS 'POSTGIS field to store hexidecimal geometry value.

FORM: "Geographic Extent of Project Area"';

COMMENT ON COLUMN "public"."tblProjectGeography"."RareUniqueSpeciesHabitatPresent"
IS 'FORM: "Does project area include land and/or water inhabited by rare, unique, or protected habitat/species?"';

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