Latest Contributions by MatthewPainter1

Thanks, i just got back into the forums here and noticed there has been some changes here in the last few months that are taking me time to get used to. I figured out the merge, for some reason it only would merge one way ... View more

Anyone know of something else, that may get crazy, theres a couple dozen company i want to have the ability to sort through. ... View more

much appreciated, and learned a lot. THANKS ... View more

um i never done this before and your answer was to complex 🙂 I want to keep everything the same just only need 3 counties on my map. ... View more

Thanks for helping me out so much i finally got it how i needed it, when i copied the section layer and unchecked null values from the symbol tab everything showed up? I learned a ton doing all of this. I really appreciate you walking me through most of this. ... View more

Alright i do understand i would have to edit the original table to make changes like that and force a restart but thats not what im talking about. these photos will shed some light on my problem First photo This photo shows the entire sections that has been joined with my data now how to i get my data to display over my other layers disregarding null values so it doesnt cover everything? ... View more

alright i totally understand what your talking about with editing the symbol and i can do it with any other file i load, but i cant edit anything on the joined file?     its like invisible? while its loading when i make a change i can see that my land is displayed but its covered by the base map and wont display further? It acts as transparent but isnt. ... View more

I assume the Section layer display problem is resolved. Yes the section layer doesnt block out the map anymore and the join worked perfectly thank you for helping me figure that out. The new ownership shows up but doesnt display on the map? is there a setting im unaware of? ... View more

For the second, probably the formula did not export.  You will have to convert the formula to actual values.  To keep your original data with the formulas select everything on the page and then use the Paste Special - Values Only on a new tab of the Spreadsheet to convert the formula to value.  Then retry the export/import of the Excel table using the second sheet. Lets forget about the time format issue until the normal layer behavior for drawing and joining is solved. alright i did what you said and imported a new table that has no formula only the values. Doing so TWPRNGSEC Owner columns are listed as text data fields and cannot be alter nor show up in the drop menu when trying to join? It gives me an error when trying to change them to double. ... View more

also wont let me alter the data time in the tables properties ... View more

Alright so i did what you said by making a file gdb and importing my data to it. I added to the map and i did the join although my data shows up as <null> whats this mean? did i do something wrong? ... View more

I assume all Townships are North in your jurisdiction and all Ranges are West for your ownership data and in your jurisdiction.  So you would only need to deal with the numbers.  This is shown in the TwpRngSec field of your Sections table with a value like 16405525.  Check if that column is a text field or a number field. Add a column header in the next empty column of your ownership table named TwpRngSec (in cell D1).  To make a text value in your owner table that would match the value in that same column in the Section table you would add a formula to cell D2 that reads: =CONCATENATE(IF(B2<100,"0",""),IF(B2<10,"0",""),B2,IF(C2<100,"0",""),IF(C2<10,"0",""),C2,IF(A2<10,"0",""),A2) If the value that appears is 14509323 the formula worked.  Copy that formula down to the bottom of the table (double click the cell corner). This formula should work for all Townships from 1 to 999, all Ranges from 1 to 999 and all Sections from 1 to 36 (and technically also up to 99). The Excel table can be joined on the column named TwpRngSec to the field named TwpRngSec in the Section table provided it is imported into ArcMap with field type that is compatible with the one used in the Section table.  Or else join it to the TRSTXT field if it imports as text. Do not use the Excel table directly for the join.  Import it to a File Geodatabase table or a dbase table.  (I always use File Geodatabase Tables and Feature Classes and hate shapefiles).  If the relationship is one to many (one section has many owners) you need to import both the owner table and the Section shapefile into the same File Geodatabase to use the Make Query Table too correctly. alright i believe i did everything you said but when i joined it my table shows up on the end as shown in the photo but doesnt so anything? ... View more