If you had the city table editable when you created the buffers they are in
that table. My suggestion is that you creat a new table for the buffers. Keep
it empty and editable. Select all you cities and creat the buffers, the will
end up in your new table. Save it and do the join with taht one and your zip
areas.
//Hälsningar / Regards
Gustaf Svedjemo
~~~~~~~~~~~~~~~~~~~~~
Högskolan på Gotland / Gotland University College
Cramérgatan 3
S-621 57 Visby
Sweden
E-post / Email: [EMAIL PROTECTED]
Tel / Phone: +46 (0)498 29 98 86
Fax: +46 (0)498 29 98 32
Mobil / Cell: +46 (0)708 858 126
WWW: http://www.hgo.se
~~~~~~~~~~~~~~~~~~~~
> -----Ursprungligt meddelande-----
> Från: Steve Fleckenstein [SMTP:[EMAIL PROTECTED]]
> Skickat: den 8 februari 2001 13:54
> Till: Gustaf Svedjemo
> Kopia: [EMAIL PROTECTED]
> Ämne: Re: MI-L Ignorant new user question on Buffer data extraction
>
> Thank You for your reply.
>
> I'd like to join two tables if I could, however I never see a new table
> created as a result of creating the buffers ????
>
> Steve
>
> ----- Original Message -----
> From: "Gustaf Svedjemo" <[EMAIL PROTECTED]>
> To: "'Steve Fleckenstein'" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, February 08, 2001 7:44 AM
> Subject: SV: MI-L Ignorant new user question on Buffer data extraction
>
>
> Do a SQL query and join you two tables ( zip areas & city buffers ) with the
> operator within or interscts and you get a record set with all the zip areas
> that is partly within or interscts the city buffers.
>
> //Hälsningar / Regards
> Gustaf Svedjemo
> ~~~~~~~~~~~~~~~~~~~~~
> Högskolan på Gotland / Gotland University College
> Cramérgatan 3
> S-621 57 Visby
> Sweden
> E-post / Email: [EMAIL PROTECTED]
> Tel / Phone: +46 (0)498 29 98 86
> Fax: +46 (0)498 29 98 32
> Mobil / Cell: +46 (0)708 858 126
> WWW: http://www.hgo.se
> ~~~~~~~~~~~~~~~~~~~~
>
> > -----Ursprungligt meddelande-----
> > Från: Steve Fleckenstein [SMTP:[EMAIL PROTECTED]]
> > Skickat: den 8 februari 2001 13:25
> > Till: 'Mapinfo-L'
> > Ämne: MI-L Ignorant new user question on Buffer data extraction
> >
> > Hello everyone,
> >
> > As many of you might remember from my previous posts the prior Mapinfo
> guru
> > of my office has taken an "unlimited extended leave of absense" and one
> > bright Monday morning I found the MapInfo pro ver 5 CD and owners manual
> on
> > my desk with a note from my boss gently informing me I was the new dept
> > MapInfo Guy!
> >
> > They say the only stupid questions are those that are never asked. Today I
> > test this to the fullest!
> >
> > I have a list of 90 cities in the USA geocoded in a table and mapped.
> >
> > I have the Year 2000 zipcode table also loaded to the map.
> >
> > I have created buffers around each seperate city with a simple circular 25
> > mile buffer.
> >
> > If I click on a buffer with my mouse the Info tool tells me all about all
> > the zipcodes that are contained within that particular buffer.
> >
> > The Question:
> > I want to create a table that contains all the zipcodes in the buffers
> > as well as those that are partially in these buffer areas. Each record in
> > the new table should contain the city I drew the buffer around, the
> zipcodes
> > within the buffer, and the city / town / whatever affiliated with that
> that
> > zipcode.
> >
> > I must have overlooked that section of the users manual or I am thick
> > headed.. I just don't seem to be able to locate any info on how to pull
> this
> > type of data and put it into a new table.
> >
> > Thank You for your time and patience
> >
> > Steve
> >
> >
> >
> >
> >
> > _______________________________________________________________________
> > List hosting provided by Directions Magazine | www.directionsmag.com |
> > To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> > put "unsubscribe MapInfo-L" in the message body.
>
>
>
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
