I have a strange error on ST_offsetcurve calls on geometries that are
supposed to be LineStrings.
Yves
gis=# update planet_osm_line set way=ST_OffsetCurve(way,-20) where
osm_id=-1461806;
ERREUR: Geometry type (MultiLineString) does not match column type
(LineString)
gis=# select geometrytype(way) from planet_osm_line where osm_id =
-1461806;
geometrytype
--------------
LINESTRING
(1 ligne)
gis=# select st_geometrytype(way) from planet_osm_line where osm_id
= -1461806;
st_geometrytype
-----------------
ST_LineString
(1 ligne)
gis=# select st_numgeometries(way) from planet_osm_line where osm_id
= -1461806;
st_numgeometries
------------------
1
(1 ligne)
See attached the result of:
echo "select st_astext(way) from planet_osm_line where osm_id =
-1461806;" | psql -d gis > out.wkt
st_astext
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LINESTRING(686939.65 5891138.98,686998.71310263
5891073.41399011,686999.454833399 5891072.74087066,687035.599004159
5891046.03412694,687036.384965768 5891045.55853808,687126.599570305
5891001.76020861,687174.404443958 5890978.54578979,687174.891266199
5890978.3712698,687175.384882977 5890978.52552805,687218.405011668
5890997.26136067,687218.884060679 5890997.53892492,687219.191199359
5890997.99957196,687246.936127283 5891052.12695367,687248.272218193
5891054.10776972,687250.04005956 5891055.71509919,687402.366302489
5891164.03182884,687403.270881408 5891164.86041669,687455.49154993
5891226.13907239,687456.926257535 5891227.51749284,687630.784880683
5891364.05857614,687632.12317999 5891364.94571495,687633.58621046
5891365.60722998,687678.484799468 5891381.70583139,687679.654558048
5891382.31024177,687725.479218599 5891414.30765668,687726.931747301
5891415.14996539,687771.87639891 5891436.38866085,687773.963223411
5891437.10554442,687776.156463302 5891437.34732394,687778.349335027
5891437.10222773,687797.829292284 5891432.7080928,687799.533588183
5891432.15933591,687801.112707882 5891431.31545226,687802.516028613
5891430.20349472,687803.698563302 5891428.85910997,687804.62240274
5891427.32539574,687818.253270649 5891399.28694798,687818.529050307
5891398.84774468,687819.014228534 5891398.6645616,687844.7758806
5891392.00884407,687847.124675827 5891391.07176862,687867.072116161
5891380.00834258,687868.823903575 5891378.77421005,687870.272536515
5891377.19518983,687871.351496041 5891375.34378804,687884.020985036
5891346.99706664,687884.574137102 5891345.41541317,687884.855435316
5891343.76360318,687884.856981935 5891342.08801298,687880.688980812
5891291.95909654,687880.521956383 5891290.79077677,687870.967574705
5891243.90878519,687870.917864708 5891243.42972487,687870.962064349
5891242.95012477,687883.223691127 5891179.03775156,687883.343893403
5891178.23738018,687896.54251151 5891057.17077656,687896.595577875
5891055.74542926,687893.083059209 5890952.97210141,687893.115272128
5890952.21036536,687904.524131752 5890856.54005809,687904.591084708
5890855.09508675,687900.605250892 5890702.34123617,687900.610950344
5890701.93899339,687910.339055141 5890523.36802978,687910.432373328
5890522.81805244,687910.647229377 5890522.30325128,687952.882970055
5890446.62386145,687953.070032463 5890446.27241407,687984.926016508
5890383.43758196,687984.954323594 5890383.38259312,688047.92066825
5890262.90226893,688048.136748281 5890262.56012387,688048.405612186
5890262.25769036,688073.918563715 5890237.89282165,688075.195598479
5890236.40809282,688076.158776119 5890234.70294581,688076.771156487
5890232.84277705,688078.403812797 5890225.54022644,688078.535928413
5890225.12502882,688078.738787976 5890224.73942332,688096.096447442
5890197.80195392,688097.118893559 5890195.71771634,688097.633198973
5890193.45388501,688100.4429855 5890167.30772775,688100.480981754
5890165.61902339,688100.234210678 5890163.94801467,688099.709713059
5890162.34237824,688070.267006114 5890092.76011904,688069.934718379
5890091.59931152,688067.578794859 5890076.7467502,688067.551959469
5890076.27482649,688067.935973853 5890075.99920888,688098.897545174
5890058.18876682,688099.331267781 5890057.99387019,688099.773678533
5890058.1681479,688124.633372778 5890070.95147334,688124.977260985
5890071.16581277,688125.233257706 5890071.47992451,688143.495260572
5890098.0929891,688145.135138078 5890099.94275502,688156.29176669
5890109.75860185,688157.766965964 5890110.83449483,688159.413197933
5890111.62422828,688188.448684355 5890122.41669525,688190.428576088
5890122.92949221,688192.471387594 5890123.02875525,688194.491669456
5890122.71033227,688196.404914658 5890121.98754267,688209.469565314
5890115.45521734,688211.222477053 5890114.33710549,688212.706287844
5890112.88067862,688243.280078974 5890075.87928117,688243.643544673
5890075.52206051,688244.072667551 5890075.24716514,688270.91626865
5890061.73827288,688271.362705743 5890061.56552481,688271.834077292
5890061.48211712,688300.121068067 5890059.26843632,688301.351884142
5890059.32497908,688329.21706539 5890064.10572274,688329.633576008
5890064.21550208,688329.986900584 5890064.46186431,688337.669398311
5890070.88934491,688338.617880948 5890071.9475417,688365.165902443
5890111.81763336,688366.737115359 5890113.65126596,688388.84555616
5890133.89047998,688391.063744635 5890135.4274532,688414.092259642
5890147.14246297,688415.704850999 5890147.79318253,688417.405788115
5890148.15470677,688567.445834371 5890166.60746903,688568.927102415
5890166.67885261,688570.402639012 5890166.53038583,688600.329852126
5890161.25446376,688601.793093817 5890160.8807093,688603.183364883
5890160.29086609,688628.53155939 5890147.1962583,688629.794933396
5890146.41986392,688630.929604947 5890145.46517937,688679.271596296
5890098.24334297,688679.694981821 5890097.80373055,688769.03149119
5889999.18950934,688769.682062315 5889998.5884562,688792.013660795
5889981.36421222,688793.468087502 5889979.98951751,688883.043645702
5889876.47646901,688883.761131628 5889875.54116866,688909.673088348
5889837.28877798,688909.804535958 5889837.08965375,688943.005047608
5889785.46654265,688943.161293047 5889785.23778819,689021.653389554
5889676.89223157,689022.720290488 5889675.02558175,689023.363520995
5889672.97401803,689023.553346722 5889670.83237722,689023.280992671
5889668.69966007,689006.611916933 5889598.9934636,689006.544743139
5889598.40067651,689006.622635827 5889597.80920244,689056.755398495
5889403.76358059,689057.063464875 5889402.90470663,689123.327828549
5889260.66105081,689123.538973344 5889260.29413952,689123.861739315
5889260.02022683,689234.134092045 5889181.71486386,689235.559795672
5889180.48506306,689236.729706439 5889179.00981744,689442.556861531
5888862.22710686,689443.540558617 5888860.27439459,689444.076341944
5888858.15456409,689451.562572426 5888804.25922951,689451.605195858
5888801.86032014,689451.075181651 5888799.52030563,689427.698721007
5888734.0604628,689427.577598937 5888733.55859169,689427.674049133
5888733.05140086,689443.631936858 5888680.36582077,689443.808567083
5888679.93524876,689444.132548971 5888679.60114363,689486.473185768
5888643.53104999,689487.568426153 5888642.44120438,689488.482705001
5888641.19564862,689554.106080207 5888535.55826038,689554.562005614
5888534.93703015,689683.345642378 5888385.21924436,689684.257863404
5888383.97652471,689684.968238515 5888382.60836298,689789.85144748
5888135.74026671,689790.064856107 5888135.34304998,689790.346818954
5888134.99116743,689917.761926647 5888002.74454394,689918.999748137
5888001.17091681,689962.64 5887932.52)
(1 ligne)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
