数据管理问题 //www.gobook3.com/t5/data-management-questions/bd-p/data-management-questions 数据管理问题 2023年1月14日星期六07:56:29 GMT data-management-questions 2023 - 01 - 14 t07:56:29z FDO错误:-2417483640验证网络拓扑 //www.gobook3.com/t5/data-management-questions/fdo-error-2417483640-validaing-network-topology/m-p/1244496#M44350

嗨,这个错误出现在验证地图的某些部分时,它是在修改终端连接之后,但是当我像以前一样把它们放回去时,这个错误没有被删除,它一直出来。有人知道怎么修吗?非常感谢!< / P >

Edit operation failed: FDO error: -2147483640 [Topology_engine::query_from_to_junctions(): Topology entry (edge eid: 1261) not found.]

2022年12月30日星期五07:26:18 GMT //www.gobook3.com/t5/data-management-questions/fdo-error-2417483640-validaing-network-topology/m-p/1244496#M44350 LucasGodedMoreno 2022 - 12 - 30 - t07:26:18z
通过数据库视图或定义查询筛选数据以获得更好的性能 //www.gobook3.com/t5/data-management-questions/filter-data-by-database-view-or-definition-query/m-p/1243197#M44345

你好,

我目前正在研究影响我们组织地理数据基础设施(ArcSDE in SQL Server, ArcMap 10.6)性能的因素。 通过我们的ArcMap项目,我发现我们在从数据库表过滤数据时专门使用定义查询。

现在我想知道,如果通过创建数据库视图在加载到ArcMap之前过滤数据会有什么不同。有没有人对我有一个答案,我们是否可以期望在性能增益(例如加载mxd文档)时使用数据库视图而不是定义查询?

大家节日快乐

2022年12月22日星期四08:56:57 GMT //www.gobook3.com/t5/data-management-questions/filter-data-by-database-view-or-definition-query/m-p/1243197#M44345 ChristianJungnickl 2022 - 12 - 22 - t08:56:57z
像素块超过允许的最大大小 //www.gobook3.com/t5/data-management-questions/pixel-block-exceeds-the-maximum-size-allowed/m-p/1243003#M44344

我正在尝试使用Python代码和ArcGISPro跟踪城市地区不同土地覆盖上的流量。输入是4个栅格TIFF文件。代码在小流域中工作完美,但当我在更大的流域中使用它时,我得到了错误“像素块超过了允许的最大尺寸”。< / P >

I checked the solution on the Esri website, and the suggested solution is for mosaic file properties, and changing requested rows and columns from the "default" tab of "mosaic file properties". I checked these steps, but I don't have the "default" tab at all. 

So, I really appreciate it if anyone can help me with that. 

2022年12月21日星期三17:34:11 GMT //www.gobook3.com/t5/data-management-questions/pixel-block-exceeds-the-maximum-size-allowed/m-p/1243003#M44344 AidaYahyaviRahimi1 2022 - 12 - 21 - t17:34:11z
没有数据与仪表板 //www.gobook3.com/t5/data-management-questions/no-data-whith-dahsboard/m-p/1242011#M44343

嗨,我有一个表在我的数据源在我的arcgis企业10.8。< / P >

But when I want use a graphic whit that table, send me the label, no data.

ArturoJuarezLima_0-1671203539064.png

but if I push the boton for show the table data, show me correct information

ArturoJuarezLima_1-1671203612813.png

and if I choose for entity, show me the data feature by feature right.

ArturoJuarezLima_2-1671203720945.png

Could you help me?

 

 

2022年12月16日(星期五)15:17:25 GMT //www.gobook3.com/t5/data-management-questions/no-data-whith-dahsboard/m-p/1242011#M44343 ArturoJuarezLima 2022 - 12 - 16 - t15:17:25z
使用ArcGIS桌面“ArcMap”10.8.1与10.9.1 geodatabases? //www.gobook3.com/t5/data-management-questions/using-arcgis-desktop-quot-arcmap-quot-10-8-1-with/m-p/1241778#M44342

问题:

我们最近有几个客户使用ArcGIS Desktop 10.8.1,其企业地理数据库升级到10.9.1。

