Latest Contributions by DianaHu

What version of Python interpreter are you using?  I had this error when I was trying to manipulate some dataset, but the problem went away once I switched from 32 bit interpreter to 64 bit interpreter. ... View more

About Personal ArcSDE (also called "Desktop Geodatabase" or "ArcSDE Personal Server" in some documents by ESRI): I fully agree this is badly documented, but on the other hand, once you realize there is actually no real distinction between Personal, Workgroup, and Enterprise Geodatabases, except a licensing scheme determining the maximum no. of concurrent users for the geodatabase (Vince may protest here, but for the sake of this thread, I think it valid), it actually turns out to be surprisingly simple : *** STEPS TO INSTALL "PERSONAL ARCSDE / DESKTOP GEODATABASE" *** (E.g. with "ArcGIS for Home Use" license based on "ArcGIS for Desktop Advanced") * EDIT: * It may be advisable to reboot in between / after some of these steps, e.g. installing SQL Server, so as to ensure all services are properly running and usable for the next step. 1) - Install SQL Server 2012 Expresss I am not going to detail all steps of the SQL Server installation here, use the Microsoft documentation if in doubt. Basically, you can choose almost all defaults, as the 2012 version of SQL Server installation already sets it all up under restricted Windows accounts, so rather safe. The defaults will install "extra's" like the Reporting Services that aren't necessary for the functioning of an ESRI Geodatabase, so you may prefer to opt out on these "software developer / SDK options" of the installation. NOTE: you can also use the ArcGIS for Desktop 10.2 installation to install SQL Server 2008 R2 Express, as it is included in the desktop installer, but since I guess you will want to use the "latest", install 2012. 2) - Create a new instance in the process of the installation of SQL Server. Record the name of the instance for later use. 3) - Ensure you are logged in as a full Windows Administrator on your PC. This is very important, if you don't do this, the enabling of the database for geodatabase storage may fail. Make sure this administrative login is also registered with your SQL Server Express if you haven't already done so during the install of SQL Server Express (which is usually the case, so you can probably skip this). 4) - Start the ArcGIS for Desktop 10.2 installation. NOTE: Yes, you need the installation for ArcGIS for Desktop , not ArcGIS for Server . So you can use the installation that is part of the 10.2 Desktop Advanced "ArcGIS for Home Use" program. It is downloadable from the Customer Care portal once you receive your license from ESRI. 5) - Once in the main screen, choose ArcSDE for Microsoft SQL Server 2008 R2 Express as the installation option. NOTE: don't worry: it won't automatically overwrite or re-install your SQL Server 2012 Express, see next steps. 6) - Once the install wizard appears, choose Next 7) - In the next dialog that appears (Installation Options), deactivate the Microsoft SQL Server Express Edition option, since you already installed it in step 1). Leave the Enable geodatabase storage on SQL Server Express checked. You want your database to be enabled to use ESRI Geodatabases. 😎 - Click Next 9) - In the Choose a SQL Server Instance and add a Windows login dialog, choose under SQL Server instance name your instance created in step 1), e.g. YOUR_COMPUTER_NAME\YOUR_INSTANCE. Add a valid Windows Login who will administer the geodatabase, e.g. YOUR_COMPUTER_NAME\YOUR_LOGIN_NAME. Note the YOUR_COMPUTER_NAME, since we are using Personal ArcSDE on SQL Server Express, your local PC is likely the server. 10) - Click Next and finish the installation. You can also close the ArcGIS for Desktop installation window now, as you no longer need it. Your database should now be enabled for creating geodatabases 11) - To create a geodatabase, DON'T USE THE "Create / Enable Enterprise Geodatabase" TOOLS!!! I can not emphasize this enough. As the name of the tools already indicates, these tools only work against "enterprise" databases, not on SQL Server Express! 12) - To create an ESRI Geodatabase on SQL Server Express, simply create a new Database Server(!) connection to the SQL Server instance in ArcCatalog using the Add Database Server option under Database Servers in the Catalog Tree of ArcCatalog. NOTE: I wrote Database Server , not Database Connection . You must first create a Database Server connection, as only a Database Server connection contains the context menu option to create a New Geodatabase, as in step 13). 13) - Now right click the new Database Server connection, and choose New Geodatabase from the context menu. Yes, it is that simple! No hassle with an authorization file as in the "Create / Enable Enterprise Geodatabase" tools. The authorization of ArcSDE Personal Server forms an integral part of your ArcGIS for Desktop license, and was applied in steps 4) to 10). NOTE 1: In order for this step to work, you must have an ArcGIS for Desktop Standard or ArcGIS for Desktop Advanced license. This doesn't cost you anything extra with an ArcGIS for Home Use license, it is just another licensing scheme you need to activate / authorize from the ArcGIS Administrator included with ArcGIS for Desktop. In Desktop Basic the New Geodatabase option is disabled in the context menu. NOTE 2: After you have created the geodatabase via the Database Server connection, you can now also use the Add Database Connection option in ArcCatalog, to create a new Database Connection to your geodatabase. Congratulations, you have just created your Personal ArcSDE / Desktop Geodatabase in SQL Server 2012 Express! Hi Marco, I am following your instructions and thank you they have been very helpful.  Just a question, I already have ArcGIS for Desktop installed, do I need to uninstall then reinstall to get the option for step 7?  Right now, I am able to connect to my instance, but when I use the "new geodatabase" option then I get an error, so I wonder if it has to do with me skipping step 7. My license is "Advanced". [ATTACH=CONFIG]28981[/ATTACH] ... View more

