<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I'm trying to do a dissolve but keep getting an error saying that it only works with integer or string columns. But the column I'm using for the dissolve IS string.<div><br></div><div><div>GRASS 7.0.svn (Spain_utm_wgs84z30):~ > db.describe table=muro_temp</div><div>table:muro_temp</div><div>description:</div><div>insert:?</div><div>delete:?</div><div>ncols:4</div><div>nrows:177</div><div><br></div><div>column:cat</div><div>description:</div><div>type:INTEGER</div><div>len:20</div><div>scale:0</div><div>precision:0</div><div>default:</div><div>nullok:yes</div><div>select:?</div><div>update:?</div><div><br></div><div>column:Subsector</div><div>description:</div><div>type:TEXT</div><div>len:1000</div><div>scale:0</div><div>precision:0</div><div>default:</div><div>nullok:yes</div><div>select:?</div><div>update:?</div><div><br></div><div>column:valley</div><div>description:</div><div>type:TEXT</div><div>len:1000</div><div>scale:0</div><div>precision:0</div><div>default:</div><div>nullok:yes</div><div>select:?</div><div>update:?</div><div><br></div><div>column:sector</div><div>description:</div><div>type:TEXT</div><div>len:1000</div><div>scale:0</div><div>precision:0</div><div>default:</div><div>nullok:yes</div><div>select:?</div><div>update:?</div><div><br></div><div><br></div><div>GRASS 7.0.svn (Spain_utm_wgs84z30):~ > v.dissolve input=muro_temp column=sector output=muro_sectors3</div><div>ERROR: Key column must be of type integer or string</div><div>GRASS 7.0.svn (Spain_utm_wgs84z30):~ > </div><div><br></div><div><br></div><div>Note above that the column "sector" IS text.</div><div><br></div><div>So what is wrong?</div><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="font-size: 12px; ">_____________________</span><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="font-size: 12px; ">C. Michael Barton</div><div style="font-size: 12px; ">Visiting Scientist, Integrated Science Program</div><div style="font-size: 12px; ">National Center for Atmospheric Research &</div><div style="font-size: 12px; ">University Consortium for Atmospheric Research</div><div style="font-size: 12px; ">303-497-2889 (voice)</div><div style="font-size: 12px; "><br></div><div style="font-size: 12px; ">Director, Center for Social Dynamics & Complexity </div><div style="font-size: 12px; ">Professor of Anthropology, School of Human Evolution & Social Change</div><div style="font-size: 12px; ">Arizona State University</div><div style="font-size: 12px; ">www: <a href="http://www.public.asu.edu/~cmbarton">http://www.public.asu.edu/~cmbarton</a>, <a href="http://csdc.asu.edu/">http://csdc.asu.edu</a></div></div><div><br></div></div></span></div></span></div></span></span></div></div><div><br></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></div></body></html>