是否有一个官方的不支持的功能列表,将不能与此组合工作??

我听说使用ArcGIS Desktop 10.8.1和10.9.1 geodatabase编辑几何网络是不支持的。

但是我们的用户已经尝试过了,到目前为止还没有遇到问题。

另一个客户端关心他们正在使用的拓扑。

是否有一个面向外部的文档页面,比如“10.9.1的新功能”页面或弃用通知页面,我们可以指向用户??

答案:

1。< / SPAN > < SPAN > <强>客户端和geodatabase兼容性< /强> < / SPAN > < / P > < P > <标题= " https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/client-geodatabase-compatibility.htm " href = " https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/client-geodatabase-compatibility.htm " target = "平等" rel = " noreferrer noopener”> https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/client-geodatabase-compatibility.htm < / > < / P > < P > MarceloMarques_0-1671143333188.jpegMarceloMarques_1-1671143352866.jpeg

< span>support.esri.com< SPAN>弃用FAQ文章 旧版< P>FAQ: What are the deprecation plans for ArcGIS products? (esri.com)

3. Deprecation FAQ has moved

Going forward use the Esri Support Product Pages https://support.esri.com/en/Products

choose the product and click the "Deprecation" icon

MarceloMarques_2-1671143378594.jpeg
2022年12月16日星期五00:28:05 GMT //www.gobook3.com/t5/data-management-questions/using-arcgis-desktop-quot-arcmap-quot-10-8-1-with/m-p/1241778#M44342 MarceloMarques 2022 - 12 - 16 - t00:28:05z
如何检查属性表中的字段是否包含空白单元格? //www.gobook3.com/t5/data-management-questions/how-do-i-check-if-a-field-in-the-attribute-table/m-p/1239028#M44329

我有很多层,每一层都包含大量的数据,我想知道在没有打开和预览这些表的情况下,层的属性表中是否有空的单元格?< /强> < / P > 2022年12月8日星期四07:07:51 GMT //www.gobook3.com/t5/data-management-questions/how-do-i-check-if-a-field-in-the-attribute-table/m-p/1239028#M44329 AhmedWaheed1 2022 - 12 - 08 - t07:07:51z Arcgis服务器读取其他数据库没有SDE //www.gobook3.com/t5/data-management-questions/arcgis-server-read-other-data-base-with-out-sde/m-p/1237816#M44325

嗨,我有arcgis企业v 10.8.1,我需要连接到DB Oracle,但在这个DB中,我没有Geodatabase. 

当我连接我的数据存储时,连接是否有问题,包括当我收费时我的表不发送我错误。但是,当我尝试从门户网站中的表中读取我的数据时,向我发送字段正确的名称,但数据向我发送标签“数据错误”。< / P >

I check the log from my DB and arrive the query correct (select x from y where 1=1).

 

ArturoJuarezLima_0-1670254911817.png

 

2022年12月5日星期一15:48:55 GMT //www.gobook3.com/t5/data-management-questions/arcgis-server-read-other-data-base-with-out-sde/m-p/1237816#M44325 ArturoJuarezLima 2022 - 12 - 05 - t15:48:55z
在版本化地理数据库中显示用于编辑的功能类 //www.gobook3.com/t5/data-management-questions/display-a-feature-class-for-editing-in-a-versioned/m-p/1236951#M44319

我最近获得了访问数据所有者帐户的权限,以协助版本化的gdb维护。 我们需要使数据所有者帐户中显示的几个功能类对gdb的不同子版本可见(并可编辑)以供使用。使“新”特性类对不同的。side视图可见,以便我们的用户可以编辑它们的过程是什么?< / P > 2022年12月1日星期四19:50:02 GMT //www.gobook3.com/t5/data-management-questions/display-a-feature-class-for-editing-in-a-versioned/m-p/1236951#M44319 DValley 2022 - 12 - 01 - t19:50:02z 与其他发布方法相比,从SDE数据存储进行批量发布 //www.gobook3.com/t5/data-management-questions/bulk-publishing-from-sde-datastore-versus-other/m-p/1236715#M44317

