Opened 10 years ago

Closed 10 years ago

#2837 closed defect (fixed)

ST_Extrude unexpected GeometryType in extrude('Solid')

Reported by: robe Owned by: colivier
Priority: low Milestone: PostGIS SFCGAL
Component: sfcgal Version: master
Keywords: Cc: vincent.mora@…

Description

I haven't upgraded yet to sfcgal 1.0.5 yet but I got an error which is kinda odd cause I didn't even know we had such a type called Solid.

SELECT ST_Extrude(ST_Extrude(ST_Buffer(ST_GeomFromText('LINESTRING(100 200, 300 400, 123 456)'),20),10,10,10),0,20,100);

Gives me error:

NOTICE:  During extrude(A, 0, 20, 100) :
NOTICE:    with A: SOLID((((577415691646497/2199023255552 1719031574882413/4398046511104 0/1,4115412622198531/35184372088832 480411381162719/1099511627776 0/1,3988603291854619/35184372088832 7713733205043735/17592186044416 0/1,1937412201716279/17592186044416 7752732247132695/17592186044416 0/1,7556896831612941/70368744177664 3901040256776911/8796093022208 0/1,3703179004132551/35184372088832 7859881578103379/17592186044416 0/1,7303817459379711/70368744177664 7923914178285935/17592186044416 0/1,906651970093129/8796093022208 1997929394296593/4398046511104 0/1,7256497507261835/70368744177664 8060686128209531/17592186044416 0/1,114274009113311/1099511627776 4064084704308799/8796093022208 0/1,7422141009012825/70368744177664 4095787036894777/8796093022208 0/1,7578137177368667/70368744177664 1031057939750073/2199023255552 0/1,971941280381647/8796093022208 2074162877953407/4398046511104 0/1,8006734501251401/70368744177664 2083571554412647/4398046511104 0/1,8262864901981627/70368744177664 65311885584937/137438953472 0/1,533379906098961/4398046511104 4186285889765303/8796093022208 0/1,1101244087709501/8796093022208 8371751342901405/17592186044416 0/1,1134985727913535/8796093022208 522343223368993/1099511627776 0/1,2691894192844351/8796093022208 460770572213537/1099511627776 0/1,5449846736633537/17592186044416 917962979085489/2199023255552 0/1,2754347824254879/8796093022208 7302231909626429/17592186044416 0/1,5557871183983891/17592186044416 3624824884361761/8796093022208 0/1,2797657209521915/8796093022208 3594079482350455/8796093022208 0/1,1404864411954219/4398046511104 7120334047926075/17592186044416 0/1,2814645010320129/8796093022208 3524507385449155/8796093022208 0/1,2812199933596203/8796093022208 6977187191025691/17592186044416 0/1,2802495966331687/8796093022208 6907858647781095/17592186044416 0/1,5571878805305469/17592186044416 3421965924401131/8796093022208 0/1,2763223447141419/8796093022208 3394041668404181/8796093022208 0/1,1004004842699819/8796093022208 1634823063962581/8796093022208 0/1,3909385004884015/35184372088832 6451779693370207/35184372088832 0/1,3787726734414493/35184372088832 3193375996511867/17592186044416 0/1,7311439636996219/70368744177664 3173354066433633/17592186044416 0/1,7036874417766399/70368744177664 180/1 0/1,6762309198536579/70368744177664 3173354066433633/17592186044416 0/1,1624573841675953/17592186044416 3193375996511867/17592186044416 0/1,6254978825764769/70368744177664 6451779693370207/35184372088832 0/1,755213761741781/8796093022208 1634823063962581/8796093022208 0/1,5866684968974015/70368744177664 415370413860349/2199023255552 0/1,2868314784140535/35184372088832 3383792446117553/17592186044416 0/1,5656541847968133/70368744177664 6899591808151489/35184372088832 0/1,80/1 7036874417766399/35184372088832 0/1,1414135461992033/17592186044416 7174157027381309/35184372088832 0/1,1434157392070267/17592186044416 7306163943297693/35184372088832 0/1,5866684968974013/70368744177664 3713911106883607/17592186044416 0/1,755213761741781/8796093022208 1883614144920619/8796093022208 0/1,577415691646497/2199023255552 1719031574882413/4398046511104 0/1)),((599405924202017/2199023255552 1763012039993453/4398046511104 10/1,843174691963861/8796093022208 1971575075142699/8796093022208 10/1,6570372410750653/70368744177664 3889832967327767/17592186044416 10/1,1610079252514427/17592186044416 7658007664186013/35184372088832 10/1,1590057322436193/17592186044416 7526000748269629/35184372088832 10/1,90/1 7388718138654719/35184372088832 10/1,6360229289744773/70368744177664 7251435529039809/35184372088832 10/1,3220158505028855/35184372088832 3559714306561713/17592186044416 10/1,6570372410750655/70368744177664 437360646415869/2199023255552 10/1,843174691963861/8796093022208 1722783994184661/8796093022208 10/1,6958666267541409/70368744177664 6803623414258527/35184372088832 10/1,1800495702120113/17592186044416 3369297856956027/17592186044416 10/1,7465996640313219/70368744177664 3349275926877793/17592186044416 10/1,7740561859543039/70368744177664 190/1 10/1,8015127078772859/70368744177664 3349275926877793/17592186044416 10/1,4139570455302813/35184372088832 3369297856956027/17592186044416 10/1,4261228725772335/35184372088832 6803623414258527/35184372088832 10/1,1091965772921899/8796093022208 1722783994184661/8796093022208 10/1,2851184377363499/8796093022208 3482002598626261/8796093022208 10/1,5747800665749629/17592186044416 3509926854623211/8796093022208 10/1,2890456896553767/8796093022208 7083780508225255/17592186044416 10/1,2900160863818283/8796093022208 7153109051469851/17592186044416 10/1,2902605940542209/8796093022208 3612468315671235/8796093022208 10/1,1448844877065259/4398046511104 7296255908370235/17592186044416 10/1,2885618139743995/8796093022208 3682040412572535/8796093022208 10/1,5733793044428051/17592186044416 3712785814583841/8796093022208 10/1,2842308754476959/8796093022208 7478153770070589/17592186044416 10/1,5625768597077697/17592186044416 939953211641009/2199023255552 10/1,2779855123066431/8796093022208 471765688491297/1099511627776 10/1,1222946658135615/8796093022208 533338339646753/1099511627776 10/1,1189205017931581/8796093022208 8547673203345565/17592186044416 10/1,577360371210001/4398046511104 4274246819987383/8796093022208 10/1,8966552343758267/70368744177664 66686275119657/137438953472 10/1,8710421943028041/70368744177664 2127552019523687/4398046511104 10/1,1059902210603727/8796093022208 2118143343064447/4398046511104 10/1,8281824619145307/70368744177664 1053048172305593/2199023255552 10/1,8125828450789465/70368744177664 4183747967116857/8796093022208 10/1,125269125391071/1099511627776 4152045634530879/8796093022208 10/1,7960184949038475/70368744177664 8236607988653691/17592186044416 10/1,994612900315209/8796093022208 2041909859407633/4398046511104 10/1,8007504901156351/70368744177664 8099836038730095/17592186044416 10/1,4055022725020871/35184372088832 8035803438547539/17592186044416 10/1,8260584273389581/70368744177664 3989001186998991/8796093022208 10/1,2113334062160439/17592186044416 7928654107576855/17592186044416 10/1,4340447012742939/35184372088832 7889655065487895/17592186044416 10/1,4467256343086851/35184372088832 491406497440479/1099511627776 10/1,599405924202017/2199023255552 1763012039993453/4398046511104 10/1)),((577415691646497/2199023255552 1719031574882413/4398046511104 0/1,599405924202017/2199023255552 1763012039993453/4398046511104 10/1,4467256343086851/35184372088832 491406497440479/1099511627776 10/1,4115412622198531/35184372088832 480411381162719/1099511627776 0/1,577415691646497/2199023255552 1719031574882413/4398046511104 0/1)),((4115412622198531/35184372088832 480411381162719/1099511627776 0/1,4467256343086851/35184372088832 491406497440479/1099511627776 10/1,4340447012742939/35184372088832 7889655065487895/17592186044416 10/1,3988603291854619/35184372088832 7713733205043735/17592186044416 0/1,4115412622198531/35184372088832 480411381162719/1099511627776 0/1)),((3988603291854619/35184372088832 7713733205043735/17592186044416 0/1,4340447012742939/35184372088832 7889655065487895/17592186044416 10/1,2113334062160439/17592186044416 7928654107576855/17592186044416 10/1,1937412201716279/17592186044416 7752732247132695/17592186044416 0/1,3988603291854619/35184372088832 7713733205043735/17592186044416 0/1)),((1937412201716279/17592186044416 7752732247132695/17592186044416 0/1,2113334062160439/17592186044416 7928654107576855/17592186044416 10/1,8260584273389581/70368744177664 3989001186998991/8796093022208 10/1,7556896831612941/70368744177664 3901040256776911/8796093022208 0/1,1937412201716279/17592186044416 7752732247132695/17592186044416 0/1)),((7556896831612941/70368744177664 3901040256776911/8796093022208 0/1,8260584273389581/70368744177664 3989001186998991/8796093022208 10/1,4055022725020871/35184372088832 8035803438547539/17592186044416 10/1,3703179004132551/35184372088832 7859881578103379/17592186044416 0/1,7556896831612941/70368744177664 3901040256776911/8796093022208 0/1)),((3703179004132551/35184372088832 7859881578103379/17592186044416 0/1,4055022725020871/35184372088832 8035803438547539/17592186044416 10/1,8007504901156351/70368744177664 8099836038730095/17592186044416 10/1,7303817459379711/70368744177664 7923914178285935/17592186044416 0/1,3703179004132551/35184372088832 7859881578103379/17592186044416 0/1)),((7303817459379711/70368744177664 7923914178285935/17592186044416 0/1,8007504901156351/70368744177664 8099836038730095/17592186044416 10/1,994612900315209/8796093022208 2041909859407633/4398046511104 10/1,906651970093129/8796093022208 1997929394296593/4398046511104 0/1,7303817459379711/70368744177664 7923914178285935/17592186044416 0/1)),((906651970093129/8796093022208 1997929394296593/4398046511104 0/1,994612900315209/8796093022208 2041909859407633/4398046511104 10/1,7960184949038475/70368744177664 8236607988653691/17592186044416 10/1,7256497507261835/70368744177664 8060686128209531/17592186044416 0/1,906651970093129/8796093022208 1997929394296593/4398046511104 0/1)),((7256497507261835/70368744177664 8060686128209531/17592186044416 0/1,7960184949038475/70368744177664 8236607988653691/17592186044416 10/1,125269125391071/1099511627776 4152045634530879/8796093022208 10/1,114274009113311/1099511627776 4064084704308799/8796093022208 0/1,7256497507261835/70368744177664 8060686128209531/17592186044416 0/1)),((114274009113311/1099511627776 4064084704308799/8796093022208 0/1,125269125391071/1099511627776 4152045634530879/8796093022208 10/1,8125828450789465/70368744177664 4183747967116857/8796093022208 10/1,7422141009012825/70368744177664 4095787036894777/8796093022208 0/1,114274009113311/1099511627776 4064084704308799/8796093022208 0/1)),((7422141009012825/70368744177664 4095787036894777/8796093022208 0/1,8125828450789465/70368744177664 4183747967116857/8796093022208 10/1,8281824619145307/70368744177664 1053048172305593/2199023255552 10/1,7578137177368667/70368744177664 1031057939750073/2199023255552 0/1,7422141009012825/70368744177664 4095787036894777/8796093022208 0/1)),((7578137177368667/70368744177664 1031057939750073/2199023255552 0/1,8281824619145307/70368744177664 1053048172305593/2199023255552 10/1,1059902210603727/8796093022208 2118143343064447/4398046511104 10/1,971941280381647/8796093022208 2074162877953407/4398046511104 0/1,7578137177368667/70368744177664 1031057939750073/2199023255552 0/1)),((971941280381647/8796093022208 2074162877953407/4398046511104 0/1,1059902210603727/8796093022208 2118143343064447/4398046511104 10/1,8710421943028041/70368744177664 2127552019523687/4398046511104 10/1,8006734501251401/70368744177664 2083571554412647/4398046511104 0/1,971941280381647/8796093022208 2074162877953407/4398046511104 0/1)),((8006734501251401/70368744177664 2083571554412647/4398046511104 0/1,8710421943028041/70368744177664 2127552019523687/4398046511104 10/1,8966552343758267/70368744177664 66686275119657/137438953472 10/1,8262864901981627/70368744177664 65311885584937/137438953472 0/1,8006734501251401/70368744177664 2083571554412647/4398046511104 0/1)),((8262864901981627/70368744177664 65311885584937/137438953472 0/1,8966552343758267/70368744177664 66686275119657/137438953472 10/1,577360371210001/4398046511104 4274246819987383/8796093022208 10/1,533379906098961/4398046511104 4186285889765303/8796093022208 0/1,8262864901981627/70368744177664 65311885584937/137438953472 0/1)),((533379906098961/4398046511104 4186285889765303/8796093022208 0/1,577360371210001/4398046511104 4274246819987383/8796093022208 10/1,1189205017931581/8796093022208 8547673203345565/17592186044416 10/1,1101244087709501/8796093022208 8371751342901405/17592186044416 0/1,533379906098961/4398046511104 4186285889765303/8796093022208 0/1)),((1101244087709501/8796093022208 8371751342901405/17592186044416 0/1,1189205017931581/8796093022208 8547673203345565/17592186044416 10/1,1222946658135615/8796093022208 533338339646753/1099511627776 10/1,1134985727913535/8796093022208 522343223368993/1099511627776 0/1,1101244087709501/8796093022208 8371751342901405/17592186044416 0/1)),((1134985727913535/8796093022208 522343223368993/1099511627776 0/1,1222946658135615/8796093022208 533338339646753/1099511627776 10/1,2779855123066431/8796093022208 471765688491297/1099511627776 10/1,2691894192844351/8796093022208 460770572213537/1099511627776 0/1,1134985727913535/8796093022208 522343223368993/1099511627776 0/1)),((2691894192844351/8796093022208 460770572213537/1099511627776 0/1,2779855123066431/8796093022208 471765688491297/1099511627776 10/1,5625768597077697/17592186044416 939953211641009/2199023255552 10/1,5449846736633537/17592186044416 917962979085489/2199023255552 0/1,2691894192844351/8796093022208 460770572213537/1099511627776 0/1)),((5449846736633537/17592186044416 917962979085489/2199023255552 0/1,5625768597077697/17592186044416 939953211641009/2199023255552 10/1,2842308754476959/8796093022208 7478153770070589/17592186044416 10/1,2754347824254879/8796093022208 7302231909626429/17592186044416 0/1,5449846736633537/17592186044416 917962979085489/2199023255552 0/1)),((2754347824254879/8796093022208 7302231909626429/17592186044416 0/1,2842308754476959/8796093022208 7478153770070589/17592186044416 10/1,5733793044428051/17592186044416 3712785814583841/8796093022208 10/1,5557871183983891/17592186044416 3624824884361761/8796093022208 0/1,2754347824254879/8796093022208 7302231909626429/17592186044416 0/1)),((5557871183983891/17592186044416 3624824884361761/8796093022208 0/1,5733793044428051/17592186044416 3712785814583841/8796093022208 10/1,2885618139743995/8796093022208 3682040412572535/8796093022208 10/1,2797657209521915/8796093022208 3594079482350455/8796093022208 0/1,5557871183983891/17592186044416 3624824884361761/8796093022208 0/1)),((2797657209521915/8796093022208 3594079482350455/8796093022208 0/1,2885618139743995/8796093022208 3682040412572535/8796093022208 10/1,1448844877065259/4398046511104 7296255908370235/17592186044416 10/1,1404864411954219/4398046511104 7120334047926075/17592186044416 0/1,2797657209521915/8796093022208 3594079482350455/8796093022208 0/1)),((1404864411954219/4398046511104 7120334047926075/17592186044416 0/1,1448844877065259/4398046511104 7296255908370235/17592186044416 10/1,2902605940542209/8796093022208 3612468315671235/8796093022208 10/1,2814645010320129/8796093022208 3524507385449155/8796093022208 0/1,1404864411954219/4398046511104 7120334047926075/17592186044416 0/1)),((2814645010320129/8796093022208 3524507385449155/8796093022208 0/1,2902605940542209/8796093022208 3612468315671235/8796093022208 10/1,2900160863818283/8796093022208 7153109051469851/17592186044416 10/1,2812199933596203/8796093022208 6977187191025691/17592186044416 0/1,2814645010320129/8796093022208 3524507385449155/8796093022208 0/1)),((2812199933596203/8796093022208 6977187191025691/17592186044416 0/1,2900160863818283/8796093022208 7153109051469851/17592186044416 10/1,2890456896553767/8796093022208 7083780508225255/17592186044416 10/1,2802495966331687/8796093022208 6907858647781095/17592186044416 0/1,2812199933596203/8796093022208 6977187191025691/17592186044416 0/1)),((2802495966331687/8796093022208 6907858647781095/17592186044416 0/1,2890456896553767/8796093022208 7083780508225255/17592186044416 10/1,5747800665749629/17592186044416 3509926854623211/8796093022208 10/1,5571878805305469/17592186044416 3421965924401131/8796093022208 0/1,2802495966331687/8796093022208 6907858647781095/17592186044416 0/1)),((5571878805305469/17592186044416 3421965924401131/8796093022208 0/1,5747800665749629/17592186044416 3509926854623211/8796093022208 10/1,2851184377363499/8796093022208 3482002598626261/8796093022208 10/1,2763223447141419/8796093022208 3394041668404181/8796093022208 0/1,5571878805305469/17592186044416 3421965924401131/8796093022208 0/1)),((2763223447141419/8796093022208 3394041668404181/8796093022208 0/1,2851184377363499/8796093022208 3482002598626261/8796093022208 10/1,1091965772921899/8796093022208 1722783994184661/8796093022208 10/1,1004004842699819/8796093022208 1634823063962581/8796093022208 0/1,2763223447141419/8796093022208 3394041668404181/8796093022208 0/1)),((1004004842699819/8796093022208 1634823063962581/8796093022208 0/1,1091965772921899/8796093022208 1722783994184661/8796093022208 10/1,4261228725772335/35184372088832 6803623414258527/35184372088832 10/1,3909385004884015/35184372088832 6451779693370207/35184372088832 0/1,1004004842699819/8796093022208 1634823063962581/8796093022208 0/1)),((3909385004884015/35184372088832 6451779693370207/35184372088832 0/1,4261228725772335/35184372088832 6803623414258527/35184372088832 10/1,4139570455302813/35184372088832 3369297856956027/17592186044416 10/1,3787726734414493/35184372088832 3193375996511867/17592186044416 0/1,3909385004884015/35184372088832 6451779693370207/35184372088832 0/1)),((3787726734414493/35184372088832 3193375996511867/17592186044416 0/1,4139570455302813/35184372088832 3369297856956027/17592186044416 10/1,8015127078772859/70368744177664 3349275926877793/17592186044416 10/1,7311439636996219/70368744177664 3173354066433633/17592186044416 0/1,3787726734414493/35184372088832 3193375996511867/17592186044416 0/1)),((7311439636996219/70368744177664 3173354066433633/17592186044416 0/1,8015127078772859/70368744177664 3349275926877793/17592186044416 10/1,7740561859543039/70368744177664 190/1 10/1,7036874417766399/70368744177664 180/1 0/1,7311439636996219/70368744177664 3173354066433633/17592186044416 0/1)),((7036874417766399/70368744177664 180/1 0/1,7740561859543039/70368744177664 190/1 10/1,7465996640313219/70368744177664 3349275926877793/17592186044416 10/1,6762309198536579/70368744177664 3173354066433633/17592186044416 0/1,7036874417766399/70368744177664 180/1 0/1)),((6762309198536579/70368744177664 3173354066433633/17592186044416 0/1,7465996640313219/70368744177664 3349275926877793/17592186044416 10/1,1800495702120113/17592186044416 3369297856956027/17592186044416 10/1,1624573841675953/17592186044416 3193375996511867/17592186044416 0/1,6762309198536579/70368744177664 3173354066433633/17592186044416 0/1)),((1624573841675953/17592186044416 3193375996511867/17592186044416 0/1,1800495702120113/17592186044416 3369297856956027/17592186044416 10/1,6958666267541409/70368744177664 6803623414258527/35184372088832 10/1,6254978825764769/70368744177664 6451779693370207/35184372088832 0/1,1624573841675953/17592186044416 3193375996511867/17592186044416 0/1)),((6254978825764769/70368744177664 6451779693370207/35184372088832 0/1,6958666267541409/70368744177664 6803623414258527/35184372088832 10/1,843174691963861/8796093022208 1722783994184661/8796093022208 10/1,755213761741781/8796093022208 1634823063962581/8796093022208 0/1,6254978825764769/70368744177664 6451779693370207/35184372088832 0/1)),((755213761741781/8796093022208 1634823063962581/8796093022208 0/1,843174691963861/8796093022208 1722783994184661/8796093022208 10/1,6570372410750655/70368744177664 437360646415869/2199023255552 10/1,5866684968974015/70368744177664 415370413860349/2199023255552 0/1,755213761741781/8796093022208 1634823063962581/8796093022208 0/1)),((5866684968974015/70368744177664 415370413860349/2199023255552 0/1,6570372410750655/70368744177664 437360646415869/2199023255552 10/1,3220158505028855/35184372088832 3559714306561713/17592186044416 10/1,2868314784140535/35184372088832 3383792446117553/17592186044416 0/1,5866684968974015/70368744177664 415370413860349/2199023255552 0/1)),((2868314784140535/35184372088832 3383792446117553/17592186044416 0/1,3220158505028855/35184372088832 3559714306561713/17592186044416 10/1,6360229289744773/70368744177664 7251435529039809/35184372088832 10/1,5656541847968133/70368744177664 6899591808151489/35184372088832 0/1,2868314784140535/35184372088832 3383792446117553/17592186044416 0/1)),((5656541847968133/70368744177664 6899591808151489/35184372088832 0/1,6360229289744773/70368744177664 7251435529039809/35184372088832 10/1,90/1 7388718138654719/35184372088832 10/1,80/1 7036874417766399/35184372088832 0/1,5656541847968133/70368744177664 6899591808151489/35184372088832 0/1)),((80/1 7036874417766399/35184372088832 0/1,90/1 7388718138654719/35184372088832 10/1,1590057322436193/17592186044416 7526000748269629/35184372088832 10/1,1414135461992033/17592186044416 7174157027381309/35184372088832 0/1,80/1 7036874417766399/35184372088832 0/1)),((1414135461992033/17592186044416 7174157027381309/35184372088832 0/1,1590057322436193/17592186044416 7526000748269629/35184372088832 10/1,1610079252514427/17592186044416 7658007664186013/35184372088832 10/1,1434157392070267/17592186044416 7306163943297693/35184372088832 0/1,1414135461992033/17592186044416 7174157027381309/35184372088832 0/1)),((1434157392070267/17592186044416 7306163943297693/35184372088832 0/1,1610079252514427/17592186044416 7658007664186013/35184372088832 10/1,6570372410750653/70368744177664 3889832967327767/17592186044416 10/1,5866684968974013/70368744177664 3713911106883607/17592186044416 0/1,1434157392070267/17592186044416 7306163943297693/35184372088832 0/1)),((5866684968974013/70368744177664 3713911106883607/17592186044416 0/1,6570372410750653/70368744177664 3889832967327767/17592186044416 10/1,843174691963861/8796093022208 1971575075142699/8796093022208 10/1,755213761741781/8796093022208 1883614144920619/8796093022208 0/1,5866684968974013/70368744177664 3713911106883607/17592186044416 0/1)),((755213761741781/8796093022208 1883614144920619/8796093022208 0/1,843174691963861/8796093022208 1971575075142699/8796093022208 10/1,599405924202017/2199023255552 1763012039993453/4398046511104 10/1,577415691646497/2199023255552 1719031574882413/4398046511104 0/1,755213761741781/8796093022208 1883614144920619/8796093022208 0/1))))


