Latest Contributions by LanceCole

Anna, If you are in reference to having to have Excel 2007 installed to use XLSX files even when you have a newer version installed.  There are several workarounds depending upon which version of ArcGIS you are using.  Please take a look at Understanding how to use Microsoft Excel files in ArcGIS and select your version of ArcMap for specific instructions.  You may need to install the Microsoft Access Database Engine 2010 Redistributable as Microsoft has discontinued support for the Office 2007 drivers. This package will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.  One other note, I believe you need to download and install the 32-bit version of the Microsoft Access Database Engine 2010 Redistributable even for 64-bit systems on ArcGIS Desktop and Pro. ... View more

I hate to give this reply but, have you tried restarting your system.  The standard IT response.  You may have a temp file with an orphaned lock file.  We have see this or similar errors especially, if we have been having network problems to file shares. ... View more

Vasiliki, With the georeferenced image loaded make sure the correct image is selected in the dropdown in then go to the View Link Table button on your Georeferencing toolbar.  This will display the links you previously created and should enable the Update Georeferencing and Rectify options once the Link window is open.  You can add and delete the previous georeferenced link points from here including all of them. ... View more

To add the excel sheet to ArcMap please see Adding a Microsoft Excel table to ArcMap.  This will appear under the List by Source tab of your table of contents. To display this in ArcMap either the excel sheet has to have X, Y and Z (if needed) data or it need to have a common index to link the data to other features.  I am assuming the excel sheet has the coordinate data you can use Adding x,y coordinate data as a layer.  This data will now display in your ArcMap session. As to what else you are trying to do, it is a little ambiguous and you would need to clarify your request. ... View more

Ali Azzouhri, You can try a few things by logging onto my.esri.com. 1) once logged on, go to My Organization > Overview, their should be an option to "Contact My Administrator" or their contact info 2) Also on this page should be ESRI contact(s) for your Customer Service Representative, they can help you as well determine who is your ESRI Administrator.  Or you can contact ESRI general customer service for your area 3) As another option go to My Organization > Manage Users, their may be a list of users including one that has "Admin" next to their name.  This option will be dependent upon your level of access and type of licensing. 4) If this is in response to an ArcGIS error message to contact your administrator and you are the only one using/or installing ArcGIS components, that would be you. Sorry. Because of the sensitive information contained on the pages noted above, I cannot send any screen shots. ... View more

Siran, An afterthought... give this approach a try since you are trying to display a linked table data in collector. 1) Remove the joins in your map on the ArcGIS platform you are publishing from 2) Add a Relationship Class to the database between the feature class and table you need to link the data.  Note that a relationship class is not the same as creating a in memory join or relates.  If needed, please see Creating a Simple Relationship Class for additional information.  You will need a relationship class for each feature class to be linked to the table.  Although, all of the feature classes can point to the same table, if needed. 3) Publish the feature classes and table to AGOL as feature Service.  The relationship classes will transfer when you publish the data. 4) Create a AGOL Map with the data published and save.  Please insure at least one feature is editable so it will show in the available maps to Collector. 5) Open the Map in Collector. 6) Select a feature that has a relationship class to the underlying table.  A link will be available to the table row in the attribute information for the feature selected as shown below. 7) Select that link and the information from the linked row will be displayed. You can even edit the data by selecting Edit, if enabled. I hope this is helpful.  let me know if you have any questions. ... View more

