498 reputation
214
bio website
location England
age 24
visits member for 1 year, 8 months
seen yesterday

2d
accepted Keep column titles when exporting SQL query in MapInfo
2d
asked Keep column titles when exporting SQL query in MapInfo
Apr
10
comment New line in MapInfo SQL Select
Using something other than MapInfo to perform these SQL queries would probably be much more efficient but I had to find a way that involved the current skills I have, I think asking for some SQL training from my employer next is a must
Apr
10
comment New line in MapInfo SQL Select
I am trying to build a massive query to return the average of a column between certain values. I have now realised I have WAY too many queries to run (~29,000) so I have cheated a little and populated a csv with the query as each line: i.imgur.com/8RhjvT5.png then using MapBasic I have it run the query for each row in the table and append the results to a new table: i.imgur.com/e6JKtTW.png
Apr
10
comment New line in MapInfo SQL Select
Hi Pete, I'm not sure if I explained this properly but where the gap is I want it to be a 'new' query, aka so each query would be returned as a new line in the selection table
Apr
9
asked New line in MapInfo SQL Select
Apr
8
accepted MakeXYEventLayer_management not creating final file?
Apr
4
comment MakeXYEventLayer_management not creating final file?
arcpy.FeatureClassToFeatureClass_conversion worked, thank you!
Apr
4
comment MakeXYEventLayer_management not creating final file?
I'm running the script from the toolbox, the aim is to generate X and Y coordinates for line start and end (done) then create points from these coordinates. Thanks Martin, I'll give it a go
Apr
4
comment MakeXYEventLayer_management not creating final file?
Martin: how do I export my event layer?
Apr
4
comment MakeXYEventLayer_management not creating final file?
It's an open layer selected by the user: # Routed SCRIM network RtNET = arcpy.GetParameterAsText(0)
Apr
4
asked MakeXYEventLayer_management not creating final file?
Apr
4
comment CalculateField_management - updating fields with X and Y coordinates for start and end of line
Thanks, this is only my second day using python so I'm not too good yet!
Apr
4
accepted CalculateField_management - updating fields with X and Y coordinates for start and end of line
Apr
4
comment CalculateField_management - updating fields with X and Y coordinates for start and end of line
It is routed, is this the problem, should I just run the same code on the un-routed layer? Although Add Geometry did work
Apr
4
comment CalculateField_management - updating fields with X and Y coordinates for start and end of line
I've tried arcpy.CalculateField_management(RtNET,"SX","!SHAPE!.firstpoint.X", "PYTHON_9_3") but I still get the message: RtNET,"SX","!SHAPE!.firstpoint.X", "PYTHON_9_3") File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 3354, in CalculateField raise e ExecuteError: Failed to execute. Parameters are not valid.
Apr
4
comment Unable to copy text out of MapInfo 12 info tool
I think it is a common issue in MapInfo, try waiting a few seconds after selecting an item with the info tool and try again
Apr
4
asked CalculateField_management - updating fields with X and Y coordinates for start and end of line
Apr
4
accepted Python in ArcGIS, CalculateField_management, updating with single value
Apr
3
comment Python in ArcGIS, CalculateField_management, updating with single value
Thanks, I was thinking into it to much by doing =1 or "!FRMEAS! = 1"