[QGIS-pt] Postgis - actualizar geometria com coordenadas

[Pedro]

Viva,

Vou tentar explicar a situação o melhor possível

Tenho uma tabela que tem uma coluna geométrica preenchida, no caso é do tipo
multipoligono.
Queria acrescentar a essa geometria uma outra.
(Na prática quero ter 2 poligonos onde agora tenho 1)

O que fiz foi:
- copiei do QGIS, com WKT, as 2 geometrias 
- no excel colei e juntei os 2 conjuntos de coordenadas...
- no postgis tentei fazer um update à coluna geom com as coordenadas todas
que juntei

Fiz assim:

update spo_lixo
set geom1 = '(((-8.54395035976183514
40.14193282029495435,-8.54372058411877688
40.14224775653634936,-8.54352162306381224
40.14255072906414057,-8.54340689439512779
40.14273486751719844,-8.54336281186726154
40.14310841049599787,-8.5421684197380614
40.14354530358877327,-8.5418372384445167
40.14369464485874062,-8.54184585066067825
40.14384278390436123,-8.54190791762395563
40.14388997793577119,-8.54191610247774058
40.14396699783689115,-8.54196283097486031
40.14403202589375041,-8.54212525604544126
40.14407293890870676,-8.54192542822047152
40.14423366985064945,-8.54183307680136039
40.14428733659919146,-8.54184891424016079
40.14435247404576756,-8.54184161999915403
40.14442362270869324,-8.5417878463584973
40.14447122681549729,-8.54174948123173472
40.14451284923200092,-8.5418268519138838
40.14453628390557327,-8.54184251057943555
40.14457178907004931,-8.54185051732316225
40.14461917503553678,-8.541673393968507
40.14470277793213882,-8.54157339042038544
40.14476832361309278,-8.54152744418936827
40.1448336829508392,-8.54149701762617752
40.14491083724398379,-8.54149740916146882
40.14497603101239065,-8.54140519875780768
40.14505340599306038,-8.54126668637677433
40.14513687007080733,-8.54122853470967947
40.14521405379696262,-8.54115194729653382
40.14532100406085391,-8.54083605744931518
40.14544658316766146,-8.54065078257668731
40.14545909044902317,-8.54047280127825026
40.14540045106942756,-8.54023271975885478
40.1452886889671916,-8.53996971965243468
40.14521849650098773,-8.53980704570939331
40.14513609527350013,-8.53956664664652187
40.1449709909103305,-8.53929486313154307
40.14472302154999284,-8.53907040921352767
40.14464083660316618,-8.53843612075139546
40.14447118865790287,-8.53821942643603116
40.14439490029823787,-8.53803358636744747
40.14431257729286529,-8.53796369410981448
40.14424762942399383,-8.53790886017388218
40.14411743300136948,-8.53790769589804377
40.1439218515773959,-8.53795265491530309
40.1436905511245925,-8.53800604245697947
40.14357775497024505,-8.53808107988891862
40.14321003093321849,-8.53807980928995391
40.14299667229860802,-8.53805533731861033
40.14277746734737917,-8.53794651562759732
40.14265931396406017,-8.53785310494950167
40.14253517876863953,-8.53774379028527619
40.14233405032441482,-8.53774304973413223
40.14220959022745916,-8.53762601591075665
40.14200849200946664,-8.5376096887998596
40.14186037796901019,-8.53760873700481326
40.14170035963406491,-8.53759255173646814
40.14157595362976849,-8.53749928417697035
40.14147552616527292,-8.53738344806750682
40.14147593181500895,-8.53725157039448312
40.14137563768360195,-8.53716584891540897
40.14124554730133809,-8.53708725279935976
40.1410146799464016,-8.53701606245275357
40.14073044239015786,-8.53689818665168865
40.14038710107979568,-8.5367802424202246
40.14003190779024521,-8.53670947575323069
40.13981879031884148,-8.53660034611722729
40.1396472946335976,-8.53647626536180937
40.13955882770878958,-8.53640644904918489
40.13950573010016143,-8.53626709853261367
40.13944694922663103,-8.53621248038096958
40.13935231176048291,-8.53614249174833617
40.13926958164822167,-8.53627316918113266
40.13916836956624934,-8.53640444582524971
40.1391679111010049,-8.53657390986393594
40.13909619778696936,-8.53672761259065283
40.13897119782344447,-8.53723656744802817
40.13885088026869852,-8.53754513325318776
40.13879646164281922,-8.53774516505327519
40.13867129803656297,-8.53789928794709141
40.13861741631012592,-8.53802968283340924
40.13846879106595367,-8.53808306621995072
40.13835599259639508,-8.53812118168408851
40.13827288445244079,-8.53826754632424922
40.13821310285793231,-8.53845241561212376
40.13813540559205961,-8.53856775068787321
40.13805202563707297,-8.53863671910071353
40.1379628829332944,-8.53875180623345109
40.13783801588605371,-8.53882853052072655
40.13775477185774321,-8.53881999572132067
40.13761848532959675,-8.53883504949114958
40.13755323884263504,-8.53894237998759031
40.13742247281372499,-8.53896365843304039
40.13738924385592099,-8.53932377013517652
40.13778846152620616,-8.53963623483894452
40.13800030019783804,-8.54019530893853407
40.13851507055334622,-8.54065354996449955
40.13887350668488097,-8.54101156937380246
40.13917895357896271,-8.54200966837770714
40.14018167892071887,-8.54307973988443337
40.1410691239152726,-8.54377209880775723
40.14158673765712138,-8.54395035976183514 40.14193282029495435)))'
where nome1 = '10/2008/49'

dá-me erro...

provavelmente estarei abordar isto mal, se tiverem sugestões ou correcções
agradeço 


Pedro




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Postgis-actualizar-geometria-com-coordenadas-tp5215546.html
Sent from the QGIS-pt mailing list archive at Nabble.com.