Siran‌, I believe this is by design, in memory joins and relates are not supported to be published.  Please see Author maps to publish feature services. Joined data When you publish a map service with feature access capability to a GIS Server site, joined columns are included in the map service but are not included in the feature service. The feature service includes only the columns from the join table (the table or feature class on which you defined the join). If symbology for the layer is based on a joined column, the map service includes the renderer you used to symbolize features, but the feature service reverts to a simple renderer. If the renderer in the layer is based on a column from the left most feature class in the join, the map server and feature server include the renderer. You cannot publish joined data to an ArcGIS Enterprise portal or ArcGIS Online. Remove joins before publishing a feature service (hosted feature layer) to either of these applications. That being said, you can publish your features and table(s) with out the joins then create a hosted feature layer view in AGOL.  Please see Join Features analysis tool fro AGOL.  Make sure you check the "Create results as hosted feature layer view" at the bottom of the tool before running the analysis.  Unfortunately, this is a view and not directly editable although you can edit the underlying table and feature services.  However, once have used the Join Features Tool on your data you cannot update the data by republishing from ArcGIS Desktop or Pro when using this method.  Please see Create hosted feature layer views for additional information and limitations. Hopefully, Collector will support Arcade Expressions in a near future release.  This can be done using a lookup with Arcade in about 3 lines of code to build an expression for AGOL Pop-ups, but it does not function in Collector at this time. Another option would be to append your needed URL to your feature data as an attribute before publishing if you need to regularly update your data. ... View more

Dan, I agree.  Typically seeing zero (0) data is a red flag something is up unless expected. ... View more

Roberto, Seeing the zero (0) in your data makes me wonder if you may have holes or voids in your original data.  You may want to try and combine focal statistics with another function such as Elevation Void Fill, Fill, or possibly even Nibble depending upon your data type. ... View more

Kaeleigh, What is the file extension of the file you are trying to add, JPEG?  If so, rename it to JPG and try to add it again. Lance ... View more

Andrew, If you are truly using a utility data model, I would be careful there are many interrelations that could be broken.  At this time it may be better to load the full model and just not use the portions you do not need.  This model is meant to be starting point for you to expand upon.  Potions of these can be removed from your project so you do not need to see them but the underlying data schema should remain in place.  Take a look at Utility Network Data Models are just a starting point. ... View more

Hi Todd,  Do you need ArcGIS Desktop, no you can get by without but It is easer to work with data in desktop and publish a feature to ArcGIS Online (AGOL).  For creating a feature service or two in AGOL it is easily possible, but as your projects get bigger it is easier to use ArcGIS Desktop or Pro.  You can purchase a personal use copy at ArcGIS For Personal Use | Buy ArcGIS Software Online for $100 per year.  This version is for personal use only. Collector does not really have questions as such.  You create a feature class, linked table or service that have attributes.  As I believe we discussed previously,  a “table” could be a feature class with the attributes of length, width, height, material, condition, etc.  You can create another feature called “bench” with the same attributes or make it a sub type of feature class called “Fixtures” as it has they have the same attributes.  In Collector you can drop point features based upon a selected feature type and populate the attributes for that feature.   Download and and install the collector app on a mobile device.  Once installed open the app and select “No account - Try It” on the log in screen.  Select one of the available maps such as the “Forest Activity Tracking”.  Once loaded touch the blue + in the bottom corner and add a new point.  You can see how you can input the attributes for this point feature and save the date to an AGOL feature service.  Here is some additional info on Learn ArcGIS | ArcGIS Collector. Another good example of using collector to collect info about assets is the “Hydrant inspection” from the “Try It” listing.  This version uses a AGOL feature service to display hydrants and other info on a web map.  Once you select a hydrant there is an option to collect additional information or questions about the specific hydrant.  This information, for this example, I believe is stored in a secondary data table and liked to the hydrant by the Facility ID.  The same process can be used to open and collect a 123 Survey. Survey123 you create a series of questions in an excel worksheet format called XLSForm.  The Survey123 Connect application takes this excel data and processes to produce a survey that asks the questions you created and collects the answers in the form of drop downs, select buttons, lists, text, etc.  The XLSForm can be customized to be dynamic depending upon how you answer one question to modify subsequent questions. Once you are happy with the survey in Connect you publish the survey to AGOL and you can access it via the Survey 123 App.  See Create your first survey—Survey123 for ArcGIS | ArcGIS or Survey123 for ArcGIS XLSForm Tutorial on YouTube. As noted previously, start small and work up from there.  It sounds like you may be more familiar and comfortable with Survey123.  Try to work through the five part video and create a survey.  Once you get that to work, customize it to collect information for a camp site with a table, add the ability to collect for a bench, add another feature. Once you get a few items working add conditional questions to show hide additional questions.  Keep building from there.  Try to publish it to AGOL and see how it looks in the app.  Do not try and create an entire survey in one setting.  Add a date field and test it in Connect, add a drop down and test it in Connect, add a text questions and test agin.  If you have questions about why something is not working or how to do something, post your XLSForm and guaranteed someone on GeoNet will lend a hand for that problem.  GeoNet, Google and YouTube will become your best friends. Lance - When you like or find a response helpful, please like or mark it as helpful - ... View more

