GLHI Database HTML Dump
Previous topic Chapter index Next topic

Table: submit_data

 

 

Schema

public

 

Owner

wetlands

 

Tablespace

(default)

 

Descriptions

There is no description for table submit_data

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

 

sid

varchar(50)

 

 

 

 

 

 

 

title

varchar(255)

 

 

 

 

 

 

 

abstract

text

 

 

 

 

 

 

 

project_type

varchar(3)

 

 

 

 

 

 

 

project_status

varchar(3)

 

 

 

 

 

 

 

achievement_goal

varchar(3)

 

 

 

 

 

 

 

brief_locality

text

 

 

 

 

 

 

 

project_mileacreage

varchar(10)

 

 

 

 

 

 

 

project_acreage

varchar(10)

 

 

 

 

 

 

 

acreage_comp_upland

varchar(10)

 

 

 

 

 

 

 

acreage_comp_riverine

varchar(5)

 

 

 

 

 

 

 

acreage_comp_coastal

varchar(10)

 

 

 

 

 

 

 

acreage_comp_water

varchar(10)

 

 

 

 

 

 

 

project_stream1

varchar(10)

 

 

 

 

 

 

 

project_stream2

varchar(10)

 

 

 

 

 

 

 

habitat_type

text

 

 

 

 

 

 

 

current_land_use

text

 

 

 

 

 

 

 

habitat_conn_frag

varchar(3)

 

 

 

 

 

 

 

ecological_stressors

text

 

 

 

 

 

 

 

ecological_outcomes

text

 

 

 

 

 

 

 

benefit_to_species

varchar(3)

 

 

 

 

 

 

 

benefit_to_habitats

varchar(3)

 

 

 

 

 

 

 

relevancy_glrc

text

 

 

 

 

 

 

 

mitigation_tech

text

 

 

 

 

 

 

 

monitoring_gauge

varchar(255)

 

 

 

 

 

 

 

monitoring_para

text

 

 

 

 

 

 

 

mitigation_notes

text

 

 

 

 

 

 

 

monitoring_url

varchar(255)

 

 

 

 

 

 

 

sponsor_fed

text

 

 

 

 

 

 

 

sponsor_nonfed

text

 

 

 

 

 

 

 

sponsor_other

text

 

 

 

 

 

 

 

funding_total_cost

varchar(40)

 

 

 

 

 

 

 

funding_fed_cash

varchar(40)

 

 

 

 

 

 

 

funding_fed_inkind

varchar(20)

 

 

 

 

 

 

 

funding_fed_lands

varchar(20)

 

 

 

 

 

 

 

funding_fed_mon_cash

varchar(20)

 

 

 

 

 

 

 

funding_fed_mon_inkind

varchar(20)

 

 

 

 

 

 

 

funding_fed_oper_cash

varchar(20)

 

 

 

 

 

 

 

funding_nonfed_cash

varchar(20)

 

 

 

 

 

 

 

funding_nonfed_inkind

varchar(20)

 

 

 

 

 

 

 

funding_nonfed_lands

varchar(80)

 

 

 

 

 

 

 

funding_nonfed_mon_cash

varchar(80)

 

 

 

 

 

 

 

funding_nonfed_mon_inkind

varchar(20)

 

 

 

 

 

 

 

funding_nonfed_oper_cash

varchar(20)

 

 

 

 

 

 

 

project_start_planned

varchar(20)

 

 

 

 

 

 

 

project_start_actual

varchar(20)

 

 

 

 

 

 

 

project_end_actual

varchar(40)

 

 

 

 

 

 

 

realestate_public

varchar(3)

 

 

 

 

 

 

 

realestate_public_orgs

text

 

 

 

 

 

 

 

realestate_private_orgs

text

 

 

 

 

 

 

 

land_ownership

varchar(255)

 

 

 

 

 

 

 

project_lead_name

varchar(100)

 

 

 

 

 

 

 

project_lead_city

varchar(100)

 

 

 

 

 

 

 

project_lead_state

varchar(100)

 

 

 

 

 

 

 

pm_fname

varchar(100)

 

 

 

 

 

 

 

pm_lname

varchar(100)

 

 

 

 

 

 

 

pm_title

varchar(150)

 

 

 

 

 

 

 

pm_email

varchar(100)

 

 

 

 

 

 

 

