link points from excel to data in a shp file

[Chris_Baze]

I have a bunch of points in Excel that contain X and Y placement coordines for 3D buildings. I also have a .shp file with building footprints and a lot of useful information about the buildings. I would somehow like to populate the information from the .shp file or otherwise link the data back into my exel sheet. There is no common information between my .shp and .xls files, but if I were to plot out the points from by .xls file, the points would be encompassed by the cooresponding building footprint. Is there any way to combine these two data sets, with the only connection being that they are both in the same place in the real world? 

[braudpat]

Hello from France

So you have a XLS file with X & Y columns/fields + maybe some other Infos ...

Q1) How many rows in your XLS about ?

So you have a building SHP file with the footprint (closed pline, I imagine) + a lot of Infos

Q2) How many buildings about ?

The XY XLS Coordinates are ALWAYS INSIDE the SHP footprint !?

and you have not ANY columns/fields which could relate the SHP footprint to the XY XLS !?

I am right ?

Bye, Pat

[Chris_Baze]

1. I have 4 spreadsheets with ~120 points each to start with. This is just a sample though, I'd eventually like to include a few thousand points/buildings. 

2. .shp file contains maybe 40k building footprints. they came into AutoCAD Map as MPolygons. I don't need all of them for now though. 

I'll have to do some adjusting, but for now let's assume that my points always fall within the .shp file footprints. There unfortunately is not a single column in the spreasheed that relates to the data in the .shp file. 

[antoniovinci]

Would you please upload one of those .XLS as long as its containing shapefile?

[Murph_Map]

Depending on your workstation and OS, but you may be able to use Data Connect and use an overlay to get what you need. Use the ODBC administrator to make an ODBC connection and connect to the Excel files using the X-Y data then data connect to the shp file(s) and run a feature overlay with union option. 

[Chris_Baze]

Here are the building footprints: http://gisftp.hicentral.com/Layers/Structures_Facilities/Structure_Footprints.zip Projection: State Plane Oahu, Zone 3, feet

An example .csv file is attached. For the .csv file, the projection is WGS 84 UTM Zone 4.

[antoniovinci]

---

Chris_Baze wrote:

An example .csv file is attached

---

Sorry sir, but that .CSV contains 72 identical X,Y pairs, i.e. :

621004.54006435, 2353108.15500798

yielding one only point...

If you are allowed to, please upload the whole spreadsheet, thx.

[Chris_Baze]

Oops, sorry. Here is the correct spreadsheet.

[antoniovinci]

Got it, check the attachment out: have I understood what you meant..?

[Chris_Baze]

Beautiful! How did you do it? Also, many of the points are slightly off from the building footprints, so the data did not translate as expected. Is it possible to offset the building perimeters to more accurately catch their associated points? Or could I somehow graphically adjust the points so that they fall within the building footprints and associate with the correct data? Thanks for your help!

[antoniovinci]

Chris_Baze wrote:

How did you do it?

---

Since my Map2006 does not support FDO, I used Qgis to do that: in your case, I advise you applying the above Murph's tip.

---

Chris_Baze wrote:

Is it possible to offset the building perimeters to more accurately catch their associated points? 

---

 Nope.

---

Chris_Baze wrote:

Or could I somehow graphically adjust the points so that they fall within the building footprints and associate with the correct data? 

---

 Definetely yes.