[postgis-users] Cast geometry as geography

[Andreas Forø Tollefsen]

Hmm. I tried to cast as geography with some of the intersecting
geometries, but this did not reproduce the error.

SELECT SUM(ST_Length(ST_Intersection(
'01050000E0E61000000100000001020000C031000000000000C0C2D250C000000000FF494BC00000000000000000FFFFFFFFFFFFEFFF000000A0B8D450C000000040A44A4BC00000000000000000FFFFFFFFFFFFEFFF000000E033D650C0000000E00B4C4BC00000000000000000FFFFFFFFFFFFEFFF000000406FD750C000000020D64C4BC00000000000000000FFFFFFFFFFFFEFFF00000060F1D850C0000000802E4E4BC00000000000000000FFFFFFFFFFFFEFFF000000008CD950C0000000E0714E4BC00000000000000000FFFFFFFFFFFFEFFF000000807CDF50C0000000C0AB4E4BC00000000000000000FFFFFFFFFFFFEFFF000000A005E150C000000060BA4E4BC00000000000000000FFFFFFFFFFFFEFFF000000E03AE250C000000020944E4BC00000000000000000FFFFFFFFFFFFEFFF000000A0A3E350C000000000414E4BC00000000000000000FFFFFFFFFFFFEFFF000000E099E550C000000000504D4BC00000000000000000FFFFFFFFFFFFEFFF00000040A3E750C000000000A24C4BC00000000000000000FFFFFFFFFFFFEFFF00000060C8EA50C0000000C0804C4BC00000000000000000FFFFFFFFFFFFEFFF00000000D7EB50C000000060AC4C4BC00000000000000000FFFFFFFFFFFFEFFF00000000FCEC50C0000000E01A4D4BC00000000000000000FFFFFFFFFFFFEFFF00000000C1ED50C000000000654D4BC00000000000000000FFFFFFFFFFFFEFFF000000606FEE50C000000040F24D4BC00000000000000000FFFFFFFFFFFFEFFF0000008058EF50C0000000C06E4F4BC00000000000000000FFFFFFFFFFFFEFFF00000080F5EF50C00000000017524BC00000000000000000FFFFFFFFFFFFEFFF000000C070F050C0000000E0F6524BC00000000000000000FFFFFFFFFFFFEFFF0000006070F250C0000000A03B554BC00000000000000000FFFFFFFFFFFFEFFF000000C0B4F350C00000006009574BC00000000000000000FFFFFFFFFFFFEFFF000000E06AF450C00000006060584BC00000000000000000FFFFFFFFFFFFEFFF00000020C8F450C0000000E0BA594BC00000000000000000FFFFFFFFFFFFEFFF0000004036F550C000000020535B4BC00000000000000000FFFFFFFFFFFFEFFF000000C0DDF450C0000000402B5D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0B6F350C000000040575F4BC00000000000000000FFFFFFFFFFFFEFFF000000E0B0F350C000000040E55F4BC00000000000000000FFFFFFFFFFFFEFFF00000020FFF350C00000000091604BC00000000000000000FFFFFFFFFFFFEFFF000000407AF450C000000080D3604BC00000000000000000FFFFFFFFFFFFEFFF000000A042F550C0000000A0CA604BC00000000000000000FFFFFFFFFFFFEFFF000000608AF850C00000002036604BC00000000000000000FFFFFFFFFFFFEFFF0000006045FB50C000000000D5604BC00000000000000000FFFFFFFFFFFFEFFF0000000054FB50C000000040CB604BC00000000000000000FFFFFFFFFFFFEFFF000000A0D9FB50C00000006072604BC00000000000000000FFFFFFFFFFFFEFFF00000060BBFD50C000000040715E4BC00000000000000000FFFFFFFFFFFFEFFF00000080540051C0000000E0105E4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0151C000000000525D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0251C0000000A08D5C4BC00000000000000000FFFFFFFFFFFFEFFF000000A0030551C0000000A0955C4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0751C000000020FC5D4BC00000000000000000FFFFFFFFFFFFEFFF00000000E70751C0000000C00A5E4BC00000000000000000FFFFFFFFFFFFEFFF00000040460A51C000000020ED5D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0B51C0000000E07E5E4BC00000000000000000FFFFFFFFFFFFEFFF000000C05A0C51C0000000C0205F4BC00000000000000000FFFFFFFFFFFFEFFF000000202B0D51C000000020D95F4BC00000000000000000FFFFFFFFFFFFEFFF000000600F1051C000000080EE634BC00000000000000000FFFFFFFFFFFFEFFF000000E03D1051C0000000207C644BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E6100000010000000500000000000000002051C00000000000804BC000000000002051C00000000000404BC000000000000051C00000000000404BC000000000000051C00000000000804BC000000000002051C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C002000000000000C04B1251C0000000E02F654BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E6100000010000000500000000000000002051C00000000000804BC000000000002051C00000000000404BC000000000000051C00000000000404BC000000000000051C00000000000804BC000000000002051C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C0250000000000000092D950C000000020F66D4BC00000000000000000FFFFFFFFFFFFEFFF000000000DDA50C0000000C07C6E4BC00000000000000000FFFFFFFFFFFFEFFF00000060CFDA50C000000080E56E4BC00000000000000000FFFFFFFFFFFFEFFF0000008064DB50C000000040F46E4BC00000000000000000FFFFFFFFFFFFEFFF000000E05ADC50C000000060A96E4BC00000000000000000FFFFFFFFFFFFEFFF00000060BFDD50C0000000E0C66E4BC00000000000000000FFFFFFFFFFFFEFFF00000020C9DE50C000000060296E4BC00000000000000000FFFFFFFFFFFFEFFF0000000027E050C000000080E56D4BC00000000000000000FFFFFFFFFFFFEFFF0000000085E150C000000080F36D4BC00000000000000000FFFFFFFFFFFFEFFF000000803AE250C0000000203E6E4BC00000000000000000FFFFFFFFFFFFEFFF0000002014E450C000000000B36F4BC00000000000000000FFFFFFFFFFFFEFFF000000A00AE550C00000006040704BC00000000000000000FFFFFFFFFFFFEFFF000000207BE650C00000002096704BC00000000000000000FFFFFFFFFFFFEFFF0000006045E750C000000040C5704BC00000000000000000FFFFFFFFFFFFEFFF00000080A7E950C0000000C0AA714BC00000000000000000FFFFFFFFFFFFEFFF00000020ABEC50C00000004089714BC00000000000000000FFFFFFFFFFFFEFFF000000A073F150C0000000C031704BC00000000000000000FFFFFFFFFFFFEFFF0000000084F250C00000008037704BC00000000000000000FFFFFFFFFFFFEFFF0000004002F450C0000000E07B6F4BC00000000000000000FFFFFFFFFFFFEFFF000000C062F450C0000000404C6F4BC00000000000000000FFFFFFFFFFFFEFFF00000040DAF550C0000000E0D16E4BC00000000000000000FFFFFFFFFFFFEFFF000000804BF750C000000040B16E4BC00000000000000000FFFFFFFFFFFFEFFF00000020ACF750C000000040226E4BC00000000000000000FFFFFFFFFFFFEFFF00000080B6F850C0000000E0A66E4BC00000000000000000FFFFFFFFFFFFEFFF000000002DFC50C000000000926D4BC00000000000000000FFFFFFFFFFFFEFFF000000C06AFF50C0000000C0BE6D4BC00000000000000000FFFFFFFFFFFFEFFF00000060580151C000000060446D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0FE0151C0000000001B6D4BC00000000000000000FFFFFFFFFFFFEFFF000000E0E10351C000000060896B4BC00000000000000000FFFFFFFFFFFFEFFF000000E0F50651C000000020556A4BC00000000000000000FFFFFFFFFFFFEFFF00000000970751C000000000E3694BC00000000000000000FFFFFFFFFFFFEFFF00000000310A51C0000000C06A694BC00000000000000000FFFFFFFFFFFFEFFF00000040440C51C00000000082694BC00000000000000000FFFFFFFFFFFFEFFF00000000B40D51C000000020E0684BC00000000000000000FFFFFFFFFFFFEFFF000000A0480E51C0000000606E684BC00000000000000000FFFFFFFFFFFFEFFF000000A0E80E51C000000000F4674BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E6100000010000000500000000000000002051C00000000000804BC000000000002051C00000000000404BC000000000000051C00000000000404BC000000000000051C00000000000804BC000000000002051C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C031000000000000C0C2D250C000000000FF494BC00000000000000000FFFFFFFFFFFFEFFF000000A0B8D450C000000040A44A4BC00000000000000000FFFFFFFFFFFFEFFF000000E033D650C0000000E00B4C4BC00000000000000000FFFFFFFFFFFFEFFF000000406FD750C000000020D64C4BC00000000000000000FFFFFFFFFFFFEFFF00000060F1D850C0000000802E4E4BC00000000000000000FFFFFFFFFFFFEFFF000000008CD950C0000000E0714E4BC00000000000000000FFFFFFFFFFFFEFFF000000807CDF50C0000000C0AB4E4BC00000000000000000FFFFFFFFFFFFEFFF000000A005E150C000000060BA4E4BC00000000000000000FFFFFFFFFFFFEFFF000000E03AE250C000000020944E4BC00000000000000000FFFFFFFFFFFFEFFF000000A0A3E350C000000000414E4BC00000000000000000FFFFFFFFFFFFEFFF000000E099E550C000000000504D4BC00000000000000000FFFFFFFFFFFFEFFF00000040A3E750C000000000A24C4BC00000000000000000FFFFFFFFFFFFEFFF00000060C8EA50C0000000C0804C4BC00000000000000000FFFFFFFFFFFFEFFF00000000D7EB50C000000060AC4C4BC00000000000000000FFFFFFFFFFFFEFFF00000000FCEC50C0000000E01A4D4BC00000000000000000FFFFFFFFFFFFEFFF00000000C1ED50C000000000654D4BC00000000000000000FFFFFFFFFFFFEFFF000000606FEE50C000000040F24D4BC00000000000000000FFFFFFFFFFFFEFFF0000008058EF50C0000000C06E4F4BC00000000000000000FFFFFFFFFFFFEFFF00000080F5EF50C00000000017524BC00000000000000000FFFFFFFFFFFFEFFF000000C070F050C0000000E0F6524BC00000000000000000FFFFFFFFFFFFEFFF0000006070F250C0000000A03B554BC00000000000000000FFFFFFFFFFFFEFFF000000C0B4F350C00000006009574BC00000000000000000FFFFFFFFFFFFEFFF000000E06AF450C00000006060584BC00000000000000000FFFFFFFFFFFFEFFF00000020C8F450C0000000E0BA594BC00000000000000000FFFFFFFFFFFFEFFF0000004036F550C000000020535B4BC00000000000000000FFFFFFFFFFFFEFFF000000C0DDF450C0000000402B5D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0B6F350C000000040575F4BC00000000000000000FFFFFFFFFFFFEFFF000000E0B0F350C000000040E55F4BC00000000000000000FFFFFFFFFFFFEFFF00000020FFF350C00000000091604BC00000000000000000FFFFFFFFFFFFEFFF000000407AF450C000000080D3604BC00000000000000000FFFFFFFFFFFFEFFF000000A042F550C0000000A0CA604BC00000000000000000FFFFFFFFFFFFEFFF000000608AF850C00000002036604BC00000000000000000FFFFFFFFFFFFEFFF0000006045FB50C000000000D5604BC00000000000000000FFFFFFFFFFFFEFFF0000000054FB50C000000040CB604BC00000000000000000FFFFFFFFFFFFEFFF000000A0D9FB50C00000006072604BC00000000000000000FFFFFFFFFFFFEFFF00000060BBFD50C000000040715E4BC00000000000000000FFFFFFFFFFFFEFFF00000080540051C0000000E0105E4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0151C000000000525D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0251C0000000A08D5C4BC00000000000000000FFFFFFFFFFFFEFFF000000A0030551C0000000A0955C4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0751C000000020FC5D4BC00000000000000000FFFFFFFFFFFFEFFF00000000E70751C0000000C00A5E4BC00000000000000000FFFFFFFFFFFFEFFF00000040460A51C000000020ED5D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0B51C0000000E07E5E4BC00000000000000000FFFFFFFFFFFFEFFF000000C05A0C51C0000000C0205F4BC00000000000000000FFFFFFFFFFFFEFFF000000202B0D51C000000020D95F4BC00000000000000000FFFFFFFFFFFFEFFF000000600F1051C000000080EE634BC00000000000000000FFFFFFFFFFFFEFFF000000E03D1051C0000000207C644BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E6100000010000000500000000000000000051C00000000000804BC000000000000051C00000000000404BC00000000000E050C00000000000404BC00000000000E050C00000000000804BC000000000000051C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C0250000000000000092D950C000000020F66D4BC00000000000000000FFFFFFFFFFFFEFFF000000000DDA50C0000000C07C6E4BC00000000000000000FFFFFFFFFFFFEFFF00000060CFDA50C000000080E56E4BC00000000000000000FFFFFFFFFFFFEFFF0000008064DB50C000000040F46E4BC00000000000000000FFFFFFFFFFFFEFFF000000E05ADC50C000000060A96E4BC00000000000000000FFFFFFFFFFFFEFFF00000060BFDD50C0000000E0C66E4BC00000000000000000FFFFFFFFFFFFEFFF00000020C9DE50C000000060296E4BC00000000000000000FFFFFFFFFFFFEFFF0000000027E050C000000080E56D4BC00000000000000000FFFFFFFFFFFFEFFF0000000085E150C000000080F36D4BC00000000000000000FFFFFFFFFFFFEFFF000000803AE250C0000000203E6E4BC00000000000000000FFFFFFFFFFFFEFFF0000002014E450C000000000B36F4BC00000000000000000FFFFFFFFFFFFEFFF000000A00AE550C00000006040704BC00000000000000000FFFFFFFFFFFFEFFF000000207BE650C00000002096704BC00000000000000000FFFFFFFFFFFFEFFF0000006045E750C000000040C5704BC00000000000000000FFFFFFFFFFFFEFFF00000080A7E950C0000000C0AA714BC00000000000000000FFFFFFFFFFFFEFFF00000020ABEC50C00000004089714BC00000000000000000FFFFFFFFFFFFEFFF000000A073F150C0000000C031704BC00000000000000000FFFFFFFFFFFFEFFF0000000084F250C00000008037704BC00000000000000000FFFFFFFFFFFFEFFF0000004002F450C0000000E07B6F4BC00000000000000000FFFFFFFFFFFFEFFF000000C062F450C0000000404C6F4BC00000000000000000FFFFFFFFFFFFEFFF00000040DAF550C0000000E0D16E4BC00000000000000000FFFFFFFFFFFFEFFF000000804BF750C000000040B16E4BC00000000000000000FFFFFFFFFFFFEFFF00000020ACF750C000000040226E4BC00000000000000000FFFFFFFFFFFFEFFF00000080B6F850C0000000E0A66E4BC00000000000000000FFFFFFFFFFFFEFFF000000002DFC50C000000000926D4BC00000000000000000FFFFFFFFFFFFEFFF000000C06AFF50C0000000C0BE6D4BC00000000000000000FFFFFFFFFFFFEFFF00000060580151C000000060446D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0FE0151C0000000001B6D4BC00000000000000000FFFFFFFFFFFFEFFF000000E0E10351C000000060896B4BC00000000000000000FFFFFFFFFFFFEFFF000000E0F50651C000000020556A4BC00000000000000000FFFFFFFFFFFFEFFF00000000970751C000000000E3694BC00000000000000000FFFFFFFFFFFFEFFF00000000310A51C0000000C06A694BC00000000000000000FFFFFFFFFFFFEFFF00000040440C51C00000000082694BC00000000000000000FFFFFFFFFFFFEFFF00000000B40D51C000000020E0684BC00000000000000000FFFFFFFFFFFFEFFF000000A0480E51C0000000606E684BC00000000000000000FFFFFFFFFFFFEFFF000000A0E80E51C000000000F4674BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E6100000010000000500000000000000000051C00000000000804BC000000000000051C00000000000404BC00000000000E050C00000000000404BC00000000000E050C00000000000804BC000000000000051C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C027000000000000C0C2D250C000000000FF494BC00000000000000000FFFFFFFFFFFFEFFF000000C00ED250C0000000608E494BC00000000000000000FFFFFFFFFFFFEFFF0000000007D150C0000000A03B494BC00000000000000000FFFFFFFFFFFFEFFF0000006066D050C000000000BC484BC00000000000000000FFFFFFFFFFFFEFFF000000C0BFCF50C000000060AE474BC00000000000000000FFFFFFFFFFFFEFFF000000E04CCF50C0000000A055464BC00000000000000000FFFFFFFFFFFFEFFF0000008021CF50C000000020F7434BC00000000000000000FFFFFFFFFFFFEFFF00000020C4CD50C0000000C0673E4BC00000000000000000FFFFFFFFFFFFEFFF000000E0A2CD50C000000020493C4BC00000000000000000FFFFFFFFFFFFEFFF000000809FCD50C0000000E0103C4BC00000000000000000FFFFFFFFFFFFEFFF00000000CECD50C0000000600C3A4BC00000000000000000FFFFFFFFFFFFEFFF000000C01BCE50C000000000FF384BC00000000000000000FFFFFFFFFFFFEFFF0000004096CE50C00000004035384BC00000000000000000FFFFFFFFFFFFEFFF000000A05DCF50C000000000AF374BC00000000000000000FFFFFFFFFFFFEFFF000000005FD150C0000000A06C374BC00000000000000000FFFFFFFFFFFFEFFF000000805AD350C0000000801C364BC00000000000000000FFFFFFFFFFFFEFFF000000800ED450C0000000A061354BC00000000000000000FFFFFFFFFFFFEFFF000000409CD450C000000060FA334BC00000000000000000FFFFFFFFFFFFEFFF000000E0DCD450C0000000809A324BC00000000000000000FFFFFFFFFFFFEFFF000000C07DD550C00000002042314BC00000000000000000FFFFFFFFFFFFEFFF000000E084D550C00000006026314BC00000000000000000FFFFFFFFFFFFEFFF00000040BED550C0000000C043304BC00000000000000000FFFFFFFFFFFFEFFF00000020C5D550C000000060FA2E4BC00000000000000000FFFFFFFFFFFFEFFF000000E0ABD550C0000000C0192E4BC00000000000000000FFFFFFFFFFFFEFFF00000040ECD450C000000020D02C4BC00000000000000000FFFFFFFFFFFFEFFF000000E0C6D450C000000000882A4BC00000000000000000FFFFFFFFFFFFEFFF0000004061D450C000000020DD284BC00000000000000000FFFFFFFFFFFFEFFF000000C0D4D350C00000004038284BC00000000000000000FFFFFFFFFFFFEFFF0000002023D050C00000008048264BC00000000000000000FFFFFFFFFFFFEFFF000000A0CACF50C000000080CA244BC00000000000000000FFFFFFFFFFFFEFFF000000C0CCCF50C00000004092244BC00000000000000000FFFFFFFFFFFFEFFF00000060D8CF50C0000000A05B234BC00000000000000000FFFFFFFFFFFFEFFF00000060B2CF50C0000000A0E3224BC00000000000000000FFFFFFFFFFFFEFFF0000004039CF50C0000000A07A224BC00000000000000000FFFFFFFFFFFFEFFF000000C0A0CD50C0000000E0A7214BC00000000000000000FFFFFFFFFFFFEFFF000000206ECD50C00000008028214BC00000000000000000FFFFFFFFFFFFEFFF0000008081CD50C0000000A0CE204BC00000000000000000FFFFFFFFFFFFEFFF0000006048CF50C0000000A0FF1E4BC00000000000000000FFFFFFFFFFFFEFFF000000A0B5CF50C0000000C0171E4BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E610000001000000050000000000000000E050C00000000000804BC00000000000E050C00000000000404BC00000000000C050C00000000000404BC00000000000C050C00000000000804BC00000000000E050C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C031000000000000C0C2D250C000000000FF494BC00000000000000000FFFFFFFFFFFFEFFF000000A0B8D450C000000040A44A4BC00000000000000000FFFFFFFFFFFFEFFF000000E033D650C0000000E00B4C4BC00000000000000000FFFFFFFFFFFFEFFF000000406FD750C000000020D64C4BC00000000000000000FFFFFFFFFFFFEFFF00000060F1D850C0000000802E4E4BC00000000000000000FFFFFFFFFFFFEFFF000000008CD950C0000000E0714E4BC00000000000000000FFFFFFFFFFFFEFFF000000807CDF50C0000000C0AB4E4BC00000000000000000FFFFFFFFFFFFEFFF000000A005E150C000000060BA4E4BC00000000000000000FFFFFFFFFFFFEFFF000000E03AE250C000000020944E4BC00000000000000000FFFFFFFFFFFFEFFF000000A0A3E350C000000000414E4BC00000000000000000FFFFFFFFFFFFEFFF000000E099E550C000000000504D4BC00000000000000000FFFFFFFFFFFFEFFF00000040A3E750C000000000A24C4BC00000000000000000FFFFFFFFFFFFEFFF00000060C8EA50C0000000C0804C4BC00000000000000000FFFFFFFFFFFFEFFF00000000D7EB50C000000060AC4C4BC00000000000000000FFFFFFFFFFFFEFFF00000000FCEC50C0000000E01A4D4BC00000000000000000FFFFFFFFFFFFEFFF00000000C1ED50C000000000654D4BC00000000000000000FFFFFFFFFFFFEFFF000000606FEE50C000000040F24D4BC00000000000000000FFFFFFFFFFFFEFFF0000008058EF50C0000000C06E4F4BC00000000000000000FFFFFFFFFFFFEFFF00000080F5EF50C00000000017524BC00000000000000000FFFFFFFFFFFFEFFF000000C070F050C0000000E0F6524BC00000000000000000FFFFFFFFFFFFEFFF0000006070F250C0000000A03B554BC00000000000000000FFFFFFFFFFFFEFFF000000C0B4F350C00000006009574BC00000000000000000FFFFFFFFFFFFEFFF000000E06AF450C00000006060584BC00000000000000000FFFFFFFFFFFFEFFF00000020C8F450C0000000E0BA594BC00000000000000000FFFFFFFFFFFFEFFF0000004036F550C000000020535B4BC00000000000000000FFFFFFFFFFFFEFFF000000C0DDF450C0000000402B5D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0B6F350C000000040575F4BC00000000000000000FFFFFFFFFFFFEFFF000000E0B0F350C000000040E55F4BC00000000000000000FFFFFFFFFFFFEFFF00000020FFF350C00000000091604BC00000000000000000FFFFFFFFFFFFEFFF000000407AF450C000000080D3604BC00000000000000000FFFFFFFFFFFFEFFF000000A042F550C0000000A0CA604BC00000000000000000FFFFFFFFFFFFEFFF000000608AF850C00000002036604BC00000000000000000FFFFFFFFFFFFEFFF0000006045FB50C000000000D5604BC00000000000000000FFFFFFFFFFFFEFFF0000000054FB50C000000040CB604BC00000000000000000FFFFFFFFFFFFEFFF000000A0D9FB50C00000006072604BC00000000000000000FFFFFFFFFFFFEFFF00000060BBFD50C000000040715E4BC00000000000000000FFFFFFFFFFFFEFFF00000080540051C0000000E0105E4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0151C000000000525D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0251C0000000A08D5C4BC00000000000000000FFFFFFFFFFFFEFFF000000A0030551C0000000A0955C4BC00000000000000000FFFFFFFFFFFFEFFF00000000CA0751C000000020FC5D4BC00000000000000000FFFFFFFFFFFFEFFF00000000E70751C0000000C00A5E4BC00000000000000000FFFFFFFFFFFFEFFF00000040460A51C000000020ED5D4BC00000000000000000FFFFFFFFFFFFEFFF000000A07D0B51C0000000E07E5E4BC00000000000000000FFFFFFFFFFFFEFFF000000C05A0C51C0000000C0205F4BC00000000000000000FFFFFFFFFFFFEFFF000000202B0D51C000000020D95F4BC00000000000000000FFFFFFFFFFFFEFFF000000600F1051C000000080EE634BC00000000000000000FFFFFFFFFFFFEFFF000000E03D1051C0000000207C644BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E610000001000000050000000000000000E050C00000000000804BC00000000000E050C00000000000404BC00000000000C050C00000000000404BC00000000000C050C00000000000804BC00000000000E050C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C014000000000000C0C2D250C000000000FF494BC00000000000000000FFFFFFFFFFFFEFFF000000409BD250C000000000A24B4BC00000000000000000FFFFFFFFFFFFEFFF000000E000D350C000000000354E4BC00000000000000000FFFFFFFFFFFFEFFF000000A0D9D250C000000060514F4BC00000000000000000FFFFFFFFFFFFEFFF000000A00CD350C0000000E06D504BC00000000000000000FFFFFFFFFFFFEFFF0000008059D350C0000000A05D514BC00000000000000000FFFFFFFFFFFFEFFF000000C0E2D550C000000060F5554BC00000000000000000FFFFFFFFFFFFEFFF0000006063D650C00000004028574BC00000000000000000FFFFFFFFFFFFEFFF000000E0B6D650C0000000C062584BC00000000000000000FFFFFFFFFFFFEFFF00000060BCD650C0000000E0DD584BC00000000000000000FFFFFFFFFFFFEFFF00000080F5D650C000000060DA5D4BC00000000000000000FFFFFFFFFFFFEFFF0000006062D750C0000000C011614BC00000000000000000FFFFFFFFFFFFEFFF00000040D6D750C0000000E0A5624BC00000000000000000FFFFFFFFFFFFEFFF0000004073D950C0000000604D664BC00000000000000000FFFFFFFFFFFFEFFF00000020C7D950C000000000DA674BC00000000000000000FFFFFFFFFFFFEFFF00000060D4D950C0000000E04F684BC00000000000000000FFFFFFFFFFFFEFFF00000080FAD950C000000080A2694BC00000000000000000FFFFFFFFFFFFEFFF000000600DDA50C0000000E0AC6C4BC00000000000000000FFFFFFFFFFFFEFFF000000E0F9D950C0000000E0586D4BC00000000000000000FFFFFFFFFFFFEFFF0000000092D950C000000020F66D4BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E610000001000000050000000000000000E050C00000000000804BC00000000000E050C00000000000404BC00000000000C050C00000000000404BC00000000000C050C00000000000804BC00000000000E050C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C00400000000000080B1D550C00000002027704BC00000000000000000FFFFFFFFFFFFEFFF000000A0BBD650C0000000208A6F4BC00000000000000000FFFFFFFFFFFFEFFF000000402DD850C0000000000B6F4BC00000000000000000FFFFFFFFFFFFEFFF0000000092D950C000000020F66D4BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E610000001000000050000000000000000E050C00000000000804BC00000000000E050C00000000000404BC00000000000C050C00000000000404BC00000000000C050C00000000000804BC00000000000E050C00000000000804BC0'::geography)))
,SUM(ST_Length(ST_Intersection('01050000E0E61000000100000001020000C0250000000000000092D950C000000020F66D4BC00000000000000000FFFFFFFFFFFFEFFF000000000DDA50C0000000C07C6E4BC00000000000000000FFFFFFFFFFFFEFFF00000060CFDA50C000000080E56E4BC00000000000000000FFFFFFFFFFFFEFFF0000008064DB50C000000040F46E4BC00000000000000000FFFFFFFFFFFFEFFF000000E05ADC50C000000060A96E4BC00000000000000000FFFFFFFFFFFFEFFF00000060BFDD50C0000000E0C66E4BC00000000000000000FFFFFFFFFFFFEFFF00000020C9DE50C000000060296E4BC00000000000000000FFFFFFFFFFFFEFFF0000000027E050C000000080E56D4BC00000000000000000FFFFFFFFFFFFEFFF0000000085E150C000000080F36D4BC00000000000000000FFFFFFFFFFFFEFFF000000803AE250C0000000203E6E4BC00000000000000000FFFFFFFFFFFFEFFF0000002014E450C000000000B36F4BC00000000000000000FFFFFFFFFFFFEFFF000000A00AE550C00000006040704BC00000000000000000FFFFFFFFFFFFEFFF000000207BE650C00000002096704BC00000000000000000FFFFFFFFFFFFEFFF0000006045E750C000000040C5704BC00000000000000000FFFFFFFFFFFFEFFF00000080A7E950C0000000C0AA714BC00000000000000000FFFFFFFFFFFFEFFF00000020ABEC50C00000004089714BC00000000000000000FFFFFFFFFFFFEFFF000000A073F150C0000000C031704BC00000000000000000FFFFFFFFFFFFEFFF0000000084F250C00000008037704BC00000000000000000FFFFFFFFFFFFEFFF0000004002F450C0000000E07B6F4BC00000000000000000FFFFFFFFFFFFEFFF000000C062F450C0000000404C6F4BC00000000000000000FFFFFFFFFFFFEFFF00000040DAF550C0000000E0D16E4BC00000000000000000FFFFFFFFFFFFEFFF000000804BF750C000000040B16E4BC00000000000000000FFFFFFFFFFFFEFFF00000020ACF750C000000040226E4BC00000000000000000FFFFFFFFFFFFEFFF00000080B6F850C0000000E0A66E4BC00000000000000000FFFFFFFFFFFFEFFF000000002DFC50C000000000926D4BC00000000000000000FFFFFFFFFFFFEFFF000000C06AFF50C0000000C0BE6D4BC00000000000000000FFFFFFFFFFFFEFFF00000060580151C000000060446D4BC00000000000000000FFFFFFFFFFFFEFFF000000C0FE0151C0000000001B6D4BC00000000000000000FFFFFFFFFFFFEFFF000000E0E10351C000000060896B4BC00000000000000000FFFFFFFFFFFFEFFF000000E0F50651C000000020556A4BC00000000000000000FFFFFFFFFFFFEFFF00000000970751C000000000E3694BC00000000000000000FFFFFFFFFFFFEFFF00000000310A51C0000000C06A694BC00000000000000000FFFFFFFFFFFFEFFF00000040440C51C00000000082694BC00000000000000000FFFFFFFFFFFFEFFF00000000B40D51C000000020E0684BC00000000000000000FFFFFFFFFFFFEFFF000000A0480E51C0000000606E684BC00000000000000000FFFFFFFFFFFFEFFF000000A0E80E51C000000000F4674BC00000000000000000FFFFFFFFFFFFEFFF000000C0331051C000000020A0654BC00000000000000000FFFFFFFFFFFFEFFF'::geography,
'0103000020E610000001000000050000000000000000E050C00000000000804BC00000000000E050C00000000000404BC00000000000C050C00000000000404BC00000000000C050C00000000000804BC00000000000E050C00000000000804BC0'::geography)))

