If you were Registered and logged in, you could reply and use other advanced thread options
This is as much a conceptual question as a MapInfo question. I have
MapInfo 7 and use the USZIPBDY.tab table to create thematic maps and
plot patients within zip code boundaries.
Our zip code files are old. I downloaded a file from ZipInfo.com
(ZIPList5 Geocode file). Then I looked at the table structure of
USZIPBDY.tab in mapinfo and created a file that contains the same
fields and field sizes. (Zip, St, St-fips, Cty1fips, Field 5; that
last field seems strange... hmmm.)
Anyway, we use a join which joins a list of zips with corresponding
count field (07006, 3) where the zip is first then the number of
patients who've visited in that zip code. The join matches that
table's zip with the uszipbdy table. When I use the original table
from mapinfo, the dots appear on my map. When I use my manufactured
table (in which I cut the FIPS provided in the file I bought into
ST-fips and Cty1Fips), the dots don't appear. I've attached the text
of the WOR file, in case any of you have experience interpreting that
info.
Anyway, my question is: How do the FIPS fields match to a location in
the US? And why isn't LAT/LONG required in the USZIPBDY file?
Shouldn't there be more fields for the software to be able to draw the
entire boundary of a zip code? And lastly, any idea why the dots don't
appear with my newly created boundary file?
Thanks in advance for any advice you can give me!
Workspace file:
!Workspace
!Version 600
!Charset WindowsLatin1
Open Table "MapInfo CD Data\Usa_Maps\USCTY_8K" As USCTY_8K Interactive
Open Table "MapInfo CD Data\Usa_Maps\USA" As USA Interactive
Open Table "MapInfo CD Data\Usa_Maps\US_CNTY" As US_CNTY Interactive
Open Table "MapInfo CD Data\Usa_Maps\USZIPBDY" As USZIPBDY Interactive
Open Table "MapInfo CD Data\Usa_Maps\US_HIWAY" As US_HIWAY Interactive
Open Table "PracticeCity&Zip2005UpdatedOct" As
PracticeCity_Zip2005UpdatedOct Interactive
Open Table "Z:\DotMaps2005072SpringdaleA" As _11072SpringdaleA
Interactive
Open Table "C:\Documents and Settings\pandrews\My
Documents\Ring_Buffer" As Ring_Buffer Interactive
Add Column "USZIPBDY" (_COL3 Integer) From _11072SpringdaleA Set To
_COL3 Where COL1 = COL2 Dynamic
Add Column "Ring_Buffer" (Sum_COL3) Values
753,525,145
Select * from USZIPBDY where ZIP = "71203" into Query1 noselect
Select * from USZIPBDY where ZIP = "79109" into Query2 noselect
Map From
PracticeCity_Zip2005UpdatedOct,USCTY_8K,US_HIWAY,Ring_Buffer,USA,US_CNTY,USZIPBDY
Position (-0.03125,0.0729167) Units "in"
Width 7.83333 Units "in" Height 5.64583 Units "in"
Set Window FrontWindow() ScrollBars Off Autoscroll On
Set Map
CoordSys Earth Projection 1, 62
Center (-94.09934293,36.25141189)
Zoom 244.9255427 Units "mi"
Preserve Zoom Display Zoom
Distance Units "mi" Area Units "sq mi" XY Units "degree"
shade 7 with _COL3 density 1:4 color 0 # color 0 #
Set Map
Layer 1
Display Global
Global Symbol (35,8388608,18)
Label Line Arrow Position Right Font ("Arial",257,10,0,16719904)
Pen (1,2,0)
With City
Parallel On Auto On Overlap On Duplicates On Offset 2
Visibility On
Layer 2
Display Global
Global Symbol (31,0,9)
Zoom (0, 500) Units "mi"
Label Line Arrow Position Center Font ("Arial",257,9,0,16777215)
Pen (1,2,0)
With City
Parallel On Auto On Overlap Off Duplicates On Offset 2
Visibility On
Object 1010 Visibility Off
Object 263 Line Arrow Anchor (-78.89924,35.117269)
Object 1228 Line None Anchor (-77.544954,35.188341)
Layer 3
Display Graphic
Global Symbol (35,0,12)
Label Line Arrow Position Above Font ("Arial",0,9,0) Pen (1,2,0)
With Highway
Parallel On Auto Off Overlap Off Duplicates Off Offset 2
Visibility On
Layer 4
Display Graphic
Global Symbol (35,0,12)
Label Line None Position Center Font
("Arial",257,12,16711680,16777215) Pen (1,2,0)
With Sum_COL3
Parallel On Auto On Overlap On Duplicates On Offset 2
Visibility On
Object 3 Anchor (-94.718023,36.623622)
Object 2 Anchor (-94.406315,36.375482)
Object 1 Anchor (-94.176108,36.260274)
Layer 5
Display Global
Global Pen (5,2,0) Brush (1,16777215,16777215) Symbol (35,0,12)
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With State_Name
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Activate Using URL On Objects Relative Path Off
Layer 6
Display Global
Global Pen (4,2,255) Brush (1,16777215,16777215) Symbol (35,0,12)
Zoom (0, 1000) Units "mi"
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With County
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Layer 7
Display Value
Global Symbol (35,0,12)
Selectable Off
Zoom (0, 500) Units "mi"
Layer 8
Display Graphic
Global Symbol (35,0,12)
Zoom (0, 500) Units "mi"
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With ZIP
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Set CoordSys Earth Projection 1, 33
Set Map Layer 0 Editable
Create Point (-94.176153,36.184946)
Symbol (35,0,12)
Set CoordSys Earth
Set Map Layer 0 Editable
set legend
layer 7
display on
shades off
symbols off
lines off
count off
title "Springdale, AR 2005" Font ("Arial",0,9,0)
subtitle "Total Patients: 1,575" Font ("Arial",0,8,0)
ascending off
ranges Font ("Arial",0,8,0)
"1 Dot = 1 Patient" display on
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Create Cartographic Legend
Position (5.22917,0.21875) Units "in"
Width 2.80208 Units "in" Height 4.10417 Units "in"
Window Title "Legend of PracticeCity_Zip2005UpdatedOct,...,USZIPBDY
Map"
Portrait
Frame From Layer 7
Border Pen (0,1,0)
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From PracticeCity_Zip2005UpdatedOct
Position (0.270833,0.364583) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Row 93 Column 0
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From USZIPBDY
Position (0.489583,0.677083) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From Ring_Buffer
Position (0.708333,0.989583) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Layout
Position (-0.0416667,-0.3125) Units "in"
Width 0 Units "in" Height 0 Units "in"
Set CoordSys Layout Units "in"
Create Frame (0.3104,0.3326) (13.6639,8.1604)
Pen (1,2,0)
Brush (2,16777215,16777215)
Title "PracticeCity_Zip2005UpdatedOct,...,USZIPBDY Map"
FillFrame On
Create Frame (11.9056,6.9972) (13.459,7.8785)
Pen (1,2,0)
Brush (2,16777215,16777215)
Title "Legend of PracticeCity_Zip2005UpdatedOct,...,USZIPBDY Map"
FillFrame Off
Set Layout Ruler On Pagebreaks On Frame Contents Active
Zoom 40.7197 Center (-0.50814,-0.511628) Extents To Fit
Set Window FrontWindow() Autoscroll On
Set CoordSys Earth
Set Window FrontWindow() Printer
Name "\Rosie\HP4600" Orientation Landscape Copies 6
Papersize 5
Margins Left 0.2 Right 0.2 Top 0.25 Bottom 0.25 Units "in"
Dim WorkspaceMaximizedWindow As Integer
WorkspaceMaximizedWindow = Frontwindow()
Set Window WorkspaceMaximizedWindow Max
Undim WorkspaceMaximizedWindow
MapInfo 7 and use the USZIPBDY.tab table to create thematic maps and
plot patients within zip code boundaries.
Our zip code files are old. I downloaded a file from ZipInfo.com
(ZIPList5 Geocode file). Then I looked at the table structure of
USZIPBDY.tab in mapinfo and created a file that contains the same
fields and field sizes. (Zip, St, St-fips, Cty1fips, Field 5; that
last field seems strange... hmmm.)
Anyway, we use a join which joins a list of zips with corresponding
count field (07006, 3) where the zip is first then the number of
patients who've visited in that zip code. The join matches that
table's zip with the uszipbdy table. When I use the original table
from mapinfo, the dots appear on my map. When I use my manufactured
table (in which I cut the FIPS provided in the file I bought into
ST-fips and Cty1Fips), the dots don't appear. I've attached the text
of the WOR file, in case any of you have experience interpreting that
info.
Anyway, my question is: How do the FIPS fields match to a location in
the US? And why isn't LAT/LONG required in the USZIPBDY file?
Shouldn't there be more fields for the software to be able to draw the
entire boundary of a zip code? And lastly, any idea why the dots don't
appear with my newly created boundary file?
Thanks in advance for any advice you can give me!
Workspace file:
!Workspace
!Version 600
!Charset WindowsLatin1
Open Table "MapInfo CD Data\Usa_Maps\USCTY_8K" As USCTY_8K Interactive
Open Table "MapInfo CD Data\Usa_Maps\USA" As USA Interactive
Open Table "MapInfo CD Data\Usa_Maps\US_CNTY" As US_CNTY Interactive
Open Table "MapInfo CD Data\Usa_Maps\USZIPBDY" As USZIPBDY Interactive
Open Table "MapInfo CD Data\Usa_Maps\US_HIWAY" As US_HIWAY Interactive
Open Table "PracticeCity&Zip2005UpdatedOct" As
PracticeCity_Zip2005UpdatedOct Interactive
Open Table "Z:\DotMaps2005072SpringdaleA" As _11072SpringdaleA
Interactive
Open Table "C:\Documents and Settings\pandrews\My
Documents\Ring_Buffer" As Ring_Buffer Interactive
Add Column "USZIPBDY" (_COL3 Integer) From _11072SpringdaleA Set To
_COL3 Where COL1 = COL2 Dynamic
Add Column "Ring_Buffer" (Sum_COL3) Values
753,525,145
Select * from USZIPBDY where ZIP = "71203" into Query1 noselect
Select * from USZIPBDY where ZIP = "79109" into Query2 noselect
Map From
PracticeCity_Zip2005UpdatedOct,USCTY_8K,US_HIWAY,Ring_Buffer,USA,US_CNTY,USZIPBDY
Position (-0.03125,0.0729167) Units "in"
Width 7.83333 Units "in" Height 5.64583 Units "in"
Set Window FrontWindow() ScrollBars Off Autoscroll On
Set Map
CoordSys Earth Projection 1, 62
Center (-94.09934293,36.25141189)
Zoom 244.9255427 Units "mi"
Preserve Zoom Display Zoom
Distance Units "mi" Area Units "sq mi" XY Units "degree"
shade 7 with _COL3 density 1:4 color 0 # color 0 #
Set Map
Layer 1
Display Global
Global Symbol (35,8388608,18)
Label Line Arrow Position Right Font ("Arial",257,10,0,16719904)
Pen (1,2,0)
With City
Parallel On Auto On Overlap On Duplicates On Offset 2
Visibility On
Layer 2
Display Global
Global Symbol (31,0,9)
Zoom (0, 500) Units "mi"
Label Line Arrow Position Center Font ("Arial",257,9,0,16777215)
Pen (1,2,0)
With City
Parallel On Auto On Overlap Off Duplicates On Offset 2
Visibility On
Object 1010 Visibility Off
Object 263 Line Arrow Anchor (-78.89924,35.117269)
Object 1228 Line None Anchor (-77.544954,35.188341)
Layer 3
Display Graphic
Global Symbol (35,0,12)
Label Line Arrow Position Above Font ("Arial",0,9,0) Pen (1,2,0)
With Highway
Parallel On Auto Off Overlap Off Duplicates Off Offset 2
Visibility On
Layer 4
Display Graphic
Global Symbol (35,0,12)
Label Line None Position Center Font
("Arial",257,12,16711680,16777215) Pen (1,2,0)
With Sum_COL3
Parallel On Auto On Overlap On Duplicates On Offset 2
Visibility On
Object 3 Anchor (-94.718023,36.623622)
Object 2 Anchor (-94.406315,36.375482)
Object 1 Anchor (-94.176108,36.260274)
Layer 5
Display Global
Global Pen (5,2,0) Brush (1,16777215,16777215) Symbol (35,0,12)
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With State_Name
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Activate Using URL On Objects Relative Path Off
Layer 6
Display Global
Global Pen (4,2,255) Brush (1,16777215,16777215) Symbol (35,0,12)
Zoom (0, 1000) Units "mi"
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With County
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Layer 7
Display Value
Global Symbol (35,0,12)
Selectable Off
Zoom (0, 500) Units "mi"
Layer 8
Display Graphic
Global Symbol (35,0,12)
Zoom (0, 500) Units "mi"
Label Line None Position Center Font ("Arial",0,9,0) Pen (1,2,0)
With ZIP
Parallel On Auto Off Overlap Off Duplicates On Offset 2
Visibility On
Set CoordSys Earth Projection 1, 33
Set Map Layer 0 Editable
Create Point (-94.176153,36.184946)
Symbol (35,0,12)
Set CoordSys Earth
Set Map Layer 0 Editable
set legend
layer 7
display on
shades off
symbols off
lines off
count off
title "Springdale, AR 2005" Font ("Arial",0,9,0)
subtitle "Total Patients: 1,575" Font ("Arial",0,8,0)
ascending off
ranges Font ("Arial",0,8,0)
"1 Dot = 1 Patient" display on
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Create Cartographic Legend
Position (5.22917,0.21875) Units "in"
Width 2.80208 Units "in" Height 4.10417 Units "in"
Window Title "Legend of PracticeCity_Zip2005UpdatedOct,...,USZIPBDY
Map"
Portrait
Frame From Layer 7
Border Pen (0,1,0)
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From PracticeCity_Zip2005UpdatedOct
Position (0.270833,0.364583) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Row 93 Column 0
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From USZIPBDY
Position (0.489583,0.677083) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Browse * From Ring_Buffer
Position (0.708333,0.989583) Units "in"
Width 4.125 Units "in" Height 2.27083 Units "in"
Set Window FrontWindow() Printer
Name "\rosie\HP4V" Orientation Portrait Copies 1
Papersize 1
Layout
Position (-0.0416667,-0.3125) Units "in"
Width 0 Units "in" Height 0 Units "in"
Set CoordSys Layout Units "in"
Create Frame (0.3104,0.3326) (13.6639,8.1604)
Pen (1,2,0)
Brush (2,16777215,16777215)
Title "PracticeCity_Zip2005UpdatedOct,...,USZIPBDY Map"
FillFrame On
Create Frame (11.9056,6.9972) (13.459,7.8785)
Pen (1,2,0)
Brush (2,16777215,16777215)
Title "Legend of PracticeCity_Zip2005UpdatedOct,...,USZIPBDY Map"
FillFrame Off
Set Layout Ruler On Pagebreaks On Frame Contents Active
Zoom 40.7197 Center (-0.50814,-0.511628) Extents To Fit
Set Window FrontWindow() Autoscroll On
Set CoordSys Earth
Set Window FrontWindow() Printer
Name "\Rosie\HP4600" Orientation Landscape Copies 6
Papersize 5
Margins Left 0.2 Right 0.2 Top 0.25 Bottom 0.25 Units "in"
Dim WorkspaceMaximizedWindow As Integer
WorkspaceMaximizedWindow = Frontwindow()
Set Window WorkspaceMaximizedWindow Max
Undim WorkspaceMaximizedWindow
- Help with MapSource Program please
- Garmin GPS
- 2009-10-13
- lost resolution after update
- Garmin GPS
- 2008-04-20
- mapping software
- Global Positioning System
- 2007-11-14