我们的目标是从我们的SDE地理数据库中发布许多特征层。(ArcGIS v 10.9, SQL Server 2017)

我们希望门户用户能够使用标签和类别轻松查找数据。  我们很好地应用了元数据 在钻又是;(说明、标签等) ,这些层仅用于查询和分析(不用于编辑)。< / P >

How do most large organisations publish their layers for these Portal users ??

1.  Bulk publish (Sync) their SDE datastore connections and share accordingly

2.  Create a few monster map documents and publish those from Pro.

3.   Use a script to publish a single feature service for each layer.  

 

Test so far prove that number 1 works OK.  The tags and descriptions can be searched when finding layers.   

Although I find the administration of the datastore a little cumbersome as I have to ensure the database connection username has access to the layer first.

Approach number 2 is not helpful because all the sub-layers of a feature service do not store their individual Tags or descriptions.  So the user can't search for the individual layers.

Approach number 3.   Is this worth pursuing ?

What do large ArcGIS Enterprise clients normally do here ?

2022年12月1日星期四07:58:53 GMT //www.gobook3.com/t5/data-management-questions/bulk-publishing-from-sde-datastore-versus-other/m-p/1236715#M44317 GeorgieCassar1 2022 - 12 - 01 - t07:58:53z
在企业门户网站上发布偶然值 //www.gobook3.com/t5/data-management-questions/publish-contingent-values-on-enterprise-portal/m-p/1235051#M44315

Hello All,

Contingent Values是否支持ArcGIS Enterprise Portal?我知道表单(创建属性编辑表单(地图查看器)-ArcGIS Online Help | Documentation)必须在ArcGIS Online上使用,以便看到从ArcGIS Pro发布的或有值。但是,我无法在我的企业门户上重新创建相同的内容。< / P >

I am using:

  • ArcGIS Pro 3.0.2
  • ArcGIS Enterprise 10.9.1

Thanks

2022年11月25日(星期五)14:39:34 GMT //www.gobook3.com/t5/data-management-questions/publish-contingent-values-on-enterprise-portal/m-p/1235051#M44315 RandyMcGraw1 2022 - 11 - 25 - t14:39:34z
用于测深的坡度工具 //www.gobook3.com/t5/data-management-questions/slope-tool-for-bathymetry/m-p/1233570#M44311

你好! 

 

我想知道斜坡工具是否可以用于测深点(负高程值)? 斜率是怎样的呢?

谢谢。

 

2022年11月20日,星期日,05:10:54 GMT //www.gobook3.com/t5/data-management-questions/slope-tool-for-bathymetry/m-p/1233570#M44311 MShairah 2022 - 11 - 20 - t05:10:54z
存储几百个LAS文件的方法 //www.gobook3.com/t5/data-management-questions/way-to-store-several-hundred-las-files/m-p/1233527#M44309

我想知道如何在ESRI环境中存储数百个LAS文件。< / P >

We have ArcGIS Enterprise running and I would like to make the point cloud data of our entire country available to everybody within my organization.

What is the best way possible to do that, so that the data are easily and fast accessible for ArcGIS Pro users, and that the data at the same time can be used for analysis on a GeoAnalytics Server?

2022年11月19日星期六19:18:10 GMT //www.gobook3.com/t5/data-management-questions/way-to-store-several-hundred-las-files/m-p/1233527#M44309 TomGeo 2022 - 11 - 19 - t19:18:10z
Compress没有清空A表。数据在数据库中。 //www.gobook3.com/t5/data-management-questions/compress-did-not-empty-the-a-tables-data-in-base/m-p/1233503#M44307 < P >嗨又是;我的客户端有一个SQL Server 2019数据库,正在使用ArcMap 10.8.1. 企业地理数据库的版本也是10.8.1。< / P >

The client has a simple point feature class with attachments enabled.  They are capturing photos into the attachment.

The attachment table has 5012 rows and the associated A table also has 5012 rows.  When we try to compress we receive an error which states that:

  • Cannot insert duplicate key row in object 'featureclass' with unique index 'R87_SDE_ROWID_UK'.
  • The duplicate key value is (25).::Unable to trim state 109 to 0 for table

