[GRASS5] How to merge attribute files after v.patch?

Michael Barton michael.barton at asu.edu
Thu, 17 Mar 2005 08:34:00 -0700


> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--Boundary_(ID_QqeZ3PtKNqF+6HUHoxLBLQ)
Content-type: text/plain;	charset="US-ASCII"
Content-transfer-encoding: 7bit

I made a little script to solve this problem. It's still a bit rough but
seems to work pretty well. When I get a bit of time, I'll clean it up and
put it on the GRASS WIKI.

I've attached it here.

Michael
____________________
C. Michael Barton, Professor of Anthropology
School of Human Evolution and Social Change
PO Box 872402
Arizona State University
Tempe, AZ  85287-2402
USA

Phone: 480-965-6262
Fax: 480-965-7671
www: <www.public.asu.edu/~cmbarton>


> From: Allan Metts <ametts2@mindspring.com>
> Date: Wed, 16 Mar 2005 07:51:42 -0500
> To: <grass5@grass.itc.it>
> Subject: [GRASS5] How to merge attribute files after v.patch?
> 
> Hi all,
> 
> I have geometry stored in shape files (linked in with v.external), and
> attribute files stored in dbf files.
> 
> I can combine two shape files into one with v.patch -- but v.patch doesn't do
> anything with the dbf attributes.  So I'm looking for a good way to combine
> the attribute files after performing v.patch.
> 
> I tried INSERT INTO usxxxxst (SELECT * from akxxxxst), but it doesn't look
> like support for this type of operation exists in GRASS SQL yet.
> 
> Can anyone suggest an easy utility (GRASS or otherwise) that can append the
> contents of one dbf file into another?
> 
> Thanks in advance,
> Allan
> 


--Boundary_(ID_QqeZ3PtKNqF+6HUHoxLBLQ)
Content-type: application/octet-stream; name="v.append"; x-mac-creator=534D554C; x-mac-type=534D4C64
Content-disposition: attachment; filename="v.append"
Content-transfer-encoding: BASE64