Allisyn‌,  Your configuration is very similar to the setup we are currently using for our operations.  Our RTK is running on GCS NAD 1983(2011).   We are using ESRI base maps for field work on the collector units which are WGS 1984 Web Mercator Auxiliary Sphere.  The transformation we are using is WGS_1984_(ITRF00)_To_NAD_1983_2011.  One item you do not note in your question is what coordinate system is your feature data service published to AGOL for collection.  As our enterprise database is using NAD83(2011) Ohio State Plane North, this is what we publish our feature services to AGOL.  AGOL and Collector handle the transformation from GCS NAD 1983(2011) to PCS Ohio State Plane North NAD 1983(2011).  This has worked well for us. We also have to provide our data to several other agencies in WGS84 and NAD83(1986) so we have projection scripts running to process this information on a nightly schedule and generate deliverable files.  To insure there have not been issues introduced somewhere in the process, we have about 30 control points over a 35 square mile area that at least two control points are collected in the field on a daily basis for each device.   We have a set of confirmed points, for each coordinate system, that the script looks for variance between the data and the controls outside the accuracy of the GPS. These control points serve two functions: 1) used internally to pick up potential errors in the collection process or equipment 2) for transformation verification A couple of examples how we used this approach. One morning we came to find an email from our GIS server that the previous day’s data collected from one device was outside our acceptable limits (substantially).  After reviewing the data and the device it was found that the user had selected the correct GPS but forgot to change the profile and wrong RTK was being utilized. The problem was quickly found and we only lost a day’s production data for that device.  We now run a check on the data as it is posted to AGOL several times a day to catch this sooner. Another example as when we first attempted to project our data to from NAD83(2011) to NAD83(86) it did not go well.  No matter what we tried the data was always off after translation.  After a little research, it turned out it was too big of a step to go from NAD83(2011) to NAD83(86). We need to add an intermediate step of converting to NAD83(HARN).  However, because we had control points, available in the deliverable datum, this was blatantly obvious before we delivered the data. In setting up our program, we chose to minimize the number of transformations while collecting and storing the field data and perform post collection transformations to get the data in the form needed.  Each transformation in the field introduces a potential point of error that cannot be undone.  We collect our field data in NAD83(2011) Ohio State Plane North, however, since we also collect our GPS metadata we have the raw GPS data (lat, long and altitude) from our RTK service in GCS NAD 1983(2011), height above elipsoid. One other factor to consider, in comparing your data to control points and day to day repeatability, is the accuracy of your equipment and correction service.  If you are collecting data to 1 foot accuracy, keep in mind that is typically a plus or minus or a 2 foot diameter circle.  If one day you collect a point that is on the plus 1 side and the next day collect the same point on the minus 1 side.  These two points will be 2 feet apart.  Furthermore, that 1 foot accuracy is if the accuracy was 1 foot and not collected under a tree near a building reducing your accuracy to maybe 2 or 3 feet (a 4 or 6 foot diameter circle). ... View more

Hi Allisyn‌,  Two quick questions and I will work on a reply later today. 1) When you say the client wants the deliverable in NAD83 is that NAD83(86) or NAD83(2011).  Also is this GCS or on a different coordinate system such as a State Plane system 2) Are you interested in XY data only or Z data as well? ... View more

alexander nongkhlaw‌,  Yes, just keep going collecting the other data. For the other symbols like fold axis, vertical joints, fault contact, etc.  These will also be oriented with the long axis of the symbol along the direction of the feature.  Not all of these have a related dip but just a direction.  Please see a sample of fault symbols below.  The same would apply for foliation and joints. ... View more