pm_voice

varchar(50)

 

 

 

 

 

 

 

pm_address

varchar(255)

 

 

 

 

 

 

 

pm_city

varchar(80)

 

 

 

 

 

 

 

pm_state

varchar(50)

 

 

 

 

 

 

 

photo1_cap

varchar(100)

 

 

 

 

 

 

 

photo1_credit

varchar(100)

 

 

 

 

 

 

 

photo1_path

varchar(100)

 

 

 

 

 

 

 

photo2_cap

varchar(100)

 

 

 

 

 

 

 

photo2_credit

varchar(100)

 

 

 

 

 

 

 

photo2_path

varchar(100)

 

 

 

 

 

 

 

photo3_cap

varchar(100)

 

 

 

 

 

 

 

photo3_credit

varchar(100)

 

 

 

 

 

 

 

photo3_path

varchar(100)

 

 

 

 

 

 

 

photo4_cap

varchar(100)

 

 

 

 

 

 

 

photo4_credit

varchar(100)

 

 

 

 

 

 

 

photo4_path

varchar(100)

 

 

 

 

 

 

 

legal_auth_info

text

 

 

 

 

 

 

 

org_relevant_rank

text

 

 

 

 

 

 

 

additional_proj_info

text

 

 

 

 

 

 

 

access_cons

varchar(3)

 

 

 

 

 

 

 

extent

text

 

 

 

 

 

 

 

temp_extent

text

 

 

 

 

a cleaned extent that postgis can use

 

 

the_geom

public.geometry

 

 

 

 

PostGIS geometry column

 

 

existing_proj

smallint

 

 

 

 

 

 

 

existing_proj_info

text

 

 

 

 

 

 

 

compensatory_mitigation

text

 

 

 

 

 

 

 

exist_habitats_species

varchar(6)

 

 

 

 

 

 

 

pm_zip

varchar(20)

 

 

 

 

 

 

 

id

integer

 

nextval('submit_data2_id_seq'::regclass)

 

 

 

the_geom_pt

public.geometry

 

 

 

 

centroid geometry

 

 

centroid_x

varchar(256)

 

 

 

 

x value of centroid

 

 

centroid_y

varchar(256)

 

 

 

 

y value of centroid

 

 

acres

double precision

 

 

 

 

 

 

 

state_fips

varchar(32)

 

 

 

 

 

 

 

cong_dist

varchar(255)

 

 

 

 

auto populated congressional districts

 

Foreign Keys

There are no foreign keys for table submit_data

 

Checks

There are no check constraints for table submit_data

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

submit_data2_pkey

btree

 

id

 

 

 

Triggers

Name

Type

Function

Arguments

Description

mk_the_geom2

AFTER INSERT

public.mk_the_geom2

 

 

 

Rules

There are no rules for table submit_data

 

Referenced

There are no tables referenced by table submit_data

 

Options

Option

Value

Inherited From

 

Rows

83

Pages

21

System

 

Temporary

 

With OID

 

 

Definition


