X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 78D659DCA5F for ; Thu, 23 Feb 2006 15:48:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57407-10 for ; Thu, 23 Feb 2006 15:48:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.207]) by postgresql.org (Postfix) with ESMTP id E21DC9DCA25 for ; Thu, 23 Feb 2006 15:48:53 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s12so105637wxc for ; Thu, 23 Feb 2006 11:48:54 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:mime-version:content-type; b=WmWnCrybCSReSTbAvuoRv8ydjvKaCYWOG5iZgdJPBqZ63qjmK9kfYavRWFbweZqMCUKXi+UifeorDL0W02J6v9F4V5LpS2bwfHOHftM1EUABi8rvhA8MbxGBedDxlgcT+H/6qtGGfw1BoYY+wBwsiWVF71u6lF1AlxqnzvtmcaQ= Received: by 10.70.12.8 with SMTP id 8mr37782wxl; Thu, 23 Feb 2006 11:48:54 -0800 (PST) Received: by 10.70.130.15 with HTTP; Thu, 23 Feb 2006 11:48:54 -0800 (PST) Message-ID: <67e0ca070602231148l17f4dcf8n3980fa69a936e2f4@mail.gmail.com> Date: Thu, 23 Feb 2006 13:48:54 -0600 From: "Sunanda Kumaraguru" To: pgsql-admin@postgresql.org Subject: ERROR: Cannot determine geometry type (empty table). Cc: "Ashok Samal" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_1441_1579084.1140724134679" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/285 X-Sequence-Number: 20706 ------=_Part_1441_1579084.1140724134679 Content-Type: multipart/alternative; boundary="----=_Part_1442_31670873.1140724134679" ------=_Part_1442_31670873.1140724134679 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ------=_Part_1442_31670873.1140724134679 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Hello Everyone,

Iam trying to use the postgis dumper.I g= et the follwing error. 

ERROR: Cannot determine geometry type (e= mpty table).

 

 Iam sending the sql file as an att= achment.

Any suggestions from your side would be = of great help to me.

Thanks

sunanda

 

 

 

 

 

 

 

 

 

 

 

