Latest Contributions by VinceAngelo

Note: also posted at GIS StackExchange It appears that you were given a corrupt dataset. There are many ways this could happen, including by not paying attention to warnings raised by WinZip or 7Zip during data capture. Recovery from missing files is dependent on which files are missing, but doesn't have good odds if the trivial files have already been tried. Going back to your data provider will the the fastest and most reliable way to acquire this dataset. - V ... View more

ArcGIS won't preview tables that contain unsupported datatypes. Please provide a more complete description of the view SQL with a complete description of the member tables. - V ... View more

What transaction are you committing?  CREATE TABLE is not logged, nor is ALTER TABLE.  Both must occur outside a transaction. It seems you are using the transaction environment incorrectly.  Please add the relevant pieces of your script to the question, so we have a chance to figure out what is wrong. - V ... View more

Shapefiles are only marginally part of the geodatabase model, mostly because they don't conform to the full range of datatypes and NULL support (not to mention the field naming limitations and byte-sized length limit). Geodatabase, the model, doesn't have limits. File geodatabase, the format, doesn't have limits*. Enterprise geodatabase, the format, only has what limits are imposed by the RDBMS vendor. Admittedly, juggling between these formats can be a PITA, but that's not a limitation of geodatabase. I'm also mystified by the resurrection. - V * Where 2Gb-1 is "effectively unlimited" ... View more

No, there is no such limit. As stated, repeatedly, "geodatabase" text fields are unlimited (2^31-1 UTF-16), though the underlying storage format may assert a lower value. - V ... View more

Underscore should be okay, but ALLCAPS and MixedCase are BAD (with or without underscore). - V ... View more

Please remember to specify the exact versions of PostgreSQL and ArcGIS in use. It's been a decade since client libraries were necessary with PostgreSQL, so it's possible that you've corrupted the install, causing the library failure.  You should also provide verification that psql on the same host can connect to the same server. - V ... View more

This is why lists are not considered best-practice in database design.  If you had a second table organized: keycol attrval 1 A1 1 F4 1 A10 2 A1 2 A17 3 F1 3 G6 3 A1 4 A10 4 A1 then you could fashion a query: SELECT * FROM mytable WHERE keycol in (    SELECT keycol    FROM secondtab    WHERE attrval = 'A1') - V ... View more

No, this is not part of the standard workflow. - V ... View more

You haven't provided enough useful information.  What is the name of your user?  What is the name of the version?  From which version was the new version created. What exact parameter did you change on the connection UI? - V ... View more

Be sure you read up on how Esri's versioning model operates.  There is no difference between the child and parent versions if no editing has occurred. The active version is a connnection property. - V ... View more

Uninstall/reinstall couldn't hurt, but I expect the problem is with the data, not the software. - V ... View more

This question is not a logical extension of the post from seven years ago. You should have posted a new question, which would have to include the database which enforces a 320 character limit (I'm not aware of any that do).  Shapefiles have a much smaller limit: 254 bytes (fewer UTF-8 codepoints). There are a number of answered questions here which address string field width in various storage formats. - V ... View more

The polygon can still be invalid in other ways (e.g., self-intersection). - V ... View more

If your polygons have invalid ring geometry, Clip may produce bizarre results.  Try verifying both your Input and Clip layers with CheckGeometry_management - V ... View more