Latest Contributions by LanceShipman

‎04-25-2012

What results are you getting? Error message?

‎04-25-2012

Looks good. Are you getting the results that you expect?

‎04-23-2012

The GP tool arcpy.SelectLayerByLocation_management (Select Layer By Location in the toolbox) supports this query. It can be used from python or from .NET.

‎04-19-2012

Use: CAST("Price" AS CHARACTER(12)) LIKE '1%' I need to add this to the doc. The width of the character field must be set. It's consistent with other SQL implementations, but it's not obvious.

‎04-19-2012

You should add these requests to the ESRI ideas site. http://ideas.arcgis.com

‎04-12-2012

Do you have Visual Studio on your test machine (the machine where the code is failing)? If not you may need to load the Visual Studio C/C++ Runtime. Can you send us your code so we can try to reproduce yours issue locally ([email protected]).

‎03-26-2012

I tested spatial search with a moderately large dataset (30+ million polygon features) and was able to retrieve a few thousand features in under one second. No lag on the final NEXT. Can you send your code? How many attributes does your feature class included. Does it include any blobs. Was the feature class created with the API or through ArcGIS. You may want to drop your spatial index and re-create it.

‎03-22-2012

A different process can still read a file with a edit lock. It�??s only with a write lock that a read is not possible. To improve performance buffering was added to file geodatabase at 10.1? Prior to 10.1 buffering was not active. At 10.1 a write lock will only be taken out every 1000 features or when flush is called when the inserts are performed.

‎03-21-2012

RD-Lock - Read Lock SR-Lock - Schema Lock WR-Lock - Write Lock ED-Lock - Edit Lock Locking is by process, not user. A write lock will be held until a Insert Cursor goes out of scope. In an edit session a edit lock is taken out. A write lock is only taken out on save edits. A read lock can not be taken out during a write lock.

‎03-16-2012

This one is from November 2011, http://ideas.arcgis.com/ideaView?id=08730000000bsadAAA

‎03-16-2012

http://ideas.arcgis.com/ideaView?id=08730000000btFrAAI

‎03-16-2012

We renamed it to make it more generic. It didn't make sense to keep 'linux' in the name now that we have a Mac release. Since Linux and Mac are both 'Unix'-based or Unix-like under the hood, we thought libfgdbunixrtl.so made sense.

‎03-08-2012

NIM071538 makes a huge difference in performance when using a spatial search. We tested against a feature class containing over 30 million features. The performance went from 70 seconds to under one second. If you are not using a spatial search you will see no change in performance. The "extended shape buffer format" document (renamed from "extended shapefile format") has been updated, including the section on multipatch geometries, which was previously incomplete.

‎03-07-2012

The File Geodatabase API 1.2 is now available for download from the resource center. (http://resources.arcgis.com/content/geodatabases/10.0/file-gdb-api) What�??s new at 1.2: * Support for Intel-based Mac. The minimum supported OS is Snow Leopard 10.6. The supported compiler is gcc 4.2.1. * Macros for error values allowing for more readable code. (NIM077630) * HRESULT IFDEFs have been updated to define if they are not set. (NIM071619) * File Geodatabase API function parameters are const ref's where possible. (NIM071620) * Coordinate systems supported updated to match ArcGIS 10.1. (NIM078034) * Structure definitions for curves (CircularArcCurve, BezierCurve, EllipticArcCurve). Fixed Issues: NIM071538 The spatial index is not used in a spatial search. NIM072876 Dates are not correctly read or assigned when using the File Geodatabase API .NET wrapper. NIM074135 You cannot assign a domain to a table created with the API. NIM077629 Correct the Bezier curve buffer documentation in the extended_shapefile_format.pdf, the stated size is wrong. NIM075930 DeleteGeodatabase crashes intermittently. NIM076353 Row.SetGUID fails to set a value with the .NET wrapper. NIM077138 Table extents truncated, breaking spatial indexes. NIM078028 Fix the Mutlipatch Shapebuffer helper function.

‎03-07-2012

The dictionary tables are not exposed. Is your primary data store a file geodatabase or ArcSDE. If its ArcSDE you should look at replication. (http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002700000024000000.htm_)

Online Status	Offline
Date Last Visited	‎04-24-2025 12:47 PM

My Ideas

Latest Contributions by LanceShipman

Re: How to program "share a line segment with" functionality of Select by Location

Re: How to program "share a line segment with" functionality of Select by Location

Re: How to program "share a line segment with" functionality of Select by Location

Re: Using SQL CAST functionality in against a File Geodatabase

Re: File Geodatabase API 1.2 now available

Re: Could not load assembly "Esri.FileGDBAPI.dll"

Re: Spatial Queries are very slow on large tables

Re: File geodatabase debugging lock problem, what are "rd" locks?

Re: File geodatabase debugging lock problem, what are "rd" locks?

Re: APIs for raster

Re: APIs for raster

Re: File Geodatabase API 1.2 now available

Re: MultiPatchShapeBuffer Materials

File Geodatabase API 1.2 now available

Re: File Geodatabase file names / Updating a file geodatabase

Re: SQL queries on File Geodatabases

Re: ArcGIS Pro and Excel Table Problems

Re: File Geodatabase feature class reports more fe...

Re: How to prevent from truncating field name -exp...

Re: ArcGIS Pro and Excel Table Problems

Coordinate Reference Systems