------=_Part_1442_31670873.1140724134679-- ------=_Part_1441_1579084.1140724134679 Content-Type: text/plain; name=feb3.sql; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Attachment-Id: f_ek1hmjyb Content-Disposition: attachment; filename="feb3.sql" 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','SAL= ISBURY','41372793.7600', GeometryFromText('MULTIPOLYGON(((2= 55896.313590375 958162.370856 ,255890.433590375 958125.120856 ,255898.56359= 0375 957114.500856 ,255885.513590375 956537.560856 ,255873.923590375 956392= .060856 ,255895.873590375 955874.250856 ,256043.623590375 954259.190856 ,25= 6075.863590375 954045.940856 ,256081.763590375 953944.060856 ,256198.933590= 375 952961.620856 ,256239.093590375 952710.620856 ,256262.533590375 952634.= 250856 ,256252.763590375 952590.940856 ,256209.533590375 952593.620856 ,256= 178.893590375 952610.750856 ,256071.983590375 952635.560856 ,255980.2035903= 75 952674.870856 ,255756.373590375 952701.250856 ,255662.403590375 952695.4= 40856 ,255589.033590375 952657.250856 ,255515.953590375 952585.000856 ,2554= 77.933590375 952571.870856 ,255416.783590375 952597.060856 ,255388.59359037= 5 952622.250856 ,255352.973590375 952624.190856 ,255299.733590375 952616.62= 0856 ,255231.503590375 952574.560856 ,255145.673590375 952492.940856 ,25506= 2.153590375 952454.440856 ,255038.723590375 952527.810856 ,255013.043590375= 952558.060856 ,255015.253590375 952599.190856 ,255032.813590375 952629.750= 856 ,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.0008= 56 ,255325.723590375 952857.620856 ,255312.843590375 952883.250856 ,255261.= 903590375 952897.750856 ,255198.313590375 952899.870856 ,255200.593590375 9= 52931.000856 ,255220.753590375 952953.560856 ,255256.073590375 952981.69085= 6 ,255243.043590375 953027.310856 ,255244.983590375 953096.440856 ,255186.0= 03590375 953171.750856 ,255170.373590375 953210.310856 ,255146.723590375 95= 3316.690856 ,255148.653590375 953382.870856 ,255173.763590375 953423.620856= ,255249.703590375 953454.870856 ,255308.153590375 953457.620856 ,255410.06= 3590375 953420.620856 ,255478.643590375 953435.690856 ,255529.543590375 953= 421.190856 ,255577.753590375 953426.620856 ,255613.063590375 953454.690856 = ,255610.313590375 953480.620856 ,255594.923590375 953500.190856 ,255556.673= 590375 953520.120856 ,255498.113590375 953530.370856 ,255401.263590375 9535= 65.500856 ,255320.033590375 953569.060856 ,255218.073590375 953594.060856 ,= 255078.823590375 953536.870856 ,255058.973590375 953481.250856 ,255026.0935= 90375 953455.310856 ,255031.623590375 953407.370856 ,255060.203590375 95332= 8.190856 ,255060.613590375 953275.120856 ,255081.643590375 953188.690856 ,2= 55084.813590375 953114.690856 ,255057.343590375 953053.810856 ,255016.92359= 0375 953025.560856 ,254999.433590375 952992.060856 ,254992.313590375 952923= .810856 ,254974.753590375 952898.250856 ,254908.873590375 952880.250856 ,25= 4904.113590375 952834.120856 ,254871.613590375 952768.060856 ,254851.793590= 375 952699.440856 ,254824.143590375 952668.560856 ,254803.933590375 952657.= 940856 ,254745.573590375 952645.190856 ,254692.003590375 952674.620856 ,254= 353.903590375 952684.620856 ,254193.733590375 952703.870856 ,254099.8635903= 75 952693.060856 ,253889.813590375 952584.690856 ,253707.313590375 952522.2= 50856 ,253557.733590375 952489.750856 ,253433.223590375 952486.060856 ,2533= 08.983590375 952452.370856 ,253220.433590375 952408.690856 ,253162.34359037= 5 952359.940856 ,253142.113590375 952354.310856 ,252957.543590375 952238.69= 0856 ,252848.703590375 952187.440856 ,252493.723590375 952089.810856 ,25243= 8.143590375 952061.190856 ,252407.843590375 952031.190856 ,252393.113590375= 951972.750856 ,252342.703590375 951923.190856 ,252226.153590375 951881.690= 856 ,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.4408= 56 ,251355.453590375 952098.000856 ,251352.323590375 952162.000856 ,251367.= 373590375 952192.500856 ,251364.323590375 952251.440856 ,251341.343590375 9= 52265.750856 ,251287.863590375 952281.190856 ,251251.923590375 952336.12085= 6 ,251248.533590375 952428.120856 ,251223.013590375 952450.370856 ,251151.7= 93590375 952462.310856 ,251156.983590375 952017.440856 ,250839.983590375 95= 2471.060856 ,250727.093590375 952624.370856 ,250703.543590375 952657.560856= ,250667.433590375 952686.690856 ,250606.863590375 952733.750856 ,250533.01= 3590375 952776.060856 ,250433.113590375 952821.690856 ,250315.343590375 952= 872.060856 ,250193.283590375 952915.310856 ,250099.733590375 952958.500856 = ,250039.393590375 952993.500856 ,249997.703590375 953016.190856 ,249950.653= 590375 953052.690856 ,249897.653590375 953098.620856 ,249862.003590375 9531= 37.310856 ,249821.073590375 953184.060856 ,249779.283590375 953242.310856 ,= 249746.473590375 953295.620856 ,249716.823590375 953347.750856 ,249679.2235= 90375 953418.750856 ,249647.063590375 953472.060856 ,249578.033590375 95355= 8.310856 ,249495.923590375 953634.120856 ,249354.373590375 953729.750856 ,2= 49226.283590375 953788.120856 ,249161.283590375 953801.440856 ,249052.25359= 0375 953829.690856 ,248941.483590375 953845.940856 ,248823.223590375 953858= .750856 ,248708.733590375 953867.560856 ,249058.253590375 955369.750856 ,24= 8181.983590375 958442.120856 ,247828.473590375 959732.500856 ,248719.543590= 375 959747.440856 ,250194.823590375 959319.250856 ,251107.143590375 958608.= 940856 ,251305.263590375 958463.060856 ,253306.903590375 956899.120856 ,254= 202.093590375 957335.190856 ,254777.703590375 957790.000856 ,255542.7835903= 75 958135.940856 ,255809.143590375 958157.000856 ,255896.313590375 958162.3= 70856 )))',2249) ); INSERT INTO "feb3" (gid,"town" , "shape_area", "the_geom") VALUES ('1','AME= SBURY','35563042.6078', GeometryFromText('MULTIPOLYGON(((2= 47828.473590375 959732.500856 ,248181.983590375 958442.120856 ,249058.25359= 0375 955369.750856 ,248708.733590375 953867.560856 ,248619.473590375 953863= .560856 ,248495.263590375 953855.370856 ,248433.233590375 953849.060856 ,24= 8363.433590375 953848.310856 ,248315.153590375 953851.750856 ,248211.183590= 375 953878.870856 ,248139.593590375 953904.750856 ,248092.703590375 953934.= 310856 ,248045.113590375 953965.750856 ,248001.173590375 954003.560856 ,247= 968.563590375 954046.750856 ,247946.813590375 954086.940856 ,247928.9035903= 75 954124.690856 ,247909.283590375 954184.620856 ,247897.043590375 954255.5= 00856 ,247879.323590375 954346.560856 ,247862.903590375 954405.940856 ,2478= 44.653590375 954460.190856 ,247825.873590375 954509.370856 ,247797.98359037= 5 954571.690856 ,247772.423590375 954610.560856 ,247750.973590375 954635.50= 0856 ,247726.313590375 954662.310856 ,247676.143590375 954696.870856 ,24764= 9.843590375 954709.690856 ,247601.423590375 954719.500856 ,247548.123590375= 954720.940856 ,247496.263590375 954712.940856 ,247443.873590375 954698.560= 856 ,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.1208= 56 ,246904.473590375 954237.500856 ,246772.953590375 954029.120856 ,246701.= 433590375 953927.310856 ,246626.613590375 953831.250856 ,246582.483590375 9= 53787.120856 ,246541.003590375 953736.750856 ,246503.203590375 953691.56085= 6 ,246467.893590375 953650.190856 ,246438.433590375 953600.690856 ,246413.1= 43590375 953534.810856 ,246377.293590375 953425.500856 ,246351.263590375 95= 3334.190856 ,246322.923590375 953260.560856 ,246304.723590375 953220.870856= ,246290.573590375 953198.310856 ,246257.203590375 953155.750856 ,246201.31= 3590375 953094.940856 ,246139.093590375 953035.250856 ,246077.533590375 952= 974.370856 ,246036.563590375 952929.060856 ,246004.073590375 952875.060856 = ,245965.973590375 952813.310856 ,245930.393590375 952754.190856 ,245905.233= 590375 952711.120856 ,245880.623590375 952674.440856 ,245848.253590375 9526= 43.310856 ,245795.173590375 952601.620856 ,245770.753590375 952587.310856 ,= 245610.653590375 952503.940856 ,245485.043590375 952439.810856 ,245424.7635= 90375 952410.060856 ,245383.843590375 952393.940856 ,245325.823590375 95237= 6.940856 ,245209.543590375 952353.620856 ,245140.653590375 952341.440856 ,2= 44982.543590375 952316.690856 ,244729.903590375 952290.690856 ,244539.25359= 0375 952274.750856 ,244333.283590375 952263.000856 ,244041.703590375 952281= .310856 ,243868.763590375 952329.250856 ,243690.233590375 952403.810856 ,24= 3579.253590375 952463.810856 ,243410.003590375 952562.750856 ,242524.593590= 375 955050.120856 ,240904.873590375 956656.190856 ,240469.953590375 957090.= 120856 ,240901.813590375 957177.120856 ,243551.363590375 957713.940856 ,244= 813.643590375 958419.870856 ,246616.543590375 959540.190856 ,247828.4735903= 75 959732.500856 )))',2249) ); INSERT INTO "feb3" (gid,"town" , "shape_area", "the_geom") VALUES ('2','MER= RIMAC','23010189.9612' , GeometryFromText('MULTIPOLYGON(((2= 40469.953590375 957090.120856 ,240904.873590375 956656.190856 ,242524.59359= 0375 955050.120856 ,243410.003590375 952562.750856 ,243324.683590375 952624= .310856 ,243275.173590375 952658.250856 ,243232.113590375 952684.690856 ,24= 3184.033590375 952707.870856 ,243142.473590375 952725.500856 ,243099.753590= 375 952735.440856 ,242967.363590375 952756.370856 ,242836.323590375 952772.= 190856 ,242728.153590375 952785.940856 ,242627.123590375 952794.120856 ,242= 554.843590375 952792.060856 ,242492.733590375 952788.250856 ,242381.4235903= 75 952772.120856 ,242297.513590375 952748.250856 ,242229.313590375 952732.2= 50856 ,242107.253590375 952713.310856 ,242023.233590375 952695.000856 ,2419= 36.293590375 952664.620856 ,241862.073590375 952633.060856 ,241745.26359037= 5 952573.750856 ,241662.313590375 952532.870856 ,241608.173590375 952513.50= 0856 ,241557.703590375 952500.560856 ,241484.923590375 952489.310856 ,24141= 5.783590375 952488.810856 ,241368.113590375 952490.940856 ,241319.953590375= 952487.190856 ,241292.753590375 952482.940856 ,241230.953590375 952463.060= 856 ,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.8708= 56 ,240882.003590375 952148.620856 ,240864.433590375 952123.690856 ,240847.= 483590375 952099.440856 ,240830.563590375 952072.560856 ,240819.973590375 9= 52048.310856 ,240812.543590375 952026.000856 ,240805.153590375 951997.37085= 6 ,240797.153590375 951969.310856 ,240792.283590375 951941.310856 ,240789.3= 43590375 951908.870856 ,240787.223590375 951854.810856 ,240783.173590375 95= 1805.250856 ,240781.653590375 951752.500856 ,240782.613590375 951711.810856= ,240787.403590375 951664.190856 ,240790.903590375 951617.810856 ,240795.67= 3590375 951575.940856 ,240802.263590375 951541.060856 ,240811.483590375 951= 499.120856 ,240816.143590375 951471.250856 ,240825.843590375 951442.060856 = ,240842.653590375 951399.620856 ,240867.793590375 951342.000856 ,240900.643= 590375 951274.250856 ,240928.613590375 951223.250856 ,239172.473590375 9522= 13.500856 ,236472.093590375 953725.190856 ,237210.783590375 955440.810856 ,= 237766.043590375 956037.560856 ,238017.613590375 956302.750856 ,238317.5335= 90375 956626.060856 ,239540.783590375 956902.870856 ,240469.953590375 95709= 0.120856 )))',2249) ); ALTER TABLE ONLY "feb3" ADD CONSTRAINT "feb3_pkey" PRIMARY KEY (gid); SELECT setval ('"feb3_gid_seq"', 3, true); END; ------=_Part_1441_1579084.1140724134679--