CREATE TABLE "public"."submit_data" (
  "sid" VARCHAR(50), 
  "title" VARCHAR(255), 
  "abstract" TEXT, 
  "project_type" VARCHAR(3), 
  "project_status" VARCHAR(3), 
  "achievement_goal" VARCHAR(3), 
  "brief_locality" TEXT, 
  "project_mileacreage" VARCHAR(10), 
  "project_acreage" VARCHAR(10), 
  "acreage_comp_upland" VARCHAR(10), 
  "acreage_comp_riverine" VARCHAR(5), 
  "acreage_comp_coastal" VARCHAR(10), 
  "acreage_comp_water" VARCHAR(10), 
  "project_stream1" VARCHAR(10), 
  "project_stream2" VARCHAR(10), 
  "habitat_type" TEXT, 
  "current_land_use" TEXT, 
  "habitat_conn_frag" VARCHAR(3), 
  "ecological_stressors" TEXT, 
  "ecological_outcomes" TEXT, 
  "benefit_to_species" VARCHAR(3), 
  "benefit_to_habitats" VARCHAR(3), 
  "relevancy_glrc" TEXT, 
  "mitigation_tech" TEXT, 
  "monitoring_gauge" VARCHAR(255), 
  "monitoring_para" TEXT, 
  "mitigation_notes" TEXT, 
  "monitoring_url" VARCHAR(255), 
  "sponsor_fed" TEXT, 
  "sponsor_nonfed" TEXT, 
  "sponsor_other" TEXT, 
  "funding_total_cost" VARCHAR(40), 
  "funding_fed_cash" VARCHAR(40), 
  "funding_fed_inkind" VARCHAR(20), 
  "funding_fed_lands" VARCHAR(20), 
  "funding_fed_mon_cash" VARCHAR(20), 
  "funding_fed_mon_inkind" VARCHAR(20), 
  "funding_fed_oper_cash" VARCHAR(20), 
  "funding_nonfed_cash" VARCHAR(20), 
  "funding_nonfed_inkind" VARCHAR(20), 
  "funding_nonfed_lands" VARCHAR(80), 
  "funding_nonfed_mon_cash" VARCHAR(80), 
  "funding_nonfed_mon_inkind" VARCHAR(20), 
  "funding_nonfed_oper_cash" VARCHAR(20), 
  "project_start_planned" VARCHAR(20), 
  "project_start_actual" VARCHAR(20), 
  "project_end_actual" VARCHAR(40), 
  "realestate_public" VARCHAR(3), 
  "realestate_public_orgs" TEXT, 
  "realestate_private_orgs" TEXT, 
  "land_ownership" VARCHAR(255), 
  "project_lead_name" VARCHAR(100), 
  "project_lead_city" VARCHAR(100), 
  "project_lead_state" VARCHAR(100), 
  "pm_fname" VARCHAR(100), 
  "pm_lname" VARCHAR(100), 
  "pm_title" VARCHAR(150), 
  "pm_email" VARCHAR(100), 
  "pm_voice" VARCHAR(50), 
  "pm_address" VARCHAR(255), 
  "pm_city" VARCHAR(80), 
  "pm_state" VARCHAR(50), 
  "photo1_cap" VARCHAR(100), 
  "photo1_credit" VARCHAR(100), 
  "photo1_path" VARCHAR(100), 
  "photo2_cap" VARCHAR(100), 
  "photo2_credit" VARCHAR(100), 
  "photo2_path" VARCHAR(100), 
  "photo3_cap" VARCHAR(100), 
  "photo3_credit" VARCHAR(100), 
  "photo3_path" VARCHAR(100), 
  "photo4_cap" VARCHAR(100), 
  "photo4_credit" VARCHAR(100), 
  "photo4_path" VARCHAR(100), 
  "legal_auth_info" TEXT, 
  "org_relevant_rank" TEXT, 
  "additional_proj_info" TEXT, 
  "access_cons" VARCHAR(3), 
  "extent" TEXT, 
  "temp_extent" TEXT, 
  "the_geom" "public"."geometry", 
  "existing_proj" SMALLINT, 
  "existing_proj_info" TEXT, 
  "compensatory_mitigation" TEXT, 
  "exist_habitats_species" VARCHAR(6), 
  "pm_zip" VARCHAR(20), 
  "id" SERIAL, 
  "the_geom_pt" "public"."geometry", 
  "centroid_x" VARCHAR(256), 
  "centroid_y" VARCHAR(256), 
  "acres" DOUBLE PRECISION, 
  "state_fips" VARCHAR(32), 
  "cong_dist" VARCHAR(255)
) WITHOUT OIDS;

COMMENT ON COLUMN "public"."submit_data"."temp_extent"
IS 'a cleaned extent that postgis can use';

COMMENT ON COLUMN "public"."submit_data"."the_geom"
IS 'PostGIS geometry column';

COMMENT ON COLUMN "public"."submit_data"."the_geom_pt"
IS 'centroid geometry';

COMMENT ON COLUMN "public"."submit_data"."centroid_x"
IS 'x value of centroid';

COMMENT ON COLUMN "public"."submit_data"."centroid_y"
IS 'y value of centroid';

COMMENT ON COLUMN "public"."submit_data"."cong_dist"
IS 'auto populated congressional districts';

CREATE UNIQUE INDEX "submit_data2_pkey" ON "public"."submit_data"
  USING btree ("id");

CREATE TRIGGER "mk_the_geom2" AFTER INSERT 
ON "public"."submit_data" FOR EACH ROW 
EXECUTE PROCEDURE "public"."mk_the_geom2"();

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