gistfile1.txt

SET CLIENT_ENCODING TO UTF8;
SET SEARCH_PATH TO public, postgis, topology;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "shapefile_12707" (gid serial,
"id" varchar(50),
"textlink" varchar(50),
"spcode" varchar(33),
"et_source" varchar(254),
"objectid" numeric,
"spls_label" varchar(50),
"layername" varchar(50),
"sptype" varchar(20),
"gp_f_sp_ls" varchar(50),
"family" varchar(30),
"famcode" numeric,
"indexnames" varchar(100),
"treelevel" numeric,
"gp_f_sp" varchar(50),
"layerid" numeric,
"fmp_area" varchar(10),
"fmp" varchar(20),
"lsdesc" varchar(50),
"lscode" numeric,
"lifestage" varchar(5),
"fmp_sp_ls_" varchar(50),
"fmp_sp_ls" varchar(50),
"spdesc" varchar(50),
"fillcolor" varchar(12),
"splabel" varchar(50),
"lslabel" varchar(50),
"area" numeric,
"len" numeric,
"web_geomet" varchar(254),
"web_geo_01" varchar(254));
ALTER TABLE "shapefile_12707" ADD PRIMARY KEY (gid);
SELECT AddGeometryColumn('','shapefile_12707','the_geom','4326','MULTIPOLYGON',2);
INSERT INTO "shapefile_12707" ("id","textlink","spcode","et_source","objectid","spls_label","layername","sptype","gp_f_sp_ls","family","famcode","indexnames","treelevel","gp_f_sp","layerid","fmp_area","fmp","lsdesc","lscode","lifestage","fmp_sp_ls_","fmp_sp_ls","spdesc","fillcolor","splabel","lslabel","area","len","web_geomet","web_geo_01",the_geom) VALUES ('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','010600002031BF0D00020000000103000000010000002400000093107C45F81B73C1C5D4165674095A41BA60DDED8B1B73C1A04AA4412C0B5A419E98D6EBFC1973C1DA0C3C2637165A41A9183111271A73C11BF55A410A255A41AA99A18C551B73C16EB828682B2F5A4193107C45F81B73C10C4C08C0CB305A4193107C45F8','0106000020E6100000020000000103000000010000002400000000000000008066C0148E51D6E1114A40BA1EFA6E807F66C0C580D4B41F134A40CBD82DA0AA7D66C0068E57A8181B4A40BF51FE3FDC7D66C03577B024C8254A4086009067407F66C0FE191D4F122D4A4000000000008066C0842416B53D2E4A4000000000008066C0EC7AF4247D454A408FF1359F3B7E66C0E2F905C99B454A4014156076487C66C0835789CA88444A40D9212C95E17866C0F763EF215A454A403DB16B44077566C0FAF99720C7484A4007E258E2FE7166C063993477F84D4A40B9B977603C7066C04F25560152524A4054DC2DD3136E66C00922678B7D574A401AA0F3AD386C66C00EC7D343855E4A4080AA0D0BB26A66C0A6F448522F624A404EDAF699616966C00A76D08FE7634A40B876AE1E116866C062FEAE0E205F4A40A1DDDECD4F6866C0D2F8BB9EF4574A40D8D3CC99E56966C054100E8B80524A404AFDF9971D6C66C03D08D4ED61494A40A8A852CCB86D66C00A310F3406434A404D091BD7CE6F66C0AFA85540503B4A40D5213B257E7266C07A57AE01FE324A400A8E6A23817366C08BAF4A35292A4A40CD435CE9F17266C0EAA5490A78224A40A36AB699527366C0D5C34F5E231B4A4008D2FA3D3D7466C0292197C8D3124A40DF2F39FAE97466C06C1C5CD8300B4A40FC528337967566C083C23B898D034A400904FBF9D37666C043FD760F34FC4940F3B549FDB77766C087783A0A1FF94940DBDBC32A6C7966C02E4C9D54D1F74940810BB4060E7D66C0F247D90CC2F9494000000000008066C0B4EFC18E96FB494000000000008066C0148E51D6E1114A400103000000010000001D0000000000000000806640802416B53D2E4A4036766FD0E17D6640D5D272F58C314A401276476AA77966407ED74CA7652F4A405812F97ED67766406F9705C13D254A40073E6529C77666401350EE3DDB1B4A40E996DDD85E756640F337AD7E98154A40DAF01DDA017366402F747EAEC40E4A402649C2FB1E7166403C20C6184D094A4058BD1B23216F664002632A2B67024A40934C5BEFE26D66408AD9A9BB48FC4940DB746AF3EF6D6640C9D40F19C7F54940B1EB4DB6966D66400D163A1699F0494034D9FF2E296D66409402593AF5ED4940B6EA0C5C916C66404BF2876154ED4940E9B338A9776B66401605969699EC49409D5B6E29DE656640DF764D04B5F04940EBE7B4DA4E636640F3ABAA056BF549401D7AE7E1966166401986648269FF4940FB1DAB7D75606640E0666EBD090A4A402B4ADB4C5E616640F163125B17154A407C652AFFCB636640FFAAC2BA7E1C4A4031219D838967664033BD2EE494264A40584B2693B36C66400A886BD4A02E4A40F9FA6377657266402AAE8A5FBD364A407671945793766640D5BEE7455D3C4A4015042A97D37A66403DFCBCBD98414A40E31C52E7167E66400A6034045C454A400000000000806640F07AF4247D454A400000000000806640802416B53D2E4A40');

alter table shapefile_12707 add column web_geometry geometry;
update shapefile_12707 set web_geometry = ST_transform(the_geom,900913);
create index idx_shapefile_12707_web_geometry on shapefile_12707 using GIST (web_geometry);
cluster idx_shapefile_12707_web_geometry ON shapefile_12707;
analyze shapefile_12707;

COMMIT;