Latest Contributions by ThomasColson

I'm confused: When I go to the "Space", it is empty. Is that the expected behavior? Not much in the "User Group" either. And why would some the ArcHdyro discussions be dumped in "Managing Data"? Why can't ESRI "turn on" the old forums while they get this new site straightened out? It's very frustrating to not be able to find even the most basic of information, which leads to a challenging work day. I'm not getting paid to spend hours hunting through difficult to navigate content. I am not alone with this frustration. ... View more

Something clearly is not working here. And I know for a fact there was WAY more than 143 posts in the original ArcHydro forum. Where is that content? ... View more

...or there could just be an appropriate forum for things to be posted in. ESRI seriously doesn't believe that everyone is ALWAYS going to use the RIGHT tags, do the ... View more

Good to know it's there, but very frustrating that there is no content in that "Space". I have an operationally-critical project this week, went looking for the "Sticky" that contains the frequently-changing login for the FTP site, and it's not to be found with this new forum system. Any idea when we'll be able to easily find Arc Hydro posts, and when they'll be in the correct "Space"? ... View more

Still looking for a solution to this, has anyone figured out how to recover data from a collector device when it fails on synch? How does this .geodatabase file translate to XML? ... View more

I am very interested in ESRI's response regarding recovering data from a mobile device using collector if it fails on sync. Numerous sync errors have been reported in this (is this a forum now?), as well as clarification on how to get the data off the device when that happens. With ArcPad at least you had the data on the device that you could sorta of muscle back into your enterprise database. ... View more

The following assumes you have a unique ID field (SQL, GUID in SDE), that in SQL is set to "newsequentialid()". Lets assume the field is called "LocationID". Note how that column is NOT INCLUDED in this trigger! In the Adds table, it is a NON-SEQUENTIAL ID, but when it hits the business table, it becomes sequential. The rest of the trigger deals with using SQL geometry operations to autopopulate some columns. This will ONLY work on data that is versioned with move edits to base checked, which kills any replication plans you have. If you can't move edits to base, you'll need to wrap this up in a stored proc using a cursor, which IMHO was more work than it's worth. CREATE TRIGGER [dbo].[INSERT_VM_PLOTS_Location_ID] ON [dbo].[VM_PLOTS] INSTEAD OF INSERT NOT FOR REPLICATION AS BEGIN SET NOCOUNT ON; INSERT dbo.VM_PLOTS( OBJECTID, VError, MapSource, SourceDate, MapMethod, QuadName, UnitCode, EditDate, UnitName, IsExtant, HError, County, State, LAT, LON, Watershed, PlaceName, TrailName, StreamName, Landform, Meta_MID, Road, Elevation, Year, Notes, Coord_Units, Coord_System, Datum, UTM_Zone, ManagementZone, ParkDistrict, EditBy, CreateBy, CreateDate, RegionCode, Restriction, Soil, Geology, HistoricDisturb, Veg, Level4EcoReg, AvgRain, MeanDailyTemp, Loc_Name, Directions, Description, Loc_Notes,X_Coord, Y_Coord, Shape ) SELECT a.OBJECTID, a.VError, a.MapSource, a.SourceDate, a.MapMethod, b.NAME, a.UnitCode, a.EditDate, a.UnitName, a.IsExtant, a.HError, c.NAME, d.NAME, a.LAT, a.LON, e.HU_12_Name, a.PlaceName, a.TrailName, a.StreamName, a.Landform, a.Meta_MID, a.Road, a.Elevation, a.Year, a.Notes, a.Coord_Units, a.Coord_System, a.Datum, a.UTM_Zone, g.FCSubtype, f.District, a.EditBy, a.CreateBy, a.CreateDate, a.RegionCode, a.Restriction, j.MUNAME, k.GLG_SYM, l.CLASSES, h.VitalName, p.EPA_REGION, q.RANGE, a.MeanDailyTemp, a.Loc_Name, a.Directions, a.Description, a.Loc_Notes,a.X_Coord, a.Y_Coord, a.Shape From (SELECT OBJECTID, VError, MapSource, SourceDate, MapMethod, QuadName, UnitCode, EditDate, UnitName, IsExtant, HError, County, State, LAT, LON, Watershed, PlaceName, TrailName, StreamName, Landform, Meta_MID, Road, Elevation, Year, Notes, Coord_Units, Coord_System, Datum, UTM_Zone, ManagementZone, ParkDistrict, EditBy, CreateBy, CreateDate, RegionCode, Restriction, Soil, Geology, HistoricDisturb, Veg, Level4EcoReg, AvgRain, MeanDailyTemp, Loc_Name, Directions, Description, Loc_Notes, SHAPE = CASE WHEN SHAPE IS NOT NULL           THEN SHAPE ELSE Geometry::STPointFromText('POINT('            + CAST(X_Coord AS VARCHAR(20)) + ' '             + CAST(Y_Coord AS VARCHAR(20)) + ')', 26917) END,        X_Coord = CASE WHEN SHAPE IS NULL THEN X_Coord ELSE SHAPE.STX END,        Y_Coord = CASE WHEN SHAPE IS NULL THEN Y_Coord ELSE SHAPE.STY END FROM inserted) AS a LEFT OUTER JOIN grsm.dbo.USGS_24K_TOPOMAP_BOUNDARIES AS b ON b.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN grsm.dbo.GRSM_COUNTIES AS c ON c.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN grsm.dbo.GRSM_STATES AS d ON d.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN grsm.dbo.WBD_12 AS e ON e.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN grsm.dbo.RANGER_DISTRICTS AS f ON f.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN IANDM.dbo.GRSM_VEG AS h ON h.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN grsm.dbo.GRSM_GMP_ZONE AS g ON g.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN iandm.DBO.GRSM_Soil_Taxonomy AS j ON j.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN IANDM.dbo.grsmglg AS k ON k.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN IANDM.dbo.GRSM_DISTURBANCE_HISTORY AS l ON l.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN IANDM.dbo.GRSM_LEVEL_IV_ECOREGIONS AS p ON p.Shape.STContains(a.Shape) = 1 LEFT OUTER JOIN IANDM.dbo.AVERAGERAINFALL as q ON q.Shape.STContains(a.Shape) = 1; end I take it one step further and get this all going in SQL/SDE, without declaring a globalID in Arc Cat, then change the object flags on the "LocationID" column in sde_column_registry to "256", thus giving myself a sequential globalid. The difference in performance is immediate and drastically improved. ... View more

Works like a champ. Using the Monterra camera with collector is a little wonky.... ... View more

This doesn't appear to work. When I drag 68db533f-58e2-4f93-aaab-7710688df46c.geodatabase to the input data field it returns "Invalid". Is there another way to recover the contents of the offline geodatabase containing edits which fail to sync? ... View more

...added globalID to the feature class....republished....seems to work now ... View more

...removed Editor Tracking from the FGDB and republished....same error. ... View more