I've reviewed various toolbox tools, including:

  • Diagnose Version Metadata
  • Diagnose Version
  • Repair Version Metadata
  • Repair Version

Each of which returns:

  • Error executing function.
  • A check constraint violation has occurred.

As mentioned above when I review the Base and A tables in SSMS, the counts are the same.  There are no records in the d table, and the client has said that they have only ever 'added' to the data.

When I run the following SQL:

   SELECT *

   FROM   [DB].[a191]

   WHERE  EXISTS (SELECT 1

                   FROM   [DB].[Table__ATTACH]

                   WHERE  [DB].[a191].[GLOBALID] = [DB].[Table__ATTACH].[GLOBALID])

I got 5012 rows, which shows every globalid in the A table is already in the base table and the unique id constraint is preventing it from being appended. 

This all makes complete sense.  What doesn't make sense is why the Compress tool has left it hanging in the A table.  The last successful compress was in November last year.  Each Compress since is logged as:

   FAILURE -51

Does anyone have a view on how to move forwards?  I'm currently thinking of using SSMS to truncate the A table, but feel that isn't the right way, but no Toolbox tools seem to be helping.

Hive mind, what do you think?

Many thanks in advance.

 

2022年11月19日星期六06:31:07 GMT //www.gobook3.com/t5/data-management-questions/compress-did-not-empty-the-a-tables-data-in-base/m-p/1233503#M44307 Scott_Tansley 2022 - 11 - 19 - t06:31:07z
SQL数据库视图vs. Join //www.gobook3.com/t5/data-management-questions/sql-database-view-vs-join/m-p/1233275#M44305

你好,

我有一个情况,我能想到两个解决方案,我很想知道是否有一个是首选的方法。我有一个SQL数据库(side),其中有一些功能类从我的ESRI Geodatabase复制过来。数据库有一个非常大的表,其中包含服务订单列表。最终目标是有一个web地图,它将基于表中的工作订单状态在特性类(通过REST URL添加)中标记点。我有一个唯一的ID,与工作订单的特征相匹配。用户不需要使用结果显示来编辑任何内容,所有服务订单编辑都是在第三方软件中完成的。< / P >

Option one:

Create a new SQL view that selects a desired subset of attributes from feature class and service order table, sets desired WHERE clause and join the feature class data to the service order data based on the unique ID. Include the view in an ArcPro document, publish to federated server.

Option two:

In Pro document, add the feature class, join the feature class to the table containing the service orders. Set definition query on the feature class, make undesired fields not visible, publish to federated server.

 

I can provide more specifics if necessary, but I suppose my main question is, from a performance standpoint, are joins superior to views? Vice verse?

2022年11月18日星期五16:43:48 GMT //www.gobook3.com/t5/data-management-questions/sql-database-view-vs-join/m-p/1233275#M44305 EPAGOADMIN 2022 - 11 - 18 - t16:43:48z
使用ArcGIS Pro重新创建副本 //www.gobook3.com/t5/data-management-questions/recreate-replicas-using-arcgis-pro/m-p/1232325#M44303

