Latest Contributions by MarcCusumano

I am trying to populate intersection information for our facilities data. I am initially running simple points against the latest TomTom data that we purchase annualy (MultiNet Enterprise).   In using the "Reverse Geocode" tool with the "INTERSECTION" option in ArcGIS Desktop 10.1 SP1, all of the >65,000 points are placed on top of each other, in places where a single facility exists. This is obviously incorrect, and I cannot figure out why.   Then I tried using ArcGIS Pro 10.3. Using the Reverse Geocode tool there simply crashes the application. I have tried using multiple different copies of the point data, as well as several different address locators using different TeleAtlas reference data. I have run check and repair geometry on the point feature class as well as on the address locator reference data with no luck. The application crashes every time ("ArcGIS Pro has encountered a serious application error and is unable to continue...")   Does anybody have any ideas why this is happening??? ... View more

Hello all. While we are waiting for GeoEvent processor to be rolled out in my organization, I am attempting to create a temporary solution to get pressure tracking data into our GIS system to be made available to our end-users. I have the workflow planned out, but the only thing in my way is getting the most recent readings into a seperate table. We have a SQL Server database that holds all of the readings in a single table, which contains over 2 million rows. Data is held in the table per reading date, UDI (device identifier), channel (3 channels per device), and value (actual readings). Since the process will be scripted in python, I am trying to automate the copying of the most recent readings from this table into a new table. I am using the Table to Table tool, with a SQL. Here is the code I am trying to use, which seems to work well inside of SQL Server: select UDI,Channel,Value, DateTime_UTC from PTData4 t1 WHERE EXISTS(SELECT 1          FROM PTData4 t2          WHERE t2.UDI = t1.UDI            AND t2.Channel = t1.Channel          GROUP BY t2.UDI,                   t2.Channel          HAVING t1.DateTime_UTC = MAX(t2.DateTime_UTC)) However in ArcGIS I get an error that states: "There was an error with the expression. Failed to parse the where clause." Any ideas how to convert this code to be compatible with ArcGIS? ... View more

Hello all. We are trying to create a nightly script that will set attachment flags, indicate a feature has an attachment available. This is not possible using hte ArcGIS front-end due to issues related to ArcFM AutoUpdaters (and also performance reasons), so we are attempting to develop a solution using SQL Developer (we cannot use MS Access or SQL Server due to incompatibilities with ST_GEOMETRY). I am told that running an UPDATE query on a view will take care of updating all of the delta tables as well as the base table. The first feature I am running this on is a versioned view. Here is my code snippet: EXECUTE sde.version_util.set_current_version ('SDE.DEFAULT'); EXECUTE sde.version_user_ddl.edit_version ('SDE.DEFAULT', 1); UPDATE GASVALVE_VW SET ATTACH_FLAG = 'N'; Commit; EXECUTE sde.version_user_ddl.edit_version ('SDE.DEFAULT', 2); However, I am being told I cannot edit the DEFAULT version: Error starting at line 3 in command: EXECUTE sde.version_user_ddl.edit_version ('SDE.DEFAULT', 1) Error report: ORA-20500: Cannot edit the DEFAULT version in STANDARD transaction mode. ORA-06512: at "SDE.VERSION_USER_DDL", line 941 ORA-06512: at line 1 I am able to start an edit session in the DEFAULT version inside of ArcMap in the same GDB. SQL Developer then tells me i cannot edit without being in an edit session (because the edit session could not be started by SQL Developer). Error starting at line 4 in command: UPDATE GASVALVE_VW SET ATTACH_FLAG = 'N' Error report: SQL Error: ORA-20504: Editing the DEFAULT version is not supported because the spatial attribute is not a spatial type or the table is registered as versioned with the option to move edits to base. The session must call edit_version to start an edit session before editing the view. ORA-06512: at "PSEG_GAS.V87_UPDATE", line 1 ORA-04088: error during execution of trigger 'PSEG_GAS.V87_UPDATE' Not sure what I am doing wrong. Any help would be greatly appreciated! ... View more