Latest Contributions by ChrisDonohue__GISP

Some ideas (some new): Contact ESRI Support to get a basic understanding of what needs to be done.  They may also be able to line you out with some processes and what level of effort will be needed to learn this and to keep it operational. If you have a budget to work with, see about taking a class related to SDE Administration.  Example:  https://www.esri.com/training/catalog/57630436851d31e02a43f1d5/building-geodatabases/    https://www.esri.com/training/training-for-individuals/  Also, if you have budget, there are consultants out there who can set this up for you and train you.  Private firms, plus I believe ESRI has consultants also. Put posts on GeoNet along the lines of titles like "SDE Administration/Maintenance" or "How do I get started doing SDE Maintenance".  However, given the complexity of SDE and its many combinations,  my guess would be one would need some specific training, so using GeoNet as an information source may best be used for after you learn some of it, then run into issues when trying to apply what you learned.  Also, be sure to tag posts with this GeoNet group so as to get the most direct input on your questions:  Geodatabase      Chris Donohue, GISP ... View more

I have not used ArcGIS Pro, but suspect the process would be similar to ArcGIS Destop.  So be aware there may be some changes in the process particular to ArcGIS Pro that will have to be worked out Essentially the workflow is this: 1.  Clean up the field names in Excel so they are GIS-compliant  Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop  2.  Add a field in Excel to identify which points belong to which segments. 3.  Create a File Geodatabase (FGDB).  Add in a Feature Dataset with the appropriate coordinate system for you output. 4.  Create an XY Event Layer, then save it off as a feature class in the FGDB feature dataset.  The result will be a point feature class. Add x,y coordinate data as a layer—ArcGIS Pro | ArcGIS Desktop  - Make sure you choose the appropriate Geographic Coordinate system to match the lat/long data. - Choose the appropriate Transformation when saving it. 5  Run the Points to Line geoprocessing tool.  I believe one would use the Line Field (optional) setting to choose the field created in Step 2 above so as to keep line segments connected only to related points. Points To Line—Data Management toolbox | ArcGIS Desktop  6.  Clean up the linework if needed and double-check the results. 7.  Once it looks good, load into your enterprise geodatabase (SDE).   Note  - specifics will depend on how your SDE is set.  Probably by using a Version, but there are other ways. Chris Donohue, GISP ... View more

Ah, so your system is set up to the more common approach of Versioning.  Definitely good to know going forward. Not to open up a can of worms, but as part of this realization are you theoretically now the SDE Administrator also?  If so,  I would recommend looking into the ongoing maintenance that is needed to keep SDE functional, as quite a few issues can crop up if the maintenance is not done.  I'm not an SDE Administrator myself, so don't know the particulars, but have in the past seen quite a few issues that ended up being tracked to the maintenance being done (typically when scripts that do much of it fail to run).  If you start a new post on that topic here on GeoNet, there are folks who can point you the right way.  Also, ESRI Support can probably provide information on it. http://proceedings.esri.com/library/userconf/proc17/tech-workshops/tw_605-474.pdf - see the Maintenance section. Chris Donohue, GISP ... View more

I don't know if this is the root issue, as it is somewhat what you describe, but there is a warning in the tool usage information that if the field names are not set up a certain way the results will go to zero. Usage If the Pivot Field is a text field, its values must begin with a character (for example, a2) and not a number (for example, 2a). If the value of the first record begins with a number, all the output values will be 0. Source:  Pivot Table—Help | ArcGIS for Desktop  Chris Donohue, GISP ... View more

I don't know the exact answer, but here are some ideas that may help in troubleshooting this: Since "Page" orientation is chosen, by any chance is the coordinate system for the map frame different than the coordinate system for the data?  If so, that may account for the unexpected results. Dump out a selection of the "problem" lines plus some that work out well as a feature class.  Calculate the angle of each line.  Then check the line angle versus your result to see if it is labelling as per the line angle or not. Chris Donohue, GISP ... View more

I think Abdullah Anter has correctly identified what is going on.  If I can elaborate, what you are seeing is due to the extremely zoomed-in view causing visual "misrepresentation" of linework that is actually coincident.  The coordinate system used was not mentioned, but at this level of zoom, the measurement is probably well below the unit of accuracy used in that coordinate system.  So while visually it looks like it is off, it is actually coincident. Check out the Resolution and Tolerance sections in this link: The properties of a spatial reference—ArcGIS Help | ArcGIS Desktop  To double-check, check your measurement against the Resolution and Tolerance settings for the dataset.  This can be done using ArcCatalog. For example, here's a feature class I have in a File Geodatabase.  If, for example, the image you show was from this feature class, I would say it is coincident and not an issue, as the measurement of 0.000131 feet is below the XY Resolution and Tolerance settings. For further reference, here's a related issue thread I posted a while back, including ESRI Support's explanation for the visual wierdness experienced when zoomed way in: Strangeness - gaps unintentionally created while editing  So brings up another way to realize that what is being seen is probably not realistic.  In ArcGIS, check the map scale.  If it is below 1:1, what you are seeing may not be an accurate depiction of the true nature of the data (i.e. it can look ugly but be fine). Chris Donohue, GISP ... View more

I assume the objective is to edit the Loc_St_Nam field.  When you click on that field in box that has Rte 25 for the highlighted record that needs to be changed to Rte 25A, by any chance does a pulldown appear?  It may be that Domains and Subtypes were applied to constrain the data entry.  If so, use the pulldown to choose Rte 25A from the list (hopefully that is one of the choices). There may also be a network permission issue going on.  I've had that happen occasionally where the network gets flaky and suddenly the editing gets wonky in our enterprise geodatabase.  Check with your network administrator to see if things are working correctly at the network level. Another possibility - has anyone done the routine maintenance on the enterprise geodatabase recently?  When our system gets wierd one of the first things checked is whether the routine maintenance has failed to run as scheduled (much of ours is scheduled script runs). If none of these are the issue, you may need to get ESRI Support on the phone for assistance. Chris Donohue, GISP ... View more

