Latest Contributions by Asrujit_SenGupta

Yes, a View which will Join the data from the Feature Class and the View provided by your DBA. This way, this new View will be Dynamic, showing changes instantly and you can use it in ArcMap and symbolize based on desired Fields. ... View more

Create a Join between the Feature Class and the Oracle table using a Database View and then use it in ArcMap. This will be dynamic. If the Feature class is Versioned....use the Versioned View for the Join If the Feature Class is not Versioned....directly use the Feature Class name (Base table) for the Join Will this work? ... View more

 Just ask for a Desktop Analytics analyst (formerly known as geodata)  Well well, even I was not aware of this change! Been a long time ha!  ... View more

Another one: Census Blocks  Site suggested in above discussion: TIGER/Line® - Geography - U.S. Census Bureau   ... View more

Census data for the Block Groups level  Site mentioned in the above post: IPUMS NHGIS | National Historical Geographic Information System  ... View more

Enterprise geodatabase: a geodatabase stored in one of DB2, Informix, Oracle, PostgreSQL, or SQL Server. ArcSDE geodatabase: an enterprise geodatabase (version 10.1 or 10.2.x) to which connections are made via the ArcSDE application server. This is still incorrect. As Tina mentioned, these are not 2 separate types of geodatabases. The type of geodatabase does not change based on the type of connection we use. ArcSDE Application Server Connections can be still be made to any geodatabase prior to 10.2.2, which will include 10.2.x, 10.1, 10.0, 9.3.x, 9.2 etc.  ... View more

Maybe use something like the below to get a rough idea as to which all objects are consuming the most space: SQL Server – Get Sizes of All Tables and Indexes in a Database | My Adventures in Coding  ... View more

BUG-000095512: ArcMap 10.4 and 10.4.1 resets the scale and precisio..  Just in case, someone is looking for that Bug... ... View more

That is fine, there will be a Default version owned by the Schema owner when you create a User Schema gdb. So, are you connecting as the same user as 'user schema' that you created for the User Schema gdb. Only the schema owner can load data into a user-schema geodatabase ... View more

Did you connect to the User-Schema geodatabase through the Database connection? The error seems to indicate that you are connected to the Master SDE gdb and trying to load data in that. Connect to a specific geodatabase version—Help | ArcGIS Desktop  Also Note the below: User-schema geodatabase management—Help | ArcGIS Desktop  Load data into a user-schema geodatabase You load data into user-schema geodatabases the same way that you load data into the sde master geodatabase—with ArcGIS Desktop tools. However, only the schema owner can load data into a user-schema geodatabase. All other users must load data into the sde master geodatabase or into their own user-schema geodatabases. For example, if user1 owns a schema geodatabase, user1 can only create data in the user1 geodatabase. If user2 does not own a schema geodatabase, user2 can only create data in the sde master geodatabase. If a user owns data in more than one geodatabase in the same Oracle database, the geodatabases cannot be upgraded, and the user-schema geodatabase cannot be deleted. You must delete the data from the other geodatabases before you can upgrade. ... View more

Should have asked in the first post itself: 1. What is the version of ArcGIS you are using? 2. Type of geodatabase being used? File gdb or Enterprise gdb? 3. If Enterprise gdb, then what is the version of the Enterprise gdb and the complete Database version. ... View more

Bug: Add Rasters to Mosaic Dataset tool returns an error or crashes when the tool is running in the background  Disable Background Geoprocessing, if that is enabled and try again.. ... View more

Check the Log file size for the SQL Server databases. Sometimes the data file size will not be that much, but the Log file could be large and thus the total database size shows up to be quite larger than expected. Note: ArcGIS 10.4.2 does not exist. ArcGIS 10.4.1 was released after ArcGIS 10.4 and then came 10.5. ... View more