Latest Contributions by MarcoBoeringa

Ok, you might have convinced me.  I will look at reinstalling tomorrow. Forkandwait, although Vince's recommendation of reinstalling ArcGIS for Desktop entirely makes sense if you have been uncareful or highly confused while doing all this, I think you don't necessarily need to re-install if instead you have been careful in tracking and documenting which files you copied to ArcGIS's Bin folder. In that last case, simply removing any files you added to the Bin, and copying the right 32 bit files as a replacement, should solve the issues without a complete re-install. In essence, the files you need to remove and replace by their 32 bit counterparts, are the five files I referenced before, based on ESRI's Help documentation: libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll So ... where do I find the files I need again?  In the postgres installation, copy to bin64?  Or the .exe mentioned a couple of threads back? If there is a link to the download on the customer care site that would be great... NO, you SHOULDN'T be copying anything to a bin64 folder. What you need to do is to get the 32 bit versions of the five above mentioned files from the ESRI Customer Care portal (in the "pg_client_windows86" client library download as documented on this Help page), and copy these as a replacement in the ArcGIS for Desktop "Bin" folder, as described here. Also make sure to follow all other possibly necessary steps described there! The Customer Care portal is here: https://customers.esri.com If you are logged in (If not: login!), you should have access to downloads. You can find the necessary files under - "Software Downloads" - "DMBS Support Files" - Scroll down until you see "PostgreSQL Client Libraries (Windows)", should be 2.21 MB big file download, so small. - Click "Download" In the downloaded file should be the "pg_client_windows86" client set of libraries containing the necessary 32 bit version of the above mentioned five files. Copy these to the ArcGIS for Desktop "Bin" folder. Good luck! ... View more

Thanks for your help, Vince.  Replies below. Umm, I installed PG with 64 bit, which is specifiied as OK here: http://resources.arcgis.com/en/help/...00000075000000 What? If the install is from PG 64 bit, then why would I need to run the file command, etc? I don't really want to reinstall (yuck!)  I am going to find out our customer number and download the file you speak of.  Is it a self-installer (from the "exe")?  It should just clobber the old files, right? Forkandwait, I don't think you need to re-install yet, nor re-do your 64bit PostgreSQL, as you correctly remark a 64 bit PostgreSQL install is listed as "supported"... If I understand Vince well, he is actually trying to say to you that the thing you CAN'T do is, is to copy the 64 bit DLL's from your essentially 64 bit PostgreSQL install, to the ArcGIS for Desktop Bin folder. You need to copy 32 bit DLLs there, either from a 32 bit PostgreSQL install, or by downloading them from the ESRI Customer Care portal. I guess downloading them from the ESRI site, and replacing all the files you put in your ArcGIS Bin, is the easiest and safest thing. If it than still fails, maybe more drastic measures are in order... ... View more

I'm having trouble loading a somewhat large (700 MB uncompressed, 540 MB zipped) shapefile to AGOL. I'm working with an Organizational account, and am loading using the Add Item button under My Content. I understand this is the most reliable way to load large datasets. The shapefile has a lot of features, 231,698 polygons. I've tried twice to load it, and get this message: Unable to load http://usgs.maps.arcgis.com/sharing/content/users/ahrea/968e162241994b2ab8d3110aa3defc37/addItem status: 0 Any ideas?  Thanks much. I have never used ArcGIS Online, but this really sounds like something to take up directly with ESRI customer support, not on a users forum. You may well be hitting some limitation to your account. Lastly, it probably is recommendable to run "Check Geometry" before trying to upload anything that large online. You don't want to sit back and wait 4 hours for something to upload, only to discover it failed because of bad geometries. ... View more