我创建了一个python脚本,使用ArcGIS Pro中的地理处理工具来重新创建现有的副本(或创建新的副本),我想我会分享给社区。这个脚本不会在ArcMap中运行,因为“UnregisterReplica_management”工具是ArcGIS Pro的新工具。在向父副本特征数据集添加新的特征类之后,这非常有用。< / P >#---------------------------------------------------------------------- #title :RecreateReplica.py #description :Creates new replicas or recreates existing replicas using geoprocessing tools available in ArcGIS Pro 3 #description :The script is setup to work with enterprise geodatabases in SQL Server #description :Works for "SIMPLE", "One Way Replicas" only and is configured to operate at the individual feature dataset level #description :The data in the child geodatabase needs to be free of schema locks (putting the SQL database in Restricted user mode before running the script will remove schema locks) #author :Bill Myers #last_update :11/15/2022 #notes :Runs in ArcGIS Pro 3.0.2 #python_version :3 #---------------------------------------------------------------------- import sys, arcpy #---------------------------------------------------------------------- #Setup runPath = sys.path[0] dataSchema = "GIS" dataName = "Boundaries" #Feature dataset and replica base name. parentGDB = "SdeDev" childGDB = "SdeTemp" #Feature datasets parentFDName = "{0}.{1}.{2}".format(parentGDB, dataSchema.upper(), dataName) #"SdeDev.GIS.Boundaries" childFDName = "{0}.{1}.{2}".format(childGDB, dataSchema.upper(), dataName) #"SdeTemp.GIS.Boundaries" #SDE connection file (should be already setup in ArcGIS Pro) parentGDBConn = "{0}\\cosgissql_{1}_{2}.sde".format(runPath, parentGDB, dataSchema) #"cosgissql_SdeDev_GIS.sde" childGDBConn = "{0}\\cosgissql_{1}_{2}.sde".format(runPath, childGDB, dataSchema) #"cosgissql_SdeTemp_GIS.sde" #Replicas replicaName = "Replica_{0}_{1}".format(dataSchema, dataName) #"Replica_GIS_Boundaries" replicaNameFull = "{0}.{1}".format(dataSchema.upper(), replicaName) #"GIS.Replica_GIS_Boundaries" parentReplicaExists = True childReplicaExists = True parentReplicaDatasets = [] childReplicaDatasets = [] childReplicaTables = [] #Replica params expand = "DO_NOT_ADD" getRelated = "DO_NOT_GET_RELATED" #expand = "ALL_ROWS" #getRelated = "GET_RELATED" #Environment arcpy.env.overwriteOutput = True arcpy.env.workspace = childGDBConn #---------------------------------------------------------------------- def replicaExists(gdb, name): exists = False for replica in arcpy.da.ListReplicas(gdb): if replica.name.upper() == name.upper(): exists = True break return exists #---------------------------------------------------------------------- #Find if replicas exist childReplicaExists = replicaExists(childGDBConn, replicaNameFull) parentReplicaExists = replicaExists(parentGDBConn, replicaNameFull) #Get parent datasets to replicate arcpy.env.workspace = parentGDBConn + "\\" + parentFDName fcs = arcpy.ListFeatureClasses() for fc in fcs: fullPath = parentGDBConn + "\\" + fc parentReplicaDatasets.append(fullPath) #arcpy.AddMessage(parentReplicaDatasets) if childReplicaExists and parentReplicaExists: arcpy.AddMessage("Removing existsing replicas: " + replicaNameFull) #Get child replica datasets for replica in arcpy.da.ListReplicas(childGDBConn): if replica.name == replicaNameFull: childReplicaDatasets = replica.datasets #arcpy.AddMessage(childReplicaDatasets) #get child tables for dataset in childReplicaDatasets: desc = arcpy.Describe(childGDBConn + "\\" + dataset) if hasattr(desc, "dataType") and desc.dataType == "Table": childReplicaTables.append(childGDBConn + "\\" + dataset) #reset params to handle related tables if len(childReplicaTables) > 0: expand = "ALL_ROWS" getRelated = "GET_RELATED" #Unregister arcpy.AddMessage("...Unregistering Replica") arcpy.UnregisterReplica_management(parentGDBConn, replicaNameFull) arcpy.UnregisterReplica_management(childGDBConn, replicaNameFull) #Delete child tables if len(childReplicaTables) > 0: arcpy.AddMessage("...Deleting child tables") arcpy.Delete_management(childReplicaTables) #Delete child feature dataset arcpy.AddMessage("...Deleting child feature dataset") dataPath = childGDBConn + "\\" + childFDName arcpy.Delete_management(dataPath) #Create Replica arcpy.AddMessage("Creating Replica: " + replicaNameFull) arcpy.management.CreateReplica(parentReplicaDatasets, "ONE_WAY_REPLICA", childGDBConn, replicaName, "SIMPLE", "PARENT_DATA_SENDER", expand, "DO_NOT_REUSE", getRelated)

 

