Latest Contributions by HanliePretorius

Hi Sara, In my case the problem stemmed from a regional setting on my computer. My locale's decimal character is a comma by default, not a full stop. When I vary from the default, I get the behaviour I described above. I'm not sure if mobile devices have such a setting and whether it's relevant for you. Probably not if you are in the US. Sorry I can't be more helpful. Regards Hanlie ... View more

Hi Andrew, Thanks for the video. My other colleagues also don't experience my problem - hence the frustration. We are not in the US and I suspect it might have something to do with my computer's regional settings, but I don't know exactly what. My tests so far have failed to identify the culprit. For now I'm using integers and asking the users to insert the factors as 'percentages' - 0.8 should be entered as 80. Then I divide the user entry by 100 and use the result in my calculations. I suspect this will be one of those questions that do not have an answer, only a workaround. Regards Hanlie ... View more

Thanks for the reply Andrew. I tried that but it made no difference - the decimal value still disappears when I navigate from record to record. I'm considering making them integers and asking the users to multiply their values by 100 just to get on with the job. Regards Hanlie ... View more

Hi Dana, Thanks for the reply. In the end I used something similar to what you describe, except I did it straight in SQL. This is the code I used: select vs.PropertyID , vp.PROPERTY_ID as VALUATIONPROPERTY , p.PROPERTY_ID as PROPERTY from new_valuation_fc vs left outer join old_propery_fc vp on vp.PROPERTY_ID = vs.PropertyID left outer join new_property_fc p on vs.PropertyID = p.PROPERTY_ID where p.PROPERTY_ID is null That gave me everything in the new_valuation_fc linked to PropertyIDs that do not exist in the new_property_fc. I had some help from a colleague with this and it seemed to do the trick. Cheers Hanlie 2020-10-26 19:38 GMT+02:00, Dana Nolan <geonet@esri.com>: Dana Nolan replied to the discussion "Re: Finding the records that participate in a relationship" To view the discussion, visit: https://community.esri.com/message/961154-re-finding-the-records-that-participate-in-a-relationship?commentID=961154&et=watches.email.thread#comment-961154 > ... View more

Thanks, this worked for me but changes are only visible after creating, saving, updating and saving. ... View more

Thanks for the information - looks like a very useful workflow. 2018-12-12 0:15 GMT+02:00, Michael Fletcher <geonet@esri.com>: Michael Fletcher replied to the discussion "Re: Feature service not executing DB triggers" To view the discussion, visit: https://community.esri.com/message/818908-re-feature-service-not-executing-db-triggers?commentID=818908&et=watches.email.thread#comment-818908 > ... View more

Thanks for the reply; that might be the issue but I can't check today. Do you know of any documentation beyond the data dictionary for the CapitalPlanning feature dataset? The dictionary is rather sparse in its information. 2018-03-01 14:30 GMT+02:00, Scott Oppmann <geonet@esri.com>: Scott Oppmann replied to the discussion "Re: Manual installation of Capital Improvement Plan solution" To view the discussion, visit: https://community.esri.com/message/754168-re-manual-installation-of-capital-improvement-plan-solution?commentID=754168&et=watches.email.thread#comment-754168 > ... View more

Hi Jonathan, Incrementing an ID field (TreeNumber) automatically from a feature service is problematic because of the way the REST service communicates with the database - it goes back and forth several times, possibly because ArcGIS first creates the feature with an ObjectID and a Shape and then updates this record with attributes. In the front end it all looks like one process, but in the background it's two. I have actually abandoned that idea and now generate TreeNumber values only in the desktop. If you still want to try to auto increment an id field using a feature service, just make sure you refresh everything after you have saved before you decide if it worked or not. So, close the edit tool and zoom in and out, then you should see the changes. That was what I meant by the statement you highlighted. Hope this helps Hanlie ... View more

