|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] Dumb DBF question |
| Date: |
05/09/2006 01:00:01 PM |
| From: |
Rowe, John |
|
|
Larry,
format the column you are joining on the same as in the shapefile.
it sounds like the id you are using to join should be padded with zeros.
Try the following function in excell before exporting,
=TEXT(id field,"000000") the number of zeroe represents the total number of characters in the id plus the padded 1st charcter.
eg if i have zip code 1001, which in the us shoul be 01001,
i would use =TEXT(zip field,"00000").
hope it helps.
-----Original Message-----
From: gislist-bounces@lists.geocomm.com
[mailto:gislist-bounces@lists.geocomm.com]On Behalf Of Larry F. Holt
Sent: Tuesday, May 09, 2006 1:52 PM
To: Emily Smith: gislist@lists.thinkburst.com
Subject: Re: [gislist] Dumb DBF question
I am able to get my calculations to save as dbf now, but I can't get
this data to join a shapefile to save my life.
When I look at the data it shows the Blockgroups stored as text, but
when I try to convert them, it loses part of the State Code.
Larry Holt
Director of Research
Birmingham Regional Chamber of Commerce
> -----Original Message-----
> From: gislist-bounces@lists.geocomm.com
> [mailto:gislist-bounces@lists.geocomm.com] On Behalf Of Emily Smith
> Sent: Tuesday, May 09, 2006 12:01 PM
> To: gislist@lists.thinkburst.com
> Subject: Re: [gislist] Dumb DBF question
>
> Here's another thing you can do. After you make sure your
> columns are formatted (if numbers are left as "general" your
> decimal places will be lost), click on Insert-Name-Define in
> order to open up a dialog box that defines the extent of your
> data. The data range will probably be the same as the
> original excel file before you added the extra rows or
> columns of data for your DBF file. Just include the extended
> area in your selection, and then you can save the file as a
> DBF without having to copy/paste to a new worksheet.
>
> -Emily
>
> At 12:13 PM 5/9/2006 -0400, humberto Perotto wrote:
> >Larry,
> >
> >I have had this problem in the past. What I do is to copy
> the data into a
> >new spreadsheet and paste it as values. Then I make sure
> that the columns
> >that are numbers are displayed as numbers with the number
> characters after
> >the comma, and finally I highlight the whole data region I
> want and then I
> >save that as my new dbf file. Tha works for me, but if there
> is an easier
> >way to do it, that would be great!
> >
> >Cheers
> >
> >Humberto
> _________________________________________________
> I need to do an analysis on some data in a DBF-but after I have run
> calculations in Excel and pop it back into DBF, the data isn't showing
> up in the DBF.
>
> Larry Holt
> Director of Research
> Birmingham Regional Chamber of Commerce
>
> _______________________________________________
> gislist mailing list
> gislist@lists.geocomm.com
> http://lists.geocomm.com/mailman/listinfo/gislist
>
> _________________________________
> This list is brought to you by
> The GeoCommunity
> http://www.geocomm.com/
>
>
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
