Tag Info

New answers tagged

2

Walter: the HUD data uses ID's for the blockgroups (BLKGRP) with single quotes around them... the TIGER blockgroup ID's (GEOID) do not have single quotes: I would say that you should create a new column using Excel / Open Office to truncate the first and last values from the field into the new column...but I can't remember how to do that right now!!! ...


1

Cursors can read data from the DBFs and then write that data to a "master" table that holds all the information. Note: This is going to end up making an extremely large table or feature if you have 1000 fields. I'd also suggest testing it with a much smaller subset (e.g., two) of DBF files first, to make sure the script is working correctly for your data. ...


1

So the file names would then be fields in the output table? Seems like you would need to add a field to each table (let's call it "FILE_NAME"), merge all the tables together, then use the ArcGIS PivotTable tool (pivot on the FILE_NAME field). If you have 1000 tables, would you then have 1000+ fields? Not sure if this would be the best table structure... ...



Top 50 recent answers are included