Tag Info

New answers tagged

0

Given that I am still in 10.1, if you reconcile and post, but there is a lock on the feature class, the dates and editors will not be posted to the business table. If you need to see the data immediately for reporting purposes or other pressing reason(s), you can see the editor tracking information in the Adds table (a table) for that particular feature ...


0

There are several underlying related tables in SDE that have a chance of not being updated properly if the table delete happened nontraditionally. The most likely cause of this issue is that the table name is persisting in the table registry even though the table has been deleted from SDE. First, run a SELECT * on [database].[schema].[SDE_table_registry]. ...


3

There are a number of definitions to "centroid", but the most common solution for labeling a linear feature involves either the midpoint along the arc or the midpoint of the longest segment on the arc. Averaging the vertices is unlikely to be "on" the feature and will over-emphasize the significance of short segments. If it's acceptable for the label to be ...


1

I do not have an SQL Server table available to test this, but I was surprised to see you using pyodbc in this workflow. I recommend that you try to use a Query Layer: A query layer is a layer or stand-alone table that is defined by a SQL query. ... You can persist a query layer by exporting it to a feature class.


0

As commented by @whuber: As ratios of two lengths, scales are inherently unit free. Some maps describe their scales as ratios of lengths in different units (such as feet or miles per inch)--and when they do, they are usually clear about what lengths are involved. In other words, the term "unit of measurement for scale" does not make sense to use. ...


1

Since you've already got a list of dicts, you can use Shapely (to manage the geometry) and Fiona (to write the shape file). from shapely.geometry import mapping from shapely.wkt import loads from fiona import collection schema = {'geometry': 'Point', 'properties': {'atribute1':'value', 'atribute2':'value'}} with collection("output.shp", "w", "ESRI ...


0

First, if you don't have a geometry/geography column in the table yet, add it by converting WKT or WKB to geometry/geography using SQL Server Spatial (STLineFromText, STPOlyFromText, STPointFromWKT, similarily works from WKB). Then, simply connect to the database (Database Connection) and create a query layer. At this point, you'll have a layer in the ...


0

There are no known issues of performance degradation with upgrading to SQL SERVER 2008 R2. In the recent times the only bug that I can think of is [NIM082657:When working with an SQL Server 2012 geodatabase and Geometry or Geography type data, ArcMap drawing performance is slower than it was using SQL Server 2008. This affects all rendering and editing ...


0

The error is not very clear, but definitely not related to the number of users connecting to the database. (In such cases you get error - Unable to connect to database. Maximum number of connections to instance exceeded). I error message mentions STATE_ID, considering this I would recommend you to COMPRESS the database once (it is okay to compress even ...


0

I think this will work: Dim queryAddress As New StringBuilder() queryAddress.Append("http://maps.google.com/maps?q=") For i = 0 To Me.DataGridView1.RowCount - 1 If Me.DataGridView1.Rows(i).Cells(0).Value <> String.Empty Then lat = Me.DataGridView1.Rows(i).Cells(0).Value queryAddress.Append(lat + "%2C") ...



Top 50 recent answers are included