data for debugging mapserver hanging processes

gistfile1.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = arctic_gregc, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: shapefile_12707; Type: TABLE; Schema: arctic_gregc; Owner: owner_arctic_gregc; Tablespace: 
--

CREATE TABLE shapefile_12707 (
    gid integer NOT NULL,
    id character varying(50),
    textlink character varying(50),
    spcode character varying(33),
    et_source character varying(254),
    objectid numeric,
    spls_label character varying(50),
    layername character varying(50),
    sptype character varying(20),
    gp_f_sp_ls character varying(50),
    family character varying(30),
    famcode numeric,
    indexnames character varying(100),
    treelevel numeric,
    gp_f_sp character varying(50),
    layerid numeric,
    fmp_area character varying(10),
    fmp character varying(20),
    lsdesc character varying(50),
    lscode numeric,
    lifestage character varying(5),
    fmp_sp_ls_ character varying(50),
    fmp_sp_ls character varying(50),
    spdesc character varying(50),
    fillcolor character varying(12),
    splabel character varying(50),
    lslabel character varying(50),
    area numeric,
    len numeric,
    web_geomet character varying(254),
    the_geom postgis.geometry(MultiPolygon,4019),
    web_geometry postgis.geometry,
    CONSTRAINT enforce_geotype_the_geom CHECK (((postgis.geometrytype(the_geom) = 'MULTIPOLYGON'::text) OR (the_geom IS NULL))),
    CONSTRAINT enforce_geotype_web_geometry CHECK (((postgis.geometrytype(web_geometry) = 'MULTIPOLYGON'::text) OR (web_geometry IS NULL))),
    CONSTRAINT enforce_srid_the_geom CHECK ((postgis.st_srid(the_geom) = 4019)),
    CONSTRAINT enforce_srid_web_geometry CHECK ((postgis.st_srid(web_geometry) = 900913))
);


ALTER TABLE arctic_gregc.shapefile_12707 OWNER TO owner_arctic_gregc;

--
-- Name: shapefile_12707_gid_seq; Type: SEQUENCE; Schema: arctic_gregc; Owner: owner_arctic_gregc
--

CREATE SEQUENCE shapefile_12707_gid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE arctic_gregc.shapefile_12707_gid_seq OWNER TO owner_arctic_gregc;

--
-- Name: shapefile_12707_gid_seq; Type: SEQUENCE OWNED BY; Schema: arctic_gregc; Owner: owner_arctic_gregc
--

ALTER SEQUENCE shapefile_12707_gid_seq OWNED BY shapefile_12707.gid;


--
-- Name: shapefile_12707_gid_seq; Type: SEQUENCE SET; Schema: arctic_gregc; Owner: owner_arctic_gregc
--

SELECT pg_catalog.setval('shapefile_12707_gid_seq', 1, true);


--
-- Name: gid; Type: DEFAULT; Schema: arctic_gregc; Owner: owner_arctic_gregc
--

ALTER TABLE ONLY shapefile_12707 ALTER COLUMN gid SET DEFAULT nextval('shapefile_12707_gid_seq'::regclass);


--
-- Data for Name: shapefile_12707; Type: TABLE DATA; Schema: arctic_gregc; Owner: owner_arctic_gregc
--

