Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About KenGalliher1
KenGalliher1
Esri Contributor
since
07-04-2014
Online
97
Posts created
92
Kudos given
13
Solutions
69
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(2 Idea Submissions)Latest Contributions by KenGalliher1
|
POST
|
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
03-14-2018
07:47 PM
|
1
|
2
|
2577
|
|
POST
|
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
03-09-2018
10:51 PM
|
1
|
0
|
1319
|
|
POST
|
Hi Bob, I have attached a document that outlines the following: 1. Download and install the driver. 2. Add the ODBC driver as a data source on the machine. 3. Connect to the MySQL database in ArcCatalog. Here are some relevant links: MySQL ODBC Driver download (5.2.x) MySQL :: Download Connector/ODBC Adding an OLE DB Connection in ArcGIS Desktop. Adding OLE DB connections to databases—Help | ArcGIS for Desktop - Ken
... View more
01-02-2018
08:51 AM
|
6
|
0
|
16966
|
|
POST
|
If you’re still maintaining applications written in the ArcSDE Java or C API you may already know you’re getting close to the end of the code base’s life cycle. As a support analyst, I have been seeing a spike in calls regarding migrating from the SDE SDK by using native database spatial types with SQL and ArcObjects. How are you approaching your migration?
... View more
04-26-2017
02:36 PM
|
2
|
0
|
1077
|
|
POST
|
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
04-21-2017
03:55 PM
|
2
|
0
|
1831
|
|
POST
|
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
05-17-2016
08:53 AM
|
1
|
0
|
1497
|
|
POST
|
The purpose of this column is to handle complex geometries such as curves. Since a feature class can have only one shape column, the storage of circular geometries must be stored separately and then joined to the feature class when viewed in ArcGIS. I can't seem to find this documented for Postgres but concept is similar for Oracle's SDO geometry and SQL Server Geometry spatial types. SDO_Geometry: -------------------- "Convert noncircular arcs (such as cubic spline or Bézier) to straight-edged linestrings. When the feature class is registered with the CAD entity mask (c), also store the curved representation in SE_ANNO_CAD_DATA." <--- this is the same concept as the GDB_GEOMATTR_DATA column http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000006t000000#ESRI_SECTION1_E668383C2132433CBB42FE1241484AA8 --------------------
... View more
04-01-2016
03:43 PM
|
3
|
0
|
3487
|
|
POST
|
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
03-17-2016
03:10 PM
|
0
|
0
|
1574
|
|
POST
|
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
04-17-2015
09:59 PM
|
0
|
0
|
1774
|
|
POST
|
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
04-10-2015
12:59 PM
|
0
|
0
|
3507
|
|
POST
|
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
03-16-2015
09:50 AM
|
1
|
1
|
2242
|
|
BLOG
|
I also found this query for SQL Server very useful. SELECT message_id, severity, text FROM sys.messages WHERE language_id = 1033; Ken G. - Geodata Support Analyst |