OK, now I am looking for more help to organize these JPGs. Now all the JPGs are in one folder (C:\temp), I want to copy them into different folders based on the field "Wall_Num" (numeric) in a feature class "Result", and rename them based on a field called "JPG" in the same feature class, e.g. "Tree.jpg".  The "Result" feature class holds the original name of these photos in a field called "PhotoPath2", e.g. IMG_0070430.jpg.  I also have created a table that holds unique values of the all "Wall_Num" values called tbl_Wall_Numbers. My plan was to: 1.  Create folders based on the "Wall_Num" in tbl_Wall_Numbers using search cursor (done) 2.  Create Query Table with the name "Wallx", with records "Wall_Num" = x (x being "Wall_Num" value) (seem to have worked, no errors, but I could not tell if it executed successfully...also have tried with create feature layer and selectlayerbyattribute) 3.  Use search cursor to go through Query Table row by row, and if current filename matches "PhotoPath2", rename it using "JPG" (maybe this is where the problem is, I am trying to use a cursor nested inside another cursor...other ways to do this?)             os.rename(file, file.replace("\"[PhotoPath2]\","\"[JPG]\")) 4.  Copy the JPG into the correct folder, based on its "Wall_Num" value until all JPGs in temp are copied 5.  Repeat 2 - 5 for all "Wall_Num" in tbl_Wall_Numbers. Another question sort of related to this: how do I get rid of the querytable?  Once I try to run the same process again, it will say querytable "Wallx" already exists.  I have overwriting geoprocessing results turned on. Thank you for pointing me to the correct direction! ... View more

Thank you Marc, I will digest the codes a little bit first myself.  This is some amazing stuff! That.... is a thing of beauty!!! Thank you so much for sharing that, Luke! I just want to say that in the interest of giving the poster a smaller bit of code to dissect, one could make a smaller version using a filter and the exact example you were inspired by on the OS example page. import os class DirectoryWalker:       '''Callously stolen (with attribution!) from os-path-walk-example-3.py       Copyright © 1995-2010 by Fredrik Lundh       http://effbot.org/librarybook/os-path.htm'''           def __init__(self, directory):         self.stack = [directory]         self.files = []         self.index = 0     def __getitem__(self, index):         while 1:             try:                 file = self.files[self.index]                 self.index = self.index + 1             except IndexError:                 # pop next directory from stack                 self.directory = self.stack.pop()                 self.files = os.listdir(self.directory)                 self.index = 0             else:                 # got a filename                 fullname = os.path.join(self.directory, file)                 if os.path.isdir(fullname) and not os.path.islink(fullname):                     self.stack.append(fullname)                 return fullname import shutil search_dir = r'C:\Project' out_dir = r'C:\Workspace' # This filter takes all the results from DirectoryWalker and only iterates # through those that match the condition 'file.endswith('.jpg') for jpg in filter(lambda x: x.endswith('.jpg'), DirectoryWalker(search_dir)):     print('Copying: ' + jpg)     shutil.copy(jpg,out_dir) Diana: If you need any help understanding either of these examples, feel free to ask. Cheers, Marc ... View more

I really appreciate your help! Thank you thank you thank you! You could use a recursive 'glob': class rglob:     '''A recursive/regex enhanced glob        adapted from os-path-walk-example-3.py - http://effbot.org/librarybook/os-path.htm     '''     def __init__(self, directory, pattern="*", regex=False, regex_flags=0, recurse=True):         ''' @type    directory: C{str}             @param   directory: Path to search             @type    pattern: C{type}             @param   pattern: Regular expression/wildcard pattern to match files against             @type    regex: C{boolean}             @param   regex: Use regular expression matching (if False, use fnmatch)                             See U{http://docs.python.org/library/re.html}             @type    regex_flags: C{int}             @param   regex_flags: Flags to pass to the regular expression compiler.                                   See U{http://docs.python.org/library/re.html}             @type    recurse: C{boolean}             @param   recurse: Recurse into the directory?         '''         self.stack = [directory]         self.pattern = pattern         self.regex = regex         self.recurse = recurse         self.regex_flags = regex_flags         self.files = []         self.index = 0     def __getitem__(self, index):         import os         while 1:             try:                 file = self.files[self.index]                 self.index = self.index + 1             except IndexError:                 # pop next directory from stack                 self.directory = self.stack.pop()                 try:                     self.files = os.listdir(self.directory)                     print self.files                     self.index = 0                 except:pass             else:                 # got a filename                 fullname = os.path.join(self.directory, file)                 if os.path.isdir(fullname) and not os.path.islink(fullname) and self.recurse:                     self.stack.append(fullname)                 if self.regex:                     import re                     if re.search(self.pattern,file,self.regex_flags):                         return fullname                 else:                     import fnmatch                     if fnmatch.fnmatch(file, self.pattern):                         return fullname import shutil search_dir=r'C:\Project' out_dir=r'C:\Workspace' for jpg in rglob(search_dir,'*.jpg'):     print 'Copying: ' + jpg     shutil.copy(jpg,out_dir) ... View more