Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a table of addresses for every state in the nation. I just recently finished doing spatial joins and adding in census block/tract data per state. I have a national shapefile of CoreBasedStatisticalAreas, is there a faster way to add one field from this attribute table to my completed address tables (millions of records) than doing Spatial Joins? Thanks for the help.

share|improve this question
    
Have you tried Join Field? –  Aaron Jul 2 '13 at 13:27
    
There isn't really a common field between my address tables and the CBSA attribute table, therefore I was looking at a spatial join. Just need something faster. –  Maksim Jul 2 '13 at 13:32
    
Can you create a field based on a calculation or combination of attributes that you can use as a common field - or perhaps you have another table with a common field to your addresses and a common field to your CBSA data that you could use as daisy-chained join? –  MappaGnosis Jul 2 '13 at 15:39
    
Ended up just intersecting my address points to the CBSA values then joining them back to the address table. –  Maksim Jul 2 '13 at 17:11
add comment

1 Answer

Ended up just intersecting my address points to the CBSA values then joining them back to the address table.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.