Results in:
20490.8912191163;2138.63426331298;18518.5160027332;46902.7612241946;33658.3526757868;10661.3527891203;14501.8984732599;33022.9273604644;4367.73963140889;6898.27557594151

So this seems to work. However, running the complete query results in the error.
DROP TABLE IF EXISTS v0map_rd_length;
SELECT priogrid_land.gid, priogrid_land.cell,
SUM(ST_Length(ST_Intersection(v0map_rd.geom::geography,
priogrid_land.cell::geography)))/1000 as length_km
INTO v0map_rd_length
FROM priogrid_land, v0map_rd
WHERE ST_Intersects(v0map_rd.geom::geography, priogrid_land.cell::geography)
GROUP BY priogrid_land.gid, priogrid_land.cell
;

It is a very big dataset. the priogrid_land have square grid cells.
Approx 65000, and the road dataset have 563492 rows.
2011/6/20 Paul Ramsey <pramsey at opengeo.org>:
> Can you reduce this to a smaller example? a couple geometries (or one)
> that displays this behavior? It's a bug.
>
> P
>
> On Mon, Jun 20, 2011 at 12:48 AM, Andreas Forø Tollefsen
> <andreasft at gmail.com> wrote:
>> Hi.
>> I want to measure the length of lines within polygons in km and not in dd.
>>
>> Why can't I cast this as geography to get length in km? I get this error:
>>
>> ERROR:  gbox_overlaps: geometries have mismatched dimensionality
>>
>> ********** Error **********
>>
>> ERROR: gbox_overlaps: geometries have mismatched dimensionality
>> SQL state: XX000
>>
>>
>> I also tried to ST_Transform into Eckert VI, but it has been running
>> for 50 hours++ without a result.
>> Here is my query with cast as geography:
>>
>> DROP TABLE IF EXISTS v0map_rd_length;
>> SELECT priogrid_land.gid, priogrid_land.cell,
>> SUM(ST_Length(ST_Intersection(v0map_rd.geom::geography,
>> priogrid_land.cell::geography)))/1000 as length_km
>> INTO v0map_rd_length
>> FROM priogrid_land, v0map_rd
>> WHERE ST_Intersects(v0map_rd.geom::geography, priogrid_land.cell::geography)
>> GROUP BY priogrid_land.gid, priogrid_land.cell
>> ;
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>