Hot answers tagged

5

If you have a materialized view with a geometry column, you don't need to "create a spatial view" -- it's already created! At this point you have two options: Use the materialized view as a Query Layer Register the view with your enterprise geodatabase Unfortunately, in the crush to retire ArcSDE application servers and the admin utilities that let ...


4

Answering my own question. In the WHERE clause I had to change T.STIntersect(S) to T.Shape.STIntersects(S.Shape) = 1 Full example: SELECT T.TreeID, T.ServiceAreaNumber AS RecordedServiceArea, S.ServiceAreaNumber AS ActualServiceArea FROM TREE T, SERVICEAREA S WHERE T.Shape.STIntersects(S.Shape) = 1 AND T.ServiceAreaNumber != ...


2

You only need one writer (to the SDE database) but multiple outputs for each feature class. In fact if I specify my Reader feature classes first, when I create my output Writer it asks me if I want to create matching output feature classes, and then all I need to do is link them (and add any transformers between them if desired) I believe there is a way ...


2

You can do this with the Describe function: desc = arcpy.Describe(your_fc) if desc.editorTrackingEnabled and not desc.isTimeInUTC: print 'you need to switch this to UTC to publish!'


1

So I figured it out - @Yanes was close but instead of three sets of double quotes, it needed to be double-single-double. So the following script works: -- Turn ReportsTable into a View Table arcpy.MakeTableView_management(ReportsTable, ViewTable) -- Get start and end times for report start_time= datetime.timedelta(hours = 24) end_time = ...


1

Try wrapping your Where statement with three double quotations so that Arcpy understands it as an expression for your select function not a standalone SQL task - I may be wrong on the reasoning, I will check. SQL = """ "created_date" >= '{}'""".format(report_time.strftime('%Y-%m-%d %H:%M:%S')) ...


1

For this type of generic question regarding server "specs" for ESRI solutions, the most authoritative and comprehensive documentation can be found on ESRI's "System Design Strategies" Wiki pages: http://wiki.gis.com/wiki/index.php/System_Design_Strategies_Preface


1

I believe you will need to register your materialized view in SDE so that it recognizes the view as a spatial table. If that is not an option, you may want to refer to the documentation and possibly make a conventional view that accesses the materialized view, but calls the appropriate functions to retrieve the data in a fashion suitable for ArcGIS Desktop. ...


1

The Incremental Network Loader tool works for file geodatabases and personal SDE instances, but appears to have a bug for loading into SDE's, default or version. We're reporting this bug to ESRI. Alternatively, I found two other methods for accomplishing the data load into my SDE version: 1) Append Tool - quick and new features were snapped to the ...


1

We have almost exactly this same problem, same versions of everything except our SDE has been upgraded using the scripts from ArcGIS Pro 1.1, and I have tried using, alternately, the .jar file jpe_sdk.jar from 10.1 as well as 10.2.2, which is called jpe_10.2_sdk.jar. I can't seem to find that file in the 10.3.1 ArcGIS Server install, which indicates to me ...


1

I was asked this question today ("How do I identify if a featureclass has curves) and was given some arcpy code suggestions. Modify the following code as you see fit (a flag variable instead of a message for example) geometries = arcpy.CopyFeatures_management("inputFeatures", arcpy.Geometry()) import json for g in geometries: j = json.loads(g.JSON) ...



Only top voted, non community-wiki answers of a minimum length are eligible