Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stellabjenkins
Starting Member
2 Posts |
 Posted - 2010-04-13 : 01:42:44
|
| Hi,Here is my issue: We have unique a file addresses (addresses.shp) that needs to be updated with the geometry from nearest segment in the layer, roads.shp. there are multiple addreses per road so we need to have stacked road segments each with the unique address attributes. To begin I tried a spatial join. I tried joining the addresses to the roads using a "one to many" type and within the closest distant contraint. Problem was that my result was many roads containing the same address. It only took the first unique value. Then, after too much research, I tried a spatial adjustment, which updates the address features with the geomtry from the roads layer depending on the common key, "TLID", but this opperation is manual (literally point and click) and i dont have time for that. I need to do some sort of 'batch' work. So my idea is to have a script written that takes the 'shape' field from the roads.shp and updates the addresses.shp by referencing the common key "TLID" Thank you for any support you might have, Sarahedit: moved to proper forum |
|
|
stellabjenkins
Starting Member
2 Posts |
Posted - 2010-04-13 : 01:43:57
|
| I forgot to mention before I am using ARCMap 9.3.1 |
 |
|
|
|
|
|
Need help updating geometry - script