Visualizing Our Archive on QGIS via APN

Well it has been a while but if you have everything in a spreadsheet then it’s very possible to use that data save as a dbf4 from excel. Then one can geo reference that data with a unique but common item in your spreadsheet you have . By this a simple way is to use that tax ID or AP if it’s unique to said parcel. Now I have no idea if I understand what AP is. So copy the row of say tax id. Add that to a blank spreadsheet place the same header top of row name exactly. I can’t remember if it is case sensitive or not but I would assume it if I were doing this. Next to that this is an example add the lat long or national address coordinates. I have never used QGIS. But I assume you can import the new spreadsheet as it’s georeferenced. Then import the original spreadsheet in ESRI software I would merge those two together by that header tax id now it becomes one big attribute list and you can in your new spreadsheet add another row or few with some unique names or letters or query by acres zip code whatever to apply a specific symbol tag marker based on any bit of information. For a polygon it required a bit more work but that also is doable. You can point or polygon add the field notes scanned in via a hyper link in your table one of them any images all different columns so that new attribute can be linked so you can pull that as you query or click on it. I bet someone here that’s used any of the GIS software recently vs my 20 years ago methods can probably simplify these old methods I used. 

you will need to move copy or direct your geodatabase to point to your data . The type of database and server will dictate how and what type of data you wish to pull and in which method. Or if it’s just a one and done big map then that’s not as critical as an ongoing thing. 

what I do know is those young men and ladies graduating from a GIS program may not know anything about surveying but I bet they can do what you are after. The last project I ever worked on as a team I had this young whipper snapper see us copying and pasting data into a new database and he wrote some script that did it nearly perfectly. Where it was not perfect was where we as humans over time made blunders in where we had saved or as today index something incorrect. So eyes will need to go through it but the heavy lifting can be done pretty easy. Maybe advertise for an intern position for someone in a masters program or a string BS in GIS and database management. Be ready to really sit talk and describe the importance more than once on each bit and type of information you wish to use. This will be ongoing so a good GIS person first listens to what you ideas are identifies the problem . The  Goes back brainstorming and testing small samples comes back to gain more insight. The whole idea behind this way of thinking is not much different than boundary surveying. Solve the problems without creating a new one. I wish I could remember the exact flow of all this to help you better. I always drew out flow charts to map out the process to solve the problem or answer the question. But first I needed to know and understand that problem. 

@olemanriver Thanks!

Yeah, APN is Accessor's Parcel Number, so exactly that, the Tax ID

@Calavera357

Load your parcel map

Load your CSV file

On the parcel map layer create virtual field which does a lookup into the CSV...

@calavera357 No worries. I see Jim has you squared away. I figured the softwares had come a long way. It’s been so long since I used GIS software. Back when I was using all the Arc info arc catalog arc map. All those and the tools inside were all separate and I ran on Unix. I took a refresher course like 6 years ago it was a one day thing and I was impure they had Integrated so many of the tools and such. I probably need to cheyout this QGIS as I see it mentioned often enough.