Latest Contributions by TychoGranville

Thanks, all. As I learn more SQL it just gets me into trouble. I will continue on with my clunky coding ... View more

I probably didn't compose my original post very well. It is a FileGeoDB so: SELECT * FROM Taxlot_Taxpayers WHERE Taxlot.MapTaxlot LIKE '%R%' Does return all records in that field that contain an R. What I have now (which works) is: SELECT * FROM Taxlot_Taxpayers WHERE Taxlot.MapTaxlot LIKE '%R%' OR Taxlot.MapTaxlot LIKE '%W%' OR Taxlot.MapTaxlot LIKE '%T%' What I want is a shortend version like this ( Which should work with SQL):  Taxlot.MapTaxlot LIKE '%[RWT]%' It doesn't matter that much with this example, but if I end up with a lot of values it becomes a pain (and is harder to read as well). ... View more

Yep, that's exactly what I was looking for. Told you I was missing something obvious Thanks, Tycho ... View more

I am using Server/Portal 10.5, the users will be using a web browser on their desktop. Having the pop-ups appear on the edge of the map rather than in the middle covering up what you are looking at would be a bonus (though I guess that is a different question). ... View more

I will have to disagree with you on that one. I view GIS as being a tool for line staff to use. The guts of how it works should be invisible to staff. I want them to be concentrating on their primary work area (planning, tax assessment, etc.) and not have to spend time trying to figure out how these tools work. The information I provide should fit easily into their workflow, not mine. I don't know how to write staff reports, I don't expect them to know how to write queries against GeoDatabase tables. (We do have staff who do analysis against our raw data, I just don't expect people to have to do that in order to do their jobs) ... View more

Below is my final reply from ESRI tech support. Apparently I was mistaken about it being a known bug, but the issue has now been filed as such. It looks like the workarounds they suggested will have to do – hopefully there will not be too much gnashing of teeth when my staff have to change their workflow... ------------------------------------------------------ I did some further testing on a virtual machine running 10.5 and Excel 2010. When testing the copying and pasting of the shapefile and feature class alone it worked fine. However, when there was any joined table to either of the layers the records would not copy over at all. When there was a relate on the data, only the feature class allowed the records to copy over. To get all the records with the relate it did require first running a sort as you mentioned.  At this point I can go ahead and log a bug on the issue if you would like. There is currently no existing bug open related to this issue. I understand that it can be challenging modify a workflow that everyone is already used to and I apologize for the inconvenience. The best workaround options at this point though would be for you to either run the table to excel tool or export the table as a CSV from the attribute table. I have included a link to the workflow for both below.  Export an attribute table to Microsoft Excel (Option A & C): http://support.esri.com/Technical-Article/000012471 ------------------------------------------------ Thanks, Tycho ... View more

My staff will not be able to figure out a new tool. They are used to going straight from copy selection in Arc to pasting directly into Excel. Right now they are all using Arc 10.5 and Office 2010 (I'm the only one with an earlier version of Office). One thing I did forget to mention yesterday (too many pans of the fire) is that if you do a sort (on any field) before doing the copy paste the correct number of records show up in Excel. The response I got back from tech-support this morning is below (hasn't sent me the bug number yet). ----------------------------------------------------------------------- I did some more testing on the data though and believe that the issue may be with Excel. I will outline the testing I did below.  1. Tested copying the records into Excel with no joins or relates from the shapefile- Success  2. Imported the shapefile into the geodatabase as a feature class and did the same test- Success 3. Exported the table of the 8358 records and joined it to both the shapefile and feature class- Success 4. Related the exported table to the shapefile as well as the feature class- Reproduced issue only with related feature class. 5. Copied the same clipboard of records to Notepad ++ and all 8358 records came across. Excel still showed ~2050. 6. Cleared related tables and tried relating again to feature class- Success, issue did not appear second time 7. Attempted multiple times to reproduce the issue and re-added datasets each time to new map without success Results above were tested with ArcMap 10.4.1 and Microsoft Office 2016. At this point I have been able to reproduce the issue once and it was specifically with a feature class that had a related table. However, this was not consistently reproducible and when pasting those same exact records into another text editor they all loaded fine. This may be attributed to having an older version of Excel, but the oldest version we can test with is 2010. That being said, my next step will be to test ArcMap 10.5 with Microsoft Office 2010 since it is the closest I can get to your machine.  ------------------------------------------------------------------ I did run his step 5 (with both Arc 10.2/Excel 2007 and Arc 10.5/Excel 2010) on Feature Classes without related tables in 2 different file GeoDatabases on both Notepad ++ and Excel came up with the approximately 2050 records. ... View more

The data needs to go directly into Excel. ArcGIS will only export tables into DBF format. Doing the extra steps of exporting the data then importing it back into Excel is outside the normal workflow of my staff. Tycho Granville, GISP | GIS Coordinator INFORMATION SERVICES tychog@co.wasco.or.us | www.co.wasco.or.us 541-506–2658 | Fax 541-506-2641 2705 E. 2nd St. | The Dalles, OR 97058 ... View more