|
POST
|
Is there a way to tell if a service is being taxed or if it's not being used? I'm trying to get a better idea of where to set the pooling options for some of our services. I understand that by setting a higher minimum/maximum number of instances allows for more SOC instances but is there a way to definitively tell how much a service is being used? Thanks in advance!
... View more
07-02-2014
08:29 AM
|
0
|
1
|
3914
|
|
POST
|
I was the one that posted that question in GSE 🙂 As mentioned in above thread, the query performs poorly on large datasets with 2 sets of polygons. I ran STIntersects on a similar sized set of features using our address point layer (�??90,000 records) and SQL Server 2008 R2 did not time out and executed the view.
... View more
05-15-2014
04:57 AM
|
0
|
0
|
3719
|
|
POST
|
I can say the query below does what I was looking for, but as mentioned, the performance on a large dataset is poor. When trying to execute on our entire parcel dataset (�??100,000 records) SQL Server (2008 R2) times out. If executed on a smaller dataset, the results are as desired. Thanks for the input from everyone! (polygonA.Shape.STCentroid().STIntersects(polygonB.Shape) = 1)
... View more
05-15-2014
04:50 AM
|
0
|
0
|
3719
|
|
POST
|
I'm trying to construct the query/view within SQL Server...not within ArcMap/ArcCatalog...should have mentioned that eariler. My end goal is to have a SQL view comparing the geometries.
... View more
05-14-2014
12:28 PM
|
0
|
0
|
3719
|
|
POST
|
Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm trying to do this within SQL Server Management Studio, not ArcMap/ArcCatalog in order to produce a SQL view. I have two polygon layers that are not exactly coincident and if I use STIntersects on the target polygon I get two different values where the polygons are not coincident. I was wondering if there is a query that can be used instead of STIntersects that would be similar to selecting the centroid of the polygon...? Thanks in advance!
... View more
05-14-2014
12:16 PM
|
0
|
8
|
7105
|
|
POST
|
Tom, Thanks for the replies! Most of that code is over my head as I'm not a heavy SQL user, just enough to be dangerous, but by no means an expert 🙂 Is there a 'template' sql trigger that could be written up for calculating x,y? Thanks again for the knowledge!
... View more
05-08-2014
11:19 AM
|
0
|
1
|
3063
|
|
POST
|
I guess I was curious if anyone had implemented such a routine into their workflow...and if so...if they'd be willing to share a sample of their trigger.
... View more
05-05-2014
10:08 AM
|
0
|
0
|
3063
|
|
POST
|
Does anyone know if it's possible to create a SQL trigger which would auto-calculate coordinate values for a feature class? Example: For a point feature class, when a point is added or updated, the fields 'XCoordinate' and 'YCoordinate' would be auto-updated. If this is possible, would it also be possible to calculate the coordinate values based on another coordinate system from what is used for the feature class, like WGS84 for longitude and latitude? Example Environment: DBMS: SQL Server 2008 R2 Geometry: SQL Geometry Thanks in advance!
... View more
05-05-2014
07:44 AM
|
0
|
7
|
4949
|
|
POST
|
Vince, Thanks for the info! Once the SDEBINARY feature class was in the same geodatabase as the view, using the sdetable -o create view worked and I was able to see the view as a 'feature' in ArcCatalog. With feature classes that use GEOMETRY (SQL Server) as their shape, can those views span databases and use the sdetable -o register command to store the view within a different geodatabase than the feature class? Also - what type of geometry is 'better', SDEBINARY or GEOMETRY for SQL Server? Thanks again for the knowledge, been trying to figure what the issue was all day!
... View more
04-28-2014
02:49 PM
|
0
|
0
|
922
|
|
POST
|
Does anyone know how to register a SQL spatial view using a feature class that has Esri binary as its shape? I have tried sdetable -o register and sdetable -o create_view but have been unsuccessful. This could be because of my own lack of knowledge with the command line. ArcSDE = 10.1 DBMS = SQL Server 2008 R2 Feature class name = lcbase.dbo.Parcels Joined table name = gis.dbo.vw_parcels Trying to create the view in a geodatabase called 'gisstaging'. Below is the create_view command line prompt I've tried with an error (Error -162, Invalid Database Name) sdetable -o create_view -T VWTest -t lcbase.dbo.PARCELS,gis.dbo.vw_parcelsweb -c lcbase.dbo.PARCELS.SHAPE,lcbase.dbo.PARCELS.GPNNUM,gis.dbo.vw_parcelsweb.GPN -w"lcbase.dbo.PARCELS.GPNNUM = gis.dbo.vw_parcelsweb.GPN" -i sde:sqlserver:lcgissql -D gisstaging -u **** -p **** Below is the register command line prompt I've tried after creating the view in SSMS with an error (Error -144, Wrong Column Type, SE_table_get_shape_type failed) --- I'm assuming this is due to the Esri binary shape. sdelayer -o register -l gisstaging.dbo.ParcelsSearch,Shape -e a -t geometry -i sde:sqlserver:lcgissql -s lcgissql -D gisstaging -u **** -p **** Any ideas on how I can create a spatial view using an Esri binary feature class...? Thanks in advance!
... View more
04-28-2014
01:58 PM
|
0
|
3
|
1447
|
|
IDEA
|
I believe there should be a way of auto-calculating geometry attributes for a feature class. Kind of like editor tracking fields in that they are system maintained and defined by the user. For example, if I have fields meant to store Longitude and Latitude, a tab would be available to select which field I wanted to store the longitude value and which field I wanted to store the latitude value. These fields would then be system maintained and I wouldn't have to worry about calculating geometry. A similar option could be available for polygon features...different types of areas: acres, square feet, square meters, hectares, etc, etc...
... View more
04-17-2014
12:56 PM
|
23
|
8
|
5583
|
|
IDEA
|
-->
I think there should be a way to import a domain from another geodatabase rather than having to export the domain to a table and then import that table to a domain. One step, instead of two should be required for this.
... View more
04-15-2014
01:19 PM
|
48
|
12
|
14297
|