I am trying to map all street lights of an area of Barcelona. The only data I've found is a series of CAD files with all street furniture elements. The thing is that each point is a separate shapefile thus having to join several hundreds of points. Since the data is organised by ca. 300x300m squares, I've merged all points in each square and then performed a merge of the 16 resulting shapefiles. The problem is that at every merge I lose some data (I've checked that the gdb is not too large), so when I merge all points on a square I loose some of them and ditto when creating one single shapefile.
Any suggestions on how to solve this? Sorry if it has been asked before.