[gis_info] gis_info Digest, Vol 92, Issue 5

[Belinda Beller]

I didn't see the error message in your e-mail.
Are you saving the Excel file into a DBF format? I've found ArcGIS won't read an 
XLS but will read a DBF.
Good Luck,

Belinda


________________________________
From: "gis_info-request at listsmart.osl.state.or.us" 
<gis_info-request at listsmart.osl.state.or.us>
To: gis_info at listsmart.osl.state.or.us
Sent: Thu, October 14, 2010 11:52:48 AM
Subject: gis_info Digest, Vol 92, Issue 5

Send gis_info mailing list submissions to
    gis_info at listsmart.osl.state.or.us

To subscribe or unsubscribe via the World Wide Web, visit
    http://listsmart.osl.state.or.us/mailman/listinfo/gis_info
or, via email, send a message with subject or body 'help' to
    gis_info-request at listsmart.osl.state.or.us

You can reach the person managing the list at
    gis_info-owner at listsmart.osl.state.or.us

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gis_info digest..."


Today's Topics:

   1. In need of simple help or explanation (Dan Fleishman)


----------------------------------------------------------------------

Message: 1
Date: Thu, 14 Oct 2010 10:14:00 -0700
From: "Dan Fleishman" <DFleishman at ci.stayton.or.us>
To: <gis_info at listsmart.osl.state.or.us>
Subject: [gis_info] In need of simple help or explanation
Message-ID:
    <01ADB7EE22787D419C4CE7F9F0BEEA1F5C9369 at police5.ci.stayton.or.us>
Content-Type: text/plain; charset="us-ascii"

GIS Experts,



I need some help in figuring out what I thought should be a simple
operation, but its just not working.  I am using ArcGIS 9.2 (Arcview).



I periodically download the tax parcel shape file from the county, and
then clip it to the City Limits to create a city tax parcel file.  We
are working on getting all of our paper records scanned and my goal is
to be able to hotlink the parcels to the file location for all of the
documents for that parcel.  If I add a field and enter in the file
location, it works great.  However, in a few months when I download an
updated file, I would have to repeat the process and so on every few
months.



So my solution was to establish an Excel spreadsheet that would contain
the information and could be joined to the parcel file each time I
update the parcel file.  I exported the attribute table from the parcel
file, deleted most of the fields except taxlot number, street address,
street, and street direction, and added a new field for the file
location.



However when joining the table I get the notice below.











I have edited both the tax parcel file and the Excel table to make sure
that there are identical numbers of records in each and there is a
one-to-one relationship (some tax parcels are made up of more than one
polygon, so I merged them).  Still get the above message.  When I open
the attribute table for the parcel file, it is completely blank until I
remove the join.  I have tried several different ways.  I can join
parcel data to the excel table, but of course that does me no good.
Thinking that maybe it was a network connection, I moved (copies of)
both files onto my C drive and tried that - still no good.



What do I need to do differently or change?  The first person to respond
with successful help gets free breakfast in beautiful downtown Stayton.
Thanks.



Dan  Fleishman

Director of Planning and Development

362 N Third Avenue

Stayton, OR 97383

ph (503) 769-2998

fax (503) 767-2134



-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<http://listsmart.osl.state.or.us/pipermail/gis_info/attachments/20101014/d20c02fd/attachment.html>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 185465 bytes
Desc: image002.jpg
URL: 
<http://listsmart.osl.state.or.us/pipermail/gis_info/attachments/20101014/d20c02fd/attachment.jpe>


------------------------------

_______________________________________________
gis_info mailing list
gis_info at listsmart.osl.state.or.us
http://listsmart.osl.state.or.us/mailman/listinfo/gis_info


End of gis_info Digest, Vol 92, Issue 5
***************************************



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/gis_info/attachments/20101014/0c5dc207/attachment.html>