I placed the following in both my blahblah/desktop10.1/bin64 and my stuff/bin directory, copying from my recent 9.1 Postgres installation: libeay32.dll  libintl-8.dll  libpq.dll  ssleay32.dll Still running the same Postgres installation as described from the version queries above. Don't know if this is the issue, but this Help page: Setting up a connection to PostgreSQL states you actually need 5 files for a 32-bit client like ArcGIS for Desktop. You seem to be missing the underlined file: "pg_client_windows86: Includes the client files required to make a connection from a 32-bit client on a Windows operating system to a PostgreSQL database. Files are libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll" The four file client setup is for 64-bit clients, I guess the Help means ArcGIS for Server / ArcSDE. By the way, it is slightly confusing on this Help page, but if I understand it well. the pg_client_windows86 does NOT refer to the Windows itself being 32- or 64-bit, but to the specific software you are running being either 32-bit (like ArcGIS for Desktop), or 64-bit (like ArcGIS for Server / ArcSDE). As the Help page also states: "Be sure to download the correct libraries for your ArcGIS client. For ArcGIS for Desktop and ArcGIS Engine, you need the 32-bit libraries. For ArcGIS for Server, you need the 64-bit client libraries." You probably already read this one, but this Help page may be of use to others too, as it lists some of the prerequisites for setting up Query Layers: Preparing to use query layers ... View more

This page of Refractions Research lists PostGIS 1.5.1: http://postgis.refractions.net/download/windows/pg84/ And this page PostGreSQL 9.0.5: http://www.postgresql.org/ftp/source/v9.0.5/ These pages you probably already know may be of use: PostgreSQL database requirements for ArcGIS 10.1 http://resources.arcgis.com/en/help/system-requirements/10.1/index.html#//015100000075000000 Which versions of PostgreSQL and spatial types are supported with ArcGIS 10.1 and ArcGIS 10.1 SP1? http://support.esri.com/en/knowledgebase/techarticles/detail/40553 ... View more

Dear Users, I'm suffering an annoying problem: I'm working with ArcGIS 10.1 and I'm connected to an SDE 10.1. When I try to copy a certain Feature Class to a local file GDB ESRI tells me, that it can't copy because there are shape integrity erros. I'm sure it is because of invalid geometries. Now the question is how to find out which Features exactly cause the Problem. I don't know how to get this Information. Maybe you have an idea... Thank you in advance Run the Check Geometry and Repair Geometry tools in ArcToolbox to find out... ... View more

Jamal, Is your F: drive a removable disk? Sometimes these things only work for fixed internal disks. And sometimes you aren't allowed to put a file in root either... I have seen many of these similar issues with multiple different programs. E.g. I recently discovered I wasn't able to use an external disk attached to a front USB port of my desktop as the backup drive for a Windows 7 system backup. When I attached it to a back USB port (directly connected to the mainboard), it worked like a charm... ... View more

I can't say if there are any "benefits" in terms of performance or so (but most likely minor, SDEBINARY was and is efficient too), but from a functionality point of view, ESRI always strived with ArcSDE and ArcGIS to make the user experience uniform and GIS functions almost completely independent of underlying database storage format and storage options. This means you should be able to do, from a functionality point of view, exactly the same things (e.g. create topologies) whatever database storage options you choose. There just seems to be a minor caveat to this when choosing OGCWKB as the geometry storage format, as this Help page states it only supports 2D geometries, which would definitely impact the user experience at some point, but this is a real exception: "Note that the OGC well-known binary representation supports only simple 2D geometries." ... View more

Alternatively, if you are using ArcGIS 10.1 and have a 10.1 geodatabase, you might consider querying the Versioned Views that form part of the geodatabase. It will allow you to see the edit state of a specific version you specify in SQL. ... View more

I think we might be close.  The Enterprise gdb is a SQL db.  The IT person that is helping created a new SQL table in that gdb and connected it to the Oracle db.  I can see the SQL table in ArcCatalog and am able to Geocode it selecting the Dynamic option.  For the test, we populated the table with 60 records then geocoded it.  We then added 14 additional records.  Now trying to figure out how to get those to automatically geocode. The "Create dynamic feature class related to table" option should create a relationship class automatically, if I understood the Help page I referred well. So you theoretically should not have to manually create one any more if the geocoding operation successfully finished. Success with further tries. Hope you get it right. ... View more

I also see the error message talks about "table attachments". Maybe excluding some offending columns containing ESRI unsupported attachments / column types from the "mirror" your IT folks created, will solve the issue of not being able "register with geodatabase". By the way, as it not entirely clear from your posts, is your own "enterprise geodatabase" also in Oracle like the customer database, or in Microsoft SQL Server? ... View more

