Hello Everyone,
Iam trying to use the postgis dumper.I get the follwing error.
ERROR: Cannot determine geometry type (empty table).
Iam sending the sql file as an attachment.
Any suggestions from your side would be of great help to me.
Thanks
sunanda
BEGIN;
CREATE TABLE "feb3" (gid serial, "town" varchar, "shape_area" numeric);
SELECT AddGeometryColumn('','feb3','the_geom','2249','MULTIPOLYGON',2);
INSERT INTO "feb3" (gid,"town" , "shape_area", "the_geom") VALUES ('0','SALISBURY','41372793.7600', GeometryFromText('MULTIPOLYGON(((255896.313590375 958162.370856 ,255890.433590375 958125.120856 ,255898.563590375 957114.500856 ,255885.513590375 956537.560856 ,255873.923590375 956392.060856 ,255895.873590375 955874.250856 ,256043.623590375 954259.190856 ,256075.863590375 954045.940856 ,256081.763590375 953944.060856 ,256198.933590375 952961.620856 ,256239.093590375 952710.620856 ,256262.533590375 952634.250856 ,256252.763590375 952590.940856 ,256209.533590375 952593.620856 ,256178.893590375 952610.750856 ,256071.983590375 952635.560856 ,255980.203590375 952674.870856 ,255756.373590375 952701.250856 ,255662.403590375 952695.440856 ,255589.033590375 952657.250856 ,255515.953590375 952585.000856 ,255477.933590375 952571.870856 ,255416.783590375 952597.060856 ,255388.593590375 952622.250856 ,255352.973590375 952624.190856 ,255299.733590375 952616.620856 ,255231.503590375 952574.560856 ,255145.673590375 952492.940856 ,255062.153590375 952454.440856 ,255038.723590375 952527.810856 ,255013.043590375 952558.060856 ,255015.253590375 952599.190856 ,255032.813590375 952629.750856 ,255027.203590375 952697.620856 ,255047.323590375 952718.250856 ,255126.043590375 952734.560856 ,255143.643590375 952750.120856 ,255196.873590375 952762.690856 ,255255.233590375 952778.440856 ,255272.683590375 952817.000856 ,255325.723590375 952857.620856 ,255312.843590375 952883.250856 ,255261.903590375 952897.750856 ,255198.313590375 952899.870856 ,255200.593590375 952931.000856 ,255220.753590375 952953.560856 ,255256.073590375 952981.690856 ,255243.043590375 953027.310856 ,255244.983590375 953096.440856 ,255186.003590375 953171.750856 ,255170.373590375 953210.310856 ,255146.723590375 953316.690856 ,255148.653590375 953382.870856 ,255173.763590375 953423.620856 ,255249.703590375 953454.870856 ,255308.153590375 953457.620856 ,255410.063590375 953420.620856 ,255478.643590375 953435.690856 ,255529.543590375 953421.190856 ,255577.753590375 953426.620856 ,255613.063590375 953454.690856 ,255610.313590375 953480.620856 ,255594.923590375 953500.190856 ,255556.673590375 953520.120856 ,255498.113590375 953530.370856 ,255401.263590375 953565.500856 ,255320.033590375 953569.060856 ,255218.073590375 953594.060856 ,255078.823590375 953536.870856 ,255058.973590375 953481.250856 ,255026.093590375 953455.310856 ,255031.623590375 953407.370856 ,255060.203590375 953328.190856 ,255060.613590375 953275.120856 ,255081.643590375 953188.690856 ,255084.813590375 953114.690856 ,255057.343590375 953053.810856 ,255016.923590375 953025.560856 ,254999.433590375 952992.060856 ,254992.313590375 952923.810856 ,254974.753590375 952898.250856 ,254908.873590375 952880.250856 ,254904.113590375 952834.120856 ,254871.613590375 952768.060856 ,254851.793590375 952699.440856 ,254824.143590375 952668.560856 ,254803.933590375 952657.940856 ,254745.573590375 952645.190856 ,254692.003590375 952674.620856 ,254353.903590375 952684.620856 ,254193.733590375 952703.870856 ,254099.863590375 952693.060856 ,253889.813590375 952584.690856 ,253707.313590375 952522.250856 ,253557.733590375 952489.750856 ,253433.223590375 952486.060856 ,253308.983590375 952452.370856 ,253220.433590375 952408.690856 ,253162.343590375 952359.940856 ,253142.113590375 952354.310856 ,252957.543590375 952238.690856 ,252848.703590375 952187.440856 ,252493.723590375 952089.810856 ,252438.143590375 952061.190856 ,252407.843590375 952031.190856 ,252393.113590375 951972.750856 ,252342.703590375 951923.190856 ,252226.153590375 951881.690856 ,252109.753590375 951815.190856 ,252051.423590375 951804.440856 ,252033.753590375 951793.870856 ,251911.673590375 951808.250856 ,251812.343590375 951840.370856 ,251417.173590375 952004.750856 ,251371.073590375 952052.440856 ,251355.453590375 952098.000856 ,251352.323590375 952162.000856 ,251367.373590375 952192.500856 ,251364.323590375 952251.440856 ,251341.343590375 952265.750856 ,251287.863590375 952281.190856 ,251251.923590375 952336.120856 ,251248.533590375 952428.120856 ,251223.013590375 952450.370856 ,251151.793590375 952462.310856 ,251156.983590375 952017.440856 ,250839.983590375 952471.060856 ,250727.093590375 952624.370856 ,250703.543590375 952657.560856 ,250667.433590375 952686.690856 ,250606.863590375 952733.750856 ,250533.013590375 952776.060856 ,250433.113590375 952821.690856 ,250315.343590375 952872.060856 ,250193.283590375 952915.310856 ,250099.733590375 952958.500856 ,250039.393590375 952993.500856 ,249997.703590375 953016.190856 ,249950.653590375 953052.690856 ,249897.653590375 953098.620856 ,249862.003590375 953137.310856 ,249821.073590375 953184.060856 ,249779.283590375 953242.310856 ,249746.473590375 953295.620856 ,249716.823590375 953347.750856 ,249679.223590375 953418.750856 ,249647.063590375 953472.060856 ,249578.033590375 953558.310856 ,249495.923590375 953634.120856 ,249354.373590375 953729.750856 ,249226.283590375 953788.120856 ,249161.283590375 953801.440856 ,249052.253590375 953829.690856 ,248941.483590375 953845.940856 ,248823.223590375 953858.750856 ,248708.733590375 953867.560856 ,249058.253590375 955369.750856 ,248181.983590375 958442.120856 ,247828.473590375 959732.500856 ,248719.543590375 959747.440856 ,250194.823590375 959319.250856 ,251107.143590375 958608.940856 ,251305.263590375 958463.060856 ,253306.903590375 956899.120856 ,254202.093590375 957335.190856 ,254777.703590375 957790.000856 ,255542.783590375 958135.940856 ,255809.143590375 958157.000856 ,255896.313590375 958162.370856 )))',2249) );
INSERT INTO "feb3" (gid,"town" , "shape_area", "the_geom") VALUES ('1','AMESBURY','35563042.6078', GeometryFromText('MULTIPOLYGON(((247828.473590375 959732.500856 ,248181.983590375 958442.120856 ,249058.253590375 955369.750856 ,248708.733590375 953867.560856 ,248619.473590375 953863.560856 ,248495.263590375 953855.370856 ,248433.233590375 953849.060856 ,248363.433590375 953848.310856 ,248315.153590375 953851.750856 ,248211.183590375 953878.870856 ,248139.593590375 953904.750856 ,248092.703590375 953934.310856 ,248045.113590375 953965.750856 ,248001.173590375 954003.560856 ,247968.563590375 954046.750856 ,247946.813590375 954086.940856 ,247928.903590375 954124.690856 ,247909.283590375 954184.620856 ,247897.043590375 954255.500856 ,247879.323590375 954346.560856 ,247862.903590375 954405.940856 ,247844.653590375 954460.190856 ,247825.873590375 954509.370856 ,247797.983590375 954571.690856 ,247772.423590375 954610.560856 ,247750.973590375 954635.500856 ,247726.313590375 954662.310856 ,247676.143590375 954696.870856 ,247649.843590375 954709.690856 ,247601.423590375 954719.500856 ,247548.123590375 954720.940856 ,247496.263590375 954712.940856 ,247443.873590375 954698.560856 ,247383.983590375 954680.190856 ,247336.223590375 954657.690856 ,247280.893590375 954633.690856 ,247229.573590375 954598.370856 ,247172.613590375 954559.750856 ,247086.813590375 954474.870856 ,247008.753590375 954383.120856 ,246904.473590375 954237.500856 ,246772.953590375 954029.120856 ,246701.433590375 953927.310856 ,246626.613590375 953831.250856 ,246582.483590375 953787.120856 ,246541.003590375 953736.750856 ,246503.203590375 953691.560856 ,246467.893590375 953650.190856 ,246438.433590375 953600.690856 ,246413.143590375 953534.810856 ,246377.293590375 953425.500856 ,246351.263590375 953334.190856 ,246322.923590375 953260.560856 ,246304.723590375 953220.870856 ,246290.573590375 953198.310856 ,246257.203590375 953155.750856 ,246201.313590375 953094.940856 ,246139.093590375 953035.250856 ,246077.533590375 952974.370856 ,246036.563590375 952929.060856 ,246004.073590375 952875.060856 ,245965.973590375 952813.310856 ,245930.393590375 952754.190856 ,245905.233590375 952711.120856 ,245880.623590375 952674.440856 ,245848.253590375 952643.310856 ,245795.173590375 952601.620856 ,245770.753590375 952587.310856 ,245610.653590375 952503.940856 ,245485.043590375 952439.810856 ,245424.763590375 952410.060856 ,245383.843590375 952393.940856 ,245325.823590375 952376.940856 ,245209.543590375 952353.620856 ,245140.653590375 952341.440856 ,244982.543590375 952316.690856 ,244729.903590375 952290.690856 ,244539.253590375 952274.750856 ,244333.283590375 952263.000856 ,244041.703590375 952281.310856 ,243868.763590375 952329.250856 ,243690.233590375 952403.810856 ,243579.253590375 952463.810856 ,243410.003590375 952562.750856 ,242524.593590375 955050.120856 ,240904.873590375 956656.190856 ,240469.953590375 957090.120856 ,240901.813590375 957177.120856 ,243551.363590375 957713.940856 ,244813.643590375 958419.870856 ,246616.543590375 959540.190856 ,247828.473590375 959732.500856 )))',2249) );
INSERT INTO "feb3" (gid,"town" , "shape_area", "the_geom") VALUES ('2','MERRIMAC','23010189.9612' , GeometryFromText('MULTIPOLYGON(((240469.953590375 957090.120856 ,240904.873590375 956656.190856 ,242524.593590375 955050.120856 ,243410.003590375 952562.750856 ,243324.683590375 952624.310856 ,243275.173590375 952658.250856 ,243232.113590375 952684.690856 ,243184.033590375 952707.870856 ,243142.473590375 952725.500856 ,243099.753590375 952735.440856 ,242967.363590375 952756.370856 ,242836.323590375 952772.190856 ,242728.153590375 952785.940856 ,242627.123590375 952794.120856 ,242554.843590375 952792.060856 ,242492.733590375 952788.250856 ,242381.423590375 952772.120856 ,242297.513590375 952748.250856 ,242229.313590375 952732.250856 ,242107.253590375 952713.310856 ,242023.233590375 952695.000856 ,241936.293590375 952664.620856 ,241862.073590375 952633.060856 ,241745.263590375 952573.750856 ,241662.313590375 952532.870856 ,241608.173590375 952513.500856 ,241557.703590375 952500.560856 ,241484.923590375 952489.310856 ,241415.783590375 952488.810856 ,241368.113590375 952490.940856 ,241319.953590375 952487.190856 ,241292.753590375 952482.940856 ,241230.953590375 952463.060856 ,241179.433590375 952437.750856 ,241132.423590375 952409.370856 ,241088.073590375 952373.560856 ,241034.513590375 952322.810856 ,240975.613590375 952255.940856 ,240931.003590375 952206.690856 ,240909.623590375 952181.870856 ,240882.003590375 952148.620856 ,240864.433590375 952123.690856 ,240847.483590375 952099.440856 ,240830.563590375 952072.560856 ,240819.973590375 952048.310856 ,240812.543590375 952026.000856 ,240805.153590375 951997.370856 ,240797.153590375 951969.310856 ,240792.283590375 951941.310856 ,240789.343590375 951908.870856 ,240787.223590375 951854.810856 ,240783.173590375 951805.250856 ,240781.653590375 951752.500856 ,240782.613590375 951711.810856 ,240787.403590375 951664.190856 ,240790.903590375 951617.810856 ,240795.673590375 951575.940856 ,240802.263590375 951541.060856 ,240811.483590375 951499.120856 ,240816.143590375 951471.250856 ,240825.843590375 951442.060856 ,240842.653590375 951399.620856 ,240867.793590375 951342.000856 ,240900.643590375 951274.250856 ,240928.613590375 951223.250856 ,239172.473590375 952213.500856 ,236472.093590375 953725.190856 ,237210.783590375 955440.810856 ,237766.043590375 956037.560856 ,238017.613590375 956302.750856 ,238317.533590375 956626.060856 ,239540.783590375 956902.870856 ,240469.953590375 957090.120856 )))',2249) );
ALTER TABLE ONLY "feb3" ADD CONSTRAINT "feb3_pkey" PRIMARY KEY (gid);
SELECT setval ('"feb3_gid_seq"', 3, true);
END;
