Creating JOIN TABLE using more than one field
aswicks
Global Mapper User
Greetings Mike,
I have TIGER State/County SHP files loaded and a CSV data file with data identifiable by STATE FIPS and COUNTY FIPS. Is there any way in GM13 to be able to do a JOIN TABLE using both the STATE FIPS and COUNTY FIPS at the same time. If not, then I have to create separate CSV files for each state.
Thanks,
Alan Wicks
Kennewick, WA
I have TIGER State/County SHP files loaded and a CSV data file with data identifiable by STATE FIPS and COUNTY FIPS. Is there any way in GM13 to be able to do a JOIN TABLE using both the STATE FIPS and COUNTY FIPS at the same time. If not, then I have to create separate CSV files for each state.
Thanks,
Alan Wicks
Kennewick, WA
Comments
-
Alan,
You can't currently join against multiple attributes (just added that to todo list though), but you could use the calculate attributes option in the Control Center to create a new attribute that combines the state and county fips into one field, then if you can do the same in your attribute table you could join on that.
Let me know if I can be of further assistance.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.globalmapper.com -
Mike,
While making the changes to GM, might you make it possible to create something like: SELECT STFIPS=3 AND STFIPS=6 WHERE CROPCODE=3456789 AND YEAR=2006
Sort of like creating a Query String in SQL or something.
Thanks,
Alan S. Wicks
Kennewick, WA -
Alan,
That exact kind of thing is on our todo list, but will probably be a bit longer than just a simple addition to allow multiple join columns.
Thanks,
Mike -
Mike,
I started with GM with version 8. You efforts just keep making it better. I am patient and know that it will happen some day.
ALAN
Categories
- 12.7K All Categories
- 5.6K Features Discussion
- 342 Downloading Imagery
- 1.3K Elevation Data
- 380 Georeferencing Imagery Discussion
- 628 GM Script Language
- 53 User Scripts
- 113 GPS Features
- 414 Projection Questions
- 819 Raster Data
- 1.3K Vector Data
- 6.6K Support
- 177 Announcement and News
- 908 Bug Report
- 558 SDK
- 1.2K Suggestion Box
- 3.7K Technical Support
- 562 Other Discussion
- 129 GIS Data Sources
- 27 Global Mapper Showcase
- 233 How I use Global Mapper
- 107 Global Mapper Forum Website