I'm not sure if this is something that can be corrected or maybe the manner in which we are trying to do this (mirroring the Oracle in SQL) is not going to work. Any ideas? Dave, this is probably as far as I can get you, I think it is time Vince Angelo of ESRI or one of the other ESRI folks joins the thread to shed light. Yes, there may be an issue with the current manner you are trying this, as I think that, to register your table with the geodatabase, most likely requires some database rights to the SDE admin user that your "mirrored" table may not provide, like being able to add a geodatabase ObjectID column. See this Help topic also: Registering a table with the geodatabase But again, I hope some others will join the thread that may be able to help you out here. There should be some possibility, especially if you are already able to see and access the table in ArcGIS. ... View more

I have only used it sparingly, but from the different "standard" IDEs I installed and tried, I also found PyScripter one of the more useful ones to work with while debugging. Nice interception and launch of PyScripter once debugging is setup and you try to run a script from ArcGIS that needs debugging. ... View more

It ought to be exactly the same, as you are just working with a table. Only difference is that you access it directly from the Oracle DB, instead of with some export. *** EDIT ***: There may be some obstacle with having a fully dynamic solution. At least it seems you need a relationship class for full automatic re-matching, see the text below from one of the Help pages: "Alternatively, a relationship class between the input address table and output feature class can be created so that edits to the addresses in the input address table are automatically updated in the output feature class. This option is supported only if the input address table and output feature class are in the same geodatabase workspace." This requires the original table also to be part of an ESRI Geodatabase. That may require Enable Enterprise Geodatabase on the existing database that contains the address information. I don't know if that is acceptable in your shop. To make such a relationship class automatically, if your addresses are indeed part of an ESRI Geodatabase or can be made so by Enabling, you can simply choose the "Create dynamic feature class related to table" option, see the text below from this Help page. "6. Select the option Create static snapshot of table inside new feature class or Create dynamic feature class related to table. The Create dynamic feature class related to table option is only available if you have an ArcGIS for Desktop Standard or Advanced license and the input address table and output feature class are in the same geodatabase workspace." ... View more

Sounds to me you actually don't want a static spatial layer added or imported to the ArcSDE managed SQL Server DB, based on your customer list in the original Oracle DB, but just a dynamically geocoded one in ArcMap based on those addresses (maintained by your colleagues), so that it is current at any point in time. For that, you don't need ArcSDE or ArcGIS for Server, you only need access to the original table with customer addresses in ArcGIS. If on ArcGIS 10.0 or below, that can be accomplished by creating an OLE DB connection to your database. First create an ODBC data source using the Windows tools available for that and than use ArcCatalog's "Add OLE DB Connection" option to add a connection to this ODBC data source (expand the "Database Connections" option). If you personally don't know how to setup an ODBC data source in Windows, ask your local network administrators / IT staff, they will definitely be able to help you out. Please note that in ArcGIS 10.1, the "Add OLE DB Connection" option is still available, but no longer by default visible in ArcCatalog. This Help page states how to add it in 10.1: http://resources.arcgis.com/en/help/main/10.1/index.html#//006600000452000000 In 10.1 you may also try to simply connect to the original Oracle DB by using the generic "Database Connection" dialog that replaces the previous options under "Database Connections", and access the table from there. This option doesn't require setting up an ODBC data source, but it may require a database client installed. See this Help page for more information about that dialog: Database connections in ArcGIS for Desktop After you created either an OLE DB or normal Database Connection, you still need to add the data itself. This can be accomplished by either simply opening the connection in ArcCatalog and dragging a visible table "as is" to ArcMap, or using the Query Layer tool in ArcToolbox for more sophisticated SQL based selection query layers. See What is a query layer? in the Help. Using this method, you should be able to setup a fully dynamic geocoded layer, which will be current at any point in time (e.g. each time you open ArcMap, the layer will reflect the edits of your colleagues). By the way, be aware there is a Windows 7 issue with setting up ODBC data sources that at least some people including myself have run into. See the details here in a thread I started. ... View more