IDEA
|
Jefferson County, Colorado makes heavy use of the ITopology* interfaces through a VS C#/.Net solution built using the ArcObjects SDK that is our Address Street Political (ASP) Tools, an extension to ArcGIS Desktop. Originally developed for ArcGIS Desktop 9.3.1, it has been ported to what is currently 10.5.1 production. In 2019, we're slated to make some data and tool enhancements to the application including a port to 10.6.1- the final version for Desktop. In 2020, our plan is to re-write the functionality on the new ArcGIS Pro technology stack- but we require IMapTopology, ITopologyGraph, ITopologyEdge and ITopologyNode exposed in the ArcPro SDK. For Jefferson County, this need is mission critical.
... View more
11-02-2018
04:41 PM
|
0
|
1
|
968
|
IDEA
|
Jefferson County, Colorado makes heavy use of the ITopology* interfaces through a VS C#/.Net solution built using the ArcObjects SDK that is our Address Street Political (ASP) Tools, an extension to ArcGIS Desktop. Originally developed for ArcGIS Desktop 9.3.1, it has been ported to what is currently 10.5.1 production. In 2019, we're slated to make some data and tool enhancements to the application including a port to 10.6.1- the final version for Desktop. In 2020, our plan is to re-write the functionality on the new ArcGIS Pro technology stack- but we require IMapTopology, ITopologyGraph, ITopologyEdge and ITopologyNode exposed in the ArcPro SDK. For Jefferson County, this need is mission critical.
... View more
11-02-2018
04:41 PM
|
0
|
1
|
529
|
POST
|
Synopsis I am developing an integration process, using Python Win 2.5.4, that performs both geo- and tabular manipulations, and the process must work with standard Oracle 10g R2 databases (non-SDE databases) from across the enterprise. It works well in this regards. However, we also have an Oracle 10g R 2 'ASP' GDB in an enterprise SDE, and cx_Oracle query results appear to be returning unicode when in fact the unicode is part of the output string. Specifics: Here's the crux of how 'cx_Oracle' is used to return results from an Oracle table within our ASP GDB: >>> import os >>> os.environ["NLS_LANG"] = "AMERICAN_AMERICA.WE8MSWIN1252" >>> import cx_Oracle >>> import string >>> oraConnectAsp = cx_Oracle.Connection(oraUserAsp + "/" + oraPwAsp + "@" + oraDbAsp) >>> oraCursorAsp = oraConnectAsp.cursor() >>> whereCol = "a2a2_" + string.lower(envArg) >>> sql = "SELECT sys_acct FROM " + tblAspNotify + " WHERE " + whereCol + " = 'Y'" >>> print sql SELECT sys_acct FROM ASP.ASP_Notification WHERE a2a2_dev = 'Y' >>> oraCursorAsp.execute(sql) <__builtin__.OracleCursor on <cx_Oracle.Connection to asp@SDEPID>> >>> statusMsgList = oraCursorAsp.fetchall() >>> print statusMsgList [(u'nmassaro',), (u'smitchel',)] >>> print statusMsgList[0] (u'nmassaro',) The output looks like unicode but in fact it is part of the string... >>> x = statusMsgList[0] >>> x (u'nmassaro',) >>> print x (u'nmassaro',) ...whereas unicode behaves as follows: >>> x = u"nmassaro" >>> x u'nmassaro' >>> print x nmassaro As stated, using 'cx_Oracle' to connect to a standard Oracle 10g R2 database (ie, a non SDE database) it is not an issue. Here's an example of the results of a query on a table in an AGED database: >>> oraConnectAge = cx_Oracle.Connection(oraUserAge + "/" + oraPwAge + "@" + oraDbAge) >>> oraCursorAge = oraConnectAge.cursor() >>> itmStr = "upunttime, uphour, uphour, upminute, usleep, udependency" >>> sql = "SELECT " + itmStr + " FROM " + tblDb_UpdtParam + " WHERE uname = 'A2A2'" >>> print sql >>> oraCursorAge.execute(sql) <__builtin__.OracleCursor on <cx_Oracle.Connection to geocode@AGED>> >>> oraResultAge = oraCursorAge.fetchall() >>> print oraResultAge [('01:09:00', 1, 1, 9, 30, 'A2A1_FINISHED SW_FINISHED')] >>> updtDependency = string.split(str(oraResultAge[5])) >>> print updtDependency ['A2A1_FINISHED', 'SW_FINISHED'] >>> print str(updtDependency[0]) + " " + str(updtDependency[1]) A2A1_FINISHED SW_FINISHED If the query results were truly Unicode I could convert to ASCII, but when what appears to be Unicode is part of the output then the onus is a lot of string manipulation- not desirable. Ideas how to return either simple ASCII or, at the worst, true Unicode? Thanks-
... View more
04-02-2010
02:11 PM
|
0
|
2
|
2801
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|