[postgis-users] problem with dumppoints and srid

Mon Nov 25 05:52:37 PST 2013

Hi List

I have this geometry
id;geom
1;"0105000020BB0B000001000000010200000077000000329C245839223741D15CE77F823753417377C82E30223741D7188C3E8437534180BF88072722374106737AE784375341C26ED9F31C223741B546821E85375341336F19E50D2237411EA3BF63823753419128AED2B6213741B85A499D6637534151D26103B321374125B7E3B8643753416B9E0ACEB32137411D08AF0763375341EFC6A9ADB8213741DC9041EC6037534160932A97FA21374175292A5355375341E109941CFE2137414964D693543753417A9FDEA9022237411C8545E35237534152724F110322374139066D3151375341E113704B012237418E3590F84E375341C3CA08B7D8213741F6B742CE4137534160DBA1FCAF2137410042603A34375341FAC8653E99213741941808932C3753418C737DFE522137410CC4717A153753412BD4F6BA432137411B2B4554103753410C1582E52C2137419366886D09375341F056987823213741286EDC8006375341C4631B281C213741B4586BCE03375341A983BAFF142137419E21529400375341455E514C0521374121463D67F8365341A0E29BC9F12037414D684EC1ED365341CB23B69FDA2037411FAF32A1E1365341B667B5E3CE203741A7D37A4ADA365341F53C60BAB620374191135C9CCC3653411BDF712B972037414AFC1C6DBB365341D4D947C8782037417DD6CCEFA9365341D60F4AC15F2037418036B5889C365341B9AE47A03C20374101C5CD03893653418BABF52023203741839ECF2A7B36534108434BF9162037416967591A7736534181F1B0F5F71F374198527F406E365341152CB474D21F374104813BC9643653412AE7FCA7B31F37414B2B482F5E365341BBA08B4E8F1F374167B20BCD56365341D7B6EE6F7D1F374142857DF553365341E634B1415B1F37415623F6AF4E3653413006F288F71E374136F85A683E365341AF54EB52EE1E3741BB816CD83C365341ECDA6D3BE71E37415A11489E3A36534132551A77E61E3741DEF84E1739365341E6B60DCFEB1E3741D52FDD7436365341F19C78C4FA1E3741554ECF2133365341A13936ED221F37414E617EA82C365341144D73A7A51F3741EB1F397617365341F28D2BF2AB1F3741B90CD10C13365341E02BE7DBBC1F37417A6EB6F20F3653413F5ACE75DF1F3741A7DBB0F80A365341D1F29DE9E71F37411A2B38DD0936534167E5FCE2EF1F37410A797B5709365341FED75BDCF71F3741D3A3D2DF0836534100C52EE7FE1F3741DC111DA108365341826876BF10203741D82ECBE305365341024FF179A92037414ECD67E7ED355341F1CA35A8BC203741C5CE94CEEA355341D9449125D22037417ACCD1D8EA3553414AC10478DD2037412EF1BBE1EB355341CC4B265BE72037414635A2FFEF3553414C229FC6502137417EFAE6641836534169E088335A213741CFECC8FB1B365341F6E899085F21374134D84A2E1D365341B07D379364213741690BE9AE1D3653413103EBDE6C213741FEF531A91C365341618B946579213741E10C16961A36534196D247E3A22237415F5B4596EA355341466F050CCB22374199B1E755E4355341823BB95CF7223741465711FADC3553414EE4FD770A2337417B22BBB5D93553414B15E90DE02337416A2941F7B635534185F4C953052437419C0429E8B0355341D9EEA566ED24374130C5BFC28B3553410A95E37903253741E074E82288355341BBB18A121D2537412DBE8E2E8535534135490D0B2E2537415F2818E38335534154EAED533B2537418C3EF19D84355341E126BB24A5253741A8A613698D355341F183BEC3AF2537410E85258E8E355341EEF18C070D263741DD0E643A9B355341E153C38B86263741F15057C8AC3553412D5B03C0BF2637419AD782C3B43553417BDDBECCE8263741B34FE3C3BA355341DBBD08E1292737411C181B64C435534110E8B546A127374135E238CED5355341F0B4A341F12737416B6794B8E13553413ADF12BA5228374159113782EF355341695304E35828374199CC5CB5F0355341DD6DF5315F2837415293AE8BF2355341A532B808612837412694449AF535534135D946DA60283741EA84281AF8355341ECA7F6AC5E283741409F83ED2E365341587B856B5E2837416F71A4903036534105AACE90632837413AC305EE313653414BC225E97A283741371160EB33365341E728F2E5B428374127CA6552343653412C0B44399B293741ACE5E6AD34365341397C2C56C929374189A81AA134365341A2F826092C2A3741DC3FD556353653419CE87EFA362A37411BE1BD98353653418DEE88C73E2A37418CCF247636365341A5E5F607E92A374174291DDC4E365341D607687C192B37411AA37BF35536534112EA433CA12B3741FFA1EFA16A365341F1B579AEC62B3741E86EDCFD6F36534160EF10533B2C374168859CA180365341192259FA582C374145BD3467843653412BDE86D6812C3741E270EF038636534149195C2DD02C3741C58137A189365341BDA03617EC2C37417E4B579F883653411190817EF02C3741A9C2F38A863653415768CD8E002D3741BEE56B23833653416605DC75122D3741B9948951823653418F692590232D3741863770AA83365341D9BD77E1302D374172B6020987365341EBB38AE5342D3741C94A4C6D8B365341696406B3302D3741D62D58D78F365341467D4E422A2D3741B8D3DD8792365341"

1)
SELECT  ST_Y  ( ST_Transform ((ST_DumpPoints(geom)).geom, 4326 ) )

give this error output:
ERROR:  Input geometry has unknown (0) SRID

Infact :
ST_srid(geom) ---- give 3003
ST_srid ((ST_DumpPoints(geom)).geom) ---give 0

2)
SELECT ST_Y  ((ST_DumpPoints(ST_transform(geom,4326))).geom)

works well

I think (but I'm not sure) that first query doesn't work since I update
Postgis to:

"POSTGIS="2.1.0 r11822" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.7.1, 23
September 2009" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"

thanks
f.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131125/26baf1f2/attachment.html>