Latest Contributions by KenGalliher1

Take a look at this: GitHub - Esri/arcgis-rest-js: compact, modular JavaScript wrappers for the ArcGIS REST API  ... View more

Also, try this query to check the count of unposted states on all versioned feature classes: SELECT tr.table_name AS table_name , s.owner AS state_owner, count(*) AS total_unposted_states FROM sde.table_registry tr INNER JOIN sde.mvtables_modified mv ON tr.registration_id = mv.registration_id INNER JOIN sde.states s ON mv.state_id = s.state_id GROUP BY tr.table_name, s.owner; ... View more

The "no ntvinv in java.library.path" error typically comes from a mismatch between the Java's bit level and the bit level of ArcObjects.  The ArcObjects libraries are comprised of 32 bit components while Java is 64 bit.  Try using a 32 bit Java version that is supported for your version of ArcObjects.  Regarding the sample script, the key is the Geoprocessing object which makes use of ArcGIS's Python functionality.  If the goal is to create a file geodatabase then the CreateFileGDBClass is the way to go. com.esri.arcgis.geoprocessing.tools.datamanagementtools.CreateFileGDB Creating enterprise, multi-user geodatabases can be accomplished by running the CreateEnterpriseGeodatabase geoprocessing tool with the Geoprocessor class methods. Create Enterprise Geodatabase—Help | ArcGIS Desktop  ArcObjects Java API - Geoprocessor class .NET example of executing a geoprocessing tool with ArcObjects arcobjects-sdk-community-samples/Net/Geoprocessing/GPExecutingTools at master · Esri/arcobjects-sdk-community-samples · …  ... View more

This isn't an ArcGIS/Esri way but take a look at this tech article describing a SQL script that.. "reports information about a versioned geodatabase in Oracle. The output lists the number of versions, the number of versions blocking the DEFAULT version from being compressed to state 0 and the owner.names of the first 5 blocking versions, the number of states, the number of entries in the state_lineages table, and the number of rows in the versioned table and delta tables." As has been mentioned in the other comments, to see what versioned feature classes have not had their edits posted and compressed to the base table is to look at the delta tables. How To: Report geodatabase versioning statistics in an Oracle geodatabase  ... View more

Hello Elias, Are you labeling with the ST_Area(shape) or ST_Length(shape) columns specifically?  If so, this is a known bug: BUG-000084936 ---------------- Attempting to label features from PostgreSQL based on the st_area(shape) or st_length(shape) field in ArcGIS 10.4.1 fails with an error, "Invalid column data type". BUG-000084936: Attempting to label features from PostgreSQL based o..  ---------------- The workaround for this is to add a new field of the same data type and use the Field Calculator to populate the new field with the ST_Area or ST_Length column values. If this is not a case then it may be best to open a case with Support. ... View more

Hi Gianni, Does the database reside in a location different than the ArcGIS Server machine?  If so, make sure to alter the pg_hba.conf file to allow the IP address of the ArcGIS Server machine to connect. For example, the pg_hba.conf file could contain: Entries for both ipv4 and ipv6 connection types, the second line, indicates that any user from any machine can connect. # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 0.0.0.0/0 md5  # <-- add the specific address of the ArcGIS Server machine if desired. # IPv6 local connections: host all all ::1/128 md5 host all all ::/0 md5 If this is the case, the "bad login user" error may sound misleading.  However, from PostgreSQL's point of view, the proper credentials were never actually passed to the database. Ken ... View more

This is typically done using a SQL trigger that listens for incoming geometries either from editing a map document or inserting geometries with SQL.  When using a native DBMS spatial type such as SQL Server Geometry or Postgres' PostGIS type, constructor functions and spatial operator functions are provided that allow one to query different spatial properties. For instance, in SQL Server we can use the shape.Lat, shape.Long functions for Geography types or shape.X and shape.Y for Geometry types on a spatial column called "shape". Here is a simple SQL Server Geography example using shape.Lat and shape.Long. to update columns called "latitude" and "longitude" with their respective values.  This sample is provided AS IS and must be properly tested before implementing in a production environment. CREATE TRIGGER [gis].[Insert_xy_if_geometry_fc] ON [gis].[Landmark_fc] AFTER INSERT   ,UPDATE AS UPDATE pt SET pt.latitude = i.Shape.Lat   ,pt.longitude = i.Shape.Long FROM Landmark_fc AS pt INNER JOIN (   SELECT objectid   ,Shape   FROM inserted   WHERE (Shape IS NOT NULL)   ) AS i ON i.objectid = pt.objectid; RETURN GO ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Lat (geography Data Type) Long (geography Data Type) ... View more

With the exception of directly accessing a geodatabase, I believe most if not all of the requirements listed above could be met in a Runtime for Java app.  Maybe not in the sense of installing an "add-in" into an existing application but Java Runtime provides the selection, query and information display functionality needed to build a custom application from scratch that meets these requirements.  Outside of the ArcGIS Runtime SDK, one could use the native Java FileWriter to export a JTable to a .csv file. There are other 3rd party packages that can provide this functionality. The key here is data access. If there is access to the data, the functionality exists to select one or more features, query by attributes, display tables of information, display graphs and calculations, etc.  Accessing geodatabase data would require ArcGIS Server services, offline geodatabases created from feature services or map packages.  The Runtime SDKs do not provide direct geodatabase access.  An ArcObjects application would be necessary to accomplish this programmatically. Here are some examples that could be useful in visualizing what this would entail: Runtime SDK examples Find | ArcGIS for Developers Selection mode | ArcGIS for Developers WebMap charts | ArcGIS for Developers Query by attribute | ArcGIS for Developers Offline feature table query | ArcGIS for Developers Local Server feature layer | ArcGIS for Developers Java examples FileWriter (Java Platform SE 7 ) Apache POI - the Java API for Microsoft Documents ... View more

Hi Bradley, The Register With Geodatabase tool is available at 10.2.x as well as 10.3.  Here's the doc for 10.3 with some Python snippets. Register with Geodatabase—Help | ArcGIS for Desktop Functionality to handle objectids is available with the geoprocessing tool as well: In addition, registering a table with the geodatabase adds an ObjectID field to the table. This field is populated by the geodatabase with unique ID numbers. If you register a table with the geodatabase and the table already contains an ObjectID field, you are presented with a dialog box that allows you to use the existing field or add a new field, ObjectID_1. Hope this helps. ... View more

To add to George's statement, here are some updated tech articles and help docs relevant to this discussion: 44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases? Migrate from ArcSDE administration commands—Help | ArcGIS for Desktop  10.3 help George Thompson​ ... View more

Yes.  Good catch.  Thanks. ... View more

Adding to Geonet Admin's answer, I used hasattr(class, 'prop') to check each incoming layer had the datasource property.                      for df in arcpy.mapping.ListDataFrames(mxd):      brknList = arcpy.mapping.ListBrokenDataSources(mxd)                          for bk in brknList:                                   if hasattr(bk, "dataSource"):                                            bk_list.append(bk.dataSource) ... View more