Need Help Using list items as output table names in MsACCESS

Path	csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<nambo4jb@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.045
X-Spam-Evidence	'H': 0.91; 'S': 0.00; 'correspond': 0.09; 'python': 0.11; 'print': 0.15; 'better:': 0.16; 'folks,': 0.16; 'subject:Help': 0.16; 'advance': 0.17; 'output': 0.18; 'received:209.85.210.174': 0.20; 'received:mail- iy0-f174.google.com': 0.20; 'import': 0.24; 'input': 0.24; 'message-id:@mail.gmail.com': 0.27; 'becomes': 0.27; 'subject:list': 0.28; 'received:209.85': 0.32; 'received:209.85.210': 0.32; 'skip:" 20': 0.32; 'received:google.com': 0.32; 'received:209': 0.35; 'sql': 0.35; 'list': 0.37; 'skip:" 10': 0.38; 'skip:a 20': 0.39; 'to:addr :python-list': 0.39; 'to:addr:python.org': 0.40; 'your': 0.60; 'such': 0.61; 'dear': 0.63; 'python-': 0.84; 'subject:Using': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=cRzXT0s7cQGU3KUQlc95oJlC9Debsvyx61kCe1csCSA=; b=pDdCELskGpk9BkLhlp2oALs7+ltSQx45+7EB1IGWecH8Sqv5Gf59aXMNpEbBgXpTsS f+GBS7+YayPvL11P45AlQFZSqG/1jFxW+vt8nbL+5V+jHCUsUjc30Sc1lJdo8cv9lrMo jdBY5ccI6RrT0A/NwKTC/BX59LzfVfTjrGW9afqkiwHBomjkqZ4JEoIlxz8tG/0abnzH jTjbXjnHAF4oRaX7atGHaLzBSmPCKWQ7b+JlQW/RajBKUerv7YFRptlDVUIrKx3A3Ekp C0PgqNMtyiDBZ0/9uEg8A3wSPXxXYI2OD7VSdKAHXJUafHj0GMhgy9x1GAALCF+cl/FC 4dqA==
MIME-Version	1.0
Date	Wed, 28 Mar 2012 16:48:35 -0500
Subject	Need Help Using list items as output table names in MsACCESS
From	Cathy James <nambo4jb@gmail.com>
To	python-list@python.org
Content-Type	text/plain; charset=ISO-8859-1
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.1099.1332971318.3037.python-list@python.org> (permalink)
Lines	27
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1332971318 news.xs4all.nl 6891 [2001:888:2000:d::a6]:43022
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:22316

Show key headers only | View raw

Dear Python folks,
I need your help on using list items as output table names in
MsACCESS-new to Python- simple would be better:

import arcpy, os
outSpace = "c:\\data\\Info_Database.mdb\\"
arcpy.overwriteOutput = True
SQL = "Database Connections\\SDE_ReadOnly.sde\\"

inFcList = [(SDE + "sde.GIS.Parcel"),
            (SDE + "sde.GIS.Residence"),
            (SDE + "sde.GIS.Park"),
            (SDE + "sde.GIS.Field"),
            (SDE + "sde.GIS.Business"),
            (SDE + "sde.GIS.Facility"),
            (SDE + "sde.GIS.Tertiary"),
            (SDE + "sde.GIS.KiddieClub")]

#I'd like to crete output tables in the MDB whose names correspond to
input names such that
#"sde.GIS.Parcel" becomes "sde.GIS.Parcel_Buffer_500"
for fc in inFcList:
    arcpy.overwriteOutput = True
    arcpy.Buffer_analysis(fc,(outSpace+fc+"_Buffer_500"), "500 Feet",
"FULL", "ROUND", "ALL", "")
    print Finished
#Thanks in advance

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Need Help Using list items as output table names in MsACCESS Cathy James <nambo4jb@gmail.com> - 2012-03-28 16:48 -0500

csiph-web