Latest Contributions by ThomasColson

...and on that note....does the Feature Service and Service Definition also need to be shared with the same group as the web map? ... View more

So if I share this with "Group A", which I'm a member of, if I want others to be able to see this on collector, they also need to be members of "Group A"? ... View more

....and here's a another one that handles updates to the XY or the geometry.... CREATE TRIGGER    [dbo].[GRSM_POINTS_OF_INTEREST_Update_Geo] ON    [dbo].[GRSM_POINTS_OF_INTEREST] after  UPDATE NOT FOR REPLICATION AS   BEGIN      SET NOCOUNT ON;    UPDATE p SET      X_Coord = CASE WHEN i.shape.STDimension() = 2        THEN i.shape.STCentroid().STX        ELSE i.shape.STEnvelope().STCentroid().STX      END,     Y_Coord = CASE WHEN i.shape.STDimension() = 2        THEN i.shape.STCentroid().STY        ELSE i.shape.STEnvelope().STCentroid().STY      END,      QuadName = COALESCE(b.name, p.QuadName),     Watershed = COALESCE(c.HU_12_Name, p.Watershed),     County = COALESCE(d.Name, p.County),     State= COALESCE(e.Name, p.State),     SubRangerDistrict = COALESCE(f.District, p.SubrangerDistrict)   FROM      dbo.GRSM_POINTS_OF_INTEREST AS p   INNER JOIN      inserted AS i     ON i.Location_ID = p.Location_ID   LEFT OUTER JOIN grsm.dbo.USGS_24K_TOPOMAP_BOUNDARIES AS b     ON b.Shape.STContains(i.Shape) = 1       LEFT OUTER JOIN grsm.dbo.WBD_12 AS c     ON c.Shape.STContains(i.Shape) = 1           LEFT OUTER JOIN grsm.dbo.GRSM_COUNTIES AS d     ON d.Shape.STContains(i.Shape) = 1               LEFT OUTER JOIN grsm.dbo.GRSM_States AS e     ON e.Shape.STContains(i.Shape) = 1     LEFT OUTER JOIN dbo.GRSM_SUB_RANGER_DISTRICTS AS f ON f.Shape.STContains(i.Shape) = 1   WHERE EXISTS    (     SELECT 1 FROM inserted AS i2       INNER JOIN deleted AS d       ON i2.Location_ID = d.Location_ID       WHERE i2.Location_ID = i.Location_ID       AND i2.Shape.STEquals(d.Shape) = 0       -- ...and NULL handling if necessary   ); END GO ... View more

This works when using SQL Geometry as the storage type, I'm not sure you can do what you're asking when using SDE binary, unless you cook up a really complicated stored procedure. As always, ESRI will disown you if you call tech support with any SDE issue and they discover you're using triggers, SP's, and such "under the hood". This allows to either populate UTM XY on insert from a GIS client, or create the geometry object on insert from a non-gis client (using a SP that also honors the Object ID creation!). In addition, it is also performing a number of intersect operations to populate some attributes that we adminstratively in all of our data per local protocol. Finally, it's allowing us to set the GlobalID (LocationID Field) as a sequential GUID, which has done wonders to improve performance over the non-sequential default ESRI GUID. Use at your own risk! 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 ... View more

Assuming your attachments are BLOB's, then no, you cannot view them through a linked table in Access. ... View more

You could, but you'll spend more time messing with SQL than with GIS, and be recognized by your superior as a "DB Admin". Access CANNOT edit data in a table with the SQL Geometry field, and you'd need some pretty complex triggers on indexed views in order to make them editable. At this point, why are you using GIS? We've accomplished some of this using VS Lightswitch and insert/update triggers, but took years to get to this point. There is no simple way to edit SDE tables outside of ArcGIS without extensive customization and a rock-solid back up plan. And...once you do so....don't bother calling ESRI tech support about ANY problem with your SDE. They catch you doing that, and you're on their "Do not return call list". "Are you sure this isn't related to the time you tried editing that table with Access 7 years ago?" they'll say.... ... View more

I'm curious...actually I'm desperate to figure out how....how are you using Mapbox tiles as a basemap without having to do custom coding/compiling? ... View more

Hi, nice script. Anyway to extend it to include a success message after each tool runs? E.g. I have a very long and complicated py that exports a bunch of stuff out of SDE into a FGDB, would like to know which FC's exported successfully, and which failed. Thanks! ... View more

This has been resolved with the application of the latest 10.1 SP1 QIP service pack. ... View more

It does work in 3.6. It'd be nice if there was source code, or some other ability to add more coordinate formats/projects to the default functionality. ... View more

That worked perfectly thanks! ... View more

C:\Python27\ArcGISx6410.1\pythonw.exe "C:\Python27\ArcGISx6410.1\Lib\idlelib\idle.pyw" is what I'm using for standalone. Further testing reveals that ALL of the production mapping tools return this error, I am able to run other tools just fine in standalone python. Production mapping tools run fine in Arc Map, as a tool, or Arc Map python window. Has ESRI perhaps disabled execution of Production Mapping tools in standalone python in Arc Map 10.1? I'm able to reproduce this on many different workstations. ... View more

I was unable to get availability = arcpy.CheckExtension("Foundation") if availability == "Available":    arcpy.CheckOutExtension("Foundation")    arcpy.AddMessage("Foundation Ext checked out") else:    arcpy.AddError("%s extension is not available (%s)"%("Foundation Extension",availability))    arcpy.AddError("Please ask someone who has it checked out but not using to turn off the extension")    return to work however: >>> arcpy.CheckOutExtension("Foundation") u'CheckedOut' >>> arcpy.CheckInExtension("Foundation") u'CheckedIn' works fine. I'm running a checked-out license enviroment, and this workstation has every extension and license checked out to it, and all tool in all toolboxes work fine with no license issues. Trans = r'C:\Temp\Python\GRSM_20140326075058.gdb\Boundaries_And_AOIs\grsm_bndry_polygon' TarGDB = r'C:\Temp\Python\GRSM_20140326075333.gdb' arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","") still fails with: Traceback (most recent call last):   File "C:\Temp\Python\GRSM.PY", line 17, in <module>     arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","") AttributeError: 'module' object has no attribute 'ExtractData_production' I've put this in a .py file, so there are no carraige return or escape issues, same result. >>> Trans = r'C:\Temp\Python\GRSM_20140326075058.gdb\Boundaries_And_AOIs\grsm_bndry_polygon' >>> Trans 'C:\\Temp\\Python\\GRSM_20140326075058.gdb\\Boundaries_And_AOIs\\grsm_bndry_polygon' >>> TarGDB = r'C:\Temp\Python\GRSM_20140326075333.gdb' >>> TarGDB 'C:\\Temp\\Python\\GRSM_20140326075333.gdb' >>> arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","") Traceback (most recent call last):   File "<pyshell#7>", line 1, in <module>     arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","") AttributeError: 'module' object has no attribute 'ExtractData_production' ... View more