Latest Contributions by BruceHarold

Jonty What is your host DBMS, or are you using file GDB?  Email me at [email protected] and i'll determine the correct syntax. Regards ... View more

Hi Jonty Is "SORT" a reserved word in your DBMS? Also, the parenthese around the subquery (select...) will be required. Cheers ... View more

Hi Jonty Your SQL query will be something like; where...: "ObjectID" = (select min("ObjectID") from Mytable) and "Otherfield" = 0 Depending on the host database you're working in the syntax may need to be tweaked. See the help on subqueries. Regards ... View more

Archana Please open a support call with Esri, the analyst will track this issue to resolution. Regards ... View more

Hi Grazi Quick Import creates a file geodatabase for the imported data, so it will not be added to your map, but you can navigate to the result workspace and look for it. Regards ... View more

Hello Thomas Are you able to share your data and model?  Big Data issues that we can reproduce are of interest; while I can't commit to a resolution timeframe I hopefully can take a look.  If you can share data and models please email me at [email protected] and I'll set up an FTP location. Regards ... View more

Hi Thanks for the idea; there are a number of IP geocoding solutions already in the market that can be integrated with ArcGIS. Regards ... View more

I was just about to test SimpleGeo's Python client in ArcGIS but today learned they have been acquired and the product direction is uncertain.  Their Storage product is interesting.  ... View more

Hello All The underlying issue Szymon uncovered is likely to be attempted concurrent writing to system tables.  The File GDB itself does not have exclusive locks unless you're doing something like renaming or deleting it.  Writing to separate geodatabases will avoid the issue. Regards ... View more

Hi V Patiballa -------------------------------------------------------------------------------- The Data Interoperability extension has functionality designed to detect differences between feature classes (or tables) after which you can optionally write adds and deletes to the target object to bring the data into agreement.  It is beyond the scope of the forum to provide the Data Interop tool for this task, but your Esri regional office or distributor will be able to help you with this. Regards ... View more

Hello You need to be connected to the internet to access the on-line locators. Regards ... View more

Hello Marilyn In ArcMaps table of contents or the Catalog window view of your output, right click on the output feature class and choose to rematch your addresses; work on the unmatched records. Please see here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/About_rematching_a_geocoded_feature_class/002500000028000000/ Regards ... View more

Hi I might be missing something here with respect to the programming environment you might be tied to, but the geoprocessing environment has the Get Count tool, and if you really need to do this with SQL, and your OID values are a sequence, then select something like OID = (select max(OID) from table_xy) is fast. Regards ... View more

James The Data Interoperability extension is for this workflow, especially when dealing with SDE geodatabases.  It is likely you'll need assistance with your workbench authoring, work with your Esri account manager in this regard.  If you have many tens of millions of features to process simultaneously then memory may be an issue - bring this up in discussions if necessary. Regards ... View more

Stephane The interop connection should display Line, NoGeometry, Point and Polygon feature classes when opened, either when using the Add Data tool or in the Catalog Window browse tree.  This makes me suspect an issue with the table in PostGreSQL.  Try adding the data as a query layer (File->Add Data->Add Query Layer) and see if you can make it work.  That method has a few more dependencies (only one geometry type in the query, one spatial reference, a primary key in the query).  If that fails use PGAdmin to inspect the table for issues like null geometry, no spatial reference etc. Regards ... View more