INSERT INTO shapefile_12707 VALUES (1, 'BSAI Crab_CRAB_KG_M', 'BSAI Crab.htm#CRAB_KG', 'CRAB_KG', 'f:\new_efh_spec_shapes\golden kc_95', 14.0000000000, 'Golden King Crab', 'golden_king_crab', 'Crab', 'Crab_1_CRAB_KG', 'King Crab', 1.0000000000, 'BSAI Crab, Golden King Crab, Mature', 1.0000000000, 'Crab, 1, CRAB_KG', 3.0000000000, 'BSAI', 'BSAI Crab', 'Mature', 6.0000000000, 'M', 'BSAI Crab, Golden Kin, 6', 'BSAI Crab, Golden Kin, 6', 'Golden King Crab', '255,255,0', 'Golden King Crab', 'Mature', 43646727358.9000015259, 6469517.6795899998, '010600002031BF0D00010000000103000000010000002400000093107C45F81B73C1C5D4165674095A41BA60DDED8B1B73C1A04AA4412C0B5A419E98D6EBFC1973C1DA0C3C2637165A41A9183111271A73C11BF55A410A255A41AA99A18C551B73C16EB828682B2F5A4193107C45F81B73C10C4C08C0CB305A4193107C45F8', '0106000020B30F0000020000000103000000010000002400000000000000008066C0148E51D6E1114A40BA1EFA6E807F66C0C580D4B41F134A40CBD82DA0AA7D66C0068E57A8181B4A40BF51FE3FDC7D66C03577B024C8254A4086009067407F66C0FE191D4F122D4A4000000000008066C0842416B53D2E4A4000000000008066C0EC7AF4247D454A408FF1359F3B7E66C0E2F905C99B454A4014156076487C66C0835789CA88444A40D9212C95E17866C0F763EF215A454A403DB16B44077566C0FAF99720C7484A4007E258E2FE7166C063993477F84D4A40B9B977603C7066C04F25560152524A4054DC2DD3136E66C00922678B7D574A401AA0F3AD386C66C00EC7D343855E4A4080AA0D0BB26A66C0A6F448522F624A404EDAF699616966C00A76D08FE7634A40B876AE1E116866C062FEAE0E205F4A40A1DDDECD4F6866C0D2F8BB9EF4574A40D8D3CC99E56966C054100E8B80524A404AFDF9971D6C66C03D08D4ED61494A40A8A852CCB86D66C00A310F3406434A404D091BD7CE6F66C0AFA85540503B4A40D5213B257E7266C07A57AE01FE324A400A8E6A23817366C08BAF4A35292A4A40CD435CE9F17266C0EAA5490A78224A40A36AB699527366C0D5C34F5E231B4A4008D2FA3D3D7466C0292197C8D3124A40DF2F39FAE97466C06C1C5CD8300B4A40FC528337967566C083C23B898D034A400904FBF9D37666C043FD760F34FC4940F3B549FDB77766C087783A0A1FF94940DBDBC32A6C7966C02E4C9D54D1F74940810BB4060E7D66C0F247D90CC2F9494000000000008066C0B4EFC18E96FB494000000000008066C0148E51D6E1114A400103000000010000001D0000000000000000806640802416B53D2E4A4036766FD0E17D6640D5D272F58C314A401276476AA77966407ED74CA7652F4A405812F97ED67766406F9705C13D254A40073E6529C77666401350EE3DDB1B4A40E996DDD85E756640F337AD7E98154A40DAF01DDA017366402F747EAEC40E4A402649C2FB1E7166403C20C6184D094A4058BD1B23216F664002632A2B67024A40934C5BEFE26D66408AD9A9BB48FC4940DB746AF3EF6D6640C9D40F19C7F54940B1EB4DB6966D66400D163A1699F0494034D9FF2E296D66409402593AF5ED4940B6EA0C5C916C66404BF2876154ED4940E9B338A9776B66401605969699EC49409D5B6E29DE656640DF764D04B5F04940EBE7B4DA4E636640F3ABAA056BF549401D7AE7E1966166401986648269FF4940FB1DAB7D75606640E0666EBD090A4A402B4ADB4C5E616640F163125B17154A407C652AFFCB636640FFAAC2BA7E1C4A4031219D838967664033BD2EE494264A40584B2693B36C66400A886BD4A02E4A40F9FA6377657266402AAE8A5FBD364A407671945793766640D5BEE7455D3C4A4015042A97D37A66403DFCBCBD98414A40E31C52E7167E66400A6034045C454A400000000000806640F07AF4247D454A400000000000806640802416B53D2E4A40', '010600002031BF0D00020000000103000000010000002400000093107C45F81B73C1C5D4165674095A41BA60DDED8B1B73C1A04AA4412C0B5A419E98D6EBFC1973C1DA0C3C2637165A41A9183111271A73C11BF55A410A255A41AA99A18C551B73C16EB828682B2F5A4193107C45F81B73C10C4C08C0CB305A4193107C45F81B73C135F297BE31515A4165220B11781A73C1F72AE1885C515A41BBB65721D01873C1CF895789DC4F5A413D66E97DEC1573C17592F8D900515A411F5457D0A61273C121BA08E9C9555A41FFAD716E131073C1BB772F440C5D5A4138BBBDD0940E73C160B0534522635A41E0316B88BF0C73C1AF52BDAB5F6A5A418019E2FD2B0B73C106BDFCA23A745A4160E86339E00973C1E2D215ED5E795A410785ED7BC20873C1D2A74AF9C87B5A416DD1CEB5A40773C177D780C813755A4169CBB0F2D90773C1F2802980066B5A414F385897320973C19C661A6963635A41971EDBFC140B73C151574C3AA2565A4195AB4B39720C73C1A15899D5C04D5A41FF1934C9370E73C17B04F552FF425A41D646B3837F1073C19D9E7B0568375A41CEC42A7A5B1173C1357BABA41F2B5A4126A1ACD5E11073C1C9FDB2DD70205A4112D4DAF3331173C1B1F0C5FE45165A41FD5EDA3BFB1173C1DF5A512CC30A5A4138AC1EF08D1273C1CE36F44233005A41F6849038201373C1020C6D73A6F55941731D25182E1473C147EA370683EB5941EE29EABEEF1473C111BADA9643E7594134D60A31621673C1C2EDF8D777E559412279D5EB771973C1A9441D3424E8594193107C45F81B73C12124EAE7A9EA594193107C45F81B73C1C5D4165674095A410103000000010000001D00000093107C45F81B7341094C08C0CB305A41A385F8CA2B1A734158458D6766355A41BE19D182941673412AEA9C6067325A41DBC0AEA709157341B6A273164A245A41AB6CF1352314734186F14BDF44175A4188330832F112734177FDAB4C980E5A41924F765FEF1073411A347A8525055A4161C0BF45550F7341BCC1FCBC96FD59419CFC8442A40D7341B7DE7A2910F45941C30BBA02960C734106FBFB859FEB5941F24AA510A10C73411CF41095A8E25941140B4946550C734172C6317087DB594160AB7E40F80B7341A25F81CEE5D759416268C84E770B734127339EA008D7594115CDA20F880A73414D90F2CC07D659412458FB96C6057341688D57DDADDB5941C5C671099A0373416EE865CB29E25941B8B25E5E24027341019206C6EFEF594141ED9A962E0173410BAD03699BFE5941E0E43650F401734110937D7CE50D5A412FE3045204047341E739B28427185A41303B4A8A31077341551A2E9A26265A41E873E35D940B7341FC6FD29B55315A41ACD8F48D6A1073416E50D8D19F3C5A41B41C4833F7137341DA7ADE5D76445A41BBA6337393177341A9C31DC2C24B5A4140C8B6E1581A73416D9E707B03515A4193107C45F81B734139F297BE31515A4193107C45F81B7341094C08C0CB305A41');


--
-- Name: shapefile_12707_pkey; Type: CONSTRAINT; Schema: arctic_gregc; Owner: owner_arctic_gregc; Tablespace: 
--

ALTER TABLE ONLY shapefile_12707
    ADD CONSTRAINT shapefile_12707_pkey PRIMARY KEY (gid);


--
-- Name: idx_shapefile_12707_web_geometry; Type: INDEX; Schema: arctic_gregc; Owner: owner_arctic_gregc; Tablespace: 
--

CREATE INDEX idx_shapefile_12707_web_geometry ON shapefile_12707 USING gist (web_geometry);

ALTER TABLE shapefile_12707 CLUSTER ON idx_shapefile_12707_web_geometry;


--
-- PostgreSQL database dump complete
--