Tag Info

New answers tagged

2

Unfortunately with SQL Server 2008 R2 your options are quite limited. If you are able to enable CLR on your server, you can use something like this to add extra capabilities, including aggregates. Another option would be to create a procedure/function using CURSORs to step through the dataset and do the Unioning. This would likely to be quite slow. ...


2

If you want to query by x & y coordinates, use Get Cell Value (Data Management) . If you want to query by point features, you can use Sample (Spatial Analyst) or Extract Values to Points (Spatial Analyst). If you want an array of raster values in an extent, you can use RasterToNumPyArray (arcpy).


1

I use the GEOMETRY::UnionAggregate function in SQL Server to do this for our Elem, Mid and High boundaries In the dbo.SchoolBoundaries table below, the ELEM_NUM value is what I want to group on, and values of 0 are non-district boundaries (which I filter out): SELECT elem_num , GEOMETRY::UnionAggregate(shape) as shape FROM [dbo].[SchoolBoundaries] ...


1

After so many tries i was able to copy Export current personal gdb to xml workspace document and also export arcfm properties, then import xml workspace document and arcfm properties to arcsde. Before running geometric network dont forget to registered as version. use right click import/export from the ArcCatalog tree.


1

First of all, both Copy and Import will honor any relationships. per the ArcGIS documentation: Any data dependent on the input is also copied. For example, copying a feature class or table that is part of a relationship class also copies the relationship class. The same applies to a feature class that has feature-linked annotation, domains, subtypes, ...


1

I use this free software, Spatial Data Manager. I found that it is the only free software that can load spatial data directly between the major RDBMS. You can filter your data during the export operation. Cheers.


0

It apears QGIS is looking for atleast one integer value in the data. The solution consists of creating a view based on the original table including an extra col: ROW_NUMBER() OVER(ORDER BY [Outlet Code] DESC) AS Row This view can than be added in QGIS using the method described earlier. It might be interesting to know how one could tell QGIS that this ...


0

Here is a basic trigger that will get fired when a record gets updated: CREATE TRIGGER dbo.trg_MY_TABLE_OnUpdate ON dbo.MY_TABLE AFTER UPDATE AS Begin Update dbo.MY_TABLE Set DATE_CHANGED = CURRENT_TIMESTAMP, USER_CHANGED = SYSTEM_USER Where MI_PRINX In (Select MI_PRINX From inserted); End GO and a similar one for a record ...


1

You'll need to install the ArcObjects SDK to work with your enterprise geodatabases. If you have ArcGIS, the SDK is available to you as a separate install. You can find it either on your installation DVD (if you have one) or for download from the customer service site. Please see the links below for more info. ...


1

Normally, no, you cannot just change the SRID value. SRID stands for Spatial Reference System Identifier and is a coded value describing what coordinate system the data's geometry is in. Let's take the example of the two CRS (coordinate reference systems) you have. 4326 is WGS84, which is a geographic CRS with degrees for units and the WGS84 datum. 27700 is ...


2

I'm assuming that you are using Geometries, but the methodologies remain mostly the same. When tuning spatial queries, these are the steps I take This is the most important step. Check the indexes are suitable for the table. If you have SQL Server 2012+ then I would suggest that you use the AUTO GRID. This gives you a finer grid. Make sure the extents ...


1

What I have found speeds these intersection queries up the most is forcing the spatial index: In a view I deliver to BI which intersects ~280,000 address points with ~300 boundary polygons, I force the use of the address point spatial index: ... FROM [dpsdata].[Address_Master] as am with (index(SIndx_AddrMsterIC)) left outer join ...



Top 50 recent answers are included