I'm not sure if this will directly answer your question or be the exact solution, but one topic you may want to explore is the use of Global ID's for data replication. GlobalID [ESRI software] A field of type UUID (Universal Unique Identifier) in which values are automatically assigned by the geodatabase when a row is created. The GlobalID field is necessary for maintaining object uniqueness across replicas. All feature classes and tables participating in one-way or two-way replication must contain the GlobalID field. This field is not editable and is automatically populated when it is added for existing data. Source:  globalid | Definition - Esri Support GIS Dictionary  Add Global IDs—Help | ArcGIS for Desktop  Chris Donohue, GISP ... View more

Knowing the data is in an enterprise geodatabase helps limit the possibilities.  Some specific things to check: Do you know if the Enterprise Geodatabase is it set up to do Versioning?  Versioning is a common way to allow editing; however that is not the only way.  For example, some systems are set up to directly edit the data. An overview of versioning—ArcGIS Help | ArcGIS Desktop  If it is set up to do Versioning, have you been able to make a Version of the Town Authorized SITE address to do the edits in?  The reason I ask is sometimes users are assigned view permissions but not write permissions, i.e. without write permissions one cannot make a version nor edit the data.  If that is the case, you will need to contact your enterprise database administrator and request privileges to be able to edit the data. Creating versions and setting permissions—ArcGIS Help | ArcGIS Desktop  If editing a Version is not the approach you have tried so far to change the information, as the system is not set up to do Versioning, what approach did you use?  You mentioned "I tried to change the address in the attribute table but it will not let me.", but what environment were you in when this was attempted?  Did a warning message pop up when you tried to do editing?  Or was it instead that when you tried to start an editing session it was grayed out?  Can you elaborate on what was tried?  Chris Donohue, GISP ... View more

Can you provide some more details?  There are a whole plethora of things that could be going on here: Is what is viewed labels or annotation?  Both can be modfified, but the process is very different.  Example:  Labels and Annotation  Or is it what is being viewed is actually a static map service? If it is annotation, is it Map Annotation or Feature Class Annotation? If it is labels, is it actively labelling off of a layer or is it currently just a free-standing graphic label?  If it is actively being labelled off a layer, which layer is it (what is the name)? What type of dataset is that layer in?  Feature Class in an Enterprise Geodatabase (SDE)?  Feature Class in a File Geodatabase?  Personal Geodatabase?  Shapefile?  Other? Is that layer editable? Is it potentially an issue that permissions have been set to prevent editing on what would otherwise be an editable layer? Chris Donohue, GISP ... View more

I'd look into what Dan Patterson suggested, as it has quite a bit of potential for what you are describing.  Specifically, the "Vehicle Routing Problem" function may be useful. ArcGIS Network Analyst | Overview  ArcGIS Network Analyst | Features  Vehicle routing problem analysis—Help | ArcGIS Desktop  Notes: If using ArcGIS, one will need a Network Analyst Extension. There are also some services available in ArcGIS Online, though I have not used them myself so don't know if they have the full capabilities you need.  ArcGIS Online Directions and Routing Services .   What are the ArcGIS Online network analysis services?—Help | ArcGIS Desktop  You may want to contact ESRI Support, as they can give you more specifics as to what options are available considering your specific situation. Chris Donohue, GISP ... View more

I'd place it on a short path from the C: drive if possible.  Something like: C:\GIS\Projects or similar As for the folder naming, be there are several issues that can come up with GIS files that are not obvious.  Most important, avoid at all costs using a space in any folder name (or file name).  Then there are several more restrictions that come into play for different file types.  Here's the most extreme restrictions.  If you adhere to these (even though you are don't appear to be working with rasters), you should be good to go for all GIS work. Output raster formats and names—ArcGIS Help | ArcGIS Desktop  Chris Donohue, GISP ... View more

If one clicks on the red X, it often will then display an error message.  Sometimes the message will provide more specifics as to what the issue is. Also, as general practice try to avoid using the default geodatabase at C:\Users\... Documents\.  I don't know the exact reason, but it seems that this particular location has led to issues for many folks, including what appears to be going on for you. Some solution possibilities to consider if the error turns out be the dreaded Error 999999: Troubleshooting Error 999999 in ArcMap and ArcGIS | IT Help Site  Chris Donohue, GISP ... View more

One alternative is to mask the results so as to just show the United States in the final display.  Check out the variety of possible solutions in this recent GeoNet thread: smothening edges of interpolated map   Chris Donohue, GISP ... View more

If the goal is to select the pipes that are 8" diameter that are overlapped by polygons and then buffer them, this is one approach that may work to get started.  Note the Expression in the Make Feature Layer for the Pipes_test feature class to limit the results right from the start to just 8 inch diameter pipes. To improve on this, you may want to add a Spatial Join so the attributes transfer across from your selection areas (in this case the feature class PipeSelectionZones) to the output. Spatial Join—Help | ArcGIS Desktop  About joining the attributes of features by their location—Help | ArcGIS for Desktop  After the buffer, one could Dissolve the result of the buffer. Dissolve—Data Management toolbox | ArcGIS Desktop  Can you explain why the Feature to Line is being employed?  Does the end product need to be lines from the end buffer?  Or was the Feature to Line used originally as a potential solution but not needed? Anyways, that's my guess on what is required based on what was stated.   However, there may be other variations that accomplish the goal better - much would depend on further details of the project goals. Chris Donohue, GISP ... View more