POST
|
I found a way around previous issue by writing a VBScript that converts the DBF file into an XLSX file. I can then read the document and import it into SQL Server. However, now I am having an issue with Python. I have a model that Geocodes addresses and then does an intersect. The model works perfectly within ModelBuilder. I then chose Model > Export > To Python Script and saved the script. I then opened the script with IDLE and ran it. I get: Traceback (most recent call last): File "C:\RunningJobs\NewGeocode.py", line 22, in <module> arcpy.GeocodeAddresses_geocoding(dbo_CDM_ARCCHANCERY, NewAASD_Streets, "Street 'Full Address' VISIBLE NONE;ZIP ZIP VISIBLE NONE", output_featureclass_shp, "STATIC") File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\geocoding.py", line 187, in GeocodeAddresses raise e ExecuteError: ERROR 000010: Geocode addresses failed. Failed to execute (GeocodeAddresses). Not sure why it works in ModelBuilder but not in Python. Any insight? Thanks, Dan
... View more
01-16-2013
06:36 AM
|
0
|
0
|
214
|
POST
|
OK, now I am working on my model. I'm using: 1. Geocode addresses to connect to a SQL Server table and geocode against a locator file. 2. Intersect to combine the results of #1 with three boundary files. 3. Table to Table to output the results of #2 to SQL Server Express which is installed on the GIS Server. Question is related to #3. The OLE DB connection to SQL appears to be read only. How can I create a connection to SQL Server Express that can be written to? Is there a way to create an ADO connection? Thanks, Dan
... View more
01-14-2013
10:54 AM
|
0
|
0
|
990
|
POST
|
I will try doing that however, we used the interface initially. It worked once and failed when we tried to run it again as a job.
... View more
01-10-2013
09:17 AM
|
0
|
0
|
990
|
POST
|
I removed the .shp from the GeocodeAddresses3 variable and got the below error: dbo_GeocodeAddresses3 = r"\\MyDrive\ArcGIS\Default.gdb\dbo_GeocodeAddresses3" Line 39 Failed to execute. Parameters are not valid. ERROR 000732: Input Features: Dataset \\MyDrive\ArcGIS\Default.gdb\dbo_GeocodeAddresses3 #;'\\MyDrive\Transportation\ArcGIS ver 10\Boundaries\elembound.shp' #;'\\MyDrive\Transportation\ArcGIS ver 10\Boundaries\highbound.shp' #;'\\MyDrive\Transportation\ArcGIS ver 10\Boundaries\middlebound.shp' # does not exist or is not supported Failed to execute (Intersect). How should I be handling the output from the GeocodeAddresses process?
... View more
01-10-2013
05:16 AM
|
0
|
0
|
990
|
POST
|
Thank you for the reply. I tried setting the value of the output to 'output_featureclass' and I got the same error. ERROR 000210: Cannot create output \\MyDrive\ArcGIS\Default.gdb\output_featureclass.shp.shp ERROR 000354: The name contains invalid characters Failed to execute (Intersect). Here is the full code: # Import arcpy module
import arcpy
from arcpy import env
try:
env.workspace = "\\\\MyDrive\\ArcGIS\\Default.gdb"
if arcpy.Exists(dbo_View1):
arcpy.Delete_management(dbo_View1)
if arcpy.Exists(dbo_GeocodeAddresses3):
arcpy.Delete_management(dbo_GeocodeAddresses3)
# Local variables:
dbo_CDM_ARCCHANCERY = "Database Connections\\Chancery.odc\\dbo.CDM_ARCCHANCERY"
NewAASD_Streets = "\\\\MyDrive\Transportation\\ArcGIS ver 10\\Locators\\NewAASD_Streets"
elembound_shp = "\\\\MyDrive\Transportation\\ArcGIS ver 10\\Boundaries\\elembound.shp"
highbound_shp = "\\\\MyDrive\Transportation\\ArcGIS ver 10\\Boundaries\\highbound.shp"
middlebound_shp = "\\\\MyDrive\Transportation\\ArcGIS ver 10\\Boundaries\\middlebound.shp"
arc__VERSION_dbo_DEFAULT_ = "Database Servers\\MyServer_ARC.gds\\arc (VERSION:dbo.DEFAULT)"
dbo_View1 = "dbo_View1"
dbo_GeocodeAddresses3 = "\\\\MyDrive\\ArcGIS\\Default.gdb\\dbo_GeocodeAddresses3.shp"
dbo_GeocodeAddresses3_Inters = 'output_featureclass'
# Process: Make Table View
arcpy.MakeTableView_management(dbo_CDM_ARCCHANCERY, dbo_View1, "", "", "Id Id VISIBLE NONE;StudentId StudentId VISIBLE NONE;'Last Name' 'Last Name' VISIBLE NONE;'First Name' 'First Name' VISIBLE NONE;'Middle Name' 'Middle Name' VISIBLE NONE;School School VISIBLE NONE;'School #' 'School #' VISIBLE NONE;'Street Number' 'Street Number' VISIBLE NONE;'Street Direction' 'Street Direction' VISIBLE NONE;Street Street VISIBLE NONE;'Street Type' 'Street Type' VISIBLE NONE;Apt Apt VISIBLE NONE;City City VISIBLE NONE;State State VISIBLE NONE;ZIP ZIP VISIBLE NONE;'Full Address' 'Full Address' VISIBLE NONE;DOB DOB VISIBLE NONE;Gender Gender VISIBLE NONE;Grade Grade VISIBLE NONE;Ethnicity Ethnicity VISIBLE NONE;LunchStatus LunchStatus VISIBLE NONE;PrivateSchool PrivateSchool VISIBLE NONE")
# Process: Geocode Addresses
arcpy.GeocodeAddresses_geocoding(dbo_View1, NewAASD_Streets, "Street 'Full Address' VISIBLE NONE;ZIP ZIP VISIBLE NONE", dbo_GeocodeAddresses3, "STATIC")
# Process: Intersect
arcpy.Intersect_analysis([dbo_GeocodeAddresses3, elembound_shp, highbound_shp, middlebound_shp], dbo_GeocodeAddresses3_Inters, "ALL", "", "INPUT")
# Process: Table to Table
arcpy.TableToTable_conversion(#Removed because of length#)
# Cleanup temporary tables
if arcpy.Exists(dbo_View1):
arcpy.Delete_management(dbo_View1)
if arcpy.Exists(dbo_GeocodeAddresses3):
arcpy.Delete_management(dbo_GeocodeAddresses3)
except Exception, e:
#If an error occurred, print line number and error message
import traceback, sys
tb = sys.exc_info()[2]
print "Line %i" % tb.tb_lineno
print e.message
... View more
01-10-2013
04:10 AM
|
0
|
0
|
990
|
POST
|
We are using ArcGIS 10 SP 4 What should the value of the output variable be? I've tried to assign it a .shp file or to simply give it a name and let the compiler figure it out. Neither have worked. My understanding is that when the intersect is complete, the result set is saved to a file and I am defining what to call it so that I can use it later. Is that correct?
... View more
01-09-2013
11:57 AM
|
0
|
0
|
990
|
POST
|
Hello, I have a script that is to geocode addresses from a database, intersect the results with three boundary files and do a tabletotable conversion on the results. Below is the intersect statement I am using.
arcpy.Intersect_analysis([geocode_results, boundary1_shp, boundary2_shp, boundary3_shp], qResults, "ALL", "", "INPUT")
The statement is failing on qResults (e.g. creating the output of the intersect). It seams that no matter what I put there (file path or variable name), the compiler is appending ".shp.shp" to the file name which causes an invalid file error. ERROR 000210: Cannot create output \\mydrive\ArcGIS\Default.gdb\qResults.shp.shp ERROR 000354: The name contains invalid characters Failed to execute (Intersect). Any help, would be greatly appreciated. Thanks, Dan
... View more
01-09-2013
09:21 AM
|
0
|
12
|
2988
|
POST
|
I highly recommend doing this using Python instead. The old GPDispatch interface is poorly supported if at all.
import arcpy
arcpy.TableSelect_analysis(\
"Database Connections\\Chancery.odc\\dbo.CDM_ARCCHANCERY2",
"C:\\ArcProcessing\\IMP_ARC_CHANCERY.dbf", "Id > 0") But, you should perhaps try simply running the Table Select tool interactively first to make sure the database connection is set up correctly. Curtis, Thank you for the tip. For me it doesn't matter if it is Python or VBScript. We are more comfortable with VB but we can adapt. From what I can gather, the script needs four parts. Here is what I have in my model so far. 1. Table Select to import data from our SQL Server Database into ArcGIS 2. Geocode Addresses (connecting the table select and our locator file) 3. Intersect (connecting the Geocode results to three boundary files (shape files) * I'm not sure if I need three separate Intersects or if I can have one intersect with three shape files. 4. I need to import the results back to SQL Server so that I can run analysis and reports. I haven't found a tool that will do this for me. Do I need to create a custom tool to do this? If so, I'd appreciate some tips to do so. Thanks again, Dan
... View more
08-15-2012
05:43 AM
|
0
|
0
|
252
|
POST
|
Hello, I'm new to ArcGIS. I have a vbscript that was written for 9.3 that I need to convert to run on 10.1. I keep getting an unspecified error on the second statement. I think the problem is with the dbf file but I'm not sure how to resolve the issue. set gp = CreateObject("esriGeoprocessing.GPDispatch.1")
gp.TableSelect_analysis "Database Connections\\Chancery.odc\\dbo.CDM_ARCCHANCERY2", "C:\\ArcProcessing\\IMP_ARC_CHANCERY.dbf", "Id > 0" Any help would be greatly appreciated. Thanks, Dan
... View more
08-14-2012
12:53 PM
|
0
|
2
|
524
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|