ERROR:  unexpected GeometryType in extrude ('Solid')
********** Error **********

ERROR: unexpected GeometryType in extrude ('Solid')
SQL state: XX000


Change History (5)

comment:1 by colivier, 10 years ago

Cc: vincent.mora@… added

At first sight it looks like:

  • You call ST_Extrude twice in your query
  • First time ST_Extrude should return a closed PolyhedralSurface (with SOLID Bit)
  • Second time ST_Extrude can't deal with this Solid input and so return the related error message.

Nota: there is no SOLID GeometryType inside PostGIS, it's internal to SFCGAL (based on PS or TIN with SOLID bit)

The question remaining is: As we can extrude in x,y,z should/could we still extrude even from a solid ? Vincent could you answer from a (SF)CGAL point of view ?

comment:2 by vmo, 10 years ago

We cannot extrude solids in SFCGAL at the moment.

I'm not sure I ever did that in CAD (which I used to use quite a lot), I'm not even sure if any CAD system will allow you to.

I can imagine how to perform the operation:

  • split the solid along the line that defines the shadow figure of the solid on a plane normal to the extrusion direction
  • extrude this line
  • the result is the combination of this extrusion an the two halves of the solid

Dealing with holes is a bit complicated though.

I there a use-case ?

comment:3 by robe, 10 years ago

Priority: mediumlow

vmo and colivier,

Nope no use case — I think this error should be more along the lines of our others. Similar to other functions we have it should just say — ST_Extrude not supported for Solids or along that line. Looks too much like an unexpected error rather than a limitation of the function.

comment:4 by vmo, 10 years ago

Changed error message in SFCGAL change-set e50d8fc7 https://github.com/Oslandia/SFCGAL/commit/e50d8fc78a49206c3c3efdf59a4990bc34fb0336

Now we have:

# SELECT ST_Extrude(ST_Extrude(ST_Buffer(ST_GeomFromText('LINESTRING(100 200, 300 400, 123 456)'),20),10,10,10),0,20,100);
ERROR:  Extrusion of Solid is not supported

comment:5 by robe, 10 years ago

Milestone: PostGIS 2.2.0PostGIS SFCGAL
Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.