|
POST
|
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
10-08-2019
10:07 AM
|
1
|
0
|
1559
|
|
POST
|
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
10-07-2019
03:45 PM
|
1
|
0
|
1677
|
|
BLOG
|
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
09-30-2019
11:34 AM
|
1
|
0
|
3859
|
|
BLOG
|
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
09-30-2019
11:20 AM
|
1
|
0
|
3859
|
|
POST
|
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
09-03-2019
04:54 PM
|
0
|
1
|
810
|
|
POST
|
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
08-29-2019
10:12 AM
|
0
|
0
|
1015
|
|
POST
|
Since converting to ArcMap 10.6.1 this week, I can no longer see my enterprise (SDE) locks. I usually view them through the ArcCatalog Administer database dialog, but I have tried selecting users and versions, looking for specific types of locks, and even running from ArcCatalog within ArcMap. They all yield a pop-up with the message "Column value is null". This problem is not an issue right now, but it can be when I making a lot of schema changes or we get a phantom lock that won't go away. Is there a script or other way around this issue? I have no access to the underlying SQL Server 2014 tools.
... View more
08-29-2019
09:51 AM
|
0
|
2
|
1340
|
|
POST
|
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
07-31-2019
08:41 AM
|
0
|
0
|
4632
|
|
POST
|
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
07-19-2019
04:31 PM
|
0
|
1
|
867
|
|
POST
|
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
07-18-2019
09:48 AM
|
1
|
0
|
2363
|
|
POST
|
Can I use a somewhat heavier paper (HP Photo Matte) to print my map/poster for the gallery? I can't recall what people used at my last UC (2017).
... View more
06-21-2019
09:34 AM
|
0
|
1
|
583
|
|
POST
|
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
06-21-2019
08:50 AM
|
0
|
0
|
6020
|
|
POST
|
Not sure why you don't get everything in the export. Exporting is the prime way to make a join permanent (not a great practice IMHO). Are you using feature to shapefile or geodatabase table tools or the Geoprocessing tools? If you export from the attribute table menu instead, you only get attributes, not shapes. As to the main question, you can only edit Table 1 (the first or "left" table in the join) in any join. So you have to join from the table you want to edit to the polygon feature, assuming you want to see its contents when you edit the table. Also, in order to edit a table, it must have an OID, i.e., it needs to be converted to an ArcGIS table using tools such as Import or Excel to Table.
... View more
06-05-2019
01:21 PM
|
1
|
0
|
6020
|
|
POST
|
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
05-22-2019
01:22 PM
|
0
|
0
|
641
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 04-13-2022 10:06 AM | |
| 1 | 05-17-2016 09:37 AM | |
| 1 | 12-08-2023 04:22 PM | |
| 1 | 11-06-2023 09:43 AM | |
| 1 | 04-24-2020 02:18 PM |