GLHI Database HTML Dump

Table: submit_data

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

There is no description for table submit_data

Fields

Foreign Keys

There are no foreign keys for table submit_data

Checks

There are no check constraints for table submit_data

Indices

Triggers

Rules

There are no rules for table submit_data

Referenced

There are no tables referenced by table submit_data

Options

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