IyEvYmluL3NoCiMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMKIwojIE1PRFVM
RTogICAgICAgdi5hcHBlbmQKIyBBVVRIT1IoUyk6CU1pY2hhZWwgQmFydG9uLCBB
cml6b25hIFN0YXRlIFVuaXZlcnNpdHkKIyBQVVJQT1NFOgkgICAgVXNlIG9ncjJv
Z3IgdXRpbGl0eSB0byBtZXJnZSAyIHZlY3RvciBmaWxlcwojICAgICAgICAgICAg
ICAgYW5kIHRoZWlyIGF0dHJpYnV0ZSB0YWJsZXMgR1JBU1MgNgojCiMgQ09QWVJJ
R0hUOgkoQykgMjAwNSBieSB0aGUgR1JBU1MgRGV2ZWxvcG1lbnQgVGVhbQojCiMJ
CVRoaXMgcHJvZ3JhbSBpcyBmcmVlIHNvZnR3YXJlIHVuZGVyIHRoZSBHTlUgR2Vu
ZXJhbCBQdWJsaWMKIwkJTGljZW5zZSAoPj12MikuIFJlYWQgdGhlIGZpbGUgQ09Q
WUlORyB0aGF0IGNvbWVzIHdpdGggR1JBU1MKIwkJZm9yIGRldGFpbHMuCiMKIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMKCgojJU1vZHVsZQojJSAgZGVzY3Jp
cHRpb246IE1lcmdlcyB0d28gdmVjdG9yIGZpbGVzIGFuZCB0aGVpciBhdHRyaWJ1
dGUgdGFibGVzIHVzaW5nIG9ncjJvZ3IKIyVFbmQKIyVvcHRpb24KIyUga2V5OiB2
ZWN0MQojJSB0eXBlOiBzdHJpbmcKIyUgZ2lzcHJvbXB0OiBvbGQsdmVjdG9yLHZl
Y3RvcgojJSBkZXNjcmlwdGlvbjogRmlyc3QgdmVjdG9yIGZpbGUKIyUgcmVxdWly
ZWQgOiB5ZXMKIyVlbmQKIyVvcHRpb24KIyUga2V5OiB2ZWN0MgojJSB0eXBlOiBz
dHJpbmcKIyUgZ2lzcHJvbXB0OiBvbGQsdmVjdG9yLHZlY3RvcgojJSBkZXNjcmlw
dGlvbjogU2Vjb25kIHZlY3RvciBmaWxlCiMlIHJlcXVpcmVkIDogeWVzCiMlZW5k
CiMlb3B0aW9uCiMlIGtleTogdm1lcmdlZAojJSB0eXBlOiBzdHJpbmcKIyUgZ2lz
cHJvbXB0OiBvbGQsdmVjdG9yLHZlY3RvcgojJSBkZXNjcmlwdGlvbjogTmFtZSBm
b3IgbmV3IG1lcmdlZCB2ZWN0b3IgZmlsZQojJSByZXF1aXJlZCA6IHllcwojJWVu
ZAojJW9wdGlvbgojJSBrZXk6IHZ0eXBlCiMlIHR5cGU6IHN0cmluZwojJSBkZXNj
cmlwdGlvbjogVHlwZSBvZiB2ZWN0b3IgZW50aXRpZXMgdG8gbWVyZ2UKIyUgcmVx
dWlyZWQgOiB5ZXMKIyUgb3B0aW9uczogcG9pbnQsY2VudHJvaWQsbGluZSxib3Vu
ZGFyeSxhcmVhCiMlZW5kCiMlb3B0aW9uCiMlIGtleTogdmxheWVyCiMlIHR5cGU6
IGludGVnZXIKIyUgZGVzY3JpcHRpb246IExheWVyIHRvIHVzZSBmb3IgYXR0cmli
dXRlcyAoZGVmYXVsdCA9IDEpCiMlIHJlcXVpcmVkOiBubwojJSBhbnN3ZXI6IDEK
IyVlbmQKCgppZiB0ZXN0ICIkR0lTQkFTRSIgPSAiIjsgdGhlbgogZWNobyAiWW91
IG11c3QgYmUgaW4gR1JBU1MgR0lTIHRvIHJ1biB0aGlzIHByb2dyYW0uIiA+JjIK
IGV4aXQgMQpmaQoKaWYgWyAiJDEiICE9ICJAQVJHU19QQVJTRURAIiBdIDsgdGhl
bgogIGV4ZWMgZy5wYXJzZXIgIiQwIiAiJEAiCmZpCgpUTVAxPSJgZy50ZW1wZmls
ZSBwaWQ9JCRgIgpUTVAyPSJgZy50ZW1wZmlsZSBwaWQ9JCRgIgpybSAtZiAiJFRN
UDEiCnJtIC1mICIkVE1QMiIKbWtkaXIgIiRUTVAxIgpta2RpciAiJFRNUDIiCgoj
ZXhwb3J0IEdSQVNTIHZlY3RvcnMgdG8gc2hhcGUgZmlsZXMKdi5vdXQub2dyIGlu
cHV0PSRHSVNfT1BUX3ZlY3QxIHR5cGU9JEdJU19PUFRfdnR5cGUgZHNuPSIkVE1Q
MSIgb2xheWVyPSRHSVNfT1BUX3ZtZXJnZWQgbGF5ZXI9JEdJU19PUFRfdmxheWVy
CnYub3V0Lm9nciBpbnB1dD0kR0lTX09QVF92ZWN0MiB0eXBlPSRHSVNfT1BUX3Z0
eXBlIGRzbj0iJFRNUDIiIG9sYXllcj0kR0lTX09QVF92bWVyZ2VkIGxheWVyPSRH
SVNfT1BUX3ZsYXllcgoKI21lcmdlIHNoYXBlZmlsZXMKb2dyMm9nciAtYXBwZW5k
ICIkVE1QMSIgIiRUTVAyIgoKI3JlaW1wb3J0IHRvIEdSQVNTIHZlY3RvciBmaWxl
cwp2LmluLm9nciAtbyBkc249IiRUTVAxIiBvdXRwdXQ9JEdJU19PUFRfdm1lcmdl
ZCBsYXllcj0kR0lTX09QVF92bWVyZ2VkCgpybSAtcmYgIiRUTVAxIgpybSAtcmYg
IiRUTVAyIgplY2hvICJEb25lLiIKCgo=

--Boundary_(ID_QqeZ3PtKNqF+6HUHoxLBLQ)--