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.