I could not figure out what the problem was, so I used a completely different approach, bypassing the CSV file. I tried using a CSV file primarily because Make XY Event layer is apparently a very fast operation and the original file doesn't have a consistent spacing between its columns. However, Python is clever enough to seperate out the columns. Also, I only work with small amounts of data, so speed doesn't really matter. In case anyone is interested, the code is below. It reads a text file as input of a very specific format, of which the first few rows are: $  1,  19, 0, 4, 1 13062016 0      93472.9    3657803.3  105530   47701 0000      93453.0    3657772.8  105545   47760 0000      93449.5    3657739.5  105600   47820 0000 The first two lines contain meta data and the columns are Easting, Northing, Time, Ping Number, Ignore. #------------------------------------------------------------------------------- # Name:        Txt2Line # Purpose:     Converts survey points to lines - one line per text file # Usage # ----- # Assumptions: # 1. Text files and shapefile are in the same folder. # 2. Shapefile contains at least the following attributes: #    LineNumber (text, 20) #    LineDate (text, 😎 # 3. Shapefile is defined with the same spatial reference as the text files # 4. Data points start on the third line of the text file and contains #    the columns Easting, Northing, Time, PingNumber, Ignore seperated by spaces # 5. Data points in text files are in time order. #------------------------------------------------------------------------------- import glob, os, csv , arcpy # folder that contains the text files and the shapefile inFolder = r'C:\temp' # specifiy file type to search for fileExt = 'nvx' folderExt = os.path.join(inFolder, '*.' + fileExt) # sepcify shapefile name - should be in the same folder as text files polylineFC = os.path.join(inFolder, 'SurveyLines.shp') # assume text files uses the same spatial reference as the shapefile spatialRef = arcpy.Describe(polylineFC).spatialReference # Set environment settings arcpy.env.workspace = inFolder def readFile(inFile):     """     Convert a space delimited file with two header lines to an arcpy array     of points and convert the points to a line.     Assumption: points in shapefile is in ping number order.     """     # get survey line name from file name - strip extension     base = os.path.basename(inFile)     lineNumber = os.path.splitext(base)[0]     print 'Line number ', lineNumber     #initialise a list to hold all the lines in the text file     allLines = []     # read lines in file into a list and remove line break charaters     allLines= [line.rstrip('\n') for line in open(inFile, 'r')]     # get survey line date (second line in file) and  first element in this line     lineDate= allLines[1].split()[0]     print 'Line date ', lineDate     print 'This file contains ', len(allLines)-2, ' data points'     # create an empty array object to hold points (vertices)     vertexArray = arcpy.Array()     # run through text file from the third line to the ned     for pointNumber in range (2,len(allLines)):         # print pointNumber, ':', allLines[pointNumber]         # split line from file into elements of a list called dataItem using the spaces in between items         dataItem = allLines[pointNumber].split() ##        # throw away 5th element (column) in list ##        dataItem = dataItem[:4] ##        print dataItem         #dataItem = dataItem.append(lineName)         #dataItem = dataItem.append(lineDate)         # write row to temporary csv file         #wr.writerow(dataItem)         # get northing coordinate (second element in dataItem list)         lat = dataItem[1]         # print lat         # get easting coordinate (first element in dataItem list)         lon = dataItem[0]         # print lon         # print dataItem         # create point feature from lat lon coordinates         vertex = arcpy.Point(lon,lat)         # print vertex         # Make a point from the coordinate and add it to the array         vertexArray.add(vertex)     print 'Created ', len(vertexArray), ' points from file'     # use vertex array to create line feature and insert into shapefile     # with line number and line date as attributes     try:         with arcpy.da.InsertCursor(polylineFC, ("SHAPE@",'LineNumber','LineDate')) as cursor:             polyline = arcpy.Polyline(vertexArray, spatialRef)             cursor.insertRow((polyline,lineNumber,lineDate))     except Exception as err:         print(err.args[0]) def main():     # search for file names that end in the specified extension     fileCount = 0     for fileName in glob.glob(folderExt):         if fileName.endswith('.'+fileExt):             print 'Found file ', fileName, ' processing it...'             fileCount += 1             # process files of the specified type in the function readFile             readFile(fileName)         else:             print 'No files found'     print 'Processed ', fileCount, ' files successfully' if __name__ == '__main__':     main() ... View more