|
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
|
2818
|
|
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
|
2818
|
|
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
|
4704
|
|
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
|
861
|
|
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
|
1386
|
|
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
|
5307
|
|
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
|
11
|
13585
|