Latest Contributions by OliverMorris

Table Valued Functions in SQL Server, PostGIS and Oracle are a fantastic way to pull back data to GIS simply by passing a variable. This avoids the need of creating thousands of views, you can simply have one TVF and pass a parameter or two.   At the moment you can add a table valued function into GIS using a select * statement but for some unexplainable reason the data that is plotted on the screen is correct but the attribute table doesn't show all the data contained within the TVF. Apparently this is because the TVF does not support Spatial Indexes but alas you can add views without Spatial Indexes using this method and view content within the attribute table without issue.   Instead of this being reported as a bug, ESRI has suggested posting this as an Idea/enhancement request. They have duly raised an enhancement request – ENH-000102584. If this was truly a query layer it should support all sql object (TVF's, Stored Procedures etc) rather than just provide support tables and views.   Please vote for my suggestion. If you use lots of views from a database, trust me this will be saving you hours.   Cheers   Oliver ... View more

Hi, We are tying to use the API within asp.NET 4.5 on IIS 7.5 we cannot load 3 modules including: Esri.FileGDBAPI.DLL FileGDBAPI.DLL FileGDBAPID.DLL In a console on windows 8 it runs fine but through asp.NET it simply doesn't load/work. The paths are correct all the dll's are in the Bin path, IIS is set to run it as a 32bit application, we also added the dll's to the GAC. Does anyone have any ideas why this is and any solutions. Thanks, Oliver ... View more

Hi, Thanks for your help in advance. Using only the file geodatabse api is it possible to convert a table (with lat and long) in a file geodatabase to a point feature class? If so can you please let me know the steps involved or some documentation. Many Thanks, Oliver ... View more

Be able to see and report using ArcPy what version and mxd or lyr file is e.g. 10 or 9.3 etc ... View more

Hi, I am creating a layer with python, is there a way of renaming it immediately or a way to identify what layer was just added so I can rename it, see code below: import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] layers = arcpy.mapping.ListLayers(mxd, "", df) words = ['curpm1', 'curpm2', 'curpm3'] for word in words:     print word     groupLayer = arcpy.mapping.Layer(r"C:\Users\oliverm\Desktop\GIS1\GL1.lyr")     arcpy.mapping.AddLayer(df, groupLayer, "BOTTOM")     'rename layer here' Thank you very much for your help, I ideally want to be able to create the newly added layer as one of the list words. Oliver ... View more

One issue that is really holding us back is the ability to permission feature classes in an SDE by adding levels of permission such as: read only with export enabled and read only with export disabled (i.e. block feature class export to option) Preventing the ability for desktop users being able to be able to export feature classes from inside ArcMap or ArcCatalog would really help our data management and ensure that users are not hoading copies of copyright sensitive data on their own c: drive. If this could apply to feature classes, regardless of participation in a dataset or not that would be great. Anything that you could do to add this functionality would help greatly. ... View more

Hi, I have been trying to get this code to work for the last couple of hours, if anyone could give me some help that would be great. I would like to repoint any broken links to a new table that lies within a personal geodatabase. The code I have is: import arcpy, os path = r"N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH" for fileName in os.listdir(path):     fullPath = os.path.join(path, fileName)     if os.path.isfile(fullPath):         basename, extension = os.path.splitext(fullPath)         if extension == ".mxd":             mxd = arcpy.mapping.MapDocument(fullPath)             print "MXD: " + fileName             brknList = arcpy.mapping.ListBrokenDataSources(mxd)             for brknItem in brknList:                  lyr.replaceDataSource (r" N:\Temporary_Work\mapping_2011.mdb",        "ACCESS_WORKSPACE", SEA_110617)                  print "\t" + brknItem.name del mxd When I run this I get the error - Runtime error <type 'exceptions.NameError'>: name 'SEA_110617' is not defined Can you please point me in the right directions. Thanks, Oliver ... View more