Latest Contributions by DanaNolan

Although Excel in the wrong hands is uniquely qualified to create such messes, can you put it back in Excel to do at least some of the fixes? Look into Excel Text to Data to split fields apart and Copy/Paste/Transpose to get data going down the page, not across, and Copy/Fill to fill out noncomments fields. These are great tools to know. I also see reserved words for field names. Both Z and M are enabled (which is unlikely but was a default at some point), so I think you want a completely new feature class schema also. You can fix the field names in Excel as well. ... View more

Here are a couple of sources. http://desktop.arcgis.com/en/arcmap/10.6/manage-data/las-dataset/lidar-solutions-minimizing-noise-from-lidar-for-contouring-and-slope-analysis.htm https://www.youtube.com/watch?v=q3iblCHGoZk It has been 4 years, but I used the Esri suggestion of building them from a terrain file, which the LIDAR vendor had provided. They were a bit smoother than whatever I had tried (probably TINs). However, my main goal was 20m contours on some high-relief terrain. I also did 10m and others, but we don't use these much. If you really need 1m contours and you have a lot of relief in your area of interest, there is no way even smoothed ones will draw without some painful waiting times. What I have done is set up layers (.lyr files) that turn on 10m and 1m features only as the user zooms in to appropriate scales (turning off the other layers at the same time). This reduced wait times and also allows the labeling and symbology to be set to work at the appropriate scale range. ... View more

From what I've seen as a fed contractor, travel has been limited since at least 2012 (the fund sequestration period).  Internal travel, to an agency's conferences, still happens, but it is hard to justify other travel especially outside one's region. Conferences have been cancelled due to the insecurity of travel funding, wasting everyone's time and money. I also keenly felt the lack of user presentations from government people at this last UC. We have considered sending one person to FedGIS in DC to get this back. But as I live less than 300 miles from San Diego, this will be much more expensive and stressful. Travel cuts by government agencies are probably also a huge part of why there are so few in-person classes offered in Redlands or other training centers. ... View more

I asked my hotel manager about Comicon as he was a regular attendee. He said almost no one spends much time inside the Conference Center. It is really a different situation than the UC. ... View more

Welcome to Geonet! ... View more

Have you tried extracting it to see what's in it? You can use geoprocessing tools or ArcMap/ArcCatalog to extract it to a junk folder before deciding whether to erase the data.  You can prevent this in the future by setting an option in ArcMap/Customize/Sharing to choose where future packages are stored. I give mine a subfolder name of Packages so I know I can erase them once I have sent them to whoever needed them. ... View more

Thanks. I can't search the Geodatabase group for previous posts. So I will ask my admin to look for ownerless locks and kill them. ... View more

Additionally, the Is Required property essentially only works inside the database you are working in, i.e. if you export data from the database, this will be lost and people will be able to delete the field in their copy (makes sense). Is Nullable transfers with the data when it is moved/copied around. ... View more

This sounds like corrupt data, but remove any join or relate to eliminate that as the problem. This happens with file geodatabases. I believe this was recently discussed in GIS Stack Exchange forum, so I would search there (my system is too slow to search anywhere right now). Also try Managing Data here on GeoNet. You may have to dump out the database to XML using Esri tools then reimport it. Having done this ugly process, I am generally going back to a backup and replacing the file--it is cleaner and easier. ... View more

I highly recommend the book "Database Design for Mere Mortals" by Michael J. Hernandez. It was used in an advanced geodatabase class I took. Although I had lots of nongeo database experience, this book would have saved me a lot of time if I had found it earlier. If you have questions about SQL, try the Managing Data forum. ... View more

For data that will be edited on a regular basis and in which we need to see the joined table, I would add a Relationship that fits the situation, possibly also adding an attribute index on the joining field for speed. For other situations, doing the join, adjusting the fields shown (such as reordering and highlighting fields), and saving the join as part of a .lyr file helps people who are less familiar with the data understand what's going on. In either case, document the relationships through metadata and documentation. The problems with exporting two files into one include: you have to remember to re-generate them after any change, and the two tables may have different owners, which can complicate editing and updating workflows. ... View more

If the street file has a Composite relationship to the other file, deletes of a deleted street's data in the related table will occur automatically. If your workflow includes deleting streets and then adding them back in from somewhere, keep in mind that the deletes will take out the related data, which you would not want.  Nondelete types of transactions require some processing (not much). I don't think I should get into that, as it is not clear what your data structure is and I don't deal with this much. A good relational design would have only one redundant field, the foreign key (link) field, that is common to both tables. So if your street has a zone id field and the zone data table has one also, you will have to edit that field if the street's zone changes. And the changed zone's data would likely already be in the zone data table because it is associated with other streets so you would have to do minimal editing. That is assuming the zone table really is just about zones; if it is combining street and zone information, the design probably needs a lot of rethinking. Or perhaps a spatial join to refresh data. ... View more