|
POST
|
All, I have attempted to create a SQLite database from the Python console within ArcMap 10.3 and have been following the simple instructions discussed in CreateSQLiteDatabase—Help | ArcGIS for Desktop. A poster in 2014 describes the same problem but it is clear they never got a solution: dir function does not show CreateSQLiteDatabase too When I type "arcpy.gp." it never offers up CreateSQLiteDatabase(). I am using Windows 7, 64bit version. I have run a repair on ArcMap from the Programs and Features part of the Control panel thinking I may have had a corrupted installation but this has not resolved it. My version of ArcMap was an upgrade from 10.2 to 10.3. Is there some other hidden (and undocumented) step I need to do to make this work? Help seems to suggest that it should all be there and working. Could it be some sort of conflict with python (not sure I am suggesting a red herring here)? If I look in the folder C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite there appears to be a 32 and 64 bit version. If I type in the python console window within ArcMap import sys
print sys.version I get 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)] Also attempted the same thing on a colleagues computer who has 10.3 and when I type "arcpy.gp." it too never offers up CreateSQLiteDatabase(). Any advice would be appreciated! Duncan
... View more
08-10-2015
04:46 AM
|
0
|
3
|
4549
|
|
POST
|
Just compliment your answer I found this article on the microsoft KB.
... View more
08-10-2015
02:11 AM
|
1
|
0
|
4954
|
|
POST
|
I came across that error code page in my wanderings of the help pages, then lots of pages that say they do accept OLE tables. It's all conflicting, hence me looking for a definitive response from ESRI?
... View more
08-07-2015
10:54 AM
|
0
|
1
|
4954
|
|
POST
|
I've been tinkering around with ArcGIS Pro today and one thing I cannot seem to resolve is connecting to an Access 2007 (accdb) database. In ArcMap 10.3 you would create an OLE connection in ArcCatalog then you have access to the tables in the database. There seems to be no way of creating an OLE connection? Is this correct or has it been renamed to something else and I've just missed it? I've searched the online help and I come across many pages that explicitly state that OLE connections are accepted, here is just one example. Is this a scenario where the Help has just been copied 'n' pasted from ArcMap Help and ArcGIS Pro does not actually support OLE connections? ESRI are usually pretty good at providing help documentation, put this is pretty sloppy especially for it's new flagship desktop software? This page talks only about what is supported, I would have though it was just as important to explicitly state what is not supported! So if OLE connections are not supported now, is there a plan to include them in a later release? Half the World uses MS Access, seems a bit of an odd business plan to just drop support for them?
... View more
08-07-2015
09:15 AM
|
0
|
13
|
11726
|
|
POST
|
I've had a look at your model. One thing that would have improved performance is to ensure all your datasets have spatial indices but as all your data were file geodatabase feature classes you are already doing this. Nothing particularly leaped out at me as performance blocking steps which leads me to ask about your data. You do not actually say anything about it? Is it millions of polygons or just a few thousand that are horribly multi-part? In a part of your model you are selecting and sorting then sub-selecting multiple times, if you are doing this on a table with 10,000,000 rows then the time taken is not surprising. Whilst Neil Ayres is a good route to go for improving performance you'll be taking your work out of the model builder environment which is something you may not want to do? You need to give more information about your data and it's context.
... View more
08-05-2015
02:40 AM
|
2
|
1
|
2763
|
|
POST
|
I've just tested the Collect Events tool and it worked OK for me on 10.3. The error message is saying it's missing the module sysconfig. Do you have a standard install of ArcGIS or is it something that your IT department have dished out? I would start looking there.
... View more
08-05-2015
02:20 AM
|
0
|
2
|
1738
|
|
POST
|
Susanne, The reason you are only seeing 2 layers reported is because the sequence is incorrect your code should be: Dim pEnumLayer As IEnumLayer = pMap.Layers(Nothing, True)
pEnumLayer.Reset()
Dim pLayer As ILayer = pEnumLayer.Next()
Dim sb As System.Text.StringBuilder = New System.Text.StringBuilder()
While Not pLayer Is Nothing
sb.Append(pLayer.Name)
pLayer = pEnumLayer.Next()
End While
MsgBox(sb.ToString()) To understand this you have created an enumerate and get the first layer, as this not nothing it enters the While loop. It appends the name and then gets the next layer. Your original code had the get next layer code before you ever added it to stringbuilder so this is why it skipped a layer name.
... View more
08-04-2015
02:15 AM
|
2
|
1
|
1673
|
|
POST
|
Susanne, When you post code you should use the syntax highlighter in the Advance Editor option then >> button. This will make reading your code easier for others and improve your chances of getting an answer. You can go back and edit your question any time. That being said looking at your code on each iteration of the While loop you append then print sb, so what is not working?
... View more
08-03-2015
02:34 AM
|
0
|
3
|
1673
|
|
POST
|
Marwa, Could you please edit your question and apply the language syntax to make reading your code easier for others? Go to the Advance Editor option then >> to go to the syntax highlighter. Your code looks identical to the sample code so this would suggest to me that the data is at fault? You do not describe your data, is it some monster multi-part dataset, that could be a cause? I suggest you try union the data with the standard Union tool to see if that works?
... View more
08-03-2015
02:13 AM
|
0
|
2
|
1540
|
|
POST
|
Is this what you want? To call a geoprocessing tool and see its interface? This code is in VBA. Public Sub OpenCalculateTool()
' Hook into Toolbox and get the tool
Dim pUID As New UID
pUID = "esriGeoprocessingUI.ArcToolboxExtension"
Dim pArcToolboxExtension As IArcToolboxExtension
Set pArcToolboxExtension = Application.FindExtensionByCLSID(pUID)
Dim pArcToolbox As IArcToolbox
Set pArcToolbox = pArcToolboxExtension.ArcToolbox
Dim pGPTool As IGPTool
Set pGPTool = pArcToolbox.GetToolbyNameString("CalculateField")
' Create messages, required by Invoke method
Dim msgs As IGPMessages
Set msgs = New GPMessages
' Get existing parameter structure
Dim pArray As IArray
Set pArray = pGPTool.ParameterInfo
' Declare Parameter interfaces
Dim pGPParameter As IGPParameter
Dim pGPDataType As IGPDataType
Dim pGPParameterEdit As IGPParameterEdit
' Set the parameters of the tool
Set pGPParameter = pArray.Element(0)
Set pGPParameterEdit = pGPParameter
Set pGPDataType = pGPParameter.DataType
Set pGPParameterEdit.Value = pGPDataType.CreateValue("a") ' Featurelayer name
Set pGPParameter = pArray.Element(1)
Set pGPParameterEdit = pGPParameter
Set pGPDataType = pGPParameter.DataType
Set pGPParameterEdit.Value = pGPDataType.CreateValue("xx") ' Field
Set pGPParameter = pArray.Element(3)
Set pGPParameterEdit = pGPParameter
Set pGPDataType = pGPParameter.DataType
Set pGPParameterEdit.Value = pGPDataType.CreateValue("VB")
' Open the tool
Dim pGPToolCommandHelper As IGPToolCommandHelper2
Set pGPToolCommandHelper = New GPToolCommandHelper
pGPToolCommandHelper.SetTool pGPTool
pGPToolCommandHelper.InvokeModal 0, pArray, True, msgs
End Sub
... View more
07-29-2015
07:20 AM
|
0
|
3
|
2434
|
|
POST
|
No one will be able to answer this as your "data eksport tool" is a custom tool. You need to be asking the person who developed that to find out why your model is failing.
... View more
07-28-2015
02:49 AM
|
0
|
0
|
642
|
|
POST
|
Joshua, Looking at the code nothing leaps out at me. The only thing I can think of is you are creating your graphic polygon via the RubberBand class. I did not do that I created the graphics then ran the code. Can you have an MXD with a drawn graphic on the map (so you are not using the RubberBand) to see if the code works for you. If that does then it suggests something is not happening when you create the graphic via the RubberBand method? Duncan
... View more
07-22-2015
02:10 AM
|
0
|
0
|
3915
|
|
POST
|
Joshua, I wonder if the technique I pointed to expects your graphics to be simple fills? Below are two polygons one a simple blue fill the other a picture file. I run the code as described in that link and I get below; so it works well with simple fill but not great with the picture fill. The code was: Public Sub MakeTransparent()
' Get map document
Dim pMXDoc As IMxDocument
Set pMXDoc = ThisDocument
' Get Map
Dim pMap As IMap
Set pMap = pMXDoc.FocusMap
' Get Graphics Container for map
Dim pGC As IGraphicsContainer
Set pGC = pMap
pGC.Reset
' Get first graphic, assumed to be polygon
Dim pElement As IElement
Set pElement = pGC.Next
Dim rgb As IRgbColor
Set rgb = New RgbColor
rgb.Red = 255
Do While Not pElement Is Nothing
' Get symbol of graphic and its colour
Dim pFillShapeElement As IFillShapeElement
Set pFillShapeElement = pElement
Dim pFillSymbol As IFillSymbol
Set pFillSymbol = pFillShapeElement.Symbol
Dim pColour As IColor
Set pColour = pFillSymbol.Color
Dim psym As ISymbol
Set psym = pFillSymbol
psym.ROP2 = esriROPMaskPen
pFillSymbol.Color = rgb
pFillShapeElement.Symbol = pFillSymbol
Set pElement = pGC.Next
Loop
' Refresh map
pMXDoc.ActiveView.Refresh
End Sub
... View more
07-20-2015
10:15 AM
|
1
|
2
|
3915
|
|
POST
|
Ah but did you follow the link in the final comment...
... View more
07-20-2015
08:42 AM
|
0
|
4
|
3915
|
|
POST
|
Sounds just like the sort of thing that can be automated in modelbuilder, what have you tried?
... View more
07-20-2015
08:22 AM
|
0
|
0
|
1650
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-03-2026 07:31 AM | |
| 3 | 06-29-2026 05:17 AM | |
| 1 | 02-15-2023 05:45 AM | |
| 1 | 06-16-2026 02:37 AM | |
| 1 | 06-15-2026 08:29 AM |
| Online Status |
Offline
|
| Date Last Visited |
Friday
|