2022年11月17日星期四20:08:37 GMT //www.gobook3.com/t5/data-management-questions/recreate-replicas-using-arcgis-pro/m-p/1232325#M44303 BillMyers 2022 - 11 - 17 - t20:08:37z
如何刮/绘图/导入地图盒在线地图到ArcGis Pro。从。pbf格式文件 //www.gobook3.com/t5/data-management-questions/how-to-scrape-plot-import-map-box-online-maps-to/m-p/1230891#M44301

你好,

 

我正试图将在线网络地图导出到我的ArcGisPro项目中用于我自己的分析。 
我试图通过检查元素来查看网络选项卡。我发现他们正在使用地图框,数据正在使用。pbf格式文件绘制。 
有没有办法废弃这些数据或直接在我的项目上绘制他们的数据? 

2022年11月11日(星期五)14:17:41 GMT //www.gobook3.com/t5/data-management-questions/how-to-scrape-plot-import-map-box-online-maps-to/m-p/1230891#M44301 AbishekDeiveekan 2022 - 11 - 11 - t14:17:41z
找不到与讲师指导课程相同的工具 //www.gobook3.com/t5/data-management-questions/cannot-find-the-same-tool-as-the-instructor-led/m-p/1229910#M44294

大家好,

当我准备助理考试时,我发现了书中的步骤说明和ArcGIS专业工具之间的区别。< / P >

In "Managing Geospatial data in ArcGIS", the context of lesson 1,step 4,page 1-17 is that when I am clicking on the filegeodatabase "auroraCity", then click on "import", I will find "feature class" which will open "Feature class to feature class" tool.

Actually, when i clicked "import" i did not find "feature class" but i found "feature class(s)" which opens "Feature class to geodatabase" tool.

Note: I have ArcGIS pro version 3 and the file geodatabase version is 10.

I wonder if all databases have the same tools for the "import" part.

Screenshot (71).png

2022年11月9日星期三11:39:21 GMT //www.gobook3.com/t5/data-management-questions/cannot-find-the-same-tool-as-the-instructor-led/m-p/1229910#M44294 HalaAbdelmaksoud 2022 - 11 - 09 - t11:39:21z
SDE用户和权限的审计工具 //www.gobook3.com/t5/data-management-questions/auditing-tools-for-sde-users-and-privileges/m-p/1229544#M44291

客户端请求对他们的2个数据库的用户和权限进行审计。里面有447个项目,我正在寻找一种通过脚本访问用户/特权信息以生成报告的方法。

2022年11月8日星期二15:53:33 GMT //www.gobook3.com/t5/data-management-questions/auditing-tools-for-sde-users-and-privileges/m-p/1229544#M44291 NoahMiller 2022 - 11 - 08 - t15:53:33z
如何缩放到下一个选择的功能 //www.gobook3.com/t5/data-management-questions/how-to-zoom-to-next-selected-feature/m-p/1229455#M44290

如果我选择了许多特征,我有时需要遍历这些特征,以便进行视觉检查。如果我正在使用ArcMap表,这是非常烦人和耗时的,必须右键单击下一行并选择平移或缩放。 

我那里需要一个工具,它提供了一个简单的功能-缩放或平移到下一个功能。 

我甚至无法看到我如何在数据审查器扩展中激活此功能。

< /P>

如果有人能够证明我错了,请写!< / P > 2022年11月8日星期二10:01:17 GMT //www.gobook3.com/t5/data-management-questions/how-to-zoom-to-next-selected-feature/m-p/1229455#M44290 RobertBuckley1 2022 - 11 - 08 - t10:01:17z 分割行并赋值 //www.gobook3.com/t5/data-management-questions/split-line-and-assign-values/m-p/1228994#M44286

我通过一个点层分割了一条很长的线(这是有效的),但现在我手动将点层中的值分配给线段。想知道是否有一种更快的方法来用代码或其他工具做到这一点?

更长的故事是,我正在设计一个河床和点代表已知的海拔沿通道和线段有上游和下游的值。我必须手动输入上行和下行值到行属性表,我想只是自动分配点值。我有两百多分要分配。欢迎任何反馈。 

2022年11月5日星期六22:36:11 GMT //www.gobook3.com/t5/data-management-questions/split-line-and-assign-values/m-p/1228994#M44286 LostInTheSauce 2022 - 11 - 05 - t22:36:11z