POST
|
Thanks for your help walking me through this. A little embarrassing, I rewrote the stub and it is working fine. This script isn't on git so unfortunately I cannot back track. It's curious I found the original post here, I now wonder what I/we were doing; it must have been a typo. Note, it wasn't a procedure but good call on that behaviour. Very simple, as the sample goes.. import arcpy
print "Connecting to SQL Server.."
sqlConn = arcpy.ArcSDESQLExecute(r"\\gismsa\...\sde@iSphereBuoys.sde")
table_name = 'iSphereBuoys'
field_name = 'hashId'
sql = '''
SELECT {0} FROM {1} WHERE {0}='943906c71d6c93c7a2515b33d7a5be65'
'''.format(field_name, table_name)
sqlReturn = sqlConn.execute(sql)
print sqlReturn
#or
for i in sqlReturn:
print i
... View more
11-04-2016
07:14 AM
|
0
|
0
|
1150
|
POST
|
It is an unversioned feature class. I am using direct connect. The where statement does execute against a text field of Hash IDs. Note: I have gotten around this by dropping Arcpy and using pymssql - it works and the overhead is pretty small. I would still be interested in hearing why I am being returned True (which is supposed to be returned in cases where no records are returned)
... View more
11-03-2016
12:23 PM
|
0
|
1
|
1150
|
POST
|
I also have this problem. I am executing a simply "SELECT column FROM table WHERE column='something'" and I am being returned True, even though the correct response is 2 rows of data. Anyone?
... View more
11-03-2016
11:16 AM
|
0
|
3
|
1150
|
POST
|
Still working on this.. Recent development - the tooltip on my GpsPositionWatcher showed it as being from System.Device.Location.GeoCoordinate, not gpsLayer.GeoCoordinate This reference is from the ArcGIS API for WPF (not runtime api) "By default the position watcher used is Windows Phone's built-in System.Device.Location.GeoCoordinateWatcher. Overriding this makes it possible to assign a simulator instead." Do I need to override the default GeoCoordinateWatcher to gain access to all the gpsLayer properties? (The true GPS seems to be working, it's accurate within a couple meters.) Thanks Tom
... View more
07-30-2013
08:43 AM
|
0
|
0
|
522
|
POST
|
To further my last post, this is the code I am using to create the gpsLayer, and code for Position_Changed, where I try and access the properties I mentioned (those which I seem unable to access). Am I going about this the wrong way?
Public Class GpsTool
Private gpsLayer As GpsLayer
Private _locationWatcher As IGeoPositionWatcher(Of Geocoordinate)
Private _isStarted As Boolean
'in sub New()
Public Sub New(map As Map)
gpsLayer = New GpsLayer()
'when button is pressed for gps-on
Private Sub gpsButtonClick...
_isStarted = True
ThreadPool.QueueUserWorkItem(DirectCast(Sub() CreateGpsWatcher(ESRI.ArcGIS.Client.Local.Gps.SerialPortGpsCoordinateWatcher.FindEnabledPort(1)), WaitCallback))
Private Sub CreateGpsWatcher(serialPorts as List(Of String))
'dispatcher code
'if device found
_locationWatcher = New ESRI.ArcGIS.Client.Local.Gps.SerialPortGpsCoordinateWatcher() With {
.portName = serialPorts(0) _
}
'geometry service for projections
gpsLayer.GeoPositionWatcher = _locationWatcher
gpsLayer.GeoPositionWatcher.Start()
AddHandler gpsLayer.PositionChanged, AddressOf gpsPosition_Changed
'Then in gpsPosition_Changed - this is where I am accessing the properties of the gpsLayer, such as:
Private Sub gpsPosition_Changed(sender As Object, args As EventArgs)
Console.WriteLine(gpsLayer.GeoCoordinate.Altitude.ToString)
It is in that last function that I do not see the properties that you guys have used in the sample app, through XAML. Thanks again for any light people can shed on this. Cheers Tom
... View more
07-15-2013
08:25 AM
|
0
|
0
|
522
|
POST
|
Hi, I just solved it, a rather silly mistake. I was simply accessing the position too early; once accessed through the Position_Changed event I can access it. I do have a follow-up question for you Mike: When accessing the GeoPositionWatcher I see some of the methods, eg: Console.WriteLine(gpsLayer.GeoPositionWatcher.Position.Location.HorizontalAccuracy.ToString) but not all as seen in the Advanced GPS Information sample, eg: <TextBlock Text="{Binding Position.Location.FixStatus <TextBlock Text="{Binding Position.Location.FixSatelliteCount <TextBlock Text="{Binding Position.Location.CourseMagnetic <TextBlock Text="{Binding Position.Location.GeoidHeight I realize you bind to those properties in XAML. I can only access Altitude, Course, Speed, Lat, Long and the horiz and vert accuracies. I am looking for FixSatelliteCount. Can I access them code side, from the Position_Changed function? Thanks, Tom
... View more
07-12-2013
10:53 AM
|
0
|
0
|
522
|
POST
|
Hi Johan, I am having the same problem, and have run into a wall. Did you ever find a solution to this? Cheers Tom
... View more
07-08-2013
11:27 AM
|
0
|
0
|
522
|
POST
|
Richard and Jose, Sounds like you may be missing the reference to ESRI.ArcGIS.Framework. In VS in Solutions Explorer, double click My project and goto the References tab. Do you see the Framework reference loaded? The DockableWindowManager is part of ESRI.ArcGIS.Framework.IDockableWindowManager. dubravko - Great, simple post. +1 jakc - I believe you need a button to launch it (at least that is the solution I have read about on multiple forums).
... View more
05-24-2012
09:22 AM
|
0
|
0
|
379
|
POST
|
My issue is trying to retrieve field values inside a for loop:
#userFile - type FeatureLayer
userFile = arcpy.GetParameterAsText(0)
#user selects field from userFile - type Field "obtained from [userFile]"
userField = arcpy.GetParameterAsText(1)
#start cursor
rows = = arcpy.SearchCursor(userFile)
#inside loop, report all values of field [userField]
for row in rows:
arcpy.AddMessage("Analyzing zone " + row.userField)
Python wants userField to be a hard coded value for the field. It won't accept it as a variable set by the user. Any way I can accomplish this? Cheers Tom
... View more
03-15-2012
01:45 PM
|
0
|
3
|
688
|
POST
|
hammadem brings up an excellent point - We cannot connect to the gdb through Arc Catalogue to upgrade as the sde service is not running. Our issue is not with an out of date gdb, rather that the sde service itself won't even start. Ken or other would you be able to speak to this? Cheers Tom
... View more
02-02-2012
07:51 AM
|
0
|
0
|
428
|
POST
|
Just checking as you say you have two servers - IIS settings were applied to both?
... View more
01-23-2012
02:04 PM
|
0
|
0
|
620
|
POST
|
Hi Aaron, I'm currently gathering information about how to use WFS in a Flex application. I saw the API for Flex does not seem to support it yet, and I was wondering if someone had done a custom WFSLayer component built on top of ESRI's FeatureLayer, or something similar that would allow a Flex application to easily make WFS requests on a MapServer offering WFS services. Yours seems to be an independent component. Can you use such a component to achieve everything the FeatureLayer would? For instance could I achieve the same things as the FeatureLayer samples? http://help.arcgis.com/en/webapi/flex/samples/index.html If so yes I find this very interesting, I would love to see a working version or short example of an application on how you use it. Hopefully ESRI will release a WFS component to make this as easy as their WMSLayer one, but until then I'm looking for alternatives. Hi Yohan, I would be interested in hearing any progress you've made so far, as I am attempting a very similar solution. If it interests you please let me know at tagiles@gmail.com Cheers, Tom
... View more
08-10-2011
10:46 AM
|
0
|
0
|
727
|
POST
|
Hi all, Was hoping someone could help me out. This all works for me, except that the pages don't change - it keeps exporting the same page over and over again. Any ideas? I would think "mxd.dataDrivenPages.currentPageID = pageNum" would change the page (ie feature driving the page), so each successive "routeNum = mxd.dataDrivenPages.pageRow.routeID" would get the value for routeNum from the new feature driving the datadrivenpages (the next 'page'). Cheers, Tom
... View more
04-20-2011
09:44 AM
|
0
|
0
|
888
|
Online Status |
Offline
|
Date Last Visited |
11-28-2023
07:57 PM
|