Latest Contributions by TomGiles

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

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

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

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

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

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

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

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

Thanks Mathew - I knew it was too easy. ... View more

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

Just checking as you say you have two servers - IIS settings were applied to both? ... View more

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

Check your projection. ... View more

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